# Re: Oracle Spatial - 4D

*From*: Job Miller <jobmiller@xxxxxxxxx>*To*: "ecandrietta@xxxxxxxxx" <ecandrietta@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>*Date*: Wed, 14 Dec 2011 05:45:28 -0800 (PST)

The docs cover it: 2.2.1 SDO_GTYPE The SDO_GTYPE attribute indicates the type of the geometry. 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 numeric values differ from those given in the OGIS specification, but there is a direct correspondence between the names and semantics where applicable. The SDO_GTYPE value is 4 digits in the format dltt, where: * d identifies the number of dimensions (2, 3, or 4) * 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. For a non-LRS geometry, or to accept the Spatial default of the last dimension as the measure for an LRS geometry, specify 0. For information about the linear referencing system (LRS), see Chapter 7. * tt identifies the geometry type (00 through 07, with 08 through 99 reserved for future use). Table 2-1 shows the valid SDO_GTYPE values. The Geometry Type and Description values reflect the OGIS specification. Table 2-1 Valid SDO_GTYPE Values Value Geometry Type Description dl00 UNKNOWN_GEOMETRY Spatial ignores this geometry. dl01 POINT Geometry contains one point. dl02 LINE or CURVE Geometry contains one line string that can contain straight or circular arc segments, or both. (LINE and CURVE are synonymous in this context.) dl03 POLYGON Geometry contains one polygon with or without holes.Foot 1 dl04 COLLECTION Geometry is a heterogeneous collection of elements. COLLECTION is a superset that includes all other types. dl05 MULTIPOINT Geometry has one or more points. (MULTIPOINT is a superset of POINT.) dl06 MULTILINE or MULTICURVE Geometry has one or more line strings. (MULTILINE and MULTICURVE are synonymous in this context, and each is a superset of both LINE and CURVE.) dl07 MULTIPOLYGON Geometry can have multiple, disjoint polygons (more than one exterior boundary). (MULTIPOLYGON is a superset of POLYGON.) Footnote 1 For a polygon with holes, enter the exterior boundary first, followed by any interior boundaries. The d in the Value column of Table 2-1 is the number of dimensions: 2, 3, or 4. For example, an SDO_GTYPE value of 2003 indicates a two-dimensional polygon. Note:The 1-digit SDO_GTYPE values from before release 8.1.6 value are still supported. If a 1-digit value is used, however, Oracle Spatial determines the number of dimensions from the DIMINFO column of the metadata views, described in Section 2.6.3. Also, if 1-digit SDO_GTYPE values are converted to 4-digit values, any SDO_ETYPE values that end in 3 or 5 in the SDO_ELEM_INFO array (described in Section 2.2.4) must also be converted. The number of dimensions reflects the number of ordinates used to represent each vertex (for example, X,Y for two-dimensional objects). Points and lines are considered two-dimensional objects. (However, see Section 7.2 for dimension information about LRS points.) In any given layer (column), all geometries must have the same number of dimensions. For example, you cannot mix two-dimensional and three-dimensional data in the same layer. The following methods are available for returning the individual dltt components of the SDO_GTYPE for a geometry object: Get_Dims, Get_LRS_Dim, and Get_Gtype. These methods are described in Section 2.3. ________________________________ From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx> To: ORACLE-L <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, December 14, 2011 5:39 AM Subject: Oracle Spatial - 4D Hello friends: Does anyone know what is the meaning of 4 in the GTYPE ? 2003 - it is a polygon in 2 dimensions 3003 - it is a polygon in 3 dimensions. and what about 4003 ? Does Oracle Spatial supports it ? There is concept on this ? -- http://www.freelists.org/webpage/oracle-l

**References**:**Oracle Spatial - 4D***From:*Eriovaldo Andrietta

## Other related posts:

- » Oracle Spatial - 4D - Eriovaldo Andrietta
- » Re: Oracle Spatial - 4D - Job Miller