7,612
edits
Changes
Jump to navigation
Jump to search
→Add the geocoding
Note that PortCoGeoID and other tables are built in the BuildBaseTables.sql script.
===Load the Additions===
These include:
*CPI (see the spreadsheet CPIEstimate.xlsx, source data from https://data.bls.gov/pdq/SurveyOutputServlet)
*Population, statepop2017, and ACS. See [[American Community Survey (ACS) Data]].
*tigerplaces, which builds tigergeog, and placedisplay. See [[Jeemin Sim (Work Log)]], [[Urban Start-up Agglomeration and Venture Capital Investment]] and [[Tiger Geocoder]]
*Industry, Firm type, Firm stage, Title, statecode, and other lookup tables.
*PortCoSBIR and PortCoPatent -- These are now out of date and don't appear to have build notes.
==Base Tables==
