Tests if an ST_Geometry value spatially overlaps another ST_Geometry value.
|
Argument … |
Specifies … |
|
ageometry |
the other ST_Geometry value. |
Returns an INTEGER value:
ST_Overlaps is valid on all ST_Geometry types, with the exception of geometry collections.
Note: This method can be called on 3D geometries (those that include z coordinates). However, the z coordinate is ignored in method calculations.
Use of a geospatial index can greatly improve the performance of queries that use this method.
SELECT cityName
FROM sample_cities
WHERE cityShape.ST_Overlaps(
NEW ST_Geometry('POLYGON((1 1, 1 3, 6 3, 6 0, 1 1))')) = 1;