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: [EMAIL PROTECTED] 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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users


<<winmail.dat>>

Attachment: PGP.sig
Description: PGP signature

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to