[postgis-users] Import Raster with 3 bands to PostgreSQL
Mauricio de Paulo
mauricio.dev at gmail.com
Mon Dec 10 10:25:19 PST 2012
Sorry but I didn't understand what you're trying to do. Could you
Were the 3 bands stored in a single file when you used raster2pgsql? If
that's the case, you should be able to see your data in qgis.
If not, the 3 separate files had nothing to tell that they were separate
bands of the same imagery and were probably merged as a mosaic in
raster2pgsql. I've never tried that with overlapping data but certainly
qgis isn't ready to read special scenarios like this one.
Mauricio C. M. de Paulo
On 12/10/2012 02:37 PM, Pierre Racine wrote:
> Which software? The software has to interpret himself the three bands as RGB. I don't think QGIS does that...
> There is nothing in PostGIS stating that a three bands raster is a TIFF or JPEG file. PostGIS store rasters, not images.
>> -----Original Message-----
>> From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
>> bounces at lists.osgeo.org] On Behalf Of José Pedro Santos
>> Sent: Monday, December 10, 2012 11:26 AM
>> To: postgis-users at lists.osgeo.org
>> Subject: [postgis-users] Import Raster with 3 bands to PostgreSQL
>> Dear all,
>> I import with sucess a 3 band image to PostgreSQL 9.1 with the raster2pgsql in
>> Ubuntu 12.04LTS. But when I try to visualize in another software I can't see the
>> image and it looks like the values from the other bands glue only in the first
>> band. Do you know if there's any problem with the import option of rasters with
>> 3 bands to PostgreSQL?
>> My Postgis version is 2.0.1.
>> Best Regards and thanks,
>> Jose Santos
More information about the postgis-users