ST_Z¶

Returns the Z coordinate of the point, or NULL if not available.

Usage¶

double ST_Z(geom: geometry)

Arguments¶

geom (geometry): Input geometry

Description¶

Returns NULL if the geometry has no Z dimension or for non-point geometries.

Examples¶

SELECT ST_Z(ST_PointZ(-74.0060, 40.7128, 100.0));

┌─────────────────────────────────────────────────────────────────┐
│ st_z(st_pointz(Float64(-74.006),Float64(40.7128),Float64(100))) │
│                             float64                             │
╞═════════════════════════════════════════════════════════════════╡
│                                                           100.0 │
└─────────────────────────────────────────────────────────────────┘