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

PostGIS trac at osgeo.org
Sat Feb 16 22:33:57 PST 2013


#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 robe):

 After running:


 {{{
 UPDATE armory_outdb SET rast = ST_SetScale(rast, 1, 1);
 SELECT ST_SummaryStats(rast) from armory_outdb;
 }}}

 I get:
 {{{
 NOTICE:  [rt_api.c:rt_raster_deserialize:8122] rt_raster_deserialize:
 Entering...
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8130] rt_raster_deserialize:
 Allocating memory for deserialized raster header
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8138] rt_raster_deserialize:
 Deserialize raster header
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8149] rt_raster_deserialize:
 Allocating memory for bands
 CONTEXT:  SQL function "st_summarystats" statement 1

 NOTICE:  [rt_api.c:rt_raster_deserialize:8157] rt_raster_deserialize: 3
 bands
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8183] rt_raster_deserialize: band
 0 with pixel type 8BUI
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_pixtype_size:973] Pixel type = 8BUI and size = 1
 bytes
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8251] rt_raster_deserialize: has
 nodata flag 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8252] rt_raster_deserialize:
 nodata value 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8295] rt_raster_deserialize: skip
 4 bytes of 8-bytes boundary padding
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8183] rt_raster_deserialize: band
 1 with pixel type 8BUI
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_pixtype_size:973] Pixel type = 8BUI and size = 1
 bytes
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8251] rt_raster_deserialize: has
 nodata flag 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8252] rt_raster_deserialize:
 nodata value 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8295] rt_raster_deserialize: skip
 4 bytes of 8-bytes boundary padding
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8183] rt_raster_deserialize: band
 2 with pixel type 8BUI
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_pixtype_size:973] Pixel type = 8BUI and size = 1
 bytes
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8251] rt_raster_deserialize: has
 nodata flag 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8252] rt_raster_deserialize:
 nodata value 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8295] rt_raster_deserialize: skip
 4 bytes of 8-bytes boundary padding
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3126] starting
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3161] nodata = 0.000000
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3162] hasnodata = 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3163] exclude_nodata_value =
 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3207] do_sample = 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3229] sampling 27000000 of
 27000000 available pixels w/ 4500 per set
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_load_offline_data:1631] Raster geotransform
 (0.000000, 1.000000, 0.000000, 0.000000, 0.000000, 1.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_load_offline_data:1636] Offline geotransform
 (0.000000, 1.000000, 0.000000, 0.000000, 0.000000, 1.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_new:5188] Created rt_raster @
 00000000049759D8
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_geopoint_to_cell:5925] GDALApplyGeoTransform
 (g -> c) for (0.000000, 0.000000) = (0.000000, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_geopoint_to_cell:5940] Corrected
 GDALApplyGeoTransform (g -> c) for (0.000000, 0.000000) = (-0.000000,
 -0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_cell_to_geopoint:5871] gt = (0.000000,
 1.000000, 0.000000, 0.000000, 0.000000, 1.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_cell_to_geopoint:5875] GDALApplyGeoTransform
 (c -> g) for (-0.000000, -0.000000) = (0.000000, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_same_alignment:12569] rast1(ipX, ipxY) =
 (0.000000, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_same_alignment:12570] rast2(xr, yr) =
 (-0.000000, -0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_same_alignment:12571] rast2(xw, yw) =
 (0.000000, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_destroy:5217] Destroying rt_raster @
 00000000049759D8
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_geopoint_to_cell:5925] GDALApplyGeoTransform
 (g -> c) for (0.000000, 0.000000) = (0.000000, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_geopoint_to_cell:5940] Corrected
 GDALApplyGeoTransform (g -> c) for (0.000000, 0.000000) = (-0.000000,
 -0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_load_offline_data:1659] offsets: (-0.000000,
 -0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9118] Raster dimensions
 (width x height): 6000 x 4500
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9121] Creating new raster
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_new:5188] Created rt_raster @
 00000000049759D8
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9127] Created raster
 dimensions (width x height): 6000 x 4500
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9141] Raster geotransform
 (0.000000, 1.000000, 0.000000, 0.000000, 0.000000, 1.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9174] GDAL Band 1 stats:
 0.000000, 255.000000, 98.720363, 81.487081
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9180] Processing band 1 of
 1
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_pixtype_size:973] Pixel type = 8BUI and size = 1
 bytes
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9202] GDAL band dimensions
 (width x height): 6000 x 4500
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9212] (hasnodata,
 nodataval) = (0, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_pixtype_size:973] Pixel type = 8BUI and size = 1
 bytes
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_new_inline:1328] Created rt_band @
 0000000004975A70 with pixtype 8BUI
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_new_inline:1341] Created rt_band with
 dimensions 6000 x 4500
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_add_band:5507] Adding band 0000000004975A70
 to raster 00000000049759D8
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_add_band:5523] Oldbands at 0000000000000000
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_add_band:5529] Checking bands
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_add_band:5538] realloc returned
 0000000004975B08
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_add_band:5555] Raster now has 1 bands
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9226] Created band of
 dimension (width x height): 6000 x 4500
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9232] (nXBlockSize,
 nYBlockSize) = (128, 128)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9233] (nXBlocks, nYBlocks)
 = (47, 36)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9270] values len = 16384
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9276] (iXBlock, iYBlock) =
 (0, 0)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9277] (x, y) = (0, 0)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9293] (nXValid, nYValid) =
 (128, 128)
 CONTEXT:  SQL function "st_summarystats" statement 1
 }}}

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


More information about the postgis-tickets mailing list