Hi Frank, I was wondering if you had run the script for a state or group of states without running the script for the nation?
I did this, thinking that I just wanted my little bit. Had the same results you did. Doesn't work that way. Once I followed the instructions properly it worked fine. http://postgis.net/docs/manual-dev/postgis_installation.html#install_tiger_geocoder_extension Hope that helps, Sara -- Sara Yurman, GISP Spatial Focus, LLC Geodata Architects http://www.spatialfocus.com/ Office: (404) 378-0989 Fax: (404) 806-6257 On Wed, Nov 23, 2016 at 2:49 PM, Frank Quick <[email protected]> wrote: > 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 >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
