ST_Relate assesses how geometries are related by performing intersection tests of their interiors, boundaries, and exteriors. The relationship between the geometries is then described in a 9-character string in DE-9IM (Dimensionally Extended 9 Intersection Model) format, where each character of the string represents the dimension of the result of an intersection test.

When you use ST_Relate as a predicate, you pass a DE-9IM string reflecting intersection results to test for. If the geometries satisfy the conditions in the DE-9IM string you specified, then ST_Relate returns a 1. If the conditions are not satisfied, then 0 is returned. If either or both of the geometries is NULL, then NULL is returned.

The 9-character DE-9IM string is a flattened representation of a pair-wise matrix of the intersection tests between interiors, boundaries, and exteriors. The next table shows the 9 intersection tests in the order they are performed: left to right, top to bottom:

When you specify the DE-9IM string, you can specify *, 0, 1, 2, T, or F for any of the 9 characters. These values refer to the number of dimensions of the geometry created by the intersection.

Suppose you want to test whether a geometry is within another geometry using ST_Relate and a custom DE-9IM string for the within predicate:

SELECT new ST_Polygon('Polygon(( 2 3, 8 3, 4 8, 2 3 ))').ST_Relate( new ST_Polygon('Polygon((-3 3, 3 3, 3 6, -3 6, -3 3))'), 'T*F**F***' );

This is equivalent to asking ST_Relate to look for the following conditions when performing the intersection tests:

When you execute the query, however, ST_Relate returns 0 indicating that the first geometry is not within the second geometry.

To view the two geometries and compare their appearance to what is being tested, execute the following statement in the Interactive SQL Spatial Viewer (Tools » Spatial Viewer):

SELECT NEW ST_Polygon('Polygon(( 2 3, 8 3, 4 8, 2 3 ))') 
UNION ALL
SELECT NEW ST_Polygon('Polygon((-3 3, 3 3, 3 6, -3 6, -3 3))');

• ST_Relate(ST_Geometry,CHAR(9)) method for type ST_Geometry

The non-predicate use of ST_Relate returns the full relationship between two geometries.

For example, suppose you have the same two geometries used in the previous example and you want to know how they are related. You would execute the following statement in Interactive SQL to return the DE-9IM string defining their relationship.

SELECT new ST_Polygon('Polygon(( 2 3, 8 3, 4 8, 2 3 ))').ST_Relate(new ST_Polygon('Polygon((-3 3, 3 3, 3 6, -3 6, -3 3))'));

ST_Relate returns the DE-9IM string, 212111212.

The matrix view of this value shows that there are many points of intersection:

• ST_Intersects method for type ST_Geometry
• ST_Overlaps method for type ST_Geometry
• ST_Within method for type ST_Geometry
• ST_Disjoint method for type ST_Geometry
• ST_Touches method for type ST_Geometry
• ST_Crosses method for type ST_Geometry
• ST_Contains method for type ST_Geometry
• ST_Relate method for type ST_Geometry
• ST_Relate(ST_Geometry) method for type ST_Geometry