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

[Jakub Hettler]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120823/d0c99261/attachment.html>