Click here to Skip to main content
Licence CPOL
First Posted 16 Dec 2005
Views 186,737
Bookmarked 94 times

Distance between locations using latitude and longitude

By | 16 Dec 2005 | Article
Calculate the distance between two locations given their latitude and longitude.
 
Part of The SQL Zone sponsored by
See Also

Introduction

This code drop is part of a Smash and Grab series. I'll bet there are a lot of other programmers out there that would like to make code available to others, but just don't want to spend hours required to create a full-blown "CodeProject" article. This is an attempt to see if I can make some useful code available to other programmers, and do it in 10 minutes. I encourage others to contribute to "Smash and Grab".

The basic rules are:

  • It should be a C# class, which solves a simple problem.
  • Don't waste the reader's time with GUI stuff and "OnClick" methods.
  • If at all possible, make it a console app with a "Main()" that illustrates its functionality.

The point of this series is to present usable pre-canned classes or techniques which solve a real world problem without going into too much detail about how it works. I mean, who really cares about how System.Collections.ArrayList works, you just use it.

Please fully comment the code so that the person who really cares (and has the time) will be able to understand the underlying algorithm.

Using the code

I wanted a .NET class which would tell me the distance between two locations. There were all sorts of bits of code out on the net which attempted to do this in JavaScript but the programmers obviously could not separate the algorithm from the GUI. This is my humble attempt at a pure non-GUI class which will calculate the distance between two locations.

using System;
using System.Text;

public class CDistanceBetweenLocations
{
    public static double Calc(double Lat1, 
                  double Long1, double Lat2, double Long2)
    {
        /*
            The Haversine formula according to Dr. Math.
            http://mathforum.org/library/drmath/view/51879.html
                
            dlon = lon2 - lon1
            dlat = lat2 - lat1
            a = (sin(dlat/2))^2 + cos(lat1) * cos(lat2) * (sin(dlon/2))^2
            c = 2 * atan2(sqrt(a), sqrt(1-a)) 
            d = R * c
                
            Where
                * dlon is the change in longitude
                * dlat is the change in latitude
                * c is the great circle distance in Radians.
                * R is the radius of a spherical Earth.
                * The locations of the two points in 
                    spherical coordinates (longitude and 
                    latitude) are lon1,lat1 and lon2, lat2.
        */
        double dDistance = Double.MinValue;
        double dLat1InRad = Lat1 * (Math.PI / 180.0);
        double dLong1InRad = Long1 * (Math.PI / 180.0);
        double dLat2InRad = Lat2 * (Math.PI / 180.0);
        double dLong2InRad = Long2 * (Math.PI / 180.0);

        double dLongitude = dLong2InRad - dLong1InRad;
        double dLatitude = dLat2InRad - dLat1InRad;

        // Intermediate result a.
        double a = Math.Pow(Math.Sin(dLatitude / 2.0), 2.0) + 
                   Math.Cos(dLat1InRad) * Math.Cos(dLat2InRad) * 
                   Math.Pow(Math.Sin(dLongitude / 2.0), 2.0);

        // Intermediate result c (great circle distance in Radians).
        double c = 2.0 * Math.Asin(Math.Sqrt(a));

        // Distance.
        // const Double kEarthRadiusMiles = 3956.0;
        const Double kEarthRadiusKms = 6376.5;
        dDistance = kEarthRadiusKms * c;

        return dDistance;
    }

    public static double Calc(string NS1, double Lat1, double Lat1Min, 
           string EW1, double Long1, double Long1Min, string NS2, 
           double Lat2, double Lat2Min, string EW2, 
           double Long2, double Long2Min)
    {
        double NS1Sign = NS1.ToUpper() == "N" ? 1.0 : -1.0;
        double EW1Sign = EW1.ToUpper() == "E" ? 1.0 : -1.0;
        double NS2Sign = NS2.ToUpper() == "N" ? 1.0 : -1.0;
        double EW2Sign = EW2.ToUpper() == "E" ? 1.0 : -1.0;
        return (Calc(
            (Lat1 + (Lat1Min / 60)) * NS1Sign,
            (Long1 + (Long1Min / 60)) * EW1Sign,
            (Lat2 + (Lat2Min / 60)) * NS2Sign,
            (Long2 + (Long2Min / 60)) * EW2Sign
            ));
    }

    public static void Main(string[] args)
    {
        if (args.Length < 12)
        {
            System.Console.WriteLine("usage: DistanceBetweenLocations" + 
                    " N 43 35.500 W 80 27.800 N 43 35.925 W 80 28.318");
            return;
        }
        System.Console.WriteLine(Calc(
            args[0], 
            System.Double.Parse(args[1]), 
            System.Double.Parse(args[2]), 
            args[3], 
            System.Double.Parse(args[4]), 
            System.Double.Parse(args[5]), 
            args[6], 
            System.Double.Parse(args[7]), 
            System.Double.Parse(args[8]), 
            args[9], 
            System.Double.Parse(args[10]), 
            System.Double.Parse(args[11])));

    }

}

Here is an MS-SQL user defined function. I never really understood why this math functionality was in SQL Server until now! You can use this function in a query statement to find the nearest Tim Horton's!!!

CREATE FUNCTION [dbo].[DistanceBetween] (@Lat1 as real, 
                @Long1 as real, @Lat2 as real, @Long2 as real)
RETURNS real
AS
BEGIN

DECLARE @dLat1InRad as float(53);
SET @dLat1InRad = @Lat1 * (PI()/180.0);
DECLARE @dLong1InRad as float(53);
SET @dLong1InRad = @Long1 * (PI()/180.0);
DECLARE @dLat2InRad as float(53);
SET @dLat2InRad = @Lat2 * (PI()/180.0);
DECLARE @dLong2InRad as float(53);
SET @dLong2InRad = @Long2 * (PI()/180.0);

DECLARE @dLongitude as float(53);
SET @dLongitude = @dLong2InRad - @dLong1InRad;
DECLARE @dLatitude as float(53);
SET @dLatitude = @dLat2InRad - @dLat1InRad;
/* Intermediate result a. */
DECLARE @a as float(53);
SET @a = SQUARE (SIN (@dLatitude / 2.0)) + COS (@dLat1InRad) 
                 * COS (@dLat2InRad) 
                 * SQUARE(SIN (@dLongitude / 2.0));
/* Intermediate result c (great circle distance in Radians). */
DECLARE @c as real;
SET @c = 2.0 * ATN2 (SQRT (@a), SQRT (1.0 - @a));
DECLARE @kEarthRadius as real;
/* SET kEarthRadius = 3956.0 miles */
SET @kEarthRadius = 6376.5;        /* kms */

DECLARE @dDistance as real;
SET @dDistance = @kEarthRadius * @c;
return (@dDistance);
END

OK, this first one took me longer than 10 minutes, but the next one won't.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Gary Dryden

Software Developer (Senior)

Canada Canada

Member



Sign Up to vote   Poor Excellent
Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

 
You must Sign In to use this message board. (secure sign-in)
 
Search this forum  
 FAQ
    Noise  Layout  Per page   
  Refresh
Questionquestion about the other way around Pinmemberomrivm5:30 12 Aug '11  
Questionquestion Pinmemberfithri16:50 1 Aug '11  
AnswerRe: question PinmemberGary Dryden3:46 2 Aug '11  
QuestionQuestion? PinmemberRichardg321:24 27 Jul '11  
AnswerRe: Question? PinmemberGary Dryden2:58 28 Jul '11  
GeneralSimpler Trig Pinmemberziopino7022:08 15 Apr '10  
AnswerDistance Calculator for Postgre PinmemberThe Swatchster6:08 6 Apr '10  
GeneralFind one bug ! Pinmemberkingdomkao14:51 13 Jan '09  
GeneralRe: Find one bug ! PinmemberMember 21446195:22 5 Apr '09  
GeneralThanks Gary Pinmemberbuttercatz6:50 13 Aug '08  
GeneralThanks! PinmemberEdithzor12:28 29 Jul '08  
GeneralDirection from one location from other using latitudes and longitudes PinmemberMember 39254801:05 28 Mar '08  
GeneralNo nonsense - straight, working code PinmemberLarsenLP0:15 7 Sep '07  
QuestionMiles or Kilometers? Pinmemberdeanj9:10 30 Jul '07  
Awesome code!
 
I've been testing this code and comparing the results with Google Earth. Pretty darn similar! The only thing is, it only matches up when I set the unit of measurement to Kilometers in Google Earth, not miles like the comments say. Hopefully I'm not missing something.
 
Thanks!

AnswerRe: Miles or Kilometers? PinmemberGary Dryden12:33 30 Jul '07  
GeneralFinding lat and long for address Pinmembersides_dale15:14 14 Mar '06  
GeneralRe: Finding lat and long for address PinmemberGary Dryden2:25 15 Mar '06  
GeneralYou PLAGIARIZED Dr. Math's formula! PinmemberBill SerGio, The Infomercial King0:43 17 Dec '05  
GeneralA serious note about this PinmemberBill SerGio, The Infomercial King0:04 17 Dec '05  
GeneralFrom Bill SerGio PinmemberBill SerGio, The Infomercial King23:49 16 Dec '05  
GeneralUnit testing PinprotectorMarc Clifton8:40 16 Dec '05  
GeneralRe: Unit testing - C++ versus C# .NET PinmemberBill SerGio, The Infomercial King1:13 17 Dec '05  
GeneralNot as good as my article PinmemberBill SerGio, The Infomercial King5:31 16 Dec '05  
GeneralRe: Not as good as my article PinmemberHarkos10:06 16 Dec '05  
GeneralFrom Bill SerGio PinmemberBill SerGio, The Infomercial King1:01 17 Dec '05  

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Mobile
Web02 | 2.5.120529.1 | Last Updated 16 Dec 2005
Article Copyright 2005 by Gary Dryden
Everything else Copyright © CodeProject, 1999-2012
Terms of Use
Layout: fixed | fluid