Status:Closed    Asked:Jun 08, 2017 - 05:52 PM

Merged 2011-2015 ACS csv data to shapefile of same wave, but 338 tracts in the shapefile aren't in the csv file.

Hi there,

I'm trying to merge some data from the 2011-2015 ACS at the tract level onto the 2011-2015 ACS tract shapefile. Both files, the shapefile and the csv data, come from NHGIS. I'm trying to use the GISJOIN variable to merge, but I'm finding that 338 of the tracts in the shapefile don't appear in the csv file. Could anyone help me figure out what to do? I've attached a sheet with the tracts in the shapefile that don't appear in the csv file. Any help would be much appreciated.


Pete Rodrigue

Do you have the same question? Follow this Question

Staff Answer




It may be that the table you are analyzing is suppressed for those tracts. The Census Bureau suppresses data for a number of reasons. Would you mind sharing which specific table you are analyzing? I can than double check to make sure that this is in fact the case.


Jun 09, 2017 - 03:20 PM

Report it



Jun 09, 2017 - 03:27 PM

Report it

I just extracted the table and I am getting data for all of the tracts listed in your attached csv file, so this is not related to suppression. There is a 338 tract difference between the CSV and the shape file, but these tracts are in the CSV table but not in the shapefile (they all represent areas with populations of zero). I would recommend starting over from the original extracted files, or even creating a brand new extract, and attempting the merge again.


Jun 09, 2017 - 04:03 PM

Report it


Why the Puerto Rico IPUM GIS shapefile codes different than that from the dat...
Match 1860-1920 census data to county subdivisions in 2010 TIGER shapefile
How do I transform the IMPUMS GEOLEV1 shapefile so that latitude runs from 0 ...
merging 2010 census tracts to 2015 5-year ACS file
Login   |   Register

Recently Active Members

View More »

Share |