[postgis-users] no pixels in raster

Andreas Laggner andreas.laggner at ti.bund.de
Wed Mar 19 06:19:28 PDT 2014

Hi list,

i have some problems with raster datasets since i use postgis 2.1.1 and 
postgres 9.3.3
"POSTGIS="2.1.1 r12113" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 
March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8" 

First all my rasters were empty after restoring my dump from 2.03/9.1, 
that was no fun, but i still have the files on my harddrive, so i 
imported them again:
raster2pgsql -s 31467 -I -C -M /disk1/samba/importdb/dgm_25.tif -t 
100x100 rast.dgm25 | psql -d gis

All seemed to be good, but as i want to use the raster, all my results 
were empty.

All my imported rasters are empty! Trying to convert the raster to 
Polygons returns "No pixels found for band 1"

The raster files are the same that i imported two months ago to 
2.03/9.1, the raster2pgsql-command is the same too.

Thanks, Cheers,


Dipl. Geoökologe Andreas Laggner

Thünen-Institut für Agrarklimaschutz (AK)
Arbeitsgruppe Emissionsinventare
Johann Heinrich von Thünen-Institut (vTI),
Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei

Thünen Institute of Climate-Smart Agriculture
Johann Heinrich von Thünen Institute (vTI),
Federal Research Institute for Rural Areas, Forestry and Fisheries

Bundesallee 50
D-38116 Braunschweig

Tel.: (+49) (0)531 596 2636
Fax : (+49) (0)531 596 2645
E-mail: andreas.laggner at ti.bund.de
Homepage: http://www.ti.bund.de

More information about the postgis-users mailing list