479
edits
Changes
Jump to navigation
Jump to search
no edit summary
WHERE os = 'sh';
The installation instructions also provide the following note: As of PostGIS 2.4.1 the Zip code-5 digit tabulation area zcta5 load step was revised to load current zcta5 data and is part of the Loader_Generate_Nation_Script when enabled. It is turned off by default because it takes quite a bit of time to load (20 to 60 minutes), takes up quite a bit of disk space, and is not used that often. If you would like this feature, you can enable it by using the following command. This should be done before loading the script. UPDATE tiger.loader_lookuptables SET load = true WHERE table_name = 'zcta510'; The paths in declare_sect need to be edited so they match our server locations.The One option is to edit the declare_sect column in the tiger.loader_platform table. If so, the declare_sect looks like the following:
export PGHOST=localhost +
export PGUSER=postgres +
SHP2PGSQL=shp2pgsql +
cd ${staging_fold}
Another option is to edit the sh file before running the script. The downloaded script is located in the following directory:
/gisdata
There needs to be a directory called "temp" in the gisdata directory. To make the script, use the following from the command line:
psql -c "SELECT Loader_Generate_Nation_Script('debbie')" -d geocoder -tA > /gisdata/nation_script_load.sh
This will create a script in the gisdata directory. Change to that directory. If you did not edit the paths in the declare_sect table in psql, then you will need to edit this file to contain the correct paths. Run the script by using:
sh nation_script_load.sh
