[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