Syntax

Teradata Vantageā„¢ Geospatial Data Types

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1181-162K


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.