- Kategorien:
ST_DISJOINT¶
Returns TRUE if the two GEOGRAPHY objects or the two GEOMETRY objects are disjoint (i.e. do not share any portion of space). ST_DISJOINT is equivalent to NOT ST_INTERSECTS(expr1, expr2).
Bemerkung
This function does not support using a GeometryCollection or FeatureCollection as input values.
- Siehe auch:
Syntax¶
ST_DISJOINT( <geography_expression_1> , <geography_expression_2> )
ST_DISJOINT( <geometry_expression_1> , <geometry_expression_2> )
Argumente¶
geography_expression_1
Ein GEOGRAPHY-Objekt.
geography_expression_2
Ein GEOGRAPHY-Objekt.
geometry_expression_1
A GEOMETRY object.
geometry_expression_2
A GEOMETRY object.
Rückgabewerte¶
Ein BOOLEAN-Wert.
Usage Notes¶
For GEOMETRY objects, the function reports an error if the two input GEOMETRY objects have different SRIDs.
Beispiele¶
GEOGRAPHY Examples¶
In den folgenden Beispielen wird mithilfe der Funktion ST_DISJOINT ermittelt, ob zwei Geodatenobjekte räumlich getrennt sind:
-- These two polygons are disjoint and do not intersect. SELECT ST_DISJOINT( TO_GEOGRAPHY('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'), TO_GEOGRAPHY('POLYGON((3 3, 5 3, 5 5, 3 5, 3 3))') ); +---------------------------------------------------------+ | ST_DISJOINT( | | TO_GEOGRAPHY('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'), | | TO_GEOGRAPHY('POLYGON((3 3, 5 3, 5 5, 3 5, 3 3))') | | ) | |---------------------------------------------------------| | True | +---------------------------------------------------------+-- These two polygons intersect and are not disjoint. SELECT ST_DISJOINT( TO_GEOGRAPHY('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'), TO_GEOGRAPHY('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))') ); +---------------------------------------------------------+ | ST_DISJOINT( | | TO_GEOGRAPHY('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'), | | TO_GEOGRAPHY('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))') | | ) | |---------------------------------------------------------| | False | +---------------------------------------------------------+