From: | Osahon Oduware <osahon(dot)gis(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: QGIS Loads Black Screen For PostGIS Out-Db Raster Data |
Date: | 2017-04-18 14:31:28 |
Message-ID: | CAGpiUSgctn4FZrKW6yyyc_5x0ZvEDG6X_67Qpbbe3jGSKND=HQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Adrian,
I think it is a problem with QGIS as things seems fine from the PostGIS end
(raster data) going by the following queries:
*SELECT r_table_name, r_raster_column, out_db FROM raster_columns;*
returned the following output:
"test_rast","rast","[True, True, True]"
*SELECT t.rid, (md).isoutdb, (md).path*
*FROM test_rast AS t, ST_BandMetaData(t.rast) AS md*
*limit 1;*
returned the following output:
1,True,"/home/nagispg/local/src/SID_Test/rast_1.sid"
*SELECT ST_Width(rast) wdth, ST_Height(rast) hgt*
*FROM test_rast;*
returned the following output:
10000,7000
The "Add to canvas" menu is a pop-up that is displayed when you right-click
on the raster table from the DB Manager Menu (Database => DB Manager => DB
Manager)
On Tue, Apr 18, 2017 at 3:03 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 04/18/2017 06:41 AM, Osahon Oduware wrote:
>
>> Hi All,
>>
>> I have an out-db raster on PostGIS which I tried to load in QGIS (v
>> 2.14.12-Essen) utilizing the DB Manager to establish a connection. I
>> could view the raster table, but when I try to "Add to canvas" it
>> displays a black screen instead of the raster image.
>>
>
> There is data in the table?
>
> I am not that familiar with GIS, much less QGIS. Still a quick look at the
> docs found this:
>
> http://docs.qgis.org/2.14/en/docs/user_manual/working_with_r
> aster/supported_data.html#what-is-raster-data
>
> I see Add Raster layer, nothing about Add to canvas.
>
> If the above does not answer the question I would say you will have a
> better chance of getting an answer here:
>
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
>> I would be glad if someone could help me to resolve this.
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | agharta | 2017-04-18 14:36:19 | Re: CANNOT USE ANY INDEX ON UPSERT (INSERT.....ON CONFLICT) |
Previous Message | Adrian Klaver | 2017-04-18 14:03:23 | Re: QGIS Loads Black Screen For PostGIS Out-Db Raster Data |