st_touches function

Applies to: Databricks SQL Databricks Runtime 17.1 and above

Preview

This feature is in Public Preview.

Returns true if the two geometries touch each other.

Syntax

st_touches ( geo1, geo2 )

Arguments

• geo1: The first GEOMETRY value.
• geo2: The second GEOMETRY value.

Returns

A value of type BOOLEAN, true if the two geometries touch each other.

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

Error conditions

• If any of the input geometries is a geometry collection, the function returns ST_INVALID_ARGUMENT.
• If the input geometries do not have the same SRID value, the function returns ST_DIFFERENT_SRID_VALUES.

Examples

SQL

-- Returns false when geometries do not touch.
> SELECT st_touches(st_geomfromtext('LINESTRING(5 0,5 10)'),st_geomfromtext('MULTILINESTRING((0 0,10 10),(0 10,10 0))'));
  false
-- Returns true when geometries touch.
> SELECT st_touches(st_geomfromtext('LINESTRING(5 0,5 5)'),st_geomfromtext('MULTILINESTRING((0 0,10 10),(0 10,10 0))'));
  true

Related functions

• st_intersects function
• st_within function
• st_equals function