[postgis-users] TIGER 2016 Setup Question

Frank Quick fquick1y at gmail.com
Wed Nov 23 11:49:17 PST 2016


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161123/7bc40643/attachment.html>


More information about the postgis-users mailing list