[postgis-users] in-base raster wrong use by gdalinfo and gdal_translate
Rémi Cura
remi.cura at gmail.com
Fri Mar 7 07:42:50 PST 2014
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$
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140307/fdd3c3a0/attachment.html>
More information about the postgis-users
mailing list