Three-dimensional Data Types

Geospatial User Guide > Geospatial User Guide > Geospatial Data Types > Three-dimensional Data Types

Was this helpful?

3D data types exist in a three-dimensional coordinate space. The third coordinate can be either:

• An elevation and the data type will end in Z, or

• A measurement and the data type will end in M

The Z and M values are not considered in all geometric calculations or in the generation of some new geometry values. M values are considered when using LRS functions. Each function description indicates whether it supports Z values.

To convert WKT or WKB to an Ingres geometry you have to use the appropriate SQL function. For geometries with a Z coordinate use GeomZFromText and GeomZFromWKB. For geometries with an M coordinate use GeomMFromText and GeomMFromWKB.

3D types include:

• GeometryZ

• GeometryM

• PointZ

• PointM

• LinestringZ

• LinestringM

• PolygonZ

• PolygonM

• MultiLinestringZ

• MultiLinestringM

• MultiPolygonZ

• MultiPolygoM

• GeometryCollectionZ

• GeometryCollectionM

• PolyhedralSurfaceZ

• PolyhedralSurfaceM

• MultiCurveZ

• MultiCurveM

• MultiSurfaceZ

• MultiSurfaceM

• CircularStringZ

• CircularStringM

• CompoundCurveZ

• CompoundCurveM

• CurvePolygonZ

• CurvePolygonM

• TINZ

• TINM

• TriangleZ

• TriangleM

Last modified date: 11/28/2023