15.10 - MBR_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 MBRs of two 2D geometries spatially intersect.

 

Argument …

Specifies …

othergeom

a 2D ST_Geometry.

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.
  • All 2D ST_Geometry types.

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

    INSERT INTO sample_shapes VALUES (1001, 'POINT(10 20)');
    INSERT INTO sample_shapes VALUES (1002, CAST(
     'LINESTRING(1 1, 2 2, 3 3)' AS ST_Geometry));
     
    SELECT shape.MBR_Filter('MultiPoint((10 20), (30 40), (50 60))') 
    FROM sample_shapes;