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

[Stephen Crawford]

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)."

Thanks,
Steve


Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University