Skip to main content
20 votes

Joining polygons in R

Here is a solution using the sf package: library(tidycensus) library(dplyr) library(sf) library(ggplot2) # get data from tindycensus for demonstration (note you need an API key, folow instructions ...
sebdalgarno's user avatar
  • 1,733
17 votes
Accepted

Why is there no state with code "03" (among other missing numbers)?

These are Federal Information Processing Standard (FIPS) state codes, and the ones you mention are missing because, from the wiki: "certain numeric codes "are reserved for possible future use in ...
Kartograaf's user avatar
  • 2,947
13 votes

Seeking shapefile of city boundaries in US?

Getting the Data You can acquire US Census Place Data, which includes cities, here. For instance, Rhode Island's 2017 Place Data is available here. For ease of bulk downloading, the full list 2017 ...
Richard's user avatar
  • 1,831
7 votes
Accepted

List of Most Populated US Census Designated Places

These data are available from the 2010 Census or the 2014-2018 American Community Survey (ACS) 5-year estimates. (1 year data are only for places with 60,000 population or more, so you need to use the ...
JamiRae's user avatar
  • 372
5 votes

QGIS's "Points in Polygon" counts zero in every census tract

Save both files as the same CRS. Load each of the files and then run points in polygon with the newly loaded files. The project on the fly is a visual aid. When running analysis it will use the CRS of ...
dustinturp's user avatar
5 votes
Accepted

ogr2ogr encoding on Windows using os4geo shell with Census data

There is. If on windows simply run: set PGCLIENTENCODING=LATIN1 In the command line before running your ogr2ogr command. If your on Linux, you need to run: export PGCLIENTENCODING=LATIN1;
HeikkiVesanto's user avatar
5 votes
Accepted

CRS for US Census 1999 ShapeFile

US census data is almost always in NAD 1983 (EPSG:4269). You'll see the same distortion with 4269. Both 4269 and 4326 are geographic coordinate reference systems. They are probably displayed using ...
mkennedy's user avatar
  • 19k
5 votes

Migrating US Census GDB file to PostGIS -- ERROR: tables can have at most 1600 columns

I would definitely re-think how you store your Census data in PostGIS. The ArcGIS-ready tables are unnecessarily massive, as you're finding out. We store our census tables separately with geometry ...
Inactivated Account's user avatar
4 votes
Accepted

Joining attributes in 100s SHPs back to main SHP file batch in QGIS

I would also recommend using PostGIS as mentioned by DPSSpatial but in QGIS, you could use a bit of python to loop through all your layers and perform a joins operation. It uses a common field to ...
Joseph's user avatar
  • 76k
4 votes
Accepted

Understanding U.S. Census MSA to place relationships?

According to the U.S. Census, "Counties or equivalent entities form the geographic 'building blocks' for metropolitan and micropolitan statistical areas throughout the United States and Puerto Rico." ...
syre's user avatar
  • 407
4 votes
Accepted

Working around US Census site blocking of IP addresses?

To simplify the download on multiple machines, you can use more advanced downloading tool (such as aria2c) that supports resume etc., and have a script continuously download the dataset from a file of ...
laser's user avatar
  • 966
4 votes
Accepted

How retrieve blocks for Guam?

Go to that website. Press Ctrl+a Press Ctrl+c Open a text editor (notepad++ should work) Press Ctrl+v Remove the header line (until MTFCC) Save as any_filename.csv You will have a tab-separated (C)SV ...
pLumo's user avatar
  • 6,519
4 votes

What part of the Census Block is the County?

Your example is missing one character (it is 15 in total). In California it should be 060070004024003 (starting with 06; see here). The first and second digits identify the state. The third, fourth ...
Andre Silva's user avatar
  • 10.3k
4 votes
Accepted

Advice on normalizing census data in choropleth maps

I think the first approach (divide the total population with hearing loss within a state by the state's total population) is the best way to go. Here is my take on the different ways one could ...
Nick's user avatar
  • 1,613
3 votes
Accepted

Trouble getting area of census block with OGR

Bringing the comments together... srcSR = osr.SpatialReference() srcSR.ImportFromEPSG(4326) # WGS84 Geographic destSR = osr.SpatialReference() lyr.ResetReading() for feat in lyr: geom = feat....
Michael Stimson's user avatar
3 votes
Accepted

Extract tract shapefile from 2006 US Census

Good question. So lets review, The TIGER/Line files are typically used in conjunction with geographic information system (GIS), or similar, software. The U.S. Census Bureau provides the TIGER/...
Evan Carroll's user avatar
  • 7,091
3 votes
Accepted

How to obtain Census block data in SQL format?

You can install PostgreSQL (opensource) and the PostGIS and TIGER extensions to load the TIGER data. This post has a lot of good info that I used to load the census data. Then you can run SQL ...
kttii's user avatar
  • 3,630
3 votes
Accepted

Where do I find city/town point locations in US census data?

If you are just looking for a table with city names and coordinates, I would recommend the US geographic Names file. You can download the data (Domestic and Antarctic Names - State and Topical ...
PhilippNagel's user avatar
  • 1,712
3 votes

ogr2ogr encoding on Windows using os4geo shell with Census data

Unfortunately it cannot be done with GDAL, you will have to set the PGCLIENTENCODING environment variable to LATIN1 in your operating system instead. (e.g. in windows it can be done under System--> ...
ylka's user avatar
  • 1,077
3 votes
Accepted

American FactFinder by ZIP code

You may want to look in the NHGIS Data Finder that provide: The National Historical Geographic Information System (NHGIS) provides, free of charge, aggregate census data and GIS-compatible boundary ...
whyzar's user avatar
  • 12.1k
3 votes
Accepted

How do I get revised data from the U.S. Census?

This is not a very satisfying answer, so I'd love to hear from somebody more familiar with U.S. Census data (or for that matter, somebody more experienced with bash), but the following does seem to ...
user1521655's user avatar
  • 1,319
3 votes
Accepted

Which the columns available on the TIGER geocoder

Tiger data doesn't include parcels. It just has street centerlines and census tract. For census tract that may be be turned off loading by default since I recall it taking some space. If it's not, ...
Regina Obe's user avatar
  • 10.6k
3 votes

Working around US Census site blocking of IP addresses?

I only see you mentioning http sites. Try using the Census' FTP site, ftp://ftp2.census.gov/geo/tiger/
neuhausr's user avatar
  • 2,265
3 votes

SRID for New York City 2010 Census Shapefile

It doesn't have an EPSG code. I looked it up on spatialreference.org with NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet Came up with http://spatialreference.org/ref/esri/102718/ It's ESRI:...
Evan Carroll's user avatar
  • 7,091
3 votes

Unable to perform centroids or point on surface operations because of "invalid geometry"

I had a similar issue with being unable to perform an operation due to invalid geometries. @ndawson resolved it by suggesting the following this post: How to ignore invalid geometries in performing ...
3 votes
Accepted

Migrating US Census GDB file to PostGIS -- ERROR: tables can have at most 1600 columns

I figured out a way to get the gdb files into a database. Most of the process can be automated, but I'll have to manually prepare some files. First, run the ogr2ogr command that turns the gdb file ...
alfonso's user avatar
  • 173
3 votes

Combining data with partially overlapping polygon layers? (QGIS)

QGIS Expressions: Use these four expressions to create new (virtual or not) fields in your Neighborhood Shapefile: 1940s_CT aggregate( '<CT>', 'array_agg', "<ID>", intersects( $...
geozelot's user avatar
  • 30.4k
3 votes

Finding where to close polyline using QGIS technique that resemble how US Census Geography's Inland Water is calculated

Hypothesis There is one continues line representing edge of water - both for open waters, and inland water The line has known direction, and the water is on the known side in regards of line ...
Miro's user avatar
  • 9,784
2 votes
Accepted

Seeking postcode shapefiles & census data for Netherlands

Things have changed since 2015 I guess, currently there are multiple free methods to obtain data and geometry of postal codes. It is unfortunately slightly harder to find when one cannot read Dutch. I'...
Saaru Lindestøkke's user avatar
2 votes

U.S. Census Data, Block Level, Where to Find It

Block GROUPS are the smallest level of geography the census summarizes American Community Survey data. <-- This primarily answers the question. So no you cannot get "Block" data you can get Block ...
Amber Keller's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible