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-boun...@lists.osgeo.org [mailto:postgis-users- > boun...@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-boun...@lists.osgeo.org [mailto:postgis-users- > boun...@lists.osgeo.org] På vegne av Tom McCallum > Sendt: 27. januar 2014 20:48 > Til: mor...@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 <mor...@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@lists.osgeo.org > >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > >> > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@lists.osgeo.org > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users