[postgis-users] TIGER 2016 Setup Question

[Frank Quick]

Sara,

I ran the nation script before I ran the state script. Though, I didn't
check to see if the nation script error'd at all. I can check to see if
that's the case later today and post back my results!


On Wed, Nov 23, 2016 at 12:46 PM Sara Yurman <syurman at spatialfocus.com>
wrote:

> Hi Frank,
>
> I was wondering if you had run the script for a state or group of states
> without running the script for the nation?
>
> I did this, thinking that I just wanted my little bit.  Had the same
> results you did.  Doesn't work that way.  Once I followed the instructions
> properly it worked fine.
> http://postgis.net/docs/manual-dev/postgis_installation.html#install_tiger_geocoder_extension
>
> Hope that helps,
>
> Sara
> --
> Sara Yurman, GISP
> Spatial Focus, LLC
> Geodata Architects
> http://www.spatialfocus.com/
> Office: (404) 378-0989
> Fax:    (404) 806-6257
> On Wed, Nov 23, 2016 at 2:49 PM, Frank Quick <fquick1y at gmail.com> wrote:
>
> 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/da7059d9/attachment.html>