单位是千米(km)
SELECT
*
FROM
(
SELECT
STNM,
LGTD,
lttd,
ACOS(
SIN( ( 37.382404 * 3.1415 ) / 180 ) * SIN( ( LTTD * 3.1415 ) / 180 ) + COS( ( 37.382404 * 3.1415 ) / 180 ) * COS( ( LTTD * 3.1415 ) / 180 ) * COS( ( 122.359722 * 3.1415 ) / 180 - ( LGTD * 3.1415 ) / 180 )
) * 6371.004 AS dis
FROM
ST_STBPRP_B
) B