Regina, Thank you for responding!
I'm definitely downloading successfully from the census site. I'm on Mac OS X v10.11.1. I noticed the script didn't generate any wget commands for addr/edges/features/faces. Abe On Wed, Nov 23, 2016 at 12:31 PM Regina Obe <[email protected]> wrote: > Yap seems something went wrong with your load. > > > > I get this: > > > > rating | lon | lat | stno | street | styp | > city | st | zip > > > --------+-------------------+------------------+------+--------+------+---------------+----+------- > > 0 | -122.406147398092 | 37.7853683917931 | 835 | Market | St | > San Francisco | CA | 94103 > > (1 row) > > > > > > You might want to check the folder the script downloads to and make sure > it did download the addr/edges/featnames files. I've had issues with the > census site in that if you download enough states, their akmai lockout > thing kicks in so then you are denied from their site for a couple of > days. Not sure if that is what you are running into. > > > > Which OS are you on. It's also possible I made a mistake somewhere in the > script that is affecting your OS. > > > > > > Thanks, > > Regina > > > > > > > > > > *From:* postgis-users [mailto:[email protected]] *On > Behalf Of *Frank Quick > *Sent:* Wednesday, November 23, 2016 2:49 PM > *To:* [email protected] > *Subject:* [postgis-users] TIGER 2016 Setup Question > > > > 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
