PostGIS 如何计算两个经纬度之间的距离

记录一下如何使用PostGIS计算两个点之间的距离

SELECT ST_Distance(ST_GeomFromText('POINT(120.30 30.06)')::geography, ST_GeomFromText('POINT(120.36 30.16)')::geography));

注意：如果POINT是3857坐标系的，就需要转一下，转成4326坐标系的再进行计算，如下所示

SELECT ST_Distance(ST_GeomFromText('POINT(lon1 lat1)', 4326)::geography, ST_GeomFromText('POINT(lon2 lat2)', 4326)::geography);