Tessellate_Search UDF Syntax - 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ā„¢
SYSSPATIAL.Tessellate_Search (
  in_key,
  o_xmin, o_ymin, o_xmax, o_ymax
  u_xmin, u_ymin, u_xmax, u_ymax,
  g_nx, g_ny, levels, scale, shift
)

Syntax Elements

in_key
A DECIMAL(18,0) for a key that is passed back in the result rows to allow joining back to the proper object.
o_xmin, o_ymin, o_xmax, o_ymax
The coordinates of the object rectangle.

The data type of o_xmin, o_ymin, o_xmax, and o_ymax is FLOAT.

u_xmin, u_ymin, u_xmax, u_ymax
The coordinates of the universe of interest.

The data type of u_xmin, u_ymin, u_xmax, and u_ymax is FLOAT.

g_nx, g_ny
The number of grid cells to divide the universe into in the X and Y dimensions.

The data type of g_nx and g_ny is INTEGER.

levels
An INTEGER value for the number of levels in the two-dimensional grid. There are always levels + 1 levels, where level 0 is the entire universe. Higher levels are more granular.

The range of values is 1 to 15.

scale
The scaling factor between grid levels. For example, if g_nx * g_ny is 100x100 and level is 2 and scale is 0.1, you have a 3 level grid (100x100, 10x10, 1x1).

The value of scale must be greater than 0.0 and less than 1.0.

The data type of scale is FLOAT.

shift
An INTEGER value that represents the number of times to shift the grid at each level. If the value of shift is 0, the method performs no shifting. If the value of shift is 1, the method creates four grids for each level, where it shifts each of the four grids in a unique manner.

Shifting the grid helps to avoid assigning smaller spatial objects to large cells if they cross a grid cell boundary.