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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms