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

2014-03-04 Thread Rémi Cura
Hey, you could use postgres windows function and group by on parcel_id, coverage_id. If using Union, overlapping polygons while be merged, and non overlapping will only be grouped into multi or geom collection. You might struggle to keep the id. Cheers, Rémi-C 2014-03-03 22:52 GMT+01:00 mane

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

2014-03-03 Thread 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