[postgis-users] geo-coding question

[Stephen Woodbridge]

Lee,

The refractions team work a geocoder in pgsql procedures that assumes 
some Tiger data has been loaded. There are occasional requests for help 
on loading data, but I'm not sure if there is an explicit well defined 
procedure for that. I think the PostGIS geocoder was written as a proof 
of concept and I am not aware of anyone using it in a production 
environment. OracleSpatial geocoder is a mature production quality 
geocoder, but it expects Navteq data, or data that can get munged into 
Navteq format.

The difficult part of geocoding is handling address standardization and 
handling fuzzy searching. Once you can standardize the addresses the 
query part is trivial in comparison. Much of the Oracle's geocoder is 
written in Java in their application server.

-Steve


Lee Keel wrote:
> 
> 
> * From: * postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] *On Behalf Of 
> *gisfans gisfans
> *Sent:* Wednesday, June 27, 2007 12:59 AM
> *To:* postgis-users at postgis.refractions.net
> *Subject:* [postgis-users] geo-coding question
> 
>  
> 
> Hello,everyone!
> 
>  
> 
>               Recently I read an introduction about postgis, there are 
> comparsion between oracle and postgis.Both of them support Geo-code,but 
> I don't know how to use external geo-codeing providers?
> 
>  
> 
> thanks,
> 
>  
> 
> gispowerfan
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
> AFAIK geocoding for postgres\postgis is not external.  It is expected to 
> be done through functions within the database against tiger data (See 
> Tiger Geocoder @ http://www.postgis.org/download/).  The problem is that 
> this geocoder was written for a previous version of postgres and does 
> not currently integrate with latest version (8.2.4).  However, it is a 
> good starting point and can be migrated into a very fast and slick 
> geocoder.  You can see what I have done @ 
> http://hud.uai.com/hudpls/ViewMap.aspx?FindAddTI=1.  This website is 
> using Tiger data for the entire US and we are doing a live geocoded 
> search for ease of use.
> 
>  
> 
> I am not sure about geocoding in ORACLE, but I can speak for Sql 
> Server.  The easiest way to do geocoding for Sql Server 2005 is to write 
> your own CLR and have it call some external geocoder see 
> http://www.sqlservercentral.com/columnists/cBunch/geocodingwithsqlserver2005.asp.  
> The other approach is to write your own geocoder using user-defined 
> functions as you would do with postgres\postgis.  I am currently working 
> towards this as well but it is MUCH more difficult.
> 
>  
> 
> As a side note: I APPLAUD the postgres team for making things so easy to 
> work with!!!!!
> 
>  
> 
> Regards,
> 
> Lee Keel
> 
>  
> 
> 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.
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users