[postgis-users] Nearest linestring given a point, a tolerance and a set of linestrings?

[Michael.Scholz at dlr.de]

Hey! What about ST_ClosestPoint (http://postgis.refractions.net/documentation/manual-2.0/ST_ClosestPoint.html)?

Greets, Michi

> -----Ursprüngliche Nachricht-----
> Von: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> bounces at lists.osgeo.org] Im Auftrag von Stefan Keller
> Gesendet: Mittwoch, 23. Januar 2013 03:25
> An: PostGIS Users Discussion
> Betreff: [postgis-users] Nearest linestring given a point, a tolerance and a set
> of linestrings?
> 
> What is the nearest interpolated point on a linestring given a single point, a
> tolerance (say 100m) and a set of linestrings (i.e. a table called myways with
> linestring geometry column); return way/linestring id and distance?
> 
> It's a use case similar to snapping or to a navigation system where you have a
> point and a set of lines.
> 
> I found hints to ST_Line_Interpolate_Point and ST_Line_Locate_Point but
> theses posts/blogs are rather outdated and I'm not sure if KNN index would
> do the job better?
> 
> - S.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users