Hi Pierre, Yes I have a unique rid (Integer) with sequential number. I used the tool raster2pgsql.exe to upload the data in the database. I uploaded 2 files 056n05_0100_deme.tif 056n05_0100_demw.tif "C:\Program Files\PostgreSQL\9.1\bin\raster2pgsql.exe" -I -e -Y -F -s 4269 e:\dir\*.tif dbelange.elevationTest | "psql.exe" -U myuser -d myDB -h myhost -p 14070 I used this command to extract data: "C:\Program Files\GDAL\gdal_translate" -a_nodata "-32767" -of GTIFF "PG:host=myhost port=14070 dbname='myDB' user='myuser' password='mypassword' schema='dbelange' table='elevationTest' mode=2 where=\"filename LIKE \'%056n05%\'\" " 056N05_testGDAL1.9.tif Like I said it’s working very well with gdal 1.8 I can send you the 2 files If you want to try on your side. Do you have another idea?
David > From: pierre.rac...@sbf.ulaval.ca > To: postgis-users@postgis.refractions.net > Date: Sat, 19 May 2012 13:55:47 -0400 > Subject: Re: [postgis-users] PostGis Raster and GDAL 1.9 > > Hi David, > > Do you have a "rid" column in your table with unique values? > > Pierre > > > -----Original Message----- > > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > > boun...@postgis.refractions.net] On Behalf Of David B?langer > > Sent: Thursday, May 17, 2012 8:13 PM > > To: postgis-users@postgis.refractions.net > > Subject: [postgis-users] PostGis Raster and GDAL 1.9 > > > > 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. > > > > I tried the stable version 1.9 MSVC2008 (Win32) and development version > > available today at http://www.gisinternals.com/sdk/ > > <https://email.nrcan.gc.ca/owa/redir.aspx?C=OzXx4wlk90m3TV7W8fzG7_FxObj > > PB88I1bAwXOtZColSmDyhIvj_1yhbCVJUJ0vrnCWWTuivB9Y.&URL=http://www.g > > isinternals.com/sdk/> and I have still the same problem. For your > > information, > > I'm running GDAL on windows7 and PostGIS 2.0 is installed on a 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 a project where processing time > > is > > very important. > > > > Does anybody have any idea about this problem ? > > > > Thanks > > > > David Bélanger > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
