ST_timeAtDistance
Returns an array of timestamps at which a trajectory reaches the specified distance from its start point.
Syntax
timestamp[] ST_timeAtDistance(trajectory traj, float8 d);Parameters
| Parameter | Description |
|---|---|
traj | The trajectory object. |
d | The distance of movement. |
Return value
Returns timestamp[]. The function returns an array rather than a single value because multiple spatial points on a trajectory can be at the same distance from the start point.
Examples
Query the timestamps at which a trajectory in traj_table reaches 100 units from its start point:
SELECT ST_timeAtDistance(traj, 100) FROM traj_table;