I'm attempting to get the geocoder extension to work. When I try to geocode
a common address, I get a latitude and longitude that's pretty far off and
the street information is missing. Example:
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('835 market street, san
francisco ca 94103') AS g;
rating | lon | lat | stno | street | styp |
city | st | zip
--------+-----------------+------------------+------+--------+------+---------------+----+-------
100 | -122.6939756117 | 37.7597150026058 | | | | San
Francisco | CA | 94103
Here are the counts of some of the tables that I believe are/should be
populated after running the loader script:
- tiger.addr: 0
- tiger.edges: 0
- tiger.faces: 0
- tiger.featnames: 0
- tiger.place: 1522
- tiger.cousub: 397
- tiger.county: 3233
- tiger.state: 56
- tiger.zip_lookup_base: 0
- tiger.zip_state: 0
- tiger.zip_state_loc: 0
The loader script appears to not be downloading a few datasets:
- www2.census.gov/geo/tiger/TIGER2016/ADDR
- www2.census.gov/geo/tiger/TIGER2016/EDGES
- www2.census.gov/geo/tiger/TIGER2016/FEATNAMES
- www2.census.gov/geo/tiger/TIGER2016/FACES
Does any one know if I'm missing crucial data? If so, is it possible to
back fill from previous years? If not, what else could be going on here?
Thanks
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users
