[postgis-users] TIGER 2016 Setup Question

Sara Yurman syurman at spatialfocus.com
Wed Nov 23 12:46:35 PST 2016


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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161123/d4f8ff81/attachment.html>


More information about the postgis-users mailing list