Returns the point in traj1 that is spatially nearest to traj2 within a specified time range.
Syntax
geometry ST_nearestApproachPoint(trajectory traj1, trajectory traj2);
geometry ST_nearestApproachPoint(trajectory traj1, trajectory traj2, tsrange range);
geometry ST_nearestApproachPoint(trajectory traj1, trajectory traj2, timestamp t1, timestamp t2);Parameters
| Parameter | Description |
|---|---|
traj1 | The first trajectory object. |
traj2 | The second trajectory object. |
range | The time range, specified as a tsrange value. |
t1 | The start time. |
t2 | The end time. |
Example
Select ST_nearestApproachPoint((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');该文章对您有帮助吗？