Re: [Qgis-user] Geopackage File Styles

2018-09-14 Per discussione Kurt Menke
The Package layer tool does not save the style. Sounds like a feature
request. I’ve seen several who are wanting this. You can save a style into
a geopackage from the Symbology tab of Layer properties though. If the
style has the same name as the layer it will come into QGIS with that style
applied.

Kurt Menke
___
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] Simple Vector-Editing Question - Deleting Multiple Rings at Once

2018-09-14 Per discussione Nicolas Cadieux
Hi,
Yes indeed, i has thinking at the object level. I have a method to remove 
thousands of rings that I developed for merging LiDAR borders files that 
generally results in thousands of polygones with thousands of islands.

If you want to eliminate thousands of rings, or holes inside polygons , you 
need create new polygon layer with a big square covering the entire area.  
Then, you can subtract the polygone layer from the square.  You will be left 
with all the rings and the square contour.  After deleting the square contour 
(a single polygon), all you have left is the inside rings.  Using the merge 
tools, you can then merge the inside rings with polygons.  

The result is a polygon layer with no more rings.  You may have to do a spatial 
query to transfert the data base to the new polygons. That depends on the 
algorithm used. Write back if this is not clear.

Nicolas

> Le 14 sept. 2018 à 10:24, Michael Treglia  a écrit :
> 
> Hi Delaz, Nicholas,
> 
> Thanks so much for the responses!
> 
> Delaz - your solution works - not sure if it's quicker/simpler to click on 
> the rings using the 'delete ring' tool, but it's a smart alternative option.
> 
> Nicholas - I think the challenge is that you can select the objects, but I 
> couldn't figure out a way to select rings for a bulk deletion, as it's more 
> about removing the holes (and selecting the bounding vertices) than selecting 
> the objects themselves. I'm happy to learn if I was just missing something.
> 
> On a related note - for the Shape Digitizing toolbar, those tools only work 
> to create new polygons, not new parts of a multipolygon, correct? Or is there 
> a way to do that I've been missing? (I know you can merge tool in this case 
> as well, but figured I'd check).
> 
> Thanks!
> Mike
> 
>> On Wed, Sep 12, 2018 at 12:12 PM Nicolas Cadieux 
>>  wrote:
>> Hi,
>> You have various selection tools in the GUI. (yellow box Icon with an 
>> arrow).  If you use shift + left mouse click, you can add to the current 
>> selection.  I think it is Ctlt + left mouse click in some version of QGIS.
>> Nicolas
>> 
>>> On 2018-09-12 11:12 AM, Michael Treglia wrote:
>>> Hi All,
>>> 
>>> I'm doing some work that entails fixing up some digitization based on 
>>> per-pixel image classification. Sometimes there are polygons with lots of 
>>> rings contained, so I'm using the Delete  Ring tool, but that requires 
>>> clicking on every individual ring. Is there a way to delete multiple rings 
>>> at one time via clicking/dragging with a keyboard key held or anything like 
>>> that?  
>>> Thanks!
>>> Mike
>>> 
>>> 
>>> 
>>> ___
>>> 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] Simple Vector-Editing Question - Deleting Multiple Rings at Once

2018-09-14 Per discussione Michael Treglia
Hi Delaz, Nicholas,

Thanks so much for the responses!

Delaz - your solution works - not sure if it's quicker/simpler to click on
the rings using the 'delete ring' tool, but it's a smart alternative option.

Nicholas - I think the challenge is that you can select the objects, but I
couldn't figure out a way to select rings for a bulk deletion, as it's more
about removing the holes (and selecting the bounding vertices) than
selecting the objects themselves. I'm happy to learn if I was just missing
something.

On a related note - for the Shape Digitizing toolbar, those tools only work
to create new polygons, not new parts of a multipolygon, correct? Or is
there a way to do that I've been missing? (I know you can merge tool in
this case as well, but figured I'd check).

Thanks!
Mike

On Wed, Sep 12, 2018 at 12:12 PM Nicolas Cadieux <
nicolas.cadi...@archeotec.ca> wrote:

> Hi,
>
> You have various selection tools in the GUI. (yellow box Icon with an
> arrow).  If you use shift + left mouse click, you can add to the current
> selection.  I think it is Ctlt + left mouse click in some version of QGIS.
>
> Nicolas
>
> On 2018-09-12 11:12 AM, Michael Treglia wrote:
>
> Hi All,
>
> I'm doing some work that entails fixing up some digitization based on
> per-pixel image classification. Sometimes there are polygons with lots of
> rings contained, so I'm using the Delete  Ring tool, but that requires
> clicking on every individual ring. Is there a way to delete multiple rings
> at one time via clicking/dragging with a keyboard key held or anything like
> that?
> Thanks!
> Mike
>
>
>
> ___
> Qgis-user mailing listqgis-u...@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-it-user] Quickmapservices

2018-09-14 Per discussione Giuseppe Puddu
  
CIAO A TUTTI! 
SOTTO QGIS 3.2.2 WIN 7-64 HO PROVATO AD INSTALLARE IL
PLUGIN QUICKMAPSERVICES 
e mi restituisce questo errore. 
E ovviamente
non si installa! 
Idee? 
grazie 1000 giuseppe puddu

Impossibile
caricare il plugin 'quick_map_services' a causa di un errore chiamando
il metodo classFactory() 

TypeError: 'QVariant' object is not
subscriptable  

Traceback (most recent call last):
 File
"C:/OSGeo4W/apps/qgis/./pythonqgisutils.py", line 337, in startPlugin

plugins[packageName] = package.classFactory(iface)
 File
"C:/Users/win7-2015/AppData/Roaming/QGIS/QGIS3profilesdefault/python/pluginsquick_map_services__init__.py",
line 35, in classFactory
 return QuickMapServices(iface)
 File
"C:/Users/win7-2015/AppData/Roaming/QGIS/QGIS3profilesdefault/python/pluginsquick_map_servicesquick_map_services.py",
line 72, in __init__
 self.locale = Locale.get_locale()
 File
"C:/Users/win7-2015/AppData/Roaming/QGIS/QGIS3profilesdefault/python/pluginsquick_map_servicesplugin_locale.py",
line 30, in get_locale
 return
QSettings().value('locale/userLocale')[0:2]
TypeError: 'QVariant' object
is not subscriptable

Versione Python: 3.6.0 (v3.6.0:41df79263a11, Dec
23 2016, 07:18:10) [MSC v.1900 32 bit (Intel)] 
Versione di QGIS:
3.2.2-Bonn Bonn, 26842169e9 

Percorso Python: 

*
C:/OSGeo4W/apps/qgis/./python
*
C:/Users/win7-2015/AppData/Roaming/QGIS/QGIS3profilesdefault/python
*
C:/Users/win7-2015/AppData/Roaming/QGIS/QGIS3profilesdefault/python/plugins

* C:/OSGeo4W/apps/qgis/./python/plugins
* C:OSGeo4Wbinpython36.zip

* C:OSGeo4WappsPython36DLLs
* C:OSGeo4WappsPython36lib
*
C:OSGeo4Wbin
* C:OSGeo4WappsPython36
*
C:OSGeo4WappsPython36libsite-packages
*
C:OSGeo4WappsPython36libsite-packageswin32
*
C:OSGeo4WappsPython36libsite-packageswin32lib
*
C:OSGeo4WappsPython36libsite-packagesPythonwin
*
C:/Users/win7-2015/AppData/Roaming/QGIS/QGIS3profilesdefault/python
*
C:Userswin7-2015AppDataRoamingQGISQGIS3profilesdefaultpythonpluginsmmqgis/forms


 


Con MyOpen hai Giga, SMS e i minuti che vuoi da 3€ al mese, per sempre. Cambi 
gratis quando e come vuoi e in più hai 10€ di credito omaggio!
SCOPRI DI PIU’ http://tisca.li/myopen

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


[Qgis-user] Problem with GEarthView plugin

2018-09-14 Per discussione Chavoux Luyt
Hi everyone,

The GEarthView plugin used to work, so I don't know what went wrong. I am
running QGIS 2.18.11 on Debian stable (Stretch) (libpython 2.7.13-2+deb9u2,
python-qgis 1:2.18.11+14stretch, libqt5core5a 5.9.1+dfsg-9).

It gives me the following error message:

The plugin is broken. Python said:
'module' object has no attribute 'in_'


Any advice? What could have changed to stop it from working? How do I fix
it?


Regards,

Chavoux Luyt
___
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] Geopackage File Styles

2018-09-14 Per discussione Grant Boxer
Is there a way to save the styling information for each layer when creating
a geopackage using the "Package Layers" option? I have tried to do this but
every layer loses its style and has to be re-applied.

 

Grant Boxer

Perth, Western Australia

 

___
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] Geopagkage and "geom" in DBmanager

2018-09-14 Per discussione Karl Magnus Jönsson
Hi!
A question related to this. I have set up a PostGIS structure with tables, 
rules, views, triggers and constraints. To this there is a QGIS project with 
styling, forms, relations and so on. If I want to make a file based version of 
this for testing, working copies, versions, distribution etc. where do I put 
the database logic? Could it fit in a file based database or virtual layers? 
Which strategy is the best? Any ideas or experiences?

Regards
Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Bo Victor Thomsen
Skickat: den 13 september 2018 22:40
Till: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Geopagkage and "geom" in DBmanager

Ok, after some googling, I have a glimmer of understanding of the (technical 
and personal) issues. Enough said about that...

So technically, GPKG support in QGIS is a hybrid of a "simple" GPKG 
implementation bundled/merged with the spatialite sqlite-extension incl. 
conversion functions, so you can convert the GPKG binary object to and fro a 
spatialite ditto -  when you have to use som spatialite-specific functionality 
like spatial SQL, projection support and so on ?
(If there is a web page somewhere that explains this in detail, i'll 
respecfully redraw my questions and do some RTFM)

Regards
Bo Victor Thomsen

Den tor. 13. sep. 2018 kl. 16.00 skrev Luigi Pirelli 
mailto:lui...@gmail.com>>:
you should look into the history of the gpkg format definition vs spatialite 
format adoption. Nothing related with QGIS, or gdal or etc etc
Luigi Pirelli

**
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Mastering QGIS 2nd Edition:
* 
https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
* Hire me: http://goo.gl/BYRQKg
**


On Thu, 13 Sep 2018 at 14:30, Bo Victor Thomsen 
mailto:bo.victor.thom...@gmail.com>> wrote:
Ok.. From the Spatialite 4.2.0 wiki:

· CastAutomagic(): will indifferently accept both GPKG and SpatiaLite 
BLOB Geometries, then returning anyway a SpatiaLite's own BLOB Geometry.

I can confirm, that using the "CastAutomagic(geom)" function instead of the 
simple field "geom"  will get the st_area and other ogc functions in the QGIS 
Databasemanager Dataprovider for GeoPackage to work.

That means that the geopackage binary format for geometry is incompatible with 
the underlying spatialite spatial system and functions.

This is not the most helpful and thoughtful user oriented solution I've 
encountered ... Or should I have RTFM somewhere in the QGIS.org site ?

However it does work. Thanks for the tip




Den tor. 13. sep. 2018 kl. 13.20 skrev Jean-Baptiste Desbas 
mailto:jb.des...@gmail.com>>:
Hi,

I have to use st_area(CastAutomagic(geom)) instead of st_area(geom), otherwise 
null column is retourned.

Le jeu. 13 sept. 2018 à 11:45, Bo Victor Thomsen 
mailto:bo.victor.thom...@gmail.com>> a écrit :
Hi Lene -

I've made a few observations regarding the use of GeoPackage in DBManager...

I have a GeoPackage based table called "renhold" containing polygons. Primary 
key column is an integer called "fid" and the geometry column is called "geom" 
- It's pretty close to your setup

If I use the DBManager with the GeoPackage dataprovider and execute the 
following statement: select fid, st_area (geom) from renhold , it returns a 
table with 2 columns as expected. However , column nr. 2 contains only nulls. 
However, the statement does not result in an error. The function "st_area" 
simply doesn't return a value besides null.

An now the mystery!! :

If I use the DBManager with the Virtual Layers -> Project layers dataprovider 
and execute the following statement: select fid, st_area (geometry) from 
renhold , it returns a table with 2 columns as expected. And column nr. 2 do 
contain the expected area values. Go figure...

NB! The "renhold" layer is visible in the map and named "renhold"
NBB! In the Virtual Layers dataprovider you have to use the standard name 
"geometry" to represent the geometry column - not the real column name ("geom" 
in this case)

Actually I have a reasonable explanation: The 2 different dataproviders uses 
different internal functions to calculate the area. However the function used 
by the GeoPackage Dataprovider doesn't work !


Regards
Bo Victor Thomsen
LIFA Denamrk

Den tor. 13. sep. 2018 kl. 09.27 skrev Alexandre Neto 
mailto:senhor.n...@gmail.com>>:
Hi Lee,

Can you try removing the quotation marks around geom?

Best wishes,

Alex Neto
A qui, 13/09/2018, 02:04, Lene Fischer mailto:l...@ign.ku.dk>> 
escreveu:
Hi,
Trying out a geopackage layer in DBManager asking a simple SQL statement st_area
But when I try to write a statement like this

SELECT