Opened 5 years ago

Closed 5 years ago

Last modified 5 years 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 by pramsey, 5 years ago

In 17704:

branch 2.4: Geography Distance inconsistent with Intersects
References #4480

comment:2 by pramsey, 5 years ago

In 17705:

branch 2.5: Geography Distance inconsistent with Intersects
References #4480

comment:3 by pramsey, 5 years ago

Resolution: → fixed
Status: new → closed

In 17706:

Geography Distance inconsistent with Intersects
Closes #4480

comment:4 by robe, 5 years ago

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