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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users