List of spatial predicates

The following is a list of predicate methods available for use with spatial data. An X in the Round-Earth column indicates that the method is also supported on round-Earth spatial reference systems. The SQL/MM column reflects compliance with the SQL/MM standard (ISO/IEC 13249-3: 2006).

Method Type Description Round-Earth SQL/MM
ST_Contains method ST_Geometry type

Tests if a geometry value spatially contains another geometry value.

5.1.31
ST_ContainsFilter method ST_Geometry type

An inexpensive test if a geometry might contain another.

Vendor extension
ST_CoveredBy method ST_Geometry type

Tests if a geometry value is spatially covered by another geometry value.

X Vendor extension
ST_CoveredByFilter method ST_Geometry type

An inexpensive test if a geometry might be covered by another.

X Vendor extension
ST_Covers method ST_Geometry type

Tests if a geometry value spatially covers another geometry value.

X Vendor extension
ST_CoversFilter method ST_Geometry type

An inexpensive test if a geometry might cover another.

X Vendor extension
ST_Crosses method ST_Geometry type

Tests if a geometry value crosses another geometry value.

5.1.29
ST_Disjoint method ST_Geometry type

Test if a geometry value is spatially disjoint from another value.

X 5.1.26
ST_Equals method ST_Geometry type

Tests if an ST_Geometry value is spatially equal to another ST_Geometry value.

X 5.1.24
ST_EqualsFilter method ST_Geometry type

An inexpensive test if a geometry is equal to another.

X Vendor extension
ST_Intersects method ST_Geometry type

Test if a geometry value spatially intersects another value.

X 5.1.27
ST_IntersectsFilter method ST_Geometry type

An inexpensive test if the two geometries might intersect.

X Vendor extension
ST_IntersectsRect method ST_Geometry type

Test if a geometry intersects a rectangle.

X Vendor extension
ST_OrderingEquals method ST_Geometry type

Tests if a geometry is identical to another geometry.

X 5.1.43
ST_Overlaps method ST_Geometry type

Tests if a geometry value overlaps another geometry value.

5.1.32
ST_Relate method ST_Geometry type

Tests if a geometry value is spatially related to another geometry value as specified by the intersection matrix. The ST_Relate method uses a 9-character string from the Dimensionally Extended 9 Intersection Model (DE-9IM) to describe the pair-wise relationship between two spatial data items. For example, the ST_Relate method determines if an intersection occurs between the geometries, and the geometry of the resulting intersection, if it exists. See also: How spatial relationships work.

5.1.25, Vendor extension
ST_Touches method ST_Geometry type

Tests if a geometry value spatially touches another geometry value.

5.1.28
ST_Within method ST_Geometry type

Tests if a geometry value is spatially contained within another geometry value.

5.1.30
ST_WithinDistance method ST_Geometry type

Test if two geometries are within a specified distance of each other.

X Vendor extension
ST_WithinDistanceFilter method ST_Geometry type

An inexpensive of whether two geometries might be within a specified distance of each other.

X Vendor extension
ST_WithinFilter method ST_Geometry type

An inexpensive test if a geometry might be within another.

Vendor extension