[postgis-users] RE: [postgis-devel] Geocoder and scripts

Lee Keel lee.keel at uai.com
Tue Jul 3 11:42:27 PDT 2007

There may have been some problem with the zip that I attached, so I am
reattaching a 7zip file.  Hopefully it will work better.


Sorry for the repeated emails!





From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Lee Keel
Sent: Tuesday, July 03, 2007 1:37 PM
To: postgis-users at postgis.refractions.net;
postgis-devel at postgis.refractions.net
Subject: [postgis-devel] Geocoder and scripts


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/
<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/711cd030/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Geocoder.7z
Type: application/octet-stream
Size: 11735 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070703/711cd030/attachment.obj>

More information about the postgis-users mailing list