Re: [QGIS-Developer] PostGIS Raster loading extrem long in QGIS 3.16 and 3.22

2022-03-15 Thread Alessandro Pasotti via QGIS-Developer
Hi, the reason for the different behavior is that the old QGIS version was using GDAL to access PG rasters while the new versions uses a QGIS native data provider which is using ST_SummaryStatsAgg() to calculate statistics, I believe that this call can become very slow on large rasters and we

[QGIS-Developer] PostGIS Raster loading extrem long in QGIS 3.16 and 3.22

2022-03-15 Thread Pascal Bircher / Netzwerk Schweizer Pärke via QGIS-Developer
Dear QGIS-Developer I am working on a test-server (RAID6) implementing PostgreSQL/PostGIS with vector and raster support. The aim is a big database sharing different data types including high resolution (0.5m, also 0.1m; 8 bit; 3 bands) rasters and (2m, also 0.5m; 32bit floating point; 1 band)

[Qgis-developer] PostGIS raster access in QGIS using DBManager (or wktraster)

2014-03-05 Thread Guido Lemoine
Dear Developers, I am using QGIS 2.2 .0 (Valmiera) and trying to load a raster query result via DBManager, using the following query: select 1 as rid, st_union(st_band(rast, '4,3,2') ) as rast from o_8_lc81970232013202lgn00_all_rds_sub, gemeentegebieden where gemeentegebieden.wkb_geometry rast

Re: [Qgis-developer] PostGIS Raster Layer into QGIS not displayed

2012-03-05 Thread Sandro Santilli
On Sun, Mar 04, 2012 at 01:30:30PM -0800, Salvatore Larosa wrote: Hi, I am trying to load a raster layer in qgis (master[fa4ec86]) but w/out success!! my steps are: from qgis.utils import iface connection = PG:host='localhost' port='5432' dbname='workshop' user='postgres'

[Qgis-developer] PostGIS Raster Layer into QGIS not displayed

2012-03-04 Thread Salvatore Larosa
Hi, I am trying to load a raster layer in qgis (master[fa4ec86]) but w/out success!! my steps are: from qgis.utils import iface connection = PG:host='localhost' port='5432' dbname='workshop' user='postgres' password='***' schema='public' table='r_ctr5k' mode='2'

Re: [Qgis-developer] PostGIS raster

2011-02-22 Thread Paolo Cavallini
AFAIK it does not *require* it, but it is ture that without it it gives lots of trouble. Unfortunately gdal1.8 is not yet available on debian (not even in experimental). All the best. Il giorno mar, 22/02/2011 alle 22.13 +1100, Noli Sicad ha scritto: Hi Paulo, it requires GDAL 1.8.0, if I am

Re: [Qgis-developer] PostGIS raster

2011-02-22 Thread Noli Sicad
You are right. You are referring to the plugin, I suppose. http://www.mail-archive.com/qgis-user@lists.osgeo.org/msg08130.html Noli On 2/22/11, Paolo Cavallini cavall...@faunalia.it wrote: AFAIK it does not *require* it, but it is ture that without it it gives lots of trouble. Unfortunately

[Qgis-developer] PostGIS raster

2011-01-03 Thread Paolo Cavallini
Hi all. More tests, now I cannot load a raster created with: python raster2pgsql.py -r w001001.adf -t dtm_rt2 -l 1 -k 64x64 -o dtm_rt.sql -s 3003 -I -M or python raster2pgsql.py -r utm.tif -t utm -l 1 -k 64x64 -o utm.sql -s 26711 -I -M anmd severa other tests, but I always get: ERROR 1: Can't

Re: [Qgis-developer] PostGIS raster not loaded

2010-12-25 Thread Maurício de Paulo
Hi Paolo, Merry Christimas! Ok, I'm going to implement the two sugestions: 1- Avoiding gdal 1.6 crash 2- Refresh on startup But I don't know what you meant with the last mail. You mean by clicking the row number? Best regards, Mauricio 2010/12/25 Paolo Cavallini cavall...@faunalia.it Il giorno

[Qgis-developer] PostGIS raster not loaded

2010-12-24 Thread paolo
Hi all. Starting afresh with a new machine, with gdal 1.7, pg9.0 and postgis svn, I have loaded the sample utm raster into qgis, but opening the plugin I do not see any available raster. The tables are there. Anything specific to check? All the best. -- Paolo Cavallini: http://www.faunalia.it/pc