Result Rows - Analytics Database - Teradata Vantage

Geospatial Data Types

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-08-30
dita:mapPath
qgk1628112272483.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ghz1472251264557
lifecycle
latest
Product Category
Teradata Vantageā„¢

The columns in the table that Tessellate_Search returns are as follows.

Column Name Data Type Description
out_key DECIMAL(18,0) A copy of the in_key input argument.

The data type of out_key matches the data type of the in_key argument.

VARCHAR(32)
cellid INTEGER The INTEGER value that is returned codes for the cell number and level. The upper 28 bits identifies the cell number, and the lower four bits identifies the level. Use:
cellid  / 16

to derive the cell number and:

cellid  MOD 16

to derive the level.

Cell IDs are numbered from left to right, 0 to n-1, where n = g_nx * g_ny. Cell 0 is in the lower left corner. Here is an example that shows the cell numbering of a single-level grid (of unspecified size) that contains 16 cells.