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 <[email protected]>: > 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 <[email protected]> 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@RemiCura-VirtualUbuntu:/media/sf_E_RemiCura/PROJETS/PC_in_DB/Raster/exported$ >> >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
