17.10 - Tessellate UDF Syntax - 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)
SYSSPATIAL.Tessellate (
  in_key, 
  o_xmin, o_ymin, o_xmax, o_ymax
  u_xmin, u_ymin, u_xmax, u_ymax,
  g_nx, g_ny
)

Syntax Elements

in_key
A DECIMAL(18,0) value 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.