[postgis-users] Help with an area and hole filter query?

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081230/810df088/attachment.html>