Advertisement
kijato

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

Feb 12th, 2020
478
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1.  
  2. select st_buildarea(st_collect(st_buildarea))
  3. from (
  4. select path_0, st_buildarea(st_collect(geom))
  5. from (
  6. select path path_0, (st_dumprings).path path_1, (st_dumprings).geom
  7. from (
  8. select path,st_dumprings(geom)
  9. from (
  10. select (st_dump).path, (st_dump).geom
  11. from (
  12. select st_dump(st_union)
  13. from (
  14. select st_union(geometria)
  15. from ladanybene.bc_bd
  16. ) d
  17. ) d__p_g
  18. ) dr
  19. ) dr__p_g
  20. where st_area((st_dumprings).geom)>1
  21. ) ba
  22. group by path_0
  23. ) ba_dominium
  24.  
  25.  
  26.  
  27. 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))
  28. from (
  29. select fekves, path_0, st_buildarea(st_collect(geom))
  30. from (
  31. select fekves, path path_0, (st_dumprings).path path_1, (st_dumprings).geom
  32. from (
  33. select fekves, path, st_dumprings(geom)
  34. from (
  35. select fekves, (st_dump).path, (st_dump).geom
  36. from (
  37. select fekves, st_dump(st_union)
  38. from (
  39. select fekves, st_union(geometria)
  40. from orgovany.bc_bd
  41. group by fekves
  42. ) d
  43. ) d__p_g
  44. ) dr
  45. ) dr__p_g
  46. where st_area((st_dumprings).geom)>1
  47. ) ba
  48. group by fekves, path_0
  49. ) ba_dominium
  50. group by fekves
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement