SDO_GEOM.SDO_MBR value less then SDO_GEOM.SDO_AREA on Geodetic Coordinate System
Last updated on JUNE 27, 2011
Applies to:Oracle Spatial - Version: 10.2.0.4
Information in this document applies to any platform.
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.
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_MBR < AREA
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