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

Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
ufo1590694251930.ditamap
dita:ditavalPath
ufo1590694251930.ditaval
dita:id
B035-1181
lifecycle
previous
Product Category
Teradata Vantageā„¢

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).