Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select st_buildarea(st_collect(st_buildarea))
- from (
- select path_0, st_buildarea(st_collect(geom))
- from (
- select path path_0, (st_dumprings).path path_1, (st_dumprings).geom
- from (
- select path,st_dumprings(geom)
- from (
- select (st_dump).path, (st_dump).geom
- from (
- select st_dump(st_union)
- from (
- select st_union(geometria)
- from ladanybene.bc_bd
- ) d
- ) d__p_g
- ) dr
- ) dr__p_g
- where st_area((st_dumprings).geom)>1
- ) ba
- group by path_0
- ) ba_dominium
- select case fekves when 1 then 'belterület' when 2 then 'külterület' when 3 then 'zártkert' else 'ismeretlen' end fekves, st_buildarea(st_collect(st_buildarea))
- from (
- select fekves, path_0, st_buildarea(st_collect(geom))
- from (
- select fekves, path path_0, (st_dumprings).path path_1, (st_dumprings).geom
- from (
- select fekves, path, st_dumprings(geom)
- from (
- select fekves, (st_dump).path, (st_dump).geom
- from (
- select fekves, st_dump(st_union)
- from (
- select fekves, st_union(geometria)
- from orgovany.bc_bd
- group by fekves
- ) d
- ) d__p_g
- ) dr
- ) dr__p_g
- where st_area((st_dumprings).geom)>1
- ) ba
- group by fekves, path_0
- ) ba_dominium
- group by fekves
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement