[gdal-dev] GDAL 1.9 and PostGis raster

[David B�langer]

Hi,
I have tried the version MSVC2008 (Win32) -development available today  at  http://www.gisinternals.com/sdk/ and I have still the same problem. For your information, I'm running GDAL on windows with a PostGIS 2.0 connection on Linux server. I tried many version of GDAL 1.9 and I always have the same problem. The version 1.8 is working very well but I would like to take advantage of the improvements in the last version because I'm working on an important project in Canada where processing time is very important.

Does any developper has an idea for this problem ?
 
Thanks
 
David Bélanger
 
 
 

> Date: Wed, 16 May 2012 07:38:30 -0700
> Subject: Re: [gdal-dev] GDAL 1.9 and PostGis raster
> From: bkpark at ucdavis.edu
> To: belanger_david at live.ca
> 
> David,
> 
> The PostGIS Raster driver in GDAL was and still is in a state of flux.
> GDAL 1.9 should be better than 1.8 as there were significant changes
> to PostGIS Raster before 2.0 and 2.0. You may want to try GDAL trunk.
> 
> -bborie
> 
> On Tue, May 15, 2012 at 6:37 PM, David B�langer <belanger_david at live.ca> wrote:
> > Hi,
> >
> > I stored DEM raster data in  PostGIS 2.0 and I used gdal_translate (with
> > mode=2) to extract a mosaic of tiles. When I’m using GDAL 1.8 is working but
> > when I’m using GDAL 1.9 I can see the values of pixel for just one tile.
> >
> >
> >
> > For example I uploaded in the database a tile with an attribute
> > filename=056n05_w and an other tile with an filename=056n05_e and I executed
> > the command with GDAL 1.8 and GDAL 1.9:
> >
> > gdal_translate" -a_nodata "-32767" -of GTIFF  "PG:host=myhost port=14070
> > dbname='mybd' user='myuser' password='mypassword' schema='myschema'
> > table='Elevation' mode=2 where=\"filename LIKE \'%056n05%\'\" " 056N05.tif
> >
> >
> >
> > With GDAL 1.8 I obtained a mosaic of 2 tiles (the result expected) but with
> > GDAL 1.9, I obtained a raster with the same extent but only the values of
> > the tile 056n05_w are present. The pixels of the tile 056n05_w have a value
> > 0.
> >
> >
> >
> > Does anyone know this problem and can you help me?
> >
> >
> >
> > Thanks
> >
> > David
> >
> >
> > _______________________________________________
> > gdal-dev mailing list
> > gdal-dev at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/gdal-dev
> 
> 
> 
> -- 
> Bborie Park
> Programmer
> Center for Vectorborne Diseases
> UC Davis
> 530-752-8380
> bkpark at ucdavis.edu
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120516/38d65ee2/attachment.html