[postgis-users] Re: a line's direction

[Amit Kulkarni]

referring to Hartmut Tschauner's post here

http://postgis.refractions.net/pipermail/postgis-users/2005-September/009260.html

I used that function to correctly set the digitized direction of all
road segments for a given road (Thanks Hartmut!). I am hoping somebody
will integrate something like this in the next 1.0.5 (or 1.0.6) release
for general use. This is probably what most people who are checking
roads would run up against.

If its already being done or planned, ignore this message.

(It would be called like this)

to initially check for bad direction and rerun this query afterwards to
doublecheck if everything was done...

SELECT r."ID1", azimuth(startpoint(the_geom), endpoint(the_geom)) as
azimuth, r."ROAD_LABEL" FROM "Roads" as r where r."ROAD_LABEL"=
'FLORIDA BLVD';

to actually run the stored proc, a dummy select

select * from align_direction('FLORIDA BLVD','0');

Thanks in advance




		
__________________________________ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgis_align_direction.sql
Type: text/sql
Size: 1257 bytes
Desc: 506041946-postgis_align_direction.sql
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20051117/314970e2/attachment.bin>