15.10 - MBB_Filter - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Tests whether the MBBs of two 3D geometries spatially intersect.

 

Argument …

Specifies …

othergeom

a 3D ST_Geometry.

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

    All 3D ST_Geometry types.

    SELECT shape.MBB_Filter(
     'Polygon((0 0 0, 0 20 20, 20 20 20, 20 0 20, 0 0 0))')
    FROM sample_shapes;