<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:10pt">Thanks a lot Rémi-C. It works.<br><br>after windows function I need to deaggreagte non-intersected polygons with the same parcel_id and Coverage_type.<br>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?<br><br>Cheers,<br>Many<br><div><span><br></span></div><div style="display: block;" class="yahoo_quoted"> <br> <br> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 10pt;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> On Tuesday, March 4, 2014 10:59 AM,
Rémi Cura <remi.cura@gmail.com> wrote:<br> </font> </div> <div class="y_msg_container"><div id="yiv7290230014"><div><div dir="ltr"><div><div><div><br clear="none"></div>Hey,<br clear="none"></div><div><br clear="none"></div><div>you could use postgres windows function and group by on parcel_id, coverage_id.<br clear="none"></div><div><br clear="none"></div><div>If using Union, overlapping polygons while be merged, and non overlapping will only be grouped into multi or geom collection.<br clear="none">
</div><div>You might struggle to keep the id.<br clear="none"></div><div><br clear="none"></div><div>Cheers,<br clear="none">Rémi-C<br clear="none"></div></div><br clear="none"></div><div class="yiv7290230014gmail_extra"><br clear="none"><br clear="none"><div class="yiv7290230014gmail_quote">2014-03-03 22:52 GMT+01:00 mane moshref <span dir="ltr"><<a rel="nofollow" shape="rect" ymailto="mailto:many_yammy@yahoo.com" target="_blank" href="mailto:many_yammy@yahoo.com">many_yammy@yahoo.com</a>></span>:<br clear="none">
<blockquote class="yiv7290230014gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="yiv7290230014yqt6539076098" id="yiv7290230014yqt68299"><div><div style="font-size:10pt;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;">Hi all,<br clear="none">
<br clear="none">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?<br clear="none">
<br clear="none">I appreciate your advice in advance<br clear="none">Many<br clear="none"><div><br clear="none"></div></div></div></div><br clear="none">_______________________________________________<br clear="none">
postgis-users mailing list<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:postgis-users@lists.osgeo.org" target="_blank" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br clear="none"></blockquote></div><br clear="none"></div></div></div><br><br></div> </div> </div> </div> </div></body></html>