[gdal-dev] GDAL 1.9 and PostGis raster

[Bborie Park]

You may want to post on the postgis-users list as I believe the
developers of the PostGIS Raster driver can be found there.

-bborie

On 05/16/2012 11:49 AM, David B�langer wrote:
> 
> 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
>  		 	   		  
> 
> 
> 
> _______________________________________________
> 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