<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Verdana","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#8000FF;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:fuchsia;
text-decoration:underline;}
span.emailstyle17
{mso-style-name:emailstyle17;
font-family:"Verdana","sans-serif";
color:navy;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:.5in .5in .5in .5in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link="#8000FF" vlink=fuchsia>
<div class=Section1>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#1F497D'>I
think that the task of geocoding is fairly easy and I have written a geocode
function that uses PostGIS. However, the problem is where to get the data. In
the U.S. you can use Tiger line data from the census, but it is horrible
inaccurate. If you have resources you can purchase more accurate data
from other companies like Navteq, or manually correct the census data. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#1F497D'>Rob.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #91C0FF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:9.0pt;font-family:"Segoe UI","sans-serif"'>From:</span></b><span
style='font-size:9.0pt;font-family:"Segoe UI","sans-serif"'>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b>On Behalf Of </b>Stone,
Matthew (DHS-HISP)<br>
<b>Sent:</b> Friday, February 02, 2007 1:15 PM<br>
<b>To:</b> postgis-users@postgis.refractions.net<br>
<b>Subject:</b> [postgis-users] Geocoding<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:navy'>Does/Will PostGis have a Geocoding
routine built in such as ArcSDE has locators and geocoding processing? I
am curious, as geocoding is the building block of any GIS work I do and I have
need of decent open-source solutions that can process millions of records in a
batch mode, or can be implemented on the WEB as a “geocoding
service” either again in batch mode, or real time via other web-based
applications. I understand the limitations of this functionality in an
open-source environment, namely the ability of getting decent reference data,
but am curious all the same. </span><o:p></o:p></p>
<p class=MsoNormal><span style='color:navy'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='color:navy'>Maybe a module could be built that
accesses the geocoding services provided by Google or Yahoo, of MS Virtual
Earth??????</span><o:p></o:p></p>
<p class=MsoNormal><span style='color:navy'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='color:navy'>Just thought I would throw this out
there.</span><o:p></o:p></p>
<p class=MsoNormal><span style='color:navy'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='color:navy'>Matthew</span><o:p></o:p></p>
<p class=MsoNormal><span style='color:navy'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:navy'>Matthew Stone, MPH</span><span
style='color:navy'><br>
</span><span style='font-size:10.0pt;color:navy'>UCSF/CA Dept. of Health
Services</span><span style='color:navy'><br>
</span><span style='font-size:10.0pt;color:navy'>Health Information &
Strategic Planning (HISP)</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:navy'>Office of County
Health Services (OCHS)</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:navy'>1501 Capitol Ave
MS 5204</span><o:p></o:p></p>
<p class=MsoNormal><strong><span style='font-family:"Verdana","sans-serif";
color:navy'>Mailing Address:</span></strong><b><span style='color:navy'><br>
</span></b><span style='font-size:10.0pt;color:navy'>PO BOX 997413, MS 5204</span><span
style='color:navy'><br>
</span><span style='font-size:10.0pt;color:navy'>Sacramento CA 95899-7413 </span><o:p></o:p></p>
<p class=MsoNormal><strong><span style='font-family:"Verdana","sans-serif";
color:navy'>Physical Address:</span></strong><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:navy'>1501 Capitol
Avenue, Suite 71.5195, MS 5204</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:navy'>Sacramento, CA
95814</span><o:p></o:p></p>
<p class=MsoNormal><span style='color:navy'>_____________________________</span><o:p></o:p></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;color:navy'>PH: 916-552-9918</span><span
style='color:navy'><br>
</span><span style='font-size:10.0pt;color:navy'>FAX: 916-552-8260 </span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;color:navy'><a
href="mailto:mstone@dhs.ca.gov">mstone@dhs.ca.gov</a></span><o:p></o:p></p>
</div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
</body>
</html>