ST_Touches takes two geometry columns and returns a boolean column. The function returns True if the first geometry and
the second geometry spatially touch on their boundaries (i.e., their intersection is a single point); otherwise, it returns False.
| Function | Syntax |
|---|---|
| Python | touches(geometry1, geometry2) |
| SQL | ST |
| Scala | touches(geometry1, geometry2) |
For more details, go to the GeoAnalytics Engine API reference for touches.
This function implements the OpenGIS Simple Features Implementation Specification for SQL 1.2.1.
Examples
from geoanalytics.sql import functions as ST
data = [
("POLYGON ((0 0, 0 10, 10 10, 10 0))", "LINESTRING (2 2, 10 10, 20 20)" ),
("POLYGON ((0 0, 0 10, 10 10, 10 0))", "LINESTRING (0 10, 5 15, 10 20)")
]
df = spark.createDataFrame(data, ["poly_wkt", "line_wkt"])\
.withColumn("polygon", ST.poly_from_text("poly_wkt"))\
.withColumn("linestring", ST.line_from_text("line_wkt"))\
.withColumn("touches", ST.touches("polygon", "linestring"))\
.drop("poly_wkt", "line_wkt")
df.show(truncate=False)Result
+-----------------------------------------------+-----------------------------------+-------+
|polygon |linestring |touches|
+-----------------------------------------------+-----------------------------------+-------+
|{"rings":[[[0,0],[0,10],[10,10],[10,0],[0,0]]]}|{"paths":[[[2,2],[10,10],[20,20]]]}|false |
|{"rings":[[[0,0],[0,10],[10,10],[10,0],[0,0]]]}|{"paths":[[[0,10],[5,15],[10,20]]]}|true |
+-----------------------------------------------+-----------------------------------+-------+Version table
| Release | Notes |
|---|---|
1.0.0 | Python and SQL functions introduced |
1.5.0 | Scala function introduced |