Guest User

Untitled

a guest
Jan 20th, 2019
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. sql := 'SELECT DISTINCT ON (seq)
  2. seq, id, the_geom, id1 AS node, id2 AS edge, cost, km
  3. FROM pgr_dijkstra(''
  4. SELECT id,
  5. source::integer,
  6. target::integer,
  7. my_cost::double precision AS cost,
  8. FROM network
  9. WHERE network.the_geom && bbox
  10. '',' || source || ',' || target || ', false, false),
  11. network WHERE id2 = network.id';
  12.  
  13. sql := 'SELECT DISTINCT ON (seq)
  14. seq, id, the_geom, id1 AS node, id2 AS edge, cost, km
  15. FROM pgr_dijkstra(''
  16. SELECT id,
  17. source::integer,
  18. target::integer,
  19. my_cost::double precision AS cost,
  20. my_reverse_cost::double precision AS reverse_cost
  21. FROM network
  22. WHERE network.the_geom && bbox
  23. '',' || source || ',' || target || ', false, false),
  24. network WHERE id2 = network.id';
Add Comment
Please, Sign In to add comment