Click here to Skip to main content
15,879,613 members
Articles / Programming Languages / SQL

Distance between locations using latitude and longitude

Rate me:
Please Sign up or sign in to vote.
4.46/5 (32 votes)
16 Dec 2005CPOL2 min read 580.4K   105   56
Calculate the distance between two locations given their latitude and longitude.

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.

C#
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!!!

SQL
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)


Written By
Software Developer (Senior)
Canada Canada
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
QuestionThank you... Pin
Destiny77730-Nov-17 12:04
Destiny77730-Nov-17 12:04 
GeneralMy vote of 5 Pin
Bernard Chayer27-Jun-13 5:47
professionalBernard Chayer27-Jun-13 5:47 
QuestionDistance between two locations using Latittude and longitude Pin
s pullareddy21-May-13 2:37
s pullareddy21-May-13 2:37 
QuestionThanks for this article Pin
ngnlx18-May-13 3:46
ngnlx18-May-13 3:46 
GeneralMy vote of 4 Pin
Ashish Jain(Be Jovial)19-Oct-12 20:44
Ashish Jain(Be Jovial)19-Oct-12 20:44 
Questionquestion about the other way around Pin
User 296361512-Aug-11 5:30
User 296361512-Aug-11 5:30 
Questionquestion Pin
fithri1-Aug-11 16:50
fithri1-Aug-11 16:50 
AnswerRe: question Pin
Gary Dryden2-Aug-11 3:46
Gary Dryden2-Aug-11 3:46 
QuestionQuestion? Pin
Richardg327-Jul-11 21:24
Richardg327-Jul-11 21:24 
AnswerRe: Question? Pin
Gary Dryden28-Jul-11 2:58
Gary Dryden28-Jul-11 2:58 
GeneralSimpler Trig Pin
ziopino7015-Apr-10 22:08
ziopino7015-Apr-10 22:08 
AnswerDistance Calculator for Postgre Pin
The Swatchster6-Apr-10 6:08
The Swatchster6-Apr-10 6:08 
GeneralFind one bug ! Pin
kingdomkao13-Jan-09 14:51
kingdomkao13-Jan-09 14:51 
GeneralRe: Find one bug ! Pin
Member 21446195-Apr-09 5:22
Member 21446195-Apr-09 5:22 
So did I! I hope you'd fix it up
GeneralThanks Gary Pin
buttercatz13-Aug-08 6:50
buttercatz13-Aug-08 6:50 
GeneralThanks! Pin
Edithzor29-Jul-08 12:28
Edithzor29-Jul-08 12:28 
GeneralDirection from one location from other using latitudes and longitudes Pin
Member 392548028-Mar-08 1:05
Member 392548028-Mar-08 1:05 
GeneralNo nonsense - straight, working code Pin
LarsenLP7-Sep-07 0:15
LarsenLP7-Sep-07 0:15 
QuestionMiles or Kilometers? Pin
deanj30-Jul-07 9:10
deanj30-Jul-07 9:10 
AnswerRe: Miles or Kilometers? Pin
Gary Dryden30-Jul-07 12:33
Gary Dryden30-Jul-07 12:33 
GeneralFinding lat and long for address Pin
sides_dale14-Mar-06 15:14
sides_dale14-Mar-06 15:14 
GeneralRe: Finding lat and long for address Pin
Gary Dryden15-Mar-06 2:25
Gary Dryden15-Mar-06 2:25 
GeneralYou PLAGIARIZED Dr. Math's formula! Pin
Bill SerGio, The Infomercial King17-Dec-05 0:43
Bill SerGio, The Infomercial King17-Dec-05 0:43 
GeneralA serious note about this Pin
Bill SerGio, The Infomercial King17-Dec-05 0:04
Bill SerGio, The Infomercial King17-Dec-05 0:04 
GeneralFrom Bill SerGio Pin
Bill SerGio, The Infomercial King16-Dec-05 23:49
Bill SerGio, The Infomercial King16-Dec-05 23:49 

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

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