[QGIS-Developer] Plugin [1935] Nuclear Energy Plants' Radiations approval notification.
Plugin Nuclear Energy Plants' Radiations approval by pcav. The plugin version "[1935] Nuclear Energy Plants' Radiations 1.6" is now approved Link: http://plugins.qgis.org/plugins/Nuclear-Energy-Plant-Radiations-/ ___ 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] Testing algorithm/code efficiency
Greetings everyone, I wanted to know what was the best way to test memory usage and execution time. I would guess that debugging c++ would be one way to check for runtime but I wanted to know a good way to test for both. Thanks and have a nice day! Alex ___ 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] Plugin [1350] Mascaret approval notification.
Plugin Mascaret approval by pcav. The plugin version "[1350] Mascaret 3.0.0 Experimental" is now approved Link: http://plugins.qgis.org/plugins/Mascaret/ ___ 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] Plugin [1350] Mascaret approval notification.
Plugin Mascaret approval by pcav. The plugin version "[1350] Mascaret 2.0.0" is now approved Link: http://plugins.qgis.org/plugins/Mascaret/ ___ 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] Plugin [1350] Mascaret approval notification.
Plugin Mascaret approval by pcav. The plugin version "[1350] Mascaret 1.1.2 Experimental" is now approved Link: http://plugins.qgis.org/plugins/Mascaret/ ___ 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] WMS projection wrong?
I tried changing that, in connection params, but the result is the same. loading in 3046 is OK Il 10/01/20 16:57, Jorge Gustavo Rocha ha scritto: > Hi Paolo, > > Maybe related with axis order in 1.3.0? Seems like that. Erithrea > coordinates are like the ones in Italy, but in reverse order. > > Regards, > > Jorge > > On 10/01/20 15:34, Paolo Cavallini wrote: >> Thanks fro checking. In my case, qgis 3.10 is reprojecting wrong, >> placing the layer in Erithrea, rather than in Italy. >> Cheers. >> >> Il 10/01/20 16:09, Jorge Gustavo Rocha ha scritto: >>> Hi Paolo, >>> >>> I'm running QGIS 3.11-Master on Ubuntu and I'm able to add layers from >>> that service in EPSG:6706. What is happening in your QGIS? >>> >>> Regards, >>> >>> Jorge >>> >>> On 10/01/20 14:55, Paolo Cavallini wrote: Hi all, this service: https://wms.cartografia.agenziaentrate.gov.it/inspire/wms/ows01.php is displayed correctly (epsg:6706) in qgis 3.4 (GDAL/OGR 2.4.3 + PROJ 6.2.1) whereas is wrong in 3.10 (GDAL/OGR 3.0.2 + PROJ 6.3.0) on my Debian box. Reports from Windows are apparently mixed. Anyone has a hint? Thanks in advance. >>> >>> J. Gustavo >>> >> > > J. Gustavo > -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ 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] WMS projection wrong?
Hi Paolo, Maybe related with axis order in 1.3.0? Seems like that. Erithrea coordinates are like the ones in Italy, but in reverse order. Regards, Jorge On 10/01/20 15:34, Paolo Cavallini wrote: > Thanks fro checking. In my case, qgis 3.10 is reprojecting wrong, > placing the layer in Erithrea, rather than in Italy. > Cheers. > > Il 10/01/20 16:09, Jorge Gustavo Rocha ha scritto: >> Hi Paolo, >> >> I'm running QGIS 3.11-Master on Ubuntu and I'm able to add layers from >> that service in EPSG:6706. What is happening in your QGIS? >> >> Regards, >> >> Jorge >> >> On 10/01/20 14:55, Paolo Cavallini wrote: >>> Hi all, >>> this service: >>> https://wms.cartografia.agenziaentrate.gov.it/inspire/wms/ows01.php >>> is displayed correctly (epsg:6706) in qgis 3.4 (GDAL/OGR 2.4.3 + PROJ >>> 6.2.1) whereas is wrong in 3.10 (GDAL/OGR 3.0.2 + PROJ 6.3.0) on my >>> Debian box. Reports from Windows are apparently mixed. >>> Anyone has a hint? >>> Thanks in advance. >>> >> >> J. Gustavo >> > J. Gustavo -- Jorge Gustavo Rocha Departamento de Informática Universidade do Minho 4710-057 Braga Gabinete 3.29 (Piso 3) Tel: +351 253604480 Fax: +351 253604471 Móvel: +351 910333888 skype: nabocudnosor ___ 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] WMS projection wrong?
more info: layers are displayed correctly also in qgis 3.10 when loaded as 3046, not as 6706. I suspect there is a real issue with projections here. cheers. Il 10/01/20 16:34, Paolo Cavallini ha scritto: > Thanks fro checking. In my case, qgis 3.10 is reprojecting wrong, > placing the layer in Erithrea, rather than in Italy. > Cheers. > > Il 10/01/20 16:09, Jorge Gustavo Rocha ha scritto: >> Hi Paolo, >> >> I'm running QGIS 3.11-Master on Ubuntu and I'm able to add layers from >> that service in EPSG:6706. What is happening in your QGIS? >> >> Regards, >> >> Jorge >> >> On 10/01/20 14:55, Paolo Cavallini wrote: >>> Hi all, >>> this service: >>> https://wms.cartografia.agenziaentrate.gov.it/inspire/wms/ows01.php >>> is displayed correctly (epsg:6706) in qgis 3.4 (GDAL/OGR 2.4.3 + PROJ >>> 6.2.1) whereas is wrong in 3.10 (GDAL/OGR 3.0.2 + PROJ 6.3.0) on my >>> Debian box. Reports from Windows are apparently mixed. >>> Anyone has a hint? >>> Thanks in advance. >>> >> >> J. Gustavo >> > -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ 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] WMS projection wrong?
Thanks fro checking. In my case, qgis 3.10 is reprojecting wrong, placing the layer in Erithrea, rather than in Italy. Cheers. Il 10/01/20 16:09, Jorge Gustavo Rocha ha scritto: > Hi Paolo, > > I'm running QGIS 3.11-Master on Ubuntu and I'm able to add layers from > that service in EPSG:6706. What is happening in your QGIS? > > Regards, > > Jorge > > On 10/01/20 14:55, Paolo Cavallini wrote: >> Hi all, >> this service: >> https://wms.cartografia.agenziaentrate.gov.it/inspire/wms/ows01.php >> is displayed correctly (epsg:6706) in qgis 3.4 (GDAL/OGR 2.4.3 + PROJ >> 6.2.1) whereas is wrong in 3.10 (GDAL/OGR 3.0.2 + PROJ 6.3.0) on my >> Debian box. Reports from Windows are apparently mixed. >> Anyone has a hint? >> Thanks in advance. >> > > J. Gustavo > -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ 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] WMS projection wrong?
Hi Paolo, I'm running QGIS 3.11-Master on Ubuntu and I'm able to add layers from that service in EPSG:6706. What is happening in your QGIS? Regards, Jorge On 10/01/20 14:55, Paolo Cavallini wrote: > Hi all, > this service: > https://wms.cartografia.agenziaentrate.gov.it/inspire/wms/ows01.php > is displayed correctly (epsg:6706) in qgis 3.4 (GDAL/OGR 2.4.3 + PROJ > 6.2.1) whereas is wrong in 3.10 (GDAL/OGR 3.0.2 + PROJ 6.3.0) on my > Debian box. Reports from Windows are apparently mixed. > Anyone has a hint? > Thanks in advance. > J. Gustavo -- Jorge Gustavo Rocha Departamento de Informática Universidade do Minho 4710-057 Braga Gabinete 3.29 (Piso 3) Tel: +351 253604480 Fax: +351 253604471 Móvel: +351 910333888 skype: nabocudnosor ___ 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] WMS projection wrong?
Hi all, this service: https://wms.cartografia.agenziaentrate.gov.it/inspire/wms/ows01.php is displayed correctly (epsg:6706) in qgis 3.4 (GDAL/OGR 2.4.3 + PROJ 6.2.1) whereas is wrong in 3.10 (GDAL/OGR 3.0.2 + PROJ 6.3.0) on my Debian box. Reports from Windows are apparently mixed. Anyone has a hint? Thanks in advance. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ 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] Snap cache improvements grant report
Hi, Could be. Thank you for reporting, I'll take a look and answer you back in those tickets. Regards, Julien > Hi, > > > > It seems those two regressions may be related to your work on the cache, > arent they? > > > > https://github.com/qgis/QGIS/issues/33285 > > https://github.com/qgis/QGIS/issues/33449 > > > > Regards, > > Borys > > > > > > Dnia piątek, 10 stycznia 2020 11:29:15 CET Julien Cabieces pisze: > >> Hi PSC, devs, > >> > >> Here is my report for the Snap cache improvements grant proposal. > >> > >> We write a blog article to better explain what Snap cache improvement was > >> about: https://oslandia.com/en/2020/01/10/en-qgis-snapping-improvements/ > >> > >> This work leads to these PRs : > >> - Manage circular dependencies: https://github.com/qgis/QGIS/pull/30947 > >> - Parallelize and relax snap index building: > >> https://github.com/qgis/QGIS/pull/31648 - Fix QgsTaskManager > >> waitForFinished : https://github.com/qgis/QGIS/pull/32838 > >> > >> The first one is available in 3.10 release while the other ones are only in > >> master. At first, I wanted to backport them in 3.10 but I change my mind. > >> Indeed some of the modifications are quite critical (In QgsTaskManager for > >> instance) and are difficult to fine test (because it's all threads and > >> synchronisation). > >> > >> We're going to invest more time and keep working on this in the days to come > >> in order to improve stability and maybe efficiency. > >> > >> As a consequence, parallel snap cache building and relaxed mode will > >> land in 3.12 release. > >> > >> Thanks QGIS.org for funding this, > >> > >> Regards, > >> Julien > >> > >> ___ > >> 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 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] Snap cache improvements grant report
Hi, It seems those two regressions may be related to your work on the cache, arent they? https://github.com/qgis/QGIS/issues/33285[1] https://github.com/qgis/QGIS/issues/33449[2] Regards, Borys Dnia piątek, 10 stycznia 2020 11:29:15 CET Julien Cabieces pisze: > Hi PSC, devs, > > Here is my report for the Snap cache improvements grant proposal. > > We write a blog article to better explain what Snap cache improvement was > about: https://oslandia.com/en/2020/01/10/en-qgis-snapping-improvements/ > > This work leads to these PRs : > - Manage circular dependencies: https://github.com/qgis/QGIS/pull/30947 > - Parallelize and relax snap index building: > https://github.com/qgis/QGIS/pull/31648 - Fix QgsTaskManager > waitForFinished : https://github.com/qgis/QGIS/pull/32838 > > The first one is available in 3.10 release while the other ones are only in > master. At first, I wanted to backport them in 3.10 but I change my mind. > Indeed some of the modifications are quite critical (In QgsTaskManager for > instance) and are difficult to fine test (because it's all threads and > synchronisation). > > We're going to invest more time and keep working on this in the days to come > in order to improve stability and maybe efficiency. > > As a consequence, parallel snap cache building and relaxed mode will > land in 3.12 release. > > Thanks QGIS.org for funding this, > > Regards, > Julien > > ___ > 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 [1] https://github.com/qgis/QGIS/issues/33285 [2] https://github.com/qgis/QGIS/issues/33449 ___ 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] QGIS Time Management Call
I am ok with this time. P. On Fri, Jan 10, 2020 at 2:22 PM Anita Graser wrote: > Let's do it after family hours then. > > How about > https://www.timeanddate.com/worldclock/meetingdetails.html?year=2020&month=1&day=17&hour=10&min=0&sec=0&p1=259&p2=240 > > Regards, > Anita > > > > On Thu, Jan 9, 2020 at 11:45 PM Nyall Dawson > wrote: > >> On Fri, 10 Jan 2020 at 00:59, Anita Graser wrote: >> > >> > Hi, >> > >> > Good to hear that work on the time integration is advancing! >> > >> > The best time next week for me would be Friday morning, for example >> 09:00 Vienna time / 19:00 Melbourne time ( >> https://www.timeanddate.com/worldclock/meetingtime.html?day=17&month=1&year=2020&p1=259&p2=152&iv=0 >> ). >> > A bit earlier or later is also possible. I just have a different call >> scheduled for 10:00 already. >> >> Between 18:00 and 19:30 AEST is not an option for me -- that's crazy >> hour with the family! The couple of hours either side of this is fine >> though. >> >> Nyall >> >> >> > >> > Anita >> > >> > >> > >> > >> > >> > On Thu, Jan 9, 2020 at 3:27 PM Tim Sutton wrote: >> >> >> >> Hi Folks (cc QGIS Developer List, anyone else interested in >> contributing to this please let us know). >> >> >> >> I think we (Saber, Peter, Nyall, Samweli and myself) have all chatted >> barring Anita about >> https://github.com/qgis/QGIS-Enhancement-Proposals/issues/161 and the >> related https://github.com/qgis/QGIS-Enhancement-Proposals/issues/128 >> >> >> >> Anita I am including you in the conversation since you have invested a >> lot of energy and time [sic] into time management with your plugin. We are >> hoping we can build something that time manager hooks into (short term) and >> ultimately replaces time manager with core functionality (longer term). >> >> >> >> We have some time zone issues, but I am wondering if we could have a >> little 1 hour hang out session some time next week to plan and collude? >> Anita I think you might have the most issues with timings so how about you >> suggest a time and day if you are able to join (bearing in mind Nyall being >> in Australia) and the rest of us can see if we can make that work? >> >> >> >> Thanks all, look forward to chatting soon! >> >> >> >> Regards >> >> >> >> Tim >> >> >> >> -- >> >> >> -- >> >> >> >> Tim Sutton >> >> Visit http://kartoza.com to find out about open source: >> >> * Desktop GIS programming services >> >> * Geospatial web development >> >> * GIS Training >> >> * Consulting Services >> >> Skype: timlinux Irc: timlinux on #qgis at freenode.net >> >> Tim is a member of the QGIS Project Steering Committee >> >> >> --- >> >> Kartoza is a merger between Linfiniti and Afrispatial >> > ___ 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] QGIS Time Management Call
Let's do it after family hours then. How about https://www.timeanddate.com/worldclock/meetingdetails.html?year=2020&month=1&day=17&hour=10&min=0&sec=0&p1=259&p2=240 Regards, Anita On Thu, Jan 9, 2020 at 11:45 PM Nyall Dawson wrote: > On Fri, 10 Jan 2020 at 00:59, Anita Graser wrote: > > > > Hi, > > > > Good to hear that work on the time integration is advancing! > > > > The best time next week for me would be Friday morning, for example > 09:00 Vienna time / 19:00 Melbourne time ( > https://www.timeanddate.com/worldclock/meetingtime.html?day=17&month=1&year=2020&p1=259&p2=152&iv=0 > ). > > A bit earlier or later is also possible. I just have a different call > scheduled for 10:00 already. > > Between 18:00 and 19:30 AEST is not an option for me -- that's crazy > hour with the family! The couple of hours either side of this is fine > though. > > Nyall > > > > > > Anita > > > > > > > > > > > > On Thu, Jan 9, 2020 at 3:27 PM Tim Sutton wrote: > >> > >> Hi Folks (cc QGIS Developer List, anyone else interested in > contributing to this please let us know). > >> > >> I think we (Saber, Peter, Nyall, Samweli and myself) have all chatted > barring Anita about > https://github.com/qgis/QGIS-Enhancement-Proposals/issues/161 and the > related https://github.com/qgis/QGIS-Enhancement-Proposals/issues/128 > >> > >> Anita I am including you in the conversation since you have invested a > lot of energy and time [sic] into time management with your plugin. We are > hoping we can build something that time manager hooks into (short term) and > ultimately replaces time manager with core functionality (longer term). > >> > >> We have some time zone issues, but I am wondering if we could have a > little 1 hour hang out session some time next week to plan and collude? > Anita I think you might have the most issues with timings so how about you > suggest a time and day if you are able to join (bearing in mind Nyall being > in Australia) and the rest of us can see if we can make that work? > >> > >> Thanks all, look forward to chatting soon! > >> > >> Regards > >> > >> Tim > >> > >> -- > >> > -- > >> > >> Tim Sutton > >> Visit http://kartoza.com to find out about open source: > >> * Desktop GIS programming services > >> * Geospatial web development > >> * GIS Training > >> * Consulting Services > >> Skype: timlinux Irc: timlinux on #qgis at freenode.net > >> Tim is a member of the QGIS Project Steering Committee > >> > --- > >> Kartoza is a merger between Linfiniti and Afrispatial > ___ 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] Plugin [1941] Servicios WMS - IDES Cali approval notification.
Plugin Servicios WMS - IDES Cali approval by pcav. The plugin version "[1941] Servicios WMS - IDES Cali 0.1 Experimental" is now approved Link: http://plugins.qgis.org/plugins/idescali_ws/ ___ 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] Plugin [1723] Color to Attribute approval notification.
Plugin Color to Attribute approval by pcav. The plugin version "[1723] Color to Attribute 0.2.1" is now approved Link: http://plugins.qgis.org/plugins/color_attribute/ ___ 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] Plugin [1940] Produce Training Data For Deep Learning approval notification.
Plugin Produce Training Data For Deep Learning approval by pcav. The plugin version "[1940] Produce Training Data For Deep Learning 0.2 Experimental" is now approved Link: http://plugins.qgis.org/plugins/produce_training_data_for_deep_learning/ ___ 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] Plugin [1940] Produce Training Data For Deep Learning approval notification.
Plugin Produce Training Data For Deep Learning approval by pcav. The plugin version "[1940] Produce Training Data For Deep Learning 0.1 Experimental" is now approved Link: http://plugins.qgis.org/plugins/produce_training_data_for_deep_learning/ ___ 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] Plugin [1146] layer2kmz approval notification.
Plugin layer2kmz approval by pcav. The plugin version "[1146] layer2kmz 1.5.1" is now approved Link: http://plugins.qgis.org/plugins/layer2kmz/ ___ 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] Snap cache improvements grant report
Hi PSC, devs, Here is my report for the Snap cache improvements grant proposal. We write a blog article to better explain what Snap cache improvement was about: https://oslandia.com/en/2020/01/10/en-qgis-snapping-improvements/ This work leads to these PRs : - Manage circular dependencies: https://github.com/qgis/QGIS/pull/30947 - Parallelize and relax snap index building: https://github.com/qgis/QGIS/pull/31648 - Fix QgsTaskManager waitForFinished : https://github.com/qgis/QGIS/pull/32838 The first one is available in 3.10 release while the other ones are only in master. At first, I wanted to backport them in 3.10 but I change my mind. Indeed some of the modifications are quite critical (In QgsTaskManager for instance) and are difficult to fine test (because it's all threads and synchronisation). We're going to invest more time and keep working on this in the days to come in order to improve stability and maybe efficiency. As a consequence, parallel snap cache building and relaxed mode will land in 3.12 release. Thanks QGIS.org for funding this, Regards, Julien ___ 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] Plugin [1935] Nuclear Energy Plants' Radiations approval notification.
Plugin Nuclear Energy Plants' Radiations approval by pcav. The plugin version "[1935] Nuclear Energy Plants' Radiations 1.5 Experimental" is now approved Link: http://plugins.qgis.org/plugins/Nuclear-Energy-Plant-Radiations-/ ___ 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] core API to fetch query output fields from SQL query?
On Fri, Jan 10, 2020 at 09:55:33AM +0100, Sandro Santilli wrote: > On Thu, Jan 09, 2020 at 05:52:16PM +0100, Alessandro Pasotti wrote: > > > This works for me: > > > > vl = QgsVectorLayer( "dbname=qgis_tests host=localhost port=5432 > > key='__rid__' user=ale table=\"(SELECT row_number() OVER () AS __rid__, * > > FROM (SELECT * FROM raster_columns) AS foo)\" schema=public", 'layer', > > 'postgres') > > Ok, I've taken this path [1]. My mistake was using .setDataSource, which > insists in taking a geometry column name. > > [1] x And the commit is: https://github.com/qgis/QGIS/pull/33225/commits/bf4ed9ad47223cd0f9c0b7d7d71c09c646f1bae6 --strk; ___ 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] core API to fetch query output fields from SQL query?
On Thu, Jan 09, 2020 at 05:52:16PM +0100, Alessandro Pasotti wrote: > This works for me: > > vl = QgsVectorLayer( "dbname=qgis_tests host=localhost port=5432 > key='__rid__' user=ale table=\"(SELECT row_number() OVER () AS __rid__, * > FROM (SELECT * FROM raster_columns) AS foo)\" schema=public", 'layer', > 'postgres') Ok, I've taken this path [1]. My mistake was using .setDataSource, which insists in taking a geometry column name. Of course, as expected, doing the QgsVectorLayer dance degrades startup costs as very many vector layers will be created, and there's a number of operations that are done by the PostgreSQL provider when creating such layers (such as retrieving capabilities of the provider). [1] x > Also, the vector API uses an iterator, so chunk retrieval is definitely > possible. Uhm, this would be interesting, does the chunk retrieval depend on key generated by "row_number" as well ? The only downsides I see with using this approach would be: 1. The cost of creating a QgsVectorLayer 2. The need to provide a syntetic primary key 3. (not sure about this): the need to support non-SELECT statements --strk; ___ 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] core API to fetch query output fields from SQL query?
Oops sorry I didn't read it carefully enough! Regards Tim On Fri, Jan 10, 2020, 8:03 AM Alessandro Pasotti wrote: > > > On Thu, Jan 9, 2020 at 11:26 PM Tim Sutton wrote: > >> >>> >>> In particular, me an Nyall have been chatting about adding a method to >>> factory a QgsVectorLayer from a generic SQL query, the issues I see is that >>> we need a PK (at least for PG) and how to decide the geometry column if >>> there are more than one. >>> >> >> I wonder if you could just transparently add row_number[1] to the query >> to give each row a unique id? >> >> Regards >> >> Tim >> >> [1] https://www.postgresqltutorial.com/postgresql-row_number/ >> >> > > Hi Tim, > > the example query I pasted in my original email does exactly that: > (SELECT row_number() > > we just need a bit of login to determine when/if we have to make that > trick. > > > -- > Alessandro Pasotti > w3: www.itopen.it > ___ 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] core API to fetch query output fields from SQL query?
On Thu, Jan 9, 2020 at 11:26 PM Tim Sutton wrote: > >> >> In particular, me an Nyall have been chatting about adding a method to >> factory a QgsVectorLayer from a generic SQL query, the issues I see is that >> we need a PK (at least for PG) and how to decide the geometry column if >> there are more than one. >> > > I wonder if you could just transparently add row_number[1] to the query to > give each row a unique id? > > Regards > > Tim > > [1] https://www.postgresqltutorial.com/postgresql-row_number/ > > Hi Tim, the example query I pasted in my original email does exactly that: (SELECT row_number() we just need a bit of login to determine when/if we have to make that trick. -- Alessandro Pasotti w3: www.itopen.it ___ 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
