跳到主要内容
跳到主要内容

ST_ANGLE_SPHERE

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

mysql> select ST_Angle_Sphere(116.35620117, 39.939093, 116.4274406433, 39.9020987219);
+---------------------------------------------------------------------------+
| st_angle_sphere(116.35620117, 39.939093, 116.4274406433, 39.9020987219) |
+---------------------------------------------------------------------------+
| 0.0659823452409903 |
+---------------------------------------------------------------------------+
1 row in set (0.06 sec)

mysql> select ST_Angle_Sphere(0, 0, 45, 0);
+----------------------------------------+
| st_angle_sphere(0.0, 0.0, 45.0, 0.0) |
+----------------------------------------+
| 45 |
+----------------------------------------+
1 row in set (0.06 sec)

keywords

ST_ANGLE_SPHERE,ST,ANGLE,SPHERE