[postgis-users] Sorry for simple question!

David Haynes haynesd2 at gmail.com
Fri Aug 1 05:51:22 PDT 2014

You can place rasters into a single raster using ST_BAND. If you are
familiar with rasters this will make a multispectral raster. I don't
believe there is a limit to the bands as I have added over 50. To make the
multispectral raster your other rasters (matrices) will need to be the same
cell size and alignment.

You might try http://www.gdal.org/gdal_merge.html (using the -separate)

This will create a 2 banded raster in postgis
layers.stack_rast]) as rast

On Fri, Aug 1, 2014 at 6:42 AM, Darrel Maddy <darrel.maddy at newcastle.ac.uk>

>  Dear all,
> I am just reacquainting myself with postgres and postgis and trying to
> decide how best to store the output from my model (large matrices stored in
> gtiff format).  I really want to store multiple rasters in one table but
> when I try to visualise these in QGIS (via an sql extract in dbmanager
> using import to new layer) nothing happens. I can add one raster per table
> to the canvas but I do not want thousands of tables.   Will the dbmanager
> sql add layer work with rast as a geometry?
> I suspect this is simple, but it eludes me at present.
> Thanks in anticipation of your help.
> Darrel
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140801/b0495211/attachment.html>

More information about the postgis-users mailing list