SDO_GEOM.SDO_MBR Does Not Return Correct Result For Multi-polygon That Cross Antimeridian (Doc ID 1914827.1)

Last updated on AUGUST 06, 2014

Applies to:

Oracle Spatial and Graph - Version 12.1.0.1 and later
Information in this document applies to any platform.

Goal

Why doesn't the SDO_GEOM.SDO_MBR function return a correct MBR for a multi-polygon that crosses the antimeridian?

SQL> select sdo_geom.sdo_mbr(sdo_geometry(2007, 8307, null,
 2 sdo_elem_info_array(1,1003,1, 11,1003,1),
 3 sdo_ordinate_array(-160,70, -179,70, -179,50, -160,50, -160,70,
 4 160,50, 179,50, 179,70, 160,70, 160,50))) as mbr
 5 from dual;

MBR(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
------------------------------------------------------------------------------------------------------
SDO_GEOMETRY(2003, 8307, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(-179, 50, 179, 70))

The expected result should be 160,50,-160,50 for the SDO_ORDINATE_ARRAY in the resulting MBR.
 

Solution

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