Return Value - 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™

Returns a FLOAT value.

IF you pass in … THEN …
iBegin and iEnd the speed is calculated as the distance between the two points (along the LineString) divided by the time between them.
index if the point is:
  • The first point, the distance between the first and second points is divided by the time between them.
  • The last point, the distance between the second to the last and last points is divided by the time between them.
  • Any other point, the distance between the previous point and the next point (along the LineString) is divided by the time difference between the previous point and the next point.

The units used for distance are the same units that are used by the coordinate system for the GeoSequence value, and the time units are in hours.