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:
I have installed PostgreeSQL, PostGIS and the requerired extensions:
CREATE EXTENSION postgis;
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