[postgis-devel] [PostGIS] #1404: [raster] raster2pgsql overviews don't look right

[PostGIS]

#1404: [raster] raster2pgsql overviews don't look right
-----------------------------+----------------------------------------------
  Reporter:  robe            |       Owner:  pracine      
      Type:  defect          |      Status:  reopened     
  Priority:  medium          |   Milestone:  PostGIS 2.0.0
 Component:  postgis raster  |     Version:  trunk        
Resolution:                  |    Keywords:               
-----------------------------+----------------------------------------------

Comment(by robe):

 Slight corrections -- these are the queries I meant to post.


 {{{ -- returns 4, 0
 SELECT  Count(o2.rast) AS bbox_inter
         , COUNT(CASE WHEN ST_Intersects(o.rast, o2.rast) THEN 1 ELSE NULL
 END) As inter
  FROM boston_test_125_125_Y As o INNER JOIN
         o_2_boston_test_125_125_Y AS o2 ON o.rast && o2.rast
 WHERE ST_Intersects(o.rast, ST_SetSRID(ST_Point(231724, 886309), 26986));


 -- returns 4,4
 SELECT  Count(o2.rast) AS bbox_inter
         , COUNT(CASE WHEN ST_Intersects(o.rast, o2.rast) THEN 1 ELSE NULL
 END) As inter
  FROM boston_test_200_200_Y As o INNER JOIN
         o_2_boston_test_200_200_Y AS o2 ON o.rast && o2.rast
 WHERE ST_Intersects(o.rast, ST_SetSRID(ST_Point(231724, 886309), 26986));
 }}}

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