[Qgis-user] QGIS master password

it so I was just hoping there is a setting under advanced I can use. Does anyone know if there is one? Thanks, Paul Wittle This e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. It may contain unclassified but sensitive

Re: [Qgis-user] Cross layer filtering

d beer Am 28.03.24 um 14:39 schrieb Paul Wittle via QGIS-User: > Hi, > > I?ve been filtering a layer by adding a virtual column populated with > is_selected() and then creating a virtual layer from it using the filter: > > WHERE virtualField = 1 > > This is working well

[Qgis-user] Cross layer filtering

Hi, I've been filtering a layer by adding a virtual column populated with is_selected() and then creating a virtual layer from it using the filter: WHERE virtualField = 1 This is working well and allows you to have a copy of the layer that only shows the selected records when you are creating

[Qgis-user] DataPlotly pie charts are really small in a layout

Hi, I've been searching around and I can't seem to find any documentation on this. I'm trying to add a pie chart to a layout and it works fine until the size of the pie chart shrinks below a certain size. For small pie charts there seems to be a really big margin applied to the layout option

Re: [Qgis-user] MapInfo export issue

Morning, That tool seems to be saving as I would have expected thank you for the tip  I’ve told the users to use that tool instead of right click > export for now. Cheers, Paul From: Richard Greenwood Sent: 02 December 2021 00:37 To: Nicolas Cadieux Cc: Paul Wittle ; qgis-user Subject:

Re: [Qgis-user] MapInfo export issue

Hi, I've tried exporting to MIF instead of a tab file and it generates an error of "Found [region] while searching for [version]" when you try to load it into the MapInfo. The output is also creating an error when QGIS tries to load the data as well although I'm not sure if QGIS could ever

Re: [Qgis-user] MapInfo export issue

is now incorrect and requires a further alteration to set the CRS? Thanks, Paul From: Zoltán Siki Sent: 30 November 2021 22:54 To: Paul Wittle Subject: Re: [Qgis-user] MapInfo export issue Dear PAul, QGIS exports MapInfo 3 compatible TABs or MIFs in non-earth CRS. You can check it if you

[Qgis-user] MapInfo export issue

Hi, I was just about to try and push out version 3.16.14 but it has been pointed out that if you export to MapInfo tab file it is no longer saving the projection in the output. Is anyone else finding that the resulting files are doing this and is there a work around using say gdal options?

[Qgis-user] WFS rendering issues

Hi, I wanted to load a WFS layer into QGIS and I've found that when using QGIS at work it will not work if the layer source is MSSQL or Oracle but is fine if the database source is PostGIS. Has anyone else had any experience of getting it to work for MSSQL? I'm using GeoServer to serve up the

Re: [Qgis-user] Project file format

Hi, I will try that out; thank you so much for the pointer  Paul From: Hugh Kelley Sent: 16 November 2021 18:11 To: Paul Wittle Cc: qgis-user Subject: Re: [Qgis-user] Project file format Paul, as far as the re-ordering of xml elements, I had a similar question about version control

[Qgis-user] Project file format

Hi, I know people will probably ask "why?" in relation to this question but I've got a Powershell script that I use to create copies of some QGIS projects because I want to change the data source of a couple of layers between dev and test. Rather than do this in QGIS it is done as part of an

[Qgis-user] Info click with geometry generator

Hi, I've added a geometry generator to a line feature layer to buffer the line by 150m. This works fine in terms of the way it is displayed but when you info click on the buffered area it does not return any results. Is there a way to make the info click query based on the full extent of the

[Qgis-user] Oracle configuration switches

Hi, I was wondering, is there a way to set a default setting when adding a new Oracle connection for the option “Use estimated table statistics for the layer metadata” in the ini file? Not to worry if there isn’t / no-one knows but I don’t think there is a list of switches anywhere so I

Re: [Qgis-user] Hardware comparisons

, Paul From: Nicolas Cadieux Sent: 15 June 2021 19:23 To: Paul Wittle Subject: Re: [Qgis-user] Hardware comparisons Hi, I think you will have difficulty finding that. It would be interesting to see. I don’t think QGIS is particularity ram hungry. I have never seen à out of memory error starting

[Qgis-user] Hardware comparisons

Hi, We were doing some testing for using GIS applications as RemoteApp solutions today and I noticed that QGIS seems to be pretty RAM hungry compared with say MapInfo. Does anyone know if there are any good summaries available showing the differences in RAM/CPU use comparing all the big ones

Re: [Qgis-user] Snapping tools really slow

for the help everyone; I'm really really pleased with the performance now!  Paul -Original Message- From: Philip Barlow Sent: 22 January 2021 13:39 To: Paul Wittle ; Julien Cabieces Cc: qgis-user@lists.osgeo.org Subject: RE: [Qgis-user] Snapping tools really slow Hi Paul, What sort

Re: [Qgis-user] Snapping tools really slow

if that is possible. Thanks, Paul -Original Message- From: Julien Cabieces Sent: 22 January 2021 05:32 To: Paul Wittle Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Snapping tools really slow Hi, I made quick tests with some dataset and I failed to see any performance issues. Could you

[Qgis-user] Snapping tools really slow

indices and all is of good quality. As I say the data downloads and displays within seconds on the map; is it because I've selected snapping to segment as well as vertex? Thanks, Paul Wittle [cid:image001.jpg@01D6F016.C23D1CA0]<https://www.dorsetcouncil.gov.uk/> Business Solutions Analyst (GI

[Qgis-user] Best practice, database vs WFS

Hi, As I'm sure is clear from the number of posts I've done of late we are currently looking at how we use QGIS within our business. I thought I'd ask a question here to see if others are considering it as I can't find too much chat online about it but I wondered if perhaps there should be

Re: [Qgis-user] Creating the user profiles

Hi, I have now worked out how to generate a user profile using python and I thought I'd reply to my own post in case it is of use to others. I used: profilePath = QStandardPaths.standardLocations(QStandardPaths.AppDataLocation)[0].replace("python","QGIS") To get a path suitable for loading

[Qgis-user] Creating the user profiles

Hi, When we install QGIS on devices we have a series of customisations particular to our work environment but I notice that the user profile is only generated when the user opens the application for the first time. I was wondering whether a simple python script as shown on 1. Introduction -

Re: [Qgis-user] Deployment customisation options

that using any of the start-up options. I'd be keen to hear other suggestions though? Thanks, Paul From: Paul Wittle Sent: 23 December 2020 09:04 To: qgis-user@lists.osgeo.org Subject: Deployment customisation options Hi, I'm trying to update our deployment of QGIS to use a more standard method

[Qgis-user] Deployment customisation options

Hi, I'm trying to update our deployment of QGIS to use a more standard method of deployment and customisation and I was looking at the page in the manual. I noted the following options --customizationfile and --globalsettingsfile. The customisation file ini turns off certain buttons from

[Qgis-user] Auxiliary Storage

Hi, I can now see that you can export the auxiliary storage information but I can't see an option it import it back. Is this a one way function but I can see lots of uses where you might want to export customised labelling for a layer and then import it into another project? Thanks, Paul

Re: [Qgis-user] Labelling in QGIS 3

but it would also mean that every single record would need to be in the auxiliary storage. I guess the question remains and to whether it can / should be possible via any of the default functionality? Thanks, Paul From: Bernd Vogelgesang Sent: 19 November 2020 14:55 To: Paul Wittle ; qgis-user

[Qgis-user] Labelling in QGIS 3

Hi, Is there a way to turn on labelling without actually displaying any labels? I would like to have a layer where there are no labels but if you use the abc(eye) button I can add remove individual labels as required. At present the best I can find is to label everything then individually hide

[Qgis-user] GeoServer vector tiles in QGIS 3.16

om GeoServer and if so; what URL format did you use? Thanks in advance, Paul Wittle [cid:image009.jpg@01D6BDC7.BF951B50]<https://www.dorsetcouncil.gov.uk/> Business Solutions Analyst (GIS) ICT Operations Dorset Council 01305 228473 dorsetcouncil.gov.uk<https://www.dorsetcouncil.gov.u

[Qgis-user] get_feature_by_id crashing

Hi, Has anyone experienced QGIS crashing out when trying to use get_feature_by_id within a layout? I'm using 3.10.2-A Coruna and it works until I change the ID to 346 at which point QGIS just closes without any error messages. I should point out the layer I'm looking at is an Oracle dataset

[Qgis-user] Python to export layouts

layoutByName("layout ") # name of the layout # or layout = manager.layouts()[0] # first layout exporter = QgsLayoutExporter(layout) exporter.exportToPdf(project_instance.absolutePath() + "/layout-" + timestr + ".pdf", QgsLayoutExporter.PdfExportSettin

[Qgis-user] Inefficient SQL

to replicate the issue; my working theory is trying to load too many features in the attribute table but I'm not sure. Thanks, Paul Wittle [cid:image001.jpg@01D6513B.651ABDE0]<https://www.dorsetcouncil.gov.uk/> Business Solutions Analyst (GIS) ICT Operations Dorset Council 01305

[Qgis-user] sqlcli installation on 32bit and resulting pyodbc error

Hi, I’m trying to install QGIS 3.10 32bit but I’m getting an error when it tries to install the Microsoft SQL Server 2012 Native Client. The error reads “Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see

[Qgis-user] LTR installs

Hi, I seem to always be looking at QGIS at the wrong time of year and once again I seem to have hit the magic LR/PR window where a new Long Term Release has been issued but is not yet showing as the long term release in the advanced installer. As usual my deadline is before the March release.

[Qgis-user] Issue with pyproj import_datadir in 3.4.15

al-c-downloads which I found referenced somewhere. I don't seem to be getting the issue on my 32 bit installation but then for course it was a separate install download so I'm not 100% certain why that one works and this one doesn't. Any help or pointers would be apricated, Paul

[Qgis-user] Selecting by Oracle ROWID in version 3.4.7

Hi, I have an issue with QGIS 3.4.7 as we are doing a normal select from an Oracle table (which is partitioned). We are drawing a rectangle but QGIS is selecting points outside the rectangle. On closer inspection we found that the SQL issues searches for the ROWID rather than the value of the

Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)

To: Tobias Wendorff ; Andrea Peri Cc: qgis-user ; Paul Wittle Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri) (A little late). TL;DR: at least for QGIS, is - never multi-user edit SQLite/SpatiaLite/GeoPackages on network file systems. SQLite, (and therefore SpatiaLite

Re: [Qgis-user] Shortest path (Network Analysis)

Hi, I've also been investigating this sort of work over the last two weeks and have largely come to the same conclusion. I don't think there is a way to do it directly at present without a chargeable plugin but I can't help but feel that it might be possible to create a processing toolbox

Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)

do you do it? Paul P.S. I have heard about the compression issue but I was hoping that will be resolved in the future given the prominence given to the format but the OGC. From: Luigi Pirelli Sent: 27 September 2019 09:56 To: Tobias Wendorff Cc: Andrea Peri ; qgis-user ; Paul Wittle Subject

Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)

Hi, My understanding is that GeoPackage and Spatialite are both based on SQLite so I’ve been assuming both may be susceptible to this bug? Paul From: Andrea Peri Sent: 27 September 2019 09:25 To: Paul Wittle Cc: Gino Pirelli ; qgis-user Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea

Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)

To: Paul Wittle Cc: Alessandro Pasotti ; qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri) without resting importance to the issue, reading the bug report, I can read you moved from oracle spatial to geopackage! why not postgis? Luigi Pirelli

Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)

if others that have experienced the issue could provide any further relevant comments as I’ve not got it as well documented as I’d like. Sorry, time constraints in the office. Many thanks, Paul From: Alessandro Pasotti Sent: 27 September 2019 08:20 To: Paul Wittle Cc: qgis-user@lists.osgeo.org

Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)

Hi Andrea and Enrico, Thank you for providing an answer even if it was not what I was hoping to hear; it was the conclusion I'd reached myself. Has this issue been considered given the official move from shapefile to geopackage as the default format? My understanding was that shapefiles could

Re: [Qgis-user] Shortest path caching

2019 16:09 To: DelazJ Cc: Paul Wittle ; qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Shortest path caching Hi Harrissou I was referring to the online documentation in the developers cookbook. The user guide is effective. I perfectly understand the problem and wish I could help

[Qgis-user] Shortest path caching

Hi, I'm aware that you can use things like the pgRouting plugin for shortest path calculations but when looking at the default functions is there a sensible way to speed up the calculations? I've just run a couple of tests using an Oracle database based routing layer and it runs but seems to

Re: [Qgis-user] Using QgsAuthManager

oesn’t work and neither does quir.uri(False) so what should I be using there or should the QgsRasterLayer function just be accepting a ByteArray or String? Thanks, Paul From: Paul Wittle Sent: 26 July 2019 08:23 To: DelazJ Cc: qgis-user@lists.osgeo.org Subject: RE: [Qgis-user] Using QgsAuthM

Re: [Qgis-user] Using QgsAuthManager

confirmed my interpretations are correct; they compiled but that doesn’t mean I got them right! Thanks, Paul From: DelazJ Sent: 24 July 2019 23:25 To: Paul Wittle Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Using QgsAuthManager Hi, Le mer. 24 juil. 2019 à 14:20, Paul Wittle mailto:paul.wit

Re: [Qgis-user] Oracle Passwords

Hi, Thank you for the speedy pull request for the Oracle passwords. Looks great  Cheers, Paul This e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. It may contain unclassified but sensitive or protectively marked

Re: [Qgis-user] Using QgsAuthManager

Hi, Thanks for the hint; unfortunately I’m still on version 3.4.7 and that plugin requires version 3.6 or above. Thanks, Paul From: Alessandro Pasotti Sent: 24 July 2019 13:22 To: Paul Wittle Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Using QgsAuthManager Hi, you may try

[Qgis-user] Using QgsAuthManager

Hi, I'm trying to use python to assign an authentication configuration to a WMS layers that I'm adding. I have been using the following guide https://docs.qgis.org/3.4/en/docs/pyqgis_developer_cookbook/authentication.html#leave-authcfg-expansion-to-qgsauthmanager. I had to update a few bits as

[Qgis-user] GeoPackage deadlocks

Hi, Is anyone else getting occasional deadlocks when using GeoPackages in the Long Term Release of QGIS? We are using them over a Windows network so there are multiple users trying to access the same GeoPackage files. It all seems fine and two or more can open the file to look at but when

Re: [Qgis-user] Oracle Passwords

Hi, I’m afraid not; there is no authentication section on the Oracle layers. Thanks, Paul From: Luigi Pirelli Sent: 24 July 2019 07:43 To: Paul Wittle Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Oracle Passwords doesn't authentication system works? https://docs.qgis.org/3.4/en

[Qgis-user] Oracle Passwords

Hi, Are there any plans to replace the plain text passwords for Oracle data layers yet and if not; how much work is involved in doing it now it exists for many other formats? We use Oracle pretty heavily and I'd like to remove any reliance on plain text passwords if possible? Many thanks,

Re: [Qgis-user] GDAL locks and filetype support

, should it be "MITAB" or "MapInfo File"? Thanks, Paul From: Paul Wittle Sent: 04 July 2019 15:36 To: qgis-user@lists.osgeo.org Subject: GDAL locks and filetype support Hi, Following on from my previous email it is clear that quite a bit of work would be required to substant

[Qgis-user] GDAL locks and filetype support

recommending its use. I'm a massive advocate of QGIS and working hard to roll it out but it's been a bad couple of weeks with file locks disrupting our users. I'm hoping the database file format (Oracle) will be safe! If anyone else is having similar issues I'd love to hear from you. Thanks, Paul

[Qgis-user] Version 3.4.7 (LTR) is locking MapInfo tab files

Hi, I believe there may already be a bug ticket for this but I've found my deployment of QGIS is causing MapInfo errors when opening MapInfo tab files. It happens when you load the TAB file and also when you open the project and it even happens when a TAB file is open but not rendering. This

Re: [Qgis-user] Rogue start menu shortcut

read and is it really not a quick fix? Would I be correct in thinking there needs to be a switch added to a function in the winToast dependency to fix it? Thanks, Paul -Original Message- From: Paul Wittle Sent: 24 May 2019 08:56 To: qgis-user@lists.osgeo.org Subject: Re: Rogue start menu

Re: [Qgis-user] Rogue start menu shortcut (Fernando M. Roxo da Motta)

3 May 2019 11:43:18 +0000, Paul Wittle wrote: I am not a Windows user, but I know that there is a configuration to show recently used programs in start menu. I think it can be disabled, if one use the procedure to activate and simply uncheck the option. See: https://answers.microsoft.com/en-

Re: [Qgis-user] Rogue start menu shortcut

but this is creating a physical file with the extension *.lnk and as far as I can tell; wintoast is the only bit of code which is aimed at Windows users and has the concept of a *.lnk file (shortcut). Paul From: Alexandre Neto Sent: 23 May 2019 12:34 To: Paul Wittle Cc: qgis-user@lists.osgeo.org

[Qgis-user] Rogue start menu shortcut

Hi, My install of QGIS 3 (LTR) keeps adding a shortcut to the start menu every time I load the application. I can literally delete the shortcut then open QGIS and watch it create the icon again. Does anyone know how to stop it doing this; it is frankly just annoying when applications change

Re: [Qgis-user] 3D views in Reports

suggestions. Paul From: Saber Razmjooei Sent: 15 May 2019 08:20 To: Paul Wittle Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] 3D views in Reports Could you try and reduce the resolution of output (e.g. below 150px)? Regards Saber On Wed, 15 May 2019 at 08:16, Paul Wittle

[Qgis-user] 3D views in Reports

Hi, I'm playing with the report feature in QGIS 3.4 (Madeira) long term release. I added a 3D map view to the report but all I'm getting is a black box in the reports. Are 3D views not yet supported in the report tool or did I miss a setting somewhere? Best Regards, Paul This e-mail and

Re: [Qgis-user] GeoPackage-Hickups

Hi, I think I encountered point 2 the other day using QGIS 2 and although it was the old version I still found it a bit worrying as the fault appeared to be with the GeoPackage format rather than the software (although I'm sure the software is heavily involved really). I tried to add a

[Qgis-user] WMTS y-axis shift using non-global UK projection

if I load the layer in EPSG:3857 (web Mercator) but ironically the base dataset is in EPSG:27700 (BNG) so you would have expected it to be the other way round. Is this issue a known problem or is the issue more likely with my GeoServer Gridset settings? Best Regards, Paul Wittle GIS Developer

Re: [Qgis-user] QGIS 3 Interface Customisation

nce/mastering-qgis-second-edition * Hire me: http://goo.gl/BYRQKg ****** On Thu, 3 Jan 2019 at 12:41, Paul Wittle mailto:p.wit...@dorsetcc.gov.uk>> wrote: Hello, I’m trying to create a cut down pro

[Qgis-user] QGIS 3 Interface Customisation

nd disable The current versions seems to only have the option to display or disable the options but I'm trying to change the menu not disable functionality. Best Regards, Paul Wittle GIS Developer Insight, Intelligence & Performance County Hall Dorchester Dorset. DT1 1XJ Tel: 01305 228473