[postgis-tickets] [PostGIS] #3446: [raster] Error with topology reported on clean geometries when using ST_Intersection

[PostGIS]

#3446: [raster] Error with topology reported on clean geometries when using
ST_Intersection
------------------------------------+---------------------------
 Reporter:  gdrolet                 |      Owner:  dustymugs
     Type:  defect                  |     Status:  new
 Priority:  critical                |  Milestone:  PostGIS 2.2.2
Component:  raster                  |    Version:  trunk
 Keywords:  raster ST_Intersectino  |
------------------------------------+---------------------------
 I get the following error when using ST_Intersection (raster, geometry) in
 development version 2.3:


 {{{
 ERROR:  GEOSIntersects: TopologyException: side location conflict at
 1749960.0258611713 1220621.9908729347
 CONTEXT:  PL/pgSQL function _st_intersects(geometry,raster,integer) line
 22 at RETURN
 PL/pgSQL function st_intersection(geometry,raster,integer) line 5 at
 assignment
 SQL function "st_intersection" statement 1
 }}}


 The call that generates this error is:

 {{{

 SELECT  ST_Intersection(rt.rast, gt.geom) gv
 FROM    raster_100x100_indb_single rt,
         polygons gt
 WHERE   ST_Intersects(rt.rast, gt.geom) and
         gid = 7
 }}}

 Version with the error is:


 {{{
 postgis_full_version | POSTGIS="2.3.0dev r14604" GEOS="3.5.0-CAPI-1.9.0
 r4090" PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 2.0.1, released
 2015/09/15" LIBXML="2.7.8" LIBJSON="0.12" RASTER

 }}}

 No error is thrown when using the exact same query on the exact same data
 with this version:


 {{{
 postgis_full_version | POSTGIS="2.1.8 r13780" GEOS="3.4.2-CAPI-1.8.2
 r3924" PROJ
 ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24"
 LIBXML="2.7.
 8" LIBJSON="UNKNOWN" TOPOLOGY RASTER
 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3446>
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.