[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.


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