ST_Distance¶

Introduction: Returns the minimum geodesic distance between two geography objects in meters. Uses S2 geometry-to-geometry distance (S2ClosestEdgeQuery), which computes the true minimum distance between any two points on the geometries — not centroid-to-centroid. Consistent with sedona-db's implementation.

ST_Distance on a sphere: great-circle distance between two points

Format:

ST_Distance (A: Geography, B: Geography)

Return type: Double

Since: v1.9.1

SQL Example

SELECT ST_Distance(
  ST_GeogFromWKT('POINT (0 0)'),
  ST_GeogFromWKT('POINT (1 1)')
);

Output:

157249.59847404022

The result is approximately 157 km, the great-circle distance between (0,0) and (1,1) on the WGS84 sphere.