[postgis-users] no pixels in raster

[Rémi Cura]

Hey,
I encountered countinuous trouble with raster regarding gdal.
Only working solution for me was to update it.
Also,
maybe you could write
raster2pgsql -s 31467 -I -C -M /disk1/samba/importdb/dgm_25.t
if -t 100x100 rast.dgm25 |
to disk,
so to see what it says,
then try to manually execute it in psql to see if error or notice arise.

Cheers,
Rémi-C



2014-03-19 14:19 GMT+01:00 Andreas Laggner <andreas.laggner at ti.bund.de>:

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