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

2009/10/16 Marco Lechner - FOSSGIS e.V. <[email protected]>

> 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
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to