[postgis-users] Deleting an arbitrary polygon

[Bresnahan, Mike]

You could union the polygons. This would not really delete any polygons, but it would result in no overlapping polygons.  See the ST_Union functions for more info.

________________________________

From: postgis-users-bounces at postgis.refractions.net on behalf of Dylan Lorimer
Sent: Wed 9/24/2008 10:50 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Deleting an arbitrary polygon



Hey PostGIS Friends, here's a problem that's stumping me, hoping you can help:

I have a bunch of polygons, many of which overlap with each other. I
would like to trim down the set of polygons to only those that do not
overlap. I'm not particular about which I delete, so long as they
overlap by a certain %.

Any thoughts on how to do this? I was trying for a self join but can't
figure out how to not to delete all polygons that overlap.

Cheers,
dylan
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3926 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080925/67ef6343/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 476 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080925/67ef6343/attachment.pgp>