Syntax - Advanced SQL Engine - Teradata Database

Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
vci1556127188517.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1181
lifecycle
previous
Product Category
Teradata Vantageā„¢
[TD_SYSFNLIB.] GeoSequenceFromRows (
  in_key,
  pcount,
  point_index,
  x,
  y,
  ts,
  Link_id,
  user_fld_1,
  user_fld_2,
  user_fld_3,
  user_fld_4,
  user_fld_5,
  user_fld_6,
  user_fld_7,
  user_fld_8,
  user_fld_9,
  user_fld_10
)
in_key
A key that identifies this GeoSequence type. All points in the same GeoSequence object have the same in_key value.

The data type of in_key is DECIMAL(18,0).

pcount
The number of points in the GeoSequence.

The function produces a result row when it sees pcount rows for the same in_key value.

The data type of pcount is INTEGER.

point_index
The index of this point in the sequence, where the index of the first point is 1.

The data type of point_index is INTEGER.

x,y
The X and Y coordinates of the point.

The data type of x and y is FLOAT.

ts
A timestamp for the point.

The data type of ts is TIMESTAMP.

Link_id
The Link ID of the point.

The data type of Link_id is DECIMAL(18,0).

user_fld_1 to user_fld_10
User fields of data for this point.

The data type of user_fld_1 to user_fld_10 is FLOAT.

A NULL value indicates that the user field is not used.