Return Value - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ Geospatial Data Types

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

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.