Hi,
Is there an efficient to run one to many or many to one routes in spatialite?
I know I can just iterate computing many routes, but with Dijkstra at least for one to many problem all the results should be included in the graph after it is solved.
If not, maybe something like this could be implemented:
select * from graph_net where FromNode=123 and ToNode in (12,23,34,etc);
Then maybe the output might be:
Algorithm|RouteNodeFrom|RouteNodeTo|ArcRowid|NodeFrom|NodeTo|Cost|Geometry|Name
so for the summary line RouteNodeFrom=NodeFrom and RouteNodeTo=NodeTo. and it would be easy to extract any individual route using where RouteNodeFrom=? and RouteNodeTo=?