ST_Angle_Sphere

Syntax

DOUBLE ST_Angle_Sphere(DOUBLE x_lng, DOUBLE x_lat, DOUBLE y_lng, DOUBLE y_lat)

description

计算地球表面两点之间的圆心角，单位为 度。传入的参数分别为X点的经度，X点的纬度，Y点的经度，Y点的纬度。

x_lng 和 y_lng 都是经度数据，合理的取值范围是 [-180, 180]。

x_lat 和 y_lat 都是纬度数据，合理的取值范围是 [-90, 90]。

example

  1. mysql> select ST_Angle_Sphere(116.35620117, 39.939093, 116.4274406433, 39.9020987219);
  2. +---------------------------------------------------------------------------+
  3. | st_angle_sphere(116.35620117, 39.939093, 116.4274406433, 39.9020987219) |
  4. +---------------------------------------------------------------------------+
  5. |                                                        0.0659823452409903 |
  6. +---------------------------------------------------------------------------+
  7. 1 row in set (0.06 sec)
  9. mysql> select ST_Angle_Sphere(0, 0, 45, 0);
  10. +----------------------------------------+
  11. | st_angle_sphere(0.0, 0.0, 45.0, 0.0) |
  12. +----------------------------------------+
  13. |                                     45 |
  14. +----------------------------------------+
  15. 1 row in set (0.06 sec)

keywords

ST_ANGLE_SPHERE,ST,ANGLE,SPHERE