Re: [postgis-users] geocoding failure

Solved. Flat forehead moment. Just needed to run the script generated by Loader_Generate_Nation_Script before loading the Georgia data. Sorry for the fuss. Sara On Fri, Oct 14, 2016 at 3:27 PM, P O'Toole wrote: > >>I hav

Re: [postgis-users] geocoding failure

>>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_da

Re: [postgis-users] geocoding failure

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

[postgis-users] geocoding failure

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. For example: select geocode_intersection( 'Patterson Av