Hi<br> <br>After a while I returned to my work pgrouting. I'm trying to define whether a user should turn right or left with the function azimuth .<br> <br>My problem is: does not work:) I'm doing something wrong.<br>
<br>My query:<br> <br>A-SELECT azimuth(startpoint(the_geom),endpoint(the_geom)) as azimuth from calle where gid = 4390<br>B-SELECT azimuth(startpoint(the_geom),endpoint(the_geom)) as azimuth from calle where gid = 7326<br>
C-SELECT azimuth(startpoint(the_geom),endpoint(the_geom)) as azimuth from calle where gid = 4392<br>D-SELECT azimuth(startpoint(the_geom),endpoint(the_geom)) as azimuth from calle where gid = 4402<br> <br>After obtaining the results:<br>
I compare A con B if the result is <=-1=turn left >=1 tunr right<br>I compare B con C if the result is <=-1=turn left >=1 tunr right<br>I compare C con D if the result is <=-1=turn left >=1 tunr right<br>
<br> <br>can someone please guide me?<br>RG