ba+bb-k_felépítése_szak+metsz_nélkül.sql

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