This function returns the spatial geometry object of a trajectory object within the specified time range.

Syntax

geometry ST_subTrajectorySpatial(trajectory traj, timestamp starttime, timestamp endtime);
geometry ST_subTrajectorySpatial(trajectory traj, tsrange range);

Parameters

Parameter Description
traj The trajectory object.
starttime The start time.
endtime The end time.
range The time range.

Examples

Select ST_subTrajectorySpatial(traj, '2010-1-11 02:45:30', '2010-1-11 03:00:00') FROM traj_table;