Overlaps

Description

Determines if a geometry (testGeometry) object overlaps (shares geometric features) with another geometry (containerGeometry) object of similar type. This operation is for geometries of similar types only. For Example, Points and points, linestrings and linestrings, polygons and polygons.

Syntax

Overlaps ( testGeometry, containerGeometry )

Arguments

containerGeometry and testGeometry are geometry objects (or expressions) with similar types.

Example

Determines if the defined box overlaps any of the specified countries.

select Overlaps(MI_Box(-13.36676789,8.05796847,79.06334219,62.70540978,'epsg:4326'),[Geometry_Column]) from countries where country = ANY ('Mauritania','Mali','Algeria')

Remarks

Returns true if testGeometry overlaps the containerGeometry, false otherwise. The Overlaps operation will return false in cases where the geometries are different types. If either containerGeometry or testGeometry are null, false is returned.