snowflake.snowpark.functions.st_intersects

snowflake.snowpark.functions.st_intersects(geography_or_geometry_expression_1: Union[snowflake.snowpark.column.Column, str], geography_or_geometry_expression_2: Union[snowflake.snowpark.column.Column, str]) → Column[source]

Returns True if the two GEOGRAPHY or GEOMETRY objects intersect (i.e. have any points in common), False otherwise.

Parameters:

  • geography_or_geometry_expression_1 (ColumnOrName) – A column containing GEOGRAPHY or GEOMETRY objects or a column name.

  • geography_or_geometry_expression_2 (ColumnOrName) – A column containing GEOGRAPHY or GEOMETRY objects or a column name.

Returns:

A column of boolean values indicating whether the two geography objects intersect.

Return type:

Column

Examples::
>>> from snowflake.snowpark.functions import to_geography
>>> df = session.create_dataframe([
...     ["POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))", "POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))"],
...     ["POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))", "POLYGON((2 2, 3 2, 3 3, 2 3, 2 2))"]
... ], schema=["geog1", "geog2"])
>>> df.select(st_intersects(to_geography(df["geog1"]), to_geography(df["geog2"])).alias("intersects")).collect()
[Row(INTERSECTS=True), Row(INTERSECTS=False)]