Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT id, ST_Collect(ST_MakePolygon(geom)) As geom
- FROM (
- SELECT gid, ST_ExteriorRing((ST_Dump(geom)).geom) As geom
- FROM layer
- ) s
- GROUP BY id
- select geom,st_area(geom)/43560 acres from(
- select (st_dumprings((st_dump(shape)).geom)).geom geom
- from agriculture.agricultural_grtr_250) t
- where st_area(geom)/43560 > .1
- WITH rings AS (
- SELECT id, (ST_DumpRings((st_dump(shape)).geom)).geom
- FROM agriculture.agricultural_grtr_250
- )
- SELECT id,ST_BuildArea(ST_Collect(geom)) geom
- from rings
- WHERE ST_Area(geom)/43560 > .1
- GROUP BY id;
Add Comment
Please, Sign In to add comment