Re: [Qgis-user] Problems with raster layer in geopackage

2022-09-22 Thread Nicolas Cadieux via Qgis-user
Hi,

I would not store raster in a geopackage unless it’s just a pretty picture.  
The default compression for that format is not lossless.  I would just save as 
a .tiff. 

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 1 sept. 2022 à 23:33, David Strip via Qgis-user 
>  a écrit :
> 
>  I have a geopackage called GMU5ab. I also have a map project called GMU5ab, 
> which is stored in that geopackage. With the GMU5ab project open in QGIS,  I 
> created a hillshade layer, called "Hillshade" in the layer list. I saved this 
> layer to the geopackage. Unlike a vector layer which is stored with the 
> legend name, the layer in the geopackage was stored as GMU5ab and has a 
> raster icon. If I right click on a vector layer in a geopackage in the 
> browser, I have the choice of Manage->Rename Layer, but if I right click on 
> the raster layer, Manage only offers delete.
> 
> Is there a way to store the raster layer with the correct name in the first 
> place using Qgis?
> Once stored, is there a way to rename a raster layer in a geopackage from 
> within Qgis.
> 
> QGIS 3.26 on Windows 10
> 
> Thanks
> 
> 
> ___
> 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] Hire a QGIS Contractor

2022-09-22 Thread Nicolas Cadieux via Qgis-user
Funny message! :) What are you looking for exactly!

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 9 sept. 2022 à 13:13, Dennis Burgess via Qgis-user 
>  a écrit :
> 
> 
> Looking for a contractor that can either speak with us and/or exchange emails 
> in English for QGIS .  😊  Anyone please hit me off-list 😊
>  
>  
> 
> Dennis Burgess
> 
> Mikrotik : Trainer, Network Associate, Routing Engineer, Wireless Engineer, 
> Traffic Control Engineer, Inter-Networking Engineer, Security Engineer, 
> Enterprise Wireless Engineer
> Hurricane Electric: IPv6 Sage Level
> Cambium: ePMP
>  
> Author of "Learn RouterOS- Second Edition”
> Link Technologies, Inc -- Mikrotik & WISP Support Services
> Office: 314-735-0270  Website: http://www.linktechs.net
> Create Wireless Coverage’s with www.towercoverage.com
> Need MikroTik Cloud Management: https://cloud.linktechs.net
> How did we do today?
> 
> 
> 
> 
>  
> ___
> 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] Faster Intersects

2022-09-22 Thread Nicolas Cadieux via Qgis-user
Hi,
Geopackage has a build in index. So you don’t need to build it.

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 9 sept. 2022 à 13:50, Raymond Nijssen via Qgis-user 
>  a écrit :
> 
> Great! \o/
> 
> 
>> On 09-09-2022 19:25, Dennis Burgess wrote:
>> That did it!!!  I was unware that GeoPackage’s are SUPER fast and that I 
>> could SAVE a CSV as a GeoPackage file. . There is no metho to create indexes 
>> though once I do this, but now it runs in about 2 min!  lol
>> *LTI-Full_175px*
>> *Dennis Burgess*
>> *
>> *Author of "Learn RouterOS- Second Edition”
>> *Link Technologies, Inc*-- Mikrotik & WISP Support Services
>> *Office*: 314-735-0270  Website: http://www.linktechs.net 
>> 
>> Create Wireless Coverage’s with www.towercoverage.com 
>> Need MikroTik Cloud Management: https://cloud.linktechs.net 
>> 
>> *From:* Alexandre Neto 
>> *Sent:* Friday, September 9, 2022 12:20 PM
>> *To:* Dennis Burgess 
>> *Cc:* Raymond Nijssen ; QGIS User 
>> 
>> *Subject:* Re: [Qgis-user] Faster Intersects
>> Following raymond advice,
>> Move the CSV to a shapefile or geopackage and run the create spatial index 
>> on it.
>> If you have very complex polygons, use suvdivide to create smaller ones save 
>> it in shapefile or geopackage and run create spatial index on it.
>> https://docs.qgis.org/3.22/en/docs/user_manual/processing_algs/qgis/vectorgeometry.html#subdivide
>>  
>> 
>> I would try with a smaller subset of points to test the improvement speed 
>> before trying to run on the full dataset again.
>> Answering your question, yes I am pretty sure postgis is much faster than 
>> mssql, and yes I think most recent versions of PostgreSQL PostGIS make use 
>> of more than one core.
>> Good luck
>> A sexta, 9/09/2022, 17:59, Dennis Burgess via Qgis-user 
>> mailto:qgis-user@lists.osgeo.org>> escreveu:
>>In the format, are you talking about the shape or the CSV with
>>2million lines?
>>Dennis Burgess
>>Author of "Learn RouterOS- Second Edition”
>>Link Technologies, Inc -- Mikrotik & WISP Support Services
>>Office: 314-735-0270  Website: http://www.linktechs.net
>>
>>Create Wireless Coverage’s with www.towercoverage.com
>>
>>Need MikroTik Cloud Management: https://cloud.linktechs.net
>>
>>-Original Message-
>>From: Qgis-user >> On Behalf Of Raymond
>>Nijssen via Qgis-user
>>Sent: Friday, September 9, 2022 11:11 AM
>>To: qgis-user@lists.osgeo.org 
>>Subject: Re: [Qgis-user] Faster Intersects
>>Some things to check:
>>* Is your data local?
>>* Is it in a fast file format? (for example .gpkg or .shp and not
>>.csv or .geojson)
>>* Does the data have a spatial index?
>>* Is the geometry very complicated, like a huge multi polygon with
>>thousands of vertices and islands? In that case, split it up in
>>several polygons.
>>Hope this helps. Anyway, it should not need to take this long.
>>Raymond
>>On 09-09-2022 16:28, Dennis Burgess via Qgis-user wrote:
>> > How can I speed up Intersects?  Right now I have a single geometry
>> > file, but then have about 2 million points that I need to understand
>> > what intersects that geometry.  Right now its taking 3 days?
>> > QGIS-bin.exe is only using 11% CPU.. ☹
>> >
>> > Dennis
>> >
>> >
>> > ___
>> > 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://

[Qgis-user] Distance to nearest hub

2022-09-22 Thread Hans Skov-Petersen via Qgis-user
Dear list

I am trying to compile the distance from a set of points to its nearest 
polygon. Quite simple, but it keeps on crashing.

Both layers are in the same CRS (UTM32N). The polygon layer is as cleaned as ca 
be.

[cid:image001.png@01D8CE93.90386900]

[cid:image002.png@01D8CE93.90386900]

Whattodo?

Cheers
Hans Skov-Petersen
Professor of Geoinformatic
University of Copenhagen
Dept. og Geoscience and Nature Management
Rolighedsvej 23
DK-1958 Frederiksberg
Mobile: +45 23 82 80 45
Email: h...@ign.ku.dk

___
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] Profile data (other than plugins) that can cause crashes?

2022-09-22 Thread Richard Duivenvoorde via Qgis-user

Not sure if this is in your capabilities, but I would try to compile/install 
QGIS myself (in debug mode).
Then read up a little about the first steps of gdb, and start QGIS via gdb, 
then upon a crash the debugger will jump in and you will get some context about 
the crash.
Even without debugger a in debug mode compiled QGIS will show a lot of info in 
it's stacktrace.

I'm not aware of other methods (on Kubuntu) to show this..

Some other options:
- try to close the 'browser-panel', I've seen some issues with that one (though 
not crashes)
- minimize your plugins, or if possible try if you can make QGIS crash without 
any plugin
- maybe make a list of types of data you load in your projects (to see if it 
could be data related)
- is it project file related (are you using older projects, not that that 
should be a problem, but..)

Please create an issue report, with as much info as possible

Others?

Regards,

Richard Duivenvoorde


On 9/22/22 04:31, Patrick Dunford via Qgis-user wrote:

Good day

Since I first began to use Kubuntu 22.04 from the .0 release I started to see 
crashes on Qgis that weren't experienced on the same versions running on 
previous releases of Kubuntu (certainly the case on 20.04). These seem to come 
and go depending on some random factors, which makes it extremely hard to write 
up a meaningful bug report for the issue which is why so far all that has been 
filed is one with the Ubuntu project bug reporting system.

All of these crashes occur when Qgis attempts to display a file operation 
dialog (e.g. add a layer, save a layer definition file, etc).

Today I started to see these issues happening on a system that has been trouble 
free for weeks if not months, the crashes became very consistent / repetitive 
which had not been observed for a long time up to now if at all.

I have tried a new profile and at the moment that makes the problem go away. 
However the next question would be what might be contained within a profile 
that could cause such an issue. Often it is considered the most likely issue in 
a profile is to do with installed plugins. In this case, both profiles contain 
the same plugins which are the 10 that are installed as core plugins (5 
selected by default). If the issue is within a profile, it must be some other 
part of the profile.

Is there any base of experience about other parts of a profile (such as user 
settings) which can cause issues?

The most obvious different between profiles in this case is previewImages 
folder, however removing these images made no difference to the issue. It would 
require further testing or analysis to try to find out where the issue might be 
occurring. Nevertheless a bug report has been filed, attaching the old and new 
profiles.

Is there any straightforward way of producing a comparison between different 
versions of the databases (which must include all the user settings) in a 
profile.

T.I.A.
___
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