Re: [Qgis-user] Project files with local and remote connections to postgreSQL databases

[Paolo Cavallini]

Use pg_services.

Il 11 gennaio 2019 01:54:24 CET, Brent Wood  ha scritto:
>This is not tested, but I think it should work
>
>Enable host based access for local connections via the server IP
>address in your pg_hba file and use this for all QGIS access, so you
>apply the same access approach for both local & remote connections.
>
>
>Cheers
>
>Brent Wood
>
>Programme leader: Environmental Information Delivery
>NIWA
>DDI:  +64 (4) 3860529
>
>
>
>[cid:imagef6a2d5.PNG@d3805356.4e8e0b4a]
>
>
>Brent Wood
>Principal Technician - GIS and Spatial Data Management
>Programme Leader - Environmental Information Delivery
>T +64-4-386-0529
>
>National Institute of Water & Atmospheric Research Ltd (NIWA)
>301 Evans Bay Parade, Greta Point, Wellington
>Connect with NIWA: niwa.co.nz
>Facebook
>Twitter
>LinkedIn
>Instagram
>
>To ensure compliance with legal requirements and to maintain cyber
>security standards, NIWA's IT systems are subject to ongoing
>monitoring, activity logging and auditing. This monitoring and auditing
>service may be provided by third parties. Such third parties can access
>information transmitted to, processed by and stored on NIWA's IT
>systems.
>
>
>
>From: Qgis-user  on behalf of
>Laurence Béchet 
>Sent: Friday, January 11, 2019 13:04
>To: qgis-user@lists.osgeo.org
>Subject: [Qgis-user] Project files with local and remote connections to
>postgreSQL databases
>
>Hi,
>
>I am having a basic problem with my project files. I usually run qgis
>locally, where the PostgreSQL database is. However, sometimes I need to
>have these same projects run on a remote computer (where a version a
>qGIS is locally installed, but the connection to the database is
>remote). And then the project file 'doesn't work' because the expected
>connection to the database is locally not remotely, and I have not
>figured out how to modify this parameter when the project is loaded in
>qGIS. My current work around is to create a specific project for the
>remote computer.
>
>However this solution is annoying when you have plenty of composers
>that
>you lose in the process ... and playing directly in the xml project
>file
>is a bit scary ...
>Anybody would have an idea how to fix the problem?
>
>Kind regards
>Laurence Béchet
>ARK IN THE PARK Volunteer Co-Ordinator
>Cascades Ranger Station
>Falls Road, Waitakere
>Phone:  (09) 810 7014
>
>www.arkinthepark.org.nz www.forestandbird.org.nz
>
>
>
>
>___
>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

-- 
Sorry for being short___
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] Project files with local and remote connections to postgreSQL databases

[Brent Wood]

This is not tested, but I think it should work

Enable host based access for local connections via the server IP address in 
your pg_hba file and use this for all QGIS access, so you apply the same access 
approach for both local & remote connections.


Cheers

Brent Wood

Programme leader: Environmental Information Delivery
NIWA
DDI:  +64 (4) 3860529



[cid:imagef6a2d5.PNG@d3805356.4e8e0b4a]


Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
T +64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade, Greta Point, Wellington
Connect with NIWA: niwa.co.nz 
Facebook Twitter 
LinkedIn 
Instagram

To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems.



From: Qgis-user  on behalf of Laurence 
Béchet 
Sent: Friday, January 11, 2019 13:04
To: qgis-user@lists.osgeo.org
Subject: [Qgis-user] Project files with local and remote connections to 
postgreSQL databases

Hi,

I am having a basic problem with my project files. I usually run qgis
locally, where the PostgreSQL database is. However, sometimes I need to
have these same projects run on a remote computer (where a version a
qGIS is locally installed, but the connection to the database is
remote). And then the project file 'doesn't work' because the expected
connection to the database is locally not remotely, and I have not
figured out how to modify this parameter when the project is loaded in
qGIS. My current work around is to create a specific project for the
remote computer.

However this solution is annoying when you have plenty of composers that
you lose in the process ... and playing directly in the xml project file
is a bit scary ...
Anybody would have an idea how to fix the problem?

Kind regards
Laurence Béchet
ARK IN THE PARK Volunteer Co-Ordinator
Cascades Ranger Station
Falls Road, Waitakere
Phone:  (09) 810 7014

www.arkinthepark.org.nz www.forestandbird.org.nz




___
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] Project files with local and remote connections to postgreSQL databases

[Laurence Béchet]

Hi,

I am having a basic problem with my project files. I usually run qgis 
locally, where the PostgreSQL database is. However, sometimes I need to 
have these same projects run on a remote computer (where a version a 
qGIS is locally installed, but the connection to the database is 
remote). And then the project file 'doesn't work' because the expected 
connection to the database is locally not remotely, and I have not 
figured out how to modify this parameter when the project is loaded in 
qGIS. My current work around is to create a specific project for the 
remote computer.


However this solution is annoying when you have plenty of composers that 
you lose in the process ... and playing directly in the xml project file 
is a bit scary ...

Anybody would have an idea how to fix the problem?

Kind regards
Laurence Béchet
ARK IN THE PARK Volunteer Co-Ordinator
Cascades Ranger Station
Falls Road, Waitakere
Phone:  (09) 810 7014

www.arkinthepark.org.nz www.forestandbird.org.nz




___
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] How to fix 'Could not find the Qt platform plugin “Windows” in “”' when implementing qgis in custom Python3 application?

[Matt Brauer]

Thanks! That did work. I had tried modifying QT_QPA_PLATFORM_PLUGIN_PATH
earlier, but it didn't work so I didn't look back. I think at that time I
had tried it with the standalone QGIS install. That may have had a
detrimental effect, although I don't know why that would be the case.

Modifying the QT_QPA_PLATFORM_PLUGIN_PATH to point to ~\apps\Qt5\plugins
directory did the trick.

MB

On Thu, Jan 10, 2019 at 2:59 PM DT  wrote:

> Matt, I don’t know if this was specific to OSX or of it might be relevant
> to your issue on Windows, but I had to set another Qt path.  See this gist:
> https://gist.github.com/dmofot/94345126db10660053ccfb0d76a1e32a
>
> DT
>
> On Thu, Jan 10, 2019 at 4:44 PM Matt Brauer  wrote:
>
>> I am implementing qgis 3.4.3 in a custom application, but when I
>> instantiate the QgsApplication() class, I receive the error "Could not find
>> the Qt platform plugin "Windows" in "".
>>
>> I've attempted using various installs of qgis 3.x+ including the
>> standalone installer and OSGeo4W web installer. I currently am sticking
>> with the OSGeo4W web installer installation. I am using a Python 3.7
>> installation separate from what comes with OSGeo4W and attempting to
>> integrate qgis functionality.
>>
>> I have followed the instructions in the following QGIS help doc under the
>> section: "Using PyQGIS in Custom Applications"
>> https://docs.qgis.org/2.18/en/docs/pyqgis_developer_cookbook/intro.html#run-python-code-when-qgis-starts
>>
>> After attempting to run the script I realized a dll plugin was missing.
>> After some research, I found its the qwindows.dll that qt uses. The
>> qwindows.dll is included in the OSGeo4W installation under:
>> C:\OSGeo4W\apps\Qt5\plugins\platforms
>>
>> I changed the QT_PLUGIN_PATH variable on the local command prompt to
>> include the directory above, but the same error prevailed. I also changed
>> the QT_DEBUG_PLUGINS variable to 1 which printed out the locations Qt is
>> looking for plugins. Interestingly, it wasn't looking for plugins in the
>> path I specified in the QT_PLUGIN_PATH variable.
>>
>> Python Code:
>>
>> import sys#add qgis python libraries to instance python path in case not 
>> added #at the environment variable %PYTHONPATH% level
>> sys.path.extend(['C:\\OSGeo4W\\apps\\qgis\\python', 
>> 'C:\\OSGeo4W\\apps\\Python37\\Lib\\site-packages'])
>> from qgis.core import *
>> # supply path to qgis install 
>> locationQgsApplication.setPrefixPath('C:\\OSGeo4W\\apps\\qgis', True)
>> # create a reference to the QgsApplication# setting the second argument to 
>> True enables the GUI, which we need to do# since this is a custom application
>> qgs = QgsApplication([], True)
>> # load providers
>> qgs.initQgis()
>> # Write your code here to load some layers, use processing algorithms, etc.
>> # When your script is complete, call exitQgis() to remove the provider and# 
>> layer registries from memory
>> qgs.exitQgis()
>>
>> Batch File Code to Start Cmd Prompt with Proper Variables:
>>
>> @echo off
>> SET OSGEO4W_ROOT=C:\OSGeo4W::Include environment variables set by qgis on 
>> startup
>> call %OSGEO4W_ROOT%\bin\o4w_env.bat
>> call %OSGEO4W_ROOT%\bin\qt5_env.bat
>> call %OSGEO4W_ROOT%\bin\py3_env.bat@echo off
>> path %PATH%;%OSGEO4W_ROOT%\apps\qgis\bin
>> path %PATH%;C:\OSGeo4W\apps\Qt5\bin
>> path %PATH%;C:\OSGeo4W\apps\Python37\Scripts
>> path %PATH%;C:\OSGeo4W\apps\Python37
>>
>> set PYTHONPATH=%PYTHONPATH%;%OSGEO4W_ROOT%\apps\qgis\python
>> set PYTHONHOME=%OSGEO4W_ROOT%\apps\Python37
>> set 
>> QT_PLUGIN_PATH=%OSGEO4W_ROOT%\apps\Qt5\plugins;%OSGEO4W_ROOT%\apps\qgis\qtplugins
>> set QT_DEBUG_PLUGINS=1
>>
>> cmd.exe
>>
>> I expect to run the python script and receive no errors since I'm
>> pointing to the directory where the qwindows.dll missing plugin is stored.
>> However, I am still receiving the missing windows plugin error.
>>
>> Here is the actual message with QT_DEBUG_PLUGINS set to 1:
>> QFactoryLoader::QFactoryLoader() checking directory path
>> "C:/OSGeo4W/apps/qgis/qtplugins/platforms" ...
>> QFactoryLoader::QFactoryLoader() checking directory path
>> "C:/OSGeo4W/apps/Python37/platforms" ... qt.qpa.plugin: Could not find the
>> Qt platform plugin "windows" in "" This application failed to start because
>> no Qt platform plugin could be initialized. Reinstalling the application
>> may fix this problem.
>> ___
>> 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] How to fix 'Could not find the Qt platform plugin “Windows” in “”' when implementing qgis in custom Python3 application?

[DT]

Matt, I don’t know if this was specific to OSX or of it might be relevant
to your issue on Windows, but I had to set another Qt path.  See this gist:
https://gist.github.com/dmofot/94345126db10660053ccfb0d76a1e32a

DT

On Thu, Jan 10, 2019 at 4:44 PM Matt Brauer  wrote:

> I am implementing qgis 3.4.3 in a custom application, but when I
> instantiate the QgsApplication() class, I receive the error "Could not find
> the Qt platform plugin "Windows" in "".
>
> I've attempted using various installs of qgis 3.x+ including the
> standalone installer and OSGeo4W web installer. I currently am sticking
> with the OSGeo4W web installer installation. I am using a Python 3.7
> installation separate from what comes with OSGeo4W and attempting to
> integrate qgis functionality.
>
> I have followed the instructions in the following QGIS help doc under the
> section: "Using PyQGIS in Custom Applications"
> https://docs.qgis.org/2.18/en/docs/pyqgis_developer_cookbook/intro.html#run-python-code-when-qgis-starts
>
> After attempting to run the script I realized a dll plugin was missing.
> After some research, I found its the qwindows.dll that qt uses. The
> qwindows.dll is included in the OSGeo4W installation under:
> C:\OSGeo4W\apps\Qt5\plugins\platforms
>
> I changed the QT_PLUGIN_PATH variable on the local command prompt to
> include the directory above, but the same error prevailed. I also changed
> the QT_DEBUG_PLUGINS variable to 1 which printed out the locations Qt is
> looking for plugins. Interestingly, it wasn't looking for plugins in the
> path I specified in the QT_PLUGIN_PATH variable.
>
> Python Code:
>
> import sys#add qgis python libraries to instance python path in case not 
> added #at the environment variable %PYTHONPATH% level
> sys.path.extend(['C:\\OSGeo4W\\apps\\qgis\\python', 
> 'C:\\OSGeo4W\\apps\\Python37\\Lib\\site-packages'])
> from qgis.core import *
> # supply path to qgis install 
> locationQgsApplication.setPrefixPath('C:\\OSGeo4W\\apps\\qgis', True)
> # create a reference to the QgsApplication# setting the second argument to 
> True enables the GUI, which we need to do# since this is a custom application
> qgs = QgsApplication([], True)
> # load providers
> qgs.initQgis()
> # Write your code here to load some layers, use processing algorithms, etc.
> # When your script is complete, call exitQgis() to remove the provider and# 
> layer registries from memory
> qgs.exitQgis()
>
> Batch File Code to Start Cmd Prompt with Proper Variables:
>
> @echo off
> SET OSGEO4W_ROOT=C:\OSGeo4W::Include environment variables set by qgis on 
> startup
> call %OSGEO4W_ROOT%\bin\o4w_env.bat
> call %OSGEO4W_ROOT%\bin\qt5_env.bat
> call %OSGEO4W_ROOT%\bin\py3_env.bat@echo off
> path %PATH%;%OSGEO4W_ROOT%\apps\qgis\bin
> path %PATH%;C:\OSGeo4W\apps\Qt5\bin
> path %PATH%;C:\OSGeo4W\apps\Python37\Scripts
> path %PATH%;C:\OSGeo4W\apps\Python37
>
> set PYTHONPATH=%PYTHONPATH%;%OSGEO4W_ROOT%\apps\qgis\python
> set PYTHONHOME=%OSGEO4W_ROOT%\apps\Python37
> set 
> QT_PLUGIN_PATH=%OSGEO4W_ROOT%\apps\Qt5\plugins;%OSGEO4W_ROOT%\apps\qgis\qtplugins
> set QT_DEBUG_PLUGINS=1
>
> cmd.exe
>
> I expect to run the python script and receive no errors since I'm pointing
> to the directory where the qwindows.dll missing plugin is stored. However,
> I am still receiving the missing windows plugin error.
>
> Here is the actual message with QT_DEBUG_PLUGINS set to 1:
> QFactoryLoader::QFactoryLoader() checking directory path
> "C:/OSGeo4W/apps/qgis/qtplugins/platforms" ...
> QFactoryLoader::QFactoryLoader() checking directory path
> "C:/OSGeo4W/apps/Python37/platforms" ... qt.qpa.plugin: Could not find the
> Qt platform plugin "windows" in "" This application failed to start because
> no Qt platform plugin could be initialized. Reinstalling the application
> may fix this problem.
> ___
> 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] How to fix 'Could not find the Qt platform plugin “Windows” in “”' when implementing qgis in custom Python3 application?

[Matt Brauer]

I am implementing qgis 3.4.3 in a custom application, but when I
instantiate the QgsApplication() class, I receive the error "Could not find
the Qt platform plugin "Windows" in "".

I've attempted using various installs of qgis 3.x+ including the standalone
installer and OSGeo4W web installer. I currently am sticking with the
OSGeo4W web installer installation. I am using a Python 3.7 installation
separate from what comes with OSGeo4W and attempting to integrate qgis
functionality.

I have followed the instructions in the following QGIS help doc under the
section: "Using PyQGIS in Custom Applications"
https://docs.qgis.org/2.18/en/docs/pyqgis_developer_cookbook/intro.html#run-python-code-when-qgis-starts

After attempting to run the script I realized a dll plugin was missing.
After some research, I found its the qwindows.dll that qt uses. The
qwindows.dll is included in the OSGeo4W installation under:
C:\OSGeo4W\apps\Qt5\plugins\platforms

I changed the QT_PLUGIN_PATH variable on the local command prompt to
include the directory above, but the same error prevailed. I also changed
the QT_DEBUG_PLUGINS variable to 1 which printed out the locations Qt is
looking for plugins. Interestingly, it wasn't looking for plugins in the
path I specified in the QT_PLUGIN_PATH variable.

Python Code:

import sys#add qgis python libraries to instance python path in case
not added #at the environment variable %PYTHONPATH% level
sys.path.extend(['C:\\OSGeo4W\\apps\\qgis\\python',
'C:\\OSGeo4W\\apps\\Python37\\Lib\\site-packages'])
from qgis.core import *
# supply path to qgis install
locationQgsApplication.setPrefixPath('C:\\OSGeo4W\\apps\\qgis', True)
# create a reference to the QgsApplication# setting the second
argument to True enables the GUI, which we need to do# since this is a
custom application
qgs = QgsApplication([], True)
# load providers
qgs.initQgis()
# Write your code here to load some layers, use processing algorithms, etc.
# When your script is complete, call exitQgis() to remove the provider
and# layer registries from memory
qgs.exitQgis()

Batch File Code to Start Cmd Prompt with Proper Variables:

@echo off
SET OSGEO4W_ROOT=C:\OSGeo4W::Include environment variables set by qgis
on startup
call %OSGEO4W_ROOT%\bin\o4w_env.bat
call %OSGEO4W_ROOT%\bin\qt5_env.bat
call %OSGEO4W_ROOT%\bin\py3_env.bat@echo off
path %PATH%;%OSGEO4W_ROOT%\apps\qgis\bin
path %PATH%;C:\OSGeo4W\apps\Qt5\bin
path %PATH%;C:\OSGeo4W\apps\Python37\Scripts
path %PATH%;C:\OSGeo4W\apps\Python37

set PYTHONPATH=%PYTHONPATH%;%OSGEO4W_ROOT%\apps\qgis\python
set PYTHONHOME=%OSGEO4W_ROOT%\apps\Python37
set 
QT_PLUGIN_PATH=%OSGEO4W_ROOT%\apps\Qt5\plugins;%OSGEO4W_ROOT%\apps\qgis\qtplugins
set QT_DEBUG_PLUGINS=1

cmd.exe

I expect to run the python script and receive no errors since I'm pointing
to the directory where the qwindows.dll missing plugin is stored. However,
I am still receiving the missing windows plugin error.

Here is the actual message with QT_DEBUG_PLUGINS set to 1:
QFactoryLoader::QFactoryLoader() checking directory path
"C:/OSGeo4W/apps/qgis/qtplugins/platforms" ...
QFactoryLoader::QFactoryLoader() checking directory path
"C:/OSGeo4W/apps/Python37/platforms" ... qt.qpa.plugin: Could not find the
Qt platform plugin "windows" in "" This application failed to start because
no Qt platform plugin could be initialized. Reinstalling the application
may fix this problem.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[QGIS-it-user] Errore al caricare il file di progetto

[Luca Bellani]

Ho un grosso problema: ho lasciato il pc con windows 10 acceso per circa 3
ore senza usarlo, con il progetto QGIS 2.18.26 aperto.l
Quando sono tornato al pc lo schermo era nero e, non riuscendo a dialogare
con il pc, l'ho riavviato. Ora, il progetto non ri apre piú, e si presenta
un errore. mi da opzione di caricare il file "copia" ma l'errore persiste.
Ho provato anche co QGIS 3.4 ma nulla.
Ci puó essere una forma di oter recuperare il progetto? Mai successo in vari
anni di utilizzo..
Grazie a tutti

 



--
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] QGIS 3 - Postgres Authentication Issue

[Ungerboeck, Erhard]

Hello,

we are using QGIS  with a Postgres database where each different user (in total 
about 20 ) each have their own login credentials. Since we changed from QGIS 
2.18 to QGIS 3 when opening a project QGIS always asks for the login data 
twice. I didn't change anything in the database / server. This is rather 
annoying, any ideas how I can change that or can find further information / 
help?

Best regards,
Erhard


___
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.4.3 on debian testing

[Micha Silver]

  
  
Thanks Nicklas and Richard for reminding me of the options. 

With the next point release in a week, I'll just wait a bit...


On 10/01/2019 11:40, Richard
  Duivenvoorde wrote:


  On 1/10/19 10:09 AM, Nicklas Avén wrote:


  
There is a note on the download page of Qgis saying this is expected and
that there is 4 ways to handle it. I choose to revert to nightly-build
repos.

https://qgis.org/en/site/forusers/alldownloads.html#debian-ubuntu

  
  
Ah, duh, pretty clear :-)

Sorry for my noise then.

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

-- 
Ben Gurion Univ
Sde Boker
+972-523-665918
  

___
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] Selecting a part of an attribute

[johnrobot]

Ah, much better, works perfectly. Thanks!



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Selecting a part of an attribute

[Stefan Giese]

you can better use this expression:  array_get(string_to_array( 
"Koordinater" ),0)  for the first coordinate


Mit freundlichen Grüßen
Stefan Giese
Projektleiter/Consultant

FOSS Academy Kompaktkurs "Winterschule 2019"
Grundwissen zum Aufbau von Geodateninfrastrukturen mit Open-Source-Software
https://foss-academy.com/kompaktkurse

WhereGroup GmbH & Co. KG
Schwimmbadstr. 2
79100 Freiburg
Germany

Fon: +49 (0)761 / 519 102 - 61
Fax: +49 (0)761 / 519 102 - 11

stefan.gi...@wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
---
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
---

Am 10.01.2019 um 10:59 schrieb johnrobot:

Hi
I have an attribute (named "Koordinater") with coordinate pairs, such as
"6417192.227, 326926.702", and I would like to exctract the two coordinates
into separate attributes. Using the field calculator seems to be the way to
do this, for example:

left( "Koordinater",  strpos( "Koordinater" , ','))

When I runt this in the field calculator from the attribute table, I get
"6417192.227", but when I run the field calculator in Processing with the
same configuration, I get "6417192.227,". Note the extra "," at the end. Am
I missing something or could this be a bug? I use QGIS 3.4.3, 64 bit, on
Windows 10.

Regards,

Magnus



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

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

[Qgis-user] Selecting a part of an attribute

[johnrobot]

Hi
I have an attribute (named "Koordinater") with coordinate pairs, such as
"6417192.227, 326926.702", and I would like to exctract the two coordinates
into separate attributes. Using the field calculator seems to be the way to
do this, for example:

left( "Koordinater",  strpos( "Koordinater" , ','))

When I runt this in the field calculator from the attribute table, I get
"6417192.227", but when I run the field calculator in Processing with the
same configuration, I get "6417192.227,". Note the extra "," at the end. Am
I missing something or could this be a bug? I use QGIS 3.4.3, 64 bit, on
Windows 10.

Regards,

Magnus



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 3.4.3 on debian testing

[Richard Duivenvoorde]

On 1/10/19 10:09 AM, Nicklas Avén wrote:

> There is a note on the download page of Qgis saying this is expected and
> that there is 4 ways to handle it. I choose to revert to nightly-build
> repos.
> 
> https://qgis.org/en/site/forusers/alldownloads.html#debian-ubuntu

Ah, duh, pretty clear :-)

Sorry for my noise then.

Richard
___
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.4.3 on debian testing

[Nicklas Avén]

Hi


I had the exactly same problem some days ago.


There is a note on the download page of Qgis saying this is expected and 
that there is 4 ways to handle it. I choose to revert to nightly-build 
repos.


https://qgis.org/en/site/forusers/alldownloads.html#debian-ubuntu


/Nicklas


On 1/10/19 10:05 AM, Micha Silver wrote:


I had QGIS 3.4.1 running on a debian testing machine. A few weeks ago 
a routine apt-get update  removed QGIS due to a missing dependency: 
qtbase-abi. (See https://issues.qgis.org/issues/19641).


To get back QGIS, I removed the qgis.org repository, and reverted back 
to 2.18.17 from the regular debian repository.



Does anyone know when updated qt packages will be available, so that 
QGIS 3.4.x will be installable on debian buster?



Thanks,

--
Ben Gurion Univ
Sde Boker
+972-523-665918

___
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 3.4.3 on debian testing

[Richard Duivenvoorde]

On 1/10/19 10:05 AM, Micha Silver wrote:
> I had QGIS 3.4.1 running on a debian testing machine. A few weeks ago a
> routine apt-get update  removed QGIS due to a missing dependency:
> qtbase-abi. (See https://issues.qgis.org/issues/19641).
> 
> To get back QGIS, I removed the qgis.org repository, and reverted back
> to 2.18.17 from the regular debian repository.
> 
> Does anyone know when updated qt packages will be available, so that
> QGIS 3.4.x will be installable on debian buster?

Hi Micha/Juergen,

I'm on Buster, and compile 2.18, 3.4 regularly and master almost daily.

I don't know the packaging details, but is qtbase-abi (still?) a
necessary dependency or is it maybe possible to remove it?

@Micha happy to sent you some lines to compile it and install it in your
home dir, after the first steps it is pretty easy to do. You can have a
daily fresh backed master version then :-)

Regards,

Richard Duivenvoorde


___
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 3.4.3 on debian testing

[Micha Silver]

  
  
I had QGIS 3.4.1 running on a debian testing machine. A few weeks
  ago a routine apt-get update  removed QGIS due to a
  missing dependency: qtbase-abi. (See
  https://issues.qgis.org/issues/19641). 

To get back QGIS, I removed the qgis.org repository, and reverted
  back to 2.18.17 from the regular debian repository.


Does anyone know when updated qt packages will be available, so
  that QGIS 3.4.x will be installable on debian buster?


Thanks,

-- 
Ben Gurion Univ
Sde Boker
+972-523-665918
  

___
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 Web Client 2 plugin?

[Luca Manganelli]

Hi, is there any plugin to convert qgis projects to qgis web client 2?



-- 
Luca Manganelli
Assistente informatico
Servizio Innovazione e Sistemi digitali
Via Ezio Maccani 148
38121 Trento (TN)
___
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] resolved QGIS 3 - Deactivate "boxes" around labels

[Anna Hujber]

Dear Nyall,

thanks for the fast and easy help. There was no "draw label candidates" 
option in that tab u described (named "Automated Placement Engine") but 
I clicked on "Restore Defaults" which deactivated an option called "show 
candidates (for debugging)" and resolved my problem. Maybe the "draw 
label candidates" option has been renamed?


Thanks again,

Anna

On 10.01.19 09:19, Nyall Dawson wrote:



On Thu., 10 Jan. 2019, 18:13 Anna Hujber  wrote:


Hey community,

I use 3.4.3-Madeira on a Ubuntu 18.04.1 LTS.

I was modifying labels on a map when several rectangles appeared
around and next to the labels. I ignored them first cuz I was busy
working on making a label appear again I had hidden before and
thought the display of boxes belonged to one of the labeling tools
I was working with. When I had arranged my issue, I intended to
deactivate the rectangles that had appeared around all labels of
all layers, assuming that I had somehow somewhere clicked on a
special view option. However, until now I was not able to figure
out what those boxes are, how I had made them appear in first
place and how to get rid of them again.

They also show up in the print layout and on the exported pdf.
When I click on "new map view", though, they are not shown in the
new view. Deactivating labels and reactivating them did not change
anything. Moreover, it is something that applies to all layers, so
modifying a specific layer's label options should not bring any
solution.

From the label setting for one of your layers, look for the little 
button in the top right which has a blue/yellow four arrow symbol. 
Click that, and then uncheck "draw label candidates"


Nyall

Thank you,

Anna

___
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 3 - Deactivate "boxes" around labels

[Nyall Dawson]

On Thu., 10 Jan. 2019, 18:13 Anna Hujber  Hey community,
>
> I use 3.4.3-Madeira on a Ubuntu 18.04.1 LTS.
>
> I was modifying labels on a map when several rectangles appeared around
> and next to the labels. I ignored them first cuz I was busy working on
> making a label appear again I had hidden before and thought the display of
> boxes belonged to one of the labeling tools I was working with. When I had
> arranged my issue, I intended to deactivate the rectangles that had
> appeared around all labels of all layers, assuming that I had somehow
> somewhere clicked on a special view option. However, until now I was not
> able to figure out what those boxes are, how I had made them appear in
> first place and how to get rid of them again.
>
> They also show up in the print layout and on the exported pdf. When I
> click on "new map view", though, they are not shown in the new view.
> Deactivating labels and reactivating them did not change anything.
> Moreover, it is something that applies to all layers, so modifying a
> specific layer's label options should not bring any solution.
>
>From the label setting for one of your layers, look for the little button
in the top right which has a blue/yellow four arrow symbol. Click that, and
then uncheck "draw label candidates"

Nyall

Thank you,
>
> Anna
>
> ___
> 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] QGIS 3 - Deactivate "boxes" around labels

[Anna Hujber]

Hey community,

I use 3.4.3-Madeira on a Ubuntu 18.04.1 LTS.

I was modifying labels on a map when several rectangles appeared around 
and next to the labels. I ignored them first cuz I was busy working on 
making a label appear again I had hidden before and thought the display 
of boxes belonged to one of the labeling tools I was working with. When 
I had arranged my issue, I intended to deactivate the rectangles that 
had appeared around all labels of all layers, assuming that I had 
somehow somewhere clicked on a special view option. However, until now I 
was not able to figure out what those boxes are, how I had made them 
appear in first place and how to get rid of them again.


They also show up in the print layout and on the exported pdf. When I 
click on "new map view", though, they are not shown in the new view. 
Deactivating labels and reactivating them did not change anything. 
Moreover, it is something that applies to all layers, so modifying a 
specific layer's label options should not bring any solution.


Thank you,

Anna

___
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