ST_Is3D() method

Syntax

geometry-expression.ST_Is3D()

Returns

BIT Returns 1 if the geometry value has Z coordinate values, otherwise 0.

Examples

• Example 1 – The following example returns the result 1.

  SELECT ShapeID FROM SpatialShapes WHERE Shape.ST_Is3D() = 1

Standards

SQL/MM (ISO/IEC 13249-3: 2006) 5.1.10