[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