Right click on the raster in the legend and choose "Filter..."
On Thu, Nov 3, 2022 at 2:58 PM Thayer Young via Qgis-user <[email protected]> wrote: > > Hi Dirk, > > I have looked into this and found no easy solution. As you have noticed there > is no "Provider Feature Filter" in the Source tab of the layer properties for > a raster layer. The next obvious path would be to write a SELECT statement in > an SQL Window in the Database Manager and "Load as New Layer", but this is > only set up for geometry columns, not raster. Next is to create a view or a > materialized view with the associated indexes in the database and try adding > that to QGIS using the four methods for adding layers. All of these result in > the same PostGIS errors, that a primary key can not be found for the raster > table, that the raster layer is invalid and that the "Data type size for band > 1 could not be found: num bands is: 0 and the type size map for bands > contains: 0 item(s)". > > I have searched the QGIS issues page on Github and not found anything beyond > the basic functionality of adding PostGIS rasters. I believe that if you are > interested in this functionality you should file a feature request on the > qgis/QGIS issues page on Github. > > This is what I found, note that all of the issues are closed: > https://github.com/qgis/QGIS/issues?q=is%3Aissue+postgresraster+ > > -Thayer > > > > > Date: Wed, 2 Nov 2022 12:08:08 +0000 > > From: <[email protected]> > > To: <[email protected]> > > Subject: [Qgis-user] PostGIS raster layer filtered by attribute > > Message-ID: <[email protected]> > >Content-Type: text/plain; charset="us-ascii" > > > >Hi list, > > > > I import TIFF-files into a PostgreSQL/PostGIS table with FME. In addition > > to the raster column my table has some more columns. > > Is it possible to filter the raster layer based on my table by these > > additional columns? > > It seems that QGIS (up to 3.28) doesn't handle addional columns in raster > > layers, but maybe someone knows a trick to do so. > > Thanks and regards > > > > Dirk > > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user -- Alessandro Pasotti QCooperative: www.qcooperative.net ItOpen: www.itopen.it _______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
