ST_Touches

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_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

Python

SQL

Use dark colors for code blocksCopy
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
Use dark colors for code blocksCopy
+-----------------------------------------------+-----------------------------------+-------+
|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	Function introduced

ST_Touches

Examples

Version table

Related topics