Calculating distance between 2 points

• schleep

  SSChampion

  Points: 12586

  More actions

  February 16, 2006 at 9:44 am

  #171234

  Hi all,

  I need the formula for calculating the distance between 2 points.

  Data we have is

  Point - Latitude, Longitude, Latitude Declination, Longitude Declination

  and appears as

  Lat: 51° 39' North

  Long: 121° 17' West

  LatDec: 51.649999999999999

  Long Dec: -121.2833

  Thanks in advance,

  Paul

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  February 16, 2006 at 10:29 pm

  #621549

  You can try to convert your Declinations into a 2nd set of Latitude, Longitude, then use:

  CREATE FUNCTION dbo.fn_GreatCircleDistance

   (@Latitude1 float = NULL,

   @Longitude1 float = NULL,

   @Latitude2 float = NULL,

   @Longitude2 float = NULL)

  RETURNS float

  AS

  BEGIN

   IF @Latitude1 IS NULL RETURN 0

   IF @Longitude1 IS NULL RETURN 0

   IF @Latitude2 IS NULL RETURN 0

   IF @Longitude2 IS NULL RETURN 0

   RETURN (ACOS(SIN(@Latitude1 * PI() / 180) * SIN(@Latitude2 * PI() / 180) +

    COS(@Latitude1 * PI() / 180) * COS(@Latitude2 * PI() / 180) * COS((@Longitude2 - @Longitude1) * PI() / 180)) * 3963.1)

  END

  GO

  Andy