[postgis-users] TIGER 2016 Setup Question

Frank Quick fquick1y at gmail.com
Wed Nov 23 15:23:16 PST 2016


Regina,

I believe I followed those steps... what are the wget commands that are
being generated? I'll try running through the process again in the next
couple of hours and post the results (and the generated scripts).

Abe

On Wed, Nov 23, 2016 at 12:57 PM Regina Obe <lr at pcorp.us> wrote:

> One more note, since your state load is messed up, you should drop any
> state tables created.
>
>
>
> http://postgis.net/docs/manual-2.3/Drop_State_Tables_Generate_Script.html
>
>
>
> SELECT drop_state_tables_generate_script('CA');
>
>
>
> Will not actually drop but will generate the drop statements you can run.
>
>
>
>
>
> *From:* Regina Obe [mailto:lr at pcorp.us]
> *Sent:* Wednesday, November 23, 2016 3:54 PM
>
>
> *To:* 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
>
> *Subject:* RE: [postgis-users] TIGER 2016 Setup Question
>
>
>
> Hmm that's very odd.
>
>
>
> I see wget for those when I run:
>
>
>
> SELECT Loader_Generate_Script(ARRAY['CA'], 'sh');
>
>
>
>
>
> You followed these instructions:
>
>
>
>
> http://postgis.net/docs/manual-2.3/postgis_installation.html#install_tiger_geocoder_extension
>
>
>
> If you are using pgAdmin to generate the script, make sure you have Query
> Editor -> Max. characters per column set to something very large.
>
>
>
> It's usually low like 255, so most of the script would be truncated if you
> copied and pasted from pgAdmin.
>
>
>
>
>
> *From:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org
> <postgis-users-bounces at lists.osgeo.org>] *On Behalf Of *Frank Quick
>
>
> *Sent:* Wednesday, November 23, 2016 3:43 PM
> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
>
> *Subject:* Re: [postgis-users] TIGER 2016 Setup Question
>
>
>
> 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
>
> _______________________________________________
> 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/e3340a8e/attachment.html>


More information about the postgis-users mailing list