Re: [QGIS-it-user] QGIS 3.10 (v. GDAL 3) e pannello "Select Transformation"

2019-11-20 Thread Luca Bellani
Aggiornamento: ho realizzato un breve video, per farvi vedere il problema. Progetto inziale in EPSG: 4326. Carico un solo layer con EPSG: 6372, ed esce l'errore, che non trova la trasformazione tra 6372 e 4326 Stessa cosa se il progetto é in UTM 32615. NOn la trova. Devo dire, peró, che usando

[Qgis-user] Ang: Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Hernán
Hi Jose MercedesThank you very much for the detailed description of how you implemented your system. You seem to have refined and streamlined things a lot. Must be a very neat system to work with!Best regards and thanks again!Hernán Ursprungligt meddelande Ämne: Re: [Qgis-user]

Re: [Qgis-user] Installing QGIS- 3.4.x Madeira LTR for Ubuntu xenial

2019-11-20 Thread Mike Flannigan
Thanks for the advice.  I think it did not work for me: mike@mike-linuxmint:~/Documents/00MikeF$ sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-key 51F523511C7028C3 [sudo] password for mike: Executing: /tmp/apt-key-gpghome.a2sfPXpuV7/gpg.1.sh --keyserver keyserver.ubuntu.com

Re: [Qgis-user] PostGIS- erroneous query : Unable to get list of tables from DB

2019-11-20 Thread Laurence Béchet
Thanks Borys! Yes that final grant select on the table pointcloud_columns unlocks the access ... Kind regards Laurence On 21/11/2019 2:17 AM, Borys Jurgiel wrote: Thanks Boris and Jason for your messages. I tried your suggestion but it still doesn't work (new error message 'permission denied

Re: [QGIS-it-user] Problema sovrapposizione confini tratteggiati

2019-11-20 Thread Luca Bellani
Fenomenale! grazie! -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html ___ QGIS-it-user mailing list QGIS-it-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/qgis-it-user

[Qgis-user] Thrashing after toggling editing off

2019-11-20 Thread Jeff Hubbs
I'm observing this behavior under 3.4 on Linux and OS X Catalina and 3.10 on OS X Catalina. I use Field Calculator on a vector layer to create a new field with $area values. I toggle editing off hoping to save the layer with its new field and the system thrashes on one thread, about 1/3 system

Re: [Qgis-user] zoom level / magnifier on opentopomaps print composer

2019-11-20 Thread Nicolas Cadieux
Hi, Are you using a wms or online data?  Online services have a mind of their own, especially if you are trying to print to a large paper size like A0. Try changing the paper size to US letter or A4.  In the print composer, make sure you are using the 1:1 zoom (zoom to 100%) and then the

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Jose Mercedes Venegas Acevedo
Good morning What you manifest is precisely the work environment that I have assembled You can manage all the permissions to the tables and columns directly with postgres as well as the rights of users to be able to write or only see in any table Regarding backup copies, I have audit tables

Re: [Qgis-user] PostGIS- erroneous query : Unable to get list of tables from DB

2019-11-20 Thread Borys Jurgiel
Dnia środa, 20 listopada 2019 14:17:17 CET Borys Jurgiel pisze: > Usually, reinstalling gives nothing. Please wait until next week for 3.10.1 > - it contains the fix for the topology extension at least. Ah sorry, a small correction: Now I see it's only fixed in master so far. A backport to 3.10

[Qgis-user] WMS ortho-imagery load-up crashes QGIS / takes computer offline

2019-11-20 Thread MTS Ecological
I am running QGIS 3.4.9 Madeira. I'm getting a ton of crashes lately, unlike any other version before, but recently on loading WMS ortho-imagery, my internet connection is shut down entirely and I'm then then blocked from internet access unless I restart the computer. Even then - I'm blocked from

Re: [Qgis-user] Installing QGIS- 3.4.x Madeira LTR for Ubuntu xenial

2019-11-20 Thread Andre Joost
Am 20.11.19 um 11:13 schrieb Mike Flannigan: I have your exact same problem, except I tried to install QGIS 3.10 after uninstalling my QGIS 2.18. I am on Linux Mint 19.2. When I go to the directory: /usr/share/gdal I have a folder "2.2" My sources.list file located here: /etc/apt/sources.list

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Luis Franco Vázquez
By mistake I didn't answered in the thread. Here are my two cents. You should avoid opening ports in postgresql server by using ssh tunneling. My experience is that this kind of infrastructure can be slow for remote connections. Take a look to the offline editing plugin or maybe (it's only an

[Qgis-user] zoom level / magnifier on opentopomaps print composer

2019-11-20 Thread Scooter
Dear everyone, we have a problem with the zoom-level (also known as map magnifier) in the print composer. The exported png has a different zoom-level than the preview in the print composer. It is too detailed, and some lines, like railways are barely visible in the exported file. We cannot

[Qgis-user] Ang: Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Hernán
Title: Email Signature Thanks Jorge and all others for sharing your experiences, solutions and thoughts. Much appreciated!Best regards to allHernán Ursprungligt meddelande Ämne: Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?Från: Jorge

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Jorge Gustavo Rocha
Hi, This thread becoming is quite interesting :-) Let me share my experience regarding authentication. I'm using PG_SERVICES and LDAP authentication on Postgresql. No credentials are saved into the projects, so everyone opens shared projects with their own credentials. I'm also storing styles

[Qgis-user] load (custom) EPSG into QGIS from PostGIS

2019-11-20 Thread Basques, Bob (CI-StPaul)
I know, bad to cross post on more than one list. . . . But . . . Anyone ever tried to load a (custom) projection into QGIS from a PostGIS query? I’m not even sure what that might look like from the QGIS side. Just looking for ideas to automate this. We use Postgres/PostGIS quite a bit and

Re: [QGIS-it-user] Problema sovrapposizione confini tratteggiati

2019-11-20 Thread Totò
Danilo Procaccini wrote > Buongiorno a tutti, > vorrei capire se è possibile risolvere il seguente problema: > > - ho uno shp con 2 poligoni (facciamo 2 comuni) confinanti > - tematizzo entrambi come riempimento vuoto e cornice tratteggiata di > colore diverso (che sia tratteggio, linea di

[QGIS-it-user] Problema svolgimento geocoding con MMQGIS

2019-11-20 Thread Matteo Ruggieri
Buongiorno a tutti, sono uno studente universitario alle prese con Qgis (livello principiante) e non riesco a svolgere la geocodifica degli indirizzi della mia città con MMQGIS (circa 5000 indirizzi). Premetto che ho un file CSV con una colonna con riportati tutti indirizzi completi di civico,

Re: [Qgis-user] PostGIS- erroneous query : Unable to get list of tables from DB

2019-11-20 Thread Borys Jurgiel
> Thanks Boris and Jason for your messages. I tried your suggestion but it > still doesn't work (new error message 'permission denied for relation > pointcloud_columns'). So apparently you successfully fixed permissions to the topology tables and then you hit a similar problem related to the

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Andreas Neumann
Hi Luigi and Alessandro, thanks for the clarifications. Quick other question: is it correct that the id MUST be exactly 7 characters Less than or more than 7 characters won't work? At least on my system saving the config is deactivated if it is less than 7 chars. Thanks, Andreas On

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Alessandro Pasotti
On Wed, Nov 20, 2019 at 1:24 PM Andreas Neumann wrote: > Hi, > > I wonder what is best practice to handle auth configs across several users > for sharing of projects? > > Should we ask users to create the same auth-config ids/names to make > projects interoperable, where each users would have

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Luigi Pirelli
On Wed, 20 Nov 2019 at 13:24, Andreas Neumann wrote: > Hi, > > I wonder what is best practice to handle auth configs across several users > for sharing of projects? > > Should we ask users to create the same auth-config ids/names to make > projects interoperable, where each users would have

Re: [QGIS-it-user] Problema sovrapposizione confini tratteggiati

2019-11-20 Thread Giuseppe Scardino
Ciao prova il plugin mask, dovrebbe fare al caso tuo Giuseppe > Il giorno 20 nov 2019, alle ore 11:32, Danilo Procaccini > ha scritto: > >  > Buongiorno a tutti, > vorrei capire se è possibile risolvere il seguente problema: > > - ho uno shp con 2 poligoni (facciamo 2 comuni) confinanti >

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Andreas Neumann
Hi, I wonder what is best practice to handle auth configs across several users for sharing of projects? Should we ask users to create the same auth-config ids/names to make projects interoperable, where each users would have different credentials, but share the auth-config id that is stored

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Hernán De Angelis
Interesting point, Luigi. Thank you! Hernán On 2019-11-20 12:58, Luigi Pirelli wrote: this is not an issue, Postgres support many auth systems most of them paired with the authentication system implemented in QGIS. Other problem is how to share (auth.db) credentials or security setting

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Luigi Pirelli
this is not an issue, Postgres support many auth systems most of them paired with the authentication system implemented in QGIS. Other problem is how to share (auth.db) credentials or security setting among different users. Luigi Pirelli

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Hernán De Angelis
Thank you for your recommendations, Saber. Yes, indexing is important and metadata is even more so. Cheers Hernán On 2019-11-20 12:13, Saber Razmjooei wrote: Some other things to consider: - Indexing (especially spatial indexing) your vectors. - Meta-data: trying to capture meta-data as you

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Hernán De Angelis
Thank you for the recommendations, Alessandro. I take note and will have a look at PKI. The server will not run in the cloud, so no worries with Azure. Best Hernán I would recommend considering PKI for authentication, it works well on both sides (QGIS and postgres) and it gives you

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Alessandro Pasotti
On Wed, Nov 20, 2019 at 11:58 AM Hernán De Angelis wrote: > Thank you, Jan-Eric! Very good point. It is not redundant att all. > > Best > > Hernán > > > On 2019-11-20 11:47, Jan-Eric Oskarsson wrote: > > Hi Hernán! > > Maybe this comment is redundant but you have to set up a strong security > to

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Hernán De Angelis
Yes, Paolo. I understand. A lot of problems can be avoided by proper design and implementation of the workflow. Thanks you and all for your valuable input! Best Hernán On 2019-11-20 12:12, Paolo Cavallini wrote: IMHO conflicts should never arise if the workflow is properly designed: two

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Saber Razmjooei
Some other things to consider: - Indexing (especially spatial indexing) your vectors. - Meta-data: trying to capture meta-data as you go. There are some plugins available (Layer Metadata Search: which both captures and allows you to search for your meta-data...happy to help with the set up if you

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Paolo Cavallini
IMHO conflicts should never arise if the workflow is properly designed: two users should never edit the same feature at the same time. you can solve a lot of these issues with table partitioning. cheers Il 20/11/19 12:08, Hernán De Angelis ha scritto: > Hello Andreas > > Thank you very much for

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Hernán De Angelis
Hello Andreas Thank you very much for your comment. These are definitely things I did not think about. Our people are in two separate buildings (in two separate regions!) but our systems can handle this without problems. The editing conflicts seem more serious to me. I guess these could be

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Hernán De Angelis
Thank you, Jan-Eric! Very good point. It is not redundant att all. Best Hernán On 2019-11-20 11:47, Jan-Eric Oskarsson wrote: Hi Hernán! Maybe this comment is redundant but you have to set up a strong security to prevent hackers to hack your database and steal your data and cause damage. I

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Jan-Eric Oskarsson
Hi Hernán! Maybe this comment is redundant but you have to set up a strong security to prevent hackers to hack your database and steal your data and cause damage. I hope uthat you already have thought about this issu! Kind Regards Jan-Eric -Ursprungligt meddelande- Från: Qgis-user För

[QGIS-it-user] QGIS 3.10 e PROCESSING

2019-11-20 Thread Francesco
Salve, ho installato la versione 3.10 di qgis e quando provo a lanciare algoritmi di saga, ottengo la segnalazione di errore di seguito riportata. Che cosa non funziona? Uso windows 10. Saluti QGIS version: 3.10.0-A Coruña QGIS code revision: 6ffa89eb3e Qt version: 5.11.2 GDAL version: 3.0.2

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Andreas Neumann
Are those 15 people in the same office/same location or distributed? If the latter, at how many places are they distributed? In my experience, using Postgis sources over the internet (not in the LAN) is way too slow. It will only upset your users. In such a scenario you would have to set up

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Hernán De Angelis
I am evaluating setting up a server running PostgreSQL/PostGIS for use as data sharing/collaborating environment for spatial data. The user group may consist of up to 15 people, mostly using QGIS but one or two may use other software (non OS). Data is almost exclusively of vector type. The use

[QGIS-it-user] Problema sovrapposizione confini tratteggiati

2019-11-20 Thread Danilo Procaccini
Buongiorno a tutti, vorrei capire se è possibile risolvere il seguente problema: - ho uno shp con 2 poligoni (facciamo 2 comuni) confinanti - tematizzo entrambi come riempimento vuoto e cornice tratteggiata di colore diverso (che sia tratteggio, linea di evidenziazione, linea semplice) C'è un

Re: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Paolo Cavallini
Hi Hernán Il 20/11/19 11:10, Hernán De Angelis ha scritto: > Hello QGIS:ers > > I am evaluating setting up a server running PostgreSQL/PostGIS for use > as data sharing/collaborating environment for spatial data. The user > group may consist of up to 15 people, mostly using QGIS but one or two >

[Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

2019-11-20 Thread Hernán De Angelis
Hello QGIS:ers I am evaluating setting up a server running PostgreSQL/PostGIS for use as data sharing/collaborating environment for spatial data. The user group may consist of up to 15 people, mostly using QGIS but one or two may use other software (non OS). Data is almost exclusively of

Re: [Qgis-user] Installing QGIS- 3.4.x Madeira LTR for Ubuntu xenial

2019-11-20 Thread Mike Flannigan
I have your exact same problem, except I tried to install QGIS 3.10 after uninstalling my QGIS 2.18. I am on Linux Mint 19.2. When I go to the directory: /usr/share/gdal I have a folder "2.2" My sources.list file located here: /etc/apt/sources.list has this inside it: #deb cdrom:[Linux Mint