[postgis-users] Finding the closest house number on a street

René Fournier m5 at renefournier.com
Sun Oct 16 18:27:49 PDT 2011

Sorry, I wrote too soon. This function appears to be for forward-geocoding (address -> latlng) not reverse.

On 2011-10-14, at 3:02 AM, Paragon Corporation wrote:

> Also you may want to take a look at the tiger helper  function --
> http://trac.osgeo.org/postgis/browser/trunk/extras/tiger_geocoder/tiger_2010/geocode/interpolate_from_address.sql

Well, anyway, so I can find where along the linestring the latlng point lies (beginning 0.0 - 1.0 end). But I have to figure out which side of the line string… Hmm...

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111016/4c4e1f14/attachment.html>

More information about the postgis-users mailing list