ST_CoveredBy( ST_Geometry ) method

Tests if a geometry value is spatially covered by another geometry value.

Syntax

geometry-expression.ST_CoveredBy( ST_Geometry geo2)

geo2 – The other geometry value that is to be compared to the geometry-expression.

BIT Returns 1 if the geometry-expression covers geo2, otherwise 0.

Example 1 – The following example tests if a point is covered by a polygon. The point is completely covered by the polygon so the example returns 1.
```
SELECT NEW ST_Point( 1, 1 )
.ST_CoveredBy( NEW ST_Polygon( 'Polygon(( 0 0, 2 0, 1 2, 0 0 ))' ) )
```
The following example tests if a line is covered by a polygon. The line is completely covered by the polygon so the example returns 1. If ST_Within was used in place of ST_CoveredBy, ST_Within would return 0.
```
SELECT NEW ST_LineString( 'LineString( 0 0, 1 0 )' )
.ST_CoveredBy( NEW ST_Polygon( 'Polygon(( 0 0, 2 0, 1 2, 0 0 ))' ) )
```
The following example lists the ShapeIDs where the given point is within the Shape geometry. This example returns the result 3,5,6. Note that ShapeID 6 is listed even though the point intersects that row's Shape polygon only at the polygon's boundary.
```
SELECT LIST( ShapeID ORDER BY ShapeID )
FROM SpatialShapes
WHERE NEW ST_Point( 1, 4 ).ST_CoveredBy( Shape ) = 1
```

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension