[postgis-tickets] [PostGIS] #2495: geography && large_bbox fails

PostGIS trac at osgeo.org
Fri Oct 18 10:38:46 PDT 2013


#2495: geography && large_bbox fails
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.1.1
Component:  postgis  |     Version:  2.1.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by pramsey):

 Geography bounding boxes are constructed in geocentric space (x/y/z) from
 objects inscribed on a unit sphere using spherical coordinates
 (theta/phi).  So, the north pole (0,90) in spherical coordinates is
 (0,0,1) in geocentric coordinates. This is one reason why geographic
 "bounding boxes" are hidden from end users: they'll never understand WTF
 is going on w/ them.

 Your "181 degrees wide" box is not 181 degrees wide, there's no such
 thing, in a world where ever arc is defined as the "shortest route between
 two points". It's 179 degrees wide, across the opposite side of the world
 you expect. The overlaps result is correct. Similarly, the "180 degrees
 wide" box is not actually 180 degrees wide, since the shortest great
 circle connecting 90,1 to -90,1 has to run over longitude 0 (check it
 out). A truly 180 degree line would be from 90,0 to -90,0.

 Trying to think about spherical geometry while looking at a mercator map
 is a recipe for a broken brain. Put a globe on your desk and get a piece
 of string.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2495#comment:7>
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