forgive me for this newbie question about the distance() function:
i have two lines in the same table (roads)to see the distance between
them the correct sintax is:
select distance(FirstPoint(road l1),FirstPoint (r l2) from road r,
where road.id=1 and r.id=2;
is that correct?
Also there is any function with get the interccection between two
Brenn Erik wrote:
> Yes you can. You can use the PostGIS StartPoint() function to find
> starting point of each line. Then you can feed the start points to
> distance() function.