15.10 - MBR_Filter - Teradata Database

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;