I have a query which i use to find a route between two points . Even though the route is displayed good on the map the order i get from pgrouting is wrong the query is this one
SELECT rt.gid, ST_AsGeoJSON(rt.the_geom) AS geojson, length(ST_transform(rt.the_geom,3785))as meters,x1,x2,y1,y2,name, ways.gid FROM ways, (SELECT gid, the_geom FROM dijkstra_sp_delta( 'ways', 714, 4807, 0.1) ) as rt WHERE ways.gid=rt.gid;
do you know any way to take the segments of the route in right order ?
Thanks in advance