[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