[postgis-users] no pixels in raster

[Andreas Laggner]

Everything was ok, no errors and no warnings, like it is when i import 
raster now. But there are no pixel values!!

I think it has something to do with my PostGIS installation and gdal....




Am 19.03.2014 16:50, schrieb Bborie Park:
> What was the output when restoring your backup? And what was your restore
> command?
>
> I've never had problems dumping and restoring in my production environments.
>
> -bborie
>
>
> On Wed, Mar 19, 2014 at 6:19 AM, Andreas Laggner <andreas.laggner at ti.bund.de
>> wrote:
>> 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"
>> LIBJSON="UNKNOWN" TOPOLOGY RASTER"
>>
>> 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,
>>
>> Andreas
>>
>> --
>> 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
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>

-- 
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