creating new GPS points along a linear path

[Matthew]

hello everyone, i have two GPS points that i use to plot a line on a map, but now instead of 2 points, i want to have 10 more points spaced along the line drawn by the first two points.. does anyone know how i can do this?

Alternatively, this is only one portion of a bigger problem.. I am trying to convert this straight line into a curved line to follow the "great circle" path that an air plane follows.. I intend on transforming those additional GPS points from my original question by using some math I found on the internet.. But maybe Alteryx has a simpler method to convert this:

into this?:

[AngelosPachis · Accepted solution]

Hey @Matthew ,

My suggestion here would be to do a linear interpolation to find the coordinates of the intermediate 10 points. To do that, I subtracted the starting point lat and lon from the ending point coordinates and then divided by the number of points I want to generate, to find an offset value between each point

Then with a generate rows tool, I create those records and estimate the coordinates with a multi-row formula. 

This will return you a straight line, but I guess you can implement any kind of mathematic formulae to return you a curved line instead.

Hope that helps,

Angelos

[Matthew]

Wow, this is spectacular!!

Thank you for your help. I still need to figure out how to apply the curvature calculation, but this is exactly the starting point i need.

[Matthew · Accepted solution]

@AngelosPachis 

The formulas to do the calculation are ugly, but i think i got it to work!