ST_Intersects

ST_Intersects takes two geometry columns and returns a boolean column. The function returns True if the first geometry and the second geometry spatially intersect; otherwise, it returns False.

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.

For more details, go to the GeoAnalytics for Microsoft Fabric API reference for intersects.

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

Examples

1
2
3
4
5
6
7
8
9
10
11

from geoanalytics_fabric.sql import functions as ST, Linestring, Polygon

data = [
    (Polygon([[[0,0],[10,10],[20,0]]]), Linestring([[[5,2],[20,20]]])),
    (Polygon([[[0,0],[10,10],[20,0]]]), Linestring([[[30,40],[32,43]]])),
]

df = spark.createDataFrame(data, ["polygon", "linestring"])

df.select(ST.intersects("polygon", "linestring").alias("intersects")).show()

1
2
3
4
5
6
+----------+
|intersects|
+----------+
|      true|
|     false|
+----------+

Version table

Related topics

• SQL functions
• ST_EnvIntersects
• Data sources
• Coordinate systems and transformations