Hi Chris You need an inner query that selects the closest line segment and use that geometry in the shortest line query Select shrtest line(p.the_geom,nearestgeom.thegeom) from Points p, Select a.*, st_distance(a.the_geom, b.the_geom) as dist from roads a,points b order by dist asc limit 1) as nearestgeom
Hope this is readable as sending from phone.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
