Spatial Surrogate codes 6831, 6832, and 6833

At the current time, the ntad_2017_county_pol is not packaged with 2017. It is available as part of the 2016 surrogates as NTAD_2014.

The NTAD_2017_County_Pol table was directly created as a table in the PostgreSQL database based on the NTAD_2014_County_Pol shapefile, which had been loaded as part of the 2016 platform.

The current SurrogateToolsDB GitHub page is based on the 2016 platform, so the util/load_shapefile_reproject_multi.csh script can be used to load the NTAD_2014_County_Pol shapefile. Uncomment “source load_shapefile.csh” at line 57.

The archive pg_srgcreate_2020.tar.gz has the updated scripts for the 2017 platform. In pg_srgcreate/pg_srgtools/CONUS/util/load_shapefile_reproject_multi.csh, uncomment line 92. When load_shapefile.csh runs, it won’t try to read a shapefile from disk, instead it will create a new table from the ntad_2014_county_pol table, with updated FIPS codes for 2017.

There were two FIPS changes from 2014/2016 platforms to 2017:

46113 Shannon, SD à 46102 Oglala Lakota, SD

02270 Wade Hampton, AK à 02158 Kusilvak, AK

You don’t necessarily need to take the above approach – if you have a Shapefile editor you could instead make the two substitutions to the NTAD 2014 Shapefile.

Or you can use the 2014 Shapefile as is and just substitute the FIPS in the output of the surrogate tool.