<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16788" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2>Bob,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2>Are you looking to fill in the holes or just exclude
polygons with small holes and that have small areas.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2>Anyrate you should take a look at </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2><A
href="http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html">http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html</A>
(will give you number of holes)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2>ST_InterionRingN</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2><A
href="http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html">http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html</A>
(will give you the holes)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2>Then use ST_BuildArea to convert holes to polygons so you
can take the ST_Area of it. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2><A
href="http://postgis.refractions.net/documentation/manual-svn/ST_BuildArea.html">http://postgis.refractions.net/documentation/manual-svn/ST_BuildArea.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=141060501-31122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><FONT face=Arial color=#0000ff
size=2></FONT><FONT face=Arial color=#0000ff size=2></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Bob
and Deb<BR><B>Sent:</B> Tuesday, December 30, 2008 5:50 PM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> [postgis-users] Help with an area and hole
filter query?<BR></FONT><BR></DIV>
<DIV></DIV>Hello PostGIS Users,<BR><BR>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.<BR><BR>
<DIV><FONT size=2><FONT size=2>Any help or advice would be really
appreciated.</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT size=2>Thanks in
advance.<BR><BR>Bob<BR></FONT></FONT></DIV><BR></BODY></HTML>