Kategorien:: Geodatenfunktionen

ST_INTERSECTS¶

Returns TRUE if the two GEOGRAPHY objects or the two GEOMETRY objects intersect (i.e. share any portion of space).

Bemerkung

This function does not support using a GeometryCollection or FeatureCollection as input values.

Siehe auch:: ST_DISJOINT

Syntax¶

ST_INTERSECTS( <geography_expression_1> , <geography_expression_2> )

ST_INTERSECTS( <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¶

Das folgende Beispiel zeigt eine einfache Verwendung der Funktion ST_INTERSECTS:

SELECT ST_INTERSECTS(
    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_INTERSECTS(                                          |
|     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))')  |
|     )                                                   |
|---------------------------------------------------------|
| True                                                    |
+---------------------------------------------------------+

GEOMETRY Examples¶

Das folgende Beispiel zeigt eine einfache Verwendung der Funktion ST_INTERSECTS:

SELECT ST_INTERSECTS(
  TO_GEOMETRY('POLYGON((0 0, 0 2, 2 2, 2 0, 0 0))'),
  TO_GEOMETRY('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))')
);

+------------------------------------------------------+
| ST_INTERSECTS(                                       |
|   TO_GEOMETRY('POLYGON((0 0, 0 2, 2 2, 2 0, 0 0))'), |
|   TO_GEOMETRY('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))')  |
| )                                                    |
|------------------------------------------------------|
| True                                                 |
+------------------------------------------------------+