Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create one polygon from many polygon

Alex.DumskyJun 6 2018 — edited Jun 20 2018

Is there a way to create one polygon from a feature that has many polygons using oracle spatial functions? attached is a picture of many polygons that I would like to have converted to one polygon with just the outline

pastedImage_0.png

I have used SDO_CONCAVEHULL( SDO_AGGR_UNION(SDOAGGRTYPE(geom,0.005)),0.005)) but i get the following polygon with the bad corners:

pastedImage_4.png

Any help would be much appropriated.

Regards,

Alex;

This post has been answered by _jum on Jun 18 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2018
Added on Jun 6 2018
15 comments
2,146 views