search

censusreporter / census-postgres-scripts

Scripts used to set up census-postgres on an Amazon EC2 instance.
MIT License
65 stars 34 forks source link

Use TIGER data on state regions and divisions when populating census_name_lookup #26

Closed JoeGermuska closed 3 years ago

JoeGermuska commented 3 years ago

Since TIGER doesn't produce maps for census divisions and regions, we have constructed geographic representations of those.

The process for that has included a hardcoded list of GeoIDs for the states in a given division. Sometimes we make a mistake in that list, which messes up the map for that division, and, transitively, for the region which contains that division.

This PR uses a join so that we can use the post-simplification geographies for states (in census_name_lookup) but rely upon the explicit coding of division and region which is found in the TIGER state GIS data.

JoeGermuska commented 3 years ago
image

This image shows how Indiana was inadvertently left out of the "East North Central Division".