ST_subTrajectorySpatial
Updated at:
Copy as MD
The trajectory geometry over a specified time period.
Syntax
geometry ST_subTrajectorySpatial(trajectory traj, timestamp starttime, timestamp endtime);
geometry ST_subTrajectorySpatial(trajectory traj, tsrange range);Parameters
Parameter Name | Description |
traj | The trajectory object. |
starttime | The start time. |
endtime | The end time. |
range | The time range. |
Example
Select ST_subTrajectorySpatial(traj, '2010-1-11 02:45:30', '2010-1-11 03:00:00') FROM traj_table;Is this page helpful?