Checks whether the first specified object falls within the second specified object along a given axis.
Syntax
bool ST_TWithin(tsrange r, trajectory traj);
bool ST_TWithin(trajectory traj, tsrange r);
bool ST_2DWithin(geometry geom, trajectory traj);
bool ST_2DWithin(trajectory traj, geometry geom);
bool ST_2DWithin(geometry geom, trajectory traj, timestamp ts, timestamp te);
bool ST_2DWithin(trajectory traj, geometry geom, timestamp ts, timestamp te);
bool ST_{2D|2DT|3D|3DT}Within(trajectory traj, boxndf box);
bool ST_{2D|2DT|3D|3DT}Within(trajectory traj, boxndf box, timestamp ts, timestamp te);Parameters
| Parameter | Description |
|---|---|
| geom | The geometry to compare. |
| traj | The trajectory to compare, or the source trajectory from which a sub-trajectory is extracted for comparison. |
| box | The N-dimensional bounding box (boxndf) to compare. |
| r | The time range (tsrange) to compare. |
| ts | The start of the time range for sub-trajectory extraction. Optional. |
| te | The end of the time range for sub-trajectory extraction. Optional. |
Description
These functions check whether the first argument falls within the second argument. They work the same way as the ST_ndContains function.
Note This function is not supported for geometry types such as POLYHEDRALSURFACE.
Example
WITH traj AS(
SELECT (' {"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"2000-01-01 03:15:42","end_time":"2000-01-01 05:16:43",' ||
'"spatial":"LINESTRING(2 2 0,33.042158099636 36.832684322819 0,47.244002354518 47.230026333034 0,64.978971942887 60.618813472986 0,77.621717839502 78.012496630661 0,80 78 0)",' ||
'"timeline":["2000-01-01 03:15:42","2000-01-01 03:39:54","2000-01-01 04:04:06","2000-01-01 04:28:18","2000-01-01 04:52:31","2000-01-01 05:16:43"]}}')::trajectory a,
'LINESTRING(2 2 0,33.042158099636 36.832684322819 0,47.244002354518 47.230026333034 0,64.978971942887 60.618813472986 0,77.621717839502 78.012496630661 0,80 78 0)'::geometry b
)
SELECT ST_2dWithin(b,a) from traj;
st_2dwithin
-------------
tThis example checks whether the geometry b (a LINESTRING) falls within the trajectory a in 2D space. The result t (true) confirms that b is fully contained within a.