[postgis-users] geocoder

[Howard Butler]

In the interim, you can also get going quite quickly with the 
Geo::Coder::US stuff in CPAN from Schuyler Erle and a copy of the 2003 
Tiger data in geocoder format from my bittorrent link.

http://mapserver.cssm.iastate.edu/geocoder.db.torrent

Howard

At 07:53 PM 9/28/2004, Paul Ramsey wrote:
>We are working on one now, to be used with TIGER data. When we release, we 
>will release the plpgsql, pgsql table dumps, and a mapserver map file for 
>viewing the road data.  More info to come...
>
>Paul
>
>David Bitner wrote:
>>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
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users