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


I am looking for the Kessler 6 variable in IPUMS-MEPS
Reason for missing MIGSTA1 values in ASEC files for 1985 (and 1995)
India Area-level data (geo2) inconsistent for total population, urban share, ...
Does anyone have a method for handling missing data in CPS "EDUC" variable? 2...
How do I find the data file:Ipumsi_00001.dat for the 1974
Variables from Full Year Consolidated Files currently not included in IPUMS-M...
Login   |   Register

Recently Active Members

View More »

Share |