mysql地理坐标_mysql中如何将地理坐标拆成经度和纬度两份？

已解决

分割经纬度：

SELECT f1, start_loc, end_loc,

SUBSTR(start_loc, 2, 17) AS 'start_weidu',

SUBSTR(start_loc, -19, 18) AS 'start_jingdu',

SUBSTR(end_loc, 2, 17) AS 'end_weidu',

SUBSTRING(end_loc, -19, 18) AS 'end_jingdu'

FROM processed_data;

距离计算

SELECT

start_jingdu, start_weidu, end_jingdu, end_weidu, ROUND(

6378.138 * 2 * ASIN(

SQRT(

POW(

SIN(

(

start_weidu * PI() / 180 - end_weidu * PI() / 180

) / 2

),

2

) + COS(start_weidu * PI() / 180) * COS(end_weidu * PI() / 180) * POW(

SIN(

(

start_jingdu * PI() / 180 - end_jingdu * PI() / 180

) / 2

),

2

)

)

) * 1000

) AS distance

FROM jingweidu