ST_MinY

ST_MinY takes a geometry column and returns a double column. The output column contains the minimum y-coordinate of each input geometry.

Function	Syntax
Python	`min_y(geometry)`
SQL	`ST_MinY(geometry)`

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

Examples

PythonPythonSQL
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_y("geometry").alias("min_y")).show()

Result
Use dark colors for code blocksCopy
+-----+
|min_y|
+-----+
| 51.0|
+-----+

Version table

Release	Notes
1.0.0	Function introduced

SQL functions
Data sources
Coordinate systems and transformations

ST_MinY

Examples

Version table

Related topics