Returns a geometry representing the spatial intersection of two trajectory objects within a specified time range.
Syntax
geometry ST_intersection(trajectory traj1, trajectory traj2, tsrange range);
geometry ST_intersection(trajectory traj1, trajectory traj2, timestamp t1, timestamp t2);Use the tsrange overload to pass a prebuilt PostgreSQL timestamp range. Use the timestamp overload to specify start and end times directly.
Parameters
| Parameter | Type | Description |
|---|---|---|
traj1 | trajectory | The first trajectory object. |
traj2 | trajectory | The second trajectory object. |
range | tsrange | The time range to evaluate. |
t1 | timestamp | The start of the time range. |
t2 | timestamp | The end of the time range. |
Example
Find the spatial intersection of two trajectories between 13:00 and 14:00 on January 1, 2010:
SELECT ST_intersection(
(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'
);