st_covers function

Applies to: Databricks SQL Databricks Runtime 17.1 and above

Returns true if the first GEOMETRY value covers the second GEOMETRY value.

Syntax

st_covers ( geoExpr1, geoExpr2 )

Arguments

• geoExpr1: The first GEOMETRY value.
• geoExpr2: The second GEOMETRY value.

Returns

A value of type BOOLEAN, indicating whether the first GEOMETRY value covers the second GEOMETRY value.

The function does not support geometry collections.

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

Error conditions

• If any of the two input geometries is a geometry collection, the function returns ST_INVALID_ARGUMENT.INVALID_TYPE.
• If the two input geometries have different SRID values, the function returns ST_DIFFERENT_SRID_VALUES.

Examples

> SELECT st_covers(st_geomfromtext('POLYGON((0 0,10 0,0 10,0 0))'),st_geomfromtext('POINT(1 1)'));
  true

> SELECT st_covers(st_geomfromtext('POLYGON((0 0,10 0,0 10,0 0))'),st_geomfromtext('POINT(5 0)'));
  true

> SELECT st_covers(st_geomfromtext('POLYGON((0 0,10 0,0 10,0 0))'),st_geomfromtext('POINT(5 6)'));
  false

Related functions

• st_contains function
• st_disjoint function
• st_equals function
• st_intersects function
• st_touches function
• st_within function