7,612
edits
Changes
Jump to navigation
Jump to search
→Additions
===Additions===
====Population===
For now:
*The population table (see Population.sql)
*The statepop2017 table (from States2017PopulationEstimate.txt, with DC (2018), GU (2017), and PR (2017) added.
We might want to join in the [[American Community Survey (ACS) Data]] too.
====Tiger Places====
We will use the old Tiger Places, but it is worth exploring how to rebuild this from scratch. First, visit https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html. Then download each state's place file. Load them and merge them. See [[PostGIS_Installation#Bulk_Download_TIGER_Shapefiles]] for more information. It is also worth reading the [[Tiger Geocoder]] and [[Jeemin Sim (Work Log)]].
We also might need to add:
