Changes

Jump to navigation Jump to search
548 bytes added ,  12:41, 8 October 2019
===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:

Navigation menu