[postgis-users] Sorry for simple question!
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.
> postgis-users mailing list
> postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users