[postgis-users] in-base raster wrong use by gdalinfo and gdal_translate

[Rémi Cura]

Thanks,
Following you advice I'm in the process of upgrading gdal,
no success yet .

Cheers,

Rémi-C


2014-03-07 17:06 GMT+01:00 Bborie Park <dustymugs at gmail.com>:

> It sounds like it might be a problem with the GDAL PostGIS Raster driver.
> From the GDAL driver page, it looks like they recommend 1.10.1...
>
> http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html
>
>
> On Fri, Mar 7, 2014 at 7:42 AM, Rémi Cura <remi.cura at gmail.com> wrote:
>
>> Hey,
>> I am faced with a problem I can't solve :
>>
>> I have a raster obtained by using st_setvalues and several points.
>>
>> The raster has 2 bands, half of the pixel being set.
>>
>> Using the st_pixelaspolygons and the ST_SummaryStats I am sure that some
>> of the pixels of the raster are set.
>>
>> Now when I use gdalinfo or gdal_translate on this in-base raster, it
>> gives the correct information about the raster (size, position, band type,
>> etc),
>> *but the raster has no pixel set!*
>>
>> I tried several combination of parameters with non luck.
>>
>>
>> postgis version :
>>
>> --POSTGIS="2.1.0 r11822" GEOS="3.5.0dev-CAPI-1.9.0 r3963" PROJ="Rel.
>> 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.8.0"
>> RASTER
>>
>> postgres version : 9.3.3
>>
>>
>> Summary :
>> Raster of 50x50 pixels has 2 bands and extent of BOX(1913.5 20887.5,1914.5
>> 20888.5)
>>     band 1 of pixtype 32BSI is in-db with NODATA value of -100000
>>     band 2 of pixtype 32BSI is in-db with NODATA value of -100000
>>
>> Band 1 contains(histogram, excluding null values):
>> 41660    41666.6666666667    32    0.039360393603936
>> 41666.6666666667    41673.3333333333    0    0
>> 41673.3333333333    41680    0    0
>> 41680    41686.6666666667    656    0.806888068880689
>> 41686.6666666667    41693.3333333333    0    0
>> 41693.3333333333    41700    125    0.153751537515375
>>
>> gdalinfo :
>>  gdalinfo  "PG:host=localhost port=5433 dbname='test_pointcloud'
>> user='postgres' password='youguess' schema='test_raster'
>> table='patch_to_raster'" -stats
>> Driver: PostGISRaster/PostGIS Raster driver
>> Files: none associated
>> Size is 50, 50
>> Coordinate System is:
>> * CORRECT*
>> Origin = (1913.500000000000000,20887.500000000000000)
>> Pixel Size = (0.020000000000000,0.020000000000000)
>> Corner Coordinates:
>> Upper Left  (    1913.500,   20887.500) (  1d21'30.09"W,  5d51'10.78"S)
>> Lower Left  (    1913.500,   20888.500) (  1d21'30.09"W,  5d51'10.75"S)
>> Upper Right (    1914.500,   20887.500) (  1d21'30.06"W,  5d51'10.78"S)
>> Lower Right (    1914.500,   20888.500) (  1d21'30.07"W,  5d51'10.75"S)
>> Center      (    1914.000,   20888.000) (  1d21'30.08"W,  5d51'10.76"S)
>> Band 1 Block=50x50 Type=Int32, ColorInterp=Undefined
>>   Minimum=0.000, Maximum=0.000, Mean=0.000, StdDev=0.000
>>   NoData Value=-100000
>>   Metadata:
>>     STATISTICS_MAXIMUM=0
>>     STATISTICS_MEAN=0
>>     STATISTICS_MINIMUM=0
>>     STATISTICS_STDDEV=0
>> Band 2 Block=50x50 Type=Int32, ColorInterp=Undefined
>>   Minimum=0.000, Maximum=0.000, Mean=0.000, StdDev=0.000
>>   NoData Value=-100000
>>   Metadata:
>>     STATISTICS_MAXIMUM=0
>>     STATISTICS_MEAN=0
>>     STATISTICS_MINIMUM=0
>>     STATISTICS_STDDEV=0
>> remi at RemiCura-VirtualUbuntu:/media/sf_E_RemiCura/PROJETS/PC_in_DB/Raster/exported$
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140307/81c2645e/attachment.html>