[postgis-tickets] [PostGIS] #2556: geography ST_Intersects results depending on insert order

PostGIS trac at osgeo.org
Mon Feb 3 18:52:50 PST 2014


#2556: geography ST_Intersects results depending on insert order
--------------------------------------------------+-------------------------
 Reporter:  gekorob                               |       Owner:  pramsey      
     Type:  defect                                |      Status:  new          
 Priority:  high                                  |   Milestone:  PostGIS 2.1.2
Component:  postgis                               |     Version:  2.1.x        
 Keywords:  st_intersects intersection geography  |  
--------------------------------------------------+-------------------------

Comment(by robe):

 I think I wrote too much on this thread and it confused you.  The
 _ST_DistanceUncached and _ST_DistanceTree I couldn't get to disagree with
 these examples (that is because the CircTreePIP kicks out with  0

 http://postgis.net/docs/doxygen/2.2/d8/de3/geography__measurement__trees_8c_aa4c02294d4d0a4bd5822023f9e29cc8e.html#aa4c02294d4d0a4bd5822023f9e29cc8e


 so circ_tree_distance_tree is not run.

 However with the ST_Distance (cached version), it disagrees with
 _ST_DistanceTree in these examples (because you only have one CircTreePIP
 check safety net -- so it falls into the  circ_tree_distance_tree  which
 returns a boundary distance (so when one is inside another if the PIP you
 are checking is the right one it will return the right answer and if not
 it returns the boundary distance.

 http://postgis.net/docs/doxygen/2.2/d8/de3/geography__measurement__trees_8c_a399a5e30071a3979b414ce094ff94de9.html#a399a5e30071a3979b414ce094ff94de9

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