New answers tagged pgrouting
1
There is a handy function currently in pgRouting's develop branch coined dijkstraNear. This will help you compute many to many.
pgr_dijkstraNear(Edges SQL, Start vids, End vids [, directed] [, cap], [global])
RETURNS SET OF (seq, path_seq, start_vid, end_vid, node, edge, cost, agg_cost)
OR EMPTY SET
0
You can do some string concatenation
...
SELECT SUM(roads.km)
FROM pgr_dijkstra(
'SELECT id, source, target, cost, reverse_cost FROM roads
(
SELECT ST_Expand(ST_Extent(geom_way), 0.1) as box
FROM roads
WHERE source = (SELECT source FROM roads WHERE id = 923342)
OR target = (SELECT target ...
Top 50 recent answers are included
