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

Rémi Cura remi.cura at gmail.com
Tue Mar 4 01:59:19 PST 2014


you could use postgres windows function and group by on parcel_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.


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>

More information about the postgis-users mailing list