7,649
edits
Changes
Jump to navigation
Jump to search
→Add the geocoding
*Retrieve and load ZCTA Gazetteer from the [https://www.census.gov/geographies/reference-files/time-series/geo/gazetteer-files.html U.S. Census]
*A small but meaningful proportion of US venture firms have zip codes but not addresses. I created the table firmbogeoplus to add longitude and latitudes for these firms in Load.sql (right after firmbogeo).
A small number of US PortCos have zipcodes but not places (which are used in the Rankings and elsewhere). To address this, I loaded the 2010 ZCTA to place lookup in Load.sql (passing the result through TigerGeog) to get the placename. This is now incorporated into PortCoGeoid in BuildBaseTables.sql.
2010 Census data (2020 isn't available but the mappings are fairly static):
*https://www.census.gov/geographies/reference-files/time-series/geo/relationship-files.2010.html
*https://www2.census.gov/geo/docs/maps-data/data/rel/zcta_place_rel_10.txt
===Load the Additions===
