[postgis-users] Removing tiny polygons

[Pierre Racine]

Give a try to ST_TrimMulti() in the PostGIS Add-ons:

http://geospatialelucubrations.blogspot.ca/2013/11/launching-postgis-add-ons-new-postgis.html

https://github.com/pedrogit/postgisaddons/releases/tag/1.21

Pierre

> -----Original Message-----
> From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> bounces at lists.osgeo.org] On Behalf Of Astrid Bjørnerød
> Sent: Tuesday, January 28, 2014 1:19 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Removing tiny polygons
> 
> Is there anyone you have written some sql-code for removing the small
> polygons onto one of the neighbor-polygons ?
> Any stabil functions for this task?
> 
> Astrid
> 
> -----Opprinnelig melding-----
> Fra: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> bounces at lists.osgeo.org] På vegne av Tom McCallum
> Sendt: 27. januar 2014 20:48
> Til: morten at sickel.net; PostGIS Users Discussion
> Emne: Re: [postgis-users] Removing tiny polygons
> 
> Thanks Morten.  I wanted the first case, so that helps.
> 
> On Mon, 27 Jan 2014 19:15:18 -0000, Morten Sickel <morten at sickel.net>
> 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
> >> postgis-users at lists.osgeo.org
> >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> >>
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users