[postgis-users] find nearest point on line where distance to point not on line is minimum - or lets say drop a perpendicular on the nearest line through a given point

[Mehmet Sirin]

hi, i think you're searching this:
http://pgrouting.postlbs.org/wiki/LoadingtheCode4
bye

2009/10/16 Marco Lechner - FOSSGIS e.V. <marco.lechner at fossgis.de>

> hi,
>
> I try to find a way to solve this problem in postgis.
> I have a table with lines an coorindates of a point that needn't to be
> on a line. I try to find
> 1. the id of the line wich is nearest to the point
> 2. get the coordinates of the point on the line which is nearest to the
> point
>
> --------0---------
>        |
>        |
>        X (point X not on line)
>
> 0 is the nearest Point to X on line and therefore the Point i'm
> searching for.
>
> Any hints?
>
> Marco
>
> --
>
> FOSSGIS e.V.
> die unabhängige Hilfe bei freier GIS-Software und freien Geodaten
> www.fossgis.de
>
> +++++++++++++++++++++++++++++++++
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091016/1f9b55ce/attachment.html>