ST_Crosses( ST_Geometry ) method

Tests if a geometry value crosses another geometry value.

Syntax

geometry-expression.ST_Crosses( ST_Geometry geo2)

Parameters

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

Returns

BIT Returns 1 if the geometry-expression crosses geo2, otherwise 0. Returns NULL if geometry-expression is a surface or multisurface, or if geo2 is a point or multipoint.

Examples

Example 1 – The following example returns the result 1.

SELECT NEW ST_LineString( 'LineString( 0 0, 2 2 )' )
.ST_Crosses( NEW ST_LineString( 'LineString( 0 2, 2 0 )' ) )

The following examples returns the result 0 because the interiors of the two lines do not intersect (the only intersection is at the first linestring boundary).

SELECT NEW ST_LineString( 'LineString( 0 1, 2 1 )' )
.ST_Crosses( NEW ST_LineString( 'LineString( 0 0, 2 0 )' ) )

The following example returns NULL because the first geometry is a surface.

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

Standards

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