[postgis-users] Remove a geometry from a multi feature

[Stephen Crawford]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users