ST_Disjoint method

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

Syntax

geometry-expression.ST_Disjoint(geo2)

Parameters

Name	Type	Description
geo2	ST_Geometry	The other geometry value that is to be compared to the `geometry-expression`.

Returns

BIT
Returns 1 if the geometry-expression is spatially disjoint from geo2, otherwise 0.

Remarks

Tests if a geometry value is spatially disjoint from another value. Two geometries are disjoint if their intersection is empty. In other words, they are disjoint if there is no point anywhere in geometry-expression that is also in geo2."

geometry-expression.ST_Disjoint( geo2 ) = 1 is equivalent to geometry-expression.ST_Intersects( geo2 ) = 0.

Note If the geometry-expression contains circularstrings, then these are interpolated to line strings.

Standards

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

Example

The following example returns a result with one row for each shape that has no points in common with the specified triangle.

SELECT ShapeID, "Description"
FROM SpatialShapes
WHERE NEW ST_Polygon( 'Polygon((0 0, 5 0, 0 5, 0 0))' ).ST_Disjoint( Shape ) = 1
ORDER BY ShapeID

The example returns the following result set:

ShapeID	Description
`1`	`Point`
`22`	`Triangle`