Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm writing a program that needs to generate GEOID values from 2000 and 2010 Census data, to link the census data to TIGER/Line records. I'm starting with the state, county, region block, etc, values in the census GEO files, and need to create GEOIDs.

I need to work with all of the summary levels, and since the structure of the GEOID value seems to vary depending on the type of geography, it would be really nice to have a spec for constructing it.

I found this document, but it only specifies the GEOID structure for the redistricting files:

http://www.census.gov/rdo/pdf/0GEOID_Construction_for_Matching.pdf

I'd like to get the same thing, but for all summary levels.

I've considered downloading all of the tiger files and extracting the GEOID10 values and reverse engineering them from the records attached to the shape files, but the programming would cost more than just paying someone to do it manually by inspecting the files or the documentation ( http://www.census.gov/geo/www/tiger/tgrshp2010/TGRSHP10SF1.pdf )

Any other ideas how to most easily generate GEOID from census GEO files, for all records and summary levels?

Alternately, can the 0GEOID_Construction_for_Matching.pdf file, which is written for the redistricting files, be used as a spec for the 2010 SF1 summary levels and the GEOIDs of the corresponding TIGER files?

Thanks!

share|improve this question
    
So far, a year later, the best I've managed is to reverse engineer from the TIGER files. It's tedious, but not hard. – Eric Busboom May 1 '14 at 16:07

Downvote me if I'm wrong, but the GEOID is a concatenation of a bunch of fields as noted in the summary file documentation on page 13. In the geographic area codes, you'll be looking for fields at positions 26-65.

share|improve this answer
1  
This doesn't answer the question "for all summary levels." Then again, it's surprisingly hard to even find a list of "all summary levels." This is the closest I've found from Census factfinder2.census.gov/help/en/glossary/s/… This has more, but is compiled outside of Census mcdc2.missouri.edu/cgi-bin/browse?/pub/sasfmats/Ssumlev.sas@ – Joe Germuska May 8 '13 at 18:45

After several years, I finally created my own code to build a schema. However, it is currently embedded in a python library, so it isn't generally usable as a spec. Here is the geoid module, which parses and generate Census geoids, with variants for Census, Tiger and ACS formats:

https://github.com/CivicKnowledge/geoid.git

If you are handy with programming, you can extract all of the required information from one of the source files, although it may be easier just to use the module in python.

https://github.com/CivicKnowledge/geoid/blob/master/geoid/init.py

The segments dictionary has lists of components for each of the summary level numbers, and the lengths dictionary has the length in decimal digits for each of the components. Note that a few of the lengths are specified as strings; this is a signal that the component can take characters, as well as digits.

This code is generated from a python notebook that analyzes the data from the first link in this answer.

https://github.com/CivicKnowledge/geoid/blob/master/support/GenerateNames.ipynb

There is a short spec for some geoids on the census website in the "GEOID Structure for Geographic Areas" section.

share|improve this answer

Here you cand find a simple explanation for the columns that you must concantenate to generate the GeoIDs for different geographic areas

https://www.census.gov/geo/reference/geoidentifiers.html

share|improve this answer
    
Thanks. That's getting closer, but unfortunately isn't comprehensive. There are a lot more summary levels -- at least 209 of them. – Eric Busboom Feb 2 at 0:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.