[postgis-users] I am probably being stupid but I cannot get my rasters to display using QGIS

[guido lemoine]

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.maddy at 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
> 
> 
> 
> 
> 
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151107/f9a253b5/attachment.html>