There used to be a QGIS plugin for this (see: https://plugins.qgis.org/plugins/wktraster/) but for some reason it did not work in 2.* versions, which was never resolved. This would be a very useful plugin, esp. with the arrival of Sentinel-2 (full, free and open) optical data which is delivered in fixed UTM frames (which allow for some very nifty postgis raster access).
Guido On 11/06/15, Darrel Maddy <darrel.ma...@newcastle.ac.uk> wrote: > > > > > > > > > > > > > > > > > Dear all, > > > > > > Please accept this elementary question but I have been struggling with this > despite working through my copy of postgis in action (ver 2). > > > > > > I have imported my tifs into a table as follows (I am using postgres 9.4 and > postgis 2.2.0): > > > > > > > raster2pgsql -I -C -M *.tif -F -s 27700 testrast.all | psql -h localhost -U > postgres -p 5433 -d postgisi_in_action > > > > > > The table appears in pgAdmin as expected. At this stage all I am trying to > do is visualise one of the tifs (there are 30) in QGIS (2.10). I connect via > dbmanager and can see the table. > > > > > > I have tried add to canvas on the ‘all’ table but it simply falls over. I > also tried running a simple query in the sql window > > > > > > select rid,rast::geometry from testrast.all WHERE rid=1 and adding this as > a layer. This produces a box (presumably just of the dimensions of the > raster). > > > > > > > How can I get it to display the actual raster image itself? > > > > > > Frankly I am embarrassed asking this question but I just don’t see how to do > this. > > > > > > Darrel > > > > > > >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
