GEO_DISTANCE

Returns the approximate distance in meters between two points on Earth. The points are specified by longitude and latitude in degrees and the distance is computed using a WGS84-based approximation.

Syntax

GEO_DISTANCE(<lon1>, <lat1>, <lon2>, <lat2>)

Arguments

Return Type

Float32.

Examples

SELECT GEO_DISTANCE(55.755831, 37.617673, -55.755831, -37.617673) AS distance;

╭────────────╮
│  distance  │
├────────────┤
│ 14128353.0 │
╰────────────╯