[postgis-users] no pixels in raster

[Pierre Racine]

What happen when you dump only a raster table or schema without using the pg_dump -b option?

Pierre
________________________________________
From: postgis-users-bounces at lists.osgeo.org [postgis-users-bounces at lists.osgeo.org] On Behalf Of Bborie Park [dustymugs at gmail.com]
Sent: Wednesday, March 19, 2014 12:04 PM
To: andreas.laggner at ti.bund.de
Cc: PostGIS Users Discussion
Subject: Re: [postgis-users] no pixels in raster

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<mailto: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<mailto: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<tel:%28%2B49%29%20%280%29531%20596%202636>
Fax : (+49) (0)531 596 2645<tel:%28%2B49%29%20%280%29531%20596%202645>
E-mail: andreas.laggner at ti.bund.de<mailto:andreas.laggner at ti.bund.de>
Homepage: http://www.ti.bund.de

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto: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<tel:%28%2B49%29%20%280%29531%20596%202636>
Fax : (+49) (0)531 596 2645<tel:%28%2B49%29%20%280%29531%20596%202645>
E-mail: andreas.laggner at ti.bund.de<mailto:andreas.laggner at ti.bund.de>
Homepage: http://www.ti.bund.de