ST_Is3D

Determine if the geometry is 3 dimensional, that is, if it not only x and y, but also z coordinates.

Syntax

ST_Is3D(geo);
geo
The input geometry.

Type: VARCHAR(ANY)

Returns

A value of type BOOL that is TRUE if the geometry has x, y, and z coordinates; otherwise FALSE.

Examples

SELECT inza..ST_Is3D(inza..ST_WKTToSQL('LINESTRING (0 0, 11 0, 11 11, 0 0))'));
 
ST_IS3D
---------
f
(1 row)
SELECT inza..ST_Is3D(inza..ST_WKTToSQL('LINESTRING (0 0 0, 11 0 5, 11 11 9, 0 0 0))'));
 
ST_IS3D
---------
t
(1 row)
SELECT inza..ST_Is3D(inza..ST_POINT(0.0, 1.0, 2.0, 3.0));

ST_IS3D
---------
t
(1 row)