Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. SELECT t.territory,
  2. st_expand(t.bbox, ((st_ymax((t.bbox)) - st_ymin((t.bbox))) * (0.1))) AS geom
  3. FROM
  4. (SELECT
  5. parcellayer.id,
  6. st_envelope(st_union(parcellayer.geom,
  7. (SELECT pointlayer.geom FROM pointlayer LIMIT 1))
  8. ) AS bbox
  9. FROM parcellayer) t;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement