ST_Crosses

Crosses

ST_Crosses takes two geometry columns and returns a boolean column. The function returns True if the two geometries cross; otherwise, it returns False. Two geometries cross when their intersection is not empty and is not equal to either of the geometries. The intersection must also have a dimensionality less than the maximum dimension of the two input geometries.

This function is only relevant for the following combinations of geometries:

  • multipoint/linestring
  • multipoint/polygon
  • linestring/polygon
  • linestring/multipoint
  • linestring/linestring
  • polygon/multipoint
  • polygon/linestring

For all other combinations the function will always return 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.

FunctionSyntax
Pythoncrosses(geometry1, geometry2)
SQLST_Crosses(geometry1, geometry2)
Scalacrosses(geometry1, geometry2)

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

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

Examples

PythonPythonSQLScala
1
2
3
4
5
6
7
8
9
10
11

from geoanalytics.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([[[5,2],[9,9]]])),
]

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

df.select(ST.crosses("polygon", "linestring").alias("crosses")).show()
Result
1
2
3
4
5
6
+-------+
|crosses|
+-------+
|   true|
|  false|
+-------+

Version table

ReleaseNotes

1.0.0

Python and SQL functions introduced

1.5.0

Scala function introduced

Your browser is no longer supported. Please upgrade your browser for the best experience. See our browser deprecation post for more details.

You can no longer sign into this site. Go to your ArcGIS portal or the ArcGIS Location Platform dashboard to perform management tasks.

Your ArcGIS portal

Create, manage, and access API keys and OAuth 2.0 developer credentials, hosted layers, and data services.

Your ArcGIS Location Platform dashboard

Manage billing, monitor service usage, and access additional resources.

Learn more about these changes in the What's new in Esri Developers June 2024 blog post.

Close