censusreporter / census-postgres-scripts

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

Proper handling of sumlevels 250, 252, and 254 #12

Closed tuchandra closed 6 years ago

tuchandra commented 8 years ago

See censusreporter/censusreporter#34 for an explanation of the problem this solves.

In order for these geographies to be handled correctly, three things are necessary:

This fixes the first of the three parts. This script creates pseudo-tiger tables for sumlevels 250, 252, and 254 so that the geoids correctly correspond to acs2014_5yr.geoheader. It then inserts (replaces if some already exist) rows into tiger2014.census_name_lookup for these sumlevels, so that they appear in API calls, search results, and autosuggest.

JoeGermuska commented 8 years ago

@iandees when you have time, could you look at this and give it your ultimate OK? I feel pretty good about it (and it's essentially already implemented outside of the dataload process as part of fixing censusreporter/censusreporter#34) but I'd like to make sure you know what's going on.

If you're good, go ahead and merge, etc.

JoeGermuska commented 8 years ago

@iandees don't forget to look at this before we update TIGER, which I'm guessing will be part of the 5-year data load in December?

JoeGermuska commented 6 years ago

I manually ran the updated version of the file in 0ee1439 and native geographies seem to work correctly, so as long as this gets normalized into the data update process in the future, we are good.