<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<span style="font-size:10pt"><div>Hi,</div>
<div>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:</div>
<div> </div>
<div>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</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>I tried the stable version 1.9 MSVC2008 (Win32) and development version available today at <a href="https://email.nrcan.gc.ca/owa/redir.aspx?C=OzXx4wlk90m3TV7W8fzG7_FxObjPB88I1bAwXOtZColSmDyhIvj_1yhbCVJUJ0vrnCWWTuivB9Y.&URL=http://www.gisinternals.com/sdk/" target="_blank"><font color="blue"><u>http://www.gisinternals.com/sdk/</u></font></a>
and I have still the same problem. For your information, I'm running
GDAL on windows7 and PostGIS 2.0 is installed on a 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 a project
where processing time is very important.</div>
<div> </div>
<div><span id="result_box" class="short_text" lang="en"><span class="hps">Does</span> <span class="hps">anybody have any idea</span> <span class="hps">about this problem</span></span> ?</div>
<div> </div>
<div>Thanks<br><br>David Bélanger<br></div></span> </div></body>
</html>