How calculate two geo distance Latitude Logitude Altidute points in Azure Sql server

Question

In Azure SQL Server, how can I acquire an accurate distance (in metres) between two geo-points (two pairs of latitude/longitude/Altitude)?

22.30634 113.92934 125 Latitude Longitude

58.31962 -157.54788 35000 latitude longitude altitude

Is there a way to calculate distance in SQL Server that includes altitude?

Answer 1

For find distance between two latitude and longitude in SQL Server, we can use below mentioned query. This query calculate the distance in miles.

DECLARE @sourceLatitude FLOAT = 28.58;  

DECLARE @sourceLongitude FLOAT = 77.329;  

DECLARE @destinationLatitude FLOAT = 27.05;  

DECLARE @destinationLongitude FLOAT = 78.001;  

DECLARE @Location FLOAT  

SET @Location = SQRT(POWER(69.1 * ( @destinationLatitude - @sourceLatitude),  

2) + POWER(69.1 * ( @sourceLongitude  

- @destinationLongitude )  

* COS(@destinationLatitude / 57.3), 2))  

PRINT @Location