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

missing tracts.csv (59.7 KB)



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.



Sure thing; thanks for your prompt reply. Here’s the table:

| B14002. Sex by School Enrollment by Level of School by Type of School for the Population 3 Years and Over |



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.