[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: [postgis] newbie question about distance( )
From: "gispmpf" <gispmpf () yahoo ! com ! br>
Date: 2001-12-06 12:24:00
Message-ID: 9uno10+k9fp () eGroups ! com
[Download RAW message or body]
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
lines?
Thanks
Joćo
Brenn Erik wrote:
> Yes you can. You can use the PostGIS StartPoint() function to find
the
> starting point of each line. Then you can feed the start points to
the
> distance() function.
Right -
distance(FirstPoint(l1), FirstPoint(l2) )
(there's also a LastPoint() function)
dave
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Promise to Quit
Nicotrol will help
http://us.click.yahoo.com/5vN8tD/AqSDAA/ySSFAA/PhFolB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
postgis-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic