ST_Relate( ST_Geometry ) method

Determines how a geometry value is spatially related to another geometry value by returning an intersection matrix. The ST_Relate method returns 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.

Syntax

geometry-expression.ST_Relate( ST_Geometry geo2)

Parameters

geo2 – The second geometry value that is to be compared to the geometry-expression.

Returns

CHAR_01239321_ Returns A 9-character string representing a matrix in the dimensionally-extended 9 intersection model. Each character in the 9-character string represents the type of intersection at one of the nine possible intersections between the interior, boundary, and exterior of the two geometries.

Examples

Example 1 – The following example returns the result 1F2001102.

SELECT NEW ST_Polygon( 'Polygon(( 0 0, 2 0, 0 2, 0 0 ))' )
.ST_Relate( NEW ST_LineString( 'LineString( 0 1, 5 1 )' ) )

Standards

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension