I've installed the PostGIS Tiger Geocoder according to these instructions and loaded in data for the state of New York.
Unfortunately, when I try to geocode something...
ny_tiger=# 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('350 Fifth Ave, New York, NY 10118') As g;
rating | lon | lat | stno | street | styp | city | st | zip
--------+-----+-----+------+--------+------+------+----+-----
(0 rows)
So that's not great.
I noticed when loading things in I got a ton of errors like this:
Unable to open tl_2013_36123_addr.shp or tl_2013_36123_addr.SHP.
tl_2013_36123_addr.dbf: shape (.shp) or index files (.shx) can not be opened, will just import attribute data.
Is that the problem? How do I fix that?
No comments:
Post a Comment