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
<http://www2.census.gov/geo/tiger/TIGER2016/ADDR>
* www2.census.gov/geo/tiger/TIGER2016/EDGES
<http://www2.census.gov/geo/tiger/TIGER2016/EDGES>
* www2.census.gov/geo/tiger/TIGER2016/FEATNAMES
<http://www2.census.gov/geo/tiger/TIGER2016/FEATNAMES>
* www2.census.gov/geo/tiger/TIGER2016/FACES
<http://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
