Guest User

Untitled

a guest
Oct 21st, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. SELECT id, ST_Collect(ST_MakePolygon(geom)) As geom
  2. FROM (
  3. SELECT gid, ST_ExteriorRing((ST_Dump(geom)).geom) As geom
  4. FROM layer
  5. ) s
  6. GROUP BY id
  7.  
  8. select geom,st_area(geom)/43560 acres from(
  9. select (st_dumprings((st_dump(shape)).geom)).geom geom
  10. from agriculture.agricultural_grtr_250) t
  11. where st_area(geom)/43560 > .1
  12.  
  13. WITH rings AS (
  14. SELECT id, (ST_DumpRings((st_dump(shape)).geom)).geom
  15. FROM agriculture.agricultural_grtr_250
  16. )
  17. SELECT id,ST_BuildArea(ST_Collect(geom)) geom
  18. from rings
  19. WHERE ST_Area(geom)/43560 > .1
  20. GROUP BY id;
Add Comment
Please, Sign In to add comment