Calculate the distance between two sets of coordinates 🌍️
Summary
Returns the approximate distance in kilometres between a pair of geographical coordinates. Input latitude1, longitude1, latitude2, longitude2, output value is distance between each set of coordinates while considering the spherical nature of earth using the law of haversines.
Example
Buckingham Palace, London is located at coordinates 51.5014° N (latitude), 0.1419° W (longitude)
The Empire State Building, New York is located at coordinates 40.7484° N, 73.9857° W.
Output: 5562.2 (the approximate distance in kilometres between the two given coordinates)*
Function walkthrough
Converts each supplied coordinate into radians as a prerequisite for the Haversine Function.
Creates a new variable ‘PI / 180
’ which holds the value of π/180, then each input is multiplied by ‘PI / 180
’ to create 4 new variables, lat1, lon1, lat2, lon2
which now hold the coordinate values in radians.
Next, we calculate the ΔlatDifference (lat1 – lat2) and ΔlonDifference = (lon1 – lon2) and store these values in new variables dlat
and dlon
respectively.
Now we perform the first part of the Haversine Function, which can be mathematically expressed as:
sin(dlat
/2)² + cos(lat1
).cos(lat2
).sin(dlon
/2)²
We perform these calculations and store the output in a new variable a
.
Next we calculate 2.arcsin(√a
) and store this output in variable c
.
Finally, we multiply variable c
by the radius of earth and round to 2 decimal places, to give us the distance between the given coordiantes in kilometres. The radius of the earth is approximated at 6367km* in this function. Note that this value can be changed to 3956 to return the distance in miles rather than kilometres.
* N.B. The earth is not a perfect sphere, but is oblate at its poles, due to its rotation. Therefore, the radius of Earth is not constant, though is assumed as 6367km in this formula which may result in minor inaccuracies over long distance calculations, especially where there is a large difference in latitudes present. For precision accuracy this can be calculated at each pair of coordinates and averaged, using the below formula:
radius R, radius at equator r1, radius at pole r2
B = (latitude1 + latitude2) / 2
R = √ [ (r1² * cos(B))² + (r2² * sin(B))² ] / [ (r1 * cos(B))² + (r2 * sin(B))² ]
Compatibility
This function was developed in v. 2.6.0.2
Comments

Great work @Charlie Chambers  thanks for sharing!
0
Categories
 All categories
 16 Get started
 451 Get involved
 4 Support
 260 Resources
 2 Events
 Upcoming events
 2 Event recaps
 17 Ideas and roadmap
 218 Community categories