Database Software

Hi to all,

I have to calculate the intersection area of two polygons, one of which is a circle.

The intersection geometry is wrong because it is made of a semicircle and a line that starts from one vertex of the semicircle.

Moreover the line direction changes at every computation of the intersection area, without any reason.

(Clearly the line doesn't have to be)

My geometries are:

POINT =
SDO_GEOMETRY(3301, 82343, NULL, SDO_ELEM_INFO_ARRAY(1, 1, 1), SDO_ORDINATE_ARRAY(668257,334, 4863107,33, 22,9782043))

BUFFER_on_POINT =
SDO_GEOMETRY(3003, 82343, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 2), SDO_ORDINATE_ARRAY(668257,334, 4863112,33, 0, 668252,334, 4863107,33, 0, 668257,334, 4863102,33, 0, 668262,334, 4863107,33, 0, 668257,334, 4863112,33, 0))

POLYGON =
SDO_GEOMETRY(2003, 82343, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARRAY(668176,189, 4863150,07, 668144,41, 4863095,4, 668180,002, 4863072,51, 668200,34, 4863077,6, 668227,034, 4863062,34, 668265,167, 4863028,02, 668225,763, 4862964,45, 668286,777, 4862927,58, 668308,386, 4862964,45, 668332,537, 4863008,95, 668379,569, 4862984,79, 668378,298, 4862953,01, 668361,773, 4862919,95, 668343,977, 4862928,85, 668312,199, 4862880,54, 668276,608, 4862816,97, 668310,928, 4862802,99, 668320,53, 4862811,13, 668328,608, 4862820,83, 668349,626, 4862853,08, 668393,226, 4862910,51, 668445,785, 4862989,9, 668418,546, 4863004,57, 668334,733, 4863052,79, 668314,478, 4863065,37, 668298,148, 4863076,14, 668270,395, 4863094,44, 668237,14, 4863114,52, 668221,659, 4863123,7, 668217,31, 4863126,5, 668210,953, 4863131, 668207,967, 4863125,91, 668191,063, 4863138,76, 668176,189, 4863150,07))


So when I do 'SDO_GEOM.SDO_AREA(SDO_GEOM.SDO_INTERSECTION(..))' oracle raises the error ORA-13346 (in the subject)

Any idea?

I have also tried with two more simple geometries (a circle and a rectangular) and the error is :
ORA-13050: unable to construct spatial object

Thanks a lot for your help!

Best regards

Anna Zanetti