GREAT_CIRCLE_DISTANCE

Returns the great-circle distance in meters between two points on a sphere. The points are specified by longitude and latitude in degrees.

Syntax

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

Arguments

Return Type

Float32.

Examples

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

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