MBR_Filter Method | Geospatial Data Types | Teradata Vantage - 17.10 - MBR_Filter - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
English (United States)

Tests whether the MBRs of two 2D geometries spatially intersect.

Valid Data Types

All 2D ST_Geometry types.

Although MBR_Filter will accept 3D geometries, the z coordinates are ignored in the calculations.

Result Type

Returns an INTEGER value:
  • 1, if the MBR of the input geometry intersects the MBR of the geometry passed to the method.
  • 0, if the MBR of the input geometry does not intersect the MBR of the geometry passed to the method.