[pgrouting-dev] wrong order of segments returned from dijkstra

monopolisuop monopolisuop at gmail.com
Thu Oct 4 04:10:25 PDT 2012


Hello everyone

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20121004/8ba29923/attachment.html>


More information about the pgrouting-dev mailing list