카테고리:: 지리 공간 함수

ST_INTERSECTS¶

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

참고

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

참고 항목:: ST_DISJOINT

구문¶

ST_INTERSECTS( <geography_expression_1> , <geography_expression_2> )

ST_INTERSECTS( <geometry_expression_1> , <geometry_expression_2> )

인자¶

geography_expression_1: GEOGRAPHY 오브젝트입니다.
geography_expression_2: GEOGRAPHY 오브젝트입니다.
geometry_expression_1: A GEOMETRY object.
geometry_expression_2: A GEOMETRY object.

반환¶

BOOLEAN.

Usage Notes¶

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

예¶

GEOGRAPHY Examples¶

이는 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¶

이는 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                                                 |
+------------------------------------------------------+