Re: [Qgis-user] combining fragmented forests (RMG)

[Falk Huettmann]

Hi there,

greetings;
I have seen and done such things, a lot,
and I would like to give you a message of caution about it.

One serious problem is here that it includes error inconsistencies (sheet
edges vs sheet centers),
another one is about classes and patches that are incorrect to start with
(all sheets; merged or not).

In other words,
there are several types of errors in such 'technical artefacts' aka  merged
forest patch maps;
they "cannot be used for navigation", to put it politely.
It's a blurr of things, and a major problem with forest maps and forest
inventory maps out there.

I know of forest maps and regions that have accuracies of 40%, if
ground-truthed.
So yes, they look great on the screen and in GIS but are close to random
(50% accuracy)
if ever used and interpreted for applications.
Please be aware; happy to hear about a fix; beyond technical GIS ones, or
rubber sheeting.

Keep me posted please; thanks.
Very best
   Falk

PS There is currently no single accepted map of global forest cover;
FAO, IUFRO etc cannot really agree on such details whatsoever.
And yes, Remote Sensing products, LIDAR and air photo interpretation
can be rather poor for quality, usually they are.











On Wed, May 6, 2020 at 2:50 PM Michael Harte  wrote:

> Reiko,
>
> You could try something like this:
>
>
>1. Merge all forests into a single file (if you haven't already);
>2. Create a new field in the forests table called something like
>"border"
>3. Create lines that trace the panel boundaries, that separate the
>forests you want to join;
>4. Buffer each of those lines by some small distance  (try 1 meter);
>5. For each buffer "Select by location" all features in forests that
>intersect buffer;
>6. Use the field calculator in the table to enter a unique identifier
>for the selected features in the "border" field;
>7. Do this for each buffer;
>8. Dissolve the forest layer on the border field.
>
> Feel free to get in touch.
>
> Cheers,
>
> Mike
>
>
>
> Message: 1
> Date: Wed, 6 May 2020 14:55:30 -0400
> From: RMG  
> To: qgis-user@lists.osgeo.org
> Subject: [Qgis-user] combining fragmented forests
> Message-ID:
>
> 
> Content-Type: text/plain; charset="utf-8"
>
> Hello,
>
> I have five shapefiles that contain thousands of fragmented forests that I
> created from a NDVI raster of a large protected area in West Africa, which
> I separated into five panels. Now, how do I stitch thousands of the
> fragmented forests at the borders?
>
> Each shapefile's attributes have ID, count (number of units), area, and
> perimeter, so I can visually recognize which fragments need stitching, but
> because there are so many, I don't think I can do it manually.
>
> Any help would be appreciated.
>
> Best wishes,
>
>
> Reiko Matsuda Goodwin
> Comoé Monkey Project <https://www.facebook.com/ComoeMonkeyProject/> 
> <https://www.facebook.com/ComoeMonkeyProject/>
> Guenon Conservation 
> Community<http://facebook.com/GuenonConservationCommunity/> 
> <http://facebook.com/GuenonConservationCommunity/>
> -- next part --
> An HTML attachment was scrubbed...
> URL: 
> <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200506/c823b462/attachment-0001.html>
>  
> <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200506/c823b462/attachment-0001.html>
>
> --
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Shifting WMTS layer

[Stephane Goldstein]

Hi.
I would like to know if there is any way of applying a shift of a few
meters in a WTMS or QuickMapServices layer.

I am using several imagery layers (Bing, ESRI), to collect individual pixel
training data for Sentinel-2. However there is a shift between the two
layers that I would like to correct.

I could temporarily shift the Sentinel-2 image, but because the difference
and direction of the shift is variable across WMTS layers and also
different regions of the same layer, I was wondering if I could shift the
WMTS layer instead of having to do several shifts of the Sentinel-2 layer.
Thanks
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [QGIS-it-user] QGIS 3.10 - Servizio WMS su Win10 inaccessibile per "tipo proxy" non valido

[Andrea Giudiceandrea]

Studio Multiservice s.s. wrote
> https://www.dropbox.com/s/tzn8huvc1bqts7y/Proxy.png?dl=0

L'errore "Impossibile scaricare le capabilities:Scarico delle capabilities
non riuscito: Il tipo di proxy non è valido per questa connession" ("Failed
to retrieve service capabilities. Network error: The proxy type is invalid
for this operation") evidentemente dovrebbe dipendere dalle impostazioni del
proxy di connessione.

Hai controllato se le impostazioni del proxy in QGIS o nelle impostaioni di
sistema sono corrette?
Devi usare un proxy per connetterti ad Internet / sei connesso tramite una
rete aziendale?

Riesci a connetterti ad altri server WMS? Prima riuscivi a connetterti a
questo server e adesso non ci riesci più? Hai aggiornato qualche pacchetto
tramite OSGeo4W setup?

Hai provato ad usare un nuovo profilo utente?

Io comunque, con QGIS 3.10.3 (standalone installer) su Windows 10 riesco ad
usare quel WMS senza problemi (senza alcun proxy impostato).

A presto.

Andrea




--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] combining fragmented forests (RMG)

[Michael Harte]

Reiko,

You could try something like this:

1. Merge all forests into a single file (if you haven't already);
2. Create a new field in the forests table called something like "border"
3. Create lines that trace the panel boundaries, that separate the
   forests you want to join;
4. Buffer each of those lines by some small distance  (try 1 meter);
5. For each buffer "Select by location" all features in forests that
   intersect buffer;
6. Use the field calculator in the table to enter a unique identifier
   for the selected features in the "border" field;
7. Do this for each buffer;
8. Dissolve the forest layer on the border field.

Feel free to get in touch.

Cheers,

Mike




Message: 1
Date: Wed, 6 May 2020 14:55:30 -0400
From: RMG
To:qgis-user@lists.osgeo.org
Subject: [Qgis-user] combining fragmented forests
Message-ID:

Content-Type: text/plain; charset="utf-8"

Hello,

I have five shapefiles that contain thousands of fragmented forests that I
created from a NDVI raster of a large protected area in West Africa, which
I separated into five panels. Now, how do I stitch thousands of the
fragmented forests at the borders?

Each shapefile's attributes have ID, count (number of units), area, and
perimeter, so I can visually recognize which fragments need stitching, but
because there are so many, I don't think I can do it manually.

Any help would be appreciated.

Best wishes,


Reiko Matsuda Goodwin
Comoé Monkey Project<https://www.facebook.com/ComoeMonkeyProject/>
Guenon Conservation Community
<http://facebook.com/GuenonConservationCommunity/>
-- next part --
An HTML attachment was scrubbed...
URL:<http://lists.osgeo.org/pipermail/qgis-user/attachments/20200506/c823b462/attachment-0001.html>

--

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+

[Johanna Botman]

Hi Sunil,

We capture asset data for a local council. There are 27 tables in the database 
representing each asset category. We have times when the demand for the import 
is higher eg at the end of the calendar year and at the end of the financial 
year. When it is busy, we can be adding 2-3000 assets per week. Some of the 
tables already contain 45 000+ assets.

We have no alternatives to software. IT won’t allow it.



Johanna Botman

Assets / GIS Officer – Melton City Council



From: se_su...@rediffmail.com [mailto:se_su...@rediffmail.com]
Sent: Wednesday, 6 May 2020 7:35 PM
To: Johanna Botman 
Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+


Hi!


Can you please share the purpose and process for that you are using QGIS and 
SQL Server (Multi user).
So that I can suggest you another alternate for the same purpose which is fast 
as well as easy to
operate for multi users.



Thanks

Sunil


On Tue, 05 May 2020 12:35:42 +0530 Johanna Botman wrote
>







Hi,

I have a situation where there are three of us using QGIS v3.4 connecting to a 
Microsoft 2016 SQL
Server to add and edit items to tables in the same database at the same time. 
And I’m growing old
waiting for things to happen.

When we were all in the office, we connected through the work network to the 
databases in the cloud and
suffered some issues with delay that may be caused by internet speed. Now that 
we are all working from
home, we have the added complexity
of connecting to our home Wi-Fi then a VPN to the office before we then go out 
to the cloud.

But now the bottom line is that no more than one user at a time can edit the 
tables. Responses are
painfully slow and by mid-afternoon, QGIS is completely unresponsive.

Users love to blame the software. That’s what they are interacting with, but I 
don’t believe that it is
all QGIS’ problem. I’d prefer to blame a database that appears to not respond 
well to a multi user
environment.


Does anyone have any ideas, or strategies, to troubleshoot?



Johanna Botman

Assets / GIS Officer – Melton City Council





***
>
The information in this message is privileged and confidential, intended only 
for the use of the
individual or entity named above. If you are not the intended recipient you are 
hereby notified to
delete the message and that any dissemination, copying or use of its content is 
strictly prohibited. If
you have received this message in error please notify the Melton City Council.
>
***
>


___

Qgis-user mailing list

Qgis-user@lists.osgeo.org

List info: https://lists.osgeo.org/mailman/listinfo/qgis-user

Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

***
The information in this message is privileged and confidential, intended only 
for the use of the individual or entity named above. If you are not the 
intended recipient you are hereby notified to delete the message and that any 
dissemination, copying or use of its content is strictly prohibited. If you 
have received this message in error please notify the Melton City Council.
***
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[QGIS-it-user] QGIS e Schermo HD

[Federico Gianoli]

Carissimi,

forse qualcuno di voi ha avuto o ha il mio stesso problema.  Ho
recentemente cambiato laptop e ne ho acquistato uno con uno schermo in
alta, altissima, definizione. (windows 10)
Apparentemente tutto funziona ma, appena si attacca uno schermo esterno con
una diversa definizione cominciano i problemi e QGIS fa un po' le bizze col
ridimensionamento, diventando illeggibile ed inutilizzabile.

Windows prevede già queste opzioni e nella gestioni schermi ci sono le
opzioni per gestire la scala di ridimensionamento, tuttavia per QGIS non
funzionavano correttamente e QGIS era inutilizzabile per le dimensioni
eccessive.
Scartabellando un po' in giro, e grazie all'aiuto di Alessandro Pasotti, ho
capito che bisogna andare ad agire sulle variabili di ambiente di windows  [
https://www.architectryan.com/2018/08/31/how-to-change-environment-variables-on-windows-10/
] andando ad aggiungere le variabili di ambiente per QT.
Per me ha funzionato impostare questa variabile QT_SCREEN_SCALE_FACTORS = 2
[https://doc.qt.io/qt-5/highdpi.html] e successivamente dalle opzioni di
QGIS > Generale, andare a reimpostare la dimensione delle icone.
Con questa procedura sono riuscito a gestire correttamente il
ridimensionamento di QGIS sui due schermi.

Spero che questa indicazione sia utile anche a qualcuno di voi.

Buon QGISssing a tutti

Federico
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] combining fragmented forests

[Nicolas Cadieux]

Hi,

You can merge the borders while using a Field in the shapefiles.  Look in the 
processing toolbox for merge.

Nicolas Cadieux
Ça va bien aller!

> Le 6 mai 2020 à 16:10, RMG  a écrit :
> 
>  Hello Chris,
> 
> I need to stitch those broken up forests at the shared borders across the 
> tiles. 
> 
> Best wishes,
> 
> Reiko Matsuda Goodwin, PhD (she, her)
> 
> Sent from my iPhone 
> 
>> On May 6, 2020, at 15:57, chris hermansen  wrote:
>> 
>> Reiko and list
>> 
>>> On Wed, May 6, 2020 at 11:55 AM RMG  wrote:
>>> Hello,
>>> 
>>> I have five shapefiles that contain thousands of fragmented forests that I 
>>> created from a NDVI raster of a large protected area in West Africa, which 
>>> I separated into five panels. Now, how do I stitch thousands of the 
>>> fragmented forests at the borders?
>>> 
>>> Each shapefile's attributes have ID, count (number of units), area, and 
>>> perimeter, so I can visually recognize which fragments need stitching, but 
>>> because there are so many, I don't think I can do it manually.
>> 
>> Do you decide to "edge match" your polygons based on common attributes, or 
>> on some kind of geometric concern - shared border across tiles, for example? 
>> 
>> -- 
>> Chris Hermansen · clhermansen "at" gmail "dot" com
>> 
>> C'est ma façon de parler.
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Current status: multiple versions on Mac

[Aldo Piombino]

It seems to me that Catalina has some different characteristics, so you need 
another version of qgis which is ok for sierra or high sierra or mohave. But 
can you upgrade to Catalina? It could be better, also simply by a security issue


Dr. Aldo Piombino
Scienzeedintorni: www.aldopiombino.blogspot.it 
Skype: aldo.piombino








> Il giorno 6 mag 2020, alle ore 13:12, Saber Razmjooei 
>  ha scritto:
> 
> Is Sierra still supported by Apple? It seems to have EOLed late last year.
> 
> Regards
> Saber
> 
> On Wed, 6 May 2020 at 02:35, Priv.-Doz. Dr. Maria Shinoto 
>  > wrote:
> Hi, 
> 
> same here, I am running QGIS 3.4 and 3.10 parallel on Mac OS X 10.15 Catalina 
> without any problem. 
> 
> Was way better than upgrading from 2.18 to 3.4. 
> 
> Best, 
> Maria
> 
> 
> > Am 06.05.2020 um 01:03 schrieb Peter Petrik 
> >  > >:
> > 
> > Hi, 
> > 
> > if you use official installer, it creates you different directories for 
> > different versions (e.g. /Applications/QGIS3.10, /Applications/QGIS3.12). I 
> > have multiple version side-by-side without any problem.
> > 
> > Kind regards,
> > Peter
> > 
> > On Tue, May 5, 2020 at 5:29 PM Chris  > > wrote:
> > Dear Qgis-user List
> > 
> > I'm trying to get a project-team all on the same, new version of QGIS 
> > LTR (3.10). With windows it's fairly easy to install multiple versions 
> > of QGIS, so no discussions there. One user however is on Mac (10.12.6 
> > MacOS Sierra). He says it's not possible for him to install multiple 
> > parallel versions. For fear of breaking current projects he's reluctant 
> > to upgrade.
> > 
> > I've tried to search forums & this news-list archive, but could not find 
> > any recent disussion on that topic.
> > 
> > Could someone provide me with an update on that topic please? Is it 
> > currently easy to have multiple versions of QGIS installed on the same 
> > mac, as on windows, or is that still not possible?
> > 
> > Many thanks!
> > Chris
> > 
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org 
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user 
> > 
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user 
> > 
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org 
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user 
> > 
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user 
> > 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org 
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user 
> 
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user 
> 
> 
> -- 
> Saber Razmjooei
> www.lutraconsulting.co.uk 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] combining fragmented forests

[RMG]

Hello Chris,

I need to stitch those broken up forests at the shared borders across the 
tiles. 

Best wishes,

Reiko Matsuda Goodwin, PhD (she, her)

Sent from my iPhone 

> On May 6, 2020, at 15:57, chris hermansen  wrote:
> 
> Reiko and list
> 
>> On Wed, May 6, 2020 at 11:55 AM RMG  wrote:
>> Hello,
>> 
>> I have five shapefiles that contain thousands of fragmented forests that I 
>> created from a NDVI raster of a large protected area in West Africa, which I 
>> separated into five panels. Now, how do I stitch thousands of the fragmented 
>> forests at the borders?
>> 
>> Each shapefile's attributes have ID, count (number of units), area, and 
>> perimeter, so I can visually recognize which fragments need stitching, but 
>> because there are so many, I don't think I can do it manually.
> 
> Do you decide to "edge match" your polygons based on common attributes, or on 
> some kind of geometric concern - shared border across tiles, for example? 
> 
> -- 
> Chris Hermansen · clhermansen "at" gmail "dot" com
> 
> C'est ma façon de parler.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] combining fragmented forests

[chris hermansen]

Reiko and list

On Wed, May 6, 2020 at 11:55 AM RMG  wrote:

> Hello,
>
> I have five shapefiles that contain thousands of fragmented forests that I
> created from a NDVI raster of a large protected area in West Africa, which
> I separated into five panels. Now, how do I stitch thousands of the
> fragmented forests at the borders?
>
> Each shapefile's attributes have ID, count (number of units), area, and
> perimeter, so I can visually recognize which fragments need stitching, but
> because there are so many, I don't think I can do it manually.
>

Do you decide to "edge match" your polygons based on common attributes, or
on some kind of geometric concern - shared border across tiles, for
example?

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] combining fragmented forests

[RMG]

Hello,

I have five shapefiles that contain thousands of fragmented forests that I
created from a NDVI raster of a large protected area in West Africa, which
I separated into five panels. Now, how do I stitch thousands of the
fragmented forests at the borders?

Each shapefile's attributes have ID, count (number of units), area, and
perimeter, so I can visually recognize which fragments need stitching, but
because there are so many, I don't think I can do it manually.

Any help would be appreciated.

Best wishes,


Reiko Matsuda Goodwin
Comoé Monkey Project 
Guenon Conservation Community

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [QGIS-it-user] QGIS 3.10 - Servizio WMS su Win10 inaccessibile per "tipo proxy" non valido

[Andrea Giudiceandrea]

Studio Multiservice s.s. wrote
> ottengo questo messaggio
> 
> blob:https://web.telegram.org/87d5b90a-9c49-4a9b-ab0d-831ad7c77003

Ciao Alberto,
forse c'è stato un problema nell'incollare il testo del messaggio di errore.

Andrea



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Fwd: Question

[Nicolas Cadieux]

Hi,

Ok what you want to do is to sample a raster with data points (and not 
merge two rasters).   This mean you have a csv of points and a raster 
with values.  You want the values of the raster to be added to a column 
in the csv.   When you open both layers, do they appear to be well 
placed in space (georeferenced) and one on top of the other?  If not, 
right click on the layer in the layer panel and go to "set CRS/Set layer 
CRS".  Once both layers are in the correct CRS, they should be one on 
top of the other.


Then used the Processing tool (sample raster values) or install the 
Point Sampling tool. Both are plugins that need to be activated under 
the plugins menu but the Point Sampling tool will need to be installed 
first.  You will need to save the CSV in another format because you 
cannot write to a CSV.  Use Shp or better, Geopackage.


Nicolas


On 2020-05-06 10:48 a.m., Nikos Benos wrote:

Dear Nicolas,

I have used the following methodology
https://www.qgistutorials.com/en/docs/3/sampling_raster_data.html
It works fine, but the problem is that the coordinates of the tiff 
file are in different scale than the coordinates of the csv file.
If I convert my csv file (list of points with their coordinates) in 
raster file, how will I combine 2 raster files to produce an excel file?

Thank you very much in advance for your help.

Best,
Nikos

Στις Τετ, 6 Μαΐ 2020 στις 4:36 μ.μ., ο/η Nicolas Cadieux 
mailto:nicolas.cadi...@archeotec.ca>> 
έγραψε:


Hi,

You can save a file and reproject it by changing the coordinates
reference system (CRS).  That would change the coordinates (and
the data dependent on the method used).  However, the is the csv a
vector file (a file with a list of points for example) or is it a
true raster file (a matrix).  If it’s a vector file, you will need
to change it as a raster.  Look for rasterize or « vector to
raster ».  Google it to understand the differences between raster
and vector.

Nicolas Cadieux
Ça va bien aller!


Le 6 mai 2020 à 02:22, Nikos Benos mailto:nbe...@uoi.gr>> a écrit :




-- Forwarded message -
Από: *Nikos Benos* mailto:nbe...@uoi.gr>>
Date: Τρί, 5 Μαΐ 2020 στις 12:25 μ.μ.
Subject: Question
To: mailto:qgis-user@lists.osgeo.org>>


Dear Sir or Madam,

I hope all is well with you. I have converted a png file to a
tiff file (when I attached it to the e-mail, the e-mail became
too big and was not sent). I have been trying to combine the tiff
file with a csv file with no success. The reason is that the
coordinate units are different between the 2 files.
Since I have constructed myself the csv file, is there any way to
transform the coordinate units of the png file to make them
compatible to those of the csv file?
Thank you very much in advance for our help and I am sorry if
this is a vdery simple question, but I am very new to QGIS.

Best regards,
Nikos Benos
-- 
Dr Nikos Benos

Associate Professor
Department of Economics
University of Ioannina
University Campus
45110 Ioannina
GREECE
Tel: +30-26510-05955
Fax: +30-26510-05092
e-mail:nbe...@uoi.gr  


-- 
Dr Nikos Benos

Associate Professor
Department of Economics
University of Ioannina
University Campus
45110 Ioannina
GREECE
Tel: +30-26510-05955
Fax: +30-26510-05092
e-mail:nbe...@uoi.gr  
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




--
Dr Nikos Benos
Associate Professor
Department of Economics
University of Ioannina
University Campus
45110 Ioannina
GREECE
Tel: +30-26510-05955
Fax: +30-26510-05092
e-mail:nbe...@uoi.gr  
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[QGIS-it-user] [lavoro] Concorso università di Bologna

[Amedeo Fadini]

Ciao a tutti,

Scusandomi per il cross-posting credo sia interessante far conoscere questo
bando di concorso dell'università di Bologna per la figura di Cartografo

https://www.unibo.it/it/ateneo/concorsi-e-selezioni/bandi-e-avvisi-ta/2020/bando-ta-rif-2523


certo sapere che "verrà anche accertata la conoscenza delle applicazioni
informatiche più diffuse, con particolare riferimento ai programmi Word ed
Excel" non promette molto bene ma tant'è


Ciao a tutti

Amefad
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] QGIS 3.10 - Servizio WMS su Win10 inaccessibile per "tipo proxy" non valido

[Studio Multiservice s.s.]

Niente, scusate,

https://www.dropbox.com/s/tzn8huvc1bqts7y/Proxy.png?dl=0

Grazie


Il giorno mer 6 mag 2020 alle ore 17:18 Studio Multiservice s.s. <
studio.multiservice.mant...@gmail.com> ha scritto:

> Grazie Andrea
>
> il messaggio lo trovate qui (forse,,,)
>
> Alberto
>
>
> Il giorno mer 6 mag 2020 alle ore 16:44 Andrea Giudiceandrea <
> andreaer...@libero.it> ha scritto:
>
>> Studio Multiservice s.s. wrote
>> > ottengo questo messaggio
>> >
>> > blob:https://web.telegram.org/87d5b90a-9c49-4a9b-ab0d-831ad7c77003
>>
>> Ciao Alberto,
>> forse c'è stato un problema nell'incollare il testo del messaggio di
>> errore.
>>
>> Andrea
>>
>>
>>
>> --
>> Sent from:
>> http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
>> ___
>> QGIS-it-user mailing list
>> QGIS-it-user@lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/qgis-it-user
>>
>
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

[QGIS-it-user] Nuovo PSC QGIS 2020

[Totò]

Salve lista,
ecco il nuovo PSC:

benvenuto al nuovo presidente del consiglio QGIS: Marco Bernasocchi -
@mbernasocchi - e al nuovo vicepresidente Alessandro Pasotti - @elpaso66 -
governance: Jürgen Fischer, Andreas Neumann e Anita Graser. Buon lavoro e
grazie a Paolo Cavallini - @paolocavall - chair uscente.

saluti



-
https://pigrecoinfinito.wordpress.com/
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] QGIS 3.10 - Servizio WMS su Win10 inaccessibile per "tipo proxy" non valido

[Studio Multiservice s.s.]

Grazie Andrea

il messaggio lo trovate qui
https://web.telegram.org/87d5b90a-9c49-4a9b-ab0d-831ad7c77003>
 (forse,,,)

Alberto


Il giorno mer 6 mag 2020 alle ore 16:44 Andrea Giudiceandrea <
andreaer...@libero.it> ha scritto:

> Studio Multiservice s.s. wrote
> > ottengo questo messaggio
> >
> > blob:https://web.telegram.org/87d5b90a-9c49-4a9b-ab0d-831ad7c77003
>
> Ciao Alberto,
> forse c'è stato un problema nell'incollare il testo del messaggio di
> errore.
>
> Andrea
>
>
>
> --
> Sent from:
> http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
> ___
> QGIS-it-user mailing list
> QGIS-it-user@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/qgis-it-user
>
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] QGIS forum?

[Erich Purpur]

While it is not an "official" forum, I think of StackOverflow as such :
https://stackoverflow.com/questions/tagged/qgis

On Wed, May 6, 2020 at 12:17 AM Ivan lebedev  wrote:

> I do not understand the mailing lists. This is some kind of retro. Perhaps
> this is convenient for developers, but not for ordinary users. Why is there
> no official user forum like any other program? Or is there?
>
> --
> С уважением,
> *Лебедев Иван Вениаминович*
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Captioning raster layers

[info]

  
  
Hi,
If it's only date metadata you are interested in, you could write
  a script to extract that info from the metadata and display it in
  the raster layer name?
Or, simply, rename the raster layer to include the date?
An other possibility is to create a "legend widget" with the info
  you want to display.

Cheers,
  Benoit


On 06/05/2020 15:54, Nicolas Cadieux
  wrote:


  
  I ment as expressions, not variables.
  
  
  https://docs.qgis.org/latest/en/docs/docs/user_manual/working_with_vector/_expression_.html

Nicolas Cadieux
  Ça va bien aller!


  Le 6 mai 2020 à 09:47, Nicolas Cadieux
 a écrit :

  


  Hi,

A raster database has not been developed yet in QGIS,
  unless it was recently add and don’t know about it.  I did
  not know it could stored in the metadata.  I know some
  metadata (Like layer name, file name) can queried as
  variables.  Could this be used in a python script?
  Anyone???

Ultimately, you could do a raster to vector conversion
  and add the data in a new database. You could make that
  layer transparent but still access the dataset.

Nicolas Cadieux
Ça va bien aller!

Le 6 mai 2020 à 00:03, Patrick
Dunford  a écrit :



Good day



As we know, for vector layers,
we can caption the layers with any field that is stored
in the data table that is incorporated into each layer.



With a raster layer, there
obviously isn't an equivalent data structure attached
within the raster file itself, but within the properties
assigned to each raster layer that is incorporated into
a Qgis project are metadata fields that can be filled in
and presumably this data is stored within the project
file for the layer concerned.



Given that there is this data
stored then I think there is a question that it should
be possible to display any of the fields as a caption
when the raster layer is visible on the canvas and
unfortunately I cannot find any way of doing this. As I
currently use various raster layers in my projects that
are from various dates I would prefer to have some way
of displaying the date associated with each layer within
the canvas and this does not appear to be possible at
present with the software.





___

Qgis-user mailing list

Qgis-user@lists.osgeo.org

List info:
https://lists.osgeo.org/mailman/listinfo/qgis-user

Unsubscribe:
https://lists.osgeo.org/mailman/listinfo/qgis-user

  

  
  
  
  ___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

  


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Captioning raster layers

[info]

  
  
Hi,
If it's only date metadata you are interested in, you could write
  a script to extract that info from the metadata and display it in
  the raster layer name?
Or, simply, rename the raster layer to include the date?
An other possibility is to create a "legend widget" with the info
  you want to display.

Cheers,
  Benoit


On 06/05/2020 15:54, Nicolas Cadieux
  wrote:


  
  I ment as expressions, not variables.
  
  
  https://docs.qgis.org/latest/en/docs/docs/user_manual/working_with_vector/_expression_.html

Nicolas Cadieux
  Ça va bien aller!


  Le 6 mai 2020 à 09:47, Nicolas Cadieux
 a écrit :

  


  Hi,

A raster database has not been developed yet in QGIS,
  unless it was recently add and don’t know about it.  I did
  not know it could stored in the metadata.  I know some
  metadata (Like layer name, file name) can queried as
  variables.  Could this be used in a python script?
  Anyone???

Ultimately, you could do a raster to vector conversion
  and add the data in a new database. You could make that
  layer transparent but still access the dataset.

Nicolas Cadieux
Ça va bien aller!

Le 6 mai 2020 à 00:03, Patrick
Dunford  a écrit :



Good day



As we know, for vector layers,
we can caption the layers with any field that is stored
in the data table that is incorporated into each layer.



With a raster layer, there
obviously isn't an equivalent data structure attached
within the raster file itself, but within the properties
assigned to each raster layer that is incorporated into
a Qgis project are metadata fields that can be filled in
and presumably this data is stored within the project
file for the layer concerned.



Given that there is this data
stored then I think there is a question that it should
be possible to display any of the fields as a caption
when the raster layer is visible on the canvas and
unfortunately I cannot find any way of doing this. As I
currently use various raster layers in my projects that
are from various dates I would prefer to have some way
of displaying the date associated with each layer within
the canvas and this does not appear to be possible at
present with the software.





___

Qgis-user mailing list

Qgis-user@lists.osgeo.org

List info:
https://lists.osgeo.org/mailman/listinfo/qgis-user

Unsubscribe:
https://lists.osgeo.org/mailman/listinfo/qgis-user

  

  
  
  
  ___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

  


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Captioning raster layers

[info]

  
  
Hi,
If it's only date metadata you are interested in, you could write
  a script to extract that info from the metadata and display it in
  the raster layer name?
Or, simply, rename the raster layer to include the date?
An other possibility is to create a "legend widget" with the info
  you want to display.

Cheers,
  Benoit


On 06/05/2020 15:54, Nicolas Cadieux
  wrote:


  
  I ment as expressions, not variables.
  
  
  https://docs.qgis.org/latest/en/docs/docs/user_manual/working_with_vector/_expression_.html

Nicolas Cadieux
  Ça va bien aller!


  Le 6 mai 2020 à 09:47, Nicolas Cadieux
 a écrit :

  


  Hi,

A raster database has not been developed yet in QGIS,
  unless it was recently add and don’t know about it.  I did
  not know it could stored in the metadata.  I know some
  metadata (Like layer name, file name) can queried as
  variables.  Could this be used in a python script?
  Anyone???

Ultimately, you could do a raster to vector conversion
  and add the data in a new database. You could make that
  layer transparent but still access the dataset.

Nicolas Cadieux
Ça va bien aller!

Le 6 mai 2020 à 00:03, Patrick
Dunford  a écrit :



Good day



As we know, for vector layers,
we can caption the layers with any field that is stored
in the data table that is incorporated into each layer.



With a raster layer, there
obviously isn't an equivalent data structure attached
within the raster file itself, but within the properties
assigned to each raster layer that is incorporated into
a Qgis project are metadata fields that can be filled in
and presumably this data is stored within the project
file for the layer concerned.



Given that there is this data
stored then I think there is a question that it should
be possible to display any of the fields as a caption
when the raster layer is visible on the canvas and
unfortunately I cannot find any way of doing this. As I
currently use various raster layers in my projects that
are from various dates I would prefer to have some way
of displaying the date associated with each layer within
the canvas and this does not appear to be possible at
present with the software.





___

Qgis-user mailing list

Qgis-user@lists.osgeo.org

List info:
https://lists.osgeo.org/mailman/listinfo/qgis-user

Unsubscribe:
https://lists.osgeo.org/mailman/listinfo/qgis-user

  

  
  
  
  ___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

  


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[QGIS-it-user] QGIS 3.10 - Servizio WMS su Win10 inaccessibile per "tipo proxy" non valido

[Studio Multiservice s.s.]

Buon pomeriggio a tutt*

ho un problema inusuale su pc Win10 con QGIS 3.10.

All'apertura del servizio WMS della CTR di regione Lombardia

https://www.cartografia.servizirl.it/arcgis2/services/BaseMap/ctr_1980_1994/ImageServer/WMSServer


ottengo questo messaggio

blob:https://web.telegram.org/87d5b90a-9c49-4a9b-ab0d-831ad7c77003

Vi è già successo? Come avere rimediato?

Grazie per ogni aiuto

Alberto
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Fwd: Question

[qgis-user]

  
  
As long as Qgis is set to "Project on the fly" (I think it may be
the default in newer versions), if you load the tiff file first, the
project CRS will be set to the one used by the TIFF file. If you
then load the CSV layer (use add delimited text layer) and in the
dialog specify the correct CRS for the the csv layer.

If you really want to transform the tiff file, open it Qgis, then
right click on the layer and select Export->Save As and set the
CRS to the one you want used (same as the csv file) and save the
raster to a new file.

Or use gdal_transform which was installed with qgis. You will need
to use the command line to do this 
  

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Captioning raster layers

[Nicolas Cadieux]

I ment as expressions, not variables.

https://docs.qgis.org/latest/en/docs/docs/user_manual/working_with_vector/expression.html

Nicolas Cadieux
Ça va bien aller!

> Le 6 mai 2020 à 09:47, Nicolas Cadieux  a écrit 
> :
> 
> Hi,
> 
> A raster database has not been developed yet in QGIS, unless it was recently 
> add and don’t know about it.  I did not know it could stored in the metadata. 
>  I know some metadata (Like layer name, file name) can queried as variables.  
> Could this be used in a python script? Anyone???
> 
> Ultimately, you could do a raster to vector conversion and add the data in a 
> new database. You could make that layer transparent but still access the 
> dataset.
> 
> Nicolas Cadieux
> Ça va bien aller!
> 
>> Le 6 mai 2020 à 00:03, Patrick Dunford  a écrit :
>> 
>> Good day
>> 
>> As we know, for vector layers, we can caption the layers with any field that 
>> is stored in the data table that is incorporated into each layer.
>> 
>> With a raster layer, there obviously isn't an equivalent data structure 
>> attached within the raster file itself, but within the properties assigned 
>> to each raster layer that is incorporated into a Qgis project are metadata 
>> fields that can be filled in and presumably this data is stored within the 
>> project file for the layer concerned.
>> 
>> Given that there is this data stored then I think there is a question that 
>> it should be possible to display any of the fields as a caption when the 
>> raster layer is visible on the canvas and unfortunately I cannot find any 
>> way of doing this. As I currently use various raster layers in my projects 
>> that are from various dates I would prefer to have some way of displaying 
>> the date associated with each layer within the canvas and this does not 
>> appear to be possible at present with the software.
>> 
>> 
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Captioning raster layers

[Nicolas Cadieux]

Hi,

A raster database has not been developed yet in QGIS, unless it was recently 
add and don’t know about it.  I did not know it could stored in the metadata.  
I know some metadata (Like layer name, file name) can queried as variables.  
Could this be used in a python script? Anyone???

Ultimately, you could do a raster to vector conversion and add the data in a 
new database. You could make that layer transparent but still access the 
dataset.

Nicolas Cadieux
Ça va bien aller!

> Le 6 mai 2020 à 00:03, Patrick Dunford  a écrit :
> 
> Good day
> 
> As we know, for vector layers, we can caption the layers with any field that 
> is stored in the data table that is incorporated into each layer.
> 
> With a raster layer, there obviously isn't an equivalent data structure 
> attached within the raster file itself, but within the properties assigned to 
> each raster layer that is incorporated into a Qgis project are metadata 
> fields that can be filled in and presumably this data is stored within the 
> project file for the layer concerned.
> 
> Given that there is this data stored then I think there is a question that it 
> should be possible to display any of the fields as a caption when the raster 
> layer is visible on the canvas and unfortunately I cannot find any way of 
> doing this. As I currently use various raster layers in my projects that are 
> from various dates I would prefer to have some way of displaying the date 
> associated with each layer within the canvas and this does not appear to be 
> possible at present with the software.
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+

[Luke]

Hey Johanna

We have a similar setup and QGIS has been running okay to my knowledge
though it is slower than being in the office. One option you could ask your
IT dept to setup a virtual machine (Citrix etc) with QGIS installed. This
would place your machine within your network and keep all your data
transactions low latency. I have been running QGIS and FME from our
enterprise application servers to achieve the same effect while working
from home.

Luke

On Wed, May 6, 2020 at 4:37 PM Nyall Dawson  wrote:

> On Wed, 6 May 2020 at 16:33, Johanna Botman 
> wrote:
> >
> > Hi Nyall,
> >
> > Yes, I have restarted QGIS. I have even restarted the laptop.
> > BTW I am using QGIS 3.4 as are my colleagues. We are trying to get our
> IT folk to upgrade us to 3.10 but are not having any luck with that.
>
> In that case it's almost certainly NOT a QGIS issue.
>
> I would test direct modification of the database through another
> utility (such as the SQL server management console) to confirm that
> the slowness is a database issue.
>
> Nyall
>
>
> >
> >
> >
> > Johanna Botman
> >
> > Assets / GIS Officer – Melton City Council
> >
> >
> >
> >
> > -Original Message-
> > From: Nyall Dawson [mailto:nyall.daw...@gmail.com]
> > Sent: Wednesday, 6 May 2020 4:31 PM
> > To: Johanna Botman 
> > Cc: chris hermansen ; qgis-user@lists.osgeo.org
> > Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+
> >
> > On Wed, 6 May 2020 at 16:05, Johanna Botman 
> wrote:
> > >
> > > Just to confirm that I have been working all afternoon with all my
> plugins uninstalled. This has made no difference to the issue.
> >
> > Have you tried restarting QGIS when you hit this slowness issue? If so,
> do you experience the slowness immediately after restarting?
> >
> > Nyall
> >
> > >
> > >
> > >
> > > Johanna Botman
> > >
> > > Assets / GIS Officer – Melton City Council
> > >
> > >
> > >
> > > -Original Message-
> > > From: Nyall Dawson [mailto:nyall.daw...@gmail.com]
> > > Sent: Wednesday, 6 May 2020 2:34 PM
> > > To: Johanna Botman 
> > > Cc: chris hermansen ; qgis-user@lists.osgeo.org
> > > Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+
> > >
> > > On Wed, 6 May 2020 at 14:31, Johanna Botman <
> johan...@melton.vic.gov.au> wrote:
> > > >
> > > > Hi Nyall,
> > > >
> > > > I've had good support ideas from you before so I knew that I untick
> all plugins before I asked for more assistance. Sadly, it has not made any
> difference. Did you mean to uninstall them all? I could try that.
> > >
> > > Yes, there is a chance that a plugin which is disabled but still
> installed **could** cause an issue (although unlikely). A clean profile
> would be the easiest way to test this, and QGIS makes it easy to flick
> between profiles so you can quickly switch back to your regular profile
> after testing.
> > >
> > > Nyall
> > >
> > > >
> > > > And, to clarify, each user has their own machine, their own
> installation of QGIS and their own version of the Project file all pointing
> at the one database with all the tables. It does look like a network or
> database issue as I thought.
> > > >
> > > > Thank you.
> > > >
> > > >
> > > >
> > > > Johanna Botman
> > > >
> > > > Assets / GIS Officer – Melton City Council
> > > >
> > > >
> > > >
> > > > -Original Message-
> > > > From: Nyall Dawson [mailto:nyall.daw...@gmail.com]
> > > > Sent: Wednesday, 6 May 2020 2:25 PM
> > > > To: Johanna Botman 
> > > > Cc: chris hermansen ;
> > > > qgis-user@lists.osgeo.org
> > > > Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+
> > > >
> > > > On Wed, 6 May 2020 at 08:19, Johanna Botman <
> johan...@melton.vic.gov.au> wrote:
> > > >
> > > > > What I do know is that the refresh – or my ability to edit and
> save data - in the attribute table slows down when multiple users are
> editing the same table. And I know that this behaviour has become worse now
> that we are all working from home and have the added ‘hops’ in the network
> created by our home Wi-Fi and VPN.
> > > >
> > > > Unless you do have multiple users sharing a single machine (e.g. via
> remote desktop or similar), then this is almost certainly a database or
> network issue*. If everyone is running distinct QGIS sessions on different
> machines then it's highly unlikely that you'd also see the same issues
> arise at the same time of day.
> > > >
> > > > * Unless it's a plugin related issue. I'm aware of some plugins
> which are badly written and cause gradual slow-downs over the course of a
> single QGIS session. So possibly if you ALL had a bad plugin installed and
> ALL started a fresh QGIS session at the start of the day then you may
> experience simultaneous slow downs in the afternoon. The fix for this would
> be starting a clean profile with no plugins installed and testing.
> > > >
> > > > Nyall
> > > >
> > > >
> > > >
> > > > >
> > > > >
> > > > >
> > > > > Our workaround today will be to try to make sure that only one
> person is in a 

Re: [Qgis-user] Qgis-user Digest, Vol 171, Issue 17

[Chavoux Luyt]

Hi Bruno,

On Wed, 6 May 2020, 12:22 ,  wrote:

> Send Qgis-user mailing list -
> From: bru...@mailbox.org
> 
> Subject: [Qgis-user] Multi users environment: From geopackage to a
> database?
>
> 

> Today we run into serious issues when two people worked with the same
> geopackage. I was aware, that it is dangerous and unwise to edit the same
> geopackage from two different computers at the same time.
>


> We are using QGIS 3.12.2 on Windows 10. The Geopackages are located on a
> samba network share.
>
> My questions:
>
> 1. Is this setup that bad? 
>
Yes, it is if you have multiple users. Preventing these kinds of issues is
exactly why databases exist.

> 2. I realize, that we should probably move from geopackage to a database.
> Do we need PostGIS or can we use PostgreSQL? We don't need more
> functinality than a geopackage offers (exept multi user read/edit
> possibility and stability).
>
PostgreSQL comes with PostGIS as a standard  add-in. For GIS work you will
need PostGIS. I would say the primary reason for using PostgreSQL/PostGIS
_is_ for multi-user read/edits and stability. I must confess that as a
single computer single user I have never set up PostGIS or converted an
existing project to PostGIS, so I don't know how difficult the process is
(although from the help files it seems pretty straightforward), but I am
sure there are many others on this mailing list who can help if you get
stuck.

HTH

> Many thanks for some hints that put me in the right direction!
>
> Bruno
>
Cheers
Chavoux
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Current status: multiple versions on Mac

[Saber Razmjooei]

Is Sierra still supported by Apple? It seems to have EOLed late last year.

Regards
Saber

On Wed, 6 May 2020 at 02:35, Priv.-Doz. Dr. Maria Shinoto <
maria.shin...@zaw.uni-heidelberg.de> wrote:

> Hi,
>
> same here, I am running QGIS 3.4 and 3.10 parallel on Mac OS X 10.15
> Catalina without any problem.
>
> Was way better than upgrading from 2.18 to 3.4.
>
> Best,
> Maria
>
>
> > Am 06.05.2020 um 01:03 schrieb Peter Petrik <
> peter.pet...@lutraconsulting.co.uk>:
> >
> > Hi,
> >
> > if you use official installer, it creates you different directories for
> different versions (e.g. /Applications/QGIS3.10, /Applications/QGIS3.12). I
> have multiple version side-by-side without any problem.
> >
> > Kind regards,
> > Peter
> >
> > On Tue, May 5, 2020 at 5:29 PM Chris  wrote:
> > Dear Qgis-user List
> >
> > I'm trying to get a project-team all on the same, new version of QGIS
> > LTR (3.10). With windows it's fairly easy to install multiple versions
> > of QGIS, so no discussions there. One user however is on Mac (10.12.6
> > MacOS Sierra). He says it's not possible for him to install multiple
> > parallel versions. For fear of breaking current projects he's reluctant
> > to upgrade.
> >
> > I've tried to search forums & this news-list archive, but could not find
> > any recent disussion on that topic.
> >
> > Could someone provide me with an update on that topic please? Is it
> > currently easy to have multiple versions of QGIS installed on the same
> > mac, as on windows, or is that still not possible?
> >
> > Many thanks!
> > Chris
> >
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



-- 
Saber Razmjooei
www.lutraconsulting.co.uk
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Multi users environment: From geopackage to a database?

[Jésahel Benoist]

I forgot to cite this important discussion :
https://github.com/qgis/QGIS/issues/27899
that could help in some situations with the following environment variables
:

OGR_SQLITE_JOURNAL=DELETE
SQLITE_USE_OGR_VFS=YES



Le mer. 6 mai 2020 à 12:47, Jésahel Benoist  a écrit :

>
> Le mer. 6 mai 2020 à 12:00, Stefan Keller  a écrit :
>
>> Jésahel  wrote
>> > I've created a script to deactivate wal on samba shares, because samba
>> is the main issue.
>> > It contains this only line :
>> QSettings().setValue("/qgis/walForSqlite3", False)
>>
>> That's interesting. Are you sure it's Samba?
>> SQLite FAQ [2] confirms that NFS has problems.
>> Did not find issues on Samba, but file locking with fcntl is mentioned
>> here [3].
>
>
> No, I was speaking specifically of my concern on samba shares, based on a
> lot (a lot !) of reading/testing like
> https://trac.osgeo.org/gdal/wiki/UserDocs/SQLite
> https://www.sqlite.org/wal.html
>
> https://gis.stackexchange.com/questions/224188/geopackage-error-is-mounted-and-in-wal-mode-this-combination-is-not-allowed
>
>
> I confirm multi-users reading is possible.
>
> If you have problems with WAL files (corrupted or unusable gpkg), you can
> open the gpkg file with spatialite or another program and enter these SQL
> queries :
> PRAGMA integrity_check;
> PRAGMA journal_mode = DELETE;
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Multi users environment: From geopackage to a database?

[Jésahel Benoist]

Le mer. 6 mai 2020 à 12:00, Stefan Keller  a écrit :

> Jésahel  wrote
> > I've created a script to deactivate wal on samba shares, because samba
> is the main issue.
> > It contains this only line : QSettings().setValue("/qgis/walForSqlite3",
> False)
>
> That's interesting. Are you sure it's Samba?
> SQLite FAQ [2] confirms that NFS has problems.
> Did not find issues on Samba, but file locking with fcntl is mentioned
> here [3].


No, I was speaking specifically of my concern on samba shares, based on a
lot (a lot !) of reading/testing like
https://trac.osgeo.org/gdal/wiki/UserDocs/SQLite
https://www.sqlite.org/wal.html
https://gis.stackexchange.com/questions/224188/geopackage-error-is-mounted-and-in-wal-mode-this-combination-is-not-allowed


I confirm multi-users reading is possible.

If you have problems with WAL files (corrupted or unusable gpkg), you can
open the gpkg file with spatialite or another program and enter these SQL
queries :
PRAGMA integrity_check;
PRAGMA journal_mode = DELETE;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Multi users environment: From geopackage to a database?

[Robert Nuske]

Hi Bruno,

another list of known issues with SQLite/GeoPackage and SAMBA in particular
https://trac.osgeo.org/gdal/wiki/UserDocs/SQLite


regards
  robert

Am 06.05.20 um 12:00 schrieb Stefan Keller:
> Hi,
>
> This should be IMHO an issue of highest priority for QGIS.
>
> Jésahel  wrote
>> I've created a script to deactivate wal on samba shares, because samba is 
>> the main issue.
>> It contains this only line : QSettings().setValue("/qgis/walForSqlite3", 
>> False)
> That's interesting. Are you sure it's Samba?
> SQLite FAQ [2] confirms that NFS has problems.
> Did not find issues on Samba, but file locking with fcntl is mentioned here 
> [3].
>
> Goal should IMHO be that 1. No crash, 2. read-only multi-user access
> should be possible and 3. writing users must be warned if QGIS isn't
> able to exclusively open the file.
> And Jésahel  script suggests, that at least point 1 and 2 are possible.
>
> Andreas wrote:
>> Unfortunately it is a known issue that Geopackages and QGIS are bad at 
>> handling simultaneous write and even read requests
>> and developers are working on finding solutions (hopefully soon).
> The only issue I find on QGIS tracker is [1]. Am I missing something?
>
> :Stefan
>
> [1] https://github.com/qgis/QGIS/issues/23991
> [2] https://www.sqlite.org/faq.html#q5
> [3] https://www.samba.org/samba/docs/old/Samba3-HOWTO/locking.html
>
> Am Mi., 6. Mai 2020 um 10:42 Uhr schrieb Jésahel Benoist :
>> Hi Bruno,
>>
>> I've worked a lot on this issue for two years now. I've started with sqlite 
>> (that was faster and better) but finally I decided to migrate to geopackage. 
>> It was painful at first but now it's OK. But it needs some rules.
>>
>> First, I've broken the original big geopackage files into smaller ones. The 
>> users are advised to work only one by one on a specific thematic/file (read 
>> access is possible).
>> I've created a script to deactivate wal on samba shares, because samba is 
>> the main issue. It contains this only line : 
>> QSettings().setValue("/qgis/walForSqlite3", False)
>> You should download some tools like Spatialite_GUI and SQLiteDatabaseBrowser 
>> so that you can really work on the db and have better control. QGIS's 
>> dbmanager is a bit limited and sometimes buggy for sqlite/geopackage, 
>> especially with special chars.
>> Try to work with QGIS internal explorer, it's a tool that has good 
>> export/import functions.
>> Backup files at least one time a day !
>>
>> Now with the covid I have created my own online postgis server so that we 
>> can work at home without "help" of IT department and it's GREAT. Multi-user, 
>> faster, smaller, stronger (lol). And some nice capabilities like spatial 
>> filtering ! I highly recommend this.
>>
>> Questions for all : I've recently discovered this 
>> https://gdal.org/user/virtual_file_systems.html#virtual-file-systems
>> Wouldn't it be possible to avoid samba's multi-users bug with vsi ?
>>
>> Jésahel
>>
>>
>>
>> Le mer. 6 mai 2020 à 09:12, Andreas Neumann  a écrit :
>>> Hi Bruno,
>>>
>>> Unfortunately it is a known issue that Geopackages and QGIS are bad at 
>>> handling simultaneous write and even read requests and developers are 
>>> working on finding solutions (hopefully soon). In single user scenarios 
>>> Geopackages are fine. But Multiuser must be avoided, even for reading only, 
>>> unfortunately.
>>>
>>> As to PostgreSQL vs. Postgis: Postgis is the spatial extension of 
>>> PostgreSQL. If you need geometries (which I assume) than you will need 
>>> Postgis.
>>>
>>> Andreas
>>>
>>> Am 06.05.20 um 08:58 schrieb bru...@mailbox.org:
>>>
>>> Hi
>>>
>>> In my company we are five people who sometimes work with GIS, and we are 
>>> moving from ArcGIS to QGIS (how cool is QGIS and SLYR!) and in this context 
>>> from ESRI file geodatabase to geopackage. Today we run into serious issues 
>>> when two people worked with the same geopackage. I was aware, that it is 
>>> dangerous and unwise to edit the same geopackage from two different 
>>> computers at the same time. But I did not expect both QGIS applications to 
>>> crash immediately and the geopackage to get corrupted. I hoped to get a 
>>> warning or simply not be able to enter edit mode (We later found out, that 
>>> the corrupted geopackage could be recoveredby by adding a new table, this 
>>> somehow fixed it. Whew!).
>>>
>>> Worse, I found that the same thing happens, when I open a QGIS project with 
>>> a layer from a geopackage for display only (no edit mode), which is being 
>>> edited by an other user on an other computer. Again, both QGIS application 
>>> crashed immediately with data loss. Again, the non-responsive QGIS tasks 
>>> could not be killed by windows taskmanager, only by restarting of the 
>>> computers.
>>>
>>> We are using QGIS 3.12.2 on Windows 10. The Geopackages are located on a 
>>> samba network share.
>>>
>>> My questions:
>>>
>>> 1. Is this setup that bad? Do you experience the same fatal consequences if 
>>> someone loads a layer 

Re: [Qgis-user] QGIS forum?

[Robert Nuske]

Ordinary user here who likes mailing lists very much. I find it very
convenient to have announcements and discussions delivered neatly to my
QGIS-Email-Folder.

Isn't the Nabble interface to the mailing list [1] almost like a forum?


regards
  robert

[1] http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html


Am 06.05.20 um 06:17 schrieb Ivan lebedev:
> I do not understand the mailing lists. This is some kind of retro.
> Perhaps this is convenient for developers, but not for ordinary users.
> Why is there no official user forum like any other program? Or is there?
>
> -- 
> С уважением,
> *Лебедев Иван Вениаминович**
> *
>
> ___ Qgis-user mailing list
> Qgis-user@lists.osgeo.org List info:
> https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe:
> https://lists.osgeo.org/mailman/listinfo/qgis-user



pEpkey.asc
Description: application/pgp-keys
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Multi users environment: From geopackage to a database?

[Stefan Keller]

Hi,

This should be IMHO an issue of highest priority for QGIS.

Jésahel  wrote
> I've created a script to deactivate wal on samba shares, because samba is the 
> main issue.
> It contains this only line : QSettings().setValue("/qgis/walForSqlite3", 
> False)

That's interesting. Are you sure it's Samba?
SQLite FAQ [2] confirms that NFS has problems.
Did not find issues on Samba, but file locking with fcntl is mentioned here [3].

Goal should IMHO be that 1. No crash, 2. read-only multi-user access
should be possible and 3. writing users must be warned if QGIS isn't
able to exclusively open the file.
And Jésahel  script suggests, that at least point 1 and 2 are possible.

Andreas wrote:
> Unfortunately it is a known issue that Geopackages and QGIS are bad at 
> handling simultaneous write and even read requests
> and developers are working on finding solutions (hopefully soon).

The only issue I find on QGIS tracker is [1]. Am I missing something?

:Stefan

[1] https://github.com/qgis/QGIS/issues/23991
[2] https://www.sqlite.org/faq.html#q5
[3] https://www.samba.org/samba/docs/old/Samba3-HOWTO/locking.html

Am Mi., 6. Mai 2020 um 10:42 Uhr schrieb Jésahel Benoist :
>
> Hi Bruno,
>
> I've worked a lot on this issue for two years now. I've started with sqlite 
> (that was faster and better) but finally I decided to migrate to geopackage. 
> It was painful at first but now it's OK. But it needs some rules.
>
> First, I've broken the original big geopackage files into smaller ones. The 
> users are advised to work only one by one on a specific thematic/file (read 
> access is possible).
> I've created a script to deactivate wal on samba shares, because samba is the 
> main issue. It contains this only line : 
> QSettings().setValue("/qgis/walForSqlite3", False)
> You should download some tools like Spatialite_GUI and SQLiteDatabaseBrowser 
> so that you can really work on the db and have better control. QGIS's 
> dbmanager is a bit limited and sometimes buggy for sqlite/geopackage, 
> especially with special chars.
> Try to work with QGIS internal explorer, it's a tool that has good 
> export/import functions.
> Backup files at least one time a day !
>
> Now with the covid I have created my own online postgis server so that we can 
> work at home without "help" of IT department and it's GREAT. Multi-user, 
> faster, smaller, stronger (lol). And some nice capabilities like spatial 
> filtering ! I highly recommend this.
>
> Questions for all : I've recently discovered this 
> https://gdal.org/user/virtual_file_systems.html#virtual-file-systems
> Wouldn't it be possible to avoid samba's multi-users bug with vsi ?
>
> Jésahel
>
>
>
> Le mer. 6 mai 2020 à 09:12, Andreas Neumann  a écrit :
>>
>> Hi Bruno,
>>
>> Unfortunately it is a known issue that Geopackages and QGIS are bad at 
>> handling simultaneous write and even read requests and developers are 
>> working on finding solutions (hopefully soon). In single user scenarios 
>> Geopackages are fine. But Multiuser must be avoided, even for reading only, 
>> unfortunately.
>>
>> As to PostgreSQL vs. Postgis: Postgis is the spatial extension of 
>> PostgreSQL. If you need geometries (which I assume) than you will need 
>> Postgis.
>>
>> Andreas
>>
>> Am 06.05.20 um 08:58 schrieb bru...@mailbox.org:
>>
>> Hi
>>
>> In my company we are five people who sometimes work with GIS, and we are 
>> moving from ArcGIS to QGIS (how cool is QGIS and SLYR!) and in this context 
>> from ESRI file geodatabase to geopackage. Today we run into serious issues 
>> when two people worked with the same geopackage. I was aware, that it is 
>> dangerous and unwise to edit the same geopackage from two different 
>> computers at the same time. But I did not expect both QGIS applications to 
>> crash immediately and the geopackage to get corrupted. I hoped to get a 
>> warning or simply not be able to enter edit mode (We later found out, that 
>> the corrupted geopackage could be recoveredby by adding a new table, this 
>> somehow fixed it. Whew!).
>>
>> Worse, I found that the same thing happens, when I open a QGIS project with 
>> a layer from a geopackage for display only (no edit mode), which is being 
>> edited by an other user on an other computer. Again, both QGIS application 
>> crashed immediately with data loss. Again, the non-responsive QGIS tasks 
>> could not be killed by windows taskmanager, only by restarting of the 
>> computers.
>>
>> We are using QGIS 3.12.2 on Windows 10. The Geopackages are located on a 
>> samba network share.
>>
>> My questions:
>>
>> 1. Is this setup that bad? Do you experience the same fatal consequences if 
>> someone loads a layer from a geopackage which is being edited by someone 
>> else? Is there something I do wrong or I that can do to improve the 
>> situation?
>>
>> 2. I realize, that we should probably move from geopackage to a database. Do 
>> we need PostGIS or can we use PostgreSQL? We don't need more functinality 
>> than a geopackage 

Re: [Qgis-user] Multi users environment: From geopackage to a database?

[Jésahel Benoist]

Hi Bruno,

I've worked a lot on this issue for two years now. I've started with sqlite
(that was faster and better) but finally I decided to migrate to
geopackage. It was painful at first but now it's OK. But it needs some
rules.

First, I've broken the original big geopackage files into smaller ones. The
users are advised to work only one by one on a specific thematic/file (read
access is possible).
I've created a script to deactivate wal on samba shares, because samba is
the main issue. It contains this only line :
QSettings().setValue("/qgis/walForSqlite3", False)
You should download some tools like Spatialite_GUI
and SQLiteDatabaseBrowser so that you can really work on the db and have
better control. QGIS's dbmanager is a bit limited and sometimes buggy for
sqlite/geopackage, especially with special chars.
Try to work with QGIS internal explorer, it's a tool that has good
export/import functions.
Backup files at least one time a day !

Now with the covid I have created my own online postgis server so that we
can work at home without "help" of IT department and it's GREAT.
Multi-user, faster, smaller, stronger (lol). And some nice capabilities
like spatial filtering ! I highly recommend this.

Questions for all : I've recently discovered this
https://gdal.org/user/virtual_file_systems.html#virtual-file-systems
Wouldn't it be possible to avoid samba's multi-users bug with vsi ?

Jésahel



Le mer. 6 mai 2020 à 09:12, Andreas Neumann  a écrit :

> Hi Bruno,
>
> Unfortunately it is a known issue that Geopackages and QGIS are bad at
> handling simultaneous write and even read requests and developers are
> working on finding solutions (hopefully soon). In single user scenarios
> Geopackages are fine. But Multiuser must be avoided, even for reading only,
> unfortunately.
>
> As to PostgreSQL vs. Postgis: Postgis is the spatial extension of
> PostgreSQL. If you need geometries (which I assume) than you will need
> Postgis.
>
> Andreas
> Am 06.05.20 um 08:58 schrieb bru...@mailbox.org:
>
> Hi
>
> In my company we are five people who sometimes work with GIS, and we are
> moving from ArcGIS to QGIS (how cool is QGIS and SLYR!) and in this context
> from ESRI file geodatabase to geopackage. Today we run into serious issues
> when two people worked with the same geopackage. I was aware, that it is
> dangerous and unwise to edit the same geopackage from two different
> computers at the same time. But I did not expect both QGIS applications to
> crash immediately and the geopackage to get corrupted. I hoped to get a
> warning or simply not be able to enter edit mode (We later found out, that
> the corrupted geopackage could be recoveredby by adding a new table, this
> somehow fixed it. Whew!).
>
> Worse, I found that the same thing happens, when I open a QGIS project
> with a layer from a geopackage for display only (no edit mode), which is
> being edited by an other user on an other computer. Again, both QGIS
> application crashed immediately with data loss. Again, the non-responsive
> QGIS tasks could not be killed by windows taskmanager, only by restarting
> of the computers.
>
> We are using QGIS 3.12.2 on Windows 10. The Geopackages are located on a
> samba network share.
>
> My questions:
>
> 1. Is this setup that bad? Do you experience the same fatal consequences
> if someone loads a layer from a geopackage which is being edited by someone
> else? Is there something I do wrong or I that can do to improve the
> situation?
>
> 2. I realize, that we should probably move from geopackage to a database.
> Do we need PostGIS or can we use PostgreSQL? We don't need more
> functinality than a geopackage offers (exept multi user read/edit
> possibility and stability).
>
> Many thanks for some hints that put me in the right direction!
>
> Bruno
>
> ___
> Qgis-user mailing listqgis-u...@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Relations in .qlr not restored ?

[Alessandro Pasotti]

On Wed, May 6, 2020 at 9:26 AM Yann Voté  wrote:
>
> Hi all,
>
> I've recently discovered a somewhat unadvertised new feature in QGIS
> 3.12: relations can now be exported as styles!
>
> Consequently, when exporting a bunch of layers as a QGIS Layer
> Definition file (.qlr), relations for each layer are now saved under the
> tags `` and ``.
>
> But when loading back the .qlr file, relations are not restored: project
> relations are empty. Am I missing something ? Is this by design ? A
> feature request ?
>
> Anyway, thanks to all developers and team for the excellent work !
>
> Regards.
>
> Yann
>

Hi Yann,

yes, the relations are now saved within the configuration of the form
widgets that are supposed to use them.

The idea behind that development is that we are now able to
automatically restore relations (and automatically search and load
related layers) when a layer is loaded (or restored if it was a "bad
layer") if the associated style uses a relation (i.e. the style uses a
form that requires a relation, such as relation-reference, but
value-relation also triggers automatic loading).

Coming to your question: it should work, given that the related layers
can be found.
Layers are searched by id, then name and a few providers (postgres)
can also automatically scan for the tables with the same name in the
"current" schema and in other schemas of the same DB of the original
layer (the one stored in the relation information in the style).

You can have a look to the PRs for further details:
https://github.com/qgis/QGIS/pull/33283
https://github.com/qgis/QGIS/pull/33103
https://github.com/qgis/QGIS/pull/32487

Hope this helps.

-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Relations in .qlr not restored ?

[Yann Voté]

Hi all,

I've recently discovered a somewhat unadvertised new feature in QGIS 
3.12: relations can now be exported as styles!


Consequently, when exporting a bunch of layers as a QGIS Layer 
Definition file (.qlr), relations for each layer are now saved under the 
tags `` and ``.


But when loading back the .qlr file, relations are not restored: project 
relations are empty. Am I missing something ? Is this by design ? A 
feature request ?


Anyway, thanks to all developers and team for the excellent work !

Regards.

Yann

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Multi users environment: From geopackage to a database?

[Andreas Neumann]

Hi Bruno,

Unfortunately it is a known issue that Geopackages and QGIS are bad at 
handling simultaneous write and even read requests and developers are 
working on finding solutions (hopefully soon). In single user scenarios 
Geopackages are fine. But Multiuser must be avoided, even for reading 
only, unfortunately.


As to PostgreSQL vs. Postgis: Postgis is the spatial extension of 
PostgreSQL. If you need geometries (which I assume) than you will need 
Postgis.


Andreas

Am 06.05.20 um 08:58 schrieb bru...@mailbox.org:


Hi

In my company we are five people who sometimes work with GIS, and we 
are moving from ArcGIS to QGIS (how cool is QGIS and SLYR!) and in 
this context from ESRI file geodatabase to geopackage. Today we run 
into serious issues when two people worked with the same geopackage. I 
was aware, that it is dangerous and unwise to edit the same geopackage 
from two different computers at the same time. But I did not expect 
both QGIS applications to crash immediately and the geopackage to get 
corrupted. I hoped to get a warning or simply not be able to enter 
edit mode (We later found out, that the corrupted geopackage could be 
recoveredby by adding a new table, this somehow fixed it. Whew!).


Worse, I found that the same thing happens, when I open a QGIS project 
with a layer from a geopackage for display only (no edit mode), which 
is being edited by an other user on an other computer. Again, both 
QGIS application crashed immediately with data loss. Again, the 
non-responsive QGIS tasks could not be killed by windows taskmanager, 
only by restarting of the computers.


We are using QGIS 3.12.2 on Windows 10. The Geopackages are located on 
a samba network share.


My questions:

1. Is this setup that bad? Do you experience the same fatal 
consequences if someone loads a layer from a geopackage which is being 
edited by someone else? Is there something I do wrong or I that can do 
to improve the situation?


2. I realize, that we should probably move from geopackage to a 
database. Do we need PostGIS or can we use PostgreSQL? We don't need 
more functinality than a geopackage offers (exept multi user read/edit 
possibility and stability).


Many thanks for some hints that put me in the right direction!

Bruno


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Multi users environment: From geopackage to a database?

[brunos]

Hi

In my company we are five people who sometimes work with GIS, and we are moving 
from ArcGIS to QGIS (how cool is QGIS and SLYR!) and in this context from ESRI 
file geodatabase to geopackage. Today we run into serious issues when two 
people worked with the same geopackage. I was aware, that it is dangerous and 
unwise to edit the same geopackage from two different computers at the same 
time. But I did not expect both QGIS applications to crash immediately and the 
geopackage to get corrupted. I hoped to get a warning or simply not be able to 
enter edit mode (We later found out, that the corrupted geopackage could be 
recoveredby by adding a new table, this somehow fixed it. Whew!).

Worse, I found that the same thing happens, when I open a QGIS project with a 
layer from a geopackage for display only (no edit mode), which is being edited 
by an other user on an other computer. Again, both QGIS application crashed 
immediately with data loss. Again, the non-responsive QGIS tasks could not be 
killed by windows taskmanager, only by restarting of the computers.

We are using QGIS 3.12.2 on Windows 10. The Geopackages are located on a samba 
network share.

My questions:

1. Is this setup that bad? Do you experience the same fatal consequences if 
someone loads a layer from a geopackage which is being edited by someone else? 
Is there something I do wrong or I that can do to improve the situation?

2. I realize, that we should probably move from geopackage to a database. Do we 
need PostGIS or can we use PostgreSQL? We don't need more functinality than a 
geopackage offers (exept multi user read/edit possibility and stability).

Many thanks for some hints that put me in the right direction!

Bruno___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Insert vs ‘read only file message)

[Hamish Macdonald]

Hi,
My beginner efforts to insert a small village on a map (not included in a
Natural Earth populated places or Euroglobal map BuiltupP layer are being
blocked with a message saying ‘read only’ file. Is there anything obvious
that I may not be doing to get around this?
My thanks to anyone for advice.
Hamish
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+

[Andreas Neumann]

Hi Johanna,

Unfortunately I can't help you explain the gradual slow down during a 
longer edit session.


But I do have experience with databases (not SQL Server but PostgreSQL) 
in a network and my recommendation is to always have QGIS in the same 
network than the database. Having the database in the cloud and QGIS in 
the LAN of your organization with a slow network link in between will 
result in bad performance due to network latency. In the long run, I 
would try to either bring the database to the same LAN within your 
organization to avoid network latency, or alternatively run QGIS desktop 
in the same network/cloud where your database is located. There are 
still functions in QGIS where certain database operations are processed 
one feature at a time and network latency makes this much worse. The 
developers are though trying to eliminate such feature by feature 
processing in favour of processing whole batches at once, which improves 
the situation with slow network connections.


If, for some reason you need the same database in two different 
locations, then I would introduce two database installations local to 
the respective networks and use replication in between to keep the data 
in sync. This reduces the network latency issues significantly.


Andreas

Am 05.05.20 um 08:51 schrieb Johanna Botman:


Hi,

I have a situation where there are three of us using QGIS v3.4 
connecting to a Microsoft 2016 SQL Server to add and edit items to 
tables in the same database at the same time. And I’m growing old 
waiting for things to happen.


When we were all in the office, we connected through the work network 
to the databases in the cloud and suffered some issues with delay that 
may be caused by internet speed. Now that we are all working from 
home, we have the added complexity of connecting to our home Wi-Fi 
then a VPN to the office before we then go out to the cloud.


But now the bottom line is that no more than one user at a time can 
edit the tables. Responses are painfully slow and by mid-afternoon, 
QGIS is completely unresponsive.


Users love to blame the software. That’s what they are interacting 
with, but I don’t believe that it is all QGIS’ problem. I’d prefer to 
blame a database that appears to not respond well to a multi user 
environment.


Does anyone have any ideas, or strategies, to troubleshoot?

**

**

*Johanna Botman*

Assets / GIS Officer – Melton City Council


***
The information in this message is privileged and confidential, 
intended only for the use of the individual or entity named above. If 
you are not the intended recipient you are hereby notified to delete 
the message and that any dissemination, copying or use of its content 
is strictly prohibited. If you have received this message in error 
please notify the Melton City Council.

***

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+

[Nyall Dawson]

On Wed, 6 May 2020 at 16:33, Johanna Botman  wrote:
>
> Hi Nyall,
>
> Yes, I have restarted QGIS. I have even restarted the laptop.
> BTW I am using QGIS 3.4 as are my colleagues. We are trying to get our IT 
> folk to upgrade us to 3.10 but are not having any luck with that.

In that case it's almost certainly NOT a QGIS issue.

I would test direct modification of the database through another
utility (such as the SQL server management console) to confirm that
the slowness is a database issue.

Nyall


>
>
>
> Johanna Botman
>
> Assets / GIS Officer – Melton City Council
>
>
>
>
> -Original Message-
> From: Nyall Dawson [mailto:nyall.daw...@gmail.com]
> Sent: Wednesday, 6 May 2020 4:31 PM
> To: Johanna Botman 
> Cc: chris hermansen ; qgis-user@lists.osgeo.org
> Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+
>
> On Wed, 6 May 2020 at 16:05, Johanna Botman  
> wrote:
> >
> > Just to confirm that I have been working all afternoon with all my plugins 
> > uninstalled. This has made no difference to the issue.
>
> Have you tried restarting QGIS when you hit this slowness issue? If so, do 
> you experience the slowness immediately after restarting?
>
> Nyall
>
> >
> >
> >
> > Johanna Botman
> >
> > Assets / GIS Officer – Melton City Council
> >
> >
> >
> > -Original Message-
> > From: Nyall Dawson [mailto:nyall.daw...@gmail.com]
> > Sent: Wednesday, 6 May 2020 2:34 PM
> > To: Johanna Botman 
> > Cc: chris hermansen ; qgis-user@lists.osgeo.org
> > Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+
> >
> > On Wed, 6 May 2020 at 14:31, Johanna Botman  
> > wrote:
> > >
> > > Hi Nyall,
> > >
> > > I've had good support ideas from you before so I knew that I untick all 
> > > plugins before I asked for more assistance. Sadly, it has not made any 
> > > difference. Did you mean to uninstall them all? I could try that.
> >
> > Yes, there is a chance that a plugin which is disabled but still installed 
> > **could** cause an issue (although unlikely). A clean profile would be the 
> > easiest way to test this, and QGIS makes it easy to flick between profiles 
> > so you can quickly switch back to your regular profile after testing.
> >
> > Nyall
> >
> > >
> > > And, to clarify, each user has their own machine, their own installation 
> > > of QGIS and their own version of the Project file all pointing at the one 
> > > database with all the tables. It does look like a network or database 
> > > issue as I thought.
> > >
> > > Thank you.
> > >
> > >
> > >
> > > Johanna Botman
> > >
> > > Assets / GIS Officer – Melton City Council
> > >
> > >
> > >
> > > -Original Message-
> > > From: Nyall Dawson [mailto:nyall.daw...@gmail.com]
> > > Sent: Wednesday, 6 May 2020 2:25 PM
> > > To: Johanna Botman 
> > > Cc: chris hermansen ;
> > > qgis-user@lists.osgeo.org
> > > Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+
> > >
> > > On Wed, 6 May 2020 at 08:19, Johanna Botman  
> > > wrote:
> > >
> > > > What I do know is that the refresh – or my ability to edit and save 
> > > > data - in the attribute table slows down when multiple users are 
> > > > editing the same table. And I know that this behaviour has become worse 
> > > > now that we are all working from home and have the added ‘hops’ in the 
> > > > network created by our home Wi-Fi and VPN.
> > >
> > > Unless you do have multiple users sharing a single machine (e.g. via 
> > > remote desktop or similar), then this is almost certainly a database or 
> > > network issue*. If everyone is running distinct QGIS sessions on 
> > > different machines then it's highly unlikely that you'd also see the same 
> > > issues arise at the same time of day.
> > >
> > > * Unless it's a plugin related issue. I'm aware of some plugins which are 
> > > badly written and cause gradual slow-downs over the course of a single 
> > > QGIS session. So possibly if you ALL had a bad plugin installed and ALL 
> > > started a fresh QGIS session at the start of the day then you may 
> > > experience simultaneous slow downs in the afternoon. The fix for this 
> > > would be starting a clean profile with no plugins installed and testing.
> > >
> > > Nyall
> > >
> > >
> > >
> > > >
> > > >
> > > >
> > > > Our workaround today will be to try to make sure that only one person 
> > > > is in a particular table at a time.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Johanna, I'm struggling to understand your configuration here.
> > > >
> > > >
> > > >
> > > > Are you working via some kind of remote desktop software? It sounds 
> > > > like it.
> > > >
> > > >
> > > >
> > > > What is your theory as to why response time is worse in the afternoon? 
> > > > Is your connection to your office being overloaded? Is your office's 
> > > > connection to the cloud database also being overloaded? Do your IT 
> > > > support people have any thoughts on why response is worse in the 
> > > > afternoon?
> > > >
> > > >

Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+

[Johanna Botman]

Hi Nyall,

Yes, I have restarted QGIS. I have even restarted the laptop.
BTW I am using QGIS 3.4 as are my colleagues. We are trying to get our IT folk 
to upgrade us to 3.10 but are not having any luck with that.



Johanna Botman

Assets / GIS Officer – Melton City Council




-Original Message-
From: Nyall Dawson [mailto:nyall.daw...@gmail.com] 
Sent: Wednesday, 6 May 2020 4:31 PM
To: Johanna Botman 
Cc: chris hermansen ; qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+

On Wed, 6 May 2020 at 16:05, Johanna Botman  wrote:
>
> Just to confirm that I have been working all afternoon with all my plugins 
> uninstalled. This has made no difference to the issue.

Have you tried restarting QGIS when you hit this slowness issue? If so, do you 
experience the slowness immediately after restarting?

Nyall

>
>
>
> Johanna Botman
>
> Assets / GIS Officer – Melton City Council
>
>
>
> -Original Message-
> From: Nyall Dawson [mailto:nyall.daw...@gmail.com]
> Sent: Wednesday, 6 May 2020 2:34 PM
> To: Johanna Botman 
> Cc: chris hermansen ; qgis-user@lists.osgeo.org
> Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+
>
> On Wed, 6 May 2020 at 14:31, Johanna Botman  
> wrote:
> >
> > Hi Nyall,
> >
> > I've had good support ideas from you before so I knew that I untick all 
> > plugins before I asked for more assistance. Sadly, it has not made any 
> > difference. Did you mean to uninstall them all? I could try that.
>
> Yes, there is a chance that a plugin which is disabled but still installed 
> **could** cause an issue (although unlikely). A clean profile would be the 
> easiest way to test this, and QGIS makes it easy to flick between profiles so 
> you can quickly switch back to your regular profile after testing.
>
> Nyall
>
> >
> > And, to clarify, each user has their own machine, their own installation of 
> > QGIS and their own version of the Project file all pointing at the one 
> > database with all the tables. It does look like a network or database issue 
> > as I thought.
> >
> > Thank you.
> >
> >
> >
> > Johanna Botman
> >
> > Assets / GIS Officer – Melton City Council
> >
> >
> >
> > -Original Message-
> > From: Nyall Dawson [mailto:nyall.daw...@gmail.com]
> > Sent: Wednesday, 6 May 2020 2:25 PM
> > To: Johanna Botman 
> > Cc: chris hermansen ; 
> > qgis-user@lists.osgeo.org
> > Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+
> >
> > On Wed, 6 May 2020 at 08:19, Johanna Botman  
> > wrote:
> >
> > > What I do know is that the refresh – or my ability to edit and save data 
> > > - in the attribute table slows down when multiple users are editing the 
> > > same table. And I know that this behaviour has become worse now that we 
> > > are all working from home and have the added ‘hops’ in the network 
> > > created by our home Wi-Fi and VPN.
> >
> > Unless you do have multiple users sharing a single machine (e.g. via remote 
> > desktop or similar), then this is almost certainly a database or network 
> > issue*. If everyone is running distinct QGIS sessions on different machines 
> > then it's highly unlikely that you'd also see the same issues arise at the 
> > same time of day.
> >
> > * Unless it's a plugin related issue. I'm aware of some plugins which are 
> > badly written and cause gradual slow-downs over the course of a single QGIS 
> > session. So possibly if you ALL had a bad plugin installed and ALL started 
> > a fresh QGIS session at the start of the day then you may experience 
> > simultaneous slow downs in the afternoon. The fix for this would be 
> > starting a clean profile with no plugins installed and testing.
> >
> > Nyall
> >
> >
> >
> > >
> > >
> > >
> > > Our workaround today will be to try to make sure that only one person is 
> > > in a particular table at a time.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Johanna, I'm struggling to understand your configuration here.
> > >
> > >
> > >
> > > Are you working via some kind of remote desktop software? It sounds like 
> > > it.
> > >
> > >
> > >
> > > What is your theory as to why response time is worse in the afternoon? Is 
> > > your connection to your office being overloaded? Is your office's 
> > > connection to the cloud database also being overloaded? Do your IT 
> > > support people have any thoughts on why response is worse in the 
> > > afternoon?
> > >
> > >
> > >
> > > The reason I'm keying on this is that one possibility is that your 
> > > network infrastructure is slightly insufficient for the morning load and 
> > > completely insufficient for the afternoon load.
> > >
> > >
> > >
> > > On the contrary, if your database is starved of resources, why is it 
> > > worse now than when you were working from the office? Again your IT 
> > > people should be able to look at log info or otherwise instrument your 
> > > server to find out if it's the problem (having suggested this I admit I 
> > > wouldn't 

Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+

[Nyall Dawson]

On Wed, 6 May 2020 at 16:05, Johanna Botman  wrote:
>
> Just to confirm that I have been working all afternoon with all my plugins 
> uninstalled. This has made no difference to the issue.

Have you tried restarting QGIS when you hit this slowness issue? If
so, do you experience the slowness immediately after restarting?

Nyall

>
>
>
> Johanna Botman
>
> Assets / GIS Officer – Melton City Council
>
>
>
> -Original Message-
> From: Nyall Dawson [mailto:nyall.daw...@gmail.com]
> Sent: Wednesday, 6 May 2020 2:34 PM
> To: Johanna Botman 
> Cc: chris hermansen ; qgis-user@lists.osgeo.org
> Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+
>
> On Wed, 6 May 2020 at 14:31, Johanna Botman  
> wrote:
> >
> > Hi Nyall,
> >
> > I've had good support ideas from you before so I knew that I untick all 
> > plugins before I asked for more assistance. Sadly, it has not made any 
> > difference. Did you mean to uninstall them all? I could try that.
>
> Yes, there is a chance that a plugin which is disabled but still installed 
> **could** cause an issue (although unlikely). A clean profile would be the 
> easiest way to test this, and QGIS makes it easy to flick between profiles so 
> you can quickly switch back to your regular profile after testing.
>
> Nyall
>
> >
> > And, to clarify, each user has their own machine, their own installation of 
> > QGIS and their own version of the Project file all pointing at the one 
> > database with all the tables. It does look like a network or database issue 
> > as I thought.
> >
> > Thank you.
> >
> >
> >
> > Johanna Botman
> >
> > Assets / GIS Officer – Melton City Council
> >
> >
> >
> > -Original Message-
> > From: Nyall Dawson [mailto:nyall.daw...@gmail.com]
> > Sent: Wednesday, 6 May 2020 2:25 PM
> > To: Johanna Botman 
> > Cc: chris hermansen ; qgis-user@lists.osgeo.org
> > Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+
> >
> > On Wed, 6 May 2020 at 08:19, Johanna Botman  
> > wrote:
> >
> > > What I do know is that the refresh – or my ability to edit and save data 
> > > - in the attribute table slows down when multiple users are editing the 
> > > same table. And I know that this behaviour has become worse now that we 
> > > are all working from home and have the added ‘hops’ in the network 
> > > created by our home Wi-Fi and VPN.
> >
> > Unless you do have multiple users sharing a single machine (e.g. via remote 
> > desktop or similar), then this is almost certainly a database or network 
> > issue*. If everyone is running distinct QGIS sessions on different machines 
> > then it's highly unlikely that you'd also see the same issues arise at the 
> > same time of day.
> >
> > * Unless it's a plugin related issue. I'm aware of some plugins which are 
> > badly written and cause gradual slow-downs over the course of a single QGIS 
> > session. So possibly if you ALL had a bad plugin installed and ALL started 
> > a fresh QGIS session at the start of the day then you may experience 
> > simultaneous slow downs in the afternoon. The fix for this would be 
> > starting a clean profile with no plugins installed and testing.
> >
> > Nyall
> >
> >
> >
> > >
> > >
> > >
> > > Our workaround today will be to try to make sure that only one person is 
> > > in a particular table at a time.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Johanna, I'm struggling to understand your configuration here.
> > >
> > >
> > >
> > > Are you working via some kind of remote desktop software? It sounds like 
> > > it.
> > >
> > >
> > >
> > > What is your theory as to why response time is worse in the afternoon? Is 
> > > your connection to your office being overloaded? Is your office's 
> > > connection to the cloud database also being overloaded? Do your IT 
> > > support people have any thoughts on why response is worse in the 
> > > afternoon?
> > >
> > >
> > >
> > > The reason I'm keying on this is that one possibility is that your 
> > > network infrastructure is slightly insufficient for the morning load and 
> > > completely insufficient for the afternoon load.
> > >
> > >
> > >
> > > On the contrary, if your database is starved of resources, why is it 
> > > worse now than when you were working from the office? Again your IT 
> > > people should be able to look at log info or otherwise instrument your 
> > > server to find out if it's the problem (having suggested this I admit I 
> > > wouldn't use SQL Server and know nothing about tuning it).
> > >
> > >
> > >
> > > Can you run a different configuration, say with QGIS on your home 
> > > computer and some kind of database proxy in your office, or even a direct 
> > > connection to the cloud database (assuming I've guessed your 
> > > configuration correctly)?
> > >
> > >
> > >
> > > Users love to blame the software. That’s what they are interacting with, 
> > > but I don’t believe that it is all QGIS’ problem. I’d prefer to blame a 
> > > database that appears to not respond 

[Qgis-user] Fwd: Question

[Nikos Benos]

-- Forwarded message -
Από: Nikos Benos 
Date: Τρί, 5 Μαΐ 2020 στις 12:25 μ.μ.
Subject: Question
To: 


Dear Sir or Madam,

I hope all is well with you. I have converted a png file to a tiff file
(when I attached it to the e-mail, the e-mail became too big and was not
sent). I have been trying to combine the tiff file with a csv file with no
success. The reason is that the coordinate units are different between the
2 files.
Since I have constructed myself the csv file, is there any way to transform
the coordinate units of the png file to make them compatible to those of
the csv file?
Thank you very much in advance for our help and I am sorry if this is a
vdery simple question, but I am very new to QGIS.

Best regards,
Nikos Benos
-- 

Dr Nikos Benos
Associate Professor
Department of Economics
University of Ioannina
University Campus
45110 Ioannina
GREECE
Tel: +30-26510-05955
Fax: +30-26510-05092
e-mail: nbe...@uoi.gr



-- 

Dr Nikos Benos
Associate Professor
Department of Economics
University of Ioannina
University Campus
45110 Ioannina
GREECE
Tel: +30-26510-05955
Fax: +30-26510-05092
e-mail: nbe...@uoi.gr
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Dumb USGS geotiff questions

[Jonas]

Hi Morgan,

i would suggest to NOT use Pseudo Mercator as the projects CRS and therefore
also not the Google Maps Layer as a Base Layer. Pseudo Mercator is from my
experience simply not made for these kinds of work, because its accuracy is
limited especially when it comes to locations away from the equator.

As your work requires a decent accurate reference layer i would suggest you
seek out a reference layer in a appropriate projection like UTM or LAEA
depending on the extent of your study area. Your local authorities may
provide you with this data, for example.

Regarding your specific question QGIS will from time to time ask you for the
transformation to use when in doubt. I mostly check the first option because
i cannot be bothered to look further than the estimated accuracy.

Cheers
Jonas


Morgan Fletcher wrote
> Trying this again. Thanks, Mike Flanagan, for trying to help me the first
> time.
> 
> I start a new project in QGIS 3.12. I have a USGS
> map CA_Concord_297163_1915_62500_geo.tif, downloaded from here
> https://ngmdb.usgs.gov/topoview/viewer/#11/37.8612/-122.0759;, the
> "Concord, CA 1915, 1915 edition" map. I add "Google Maps" from Browser >
> XYZ Tiles as a base map. My project properties show WGS/84
> Pseudo-Mercator,
> EPSG:3857. I select Layer > Add Layer > Add Raster Layer... > I can select
> this geotiff. Clicking Add brings up this dialog. What do I choose?
> 
>  Screen Shot 2020-04-18 at 12.54.31 PM.png
> https://drive.google.com/file/d/1FKVPrHLtXXKK8a-QTTz3IigT9dpj1Hou/view?usp=drive_web;
> 
> What do I choose?
> 
> The reason why I ask, is that all my usgs maps are offset from the base
> map
> enough to be maddening. I know these things are imperfect, but even the
> corners labeled with known points are off. Below is the gdalinfo output
> for
> this file. Last question; if I georeference this tif file, versus trusting
> its metadata, the top corners left and right have two divergent borders.
> They start from a common point at bottom and at the top they are maybe a
> degree apart. Which of these two endpoints matches the stated coordinate?
> 
> Morgans-MBP-2:CA_Concord_297163_1915_62500_geo_tif morganfletcher$
> /Applications/QGIS3.12.app/Contents/MacOS/bin/gdalinfo
> CA_Concord_297163_1915_62500_geo.tif
> Driver: GTiff/GeoTIFF
> Files: CA_Concord_297163_1915_62500_geo.tif
> Size is 4775, 5908
> Coordinate System is:
> PROJCS["unnamed",
> GEOGCS["NAD27",
> DATUM["North_American_Datum_1927",
> SPHEROID["Clarke 1866",6378206.4,294.9786982138982,
> AUTHORITY["EPSG","7008"]],
> AUTHORITY["EPSG","6267"]],
> PRIMEM["Greenwich",0],
> UNIT["degree",0.0174532925199433],
> AUTHORITY["EPSG","4267"]],
> PROJECTION["Polyconic"],
> PARAMETER["latitude_of_origin",0],
> PARAMETER["central_meridian",-122.125],
> PARAMETER["false_easting",0],
> PARAMETER["false_northing",0],
> UNIT["metre",1,
> AUTHORITY["EPSG","9001"]]]
> Origin = (-12632.067326823029362,4208868.700336153618991)
> Pixel Size = (5.291,-5.2916640)
> Metadata:
>   AREA_OR_POINT=Area
>   TIFFTAG_RESOLUTIONUNIT=2 (pixels/inch)
>   TIFFTAG_XRESOLUTION=300
>   TIFFTAG_YRESOLUTION=300
> Image Structure Metadata:
>   COMPRESSION=YCbCr JPEG
>   INTERLEAVE=PIXEL
>   SOURCE_COLOR_SPACE=YCbCr
> Corner Coordinates:
> Upper Left  (  -12632.067, 4208868.700) (122d16' 7.84"W, 38d 0'50.81"N)
> Lower Left  (  -12632.067, 4177605.534) (122d16' 5.87"W, 37d43'56.80"N)
> Upper Right (   12635.641, 4208868.700) (121d58'52.01"W, 38d 0'50.81"N)
> Lower Right (   12635.641, 4177605.534) (121d58'53.98"W, 37d43'56.80"N)
> Center  (   1.787, 4193237.117) (122d 7'29.93"W, 37d52'24.13"N)
> Band 1 Block=512x512 Type=Byte, ColorInterp=Red
>   Overviews: 2388x2954, 1194x1477, 597x739, 299x370, 150x185, 75x93, 38x47
> Band 2 Block=512x512 Type=Byte, ColorInterp=Green
>   Overviews: 2388x2954, 1194x1477, 597x739, 299x370, 150x185, 75x93, 38x47
> Band 3 Block=512x512 Type=Byte, ColorInterp=Blue
>   Overviews: 2388x2954, 1194x1477, 597x739, 299x370, 150x185, 75x93, 38x47
> 
> On Sat, Apr 18, 2020 at 2:43 PM Morgan Fletcher 

> morgan@

>  wrote:
> 
>> (Resending, with screenshots as google drive links, to cut down message
>> size.)
>>
>> I am running 3.12.1-București on a mac, os-x 10.14.6. My knowledge of GIS
>> is rudimentary, I've learned what I need to, to satisfy my curiosity
>> about
>> my region, using old maps.
>>
>> I have downloaded all the USGS maps for my region - Oakland, CA, USA,
>> which corresponds to "CA Concord" - from USGS topoView, in geotiff
>> format.
>> Opening them in QGIS gives fairly wild offsets; they are not all encoded
>> the same way, yet have common corners. Features on the map vary with what
>> modern maps show, but getting their corners right would help me a lot.
>>
>> If I create a new project, set my CRS to WGS 84 / Pseudo-Mercator
>> (EPSG:3857) as I think is correct for my base map, Google Maps 

Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+

[Johanna Botman]

Just to confirm that I have been working all afternoon with all my plugins 
uninstalled. This has made no difference to the issue.



Johanna Botman

Assets / GIS Officer – Melton City Council



-Original Message-
From: Nyall Dawson [mailto:nyall.daw...@gmail.com] 
Sent: Wednesday, 6 May 2020 2:34 PM
To: Johanna Botman 
Cc: chris hermansen ; qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+

On Wed, 6 May 2020 at 14:31, Johanna Botman  wrote:
>
> Hi Nyall,
>
> I've had good support ideas from you before so I knew that I untick all 
> plugins before I asked for more assistance. Sadly, it has not made any 
> difference. Did you mean to uninstall them all? I could try that.

Yes, there is a chance that a plugin which is disabled but still installed 
**could** cause an issue (although unlikely). A clean profile would be the 
easiest way to test this, and QGIS makes it easy to flick between profiles so 
you can quickly switch back to your regular profile after testing.

Nyall

>
> And, to clarify, each user has their own machine, their own installation of 
> QGIS and their own version of the Project file all pointing at the one 
> database with all the tables. It does look like a network or database issue 
> as I thought.
>
> Thank you.
>
>
>
> Johanna Botman
>
> Assets / GIS Officer – Melton City Council
>
>
>
> -Original Message-
> From: Nyall Dawson [mailto:nyall.daw...@gmail.com]
> Sent: Wednesday, 6 May 2020 2:25 PM
> To: Johanna Botman 
> Cc: chris hermansen ; qgis-user@lists.osgeo.org
> Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+
>
> On Wed, 6 May 2020 at 08:19, Johanna Botman  
> wrote:
>
> > What I do know is that the refresh – or my ability to edit and save data - 
> > in the attribute table slows down when multiple users are editing the same 
> > table. And I know that this behaviour has become worse now that we are all 
> > working from home and have the added ‘hops’ in the network created by our 
> > home Wi-Fi and VPN.
>
> Unless you do have multiple users sharing a single machine (e.g. via remote 
> desktop or similar), then this is almost certainly a database or network 
> issue*. If everyone is running distinct QGIS sessions on different machines 
> then it's highly unlikely that you'd also see the same issues arise at the 
> same time of day.
>
> * Unless it's a plugin related issue. I'm aware of some plugins which are 
> badly written and cause gradual slow-downs over the course of a single QGIS 
> session. So possibly if you ALL had a bad plugin installed and ALL started a 
> fresh QGIS session at the start of the day then you may experience 
> simultaneous slow downs in the afternoon. The fix for this would be starting 
> a clean profile with no plugins installed and testing.
>
> Nyall
>
>
>
> >
> >
> >
> > Our workaround today will be to try to make sure that only one person is in 
> > a particular table at a time.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Johanna, I'm struggling to understand your configuration here.
> >
> >
> >
> > Are you working via some kind of remote desktop software? It sounds like it.
> >
> >
> >
> > What is your theory as to why response time is worse in the afternoon? Is 
> > your connection to your office being overloaded? Is your office's 
> > connection to the cloud database also being overloaded? Do your IT support 
> > people have any thoughts on why response is worse in the afternoon?
> >
> >
> >
> > The reason I'm keying on this is that one possibility is that your network 
> > infrastructure is slightly insufficient for the morning load and completely 
> > insufficient for the afternoon load.
> >
> >
> >
> > On the contrary, if your database is starved of resources, why is it worse 
> > now than when you were working from the office? Again your IT people should 
> > be able to look at log info or otherwise instrument your server to find out 
> > if it's the problem (having suggested this I admit I wouldn't use SQL 
> > Server and know nothing about tuning it).
> >
> >
> >
> > Can you run a different configuration, say with QGIS on your home computer 
> > and some kind of database proxy in your office, or even a direct connection 
> > to the cloud database (assuming I've guessed your configuration correctly)?
> >
> >
> >
> > Users love to blame the software. That’s what they are interacting with, 
> > but I don’t believe that it is all QGIS’ problem. I’d prefer to blame a 
> > database that appears to not respond well to a multi user environment.
> >
> >
> >
> > I'd be inclined to blame the network first, since that's what it sounds 
> > like has changed.
> >
> >
> >
> > Chris
> >
> >
> > 
> > **
> > * The information in this message is privileged and 
> > confidential, intended only for the use of the individual or entity named 
> > above. If you are not the intended recipient you are hereby