[PostGIS] #5765: Incorrect distance between geography polygons
PostGIS
trac at osgeo.org
Tue Aug 6 11:14:18 PDT 2024
#5765: Incorrect distance between geography polygons
-------------------------+----------------------------
Reporter: Mike Taves | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.1.12
Component: postgis | Version: 3.1.x
Resolution: | Keywords:
-------------------------+----------------------------
Comment (by pramsey):
Minimal reproducer
{{{
SELECT ST_Distance(ST_Transform(A, 27700), ST_Transform(B, 27700)) AS
distance_27700,
ST_DistanceSpheroid(A, B, 'SPHEROID["WGS 84",6378137,298.257223563]') AS
DistanceSpheroid,
ST_DistanceSphere(A, B) AS DistanceSphere,
ST_Distance(A::geography, B::geography, true) AS
distance_geography_spheroid,
ST_Distance(A::geography, B::geography, false) AS
distance_geography_sphere
FROM (
SELECT
ST_GeomFromText('LINESTRING (
-1.7485528426344 52.477970893914,
-1.7485638876537 52.477970467863,
-1.7485727216213 52.477970486617
)', 4326) AS A,
ST_GeomFromText('LINESTRING (
-1.7486648265496 52.477955848635,
-1.7485639721184 52.477955634571,
-1.7484653236191 52.477955874604
)', 4326) AS B
) AS data;
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5765#comment:3>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list