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

[Christian Yrrman]

Hi Darrel,


did you save the password for the db connection in qgis' dbmanager? If not
you'll get the same error.. (i.e. you are not being prompted for a password
again)

Also, there are two ways of adding a raster table to qgis with dbmanager:

1. by right-clicking "Add to Canvas" and
2. by drag+dropping it to the layers panel.

Method (2) gives more meaningful error messages.


Good luck!!


Chris



On Sat, Nov 7, 2015 at 2:23 PM, Darrel Maddy <darrel.maddy at newcastle.ac.uk>
wrote:

> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151107/df0b2b0b/attachment.html>