[postgis-users] Adding to geocoder data for better results?
Kent Richards
info at kentrichards.net
Thu Apr 24 21:55:21 PDT 2014
Apologies this has been discussed. I searched the archives, did not find an answer.
Description of the problem:
PostGIS version =
POSTGIS="2.0.2 r10789" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.8.0" LIBJSON="UNKNOWN" RASTER
When geocoding some addresses (perhaps, unincorporated areas), the returned results are not even in the ballpark.
Example:
select * from geocode('46896 California 1, Big Sur, CA 93920');
addy | geomout | rating
-------------------------------------------------------+----------------------------------------------------+--------
(,,California,Via,,,"Dana Point",CA,92624,t) | 0101000020AD10000073368950A46A5DC082C23F6CC5BB4040 | 38
(,,California,Via,,,"Dana Point",CA,92675,t) | 0101000020AD100000CCE9BF1EA76A5DC05EB5F600C9BB4040 | 39
(,,California,Via,,,"San Juan Capistrano",CA,92675,t) | 0101000020AD1000006679E728A16A5DC0467CB31001BC4040 | 40
Dana Point, CA is ~350 miles from Big Sur, CA.
The search zip (93920) doesn't appear to be in zip_lookup or zip_lookup_all.
"Big Sur" doesn't appear to be in place.
I have voter registration data that includes full addresses for registered voters. Is there a way to add this data to the geocoder tables so that geocoding returns something in the ballpark for addresses such as this?
Thank you.
More information about the postgis-users
mailing list