Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

share|improve this question
You're current acceptance rate is 25%. You might want to accept answers to previous questions, otherwise people won't be as likely to answer new ones. – GeoKevin Oct 2 '12 at 17:36
I have found this thread here which seems to have the same problem as me lists.osgeo.org/pipermail/pgrouting-users/2010-April/… What i don't understand is why the segment is loading in reverse and how can i understand that . Also i can't understand the given solution so a little more detailed explanation would be much apriciated – john Oct 3 '12 at 16:58

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.