Returns true if trajectory objects 1 and 2 intersect in space within the specified time range.
Syntax
boolean ST_intersects(trajectory traj1, trajectory traj2);
boolean ST_intersects(trajectory traj1, trajectory traj2, tsrange range);
boolean ST_intersects(trajectory traj1, trajectory traj2, timestamp t1, timestamp t2);Parameters
| Parameter | Type | Description |
|---|---|---|
traj | trajectory | The trajectory object. |
range | tsrange | The time range to check for intersection. |
t1 | timestamp | The start time of the range to check. |
t2 | timestamp | The end time of the range to check. |
Examples
Check whether two trajectories intersect between 13:00 and 14:00 on January 1, 2010:
Select ST_intersects((Select traj from traj_table where id=1), (Select traj from traj_table where id=2), '2010-1-1 13:00:00', '2010-1-1 14:00:00');该文章对您有帮助吗？