ST_euclideanDistance distance measurement function-ApsaraDB RDS(RDS)-阿里云帮助中心

Returns the nearest Euclidean distance between two trajectory objects at the same time point.

Syntax

float ST_euclideanDistance(trajectory traj1, trajectory traj2);

Parameter	Description
`traj1`	The first trajectory object.
`traj2`	The second trajectory object.

The returned distance value is standardized.

The following example returns the standardized Euclidean distance between two trajectories stored in traj_table.

SELECT ST_euclideanDistance(
  (SELECT traj FROM traj_table WHERE id = 1),
  (SELECT traj FROM traj_table WHERE id = 2)
);