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

Comment(by robe):

 gdalinfo

 {{{
 Driver: JPEG/JPEG JFIF
 Files: back.jpg
 Size is 6000, 4500
 Coordinate System is `'
 Metadata:
   EXIF_ColorSpace=1
   EXIF_DateTime=2012:11:28 15:18:54
   EXIF_Orientation=1
   EXIF_PixelXDimension=6000
   EXIF_PixelYDimension=4500
   EXIF_ResolutionUnit=2
   EXIF_Software=Adobe Photoshop CS3 Windows
   EXIF_XResolution=(150)
   EXIF_YResolution=(150)
 Image Structure Metadata:
   COMPRESSION=JPEG
   INTERLEAVE=PIXEL
   SOURCE_COLOR_SPACE=YCbCr
 Corner Coordinates:
 Upper Left  (    0.0,    0.0)
 Lower Left  (    0.0, 4500.0)
 Upper Right ( 6000.0,    0.0)
 Lower Right ( 6000.0, 4500.0)
 Center      ( 3000.0, 2250.0)
 Band 1 Block=6000x1 Type=Byte, ColorInterp=Red
   Overviews: 3000x2250, 1500x1125, 750x563
   Image Structure Metadata:
     COMPRESSION=JPEG
 Band 2 Block=6000x1 Type=Byte, ColorInterp=Green
   Overviews: 3000x2250, 1500x1125, 750x563
   Image Structure Metadata:
     COMPRESSION=JPEG
 Band 3 Block=6000x1 Type=Byte, ColorInterp=Blue
   Overviews: 3000x2250, 1500x1125, 750x563
   Image Structure Metadata:
     COMPRESSION=JPEG
 }}}

 I think on my server I was getting a can't create VRT or something (I
 presume because it has overviews?) (as I recall it wouldn't even load some
 of the pics using in db, though perhaps this particular one was not one I
 tested on prod server)


 {{{
 SELECT (ST_MetaData(rast)).*
 from armory_outdb;
 }}}

 outputs

 {{{
  upperleftx | upperlefty | width | height | scalex | scaley | skewx |
 skewy | srid| numbands
 ------------+------------+-------+--------+--------+--------+-------+-------+---
 ---+----------
           0 |          0 |  6000 |   4500 |      1 |     -1 |     0 |
 0 |
  0 |        3
 }}}

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