Re: [Qgis-user] Qgis-user Digest, Vol 157, Issue 20

2019-03-12 Per discussione rjwillson

 Original message From: qgis-user-requ...@lists.osgeo.org Date: 
2019-03-10  13:00  (GMT-06:00) To: qgis-user@lists.osgeo.org Subject: Qgis-user 
Digest, Vol 157, Issue 20 Send Qgis-user mailing list submissions to
qgis-user@lists.osgeo.orgTo subscribe or unsubscribe via the World Wide Web, 
visit  https://lists.osgeo.org/mailman/listinfo/qgis-useror, via email, 
send a message with subject or body 'help' to  
qgis-user-request@lists.osgeo.orgYou can reach the person managing the list at  
qgis-user-owner@lists.osgeo.orgWhen replying, please edit your Subject line so 
it is more specificthan "Re: Contents of Qgis-user digest..."Today's Topics:   
1. Re: Couldn't load plugin - QGIS 3.6 on Mac 10.14.3  (William 
Kyngesburye)   2. Problem exporting layer to GeoPkg (qgis-u...@stripfamily.net) 
  3. Re: Couldn't load plugin - QGIS 3.6 on Mac 10.14.3  (Saber Razmjooei)  
 4. Re: Couldn't load plugin - QGIS 3.6 on Mac 10.14.3 (kspencer)   5. Re: 
Couldn't load plugin - QGIS 3.6 on Mac 10.14.3  (William Kyngesburye)   6. 
Re: Couldn't load plugin - QGIS 3.6 on Mac 10.14.3 
(kspencer)--Message:
 1Date: Sat, 9 Mar 2019 17:22:55 -0600From: William Kyngesburye 
To: kspencer Cc: 
qgis-user@lists.osgeo.orgSubject: Re: [Qgis-user] Couldn't load plugin - QGIS 
3.6 on Mac   10.14.3Message-ID: 
Content-Type: text/plain; 
charset="utf-8"Oh bugger.  I'm uploading a new installer, it should be on the 
QGIS download page tomorrow.> On Mar 9, 2019, at 12:56 PM, kspencer 
 wrote:> > Hello folks,> > I'm a QGIS newb trying to 
install QGIS on my Mac.  Any help would be greatly> appreciated. Got this error 
when trying to run QGIS for the first time:> > Couldn't load plugin 
'processing' > > ImportError:> 
dlopen(/Library/Frameworks/SQLite3.framework/Versions/E/Python/3.6/sqlite3/_sqlite3.cpython-36m-darwin.so,>
 2): Library not loaded:> 
/Library/Frameworks/SQLite3.framework/Versions/D/SQLite3   Referenced from:> 
/Library/Frameworks/SQLite3.framework/Versions/E/Python/3.6/sqlite3/_sqlite3.cpython-36m-darwin.so
  > Reason: image not found > Traceback (most recent call last):>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/qgis/utils.py",> 
line 309, in loadPlugin>    __import__(packageName)>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/qgis/utils.py",> 
line 672, in _import>    mod = _builtin_import(name, globals, locals, fromlist, 
level)>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/plugins/processing/__init__.py",>
 line 29, in >    from processing.tools.general import *  # NOQA>  
File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/qgis/utils.py",> 
line 672, in _import>    mod = _builtin_import(name, globals, locals, fromlist, 
level)>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/plugins/processing/tools/general.py",>
 line 39, in >    from processing.core.Processing import Processing>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/qgis/utils.py",> 
line 672, in _import>    mod = _builtin_import(name, globals, locals, fromlist, 
level)>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/plugins/processing/core/Processing.py",>
 line 58, in >    from processing.algs.qgis.QgisAlgorithmProvider import> 
QgisAlgorithmProvider  # NOQA>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/qgis/utils.py",> 
line 672, in _import>    mod = _builtin_import(name, globals, locals, fromlist, 
level)>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/plugins/processing/algs/qgis/QgisAlgorithmProvider.py",>
 line 83, in >    from .ImportIntoSpatialite import ImportIntoSpatialite>  
File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/qgis/utils.py",> 
line 672, in _import>    mod = _builtin_import(name, globals, locals, fromlist, 
level)>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/plugins/processing/algs/qgis/ImportIntoSpatialite.py",>
 line 42, in >    from processing.tools import spatialite>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/qgis/utils.py",> 
line 672, in _import>    mod = _builtin_import(name, globals, locals, fromlist, 
level)>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/plugins/processing/tools/spatialite.py",>
 line 29, in >    import sqlite3 as sqlite>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/qgis/utils.py",> 
line 672, in _import>    mod = _builtin_import(name, globals, locals, fromlist, 
level)>  File> 
"/Library/Frameworks/SQLite3.framework/Versions/E/Python/3.6/sqlite3/__init__.py",>
 line 23, in >    from sqlite3.dbapi2 import *>  File> 
"/Applications/QGIS3.6.app/Contents/MacOS/../Resources/python/qgis/utils.py",> 
line 672, in _import>    mod = _builtin_import(name, globals, locals, 

Re: [Qgis-user] Proportional Symbols Bug in 3.2?

2019-03-12 Per discussione Nicolas Cadieux

Hi,

Not sure, try creating a new field with another format and use the field 
calculator to copy the data (this could change the data so please don't 
destroy your old fields). I would try with a Int32 or UInt32.


Nicolas

On 2019-03-12 1:39 p.m., Aj Hollenbach wrote:

Hi Nicolas,

I looked at the dataset and the "total served" by the water utility is 
indeed in an Integer format. Any other ideas on what might be 
preventing the use of proportional symbols? Perhaps this is bug with 
this version of QGIS?


Thanks Much,
Allen

image.png

On Mon, Feb 11, 2019 at 12:58 PM Nicolas Cadieux 
mailto:nicolas.cadi...@archeotec.ca>> 
wrote:


Perhaps your size field is stored in a text format and not a float
or int format...
Look at your” Layer properties, information, Fields.”

Le 11 févr. 2019 à 12:39, Aj Hollenbach mailto:ajhollenb...@gmail.com>> a écrit :


Hi QGIS User Community!

I am attempting to represent water utilities (points) using
*graduated symbols* (by size), and would like the symbols to be
*proportional* to the number of customers. I thought that this
could be done be done under the symbology dialogue box by
selecting "graduated" and then "size" for the method while also
using the "*data-defined size legend*" option under the
"advanced" sub-menu. However, whenever I click on the "advanced"
button and then select "data-defined size legend", I receive an
error message that "*data-defined size is not enabled*". Is this
a bug in version 3.2, or am I doing something incorrectly?
Alternatively, is there another approach creating proportional
symbols by size for point data?

Thanks Much,
Allen
___
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 minimum hardware requirements

2019-03-12 Per discussione Nicolas Cadieux

 * Hi again,
 *

 * If I was shopping for a laptop, this would be my personal feelings
   about this (excluding the fact that I would never again, buy a
   Laptop for GIS!).  If your not shopping for a new laptop, get more
   memory and a SSD drive if you think your laptop is slow.
 *

 * 1) Speed of CPU and how many cores.
 * CPU speed is not really a problem anymore.  Having more cores is
   better.  An i7 normally has more core than the I5...  AMD will also
   put more cores but they are individually slower than Intel's.  I
   would aim for at least 4 real physical cores (so 8 in total). 
   Currently, screen rendering is done in threads but not much more.  A
   new OpenCL option is there (but I can't get it to work on Windows). 
   This will be worked out soon I imagine and I think more and more
   algorithms will start using it.  OpenCL can run on CPUs but will
   shine on video cards (GPU)

2) How much disk space is needed for installation.
-About 5GB

3) Size of Hard Disk and swap space.

-The biggest SSD you can buy.  I would take a laptop that has a m.2 slot 
based on PCIe (and not based on a m.2 SATA slot).  If not, a regular 
SATA SSD drive would be next and hybrid drives the last option.  Patrick 
has a good point on SSDs.  Having the possibility to use an Intel Optane 
m.2 drive could be nice if you have a free m.2 PCIe slot and a SATA 
based SSD.


 *


 * 4) Minimum RAM memory.
 * -I would get 16GB now with condition I can upgrade to 32 or 64GB for
   future proofing.
 *

 * 5) Display and screen resolution and lastly.
 * All displays will probably work.  My 10 year old laptop has 1366 x
   768 and this works. That would probably only come with a lower end
   laptop today. You can most likely get a 1920x1080 or better.  Make
   sure you have a digital or usb-c (with video) plug to be able to use
   a second or third bigger screen.

6) Graphics memory.

I have only recently needed to update an nvidia GTX260 in my rig.  That 
had only 896MB of memory and it only gave me trouble with LiDAR clouds 
(not in QGIS). The video card choice will depend on your budget.  I you 
had a very big budget, professional laptops for CAD will come with pro 
card like Radeon Pro, or nvidia Quadro. An alternative would be to look 
at Gaming laptops.  Video cards are geared towards gaming but will come 
with more dedicated memory.  Then, I would look at AMD based laptops 
with Ryzen mobile processors with Vega Graphics, then a computer with a 
dedicated nvidia card and on the bottom of the pile, an Intel processor 
with integrated Intel graphics and shared memory or and Intel with a 
integrated Vega (rumored). (Current affordable desktop video cards come 
with 6 to 8GB of memory)  4GB is probably good in a laptop.  The reality 
is that the graphic card will probably only become really handy when 
OpenCL will become used more in QGIS.  Since CUDA (NVIDIA) development 
does not seem in the cards, and ATI-AMD would probably be a better 
choice as AMD support the latest version of OpenCL but not nvidia.  For 
all those reasons, (and with a hand on my wallet), my gut reaction would 
be to look at the Ryzen-Vega combos first.  Others will disagree (and 
please do).


That's my gut feeling for now.

Nicolas


On 2019-03-12 12:32 p.m., Patrick Dunford wrote:


It will depend very much on the size and content of your projects. 
Vector layers are very efficient in resource usage. If you happen to 
use raster layers, the software dedicates a lot of resources to 
caching them, so that is where insufficient memory or swap may become 
an issue.


If you do work with large projects, adding a 100 GB or larger SSD 
purely for swap purposes is a lot cheaper than 32 GB of system RAM and 
not a great deal slower.


On 11/03/19 3:46 PM, Nicolas Cadieux wrote:

Hi,

Someone will come up with a more intelligent answer than me but I 
have been running QGIS with a 10 year old dual core laptop with 
Windows 7-64 and 4Go of memory.  I find that the actual limits are 
mostly imposed by the data and the project complexity rather than the 
software.   An SSD did save the laptop from the garbage bin!


For anything serious, I use a desktop computer that would make most 
gamers cry with envy...


Nicolas

Le 10 mars 2019 à 17:19, Irene Vicatos > a écrit :



Dear all,

I am currently working with the QGIS version 2.18 Las Palmas but I 
will soon switch to the latest 3.4 LTR version.


I have been reading through the question blog in order to figure out 
which are the minimum hardware requirements for the latest version. 
All previous given answers are already outdated. More specifically, 
I would like to know, since I am a laptop owner, what are the 
following minimum requirements:


  * 1) Speed of CPU and how many cores.

2) How much disk space is needed for installation.

3) Size of Hard Disk and swap space.

 *


  * 4) Minimum RAM memory.
 *

  * 5) Display and screen resolution and lastly.

6) Graphics memory.


Re: [QGIS-it-user] Traduzione QGIS 3

2019-03-12 Per discussione Stefano Campus
Già corretto

Il mar 12 mar 2019, 18:28 Marco  ha scritto:

> In merito a questa discussione:
>
> http://osgeo-org.1560.x6.nabble.com/Traduzione-QGIS-nomi-geo-algoritmi-td5398066.html
> sono d'accordissimo con il suggerimento di Totò Fiandaca (mi sono imbattuto
> in questo algoritmo qualche settimana fa  ho pensato anch'io che forse
> andava definito diversamente).
>
>
>
> --
> Sent from:
> http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
> ___
> QGIS-it-user mailing list
> QGIS-it-user@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/qgis-it-user
>
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user


Re: [QGIS-it-user] Traduzione QGIS nomi geo-algoritmi

2019-03-12 Per discussione Totò
skampus wrote
> grazie mille.
> 
> s.
> 
> ps: per evitare di aprire nuovi thread, nel caso di segnalazioni come
> questa, suggerisco di utilizzare la discussione esistente "Traduzione QGIS
> 3", così abbiamo tutto nella stesso thread e non perdo/perdiamo il filo.
> grazie mille

Ops, scusa non ricordavo più.

Per fortuna Marco ha creato collegamento.

grazie, saluti



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


Re: [Qgis-user] Proportional Symbols Bug in 3.2?

2019-03-12 Per discussione Aj Hollenbach
Hi Nicolas,

I looked at the dataset and the "total served" by the water utility is
indeed in an Integer format. Any other ideas on what might be preventing
the use of proportional symbols? Perhaps this is bug with this version of
QGIS?

Thanks Much,
Allen

[image: image.png]

On Mon, Feb 11, 2019 at 12:58 PM Nicolas Cadieux <
nicolas.cadi...@archeotec.ca> wrote:

> Perhaps your size field is stored in a text format and not a float or int
> format...
> Look at your” Layer properties, information, Fields.”
>
> Le 11 févr. 2019 à 12:39, Aj Hollenbach  a écrit :
>
> Hi QGIS User Community!
>
> I am attempting to represent water utilities (points) using *graduated
> symbols* (by size), and would like the symbols to be *proportional* to
> the number of customers. I thought that this could be done be done under
> the symbology dialogue box by selecting "graduated" and then "size" for the
> method while also using the "*data-defined size legend*" option under the
> "advanced" sub-menu. However, whenever I click on the "advanced" button and
> then select "data-defined size legend", I receive an error message that 
> "*data-defined
> size is not enabled*". Is this a bug in version 3.2, or am I doing
> something incorrectly? Alternatively, is there another approach creating
> proportional symbols by size for point data?
>
> Thanks Much,
> Allen
>
> ___
> 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-it-user] Traduzione QGIS nomi geo-algoritmi

2019-03-12 Per discussione skampus
grazie mille.

s.

ps: per evitare di aprire nuovi thread, nel caso di segnalazioni come
questa, suggerisco di utilizzare la discussione esistente "Traduzione QGIS
3", così abbiamo tutto nella stesso thread e non perdo/perdiamo il filo.
grazie mille



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


[QGIS-it-user] Traduzione QGIS nomi geo-algoritmi

2019-03-12 Per discussione Totò
Negli strumenti di processing, gruppo Analisi Vettore ci sono due algoritmi:

1. Distanza dal nodo più vicino (da linea a nodo)
[distancetonearesthublinetohub]
2. Distanza dal nodo più vicino (punti) [distancetonearesthubpoints]

 

Questi due algoritmi generano stessa tabella attributi come output, ma
diversa geometria, nel primo caso la geometria è linestring (genera un
segmento), nel secondo caso è point (genera un punto);

Quindi secondo me va cambiato la descrizione tra parentesi tonde,
suggerisco:

1. Distanza dal nodo più vicino (genera linee)
2. Distanza dal nodo più vicino (genera punti)

saluti



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


Re: [Qgis-user] Qgis minimum hardware requirements

2019-03-12 Per discussione Patrick Dunford
It will depend very much on the size and content of your projects. 
Vector layers are very efficient in resource usage. If you happen to use 
raster layers, the software dedicates a lot of resources to caching 
them, so that is where insufficient memory or swap may become an issue.


If you do work with large projects, adding a 100 GB or larger SSD purely 
for swap purposes is a lot cheaper than 32 GB of system RAM and not a 
great deal slower.


On 11/03/19 3:46 PM, Nicolas Cadieux wrote:

Hi,

Someone will come up with a more intelligent answer than me but I have 
been running QGIS with a 10 year old dual core laptop with Windows 
7-64 and 4Go of memory.  I find that the actual limits are mostly 
imposed by the data and the project complexity rather than the 
software.   An SSD did save the laptop from the garbage bin!


For anything serious, I use a desktop computer that would make most 
gamers cry with envy...


Nicolas

Le 10 mars 2019 à 17:19, Irene Vicatos > a écrit :



Dear all,

I am currently working with the QGIS version 2.18 Las Palmas but I 
will soon switch to the latest 3.4 LTR version.


I have been reading through the question blog in order to figure out 
which are the minimum hardware requirements for the latest version. 
All previous given answers are already outdated. More specifically, I 
would like to know, since I am a laptop owner, what are the following 
minimum requirements:


  * 1) Speed of CPU and how many cores.

2) How much disk space is needed for installation.

3) Size of Hard Disk and swap space.

 *


  * 4) Minimum RAM memory.
 *

  * 5) Display and screen resolution and lastly.

6) Graphics memory.

Many thanks in advance and looking forward to your answer.

Irene Vikatou

 *


 *






___
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] corrupt layer management with spatilite source

2019-03-12 Per discussione Patrick Dunford
The same message will be thrown if the system has hit the limit of open 
file handles. It lists an absolute path which is incomprehensible (just 
as it is in your situation) but normally I never see that except with 
hundreds of layers, so unless your system is running out of resources, 
that might not be applicable to you.


On 13/03/19 1:01 AM, Andrea Giraldi wrote:

Like 20...

Date: Tue, 12 Mar 2019 23:39:48 +1300
From: Patrick Dunford mailto:enzedrailm...@gmail.com>>
To: qgis-user ML mailto:qgis-user@lists.osgeo.org>>
Subject: Re: [Qgis-user] corrupt layer management with spatilite
        source
Message-ID: mailto:b4659135-4758-2511-99e6-9fa11f0dc...@gmail.com>>
Content-Type: text/plain; charset="utf-8"; Format="flowed"

How many layers does the project have in total?

On 12/03/19 3:33 AM, Andrea Giraldi wrote:
> 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
___
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

2019-03-12 Per discussione b.j.kobben
Thanks for the info Patrick. I totally agree this is unwise, but the OSM 
(OpenStreetMap) dataset I am working with unfortunately comes with some of 
these (unwisely chosen) attribute tags :-(
So indeed inconsistency in how that 's handled is annoying. In defence of QGIS 
programmers, I think it's because the different import/export formats have 
different rules and defaults...

yours,
--
Barend Köbben


On 12/03/2019, 11:45, "Qgis-user on behalf of Patrick Dunford" 
mailto:qgis-user-boun...@lists.osgeo.org> on 
behalf of enzedrailm...@gmail.com> wrote:


Case sensitive names (from experience) are handled inconsistently within the 
Qgis software. It would be unwise to have two different columns where the names 
are only distinguished by case, unless the developers choose to address these 
issues in future.
On 12/03/19 12:20 AM, b.j.kob...@utwente.nl wrote:
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 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 error & F29

2019-03-12 Per discussione Max Pyziur

To add ... (see below)

On Tue, 12 Mar 2019, Max Pyziur wrote:


On Tue, 12 Mar 2019, DelazJ wrote:


Hi,

Le mar. 12 mars 2019 à 14:55, Max Pyziur  a écrit :
  On Tue, 12 Mar 2019, Richard Duivenvoorde wrote:

  > Ah...
  >
  > Now I see 2.7 
  > That is very old, please upgrade to the one available via
  > https://qgis.org/en/site/forusers/alldownloads.html#fedora

  Much thanks for your replies.

  I've done this, but this has led to another issue. Either it's a bug 
or

  I'm not executing something correctly (clicking checkboxes etc.

  If I go Database -> DB Manager
  Establish a connection to my postgresql/postgis database

  F2 to open the SQL editing window, type:
  SELECT * FROM "shapefiles"."us_states" WHERE state = 'Texas'

  Hit Execute, Load As layer


At this point, the dialog expands new options in which you may need to 
indicate the PK and the geometry fields.

And then press on "Load" to have layer and features in the application.

Are these options not visible? Or do you simply skip these steps in your 
feedback?


I do all of these things:
insert a SQL statement:
SELECT * FROM "shapefiles"."us_states"

Click "Execute"

The results appear

Click "Load As New Layer"
Check "Column(s) with unique values"
Click "Retrieve Values"
Add a layer name in the appropriate window
Click "Load"

And nothing shows up.

But if I go to the Layer -> Add Layer -> Add postgis layers

It loads appropriately from a table containing shapefile data.



I can then edit the SQL foundation of that layer, something like
SELECT * FROM "shapefiles"."us_states"

adding
SELECT * FROM "shapefiles"."us_states" WHERE state = 'Texas'

and the results are reflected.

I've been using QGIS since 2012, and this is a first for me.


When I add a PostGIS layer using the menus, and then edit the SQL, the Tab 
in the SQL editing window is labelled "Layer"


When I try to build a Layer from the SQL editing window, execute the SQL, 
then do all of the other clicks, including "Load As Layer" the tab 
continues to be labelled "Query(TheNameOfTheDatabase)"


Thank you,

Max



Max



Harrissou

  Nothing appears in either the Layers pane or the main window.

  However, if I go
  Layer -> Add Layer -> Add PostGIS Layers

  and then select a table built upon a shapefile

  the map loads.

  I can then edit the SQL for that layer by right-clicking on the layer 
in

  the layer pane, Update sql, and my modifications are reflected in the
  layer.

  How do I get DB Manager to add a layer?

  Much thanks,

  Max Pyziur


  > Regards,
  >
  > Richard Duivenvoorde
  >
  >
  > On 12/03/2019 07.08, Richard Duivenvoorde wrote:
  >> Hi Max,
  >>
  >> The error means that the python-cpp bridge is not working because 
wrong

  >> paths to (python) libs.
  >> Are you maybe in a Python Virtual Environment at that moment, 
which in

  >> that case screws up your python path?
  >>
  >> Or else: did you miss some QGIS-Python package (if installed via 
package

  >> manager)?
  >>
  >> Regards,
  >>
  >> Richard Duivenvoorde
  >>
  >> On 11/03/2019 23.15, Max Pyziur wrote:
  >>>
  >>>
  >>> 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?
  >>>
  

Re: [Qgis-user] QGIS error & F29

2019-03-12 Per discussione Max Pyziur

On Tue, 12 Mar 2019, DelazJ wrote:


Hi,

Le mar. 12 mars 2019 à 14:55, Max Pyziur  a écrit :
  On Tue, 12 Mar 2019, Richard Duivenvoorde wrote:

  > Ah...
  >
  > Now I see 2.7 
  > That is very old, please upgrade to the one available via
  > https://qgis.org/en/site/forusers/alldownloads.html#fedora

  Much thanks for your replies.

  I've done this, but this has led to another issue. Either it's a bug or
  I'm not executing something correctly (clicking checkboxes etc.

  If I go Database -> DB Manager
  Establish a connection to my postgresql/postgis database

  F2 to open the SQL editing window, type:
  SELECT * FROM "shapefiles"."us_states" WHERE state = 'Texas'

  Hit Execute, Load As layer


At this point, the dialog expands new options in which you may need to indicate 
the PK and the geometry fields.
And then press on "Load" to have layer and features in the application.

Are these options not visible? Or do you simply skip these steps in your 
feedback?


I do all of these things:
insert a SQL statement:
SELECT * FROM "shapefiles"."us_states"

Click "Execute"

The results appear

Click "Load As New Layer"
Check "Column(s) with unique values"
Click "Retrieve Values"
Add a layer name in the appropriate window
Click "Load"

And nothing shows up.

But if I go to the Layer -> Add Layer -> Add postgis layers

It loads appropriately from a table containing shapefile data.



I can then edit the SQL foundation of that layer, something like
SELECT * FROM "shapefiles"."us_states"

adding
SELECT * FROM "shapefiles"."us_states" WHERE state = 'Texas'

and the results are 
reflected.


I've been using QGIS since 2012, and this is a first for me.

Max



Harrissou

  Nothing appears in either the Layers pane or the main window.

  However, if I go
  Layer -> Add Layer -> Add PostGIS Layers

  and then select a table built upon a shapefile

  the map loads.

  I can then edit the SQL for that layer by right-clicking on the layer in
  the layer pane, Update sql, and my modifications are reflected in the
  layer.

  How do I get DB Manager to add a layer?

  Much thanks,

  Max Pyziur


  > Regards,
  >
  > Richard Duivenvoorde
  >
  >
  > On 12/03/2019 07.08, Richard Duivenvoorde wrote:
  >> Hi Max,
  >>
  >> The error means that the python-cpp bridge is not working because wrong
  >> paths to (python) libs.
  >> Are you maybe in a Python Virtual Environment at that moment, which in
  >> that case screws up your python path?
  >>
  >> Or else: did you miss some QGIS-Python package (if installed via 
package
  >> manager)?
  >>
  >> Regards,
  >>
  >> Richard Duivenvoorde
  >>
  >> On 11/03/2019 23.15, Max Pyziur wrote:
  >>>
  >>>
  >>> 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 

Re: [Qgis-user] QGIS error & F29

2019-03-12 Per discussione DelazJ
Hi,

Le mar. 12 mars 2019 à 14:55, Max Pyziur  a écrit :

> On Tue, 12 Mar 2019, Richard Duivenvoorde wrote:
>
> > Ah...
> >
> > Now I see 2.7 
> > That is very old, please upgrade to the one available via
> > https://qgis.org/en/site/forusers/alldownloads.html#fedora
>
> Much thanks for your replies.
>
> I've done this, but this has led to another issue. Either it's a bug or
> I'm not executing something correctly (clicking checkboxes etc.
>
> If I go Database -> DB Manager
> Establish a connection to my postgresql/postgis database
>
> F2 to open the SQL editing window, type:
> SELECT * FROM "shapefiles"."us_states" WHERE state = 'Texas'
>
> Hit Execute, Load As layer
>

At this point, the dialog expands new options in which you may need to
indicate the PK and the geometry fields.
And then press on "Load" to have layer and features in the application.

Are these options not visible? Or do you simply skip these steps in your
feedback?

Harrissou

>
> Nothing appears in either the Layers pane or the main window.
>
> However, if I go
> Layer -> Add Layer -> Add PostGIS Layers
>
> and then select a table built upon a shapefile
>
> the map loads.
>
> I can then edit the SQL for that layer by right-clicking on the layer in
> the layer pane, Update sql, and my modifications are reflected in the
> layer.
>
> How do I get DB Manager to add a layer?
>
> Much thanks,
>
> Max Pyziur
>
>
> > Regards,
> >
> > Richard Duivenvoorde
> >
> >
> > On 12/03/2019 07.08, Richard Duivenvoorde wrote:
> >> Hi Max,
> >>
> >> The error means that the python-cpp bridge is not working because wrong
> >> paths to (python) libs.
> >> Are you maybe in a Python Virtual Environment at that moment, which in
> >> that case screws up your python path?
> >>
> >> Or else: did you miss some QGIS-Python package (if installed via package
> >> manager)?
> >>
> >> Regards,
> >>
> >> Richard Duivenvoorde
> >>
> >> On 11/03/2019 23.15, Max Pyziur wrote:
> >>>
> >>>
> >>> 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 mailing list
> >> Qgis-user@lists.osgeo.org
> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >>
> >
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-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 error & F29

2019-03-12 Per discussione Max Pyziur

On Tue, 12 Mar 2019, Richard Duivenvoorde wrote:


Ah...

Now I see 2.7 
That is very old, please upgrade to the one available via
https://qgis.org/en/site/forusers/alldownloads.html#fedora


Much thanks for your replies.

I've done this, but this has led to another issue. Either it's a bug or 
I'm not executing something correctly (clicking checkboxes etc.


If I go Database -> DB Manager
Establish a connection to my postgresql/postgis database

F2 to open the SQL editing window, type:
SELECT * FROM "shapefiles"."us_states" WHERE state = 'Texas'

Hit Execute, Load As layer

Nothing appears in either the Layers pane or the main window.

However, if I go
Layer -> Add Layer -> Add PostGIS Layers

and then select a table built upon a shapefile

the map loads.

I can then edit the SQL for that layer by right-clicking on the layer in 
the layer pane, Update sql, and my modifications are reflected in the 
layer.


How do I get DB Manager to add a layer?

Much thanks,

Max Pyziur



Regards,

Richard Duivenvoorde


On 12/03/2019 07.08, Richard Duivenvoorde wrote:

Hi Max,

The error means that the python-cpp bridge is not working because wrong
paths to (python) libs.
Are you maybe in a Python Virtual Environment at that moment, which in
that case screws up your python path?

Or else: did you miss some QGIS-Python package (if installed via package
manager)?

Regards,

Richard Duivenvoorde

On 11/03/2019 23.15, Max Pyziur wrote:



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 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] [Qgis-psc] User question of the month

2019-03-12 Per discussione DelazJ
Hi Anita,

Le sam. 9 mars 2019 à 18:37, Anita Graser  a écrit :

> Dear users,
>
> The answers to the user question of February have now been analyzed. In
> total, we received 84 replies to the questionnaire. One submission was
> counted as a duplicate. Cases where all three fields were set to the same
> plugin have been only counted once. The plugins with more than three
> mentions are:
>

I'm a bit disappointed by the number of replies. I'd have expected more
answers (everybody uses plugins, right?)

For the next question of the month, I'd be interesetd in something
regarding the docs and its usage. Some rough ideas to polish for the survey:
1- What is your first source of information on QGIS features: SE, QGIS
lists/user groups, local forum, QGIS doc, web browser, social network,
others... (to sort by frequency of usage) - Here I mean when they want to
learn something not hear about something
2- If/When you use QGIS doc, does it answer your needs? Yes, no, i don't
use (or we can graduate: always, often, rarely, never(?)...)
3- How often do you use the QGIS Doc?
4- Suggestions for improvements or other comments... (on what they miss or
think docs should be/do)

Now that we are releasing the 3.4 docs, it should be fair to know whether
people do refer to the docs, use them and get feedbacks (critics or
expectations for the next round).

Regards,
Harrissou

>
>1. QuickMapServices 33
>2. qgis2web 13
>3. OpenLayers_Plugin 8
>4. Group_Stats 7
>5. Digitizing_Tools 6
>6. mmqgis 6
>7. Profile_tool 6
>8. Another_DXF_Importer_DXF2Shape 5
>9. Lat_Lon_Tools 5
>10. Qgis2threejs 5
>11. Spreadsheet_Layers 5
>12. Value_Tool 5
>13. Data_Plotly 4
>14. go2streetview 4
>15. ImportPhotos 4
>16. Mask 4
>17. TimeManager 4
>18. TUFLOW 4
>
> Among these top listed plugins, the following ones are not currently
> featured
>
>- OpenLayers_Plugin (has been marked as experimental due to known
>issues)
>- Group_Stats
>- Digitizing_Tools
>- mmqgis (has no version for QGIS 3 yet)
>- Profile_tool
>- Another_DXF_Importer_DXF2Shape
>- Spreadsheet_Layers
>- Value_Tool
>- go2streetview
>- ImportPhotos
>- TUFLOW
>
> If you don't know these plugins yet, they might be worth checking out.
>
> So far, we haven't settled on a new user question yet. If you have an idea
> for a question that would be interesting to ask, please let me know.
>
> Regards,
> Anita
>
>
>
> On Tue, Feb 5, 2019 at 8:27 PM Anita Graser  wrote:
>
>> Dear users,
>>
>> The answers to the user question of January have now been published:
>> http://blog.qgis.org/2019/02/05/user-question-of-the-month-feb19-answers-from-jan/
>>
>>
>> Based on these results, during yesterday's PSC meeting, we've been
>> discussing potential strategies to better inform users about all the
>> different options for contributing to QGIS. So thanks to everyone who
>> provided feedback!
>>
>> We also have a new question for February: Which plugins should be listed
>> as "featured" on the official plugin repository?
>> https://ee.kobotoolbox.org/x/#bpH2ouJG
>>
>> The form is available in a variety of languages thanks to Carlos Rivas
>> for providing the platform and all the volunteers who helped with
>> translations.
>>
>> Regards,
>> Anita
>>
>> ___
> 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] Python Scripts (Boolean) in QGIS 3

2019-03-12 Per discussione Herbert Lincon
Thanks Stefan,

I´ll take a look and try some new scripts


De: Stefan Giese (WhereGroup) 
Enviado: terça-feira, 12 de março de 2019 10:05
Para: Herbert Lincon
Cc: qgis-user@lists.osgeo.org
Assunto: Re: [Qgis-user] Python Scripts (Boolean) in QGIS 3

Hi Herbert,
with processing scripts ist has defintitly changed a lot. The thing is,
that in QGIS 2.18 it was python but mixed with some none python, like
the parameter with the double pound sign...like ##my_parameter=boolean

so a good starting point is the blog from Anita Graser, since the
documetation on qgis.org isn't that actual at the moment:
https://anitagraser.com/2018/03/25/processing-script-template-for-qgis3/

you can also start with the template directly in QGIS selecting "New
script from template.." in the processing toolbox top, where the python
icon is...

Hope this helps a bit
Stefan

---
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 2019-03-12 13:48, schrieb Herbert Lincon:
> Hello everyone,
>
>  I have a script in QGIS 2.18 to receive the information from 4
> boolean options as simple as that
>
>  ##formula_1=boolean
>
> ##formula_2=boolean
>
> ##formula_3=boolean
>
> ##formula_4=boolean
>
> ##result=output string
>
> if formula_1 == True:
>
> result= 1
>
> elif formula_2 == True:
>
> result= 2
>
> elif formula_3 == True:
>
> result= 3
>
> elif formula_4 == True:
>
> result= 4
>
> else:
>  result= 5
>
>  the problem is, this type of script doesn´t work in QGIS 3, and I´m
> a newbie in Python,
>  could someone translate that to the new method?
>
>  it´ll help me even begin to understand python 3
>
>  Thanks
>  Herbert Lincon
> ___
> 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] Python Scripts (Boolean) in QGIS 3

2019-03-12 Per discussione Stefan Giese (WhereGroup)

Hi Herbert,
with processing scripts ist has defintitly changed a lot. The thing is, 
that in QGIS 2.18 it was python but mixed with some none python, like 
the parameter with the double pound sign...like ##my_parameter=boolean


so a good starting point is the blog from Anita Graser, since the 
documetation on qgis.org isn't that actual at the moment: 
https://anitagraser.com/2018/03/25/processing-script-template-for-qgis3/


you can also start with the template directly in QGIS selecting "New 
script from template.." in the processing toolbox top, where the python 
icon is...


Hope this helps a bit
Stefan

---
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 2019-03-12 13:48, schrieb Herbert Lincon:

Hello everyone,

 I have a script in QGIS 2.18 to receive the information from 4
boolean options as simple as that

 ##formula_1=boolean

##formula_2=boolean

##formula_3=boolean

##formula_4=boolean

##result=output string

if formula_1 == True:

result= 1

elif formula_2 == True:

result= 2

elif formula_3 == True:

result= 3

elif formula_4 == True:

result= 4

else:
 result= 5

 the problem is, this type of script doesn´t work in QGIS 3, and I´m
a newbie in Python,
 could someone translate that to the new method?

 it´ll help me even begin to understand python 3

 Thanks
 Herbert Lincon
___
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] Python Scripts (Boolean) in QGIS 3

2019-03-12 Per discussione Herbert Lincon
Hello everyone,

I have a script in QGIS 2.18 to receive the information from 4 boolean options 
as simple as that

##formula_1=boolean
##formula_2=boolean
##formula_3=boolean
##formula_4=boolean
##result=output string

if formula_1 == True:
result= 1
elif formula_2 == True:
result= 2
elif formula_3 == True:
result= 3
elif formula_4 == True:
result= 4
else:
result= 5


the problem is, this type of script doesn´t work in QGIS 3, and I´m a newbie in 
Python,
could someone translate that to the new method?

it´ll help me even begin to understand python 3

Thanks
Herbert Lincon
___
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] Problem with QGIS on Windows 10

2019-03-12 Per discussione Nicolas Cadieux
Hi,

I would completely erase the OSGeo4w64 folder and try a reinstall and make sure 
the antivirus is not interfering. If that does not work, hunt down other 
directories where QGIS files are found like in the user profile.  You can also 
destroy the registry keys. You could also try with the other QGIS installer.   
Make sure you run the installer in admin mode. Ideas can be found here. This 
was for QGIS 2.x.

https://gis.stackexchange.com/questions/152873/how-to-completely-uninstall-and-remove-qgis-2-8-1-on-windows-vista

Nicolas

> Le 12 mars 2019 à 02:10, Jana Michalková  a écrit :
> 
> Hello all,
> 
> I would need little help from you. One of my student has a problem with
> QGIS on Windows. After the last QGIS shutdown Windows got an error message 
> The code execution cannot proceed because qgis_app.dll was not found (and 
> another ones see below) and he can not run QGIS from this moment. He 
> attempted to reinstall it, we also tried to use this tip and this, but 
> nothing worked. It still does not complete the installation and will not 
> create icons on the desktop nor in the start menu. He tried to install 
> different qgis versions (3.6, 3.4, 2.18, 2.18, 2.14). It worked only for 
> version 1.xx.
> 
> PC parameters: Acer Nitro 5, OS Windows 10 Home 64bit, 8 GB RAM, Intel Core 
> i5-8300H 2.30 GHz, GeForce GTX 1050 4GB.
> 
> Where could be a problem?
> Thanks in advance for any help!
> 
> Best regards
> Jana
> 
> -- 
> Mgr. Jana Michalková, PhD.
> Researcher
> ERASMUS+ Departmental Coordinator
> 
> Department of Geography and Applied Geoinformatics
> Faculty of Humanities and Natural Sciences   
> University of Presov
> 17. novembra 1, 081 16 Presov, Slovakia
> 
> 
> 
> 
> ___
> 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] corrupt layer management with spatilite source

2019-03-12 Per discussione Andrea Giraldi
Like 20...

> Date: Tue, 12 Mar 2019 23:39:48 +1300
> From: Patrick Dunford 
> To: qgis-user ML 
> Subject: Re: [Qgis-user] corrupt layer management with spatilite
> source
> Message-ID: 
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
> How many layers does the project have in total?
>
> On 12/03/19 3:33 AM, Andrea Giraldi wrote:
> > 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

[Qgis-user] 190312 - Can I run QGIS 2.18.xx and 3.4.xx concurrently on a Mac OS X

2019-03-12 Per discussione Paul T A Drea

Hello All,

I am running a macOS Mojave Version 10.14.3

I have installed Python 3.6.8

I would like to know if I can run QGIS 2.18.xx and 3.4.xx concurrently 
on the same machine.


Thanks in advance for any advice.

Best Regards,

Paul
--

*/Paul T. A. Drea/*

*Geodetic Consultant*

*Tel/Fax Greece: +30-210-9649 993*

*Cell Greece: +30-698 052 0611*

*SKYPE: paul.drea*

*e**-mail 1: **pauld...@gmail.com* 

*e**-mail 2: **ptad...@otenet.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] Error saving/exporting data with many attributes

2019-03-12 Per discussione Patrick Dunford
Case sensitive names (from experience) are handled inconsistently within 
the Qgis software. It would be unwise to have two different columns 
where the names are only distinguished by case, unless the developers 
choose to address these issues in future.


On 12/03/19 12:20 AM, b.j.kob...@utwente.nl wrote:


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 
"  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 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] corrupt layer management with spatilite source

2019-03-12 Per discussione Patrick Dunford

How many layers does the project have in total?

On 12/03/19 3:33 AM, Andrea Giraldi wrote:
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
___
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 error & F29

2019-03-12 Per discussione Richard Duivenvoorde
Ah...

Now I see 2.7 
That is very old, please upgrade to the one available via
https://qgis.org/en/site/forusers/alldownloads.html#fedora

Regards,

Richard Duivenvoorde


On 12/03/2019 07.08, Richard Duivenvoorde wrote:
> Hi Max,
> 
> The error means that the python-cpp bridge is not working because wrong
> paths to (python) libs.
> Are you maybe in a Python Virtual Environment at that moment, which in
> that case screws up your python path?
> 
> Or else: did you miss some QGIS-Python package (if installed via package
> manager)?
> 
> Regards,
> 
> Richard Duivenvoorde
> 
> On 11/03/2019 23.15, Max Pyziur wrote:
>>
>>
>> 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 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] Problem with QGIS on Windows 10

2019-03-12 Per discussione Jana Michalková
Hello all,

I would need little help from you. One of my student has a problem with
QGIS on Windows. After the last QGIS shutdown Windows got an error message *The
code execution cannot proceed because qgis_app.dll was not found* (and
another ones see below) and he can not run QGIS from this moment. He
attempted to reinstall it, we also tried to use this tip

and this
,
but nothing worked. It still does not complete the installation and will
not create icons on the desktop nor in the start menu. He tried to install
different qgis versions (3.6, 3.4, 2.18, 2.18, 2.14). It worked only for
version 1.xx.

PC parameters: Acer Nitro 5, OS Windows 10 Home 64bit, 8 GB RAM, Intel Core
i5-8300H 2.30 GHz, GeForce GTX 1050 4GB.

Where could be a problem?
Thanks in advance for any help!

Best regards
Jana

-- 

*Mgr. Jana Michalková, PhD.**Researcher*

*ERASMUS+ Departmental Coordinator*


Department of Geography and Applied Geoinformatics
Faculty of Humanities and Natural Sciences
University of Presov
17. novembra 1, 081 16 Presov, Slovakia
___
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 error & F29

2019-03-12 Per discussione Richard Duivenvoorde
Hi Max,

The error means that the python-cpp bridge is not working because wrong
paths to (python) libs.
Are you maybe in a Python Virtual Environment at that moment, which in
that case screws up your python path?

Or else: did you miss some QGIS-Python package (if installed via package
manager)?

Regards,

Richard Duivenvoorde

On 11/03/2019 23.15, Max Pyziur wrote:
> 
> 
> 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 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