st_intersects function
Applies to: 
Databricks SQL Databricks Runtime 17.1 and above
Preview
This feature is in Public Preview.
nota
This feature is not available on Databricks SQL Classic warehouses. To learn more about Databricks SQL warehouses, see SQL warehouse types
Returns true if the two geometries intersect.
Syntax
st_intersects ( geo1, geo2 )
Arguments
geo1: AGEOMETRYvalue.geo2: AGEOMETRYvalue.
Returns
A value of type BOOLEAN, true if the two geometries intersect.
For more details on what it means for two geometries to intersect, 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
SQL
-- 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