<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
..shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Geocoder and scripts</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Palace Script MT";
panose-1:3 3 3 2 2 6 7 12 11 5;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>There may have been some problem with the
zip that I attached, so I am reattaching a 7zip file. Hopefully it will work
better.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Sorry for the repeated emails!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>LK<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
postgis-devel-bounces@postgis.refractions.net
[mailto:postgis-devel-bounces@postgis.refractions.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b><st1:PersonName w:st="on">Lee
Keel</st1:PersonName><br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, July 03, 2007 1:37
PM<br>
<b><span style='font-weight:bold'>To:</span></b>
postgis-users@postgis.refractions.net; postgis-devel@postgis.refractions.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> [postgis-devel] Geocoder
and scripts</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Hello
all.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>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</span></font> <font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>found under
Tiger Geocoder at</span></font> <font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'><a href="http://postgis.refractions.net/download/"
target="_blank">http://postgis.refractions.net/download/</a>. </span></font>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>There
are some enhancements left to do, but this</span></font> <font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>is the first generation
of the scripts and they do work for most cases. You can see the power of
this geocoder at</span></font> <font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'><a
href="http://hud.uai.com/hudpls/ViewMap.aspx?FindAddTI=1" target="_blank">http://hud.uai.com/hudpls/ViewMap.aspx?FindAddTI=1</a>.
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</span></font> <font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>hits as the
user types. This is done by using a modified version of the Ajax</span></font>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>AutoComplete
control.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Future
enhancements include:</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
*Street Intersection geocoding</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
*FuzzyString match (also broadening</span></font> <font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>the search outwards to match at Zip,
then City, then State)</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
*Continued growth on normalization algorithms</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
*Use of 'LIKE' will be incorporated if the postgres optimizer</span></font> <font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>changes to
optimize the use of a % at the end of</span></font> <font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>a string.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>If
you would like to</span></font> <font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>test these scripts, simply follow the README.html
that is in the zip</span></font> <font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>which has basic step-by-step
instructions on exactly what to do. </span></font> <font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>Please feel free to
contact me if you have any questions\comments\suggestions on any of this.</span></font>
<o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Best
Regards,<o:p></o:p></span></font></p>
<p><st1:PersonName w:st="on"><font size=7 face="Palace Script MT"><span
style='font-size:36.0pt;font-family:"Palace Script MT"'>Lee Keel</span></font></st1:PersonName><o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
<br>
<o:p></o:p></span></font></p>
<p><font size=2 color=black face=Arial><span style='font-size:10.0pt;
font-family:Arial;color:black'><<Geocoder.zip>> </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
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.<o:p></o:p></span></font></p>
</div>
</body>
</html>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.