[postgis-users] merge partial intersected polygons in one table

[mane moshref]

Hi all,

I have a table including FID, parcel_id, coverage_id and geom. I want to find those polygons which have a partial intersect with the same parcel_id and coverage_id and union the intersected ones as One polygon. For example if I have 6 polygons with the same parcel_id and coverage_id and two of them have 5% overlap and another two touch their boarder, I expect to have four polygons at the end. how should I make it?

I appreciate your advice in advance
Many
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140303/d7b00a7a/attachment.html>