Challenge #173: Tour de France - Crow Edition

[PaceParillo]

Spoiler

[Jbrooks]

Spoiler

[mcultrera]

Solution attached

[grazitti_sapna]

Solution.

[Verakso]

I bet some of the riders wish they could have taken the bird route.....

Spoiler

Straight forward join on the Origin and Destination Cities, Spatial Distance and Summarizing

Still Climbing
/Verakso

[DanielMS]

Spoiler

[Carlithian]

Wasn't getting the same output...until I realised I auto piloted to miles rather than km 😛

[JReid]

Much easier than the Grand Prix Challenges, but that's probably good for me to learn more spatial tools.

Spoiler

I'm on 2018.2 so my double values were a bit off, so I just converted them to an int for the join.

[DataG8]

My solution. Reminded me to change the default units to kilometers. Why do miles exist? (off to Wikipedia)

Spoiler