-- origin=116.481028,39.989643&destination=114.465302,40.004717
SELECT
6371393 * 2 * ASIN(
SQRT(
POWER( SIN( ( 39.989643 - 40.004717 ) * PI( ) / 180 / 2 ), 2 ) + COS( 39.989643 * PI( ) / 180 ) * COS( 40.004717 * PI( ) / 180 ) * POWER( SIN( ( 116.481028 - 114.465302 ) * PI( ) / 180 / 2 ), 2 )
)
) AS distance ;
利用sql计算两个坐标点之间的距离(非精确算法)
最新推荐文章于 2023-03-18 17:21:57 发布