[postgis-users] no pixels in raster

[Andreas Laggner]

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...@ti.bund.de
Homepage: http://www.ti.bund.de

_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[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

[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

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

[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

[Pierre Racine]

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

Pierre
________________________________________
From: postgis-us...@lists.osgeo.org [postgis-us...@lists.osgeo.org] On Behalf Of Bborie Park [dust...@gmail.com]
Sent: Wednesday, March 19, 2014 12:04 PM
To: andreas...@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...@ti.bund.de<mailto:andreas...@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...@ti.bund.de<mailto:andreas...@ti.bund.de>

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...@ti.bund.de<mailto:andreas...@ti.bund.de>

Homepage: http://www.ti.bund.de

_______________________________________________
postgis-users mailing list

postgi...@lists.osgeo.org<mailto:postgi...@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...@ti.bund.de<mailto:andreas...@ti.bund.de>