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: 01/30/2023