Sara, I ran the nation script before I ran the state script. Though, I didn't check to see if the nation script error'd at all. I can check to see if that's the case later today and post back my results!
On Wed, Nov 23, 2016 at 12:46 PM Sara Yurman <[email protected]> wrote: > 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
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
