COLLECTION is a superset that includes all other types. Geometry is a heterogeneous collection of elements. In a three-dimensional polygon, all points must be on the same plane. Geometry contains one polygon with or without holes, Foot 1 or one surface consisting of one or more polygons. (LINE and CURVE are synonymous in this context.) Geometry contains one line string that can contain straight or circular arc segments, or both. The Geometry Type and Description values reflect the OGIS specification. Table 2-1 shows the valid SDO_GTYPE values. TT identifies the geometry type (00 through 09, with 10 through 99 reserved for future use). For information about the linear referencing system (LRS), see Linear Referencing System. For a non-LRS geometry, or to accept the Spatial and Graph default of the last dimension as the measure for an LRS geometry, specify 0. L identifies the linear referencing measure dimension for a three-dimensional linear referencing system (LRS) geometry, that is, which dimension (3 or 4) contains the measure value. The SDO_GTYPE value is 4 digits in the format DLTT, where:ĭ identifies the number of dimensions (2, 3, or 4) The numeric values differ from those given in the OGIS specification, but there is a direct correspondence between the names and semantics where applicable. Valid geometry types correspond to those specified in the Geometry Object Model for the OGIS Simple Features for SQL specification (with the exception of Surfaces). The SDO_GTYPE attribute indicates the type of the geometry. Oracle Spatial and Graph Topology Data Model and Network Data Model Graph Developer's Guide describes data types for the Oracle Spatial and Graph topology data model. Oracle Spatial and Graph GeoRaster Developer's Guide describes data types for Oracle Spatial and Graph GeoRaster.
Some Spatial and Graph data types are described in locations other than this section:ĭata Types for Geocoding describes data types for geocoding. These methods are described in SDO_GEOMETRY Methods. The SDO_GEOMETRY object type has methods that provide convenient access to some of the attributes. The sections that follow describe the semantics of each SDO_GEOMETRY attribute, and then describe some usage considerations ( Usage Considerations). Oracle Spatial and Graph also defines the SDO_POINT_TYPE, SDO_ELEM_INFO_ARRAY, and SDO_ORDINATE_ARRAY types, which are used in the SDO_GEOMETRY type definition, as follows: CREATE TYPE sdo_point_type AS OBJECT (ĬREATE TYPE sdo_elem_info_array AS VARRAY (1048576) of NUMBER ĬREATE TYPE sdo_ordinate_array AS VARRAY (1048576) of NUMBER īecause the maximum SDO_ORDINATE_ARRAY size is 1,048,576 numbers, the maximum number of vertices in an SDO_GEOMETRY object depends on the number of dimensions per vertex: 524,288 for two dimensions, 349,525 for three dimensions, and 262,144 for four dimensions. Oracle Spatial and Graph defines the object type SDO_GEOMETRY as: CREATE TYPE sdo_geometry AS OBJECT ( Tables of this sort are sometimes referred to as spatial tables or spatial geometry tables. Any table that has a column of type SDO_GEOMETRY must have another column, or set of columns, that defines a unique primary key for that table. With Spatial and Graph, the geometric description of a spatial object is stored in a single row, in a single column of object type SDO_GEOMETRY in a user-defined table.