st_intersects function

Applies to: Databricks SQL Databricks Runtime 17.1 and above

Returns true if the two input GEOMETRY values intersect.

Syntax

st_intersects ( geoExpr1, geoExpr2 )

Arguments

• geoExpr1: A GEOMETRY value.
• geoExpr2: A GEOMETRY value.

Returns

A value of type BOOLEAN, indicating whether the two input GEOMETRY values intersect each other.

For more details and the formal definition, see the Intersects predicate in the DE-9IM matrix definition.

The function returns NULL if any of the inputs is NULL.

Error conditions

• If the input geometries do not have the same SRID value, the function returns ST_DIFFERENT_SRID_VALUES.

Examples

-- Returns true if geometries intersect.
> SELECT st_intersects(st_geomfromtext('POINT(1 1)'),st_geomfromtext('POLYGON((0 0,10 0,0 10,0 0))'));
  true
-- Returns false if geometries do not intersect.
> SELECT st_intersects(st_geomfromtext('POINT(5 6)'),st_geomfromtext('POLYGON((0 0,10 0,0 10,0 0))'));
  false

Related functions

• st_contains function
• st_covers function
• st_disjoint function
• st_equals function
• st_touches function
• st_within function