<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'>
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:HyphenationZone>21</w:HyphenationZone>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Tableau Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]-->
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA">Hi,</span></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA">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.</span></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA"> </span></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA">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:</span></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA">gdal_translate"
-a_nodata "-32767" -of GTIFF<span style="mso-spacerun:yes">
</span>"PG:host=myhost port=14070 dbname='mybd' user='myuser' password='mypassword'
schema='myschema' table='Elevation' mode=2 where=\"filename LIKE
\'%056n05%\'\" " 056N05.tif</span></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA"> </span></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA">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.</span></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA"> </span></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA">Does anyone
know this problem and can you help me?</span></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA"> </span></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA">Thanks</span></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-CA" lang="EN-CA">David</span></p>
</div></body>
</html>