[postgis-users] geocoder

Dan Davis DanWDavis at ij.net
Tue Oct 5 08:16:27 PDT 2004


Has anyone seen a geocoder which uses more reliable data than Tiger such as
MSAG?

DD

----- Original Message ----- 
From: "David Bitner" <bitner at macnoise.com>
To: <postgis-users at postgis.refractions.net>
Sent: Tuesday, September 28, 2004 4:34 PM
Subject: [postgis-users] geocoder


> Has anybody out there created a geocoder function in pl/sql for use with
> postgis?  I don't want to reinvent the wheel if anyone has done this, and
if
> nobody has done this, I would love to get any pointers on how best to
start.
>
> Completely within postgis I would like to be able to use a function like:
> select geocode("5555 Address Ave, Minneapolis, MN 55555") from streets_db
> or
> select * from geocode("...",streets_db)
> The return should be a temporary table with rows ranked by likelihood
> containing interpolated point location, the geometry of the line segment
> section, and the component parts of the address itself in a normalized
form
> (av gets changed to ave).
>
> Using php and mapserver, I have implemented a ragtag geocoder, but I think
> that it would be a much cleaner and easier approach to do the address
> normalization and the scoring completely within pl/sql.  Problem is, I
have
> no programming experience with pl/sql -- not to say that I'm not ready to
> get my hands dirty.
>
> Thanks,
> David
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>





More information about the postgis-users mailing list