Was this helpful?
Three-dimensional Data Types
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/09/2022