MBB_Filter Method | Geospatial Data Types | Teradata Vantage - 17.10 - MBB_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 MBBs of two 3D geometries spatially intersect.

Valid Data Types

All 3D ST_Geometry types.

Result Type

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

Returns an error if either geometry is not 3D (does not have a z coordinate).