Problem: Unsupported Oracle Spatial geometries
All valid Oracle Spatial geometry objects of supported geometry and entity types are supported except for geometries similar to the one described below.
Occasionally, due to a geometry's configuration, an Oracle Spatial geometry object is invalid as an input to ArcSDE.
The following Oracle Spatial geometry is valid using Oracle Spatial validation, but can not be accessed using ArcGIS.
SDO_ELEM_INFO_ARRAY(1, 1003, 1),
The last three points form a line that crosses back on itself in a Cartesian coordinate system because they all have the same Y value. The final point is in between the two previous points. This creates a zero area inclusion, which is invalid according to Oracle and ArcSDE.
The geometry's coordinate system is a geographic, or geodetic, coordinate system and the points are longitude and latitude values. However, because Oracle Spatial treats lines in a geographic coordinate system as great circle arcs, it doesn't actually form a zero area inclusion. The two lines are different lengths, so the great circles that they define are slightly different and do not overlay each other.
Solution or Workaround
This is a known limit. Although geographic and geodetic distances can be calculated with ArcGIS, there is no way to store data outside of a Cartesian system.
To rectify this problem, the geometry must be changed to remove the included area.
- Which SDO_GEOMETRY feature types are supported by ArcSDE?
- Which Oracle SDO_GEOMETRY geometry types are supported by ArcSDE?
- SDO_Geometry layer does not completely draw due to invalid geometry data in Oracle Spatial layer