Name
ST_ZMin — Returns the minimum Z of the geometry bounding box.
Synopsis
double ST_ZMin(bytea
Geometry);
Description
Returns the minimum Z of the geometry bounding box.
Coordinate Dimensions
| 2D | 3D | M |
|---|---|---|
 | | |
Spatial Standards Support
| OGC SFS for SQL. 1.1 (1999) | OGC SFS for SQL. 1.1.0 (2005) | OGC SFS for SQL. 1.2.0 (2006) | SQL-MM Part 3 |
|---|---|---|---|
| - | - | - | - |
Examples
SELECT ST_AsText(Box3D(ST_GeomFromText('LINESTRING (1 1 -5, 2 3 10, 3 2 5, 4 4 0)')));
--Result
POLYGON ((1 1 -5, 1 4 10, 4 4 10, 4 1 -5, 1 1 -5))
SELECT ST_ZMin(Box3D(ST_GeomFromText('LINESTRING (1 1 -5, 2 3 10, 3 2 5, 4 4 0)')));
--Result
-5.0
SELECT ST_ZMin(ST_GeomFromText('LINESTRING (1 1 -5, 2 3 10, 3 2 5, 4 4 0)'));
--Result
-5.0