ST_Overlaps( ST_Geometry ) method

Syntax

geometry-expression.ST_Overlaps( ST_Geometry geo2)

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

BIT Returns 1 if the geometry-expression overlaps geo2, otherwise 0. Returns NULL if geometry-expression and geo2 have different dimensions.

Example 1 – The following returns the result 1 since the intersection of the two linestrings is also a linestring, and neither geometry is a subset of the other.
```
SELECT NEW ST_LineString( 'LineString( 0 0, 5 0 )' )
.ST_Overlaps( NEW ST_LineString( 'LineString( 2 0, 3 0, 3 3 )' ) )
```
The following returns the result NULL since the linestring and point have different dimension.
```
SELECT NEW ST_LineString( 'LineString( 0 0, 5 0 )' )
.ST_Overlaps( NEW ST_Point( 1, 0 ) )
```
The following returns the result 0 since the point is a subset of the multipoint.
```
SELECT NEW ST_MultiPoint( 'MultiPoint(( 2 3 ), ( 1 0 ))' )
.ST_Overlaps( NEW ST_Point( 1, 0 ) )
```
The following returns the result 24,25,28,31, which is the list of ShapeIDs that overlap the specified polygon.
```
SELECT LIST( ShapeID ORDER BY ShapeID ) FROM SpatialShapes
WHERE Shape.ST_Overlaps( NEW ST_Polygon( 'Polygon(( -1 0, 0 0, 0 1, -1 1, -1 0 ))' )
) = 1
```

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