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: * [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of
*gisfans gisfans
*Sent:* Wednesday, June 27, 2007 12:59 AM
*To:* [email protected]
*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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
