[postgis-tickets] [PostGIS] #2203: [raster]: Can't read out_db jpg in some cases

[PostGIS]

#2203: [raster]: Can't read out_db jpg in some cases
---------------------+------------------------------------------------------
  Reporter:  robe    |       Owner:  dustymugs    
      Type:  defect  |      Status:  assigned     
  Priority:  medium  |   Milestone:  PostGIS 2.1.0
 Component:  raster  |     Version:  trunk        
Resolution:          |    Keywords:  history      
---------------------+------------------------------------------------------

Comment(by dustymugs):

 Ah.  I think I may be onto something...

 {{{
 NOTICE:  [rt_api.c:rt_band_load_offline_data:1631] Raster geotransform
 (0.000000, 1.000000, 0.000000, 0.000000, 0.000000, -1.000000)
 NOTICE:  [rt_api.c:rt_band_load_offline_data:1636] Offline geotransform
 (0.000000, 1.000000, 0.000000, 0.000000, 0.000000, 1.000000)
 }}}

 That -1 vs 1 Y-scale will cause issues.  I'm going to have to chew on this
 since it will involve poking at raster2pgsql (at it specifies the generic
 geotransform).

 Just for kicks, can you up date the Y-scale of the raster and then rerun
 ST_SummaryStats()?

 {{{
 UPDATE armory_outdb SET rast = ST_SetScale(rast, 1, 1)
 }}}

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