[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:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by dustymugs):

 robe,

 I've processed the sample aerial you attached using the following:

 {{{
 raster2pgsql -s 26986 -t 100x100 -F -l 2 -I -Y 23128870.sid.jpg aerial >
 aerial.sql
 }}}

 On qgis with a modified PostGIS Raster plugin (to support the latest
 raster_columns and raster_overviews, I can zip the python files and pass
 it to you if you want), everything (base raster and overview) looks good.
 I also checked the vector representations of the base raster and overview
 in qgis and everything is where you'd expect them to be.

 Your aerial did find a bug in the ST_SameAlignment code though that I had
 to fix.

 Got to love floating point quirks as the same reference raster of mine
 never caused me any of the rounding issues.

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