[postgis-users] geo-coding question

Lee Keel lee.keel at uai.com
Wed Jun 27 07:29:28 PDT 2007


  _____  

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070627/de89fb96/attachment.html>


More information about the postgis-users mailing list