Thanks, that worked very well.....broke it apart to a temp table, did a COLLECT for the good features, and updated the original table.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Woodbridge Sent: Wednesday, August 15, 2007 2:58 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Remove a geometry from a multi feature Stephen Crawford wrote: > All, > > I have a multipolygon feature that has 12 parts, a couple of which are > "bad". How can I remove just these geometries and keep the rest as > one multi feature? The bad ones are hundreds of miles away from the "good" > ones, so I would like to do something like "remove all geomtries from > feature x that are outside of bounding box (xy,xy)." Basically you can not edit an existing object. The way to solve this problem is to deconstruct the multipolygon in a set of polygons and filter out the ones you want to exclude and then multi the remaining objects back into a multipolygon and store it where ever. -Steve W _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
