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

[mane moshref]

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?

Cheers,
Many





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

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/20140305/9dd2899c/attachment.html>