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!

Order of coordinates affect SDO_AREA for SRID 8307

737784Feb 4 2010 — edited Feb 5 2010
I 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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2010
Added on Feb 4 2010
4 comments
1,634 views