Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT t.territory,
- st_expand(t.bbox, ((st_ymax((t.bbox)) - st_ymin((t.bbox))) * (0.1))) AS geom
- FROM
- (SELECT
- parcellayer.id,
- st_envelope(st_union(parcellayer.geom,
- (SELECT pointlayer.geom FROM pointlayer LIMIT 1))
- ) AS bbox
- FROM parcellayer) t;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement