[postgis-devel] [PostGIS] #1976: ST_Intersects() returns false while ST_Intersection returns a geography
PostGIS
trac at osgeo.org
Mon Oct 22 12:19:03 PDT 2012
#1976: ST_Intersects() returns false while ST_Intersection returns a geography
------------------------+---------------------------------------------------
Reporter: mhiper3pg | Owner: pramsey
Type: defect | Status: reopened
Priority: medium | Milestone: PostGIS 1.5.6
Component: postgis | Version: 1.5.X
Resolution: | Keywords:
------------------------+---------------------------------------------------
Comment(by pramsey):
OK, so the speed difference is because between 1.5 and 2.0 we switched
from passing boxes into the distance function as part of the signature to
letting them ride in implicitly on the lwgeom objects. The trouble with
the latter is that the distance function recursively unwraps the
geometries, so that when collections get unwrapped, the lwgeom of their
sub-geometries that get passed into the next call DO NOT HAVE boxes
defined. So they get calculated on the fly, expensively. We need an
lwgeom_add_box_deep to add boxes all the way down into lwgeoms for each
element.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1976#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-devel
mailing list