- 카테고리:
ST_COVERS¶
This returns TRUE if no point in one geospatial object is outside of another geospatial object. In other words:
GEOGRAPHY object
g2
is outside GEOGRAPHY objectg1
.GEOMETRY object
g2
is outside GEOMETRY objectg1
.
ST_COVERS는 ST_CONTAINS와 유사하지만, 미묘하게 다릅니다. 《covers》와 《contains》의 차이점에 대한 자세한 내용은 차원 확장 9-교차 모델(DE-9IM) 을 참조하십시오.
Although ST_COVERS and ST_CONTAINS might seem similar, the two functions have subtle differences. For details on the differences between 《covers》 and 《contains》, see the Dimensionally Extended 9-Intersection Model (DE-9IM).
참고
이 함수는 GeometryCollection 또는 FeatureCollection을 입력 값으로 사용하는 것을 지원하지 않습니다.
- 참고 항목:
구문¶
ST_COVERS( <geography_expression_1> , <geography_expression_2> )
ST_COVERS( <geometry_expression_1> , <geometry_expression_2> )
인자¶
geography_expression_1
GeometryCollection 또는 FeatureCollection이 아닌 GEOGRAPHY 오브젝트입니다.
geography_expression_2
GeometryCollection 또는 FeatureCollection이 아닌 GEOGRAPHY 오브젝트입니다.
geometry_expression_1
A GEOMETRY object that is not a GeometryCollection or FeatureCollection.
geometry_expression_2
A GEOMETRY object that is not a GeometryCollection or FeatureCollection.
반환¶
BOOLEAN.
Usage Notes¶
For GEOMETRY objects, the function reports an error if the two input GEOMETRY objects have different SRIDs.
예¶
GEOGRAPHY Examples¶
이는 ST_COVERS 함수의 간단한 사용법을 보여줍니다.
create table geospatial_table_01 (g1 GEOGRAPHY, g2 GEOGRAPHY); insert into geospatial_table_01 (g1, g2) values ('POLYGON((0 0, 3 0, 3 3, 0 3, 0 0))', 'POLYGON((1 1, 2 1, 2 2, 1 2, 1 1))');SELECT ST_COVERS(g1, g2) FROM geospatial_table_01; +-------------------+ | ST_COVERS(G1, G2) | |-------------------| | True | +-------------------+
GEOMETRY Examples¶
The query below shows several examples of using ST_COVERS. Note how the Polygon covers (but does not contain) a LineString on its border.
SELECT ST_COVERS(poly, poly_inside), ST_COVERS(poly, poly), ST_COVERS(poly, line_on_boundary), ST_COVERS(poly, line_inside) FROM (SELECT TO_GEOMETRY('POLYGON((-2 0, 0 2, 2 0, -2 0))') AS poly, TO_GEOMETRY('POLYGON((-1 0, 0 1, 1 0, -1 0))') AS poly_inside, TO_GEOMETRY('LINESTRING(-1 1, 0 2, 1 1)') AS line_on_boundary, TO_GEOMETRY('LINESTRING(-2 0, 0 0, 0 1)') AS line_inside);+------------------------------+----------------------+----------------------------------+-----------------------------+ | ST_COVERS(POLY, POLY_INSIDE) | ST_COVERS(POLY,POLY) | ST_COVERS(POLY,LINE_ON_BOUNDARY) | ST_COVERS(POLY,LINE_INSIDE) | |------------------------------+----------------------+----------------------------------+-----------------------------| | True | True | True | True | +------------------------------+----------------------+----------------------------------+-----------------------------+