用SQL计算2点之间的距离

SELECt <replace with your select>,3963.0 * ACOS (    sin(SUBSTRINg(X, 1, 2)/57.2958) * sin(" + axisX + "/57.2958) + cos(SUBSTRINg(X, 1, 2)/57.2958) * cos(" + axisX + "/57.2958) * cos(" + axisY + "/57.2958 - SUBSTRINg(Y, 1, 2)/57.2958))as distance FROM HouseORDER BY distance

我假设axisX和axisY是您的坐标。这使用距离计算技术，可以为您提供更准确的读数。

http://www.meridianworlddata.com/Distance-
Calculation.asp

希望这可以帮助。