New answers tagged

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