ST_Distance

ST_Distance takes two geometry columns and returns a double column. The output column represents the planar distance between the two input geometries. For multipoints, lines, and polygons, the distance is calculated from the nearest point between the geometries. The result will be in the same units as the input geometry data. For example, if your input geometries are in a spatial reference that uses meters, the result values will be in meters.

If the two geometry columns are in different spatial references, the function will automatically transform the second geometry into the spatial reference of the first.

If your input geometries are in a geographic coordinate system, use ST_GeodesicDistance to calculate distance.

Function	Syntax
Python	`distance(geometry1, geometry2)`
SQL	`ST_Distance(geometry1, geometry2)`

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

This function implements the OpenGIS Simple Features Implementation Specification for SQL 1.2.1.

Examples

Python

SQL

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

data = [
    (Point(-176, -15), Point(-176, -15)),
    (Point(-176, -15), Point(-176, -20)),
    (Point(-176, -15), Point(-175, -15))
]

df = spark.createDataFrame(data, ["point1", "point2"])

df.select(ST.distance("point1", "point2").alias("distance")).show()

Result
Use dark colors for code blocksCopy
+--------+
|distance|
+--------+
|     0.0|
|     5.0|
|     1.0|
+--------+

Version table

Release	Notes
1.0.0	Function introduced

ST_Distance

Examples

Version table

Related topics