479
edits
Changes
Jump to navigation
Jump to search
I began by adding the extension listed above. First, enter into Postgres by using the psql command. Then: --Add Extensions to database CREATE EXTENSION postgis; CREATE EXTENSION fuzzystrmatch; CREATE EXTENSION postgis_tiger_geocoder; CREATE EXTENSION address_standardizer; You can test that the installation worked by running the following query: SELECT na.address, na.streetname,na.streettypeabbrev, na.zip FROM normalize_address('1 Devonshire Place, Boston, MA 02109') AS na; This should return the following: address | streetname | streettypeabbrev | zip ---------+------------+------------------+------- 1 | Devonshire | Pl | 02109 Next, a new profile needs documentation has been moved to be created by using the following command. INSERT INTO tiger.loader_platform(os, declare_sect, pgbin, wget, unzip_command, psql, path_sep, loader, environ_set_command, county_process_command) SELECT 'newuser', declare_sect, pgbin, wget, unzip_command, psql, path_sep, loader, environ_set_command, county_process_command FROM tiger.loader_platform 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. One option is to edit the declare_sect column in the tiger.loader_platform table. If so, the declare_sect looks like the following[http: export PGHOST=localhost + export PGUSER=postgres + export PGPASSWORD=yourpasswordhere + export PGDATABASE=geocoder + PSQL=${PGBIN}/psql + SHP2PGSQL=shp2pgsql + cd ${staging_fold} + TMPDIR="${staging_fold}/temp/" + UNZIPTOOL=unzip + WGETTOOL="/usr/bin/wget" + export PGBIN=/usr/lib/postgresql/9mcnair.6/bin + export PGPORT=5432 + export PGHOST=localhost + export PGUSER=postgres + export PGPASSWORD=yourpasswordhere + export PGDATABASE=geocoder + PSQL=${PGBIN}/psql + SHP2PGSQL=shp2pgsql + cd ${staging_fold} Another option is to edit the sh file before running the scriptbakerinstitute. The downloaded script is located in the following directory: org/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 databasename -tA > wiki/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 We changed the PGUSER and PGPASSWORD fields to: PGUSER=postgres PGPASSWORD=(Ask Anne for this password)!Everything else remains the sameTiger_Geocoder Tiger Geocoder] wiki page.
no edit summary
[https://postgis.net/docs/postgis_installation.html#install_tiger_geocoder_extension This link] outlines the process to enable our Postgres Database to support Tiger functionality.
