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.