|Functions / Geometry Predicate Functions (boolean)|
Determines if the minimum bounding rectangles (MBR) of two geometry objects intersect.
MI_EnvelopesIntersect ( geometry1, geometry2 )
geometry1 and geometry2 are geometry objects (or expressions).
Determines if the minimum bounding rectangles (MBR) of the point and the countries geometry intersect.
select MI_EnvelopesIntersect(MI_Point(-76,45,'epsg:4326'),[Geometry_Column]) from countries where country='Canada'
Returns true if the MBR of geometry1 intersects the MBR of geometry2, false otherwise. If either geometry1 or geometry2 are null, false is returned. The function is performed using the coordinate system of the first argument (geometry1).