<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">Yes, the TIGER/Line data can be horribly inaccurate, and the Navteq/Tele Atlas data is horribly expensive.<DIV><DIV> </DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Google Maps provides a geocoder web service (<A href="http://www.google.com/apis/maps/documentation/#Geocoding_Examples">http://www.google.com/apis/maps/documentation/#Geocoding_Examples</A>) via HTTP but it is rate-limited to 50,000 requests per day. They have some commercial-use restrictions, IIRC, and you can't use any of the GMaps services for real-time tracking. But it might fit the bill.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Their commercial-use service is pretty darn expensive, too. Starts at $10,000 per year and goes up from there.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>hth,</DIV><DIV>Brad</DIV><BR><DIV><DIV>On Feb 2, 2007, at 2:29 PM, Rob Tester wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"> <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 [<A href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</A>] <B>On Behalf Of </B>Stone, Matthew (DHS-HISP)<BR> <B>Sent:</B> Friday, February 02, 2007 1:15 PM<BR> <B>To:</B> <A href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><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><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">postgis-users mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV> </BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>