Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/functions/st_contains below:

Website Navigation

• Reference
• Function and stored procedure reference
• Geospatial

ST_CONTAINS | Snowflake Documentation

Returns TRUE if a GEOGRAPHY or GEOMETRY object is completely inside another object of the same type.

More strictly, object g1 contains object g2 if and only if no points of g2 lie in the exterior of g1, and at least one point of the interior of B lies in the interior of A. There are certain subtleties in this definition that are not immediately obvious. For more details on what “contains” means, see the Dimensionally Extended 9-Intersection Model (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).

Note

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

Tip

You can use the search optimization service to improve the performance of queries that call this function. For details, see Search Optimization Service.

See also:

ST_WITHIN , ST_COVERS , ST_COVEREDBY

ST_CONTAINS( <geography_expression_1> , <geography_expression_2> )

ST_CONTAINS( <geometry_expression_1> , <geometry_expression_2> )

Copy

geography_expression_1

A GEOGRAPHY object that is not a GeometryCollection or FeatureCollection.

geography_expression_2

A GEOGRAPHY object that is not a GeometryCollection or FeatureCollection.

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.

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

This shows a simple use of the ST_CONTAINS function:

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))');

Copy

SELECT ST_CONTAINS(g1, g2) 
    FROM geospatial_table_01;
+---------------------+
| ST_CONTAINS(G1, G2) |
|---------------------|
| True                |
+---------------------+

Copy

The query below shows several examples of using ST_CONTAINS. Note how ST_CONTAINS determines that:

• The Polygon contains itself.

• The Polygon does not contain the LineString that is on its border.

  SELECT ST_CONTAINS(poly, poly_inside),
        ST_CONTAINS(poly, poly),
        ST_CONTAINS(poly, line_on_boundary),
        ST_CONTAINS(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);
  

  Copy

  +--------------------------------+------------------------+------------------------------------+-------------------------------+
  | ST_CONTAINS(POLY, POLY_INSIDE) | ST_CONTAINS(POLY,POLY) | ST_CONTAINS(POLY,LINE_ON_BOUNDARY) | ST_CONTAINS(POLY,LINE_INSIDE) |
  |--------------------------------+------------------------+------------------------------------+-------------------------------|
  | True                           | True                   | False                              | True                          |
  +--------------------------------+------------------------+------------------------------------+-------------------------------+
  

  Copy

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4