如何使用没有三角函数的标准SQL计算两个经纬度点之间的距离(以英里为单位)?
发布于 2022-01-12 18:28:24
没有三角,你就会得到不正确的结果。在这里找到一个有答案、公式和例子的解释:
https://jonisalonen.com/2014/computing-distance-between-coordinates-can-be-simple-and-fast
无精度无三角逼近
DECLARE @SqDegreeLatInMiles AS REAL = 4774.81
DECLARE @SqDegreeLongInMiles AS REAL = 2809
-- VA, Zip=23452
DECLARE @Point_A_Lat AS REAL = 36.8366
DECLARE @Point_A_Long AS REAL = 76.0952
-- TX, Zip=75225
DECLARE @Point_B_Lat AS REAL = 32.8644
DECLARE @Point_B_Long AS REAL = 96.7946
DECLARE @DistanceInMiles AS REAL
SET @DistanceInMiles = SQRT (@SqDegreeLatInMiles * POWER(@Point_A_Lat - @Point_B_Lat,2) + @SqDegreeLongInMiles * POWER(@Point_A_Long - @Point_B_Long,2))
PRINT @DistanceInMileshttps://stackoverflow.com/questions/70686010
复制相似问题