<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'>
Hi,<BR>
I have tried the version <EM>MSVC2008 (Win32) -development </EM>available today at <A href="http://www.gisinternals.com/sdk/">http://www.gisinternals.com/sdk/</A> 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.<BR>
<BR>Does any developper has an idea for this problem ?<BR>
<BR>
Thanks<BR>
<BR>
David Bélanger<BR>
<BR>
<BR>
<BR>
<DIV>
<DIV id=ecxSkyDrivePlaceholder></DIV>> Date: Wed, 16 May 2012 07:38:30 -0700<BR>> Subject: Re: [gdal-dev] GDAL 1.9 and PostGis raster<BR>> From: bkpark@ucdavis.edu<BR>> To: belanger_david@live.ca<BR>> <BR>> David,<BR>> <BR>> The PostGIS Raster driver in GDAL was and still is in a state of flux.<BR>> GDAL 1.9 should be better than 1.8 as there were significant changes<BR>> to PostGIS Raster before 2.0 and 2.0. You may want to try GDAL trunk.<BR>> <BR>> -bborie<BR>> <BR>> On Tue, May 15, 2012 at 6:37 PM, David B�langer <belanger_david@live.ca> wrote:<BR>> > Hi,<BR>> ><BR>> > I stored DEM raster data in PostGIS 2.0 and I used gdal_translate (with<BR>> > mode=2) to extract a mosaic of tiles. When I’m using GDAL 1.8 is working but<BR>> > when I’m using GDAL 1.9 I can see the values of pixel for just one tile.<BR>> ><BR>> ><BR>> ><BR>> > For example I uploaded in the database a tile with an attribute<BR>> > filename=056n05_w and an other tile with an filename=056n05_e and I executed<BR>> > the command with GDAL 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' schema='myschema'<BR>> > table='Elevation' mode=2 where=\"filename LIKE \'%056n05%\'\" " 056N05.tif<BR>> ><BR>> ><BR>> ><BR>> > With GDAL 1.8 I obtained a mosaic of 2 tiles (the result expected) but with<BR>> > GDAL 1.9, I obtained a raster with the same extent but only the values of<BR>> > the tile 056n05_w are present. The pixels of the tile 056n05_w have a value<BR>> > 0.<BR>> ><BR>> ><BR>> ><BR>> > Does anyone know this problem and can you help me?<BR>> ><BR>> ><BR>> ><BR>> > Thanks<BR>> ><BR>> > David<BR>> ><BR>> ><BR>> > _______________________________________________<BR>> > gdal-dev mailing list<BR>> > gdal-dev@lists.osgeo.org<BR>> > http://lists.osgeo.org/mailman/listinfo/gdal-dev<BR>> <BR>> <BR>> <BR>> -- <BR>> Bborie Park<BR>> Programmer<BR>> Center for Vectorborne Diseases<BR>> UC Davis<BR>> 530-752-8380<BR>> bkpark@ucdavis.edu<BR></DIV> </div></body>
</html>