[postgis-users] geocoding failure

Sara Yurman syurman at spatialfocus.com
Sat Oct 15 09:19:37 PDT 2016

Solved.  Flat forehead moment.  Just needed to run the script generated by
<http://postgis.net/docs/manual-dev/Loader_Generate_Nation_Script.html> before
loading the Georgia data.

Sorry for the fuss.


On Fri, Oct 14, 2016 at 3:27 PM, P O'Toole <P.OToole at uwyo.edu> wrote:

> >>I have the tiger geocoder extension installed, and the tiger data loaded
> >>for the state of Georgia.  I can get a reasonable response from the
> >>geocode_intersection function, but geocode, geocode_address and
> >>reverse_geocode always fetch 0 rows.
> >
> >Ok, so here's an update.  I found the tiger_data.ga_zip_lookup_base empty.
> >It seemed to be empty because the tiger.county table was empty.  I grepped
> >the loader script for anything that would have loaded the tiger.county
> >table and didn't find anything.  I regenerated the script to be sure, and
> >got the same result.
> >
> >So I filled the tiger.county and tiger_data.ga_zip_lookup_base tables.
> And
> >got the same result.  Is there something I'm not getting about the loader
> >script?  Here's how I generated my loader:
> >
> >psql -U postgres -d wafflehouse -A t -c "SELECT
> >Loader_Generate_Script(ARRAY['GA'],'windows');"
> >
> >This has to run in a windows vm on my laptop for a variety of reasons.  In
> >any case, the script generated looks plausible and seems to work mostly.
> >I checked all the FROM clauses in the create script for the
> geocode_address
> >function, and believe I have data in all the required tables.  I'll keep
> >after it, but any help would be great.
> >
> >Thanks,
> >
> >Sara
> >--
> >Sara Yurman, GISP
> >Spatial Focus, LLC
> >Geodata Architects
> >http://www.spatialfocus.com/
> >Office: (404) 378-0989
> >Fax:    (404) 806-6257
> Sara –
> I don't do geocoding myself, but a brute-force way of moving forward would
> be to either (A) get geocoding information from someone else in the state
> who uses PostGIS and steal their configuration (B) get geocoding
> information from someone who uses PostGIS in a neighboring state for clues
> as to what's going on (C) install Postgres/PostGIS temporarily onto a Linux
> server and pg_dump/restore to the local Windows machine you stated you have
> to use. I'd suggest installing a dual-boot to that machine or flipping the
> virtualization you're doing to go from Windows->Linux instead of
> Linux->Windows instead of the other way around, but even if it happened to
> be an option I probably wouldn't chase that option until you had more
> information.
> Cheers,
> - Patrick O'Toole
> Application Developer
> Wyoming Natural Diversity Database
> UW Berry Biodiversity Conservation Center
> Department 3381, 1000 E. University Av.
> Laramie, WY 82071
> P: 307-766-3018

Sara Yurman, GISP
Spatial Focus, LLC
Geodata Architects
Office: (404) 378-0989
Fax:    (404) 806-6257
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161015/0e47a3c6/attachment.html>

More information about the postgis-users mailing list