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

[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 moshref <many_yammy at 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 at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140304/be7ac9f7/attachment.html>