[postgis-tickets] [PostGIS] #2229: [raster] Instability with st_intersection/st_intersects

[PostGIS]

#2229: [raster] Instability with st_intersection/st_intersects
--------------------+-------------------------------------------------------
 Reporter:  kib     |       Owner:  dustymugs
     Type:  defect  |      Status:  new      
 Priority:  high    |   Milestone:           
Component:  raster  |     Version:  2.0.x    
 Keywords:          |  
--------------------+-------------------------------------------------------

Comment(by dustymugs):

 Replying to [comment:13 pracine]:
 > This happens because ST_Intersection() return less polygons for one
 raster because it returns neigbour pixel sharing a same value as only one
 polygon. Use ST_PixelAsPolygons(ST_Clip(d52_2012112701_4.rast, pos.geom))
 instead of ST_Intersection(d52_2012112701_4.rast, pos.geom)...

 Good call pracine.  I forgot how ST_Intersection works.  This would
 explain the behavior.

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