Distance between two sets of Lat / Longs

Hello, i am trying to figure out how to calculate the distance between set sets of lat / longs. In excel i would use the following formula. C2,G2 (Y Coord), D2,H2 (X Coord) are cell references, and i'm calculating distance in nautical miles hence the 3440.65.

=ACOS(COS(RADIANS(90-C2))*COS(RADIANS(90-G2))+SIN(RADIANS(90-C2))*SIN(RADIANS(90-G2))*COS(RADIANS(D2-H2)))*3440.65

How would i go about doing this in alteryx?

Thanks in advance!

Spatial Analysis

Accepted answers

derekbelyea

Here is a small example:

Airport to Airport Distances.yxzp

All comments

LordNeilLord

Hey @RogerA

Have a look at these two tools... They're pretty straightforward:

Create points (to convert lat /lng to spatial points) https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Create-Points/ta-p/36653

Distance (to find the distance between spatial points) https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Distance/ta-p/87210

Hopefully you'll get the idea

derekbelyea

Here is a small example:

Airport to Airport Distances.yxzp

RogerA

Both replies are really useful, i'm going to look at these today and i'll let you know if I have managed to get my data sorted out. Thanks!

Anshul_Bajpai12

Using latitude and longitude to get the distance between the two regions gives point to point distance rather than the by road distance. So is there a way to get the by road distance between two points.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703