Click here to Skip to main content
Licence CPOL
First Posted 16 Dec 2005
Views 178,265
Bookmarked 92 times

Distance between locations using latitude and longitude

By Gary Dryden | 16 Dec 2005
Calculate the distance between two locations given their latitude and longitude.
 
Part of The SQL Zone sponsored by
See Also
3 votes, 13.6%
1
1 vote, 4.5%
2
2 votes, 9.1%
3
1 vote, 4.5%
4
15 votes, 68.2%
5
4.39/5 - 22 votes
3 removed
μ 3.93, σa 2.64 [?]

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 Pinmemberomrivm6:30 12 Aug '11  
Questionquestion Pinmemberfithri17:50 1 Aug '11  
AnswerRe: question PinmemberGary Dryden4:46 2 Aug '11  
QuestionQuestion? PinmemberRichardg322:24 27 Jul '11  
AnswerRe: Question? PinmemberGary Dryden3:58 28 Jul '11  
GeneralSimpler Trig Pinmemberziopino7023:08 15 Apr '10  
AnswerDistance Calculator for Postgre PinmemberThe Swatchster7:08 6 Apr '10  
GeneralFind one bug ! Pinmemberkingdomkao15:51 13 Jan '09  
GeneralRe: Find one bug ! PinmemberMember 21446196:22 5 Apr '09  
GeneralThanks Gary Pinmemberbuttercatz7:50 13 Aug '08  
GeneralThanks! PinmemberEdithzor13:28 29 Jul '08  
GeneralDirection from one location from other using latitudes and longitudes PinmemberMember 39254802:05 28 Mar '08  
GeneralNo nonsense - straight, working code PinmemberLarsenLP1:15 7 Sep '07  
QuestionMiles or Kilometers? Pinmemberdeanj10:10 30 Jul '07  
AnswerRe: Miles or Kilometers? PinmemberGary Dryden13:33 30 Jul '07  
GeneralFinding lat and long for address Pinmembersides_dale16:14 14 Mar '06  
GeneralRe: Finding lat and long for address PinmemberGary Dryden3:25 15 Mar '06  
GeneralYou PLAGIARIZED Dr. Math's formula! PinmemberBill SerGio, The Infomercial King1:43 17 Dec '05  
GeneralA serious note about this PinmemberBill SerGio, The Infomercial King1:04 17 Dec '05  
First I am amzed at how immature some of the people are who read these articles!
 
Second, my own article was about the "Haversine Formula" in the title of my article--Guess what morons--The formula is NOT called the Dr. Math Formula or the SerGio Formula... It is called the Haversine Formula and that is the TITLE of my article ion which I present a formula done by Joe Haversine and convert it to C++ and SQL and discuss that FACT that computers have a problem with this formula and why. So you can understand why I would get angry is someone says you copied the formula from Dr. Math--Dr. Math did NOT invent this formula--Haversine created it as I state in my article if you can read.
 
Third, grow up... get a life and not a job! Join the programmers union and make a decent wage or do you have so little respect for your skills that you would work for only $60 a hour?
 
Happy Holidays!
 
Bill SerGio
GeneralFrom Bill SerGio PinmemberBill SerGio, The Infomercial King0:49 17 Dec '05  
GeneralUnit testing PinsupporterMarc Clifton9:40 16 Dec '05  
GeneralRe: Unit testing - C++ versus C# .NET PinmemberBill SerGio, The Infomercial King2:13 17 Dec '05  
GeneralNot as good as my article PinmemberBill SerGio, The Infomercial King6:31 16 Dec '05  
GeneralRe: Not as good as my article PinmemberHarkos11:06 16 Dec '05  
GeneralFrom Bill SerGio PinmemberBill SerGio, The Infomercial King2: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
Web03 | 2.5.120210.1 | Last Updated 16 Dec 2005
Article Copyright 2005 by Gary Dryden
Everything else Copyright © CodeProject, 1999-2012
Terms of Use
Layout: fixed | fluid