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

mane moshref many_yammy at yahoo.com
Wed Mar 5 15:51:00 PST 2014

Thanks a lot Rémi-C. It works.

after windows function I need to deaggreagte non-intersected polygons with the same parcel_id and Coverage_type.
I am just wondering to know if any equivalent function in Oracle spatial for "ST_DUMP" (To convert multi-polygons to individual polygons) exists! Do you have experience in Oracle? Have you heard about the function?


On Tuesday, March 4, 2014 10:59 AM, Rémi Cura <remi.cura at gmail.com> wrote:


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.


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
>postgis-users mailing list
>postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140305/9dd2899c/attachment.html>

More information about the postgis-users mailing list