Advertisement
Guest User

Untitled

a guest
Dec 7th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. $1 = source
  2. $2 = target
  3. $3 = k
  4. $4 = directed
  5.  
  6. SELECT
  7. *
  8. FROM
  9. pgr_ksp(
  10. 'SELECT id, source, target, cost, reverse_cost FROM osm_2po_4pgr',$1, $2, $3,
  11. directed:=$4)
  12.  
  13. SELECT
  14. *
  15. FROM
  16. pgr_ksp(
  17. 'SELECT id, source, target, cost, reverse_cost FROM osm_2po_4pgr as r,
  18. (SELECT ST_Expand(ST_Extent(geom_way),4) as box FROM osm_2po_4pgr as l1
  19. WHERE l1.source = ' || $1 || ' OR l1.target = ' || $2 || ') as box
  20. WHERE r.geom_way && box.box',$1, $2, $3, directed:=$4
  21. )
  22.  
  23. SELECT
  24. *
  25. FROM
  26. pgr_ksp(
  27. 'SELECT id, source, target, cost, reverse_cost FROM osm_2po_4pgr as r,
  28. (SELECT st_buffer(st_envelope(st_collect(geom_way)), 4) as box FROM osm_2po_4pgr as l1
  29. WHERE l1.source = ' || $1 || ' OR l1.target = ' || $2 || ') as box
  30. WHERE r.geom_way && box.box',$1, $2, $3, directed:=$4
  31. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement