[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