[postgis-users] Geocoder and scripts

Lee Keel lee.keel at uai.com
Tue Jul 3 11:37:06 PDT 2007

Hello all.

There have been a few chains going around about using postgis to geo-code
against Tiger data.  I know that there are some scripts available already,
but I just thought I would post what we have running now and see what people
thought.  These scripts were originated from the scripts found under Tiger
Geocoder at http://postgis.refractions.net/download/.  There are some
enhancements left to do, but this is the first generation of the scripts and
they do work for most cases.  You can see the power of this geocoder at
http://hud.uai.com/hudpls/ViewMap.aspx?FindAddTI=1.  This is doing a live
geo-coded search as the user types for the entire US (~39 million roads).
At this time we are returning the top 12 hits as the user types.  This is
done by using a modified version of the Ajax AutoComplete control.

Future enhancements include:
  *Street Intersection geocoding
  *FuzzyString match (also broadening the search outwards to match at Zip,
then City, then State)
  *Continued growth on normalization algorithms
  *Use of 'LIKE' will be incorporated if the postgres optimizer changes to
optimize the use of a % at the end of a string.

If you would like to test these scripts, simply follow the README.html that
is in the zip which has basic step-by-step instructions on exactly what to
do.  Please feel free to contact me if you have any
questions\comments\suggestions on any of this. 

Best Regards,
Lee Keel


This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070703/e7ec9611/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Geocoder.zip
Type: application/octet-stream
Size: 13505 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070703/e7ec9611/attachment.obj>

More information about the postgis-users mailing list