時(shí)間:2024-02-07 12:09作者:下載吧人氣:23
之前用的是ST_Distance 函數(shù),但是貌似需要進(jìn)行一次單位的轉(zhuǎn)換,而且網(wǎng)上有說那種轉(zhuǎn)換不是特別準(zhǔn)確,現(xiàn)在暫時(shí)將該算法記錄在此:
select st_distance(ST_GeomFromText(‘POINT(120.451737 36.520975)’,900913),ST_GeomFromText(‘POINT(120.455636 36.520885)’,900913))*60*1.852;
網(wǎng)友評論