[raster] Possible issue with resize function outdb rasters
|Reported by:||robe||Owned by:||Bborie Park|
I have this folder of aircraft pictures that I registered as outdb and then ran a query for resizing. They are all bmp files and for some reason some of them when I resize turn black. It doesn't seem to matter what percent or width /height I apply for resizing.
The commands I am using to register are:
raster2pgsql -F -Y -R C:/jet_photos/*.bmp staging_pics | psql
The query I was using to get resized versions looks like this:
SELECT ST_AsPNG(ST_Resize(rast,0.5,0.5 )) As thumb_pic FROM staging_pics WHERE filename = 'Grand Caravan.bmp';
A lot of them resize fine and some don't but all look okay if no resize operation is applied.
I'm using the latest winnie 64-bit 9.2 buildbot build.
PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 64-bit POSTGIS="2.1.0SVN r11004" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER
I'll send you a couple of good and bad pictures (those that resize fine and some that don't). I would attach to this ticket, but they are client pictures so can't disclose publicly.
Change History (10)
comment:1 by , 11 years ago
|Summary:||raster: Possible issue with resize function → raster: Possible issue with resize function outdb rasters|
comment:9 by , 11 years ago
|Summary:||raster: Possible issue with resize function outdb rasters → [raster] Possible issue with resize function outdb rasters|