Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.ocient.com/llms.txt

Use this file to discover all available pages before exploring further.

spatiotemporal measurement functions can perform basic calculations on geospatial data that is paired with TIMESTAMP data.

​
ST_DISTANCE

Returns the two-dimensional interpolated minimum simultaneous distance between two LINESTRING-TIMESTAMP array pairs in the specified unit of measurement. If any argument is NULL or empty, the function returns NULL. If either LINESTRING-TIMESTAMP array pair has a mismatched number of points and timestamps, the function returns an error. Behavior is undefined if either timestamp array is not monotonically increasing.
SQL
ST_DISTANCE(geo1, ts_arr1, geo2, ts_arr2, units [, use_spheroid] )
ArgumentData TypeDescription
geo1LINESTRINGA geospatial object to be evaluated for its minimum cotemporal distance from geo2.
ts_arr1TIMESTAMP ARRAYA timestamp array that is paired with geo1.
geo2LINESTRINGA geospatial object to be evaluated for its minimum cotemporal distance from geo1.
ts_arr2TIMESTAMP ARRAYA timestamp array that is paired with geo2.
unitsSTRINGThe unit of measurement used for the minimum cotemporal distance.
Accepted options include 'FEET', 'KILOMETERS', 'MILES', or 'METERS'.
The default value is 'METERS'.
use_spheroidBOOLEANOptional.

If you set this argument to TRUE, this function uses a spheroid model instead of a spherical model.

The default value is FALSE.
Example
SQL
SELECT ST_DISTANCE(
        ST_LINESTRING('linestring(0 0,0 12)'),
        TIMESTAMP [](
            '2020-07-04 07:00:00.000000000',
            '2020-07-04 11:00:00.000000000'),
        ST_LINESTRING('linestring(0 0,6 0)'),
        TIMESTAMP [](
            '2020-07-04 08:00:00.000000000',
            '2020-07-04 10:00:00.00000000'),
        'MILES',
        TRUE);
Output: 206.124
To use ST_DISTANCE as a spatial function to calculate the minimum distance between two points, see the ST_DISTANCE function in the Spatial Measurement section.

​
ST_MAXDISTANCE

Returns the two-dimensional interpolated maximum cotemporal distance between two LINESTRING-TIMESTAMP array pairs in the specified unit of measurement. If any argument is NULL or empty, the function returns NULL. If either LINESTRING-TIMESTAMP array pair has a mismatched number of points and timestamps, the function returns an error. Behavior is undefined if either timestamp array is not monotonically increasing.
SQL
ST_MAXDISTANCE(geo1, ts_arr1, geo2, ts_arr2, units [, use_spheroid] )
ArgumentData TypeDescription
geo1LINESTRINGA geospatial object to be evaluated for its maximum cotemporal distance from geo2.
ts_arr1TIMESTAMP ARRAYA TIMESTAMP ARRAY that is paired with geo1.
geo2LINESTRINGA geospatial object to be evaluated for its maximum cotemporal distance from geo1.
ts_arr2TIMESTAMP ARRAYA TIMESTAMP ARRAY that is paired with geo2.
unitsSTRINGThe unit of measurement used for the maximum cotemporal distance.
Accepted options include 'FEET', 'KILOMETERS', 'MILES', or 'METERS'.
The default value is 'METERS'.
use_spheroidBOOLEANOptional.

If you set this argument to TRUE, this function uses a spheroid model instead of a spherical model.

The default value is FALSE.
Example
SQL
SELECT ST_MAXDISTANCE(
    ST_LINESTRING('linestring(0 0,0 12)'),
        TIMESTAMP[]('2020-07-04 07:00:00.000000000', '2020-07-04 11:00:00.000000000'),
    ST_LINESTRING('linestring(0 0,6 0)'),
        TIMESTAMP[]('2020-07-04 08:00:00.000000000', '2020-07-04 10:00:00.00000000'),
    'MILES',
    TRUE);
Output: 743.83
To use ST_MAXDISTANCE as a spatial function to calculate the maximum distance between two points, see the ST_MAXDISTANCE function in the Spatial Measurement section.

​
ST_TOTALSECONDSININTERSECTION

Returns the total number of seconds spent in the intersection result calculated by the spatiotemporal version of ST_INTERSECTION. Execute this function only with the result from ST_INTERSECTION. If the input is an empty, correctly typed tuple, this function returns 0 seconds. If the input is NULL, this function returns NULL.
SQL
ST_TOTALSECONDSININTERSECTION(tpl)
ArgumentData TypeDescription
tplTuple of LINESTRING-TIMESTAMP pairsA tuple of LINESTRING-TIMESTAMP pairs used to evaluate how long an intersection existed.
Example
SQL
SELECT ST_TOTALSECONDSININTERSECTION(
    ST_INTERSECTION(
        ST_LINESTRING('LINESTRING(1 1,2 2,1 1)'),
            TIMESTAMP[](
                '2020-07-04 07:00:00.000000000',
                '2020-07-04 11:00:00.000000000',
                '2020-07-04 12:00:00.000000000'),
        ST_LINESTRING('LINESTRING(2 2,1 1)')));
Output: 18000.0 Geospatial Data Types Spatiotemporal Operators
Last modified on May 21, 2026