Opened 14 months ago

Closed 14 months ago

Last modified 14 months ago

#4480 closed defect (fixed)

Geography Distance inconsistent with Intersects

Reported by: pramsey Owned by: pramsey
Priority: high Milestone: PostGIS 2.5.4
Component: postgis Version: 2.4.x
Keywords: Cc:

Description

https://lists.osgeo.org/pipermail/postgis-users/2019-August/043466.html

we found some unexpected results when doing spatial queries on very
large geography polygons. For example

    SELECT ST_Distance(ST_SetSRID( ST_MakeBox2D(ST_Point(160,
60),ST_Point(-160,-60)), 4326)::geography,ST_SetSRID(ST_Point(0, 0),
4326)::geography)/1000

returns 13130km instead of 0 as the point 0,0 should be inside this polygon.

Change History (4)

comment:1 Changed 14 months ago by pramsey

In 17704:

branch 2.4: Geography Distance inconsistent with Intersects
References #4480

comment:2 Changed 14 months ago by pramsey

In 17705:

branch 2.5: Geography Distance inconsistent with Intersects
References #4480

comment:3 Changed 14 months ago by pramsey

Resolution: fixed
Status: newclosed

In 17706:

Geography Distance inconsistent with Intersects
Closes #4480

comment:4 Changed 14 months ago by robe

Milestone: PostGIS 2.5.3PostGIS 2.5.4
Note: See TracTickets for help on using tickets.