Question

Status:Closed    Asked:Oct 08, 2018 - 03:40 PM

Help with 1960 census tract fips - best unique identifiers?

Greetings,


I'm trying to make sense of 1960 Census tracts.


I realize, by way of an earlier Q&A posting, that due to two different data sources and a lot of missing data, we should anticipate redunancy in the 1960 tracts. For confirmation, I created a FIPS variable using 'state + counnty + aggprefix + aggtract + aggsuffix', but there are many duplicates. Is there any documentation as to how to negotiate this when creating unique 1960 tract FIPS identifiers?


Is there a different ID that's been created and applied to 1960 census data in the decades since that has become the norm/convention for unique 1960 tract FIPS identifiers (like, GISJOIN, or the like)? If so, is there any documentation explaining this?


Any guidance/references will be greatly appreciated!


Thanks!

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

MPC_vanriper

Staff

With respect to your user forum question, it looks as if you're using the 1960 conflated census tract shapefile. You created a concatenation of state, county, prefix, tract, suffix, and you did find duplicate values. There is also a GISJOIN value on that shapefile, which doesn't have duplicate values (except for counties with NODATA tracts).

We create our conflated 1960 tract data by aligning our TIGER/Line 2000-based boundaries to TIGER/Line 2008-based boundaries. After creating the polygons, we used centroids from an older data file to assign the GISJOIN and the aggprefix, aggtract, aggsuffix values to the 2008-based boundaries. The older data file has the correct GISJOIN values, but not necessarily the correct aggprefix, aggtract, or aggsuffix values associated with it. We didn't keep the aggprefix/aggtract/aggsuffix values up to date over time; instead, we updated the GISJOIN value.

You'll want to use the GISJOIN value on the shapefile to merge with the population data - I don't recommend trying to create your own FIPS value by concatenating fields together.

 

Oct 09, 2018 - 08:28 AM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

Metarea in 1960
1960 census published volume - is there any documentation for state economic ...
Why are not all the "not in the labour force" categories filled for the EMPST...
Question about 1950, 1960, 1970 tract-level housing and population data
Login   |   Register

Recently Active Members

View More »

Share |