[pgrouting-users] sort result
schroeter at netgis.de
Tue Mar 20 08:50:46 EDT 2012
Im playing with Pgrouting using my own routing network (for bicycle) to
navigate from sub-line A to sub-line B:
SELECT rt.gid, AsText(rt.the_geom) AS wkt,
length(rt.the_geom) AS length, routen_sub.id
(SELECT gid, the_geom
) as rt
This works fine but the result geometry of my direction is unsorted. Is
there a possibility to sort the result directly via SQL?
Is it possible to set a "via" point directly in the SQL? With
dijkstra_sp_directed is it only possible to set a start and a endpoint.
More information about the Pgrouting-users