I'm trying to test the TIGER geocoder with the address provided in the documentation.

This is the sample address I'm testing:75 State Street, Boston MA 02109

SELECT g.rating, ST_X(g.geomout) As lon, ST_Y(g.geomout) As lat,
    (addy).address As stno, (addy).streetname As street,
    (addy).streettypeabbrev As styp, (addy).location As city, (addy).stateabbrev As st,(addy).zip
    FROM geocode('75 State Street, Boston MA 02109') As g;

But I'm not getting any match for this query:

enter image description here

I have installed PostgreeSQL, PostGIS and the requerired extensions:

CREATE EXTENSION fuzzystrmatch;
--this one is optional if you want to use the rules based standardizer (pagc_normalize_address)
CREATE EXTENSION address_standardizer;
CREATE EXTENSION postgis_tiger_geocoder;

Also I have also downloaded the data corresponding to that address from the census site, which is correspondes to the state of MA (suffolk_county)

I have loaded the data into a table using the following comand:

ogr2ogr -f PostgreSQL PG:dbname=test1 -progress -nlt PROMOTE_TO_MULTI /GIS/data/ma_suffolk_county/tl_2016_25025_edges.shp -nln ma_suffolk_county

The table was succesfully created:

\d+ ma_suffolk_county

enter image description here

1 Answer 1

ogr2ogr -f PostgreSQL PG:dbname=test1 -progress -nlt PROMOTE_TO_MULTI /GIS/data/ma_suffolk_county/tl_2016_25025_edges.shp -nln ma_suffolk_county

This is not how you load the data. Follow the section entitled Installing, Upgrading Tiger Geocoder and loading data. You can not diverge from these instructions at all.

  • I was following that until step 2.8.4 then I had some issues. Is this because I'm not indexing the data doing it this way? or what is the issue? May 16, 2017 at 3:40
  • You load the data by running the scripts you generate with Loader_Generate_Nation_Script and Loader_Generate_Script. You do not use ogr2ogr May 16, 2017 at 4:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.