Thanks Morten.  I wanted the first case, so that helps.

On Mon, 27 Jan 2014 19:15:18 -0000, Morten Sickel <[email protected]> wrote:

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
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users



_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Reply via email to