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

2020-05-05 Thread 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+

2020-05-05 Thread 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+

2020-05-05 Thread 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+

2020-05-05 Thread 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 use

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

2020-05-05 Thread 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

2020-05-05 Thread 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

2020-05-05 Thread 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
> ;, 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
> ;
> 
> 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 Ma

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

2020-05-05 Thread 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 notif

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

2020-05-05 Thread Johanna Botman
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.

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 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.
*

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

2020-05-05 Thread Nyall Dawson
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 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

Re: [Qgis-user] Cost effective illustrator software

2020-05-05 Thread Nyall Dawson
On Wed, 6 May 2020 at 00:58, Jeff McKenna  wrote:
>
> Hi Hamish,
>
> I use Inkscape, very powerful and FOSS : https://inkscape.org/  Worth
> your investment in time to learn it, and you will never turn back.

Just to be the dissenting voice here -- although I'm a HUGE fan of
open source software and use Inkscape a LOT, it really isn't
comparable to Illustrator for heavy duty work. I'd turn to Inkscape
for quick tasks like editing/creating icons, but would never use it to
post process a complex map.

I hope one day Inkscape does reach parity with Illustrator (and I'd
actively contribute to seeing this happen, if my time wasn't more
valuable to spend contributing to QGIS)

That said, Adobe's licensing is horrible and completely out-of-sync
with the resources and needs of spatial freelancers. Thanks for the
heads-up to affinity, I'll be checking this out!

Nyall

>
>
> -jeff
>
>
>
> --
> Jeff McKenna
> MapServer Consulting and Training Services
> https://gatewaygeo.com/
>
>
>
> On 2020-05-05 11:38 a.m., Hamish Macdonald wrote:
> > Hi,
> > Is adobe illustrator a cost effective investment for enhancing my modest
> > beginnings as a Qgis user? Thanks to anyone who can give me a heads up.
> >
> > regards 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
___
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+

2020-05-05 Thread Nyall Dawson
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 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] QGIS forum?

2020-05-05 Thread Nyall Dawson
On Wed, 6 May 2020 at 14:17, 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?

"Forums" are really just as retro as mailing lists these days.

If you're looking for a support site, you should use
gis.stackexchange.com. If you're looking for a mapping-chat-site, I
suggest signing up to Twitter and following a bunch of the QGIS
community for tips and inspiration.

Nyall
___
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] QGIS forum?

2020-05-05 Thread 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

[Qgis-user] Captioning raster layers

2020-05-05 Thread Patrick Dunford

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

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

2020-05-05 Thread Priv.-Doz. Dr. Maria Shinoto
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

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

2020-05-05 Thread William Kyngesburye
Except that the official installer doesn't work on Sierra.

My packages (the other official installer) do work for Sierra, BUT they're old, 
only 3.4 (old LTR) and 3.8.  I'm way behind on updating these, but I'm close, 
and I will be making Sierra the minimum so they'll still work for Mac user.  My 
naming method is to not use folders, just name the app with the version (at 
least to distinguish LTR from current).

Note that they are not the fully all-in-one that some people like, I prefer to 
have some of the tools (python, GDAL) easily accessible from a Terminal and 
scripts and usable by other software (ie PostGIS uses GDAL, PROJ and GEOS), so 
they separately installed outside the QGIS app (but all provided on the QGIS 
disk image).

-
William Kyngesburye



Don't Panic

> On May 5, 2020, at 11:10 AM, Peter Petrik 
>  wrote:
> 
> 
> 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

Re: [Qgis-user] (no subject)

2020-05-05 Thread qgis-user

  
  
On 5/5/2020 4:30 PM, Antonio Corbo
  wrote:

Salve,
  ho un problema e non so come risolverlo, Spero che possiate
aiutarmi.
  Qual sono i passaggi per fare delle channels network and
drainage basins from SAGA?
  Io so che è necessario un DEM(che ho) da cui si ricava un TPI
e un DWI che uniti danno cost surface. Ma purtroppo non conosco
bene i passaggi per ottenere tutto questo. Potete aiutarmi? 
  Grazie in anticipo

Translation:
Hello,
i have a problem and i don't know how to solve it, i hope you can help me.
What are the steps to make channels network and drainage basins from SAGA?
I know that a DEM is needed (which I have) from which a TPI and a DWI are obtained which together give cost surface. But unfortunately I don't know the steps to get all this well. Can you help me?
Thanks in advance


  

___
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

2020-05-05 Thread Morgan Fletcher
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
, 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


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  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 (EPSG:3857 -
> WGS 84 / Pseudo-Mercator - Projected) then Layer > Add Layer > Add Raster
> Layer > Raster Dataset > CA_Concord_465520_1943_62500_geo.tif > Add, I get
> prompted with:
>
>
> https://drive.google.com/file/d/1FKVPrHLtXXKK8a-QTTz3IigT9dpj1Hou/view?usp=sharing
>
> I don't know what to choose, here. I chose the first one. I've tried
> others. The tif.prj file does say
> DATUM["D_North_American_1927",SPHEROID["Clarke_1866",6378206.4,294.9786982]],
> which I am guessing conforms to NAD27. If I add an opacity slider to the
> new raster layer, set its opacity, and then use the Zoom to Coordinate
> panel to navigate to 37º45'N 122º15'W, I find that the point is off from
> what's on the map, see:
>
>
> https://drive.google.com/file/d/10vYtcM1FZ-vdS3z1FPW2EYbrNy2sj65L/view?usp=sharing
>
> This is similarly true at the top left:
>
>
> https://drive.google.com/file/d/18naBKuwk6rZ9DP0tFOZxnGKlIpRQgDKM/view?usp=sharing
>
> Also, note how the map shows two lines at top left, it's true at top
> right. This

[Qgis-user] (no subject)

2020-05-05 Thread Antonio Corbo
Salve,
ho un problema e non so come risolverlo, Spero che possiate aiutarmi.
Qual sono i passaggi per fare delle channels network and drainage basins
from SAGA?
Io so che è necessario un DEM(che ho) da cui si ricava un TPI e un DWI che
uniti danno cost surface. Ma purtroppo non conosco bene i passaggi per
ottenere tutto questo. Potete aiutarmi?
Grazie in anticipo


Mail
priva di virus. www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
___
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+

2020-05-05 Thread Johanna Botman
Hi Chris,

Thanks for your reply.
I don’t have any transparency on the config of our network so I can’t answer 
that. It is possible that my frustration peaks in the afternoon and it is 
possible that is a red herring.

Each user has a similar project that contains tables in a SQL database. We need 
to add and edit items in these tables but struggle when more than one person is 
editing in the same table.

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.

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 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

Re: [Qgis-user] Cost effective illustrator software

2020-05-05 Thread Benjamin Wragg
+1 for Affinity. Its awesome and its 50% off at the moment. My friend runs a 
graphic design business, just ditched the entire Adobe suite (such a rip) and 
uses Affinity. 

> On 6 May 2020, at 12:40 am, Alexander Numann  
> wrote:
> 
> Adobe's software as a service model will cost you a lot in the long run. 
> Maybe evaluate Affinity designer as an alternative - you purchase the license 
> once rather than paying monthly I believe.
> ___
> 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] Adding feature to PostGIS layer that has joins is really slow

2020-05-05 Thread Nuno Lopes
Hi Chris, thanks for the suggestions.
I have opened a bug with QGIS that was accepted
https://github.com/qgis/QGIS/issues/36167 .
In the meantime I'l have to go with one of the alternatives (still figuring
out which one is best for my case)

Thanks again,
Nuno Lopes

On Sun, May 3, 2020 at 5:02 PM chris hermansen 
wrote:

> Nuno and list
>
> On Sun, May 3, 2020, 04:50 Nuno Lopes  wrote:
>
>> Hi Chris and list,
>>
>> This is the minimal setup where I could reproduce my performance issue.
>> The final idea is to have multiple 1:0-1 tables that have different
>> mandatory and optional fields. So putting all this in a single table would
>> be very difficult (I can see it done using triggers and checks on the
>> database but UX would be bad)
>>
>
> Normally one would allow nulls for optional attributes rather than
> separate them into different tables.
>
> "UX would be bad" - how so? If you are building CRUD forms they can view a
> semantic type field on the table and respond to that.
>
> Another possibility with PostgreSQL if the nature of your problem is the
> kind of thing where the semantic type of point is different (retail stores,
> clinics, churches, service stations, post offices, etc) resulting in a
> different collection of attributes in each case is to use table inheritance
> (composition). Then the spatial table with the semantic type indicator is
> the base "class" and all the different types are built as extensions from
> that.
>
>
>
>> Unfortunately the index doesn't solve my problem, because in this minimal
>> setup the table is empty and I get this performance issue. This problem
>> exists with a database on my own computer, if I move the database to a
>> server (even a close one) QGIS will freeze for so much time that I have to
>> kill it.
>>
>
> Ok, so you have to get rid of the separate query for each point then.
>
> Which to me means letting PostgreSQL manage the table joins, using a view
> or using composition or just putting the attributes on your table since
> they are 1:0-1 which can be managed by null values.
>
>>
>> Thanks a lot,
>> Nuno Lopes
>>
>> On Sun, May 3, 2020 at 12:43 AM chris hermansen 
>> wrote:
>>
>>> Nuno and list
>>>
>>> On Sat, May 2, 2020 at 11:58 AM Nuno Lopes  wrote:
>>>
 Hello, I have already posted this on
 https://gis.stackexchange.com/questions/360171/adding-feature-to-postgis-layer-that-has-joins-is-really-slow
 , just posting here to see if someone else has ideas.

 I have a large project that I've been setting up to work with QGIS 3.12
 and I have now hit a problem with using "joins" to join several attribute
 tables with a geometric one.

 I have reduced the problem to a minimal setup that has only two layers
 with a one to one (or zero) relation:

  1. `point_layer` - a layer with a geometry (points) that has 64k
 entries
  2. `attribute_layer` - a layer with one text field and a foreign key
 to the `point_layer`

 On the `point_layer` I added a join to the `attribute_layer` so that we
 can edit the attributes directly in the feature form.

 After doing this whenever I try to create a point on the `point_layer`
 **it takes more than 1 min to create the feature**.

 By examining the PostgreSQL log I found out that QGIS is querying each
 feature on the `point_layer` for it's relation on the `attribute_layer`.
 These queries are made one by one, so even though I'm running the database
 on my own computer, the sheer number of queries leads to very poor
 performance.

 I've already tried tweaking the cache config on the joins, hiding the
 form on add feature and enabling the "automatically create transaction
 groups where possible" to no avail.

 I've also tested older QGIS versions 3.4 and 3.8 without success.

 Am I doing anything wrong? Is there any way to work around this?

 The schema used is:

 CREATE TABLE point_layer (
 ogc_fid integer PRIMARY KEY,
 geom public.geometry(GeometryZ,3763),
 height double precision
 );

 CREATE INDEX point_layer_geom_idx ON point_layer USING gist (geom);

 CREATE TABLE attribute_layer (
 id SERIAL PRIMARY KEY,
 fid integer REFERENCES point_layer(ogc_fid),
 some_value text
 );

 The query that is made repeatedly is (the fid changes):

 SELECT "id","some_value"::text,"fid"::text
 FROM "public"."attribute_layer"
 WHERE ("fid" = ?) LIMIT 1

 The explain analyze is (the table is empty):

   QUERY PLAN


 ---
  Limit  (cost=0.00..4.17 rows=1 width=68) (actual time=0.014..0.014
 rows=0 loops=1)
->  Seq Scan on test_relati

Re: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

2020-05-05 Thread hdienst47
Hi Richard and Karl,

Thanks for your help. The final solution to my problem is:

round( $length, 2) || ' m' || ' '

 �

Regards,

Hartmut

 �

From: Richard McDonnell  
Sent: Tuesday, May 5, 2020 11:38 AM
To: Karl Magnus Jönsson ; 
hdiens...@aol.com; qgis-user@lists.osgeo.org
Subject: RE: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

 �

Thanks Karl,

Yes that’s correct, slight typo there. For two decimal places it would be as 
you have shown, so for the Meters part of the dimension adding the number of 
decimal places will be required, but for the Centimetre, leaving the number of 
places off, rounds the value to the nearest whole number, so keeping it as 
shown would be correct. 

The corrected formula should look like below.

 �

round( $length, 2) || ' m' || ' ( ' || round(100*( $length) ) || ' cm)'

 �

 �

Regards,

 �

Richard

 �


——
Richard McDonnell MSc GIS, FME Certified Professional
FRM Data Management

——
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36 
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 1 647 6543
https://www.opw.ie

——
To send me files larger than 30MB, please use the link below 
https://filetransfer.opw.ie/filedrop/richard.mcdonn...@opw.ie

Email Disclaimer: https://www.opw.ie/en/disclaimer/ 

From: Karl Magnus Jönsson mailto:karl-magnus.jons...@kristianstad.se> > 
Sent: 05 May 2020 10:00
To: Richard McDonnell mailto:richard.mcdonn...@opw.ie> >; hdiens...@aol.com 
 ; qgis-user@lists.osgeo.org 
 
Subject: SV: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

 �

Hi!

Wouldn’t that be round($length,2) for getting two decimal places for meters?

 �

Karl-Magnus Jönsson

 �

Från: Qgis-user <  
qgis-user-boun...@lists.osgeo.org> För Richard McDonnell
Skickat: den 5 maj 2020 10:51
Till:   hdiens...@aol.com;  
 qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

 �

Hi,

In my original response, I mentioned using round(100*( $length) ) || ' cm' 
which would give you the dimensions in centimetres only.

If you want meters only then remove the 100*, which would look like this 
round($length) || ' m'

 �

Now if you want both dimensions shown, for example <-- 10.52m (1052cm) -->, 
then this can be achieved by using the following

 �

round( $length) || ' m' || ' ( ' || round(100*( $length) ) || ' cm)'

 �

Hope that helps!!

Regards,

 �

Richard


——
Richard McDonnell MSc GIS, FME Certified Professional
FRM Data Management

——
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36 
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 1 647 6543
  https://www.opw.ie

——
To send me files larger than 30MB, please use the link below  
 
https://filetransfer.opw.ie/filedrop/richard.mcdonn...@opw.ie

Email Disclaimer:   
https://www.opw.ie/en/disclaimer/ 

___
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+

2020-05-05 Thread chris hermansen
On Tue, May 5, 2020, 00:06 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.
>

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
___
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] Subject: Current status: multiple versions on Mac

2020-05-05 Thread Garth Fletcher

Chris  asked:

... One user however is on Mac (10.12.6 MacOS Sierra) ...


Peter Petrik  replied:

... if you use official installer ...


However, I believe that the official installer requires Mac OS 10.13
or higher and that those of us on Mac OS 10.12 are still restricted
to using the KyngChaos 
installers which only go up to QGIS 3.8.3

I am stuck at Mac OS 10.12.6 (and QGIS 3.8.3) but I would be delighted
if it were possible to run QGIS 3.12 !)

Thanks
--
Garth Fletcher
___
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

2020-05-05 Thread 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] Current status: multiple versions on Mac

2020-05-05 Thread Chris

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

Re: [Qgis-user] Cost effective illustrator software

2020-05-05 Thread Jeff McKenna

Hi Hamish,

I use Inkscape, very powerful and FOSS : https://inkscape.org/  Worth 
your investment in time to learn it, and you will never turn back.



-jeff



--
Jeff McKenna
MapServer Consulting and Training Services
https://gatewaygeo.com/



On 2020-05-05 11:38 a.m., Hamish Macdonald wrote:

Hi,
Is adobe illustrator a cost effective investment for enhancing my modest 
beginnings as a Qgis user? Thanks to anyone who can give me a heads up.


regards 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] Cost effective illustrator software

2020-05-05 Thread Andreas Neumann

Hi Hamish,

I find that with every new QGIS version there are fewer and fewer 
reasons to export map layouts from QGIS to any vector graphic package, 
because you can already do a lot in the QGIS  layouts. What exactly are 
you missing in the QGIS layouts that makes you think you need Adobe 
Illustrator?


If you really need a vector graphic editor alongside QGIS, I would first 
try out Inkscape, before buying a commercial vector graphic software. 
Yes, Adobe Illustrator may be more powerful than Inkscape here and there 
- but the question is - do you really need it?


Andreas

Am 05.05.20 um 16:38 schrieb Hamish Macdonald:

Hi,
Is adobe illustrator a cost effective investment for enhancing my 
modest beginnings as a Qgis user? Thanks to anyone who can give me a 
heads up.


regards 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
___
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] Cost effective illustrator software

2020-05-05 Thread Hamish Macdonald
Thanks, I'll check it out!

On Tue, 5 May 2020 at 16:41, Alexander Numann 
wrote:

> Adobe's software as a service model will cost you a lot in the long run.
> Maybe evaluate Affinity designer as an alternative - you purchase the
> license once rather than paying monthly I believe.
>
___
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] Cost effective illustrator software

2020-05-05 Thread Alexander Numann
Adobe's software as a service model will cost you a lot in the long run.
Maybe evaluate Affinity designer as an alternative - you purchase the
license once rather than paying monthly I believe.
___
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] Cost effective illustrator software

2020-05-05 Thread Hamish Macdonald
Hi,
Is adobe illustrator a cost effective investment for enhancing my modest
beginnings as a Qgis user? Thanks to anyone who can give me a heads up.

regards 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] sampling points from multipe rasters

2020-05-05 Thread Tyler Smith

Thanks Matt!

That was easy. It only took about a minute to sample 10,000 points 
from 30 layers into a single shapefile, and from there save to 
csv. I'll investigate using gpkg directly from R in future.


Best,

Tyler

Matt Boyd writes:


Hi Tyler,
the point sampling tool plugin will allow you to select multiple 
rasters to
sample from and output to the same file. It also allows you to 
save the
results in a number of different formats (geopackage, csv and 
shapefile).
If you've got access to python in your version of R then 
geopandas can read
geopackage files directly, I find that a lot more useful than 
csv.


I use this workflow. The slowest part is the point sampling 
depending on

the number and size of rasters and points.

Matt



On Tue, May 5, 2020 at 6:49 AM Tyler Smith  
wrote:



Hi,

I have 30 raster layers, and I need to sample 10,000 random 
points
from each layer (using the same set of points each time). I 
think

my options are:

1. Create a virtual raster, and sample. This has the downside 
that
the identify of the 30 layers will be replaced by generic 
'band1',

'band2' labels.

2. Sample the layers directly, using a batch process. This has 
the
downside that it appears to output to gpkg format, and creates 
30

separate files. I will need to open each of these files, export
the points they contain to csv, and then combine the into a 
single

table in R for analysis.

Is there a way to create a virtual raster that retains the 
layer

names in the stack? Alternatively, can I bulk sample multiple
rasters and have the output combined in a single table?

Thanks,

Tyler

--
Tyler Smith
plantarum.ca
___
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



--
Tyler Smith
plantarum.ca
___
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] TIN Interpolation Error

2020-05-05 Thread Maria Alicandro
HI everyone,
I have a dataset of contour lines and elevation points and I want to create
a TIN model from these dataset.
In a first moment the software crashed. So I checked the geometry of the
shapefile with the "Geometry check" and some lines were duplicate. After
eliminating the duplicate geometries, the interpolation starts but it stops
at 22%. I changed the computer machine and I tried also a old qgis version
2.18 and I had the same problem.

I made other tests:
I noted that the shapefiles contain the z and m values (POINTZM and LineZM)
I saved the dataset (export - save features as) without the z-coordinates
(see Figure) and the tin interpolation crashed again.
[image: image.png]

Finally I remove the z and m values with the tool "Drop Z/M Value" in the
processing tools.
In this way the interpolator works.

I don't understand because if I remove the z and m values with the "Drop
Z/M values" tools, the interpolator works and if I eliminate the value from
the export the interpolaor doesn't work. (Is not the same thing?)

Moreover, is it possible that the problem is the z and m values? I think
that the z-values is stored specifically for the interpolation tools or am
I wrong?
Finally, I want know if is this the right strategies or there are other
problems in the dataset, which are somehow resolved by the "Drop Z/M valus"
tools?

Does anyone have any ideas or had the same problems?

Thanks, in advance for any tips

Maria
___
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] QGIS 3.10: Dimensioning with on-board equipment

2020-05-05 Thread Richard McDonnell
Thanks Karl,
Yes that’s correct, slight typo there. For two decimal places it would be as 
you have shown, so for the Meters part of the dimension adding the number of 
decimal places will be required, but for the Centimetre, leaving the number of 
places off, rounds the value to the nearest whole number, so keeping it as 
shown would be correct.
The corrected formula should look like below.

round( $length, 2) || ' m' || ' ( ' || round(100*( $length) ) || ' cm)'

Regards,

Richard


——
Richard McDonnell MSc GIS, FME Certified Professional
FRM Data Management

——
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 1 647 6543
https://www.opw.ie

——
To send me files larger than 30MB, please use the link below 
https://filetransfer.opw.ie/filedrop/richard.mcdonn...@opw.ie

Email Disclaimer: https://www.opw.ie/en/disclaimer/
From: Karl Magnus Jönsson 
Sent: 05 May 2020 10:00
To: Richard McDonnell ; hdiens...@aol.com; 
qgis-user@lists.osgeo.org
Subject: SV: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

Hi!
Wouldn’t that be round($length,2) for getting two decimal places for meters?

Karl-Magnus Jönsson

Från: Qgis-user 
mailto:qgis-user-boun...@lists.osgeo.org>> 
För Richard McDonnell
Skickat: den 5 maj 2020 10:51
Till: hdiens...@aol.com; 
qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

Hi,
In my original response, I mentioned using round(100*( $length) ) || ' cm' 
which would give you the dimensions in centimetres only.
If you want meters only then remove the 100*, which would look like this 
round($length) || ' m'

Now if you want both dimensions shown, for example <-- 10.52m (1052cm) -->, 
then this can be achieved by using the following

round( $length) || ' m' || ' ( ' || round(100*( $length) ) || ' cm)'

Hope that helps!!
Regards,

Richard

——
Richard McDonnell MSc GIS, FME Certified Professional
FRM Data Management

——
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 1 647 6543
https://www.opw.ie

——
To send me files larger than 30MB, please use the link below 
https://filetransfer.opw.ie/filedrop/richard.mcdonn...@opw.ie

Email Disclaimer: https://www.opw.ie/en/disclaimer/

From: Qgis-user 
mailto:qgis-user-boun...@lists.osgeo.org>> 
On Behalf Of hdiens...@aol.com
Sent: 01 May 2020 17:15
To: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

Hi Richard,

As I had written to you on April 20, I have successfully implemented your 
proposal.

The only thing missing is an answer to my question:
How would I have to change the command to get a result in m.(,)cm (e.g. 10.52 m 
or 10,52 m) format?

Regards,

Hartmut

___
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] QGIS 3.10: Dimensioning with on-board equipment

2020-05-05 Thread Karl Magnus Jönsson
Hi!
Wouldn’t that be round($length,2) for getting two decimal places for meters?

Karl-Magnus Jönsson

Från: Qgis-user  För Richard McDonnell
Skickat: den 5 maj 2020 10:51
Till: hdiens...@aol.com; qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

Hi,
In my original response, I mentioned using round(100*( $length) ) || ' cm' 
which would give you the dimensions in centimetres only.
If you want meters only then remove the 100*, which would look like this 
round($length) || ' m'

Now if you want both dimensions shown, for example <-- 10.52m (1052cm) -->, 
then this can be achieved by using the following

round( $length) || ' m' || ' ( ' || round(100*( $length) ) || ' cm)'

Hope that helps!!
Regards,

Richard

——
Richard McDonnell MSc GIS, FME Certified Professional
FRM Data Management

——
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 1 647 6543
https://www.opw.ie

——
To send me files larger than 30MB, please use the link below 
https://filetransfer.opw.ie/filedrop/richard.mcdonn...@opw.ie

Email Disclaimer: https://www.opw.ie/en/disclaimer/

From: Qgis-user 
mailto:qgis-user-boun...@lists.osgeo.org>> 
On Behalf Of hdiens...@aol.com
Sent: 01 May 2020 17:15
To: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

Hi Richard,

As I had written to you on April 20, I have successfully implemented your 
proposal.

The only thing missing is an answer to my question:
How would I have to change the command to get a result in m.(,)cm (e.g. 10.52 m 
or 10,52 m) format?

Regards,

Hartmut

___
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] QGIS 3.10: Dimensioning with on-board equipment

2020-05-05 Thread Richard McDonnell
Hi,
In my original response, I mentioned using round(100*( $length) ) || ' cm' 
which would give you the dimensions in centimetres only.
If you want meters only then remove the 100*, which would look like this 
round($length) || ' m'

Now if you want both dimensions shown, for example <-- 10.52m (1052cm) -->, 
then this can be achieved by using the following

round( $length) || ' m' || ' ( ' || round(100*( $length) ) || ' cm)'

Hope that helps!!
Regards,

Richard

——
Richard McDonnell MSc GIS, FME Certified Professional
FRM Data Management

——
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 1 647 6543
https://www.opw.ie

——
To send me files larger than 30MB, please use the link below 
https://filetransfer.opw.ie/filedrop/richard.mcdonn...@opw.ie

Email Disclaimer: https://www.opw.ie/en/disclaimer/
From: Qgis-user  On Behalf Of 
hdiens...@aol.com
Sent: 01 May 2020 17:15
To: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

Hi Richard,

As I had written to you on April 20, I have successfully implemented your 
proposal.

The only thing missing is an answer to my question:
How would I have to change the command to get a result in m.(,)cm (e.g. 10.52 m 
or 10,52 m) format?

Regards,

Hartmut

___
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] MS SQL Server, multi users and QGIS v3+

2020-05-05 Thread 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