[postgis-users] TIGER 2016 Setup Question
Frank Quick
fquick1y at gmail.com
Wed Nov 23 18:13:51 PST 2016
Regina and Sara,
Thank you for responding to me :).
I may have misunderstood what you were telling me and potentially the
instructions. The steps to make it work correctly are:
1. Generate the nation script
2. Execute the nation script
3. Generate the state script
4. Execute the state script
The following is incorrect (which is what I did):
- Generate the nation script
- Generate the state script
- Execute the nation script
- Execute the state script
I believe I was confused because I read step 7 of
http://postgis.net/docs/manual-dev/postgis_installation.html#install_tiger_geocoder_extension
as
a generate step for both the nation and state scripts. Then I read step 8
as an execution step for both the nation and state scripts.
Thank you both for your help!
On Wed, Nov 23, 2016 at 3:23 PM Frank Quick <fquick1y at gmail.com> wrote:
> 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/20161124/f90af100/attachment.html>
More information about the postgis-users
mailing list