ST_DistanceSphere — Returns minimum distance in meters between two lon/lat geometries using a spherical earth model.
float ST_DistanceSphere(geometry geomlonlatA, geometry geomlonlatB, float8 radius=6371008);
Returns minimum distance in meters between two lon/lat points. Uses a spherical earth and radius derived from the spheroid defined by the SRID. Faster than ST_DistanceSpheroid, but less accurate. PostGIS Versions prior to 1.5 only implemented for points.
Availability: 1.5 - support for other geometry types besides points was introduced. Prior versions only work with points.
Changed: 2.2.0 In prior versions this used to be called ST_Distance_Sphere
WITH sample AS (
SELECT
ST_GeomFromText('LINESTRING(-118.584 38.374,-118.583 38.5)', 4326) AS geom,
ST_GeomFromText('POINT(-118 38)', 4326) AS pt
)
SELECT
round(ST_DistanceSphere(ST_Centroid(geom), pt)::numeric, 2) AS dist_meters,
round(ST_Distance(
ST_Transform(ST_Centroid(geom), 32611),
ST_Transform(pt, 32611)
)::numeric, 2) AS dist_utm11_meters,
round(ST_Distance(ST_Centroid(geom), pt)::numeric, 5) AS dist_degrees,
round(ST_Distance(
ST_Transform(geom, 32611),
ST_Transform(pt, 32611)
)::numeric, 2) AS min_dist_line_point_meters
FROM sample;
dist_meters | dist_utm11_meters | dist_degrees | min_dist_line_point_meters
-------------+-------------------+--------------+----------------------------
70424.71 | 70438.00 | 0.72900 | 65871.18