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?