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

[Bborie Park]

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