ST_Distance

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.

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

Signatures

ST_Distance (A: Geography, B: Geography)

Parameters

Geography

required

The first geography.

Geography

required

The second geography.

Return type

The minimum geodesic distance between A and B, in meters.

Example

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

157249.59847404022

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

ST_DWithin

ST_Envelope

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Example

​Signatures

​Parameters

​Return type

​Example

Signatures

Parameters

Return type

Example