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

[Darrel Maddy]

Dear Regina,

Many thanks for trying to help this is much appreciated.

I replaced the function as directed (at least I believe I did!). I removed the table constraints as directed and then created the view as directed. This was done on my laptop so the names are slightly different as I inserted the data table into the ch01 schema.

Unfortunately when I try to add the view or the raster directly in QGIS I get :

2015-11-07T13:08:34 0 QGIS starting...
2015-11-07T13:08:35 0 Python support ENABLED :-)
2015-11-07T13:08:49 0 Application state:
QGIS_PREFIX_PATH env var: C:/PROGRA~1/QGISPI~1/apps/qgis
Prefix: C:/PROGRA~1/QGISPI~1/apps/qgis
Plugin Path: C:/PROGRA~1/QGISPI~1/apps/qgis/plugins
Package Data Path: C:/PROGRA~1/QGISPI~1/apps/qgis/.
Active Theme Name: default
Active Theme Path: :/images/themes/default/
Default Theme Path: :/images/themes/default/
SVG Search Paths: C:/PROGRA~1/QGISPI~1/apps/qgis/./svg/
C:/Users/ndm12/.qgis2//svg/
User DB Path: C:/PROGRA~1/QGISPI~1/apps/qgis/./resources/qgis.db
2015-11-07T13:08:49 0 QGIS Ready!
2015-11-07T13:09:32 1 PG: dbname=postgis_in_action port=5433 mode=2 schema=ch01 column=rast table=testrast is an invalid layer - not loaded
2015-11-07T13:18:50 1 PG: dbname=postgis_in_action port=5433 mode=2 schema=ch01 column=rast table=test is an invalid layer - not loaded

This is curious as the original tif file loads without error into QGIS directly.


Running your query returns
r_table_catalog          r_table_schema          r_table_name             r_raster_column         srid            scale_x                  scale_y      blocksize_x                  blocksize_y                  same_alignment         regular_blocking                  num_bands                 pixel_types                  nodata_values             out_db       extent                  spatial_index
postgis_in_action        ch01          test            rast            27700        None          None          2928          2960                  True           False          1                [u'64BF']    [-9999.0]   [False]                  0103000020346C00000100000005000000E0CCCCCCB1D517418066666692BE0541E0CCCCCCB1D517418066666692F80C41E0CCCCCCB1681B418066666692F80C41E0CCCCCCB1681B418066666692BE0541E0CCCCCCB1D517418066666692BE0541                  True
postgis_in_action        ch01          testrast      rast            0                None          None          None          None                  False          False          None          None          None          None          None          False


Darrel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151107/016b1afa/attachment.html>