Distance Calculation

[TomBock]

Hi:

I'd like to calculate the total travel distance between 4 points (lat/long).

At this point, I'm not entire certain how to construct the expression for the multi-row formula to calculate distance between:

- Point 1 and Point 2

- Point 2 and Point 3

- Point 3 and Point 4

How would I need to modify the attached workflow to output the individual distance as well as the total distance?

Thank you,

Tom

 

[Clifford_Coon · Accepted solution]

Hi @TomBock ,

Here is a method: use the ST_Distance formula as shown

Hapy Solving ;-)

 

[TomBock]

@Clifford_Coon -- perfect!   Your solution is exactly what I was looking to achieve.   Thank you!!