LatLongDist ( Lat1 ; Long1 ; Lat2 ; Long2 )

Calculates the distance between two sets of latitude/longitude coordinates

Average rating: 4.5 (31 votes) Log in to vote

George Nassar - Show more from this author
Provident Data Services
http://www.providentdata.com

Sample input:

LatLongDist ( -97.146517, 33.231477, -97.325295; 32.785130 )

Sample output:

12.962844230981499715

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

If(
  (Lat1=Lat2) and (Long1=Long2);
  0;
  Let(
    CosAOB = Cos(Radians(Lat1))*Cos(Radians(Long1))*Cos(Radians(Lat2))*Cos(Radians(Long2)) +
    Cos(Radians(Lat1))*Sin(Radians(Long1))*Cos(Radians(Lat2))*Sin(Radians(Long2)) +
    Sin(Radians(Lat1))*Sin(Radians(Lat2));
    3963.1 * Acos(CosAOB)
  )
)

This requires the use of another custom function, Acos:

Case ( num>0 ; Atan ( Sqrt(1-num*num) / num ) ; num<0 ; Pi + Atan ( Sqrt(1-num*num) / num ) ; Pi/2 )

which takes the single parameter "num"

You can use a web service to automatically import the long/lat of an address using XML for a specific address, and then calculate distances in miles with this custom function. If you are interested in our perl script which facilitates this import contact us.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

LatLongDist ( Lat1 ; Long1 ; Lat2 ; Long2 )

Comments

Support this website.

Support this website.