[postgis-users] PostGIS raster GDAL driver error? - some tiles are not visible over gdal_translate, mode 2

[Bborie Park]

The ticket I'm thinking of is: http://trac.osgeo.org/gdal/ticket/4736

-bborie

On 08/23/2012 10:14 AM, Jakub Hettler wrote:
> I have GDAL 1.9.1 in QGIS and 1.9.0 in PostGIS. I will try latest version
> later, I need to finish my work and have last few days - no time for
> testing :) But I hope that it will resolve my issue. Maybe this ticket has
> something common with this issue  http://trac.osgeo.org/gdal/ticket/4678.
> 
> Jakub
> 
> 2012/8/23 Bborie Park <bkpark at ucdavis.edu>
> 
>> What version of GDAL are you using?  There was a fix for the GDAL driver
>> in GDAL -trunk that resolved issues I was having with in QGIS display.
>>
>> If you've compiled your own GDAL, I do recommend running GDAL trunk for
>> all the fixes.
>>
>> -bborie
>>
>> On 08/23/2012 09:03 AM, Jakub Hettler wrote:
>>> Hi all,
>>> I have a weird problem with PostGIS raster and I think GDAL driver
>>>
>>> I upload my image into database with
>>>
>>> raster2pgsql -C -N -e -Y -F -s 4326 -t 256x256  -l 2,4 myRaster | psql -d
>>> test -U postgres
>>>
>>> My original image is here
>>>
>> https://skydrive.live.com/?cid=a61d00de178d6e45&id=A61D00DE178D6E45%21311&sff=1
>>>
>>> everything is ok now, but I would like to see my image in QGIS or use
>>> gdal_translate and there is a problem I expect the same, because QGIS
>> uses
>>> gdal_translate.
>>>
>>> with gdal_translate as gdal_translate -of PNG  "PG:host=localhost
>>> dbname='test' user='postgres' password=''pass' schema='public'
>>> table=prehl500_zr mode=2" C:\users\jakub\desktop\somefile.png
>>>
>>> I get this
>>>
>> https://skydrive.live.com/?cid=a61d00de178d6e45&id=A61D00DE178D6E45%21312&sff=1
>>>
>>> There are some missing tiles, but I said ok, there are some empty data in
>>> my database.
>>>
>>> I try to use large objects to export one of the missing tiles directly
>> from
>>> DB
>>>
>>> SELECT oid, lowrite(lo_open(oid, 131072), png) As num_bytes
>>>  FROM
>>>  ( VALUES (lo_create(0),
>>>    ST_AsPNG( (select rast from prehl500_zr where rid in (14)) )
>>>   ) ) As v(oid,png);
>>>
>>> and then in psql
>>>
>>> \lo_export 165836 testX.png -- the number 165836 is oid return by the
>> first
>>> select
>>>
>>> and everything is ok I get the image one of the missing one in my picture
>>> over gdal_translate.
>>>
>>> Do you have some ideas where is the problem me, GDAL, PostGIS?
>>>
>>> Thanks
>>>
>>> Jakub
>>>
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>> --
>> Bborie Park
>> Programmer
>> Center for Vectorborne Diseases
>> UC Davis
>> 530-752-8380
>> bkpark at ucdavis.edu
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu