<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'>
<font style="font-size: 12pt;" face="Arial" size="3"><span style="font-size: 12pt;"><div><font size="2"><span style="font-size: 10pt;">Hi Pierre,</span></font></div>
<div><font size="2"><span style="font-size: 10pt;">Yes I have a unique
rid (Integer) with sequential number. I used the tool raster2pgsql.exe
to upload the data in the database. I uploaded 2 files </span></font></div>
<div><font size="2"><span style="font-size: 10pt;"> </span></font></div>
<div><font size="2"><span style="font-size: 10pt;">056n05_0100_deme.tif</span></font></div>
<div><font size="2"><span style="font-size: 10pt;">056n05_0100_demw.tif</span></font></div>
<div><font size="2"><span style="font-size: 10pt;"> </span></font></div>
<div><font size="2"><span style="font-size: 10pt;">"C:\Program
Files\PostgreSQL\9.1\bin\raster2pgsql.exe" -I -e -Y -F -s 4269
e:\dir\*.tif dbelange.elevationTest | "psql.exe" -U myuser -d myDB -h
myhost -p 14070</span></font></div>
<div><font size="2"><span style="font-size: 10pt;"> </span></font></div>
<div><font size="2"><span style="font-size: 10pt;">I used this command to extract data:</span></font></div>
<div><font size="2"><span style="font-size: 10pt;">"C:\Program
Files\GDAL\gdal_translate" -a_nodata "-32767" -of GTIFF
"PG:host=myhost port=14070 dbname='myDB' user='myuser'
password='mypassword' schema='dbelange' table='elevationTest' mode=2
where=\"filename
LIKE \'%056n05%\'\" " 056N05_testGDAL1.9.tif</span></font></div>
<div><font size="2"><span style="font-size: 10pt;"> </span></font></div>
<div><font size="2"><span style="font-size: 10pt;">Like I said it’s working very well with gdal 1.8</span></font></div>
<div><font color="blue" size="2"><span style="font-size: 10pt;"> </span></font></div>
<div><font size="2"><span style="font-size: 10pt;">I can send you the 2 files If you want to try on your side.</span></font></div>
<div><font size="2"><span style="font-size: 10pt;"> </span></font></div>
<div><font size="2"><span style="font-size: 10pt;">Do you have another idea?</span></font></div>
<div><font size="2"><span style="font-size: 10pt;"><br>David</span></font></div></span></font><br><br><div><div id="SkyDrivePlaceholder"></div>> From: Pierre.Racine@sbf.ulaval.ca<br>> To: postgis-users@postgis.refractions.net<br>> Date: Sat, 19 May 2012 13:55:47 -0400<br>> Subject: Re: [postgis-users] PostGis Raster and GDAL 1.9<br>> <br>> Hi David,<br>> <br>> Do you have a "rid" column in your table with unique values?<br>> <br>> Pierre<br>> <br>> > -----Original Message-----<br>> > From: postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-<br>> > bounces@postgis.refractions.net] On Behalf Of David B?langer<br>> > Sent: Thursday, May 17, 2012 8:13 PM<br>> > To: postgis-users@postgis.refractions.net<br>> > Subject: [postgis-users] PostGis Raster and GDAL 1.9<br>> > <br>> > Hi,<br>> > I stored DEM raster data in PostGIS 2.0 and I used gdal_translate (with mode=2)<br>> > to extract a mosaic of tiles. When I’m using GDAL 1.8 is working but when I’m<br>> > using GDAL 1.9 I can see the values of pixel for just one tile. For example I<br>> > uploaded in the database a tile with an attribute filename=056n05_w and an<br>> > other tile with an filename=056n05_e and I executed the command with GDAL<br>> > 1.8 and GDAL 1.9:<br>> > <br>> > gdal_translate" -a_nodata "-32767" -of GTIFF "PG:host=myhost port=14070<br>> > dbname='mybd' user='myuser' password='mypassword'<br>> > schema='myschema'table='Elevation' mode=2 where=\"filename LIKE<br>> > \'%056n05%\'\" " 056N05.tif<br>> > <br>> > With GDAL 1.8 I obtained a mosaic of 2 tiles (the result expected) but with GDAL<br>> > 1.9, I obtained a raster with the same extent but only the values of the tile<br>> > 056n05_w are present. The pixels of the tile 056n05_w have a value 0.<br>> > <br>> > I tried the stable version 1.9 MSVC2008 (Win32) and development version<br>> > available today at http://www.gisinternals.com/sdk/<br>> > <https://email.nrcan.gc.ca/owa/redir.aspx?C=OzXx4wlk90m3TV7W8fzG7_FxObj<br>> > PB88I1bAwXOtZColSmDyhIvj_1yhbCVJUJ0vrnCWWTuivB9Y.&URL=http://www.g<br>> > isinternals.com/sdk/> and I have still the same problem. For your information,<br>> > I'm running GDAL on windows7 and PostGIS 2.0 is installed on a Linux server. I<br>> > tried many version of GDAL 1.9 and I always have the same problem. The version<br>> > 1.8 is working very well but I would like to take advantage of the improvements<br>> > in the last version because I'm working on a project where processing time is<br>> > very important.<br>> > <br>> > Does anybody have any idea about this problem ?<br>> > <br>> > Thanks<br>> > <br>> > David Bélanger<br>> <br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@postgis.refractions.net<br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br></div> </div></body>
</html>