[postgis-users] Distance between an edge and a point

[Stephen Woodbridge]

Supunmali Ahangama wrote:
> I need to find the distance (perpendicular distance) between an edge and a
> point. Please suggest me a function in PostGIS. Can I use distance function?


select ST_distance_sphere(ST_line_interpolate_point(linestring, 
ST_line_locate_point(LineString, Point), Point);

where you have to supply linstring and Point in the above.

-Steve W