[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