- SERIES_SPEC
- The time series passed to the function. The first three fields of the PAYLOAD fields must be as follows:
- Field 1: A column or field which is a timestamp or timestamp with time zone data type. The field represents the arrival time associated with the object being tracked.
- Field 2: A column or field which is a timestamp or timestamp with time zone data type. The field represents the departure time associated with the object being tracked.
- Field 3: A column or field which is a geospatial data type that represents the location of the object being tracked.
Any number of fields may follow the first three fields, and can be any non-LOB data type.
- FUNC_PARAMS
-
Name Data Type Description DISTANCE Integer Indicator to calculate the track distance. A value of 1 means to calculate. A value of 0 means do not calculate. Default value is 0. SPEED Integer Indicator to calculate the average speed with maximum and minimum values. A value of 1 means to calculate. A value of 0 means do not calculate. Default value is 0. TIME_SPENT Integer Indicator to calculate the total time for the trip. A value of 1 means to calculate. A value of 0 means do not calculate. Default value is 0. METRIC Integer Indicator to use metric distance and time. A value of 1 means to use kilometers. A value of 0 means to use miles. Default value is 0. - INPUT_FMT
- No INPUT_FMT options are available for this function.
- OUTPUT_FMT
- No OUTPUT_FMT options are available for this function.