MySQL通过经纬度计算定位的距离

SELECT
    ROUND(
        6378.138 * 2 * ASIN(
            SQRT(
                POW(
                    SIN(
                        (
                            定位的lat * PI() / 180 - S_lat * PI() / 180
                        ) / 2
                    ),
                    2
                ) + COS(定位的lat * PI() / 180) * COS(S_lat * PI() / 180) * POW(
                    SIN(
                        (
                           定位的lng * PI() / 180 - S_lng * PI() / 180
                        ) / 2
                    ),
                    2
                )
            )
        ) * 1000
    )
 AS juli from mapsTable

前端js解析

var distance = data[i]["juli"] > 1000 ? (data[i]["juli"] / 1000).toFixed(2) + "km" : data[i]["juli"].toFixed(0) + "m";