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
