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 a circle of n meters in diameter

FlyingGuyApr 24 2014 — edited Apr 28 2014

Hey Gang,

Its me, again... <sigh>

So as I am plodding along trying to solve various problems I find myself one again at the mercy or oracle's spatial documentation.

I just want to make a circle and do an sdo_anyinteract query.  Sounds simple enough, yes?

<pounds head against desk >

So there is no sdo_circle() function, so I have to construct one. ok fair enough  the only example I can find is this from the "cola" markets examples:

INSERT INTO cola_markets VALUES(

  4,

  'cola_d',

  SDO_GEOMETRY(

  2003, -- two-dimensional polygon

  NULL,

  NULL,

  SDO_ELEM_INFO_ARRAY(1,1003,4), -- one circle

  SDO_ORDINATE_ARRAY(8,7, 10,9, 8,11)

  )

);

I cannot for the life of me figure out what the ordinates are, I have tried changing the numbers all over the place but all I have to view them in is the built in map viewer that comes with sqlDeveloper and as luck would have it, it is broken as far as point values since it draws them at seemingly random sizes.  ( yes I know they are promising BIG improvements ) but that does not help me now.  I got it to work in geoRaptor with a srid:null layer and that proves to be just as inscrutable.

So would someone be so very kind as to educate me?

Cheers.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2014
Added on Apr 24 2014
14 comments
5,714 views