> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# ST_Overlaps
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
Given two shapes *A* and *B*, `ST_Overlaps(A, B)` returns `true` if the following criteria are met:
* The shapes share any of the same space -- that is, if any point in the set that comprises *A* is also a member of the set of points that make up *B*.
* Neither of the shapes is contained by the other, in the `ST_Contains` sense.
In other words, `ST_Overlaps` returns `true` if the shapes intersect (in the `ST_Intersects` sense), but neither is contained within the other.
`ST_Overlaps` works on the following spatial data types:
* `GEOMETRY`
\`\` will attempt to use any available spatial index to speed up its operation. Use the prefixed variant `_` if you do not want any spatial indexes to be used.
## Examples
The screenshots in these examples were generated using [geojson.io](http://geojson.io), but they are designed to showcase the shapes, not the map. Representing `GEOMETRY` data in GeoJSON can lead to unexpected results if using geometries with SRIDs other than 4326 (as shown below).
### True
In this example, \`\` returns `true` because:
* There is a Point in the set that comprises Polygon *A* that is also a member of the set of Points that make up Polygon *B*.
* Neither of the shapes is contained by the other, in the `ST_Contains` sense.
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SELECT st_overlaps(st_geomfromtext('SRID=4326;POLYGON((-87.906471 43.038902, -95.992775 36.153980, -75.704722 36.076944, -87.906471 43.038902))'), st_geomfromtext('SRID=4326;POLYGON((-84.191605 39.758949, -75.165222 39.952583, -78.878738 42.880230, -84.191605 39.758949))'));
```
```
st_overlaps
---------------
true
(1 row)
```
### False
In this example, \`\` returns `false` because:
* * There is not any Point in the set that comprises Polygon *A* that is also a member of the set of Points that make up Polygon *B*.
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SELECT st_overlaps(st_geomfromtext('SRID=4326;POLYGON((-79.995888 40.440624,-74.666728 40.358244, -76.5 42.443333, -79.995888 40.440624))'), st_geomfromtext('SRID=4326;POLYGON((-79.976111 40.374444, -74.621157 40.323294, -76.609383 39.299236, -79.976111 40.374444))'));
```
```
st_overlaps
---------------
false
(1 row)
```
## See also
* Spatial and GIS Glossary of Terms
* Spatial indexes
* Spatial functions
* `ST_Covers`
* `ST_CoveredBy`
* `ST_Contains`
* `ST_Within`
* `ST_Intersects`
* `ST_CoveredBy`
* `ST_Covers`
* `ST_Disjoint`
* `ST_Equals`
* `ST_Touches`
* `ST_ConvexHull`
* `ST_Union`
* Migrate from Shapefiles
* Migrate from GeoJSON
* Migrate from GeoPackage
* Migrate from OpenStreetMap
* [Introducing Distributed Spatial Data in CockroachDB](https://www.cockroachlabs.com/blog/spatial-data/) (blog post)