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