[postgis-users] TIGER 2016 Setup Question

[Frank Quick]

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 <lr at pcorp.us> 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:postgis-users-bounces at lists.osgeo.org] *On
> Behalf Of *Frank Quick
> *Sent:* Wednesday, November 23, 2016 2:49 PM
> *To:* postgis-users at lists.osgeo.org
> *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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161123/3e72b375/attachment.html>