Order of coordinates affect SDO_AREA for SRID 8307
737784Feb 4 2010 — edited Feb 5 2010I have this strange problem. Coordinates stored in sdo_ordinate_array in this order: 1,2,3,4,1 gives very small difference in area from coordinates stored in this order: 2,3,4,1,2.
The difference in area is approximately in the range of ~0.001 square meters.
Is this a bug? Any way to fix it?
The query to show this problem is
select sdo_geom.sdo_area(polygon,0.5) from dual;
substitute polygon for
sdo_geometry(2003,8307,null,sdo_elem_info_array(1,1003,1),sdo_ordinate_array(
0.07125,-0.000069,
0.048,0.00010,
0.041,-0.000056,
0.068,-0.00014,
0.07125,-0.000069))
gives 43081.7511289923
and
sdo_geometry(2003,8307,null,sdo_elem_info_array(1,1003,1),sdo_ordinate_array(
0.068,-0.00014,
0.07125,-0.000069,
0.048,0.00010,
0.041,-0.000056,
0.068,-0.00014))
gives 43081.7503993156
These 2 geometry are clearly the same. but running sdo_area on them gives different results!
I'm using oracle 10 g release2 10.2.0.4
Any help will be greatly appreciated!
Thanks!