[postgis-users] Tiger geocoder - error instead of null when unlocatable
Matthew Syphus
MSyphus at lhtac.org
Sat Feb 6 21:43:27 PST 2016
Apologies for not including version details originally.
"postgis_full_version"
"POSTGIS="2.2.1 r14555" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.7.6" LIBJSON="0.11" TOPOLOGY RASTER"
PostgreSQL 9.5.0
CentOS 6.5
mst
From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Matthew Syphus
Sent: Saturday, February 06, 2016 9:06 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] Tiger geocoder - error instead of null when unlocatable
After following the instructions (several times) and apparently successfully installing tiger geocoder and the tiger data for Idaho, I keep getting an error when the geocoder can't find an address.
With a locatable address it works just fine.
SELECT * FROM geocode('3300 state st, boise, id 83703')
When an address is not locatable, I assume it should return null (and move on to the next in the batch).
Instead, it returns an error:
SELECT * FROM geocode('3300 state st, neverland, id 9876543210')
---------------------------------------
ERROR: column co.statefp does not exist
LINE 2: ...cefp = p.placefp) LEFT JOIN county co ON ('16' = co.statefp...
^
QUERY: SELECT DISTINCT ON (sub.predirabrv,sub.fename,COALESCE(sub.suftypabrv, sub.pretypabrv) ,sub.sufdirabrv,coalesce(p.name,zip.city,cs.name,co.name),s.stusps,sub.zip) sub.predirabrv as fedirp, sub.fename, COALESCE(sub.suftypabrv, sub.pretypabrv) as fetype, sub.sufdirabrv as fedirs, coalesce(p.name,zip.city,cs.name,co.name)::varchar as place, s.stusps as state, sub.zip as zip, interpolate_from_address($1, sub.fromhn, ...
It doesn't seem to matter which address element causes the problem, the error is the same and it kills the query. Is there some error handling that is getting missed? The examples I've seen look like it just returns null. Thank you for any help.
mst
________________________________
This email has been scanned for spam and viruses by Proofpoint Essentials cloud email security - click here<https://us1.proofpointessentials.com/index01.php?mod_id=11&mod_option=logitem&mail_id=Z07c%2BrvT0fHg&rid=6780640&report=1> to report this email as spam.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160207/d8cda44f/attachment.html>
More information about the postgis-users
mailing list