<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Hi Mauricio, <br><br>I have one raster with 3 bands. I can see perfectly the layer in QGIS. When I import to PostgreSQL with the raster2pgsql command works fine but when I try to visualize the layer both in browser as WMS service or in QGIS I don't have any information is like when I import to PostgreSQL he merge the values in one band (despite the QGIS said that the layer have 3 bands and the GDAL info also says the same). Basically I would like to know if there’s a problem when import 3 bands raster files to PostgreSQL with the raster2pgsql command. <br><br>Many thanks,<br>Regards,<br>José Santos <br><br><div><div id="SkyDrivePlaceholder"></div>> Date: Mon, 10 Dec 2012 16:25:19 -0200<br>> From: mauricio.dev@gmail.com<br>> To: Pierre.Racine@sbf.ulaval.ca<br>> CC: postgis-users@lists.osgeo.org<br>> Subject: Re: [postgis-users] Import Raster with 3 bands to PostgreSQL<br>> <br>> Sorry but I didn't understand what you're trying to do. Could you <br>> elaborate more?<br>> Were the 3 bands stored in a single file when you used raster2pgsql? If <br>> that's the case, you should be able to see your data in qgis.<br>> If not, the 3 separate files had nothing to tell that they were separate <br>> bands of the same imagery and were probably merged as a mosaic in <br>> raster2pgsql. I've never tried that with overlapping data but certainly <br>> qgis isn't ready to read special scenarios like this one.<br>> <br>> Mauricio C. M. de Paulo<br>> Cartography Engineer<br>> <br>> On 12/10/2012 02:37 PM, Pierre Racine wrote:<br>> > Which software? The software has to interpret himself the three bands as RGB. I don't think QGIS does that...<br>> ><br>> > There is nothing in PostGIS stating that a three bands raster is a TIFF or JPEG file. PostGIS store rasters, not images.<br>> ><br>> > Pierre<br>> ><br>> >> -----Original Message-----<br>> >> From: postgis-users-bounces@lists.osgeo.org [mailto:postgis-users-<br>> >> bounces@lists.osgeo.org] On Behalf Of José Pedro Santos<br>> >> Sent: Monday, December 10, 2012 11:26 AM<br>> >> To: postgis-users@lists.osgeo.org<br>> >> Subject: [postgis-users] Import Raster with 3 bands to PostgreSQL<br>> >><br>> >> Dear all,<br>> >><br>> >> I import with sucess a 3 band image to PostgreSQL 9.1 with the raster2pgsql in<br>> >> Ubuntu 12.04LTS. But when I try to visualize in another software I can't see the<br>> >> image and it looks like the values from the other bands glue only in the first<br>> >> band. Do you know if there's any problem with the import option of rasters with<br>> >> 3 bands to PostgreSQL?<br>> >> My Postgis version is 2.0.1.<br>> >><br>> >> Best Regards and thanks,<br>> >> Jose Santos<br>> <br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@lists.osgeo.org<br>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br></div> </div></body>
</html>