Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sql := 'SELECT DISTINCT ON (seq)
- seq, id, the_geom, id1 AS node, id2 AS edge, cost, km
- FROM pgr_dijkstra(''
- SELECT id,
- source::integer,
- target::integer,
- my_cost::double precision AS cost,
- FROM network
- WHERE network.the_geom && bbox
- '',' || source || ',' || target || ', false, false),
- network WHERE id2 = network.id';
- sql := 'SELECT DISTINCT ON (seq)
- seq, id, the_geom, id1 AS node, id2 AS edge, cost, km
- FROM pgr_dijkstra(''
- SELECT id,
- source::integer,
- target::integer,
- my_cost::double precision AS cost,
- my_reverse_cost::double precision AS reverse_cost
- FROM network
- WHERE network.the_geom && bbox
- '',' || source || ',' || target || ', false, false),
- network WHERE id2 = network.id';
Add Comment
Please, Sign In to add comment