Re: [QGIS-Developer] PostGIS out-of-db raster rendering as a black box in QGIS
There will probably be a GDAL 2.3.1 release with this fix at end of june / july. And assuming OSGeo4W catches this, this will be available to QGIS -- Spatialys - Geospatial professional services http://www.spatialys.com ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] PostGIS out-of-db raster rendering as a black box in QGIS
Anyone know of the approximate timeframe for a commit to GDAL master and 2.3 branch will be available in a QGIS release? Thanks Jakob - Jakob Lanstorp -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Developer-f4099106.html ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] PostGIS out-of-db raster rendering as a black box in QGIS
Il 19/05/2018 11:40, Even Rouault ha scritto: >> e.g. https://issues.qgis.org/issues/18054 > > > > Cannot reproduce. Perhaps another issue so possibly better close it. >> https://issues.qgis.org/issues/8073 > > > > That one was exactly what I fixed. Closed thanks a lot Even All the best -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html https://www.google.com/trends/explore?date=all=IT=qgis,arcgis ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] PostGIS out-of-db raster rendering as a black box in QGIS
On vendredi 18 mai 2018 13:08:56 CEST Paolo Cavallini wrote: > Il 17/05/2018 19:25, Even Rouault ha scritto: > > Jakob, > > > > > > > > This is a limitation of the GDAL PostgisRaster client driver that I'm > > currently working on. The enhancement to support out-of-db rasters in > > the driver should land in GDAL master in a few hours. > > Good news, thanks Even. Improvement/fix committed in GDAL master and 2.3 branch. > There are a few tickets related to this in QGIS > bugtracker, probably it is worth checking them once fixes are landed. > e.g. https://issues.qgis.org/issues/18054 Cannot reproduce. Perhaps another issue > https://issues.qgis.org/issues/8073 That one was exactly what I fixed. Closed Even -- Spatialys - Geospatial professional services http://www.spatialys.com ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] PostGIS out-of-db raster rendering as a black box in QGIS
Il 17/05/2018 19:25, Even Rouault ha scritto: > Jakob, > > > > This is a limitation of the GDAL PostgisRaster client driver that I'm > currently working on. The enhancement to support out-of-db rasters in > the driver should land in GDAL master in a few hours. Good news, thanks Even. There are a few tickets related to this in QGIS bugtracker, probably it is worth checking them once fixes are landed. e.g. https://issues.qgis.org/issues/18054 https://issues.qgis.org/issues/8073 All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html https://www.google.com/trends/explore?date=all=IT=qgis,arcgis ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] PostGIS out-of-db raster rendering as a black box in QGIS
Jakob, This is a limitation of the GDAL PostgisRaster client driver that I'm currently working on. The enhancement to support out-of-db rasters in the driver should land in GDAL master in a few hours. Even -- Spatialys - Geospatial professional services http://www.spatialys.com ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
[QGIS-Developer] PostGIS out-of-db raster rendering as a black box in QGIS
I load a geotiff with raster2pgsql with the -R param for having an out of db
stored raster in PostGIS.
The raster renders in QGIS through the DB Manager as a black box with no
values. Running a raster layer statistics in QGIS returns 0 for all values.
I have tried loading the raster as a in-db raster and this works fine
rendering in QGIS.
Out-db is enabled:
SET postgis.enable_outdb_rasters TO True;
SHOW postgis.enable_outdb_rasters;
ST_SummaryStats in PostGIS returns the same for both in- and out-of-db
raster.
The out-db raster is registered correct in PostGIS:
SELECT r_table_name, r_raster_column, out_db FROM raster_columns;
returning: sa_out, rast, {true,true,true,true}
Since raster2pgsql uses GDAL I suspect GDAL within QGIS is able to read the
raster to QGIS.
The sample tif is available for download here:
3320D_2010_315_RGB_LATLNG.TIF
It is loaded into PostGIS with:
raster2pgsql -C -R -F -Y -I
C:\map\raster2pg\tif\3320D_2010_315_RGB_LATLNG.TIF myschema.sa_out | psql -U
postgres -d sandbox localhost -p 5432
Is this a GDAL or QGIS problem? Any solution? Anyone able to render an
out-of-db raster from PostGIS?
Jakob
-
Jakob Lanstorp
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Developer-f4099106.html
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
