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

[Bob and Deb]

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 <lr at pcorp.us> 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:* 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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081230/9db5b26a/attachment.html>