[postgis-tickets] [PostGIS] #5437: ST_Intersects polygon geography empty results
PostGIS
trac at osgeo.org
Wed Jul 12 15:52:49 PDT 2023
#5437: ST_Intersects polygon geography empty results
-----------------------------------+---------------------------
Reporter: royjacksonalertmedia | Owner: pramsey
Type: defect | Status: closed
Priority: medium | Milestone: PostGIS 3.3.4
Component: postgis | Version: 3.3.x
Resolution: invalid | Keywords:
-----------------------------------+---------------------------
Changes (by pramsey):
* status: new => closed
* resolution: => invalid
Comment:
Remember that all lines in geography are great circles, and that the
further north you get the more a "horizontal" line in equirectangular
projection will in fact arc northward, until in the limit it is going over
the pole. This constantly trips people up applying "rectangular" boxes
from flat mapping UIs to geography, and I do not see any way to "fix" it
that does not do damage to peoples understanding in some other way. We
just aren't use to reasoning about spherical geometry in general.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5437#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