[Solved] Calculate (Find) distance between two Geographical Coordinates (Latitude and Longitude) in SQL Server

Question

Hello I am looking for distance between 2 coordinates in sql serverHere is some sample data i haveIdCoordinate15556556210072329 975574310543515825553810346218259 9719881970906044355591275667750466 975287447577966345551691452548091 9629065055870796what is the distance between id 1 and 2 need to calcuate in sql server from its coordinate

Mudassar · Accepted Answer

You will need to use the Geography DataType in SQL Server 2008 or higherDECLARE Mumbai GEOGRAPHY  39POINT189750 72825839DECLARE Delhi GEOGRAPHY  39POINT286100 77230039SELECT MumbaiSTDistanceDelhi  1000

Mudassar · Answer

You will have to remove comma and then useDECLARE Coordinates TABLE Id INT Coordinate VARCHAR1000INSERT INTO CoordinatesVALUES 1 395556556210072329 9755743105435158392 395553810346218259 971988197090604439SELECT CAST39POINT39  REPLACECoordinate 3939 3939  3939 AS GEOGRAPHY FROM CoordinatesDECLARE C1 GEOGRAPHY  SELECT CAST39POINT39  REPLACECoordinate 3939 3939  3939 AS GEOGRAPHY FROM Coordinates WHERE Id  1DECLARE C2 GEOGRAPHY  SELECT CAST39POINT39  REPLACECoordinate 3939 3939  3939 AS GEOGRAPHY FROM Coordinates WHERE Id  2 SELECT C1STDistanceC2  1000

Id	Coordinate
1	55.56556210072329, 9.755743105435158
2	55.53810346218259, 9.719881970906044
3	55.591275667750466, 9.752874475779663
4	55.51691452548091, 9.629065055870796

[Solved] Calculate (Find) distance between two Geographical Coordinates (Latitude and Longitude) in SQL Server

Company

Explore

Follow us

Contact Us