This SQL element is a shortcut for the User Defined Method SQL element with the User Defined Type field set to MBB (Minimum Bounding Box). An MBB defines the minimum sized box that can surround a three-dimensional geometric object. Selecting this element will display a listing of methods for the MBB type, described in the following table.
Function | Description |
---|---|
Constructor Method(s) | Returns an MBB value. |
INTERSECTS | Tests if an MBB value spatially intersects another value of the same data type. |
XMIN | Returns the minimum x coordinate value of an MBB. This is the x coordinate of the lower left front corner. |
YMIN | Returns the minimum y coordinate value of an MBB. This is the y coordinate of the lower left front corner. |
ZMIN | Returns the minimum z coordinate value of an MBB. This is the z coordinate of the lower left front corner. |
XMAX | Returns the maximum x coordinate value of an MBB. This is the x coordinate of the upper right back corner. |
YMAX | Returns the maximum y coordinate value of an MBB. This is the y coordinate of the upper right back corner. |
ZMAX | Returns the maximum z coordinate value of an MBB. This is the z coordinate of the upper right back corner. |
This feature requires Teradata 15.00 or later.