[postgis-users] Removing tiny polygons

[Morten Sickel]

It depends on what you mean with "remove" - do you want to just have the
large polygons without the area that is covered by the small ones or do
you want to add the area of the small polygons onto one or more of the
larges? (e.g. how one typically wants to handle shiver polygons)

In the first case it is as easy as a query like

select the_geom where ST_area(the_geom) > ...

Morten


Tom McCallum skrev:
> Hi all,
>
> If I have a polygon geometry field which seems to be made up of a large
> number of tiny polygons and some larger ones, what is the best way to
> remove polygons below a certain size?  Would I need to preprocess this and
> save in a new table/record or can I dynamically do it?
>
> Thanks
>
> Tom
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>