RES: [postgis-users] Nearest point on line

[Gustavo Henrique Sberze Ribas]

  http://astronomy.swin.edu.au/~pbourke/geometry/pointline/


--
Gustavo

> I want to go a step further though, and determine what exact point on the linestring 
> is closest to the point I have specified.  Basically, I want to know the intersecting
> point on the linestring where the distance from the specified point to the line is 
> smallest.  Thanks in advance for any info that you can provide me.

> Derek Figg