ST_IsValidTrajectory — Tests if the geometry is a valid trajectory.
boolean ST_IsValidTrajectory(geometry line);
Tests if a geometry encodes a valid trajectory. A valid trajectory is represented as a LINESTRING with measures (M values). The measure values must increase from each vertex to the next.
Valid trajectories are expected as input to spatio-temporal functions like ST_ClosestPointOfApproach
2.2.0 버전부터 사용할 수 있습니다.
This function supports 3d and will not drop the z-index.
This example constructs a valid trajectory.
SELECT ST_IsValidTrajectory(ST_MakeLine(ST_MakePointM(0, 0, 1),
ST_MakePointM(0, 1, 2)));
t
This example constructs an invalid trajectory.
SELECT ST_IsValidTrajectory(ST_MakeLine(ST_MakePointM(0, 0, 1), ST_MakePointM(0, 1, 0)));
NOTICE: Measure of vertex 1 (0) not bigger than measure of vertex 0 (1) f