설명

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

참고

ST_ClosestPointOfApproach