[postgis-users] PostGIS raster GDAL driver error? - some tiles are not visible over gdal_translate, mode 2
jakub.hettler at gmail.com
Thu Aug 23 10:14:40 PDT 2012
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.
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.
> 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
> > 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
> > 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
> > 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
> > 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
> > 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
> Center for Vectorborne Diseases
> UC Davis
> bkpark at ucdavis.edu
> postgis-users mailing list
> postgis-users at postgis.refractions.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users