7,612
edits
Changes
Jump to navigation
Jump to search
→Add the geocoding
2010 Census data (2020 isn't available but the mappings are fairly static):
*https://www.census.gov/geographies/reference-files/time-series/geo/relationship-files.2010.html
*https://www2.census.gov/geo/pdfs/maps-data/data/rel/explanation_zcta_place_rel_10.pdf
*https://www2.census.gov/geo/docs/maps-data/data/rel/zcta_place_rel_10.txt
I also load up the 2010 ANSI codes for places (i.e., statefp, statecode, placename, placefp, etc.):
* Source: https://www.census.gov/library/reference/code-lists/ansi.html
* Data: national_places.txt -> national_places_processed.txt (regexes)
* Pop the last word off the placename!
Note that the postprocessing of these two tables is done at the end of Load.sql. The final table is '''zctaplaceinfo''' which takes zcta, statecode and provides back placename and geoid (of the place).
===Load the Additions===
