My Oracle Support Banner

SDO_GEOM.SDO_MBR value less then SDO_GEOM.SDO_AREA on Geodetic Coordinate System (Doc ID 1308784.1)

Last updated on JUNE 27, 2011

Applies to:

Oracle Spatial - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms


When comparing the area of a certain sdo_geometry with the area of the MBR (minimum bounding rectangle) of the same sdo_geometry, on Geodetic Coordinate System (i.e. SRID:8307), it is observed that the latter is smaller.

SELECT
     SDO_GEOM.SDO_AREA(x.shape, 0.05) area,
     SDO_GEOM.SDO_AREA(SDO_GEOM.SDO_MBR(x.shape), 0.05) area_mbr
FROM cola_markets x;


AREA        AREA_MBR
----------  ----------
12264828.9  12263446.3

--> AREA_MBR < AREA


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.