Forum Discussion
Distance calculation by selecting two points from map
- 5 years ago
Anonymous I think it could be done if you did a couple checks -
Distance Measure = IF( COUNTROWS(LatLongTable) = 2,
VAR _LatA = Min(Lat)
VAR _LongA = Min(Long)
VAR _LatB = Max(Lat)
VAR _LongB = Max(Long)
RETURN
[DistCalc]
)
I don't know how your table is formatted, but you will need to be more precise with the Min/max lat and long to make sure they actually correspond to each data point, and that you don't use lat from one and long from the other.
Drawing the circle of radius I have met someone who I think said they achieved this, but I don't recall how....
Anonymous I think it could be done if you did a couple checks -
Distance Measure = IF( COUNTROWS(LatLongTable) = 2,
VAR _LatA = Min(Lat)
VAR _LongA = Min(Long)
VAR _LatB = Max(Lat)
VAR _LongB = Max(Long)
RETURN
[DistCalc]
)
I don't know how your table is formatted, but you will need to be more precise with the Min/max lat and long to make sure they actually correspond to each data point, and that you don't use lat from one and long from the other.
Drawing the circle of radius I have met someone who I think said they achieved this, but I don't recall how....
- Anonymous5 years agoNot applicable
Excellent! Thank you so much! The logic works, now i need to figure out how to make the calculation work. Thank you again!