[Qgis-user] QGIS 3.6.0 & Building PostgreSQL/PostGIS SQLs as Layers fails

[Max Pyziur]

Greetings,

Earlier, I had an issue using QGIS 2.7.15 on Fedora 29. It failed to load 
PyQGIS, and therefore there was no access to DB Manager to build SQLs to 
add new layers to my maps.


My workaround appeared to be to install QGIS 3.6.0-Noosa from copr, a 
non-Fedora repository.


On startup, QGIS reports no errors, and DB Manager is available.

When building a SQL using DB Manager, hitting execute, the data appears in 
the appropriate window. However, once clicking "Load As Layer" the layer 
does not appear.


To try an alternative,
Layer -> Add Layer -> Add PostGIS Layer
and then clicking on a table representing a shapefile 
(shapefile.us_rivers)

the layer appers.

Furthermore, I can right-click on the layer name in the window and am able 
to update the SQL Query and get appropriate results.


Any advice in offering a remedy allowing me to use the DB Manager directly 
would be greatly appreciated.


An example of a query that I would like to load:
SELECT gid, name AS division, st_transform(geom, 2163) AS geom FROM 
"shapefiles"."census_divisions"


Much thanks,

Max Pyziur
p...@brama.com

___
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] Anyone noticed odd network behaviour while QGIS is loaded?

[Nyall Dawson]

Hey all,

I came across this thread recently
https://www.reddit.com/r/krita/comments/9xea9b/this_is_gonna_sound_crazy_but_is_krita/
, where someone reports that having Krita open was causing their wifi
connection to regularly drop out.

Long story short, it looks like this is caused by default network
scanning behaviour in the Qt library, so in theory QGIS should also be
affected by this. The typical symptom is that network ping latencies
will jump every 10 seconds while a Qt app is running.

I personally couldn't reproduce this, but the issue seems so
widespread (google for "QT_BEARER_POLL_TIMEOUT") that I'd be surprised
if QGIS wasn't affected too.

So my questions are:

1. Has anyone noticed this?
2. Should we just go ahead and apply the workaround which other Qt
applications are doing and set the environment variable
QT_BEARER_POLL_TIMEOUT=-1 by default? The side effect of this change
is that Qt's network polling would be completely disabled, so e.g.
changing from wifi to wireless while a QGIS session is open could
result in that session being unable to connect to the network
(requiring a QGIS restart)

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 error & F29

[Max Pyziur]

Greetings,

My use of QGis Desktop is occassional; when I do use it, I construct layers 
using PostGIS & PostgreSQL.


The key component that facilitates this in QGis is a Python plugin called DB 
Manager.


When I started Qgis today, there was an error message that appeared something 
like this:


Couldn't load PyQGIS. Python support will be disabled.


Traceback (most recent call last):
  File "", line 1, in
  File "/usr/lib64/python2.7/site-packages/qgis/gui/__init__.py", line 27, in
from qgis._gui import *
RuntimeError: the PyQt4.QtCore module failed to register with the sip module


Python version:
2.7.15 (default, Oct 15 2018, 15:26:09)
[GCC 8.2.1 20180801 (Red Hat 8.2.1-2)]

QGIS version:
2.18.20 'Las Palmas', exported

After clicking away the error away, the existing layers that I had built using 
PostGIS/PostgreSQL were still available in my key critical project.


However, when I went to look for DB Manager, it wasn't available.

After some searching, I upgraded to QGIS 3.6 from a non-Fedora repository (the 
guidance is here: 
https://stackoverflow.com/questions/53716778/the-pyqt4-qtcore-module-failed-to-register-with-the-sip-module)


and now I have access to the DB Manager functionality.

Is the Fedora/QGis community aware of this issue?

Thanks!

Max Pyziur
p...@brama.com
___
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] drop shadow blur radius limit

[Saulteau Don]

I was trying to apply a drop shadow to a polygon using the "draw effects"
in the symbology tab but noticed the blur radius has a hard coded limit of
16.

The map i'm producing is fairly large (60"x60") and needed a higher value
like 30-40 to make it appear nice and noticeable when exported and printed.

Is this a bug or by design?

FYI: Font/Labels can have a higher value than 16.

Running QGIS 3.6.0 on Arch Linux 5.0.0 64-bit.




Donovan (saultdon)
___
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] Connecting QGIS to MSSQL Server on Linux

[Baker, Matthew]

Hi all,

Has anyone successfully connected QGIS to MS SQL Server on Linux?

We've been struggling with this for years.

I was finally able to connect Python to MSSQL via pypyodbc using mssql-tools 
and unixodbc-dev.

Additionally, DB clients like DataGrip and DBeaver have made it very easy to 
connect to MSSQL with the additional download of the necessary drivers.

I'm wondering if there is an environment variable that should be set somewhere 
to point to the same drivers that pypyodbc is using?

There are several threads on GIS.SE, but so far no solution.

Thank you!

-Matt Baker / Denver Public Schools
___
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] layer order

[Andreas Neumann]

Hi Carl, 

Glad it did the trick ;-) 


Yes - this option is kind of "hidden". But I also wonder how it got
enabled? 

Andreas 


On 2019-03-11 17:29, Boswell, Carl A - (cboswell) wrote:





Very nice. Thanks for the input.  Don't know how that box got checked, but deselecting it did the trick.  Not sure how one would track that issue down without help, but I'll certainly remember it. 

Cheers, 

C 

Carl Boswell 

520-954-7053 

FROM: Andreas Neumann  
SENT: Monday, March 11, 2019 12:46 AM

TO: Boswell, Carl A - (cboswell) 
CC: qgis-user@lists.osgeo.org
SUBJECT: Re: [Qgis-user] layer order 

Hi Carl, 

It might be - that by accident - you enabled the overwriting of the layer order. There is a separate "Layer Order Panel" that might be visible or not. It has a checkbox with which you can toggle which panel has preference: the "Layers" or the "Layer Order" panel. 

Reasoning behind this separation: In some more complex projects it might be desirable to structure layers into groups (hierarchically) by topics while this might contradict the actual layer order (which is a flat list). Usually, you want to first draw all polygon layers, then line layers on top, followed by points. This might not match the grouping defined in the Layers panel. 

So go to "View" --> "Panels" --> "Layer Order" and see if you enabled the "Control rendering order" checkbox. If yes, deactivate and your layers should be ordered like defined in the "Layers" panel. 

Hope this helps, 

Greetings, 

Andreas 


On 2019-03-11 04:02, Boswell, Carl A - (cboswell) wrote:

Up until now the layers listed were displayed in the map in a hierarchy defined by their position in the list, i.e. the one above in the list would overwrite the symbols of one below when the coordinates were the same.  All of a sudden the order seems to be by date, meaning that layers that were added earlier overtake precedence over those added later, regardless of their order in the list.  I can find no "switch" that can change this problem.  This seems to apply whether the layer is a vector file or imported from a .csv file.  Any help would be appreciated. 

Thanks, 

C 

Carl Boswell 

520-954-7053 


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




Links:
--
[1] 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] Mask Plugin

[Michael Jabot]

I apologize for bothering the list but I am struggling using the Mask
Plugin.

I am using 3.6.0 and the mask plugin does not  seem to enable. I would like
to use the mask plugin to clip a basemap to a data frame

I have tried uninstalling and reinstalling but my issue persists

Thank you in advance for any ideas and help that anyone can offer.

Mike Jabot

*
Michael Jabot, Ph.D.
Professor, Science Education
US Partner - *GLOBE Program*

*NASA Earth Ambassador*Director, *Institute for Research in Science
Teaching*
The State University of New York at Fredonia



716.320-0189 (Google Voice)
ja...@fredonia.edu
E250 Thompson Hall
280 Central Avenue
Fredonia, NY  14063
*
___
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] corrupt layer management with spatilite source

[Andrea Giraldi]

When I open a project created by someone else, sometime in the corrupted
layer management pop-up window I found a list of spatialite vectors with
absolute paths addressing to the position in the computer of who passed me
the project. This happen even if the project is setted with relative path.
The problem is that the browse button in the pop up windows is freezed and
I'm supposed to write the new paths by hand.
What am I doing wrong?
Thank you
Andrea
___
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] Error saving/exporting data with many attributes

[b.j.kobben]

To answer my own question: the problem is actually not the amount of 
attributes, but the fact that there are (2x) attributes columns with the same 
name (although they are different if you consider case sensitivity). Apparently 
GeoJSON is the only format that allows differentiating column names by 
upper/lowercase

yours,

--
Barend Köbben


On 11/03/2019, 11:55, "Qgis-user on behalf of 
b.j.kob...@utwente.nl" 
mailto:qgis-user-boun...@lists.osgeo.org> on 
behalf of b.j.kob...@utwente.nl> wrote:

Hi all,

I have a problem that (I think) comes down to a limit in the amount of 
attributes per object the QGIS exporting tools can handle.  Case in hand:

1) Import OSM data Points with many attributes (OSM tags), using QuickOSM – 
works

2) Temporary layer in QGIS is displayed -  seems fine

3) "Make Permanent" or "Export As..." fails on all file formats (except 
GeoJSON!). Error message is (for the GeoPackage case):

Export to vector file failed.
Error: Feature write errors:
Feature creation error (OGR error: sqlite3_exec(CREATE TABLE "test" ( "fid" 
INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "geom" POINT, "full_id" TEXT(255), 
"osm_id" TEXT(255), "osm_type" TEXT(255), "highway" TEXT(255),

... many more attributes...

"safe_place:school" TEXT(255), "safe_place:mosque" TEXT(255))) failed: 
duplicate column name: Operational_status)

Feature creation error (OGR error: failed to prepare SQL: INSERT INTO "test" ( 
"geom", "full_id", "osm_id", "osm_type", "highway", "name",

... again the same many more attributes...

"safe_place:school", "safe_place:mosque") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))

This happens even when I have only 2 features (see attached test file). The 
workaraound is to use GeoJSON, bacuse for some reason that one works, but in 
normal case I have 1000s of points instead of two, and then a GeoJSON file 
becomes very large and unwieldy...

Any ideas if this is a bug or a limit in the actual formats such as 
GeoPackage...?
yours,

--
Barend Köbben
Senior Lecturer – ITC-University of Twente & ATLAS
PO Box 217, 7500 AE Enschede (Netherlands)
ITC Building (room 1-065)
@barendkobben
+31-(0)53 4874 253






___
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] Error saving/exporting data with many attributes

[b.j.kobben]

Hi all,

I have a problem that (I think) comes down to a limit in the amount of 
attributes per object the QGIS exporting tools can handle.  Case in hand:

1) Import OSM data Points with many attributes (OSM tags), using QuickOSM – 
works

2) Temporary layer in QGIS is displayed -  seems fine

3) "Make Permanent" or "Export As..." fails on all file formats (except 
GeoJSON!). Error message is (for the GeoPackage case):

Export to vector file failed.
Error: Feature write errors:
Feature creation error (OGR error: sqlite3_exec(CREATE TABLE "test" ( "fid" 
INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "geom" POINT, "full_id" TEXT(255), 
"osm_id" TEXT(255), "osm_type" TEXT(255), "highway" TEXT(255),

... many more attributes...

"safe_place:school" TEXT(255), "safe_place:mosque" TEXT(255))) failed: 
duplicate column name: Operational_status)

Feature creation error (OGR error: failed to prepare SQL: INSERT INTO "test" ( 
"geom", "full_id", "osm_id", "osm_type", "highway", "name",

... again the same many more attributes...

"safe_place:school", "safe_place:mosque") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))

This happens even when I have only 2 features (see attached test file). The 
workaraound is to use GeoJSON, bacuse for some reason that one works, but in 
normal case I have 1000s of points instead of two, and then a GeoJSON file 
becomes very large and unwieldy...

Any ideas if this is a bug or a limit in the actual formats such as 
GeoPackage...?
yours,

--
Barend Köbben
Senior Lecturer – ITC-University of Twente & ATLAS
PO Box 217, 7500 AE Enschede (Netherlands)
ITC Building (room 1-065)
@barendkobben
+31-(0)53 4874 253








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

Re: [QGIS-it-user] Installate plugin off-line in QGIS 3.x

[Paolo Cavallini]

Ciao.

On 11/03/19 10:57, Marco Guiducci wrote:

> questo è un fatto comune alle moderne interfacce che a me, personalmente
> crea ansia.
...
> Scusate lo sfogo. Un bel ritorno al passato, almeno nell'interfaccia,
> farebbe di me un uomo felice :-)

al passato non si torna. bisogna migliorare il futuro. apri una
discussione in qgis-dev per i problemi più generali, apri tickets per i
problemi specifici.
vedrai che i problemi si risolvono, e l'ansia passa.
saluti.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] Installate plugin off-line in QGIS 3.x

[Marco Guiducci]

Il 09/03/2019 14:27, Paolo Cavallini ha scritto:

Il 2019-03-09 14:08 Marco Spaziani ha scritto:


P.S. Ancora una volta QGIS 3 mi ha dimostrato che ha solo cose in più
e non in meno di QGIS 2, basta scoprirle e impararle. Ad esempio,
pochi giorni fa sono impazzito per più di un ora nel Compositore di
stampe per cercare di girare un foglio A4 da orientamento verticale ad
orientamento orizzontale ...non potete capire che giro ingarbugliato
che ho fatto ...sono andato a finire fino alle proprietà della
"stampante preferita" cercando di operare da li  ...poi, per caso, ho
cliccato con il tasto destro del mouse sul foglio e, magicamente, mi
è comparso il pannello per il settaggio del foglio, compreso
l'orientamento, consentendomi di fare in un millesimo di secondo
quello che, agendo a casaccio, stavo provando a fare invano da un'ora


sì, se ne parlava propio ieri, questo menu è introvabile per molti, 
probabilmente modificheremo l'opzione.

a proposito, la 2.18 è ufficialmente morta:



questo è un fatto comune alle moderne interfacce che a me, personalmente 
crea ansia.
Tornassero i buoni vecchi pulsanti, stile "clicca qui", invece di aree 
sensibili (spesso o sempre è lo stesso testo il bottone ma senza il 
contorno del bottone) che devono essere scoperte passando con il mouse, 
neanche fosse uno di quei giochi di avventura dentro il castello nei 
quali bisognava "assaggiare" tutti gli oggetti per capire cosa fossero 
per poi magari prenderli ed utilizzarli per aprire una porta, un 
cassetto, a sua volta da scoprire.
Ma QGis non è un gioco e le interfacce grafiche devono mostrare, non 
nascondere, le funzioni.
Stesso dicasi di quando bisogna portare una finestra in foreground: ho 
il timore di cliccare perché ormai ogni area è sensibile. Ritornassero i 
bordi delle finestre, belli, spessi e facile da individuare. (win10 da 
questo punto di vista è micidiale: il bordo c'è ma sfumato, pensi di 
cliccare sulla finestra sotto perché la vedi, invece è la finestra 
sopra; per ridimensionare la finestra il cursore lo devi posizionare 
"fuori", in realtà sul bordo appena percettible; cosa da mandare fuori 
di testa).
E che dire poi dei toni di grigio, per esempio sulle barre di 
scorrimento: non dico di tornare al bianco e nero, ma insomma un pochino 
più di contrasto!). E' tutto un tono di grigio, differenti al massimo di 
un paio di tacche :-(
Scusate lo sfogo. Un bel ritorno al passato, almeno nell'interfaccia, 
farebbe di me un uomo felice :-)

marco

--
Marco Guiducci - 055 4383194
SITA - Sistema informativo territoriale e ambientale
Regione Toscana - Via di Novoli 26 - 50127 Firenze

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

Re: [Qgis-user] layer order

[Andreas Neumann]

Hi Carl, 


It might be - that by accident - you enabled the overwriting of the
layer order. There is a separate "Layer Order Panel" that might be
visible or not. It has a checkbox with which you can toggle which panel
has preference: the "Layers" or the "Layer Order" panel. 


Reasoning behind this separation: In some more complex projects it might
be desirable to structure layers into groups (hierarchically) by topics
while this might contradict the actual layer order (which is a flat
list). Usually, you want to first draw all polygon layers, then line
layers on top, followed by points. This might not match the grouping
defined in the Layers panel. 


So go to "View" --> "Panels" --> "Layer Order" and see if you enabled
the "Control rendering order" checkbox. If yes, deactivate and your
layers should be ordered like defined in the "Layers" panel. 

Hope this helps, 

Greetings, 

Andreas 


On 2019-03-11 04:02, Boswell, Carl A - (cboswell) wrote:





Up until now the layers listed were displayed in the map in a hierarchy defined by their position in the list, i.e. the one above in the list would overwrite the symbols of one below when the coordinates were the same.  All of a sudden the order seems to be by date, meaning that layers that were added earlier overtake precedence over those added later, regardless of their order in the list.  I can find no "switch" that can change this problem.  This seems to apply whether the layer is a vector file or imported from a .csv file.  Any help would be appreciated. 

Thanks, 
C 

Carl Boswell 
520-954-7053 


___
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