[postgis-users] no pixels in raster

[Bborie Park]

If your restored raster data was in-db, it would have nothing to do with
GDAL. GDAL only kicks in when accessing out-db raster, polygonization and
warping...

Are you able to post the output of ST_Metadata() and ST_BandMetadata() for
one of the rasters in the database that returning no values?

-bborie


On Wed, Mar 19, 2014 at 9:02 AM, Andreas Laggner <andreas.laggner at ti.bund.de
> wrote:

> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140319/5c16c891/attachment.html>