MBB Transforms | Geospatial Data Types | Teradata Vantage - 17.10 - Transforms - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
English (United States)

Client applications can use a VARCHAR to insert a value into an MBB column. The VARCHAR must have the following format:

(xmin, ymin, zmin, xmax, ymax, zmax)

where white space can appear anywhere.

For queries that select data from an MBB column, the system returns the MBB data as a VARCHAR(340) using the same format (xmin, ymin, xmax, ymax).

Consider the following definition of a table that defines an MBB column.

CREATE TABLE sample_MBBs (skey INTEGER, shape_mbb MBB);

A query that selects data from the shape_mbr column results in the system returning the column data as a VARCHAR(340):

SELECT *
FROM sample_MBBs;

SKEY          SHAPE_MBB
--------      -------------
1002          (10, 3, 1, 22, 7, 2)