Ticket #157 (new feature request)

Opened 19 months ago

Shortest path search returns a list unordered cordinates.

Reported by: shafeer Owned by: somebody
Priority: major Milestone: Version 1.1
Component: Dijkstra Version: 1.03
Keywords: Shortest path sequence. Cc:


The reply for ticket #106 (closed feature request: fixed) says: "Done - id field added to the output type. Being sorted by id result becomes ordered." But when I execute

"SELECT * FROM dijkstra_sp('road_network',4352,4052)" ,

the query returns a result set containing id,gid and the_geom. But the id is in the order of the gid which even after sorting returns the same result set. When I use these query to find the direction I get messed up with the order of the Linestrings retrieved from the_geom column since it is not in the order. How can I retrieve the lines in the order. (The id column generated along with this query I guess is just a enumerated value which will not help me out to find the direction.). Can u please explain how the id is generated for "dijkstra_sp()".

Thanks in advance for your reply

Note: See TracTickets for help on using tickets.