Catégories :: Fonctions géospatiales

ST_INTERSECTS¶

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

Note

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

Voir aussi :: ST_DISJOINT

Syntaxe¶

ST_INTERSECTS( <geography_expression_1> , <geography_expression_2> )

ST_INTERSECTS( <geometry_expression_1> , <geometry_expression_2> )

Arguments¶

geography_expression_1: Un objet GEOGRAPHY.
geography_expression_2: Un objet GEOGRAPHY.
geometry_expression_1: A GEOMETRY object.
geometry_expression_2: A GEOMETRY object.

Renvoie¶

BOOLEAN.

Usage Notes¶

For GEOMETRY objects, the function reports an error if the two input GEOMETRY objects have different SRIDs.

Exemples¶

GEOGRAPHY Examples¶

Cela montre une utilisation simple de la fonction 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¶

Cela montre une utilisation simple de la fonction 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                                                 |
+------------------------------------------------------+