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!

Compound polygon with mutiple lines and circular arcs.

cosmopolitanAug 1 2012 — edited Aug 3 2012
I am looking to create a compound polygon with multiple lines and arcs using the geodetic co-ordinate system...in an effort to resemble an irregular shape like a US state for example. I did look at the compound polygon shown in the link below which shows a compound polygon that resembles an ice cream cone but i need to have something complex.

http://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_objrelschema.htm#i1005726

In the example below, i don't understand exactly what SDO_ELEM_INFO = (1,1005,2, 1,2,1, 5,2,2)... means how is it calculated?

Also this example just had four co-ordinates, SDO_ORDINATE_ARRAY(6,10, 10,1, 14,10, 10,14, 6,10)

what if i have more lines and circular arcs...can anyone help give a complex example of inserting a compound polygon with multiple lines and arcs and help understand what each and every attribute represents in the example?

Thanks in advance
Ajay
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2012
Added on Aug 1 2012
7 comments
820 views