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 moshref <many_ya...@yahoo.com>: > 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 > > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users