[postgis-users] Re: Status of geocoding functions in PostGIS?

Putler, Dan Dan.Putler at sauder.ubc.ca
Fri Mar 31 20:07:43 PST 2006

Hi Mark,

Something outside of the US and Canada would be great. The Jamaica  
file works, the Trinidad and Tobago doesn't. Without address ranges a  
traditional postal address geocoder needs that information to function.

In terms of collaborating with Paul Smith and the PostGIS geocoder  
project, I think it makes perfect sense. After the response I made to  
Steve Woodbridge's post this morning, I kicked myself for not  
explicitly indicating that the group which is the natural one to  
mutually provide helping hands to one another in developing a library  
to create a Postgres stored procedure of postal address geocoding.


On 31-Mar-06, at 7:01 PM, Mark Thomas wrote:

> Dan,
> I have access to a spatial road network for Jamaica and a partial  
> road network (no street numbers) for trinidad & tobago, so perhaps  
> the structures of these addresses would be helpful to you.  I'm  
> afraid I cannot release the data as it belongs to the Jamaican and  
> Trinidad governments, respectively, but I could copy the structure  
> of the shapefiles for you.  I would also like to look into helping  
> out on your project and possibly Paul's as well.  I think this  
> would be a good opportunity to join the two projects and begin  
> collaborating with each other to speed up development.
> I also have extensive experience in reverse geocoding and am  
> looking into writing a country agnostic reverse geocoder.  I have  
> implemented this in Java and PL/SQL for Oracle Spatial for the US  
> so far, but I am considering porting it to PostGIS; however, the  
> major roadblock for me is the lack of a nearest neighbor query  
> function in PostGIS.  If anyone knows of an implementation please  
> let me know as the migration from PL/SQL to PL/PGSQL would be quite  
> trivial at that point.
> Mark Thomas
> Sun Certified Java 5 Programmer
> Sun Certified Java 2 Programmer
> Sun Certified Web Component Developer
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060331/405af9a5/attachment.html>

More information about the postgis-users mailing list