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 <[email protected]> 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 <[email protected]>:
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
>[email protected]
>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
