<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73">
<TITLE>Re: [postgis-users] Re: Status of geocoding functions in PostGIS?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hi Mark,</FONT>
</P>
<P><FONT SIZE=2>Something outside of the US and Canada would be great. The Jamaica </FONT>
<BR><FONT SIZE=2>file works, the Trinidad and Tobago doesn't. Without address ranges a </FONT>
<BR><FONT SIZE=2>traditional postal address geocoder needs that information to function.</FONT>
</P>
<P><FONT SIZE=2>In terms of collaborating with Paul Smith and the PostGIS geocoder </FONT>
<BR><FONT SIZE=2>project, I think it makes perfect sense. After the response I made to </FONT>
<BR><FONT SIZE=2>Steve Woodbridge's post this morning, I kicked myself for not </FONT>
<BR><FONT SIZE=2>explicitly indicating that the group which is the natural one to </FONT>
<BR><FONT SIZE=2>mutually provide helping hands to one another in developing a library </FONT>
<BR><FONT SIZE=2>to create a Postgres stored procedure of postal address geocoding.</FONT>
</P>
<P><FONT SIZE=2>Dan</FONT>
</P>
<P><FONT SIZE=2>On 31-Mar-06, at 7:01 PM, Mark Thomas wrote:</FONT>
</P>
<P><FONT SIZE=2>> Dan,</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> I have access to a spatial road network for Jamaica and a partial </FONT>
<BR><FONT SIZE=2>> road network (no street numbers) for trinidad & tobago, so perhaps </FONT>
<BR><FONT SIZE=2>> the structures of these addresses would be helpful to you. I'm </FONT>
<BR><FONT SIZE=2>> afraid I cannot release the data as it belongs to the Jamaican and </FONT>
<BR><FONT SIZE=2>> Trinidad governments, respectively, but I could copy the structure </FONT>
<BR><FONT SIZE=2>> of the shapefiles for you. I would also like to look into helping </FONT>
<BR><FONT SIZE=2>> out on your project and possibly Paul's as well. I think this </FONT>
<BR><FONT SIZE=2>> would be a good opportunity to join the two projects and begin </FONT>
<BR><FONT SIZE=2>> collaborating with each other to speed up development.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> I also have extensive experience in reverse geocoding and am </FONT>
<BR><FONT SIZE=2>> looking into writing a country agnostic reverse geocoder. I have </FONT>
<BR><FONT SIZE=2>> implemented this in Java and PL/SQL for Oracle Spatial for the US </FONT>
<BR><FONT SIZE=2>> so far, but I am considering porting it to PostGIS; however, the </FONT>
<BR><FONT SIZE=2>> major roadblock for me is the lack of a nearest neighbor query </FONT>
<BR><FONT SIZE=2>> function in PostGIS. If anyone knows of an implementation please </FONT>
<BR><FONT SIZE=2>> let me know as the migration from PL/SQL to PL/PGSQL would be quite </FONT>
<BR><FONT SIZE=2>> trivial at that point.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Mark Thomas</FONT>
<BR><FONT SIZE=2>> Sun Certified Java 5 Programmer</FONT>
<BR><FONT SIZE=2>> Sun Certified Java 2 Programmer</FONT>
<BR><FONT SIZE=2>> Sun Certified Web Component Developer</FONT>
<BR><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> postgis-users mailing list</FONT>
<BR><FONT SIZE=2>> postgis-users@postgis.refractions.net</FONT>
<BR><FONT SIZE=2>> <A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users" TARGET="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></FONT>
</P>
</BODY>
</HTML>