I am hoping to fill in the small holes and remove small areas. I'll read up on these functions and see what I can come up with, but I might need help in making an efficient query since there are over 100K polygons.
Thank you for your help. Bob On Tue, Dec 30, 2008 at 5:15 PM, Paragon Corporation <[email protected]> wrote: > Bob, > > Are you looking to fill in the holes or just exclude polygons with small > holes and that have small areas. > > Anyrate you should take a look at > > > http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html > (will give you number of holes) > > > ST_InterionRingN > > > http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html > (will give you the holes) > > Then use ST_BuildArea to convert holes to polygons so you can take the > ST_Area of it. > > http://postgis.refractions.net/documentation/manual-svn/ST_BuildArea.html > > > > ------------------------------ > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Bob and Deb > *Sent:* Tuesday, December 30, 2008 5:50 PM > *To:* PostGIS Users Discussion > *Subject:* [postgis-users] Help with an area and hole filter query? > > Hello PostGIS Users, > > I have a polygon table that has many small areas and holes. Now, I would > like to remove small areas and holes that are 2800 m^2. > > Any help or advice would be really appreciated. > > Thanks in advance. > > Bob > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
