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


Hi, it has been over 4 hours for my data extract and I was wondering if there...
When I take several Nov Supplements, the weighted number of voters equals pub...
Are there aggregate categories for OCC/OCCLY in CPS?
Do you have any idea when STEPMOM and STEPDAD will be available for usage? Th...
Comparing 2015 ASEC CPS IPUMS with Census data and Table Creator, I note diff...
I notice a large number of 'missing' or 'N/A' values for education (HIGRADE...
Login   |   Register

Recently Active Members

View More »

Share |