ST_MinZ

ST_MinZ takes a geometry column and returns a double column. The output column contains the minimum z-coordinate of each input geometry. If the input geometry does not have z-coordinates the function will return NaN.

Function	Syntax
Python	`min_z(geometry)`
SQL	`ST_MinZ(geometry)`

For more details, go to the GeoAnalytics Engine API reference for min_z.

Examples

Python

SQL

Use dark colors for code blocksCopy
from geoanalytics.sql import functions as ST

line_json = '{"paths": [[[0, 51, 801, 5],[1, 51, 129, 6],[2, 52, 206, 4]]], "hasM":true, "hasZ":true}'

df = spark.createDataFrame([(line_json,)], ["line_json"]) \
    .withColumn("geometry", ST.line_from_esri_json("line_json"))

df.select(ST.min_z("geometry").alias("min_z")).show()

Result
Use dark colors for code blocksCopy
+-----+
|min_z|
+-----+
|129.0|
+-----+

Version table

Release	Notes
1.0.0	Function introduced

SQL functions
Data sources
Coordinate systems and transformations

ST_MinZ

Examples

Version table

Related topics