Share via


st_x

Important

This feature is in Public Preview.

Returns the X coordinate of the input point geometry, or None if the input point geometry is empty.

For the corresponding Databricks SQL function, see st_x function.

Syntax

from pyspark.databricks.sql import functions as dbf

dbf.st_x(col=<col>)

Parameters

Parameter Type Description
col pyspark.sql.Column or str A Geometry value.

Examples

from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([('POINT(1 2)',)], ['wkt'])
df.select(dbf.st_x(dbf.st_geomfromtext('wkt')).alias('result')).collect()
[Row(result=1.0)]
from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([('POINT ZM (1 2 3 4)',)], ['wkt'])
df.select(dbf.st_x(dbf.st_geomfromtext('wkt')).alias('result')).collect()
[Row(result=1.0)]