Re: [Qgis-user] Adding layer slows down QGIS dramatically after adding a layer
On Fri, 14 Aug 2020 at 00:06, Peter Cornelissen wrote: > > Hi > > I am using a Geopackage with about 15 tables (a mixture of lines, polygons > and points), but each of these tables are > used 40 or 50 times with filters as many of the elements are used on multiple > layers. > However, I am now finding that as soon as I add a new layer QGIS slows down > and it is taking 60 seconds or more to do almost any action that involves > redrawing (zoom in/out/ pan etc) or even moving a layer within the layers > panel. If I save the project, close down QGIS and restart, it is fine again > until the next time. Sounds very much like a faulty plugin is installed. Try starting QGIS from a clean profile and see if it resolves the issue. Nyall > > Any suggestions? > > Thanks, Peter > > ___ > 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] Adding layer slows down QGIS dramatically after adding a layer
Hi Richard
Thanks for the suggestion. They are plain filters and I tried indexing
every table, but unfortunately it has made no noticeable difference.
Regards, Peter
On Thu, 13 Aug 2020 at 15:35, Richard Duivenvoorde
wrote:
> On 8/13/20 3:57 PM, Peter Cornelissen wrote:
> > Hi
> >
> > I am using a Geopackage with about 15 tables (a mixture of lines,
> polygons and points), but each of these tables are
> > used 40 or 50 times with filters as many of the elements are used on
> multiple layers.
> > However, I am now finding that as soon as I add a new layer QGIS slows
> down
> > and it is taking 60 seconds or more to do almost any action that involves
> > redrawing (zoom in/out/ pan etc) or even moving a layer within the layers
> > panel. If I save the project, close down QGIS and restart, it is fine
> again
> > until the next time.
> >
> > Any suggestions?
> >
> > Thanks, Peter
>
> Looking at the attributes which are used in the filters, add 'indexes' too
> the tables in the Geopackage?
>
> In QGIS you can do that by creating a connection to the gpkg with DataBase
> Manager and then:
> 'edit table' > tab indexes, > add index
>
> A geopackage is a sqlite database, so if you have some sql-client
> (DB-manager, DB-browser) you can fire the create index query there:
> CREATE INDEX "foo_index" ON "mygeopackage" ("foo_column")
>
> Note that these are plain indexes, no spatial ones.
> IF your filters are spatial filters, then off course you need spatial
> indexes.
>
> HTH
>
> Regards,
>
> Richard Duivenvoorde
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [QGIS-it-user] Remote Sensing e Impianti fotovoltaici
Ciao Intanto la piattaforma che ti permetterà di fare una classificazione o riconoscimento degli impianti fotovoltaici non è un problema. Semi automatic classification va benissimo, altrimenti hai tutti i tool di grass o di otb o di saga. Il problema è la sorgente di dati satellitari che ti permetterà di fare la classificazione, perché tra le costellazioni che forniscono immagini free of charge con una risoluzione tale (10m) da riconoscere i pannelli solari credo ci sia solo Sentinel2, che Semi Automatic Classification sa scaricare e trattare. Un saluto Giacomo Il gio 13 ago 2020, 20:02 Federico Gianoli ha scritto: > Ciao, potresti spiegare meglio cosa ti serve mappare... Il RS é un mondo > meraviglioso ed infinito. Prova ad entrare meglio nel dettaglio per capire > che funzioni ti servono. > > Il gio 13 ago 2020, 19:35 Pj Hooker ha > scritto: > >> Buongiorno a tutti, avrei bisogno di informazioni riguarda alla possibile >> mappatura di impianti fotovoltaici. Io non ho esperienza in RS, ma >> leggendo la documentazione, mi è parso di capire che si può fare. >> Ho provato a contattare Luca Congedo un paio di giorni fa, ma non mi ha >> ancora risposto, se è per caso in questa lista, vorrei scrivergli. >> >> Si tratta di una richiesta da un mio contatto che sembra avere un bel >> progetto per l'Africa. >> >> Attendo vostre. >> >> Un saluto, >> Pj. >> >> >> - >> Piergiorgio ROVEDA >> Urban planner - www.cityplanner.biz >> Coworking Login - MILANO - Via Stefanardo da Vimercate, 28 >> mobile: +39 348 7448152 - email: piergiorgio.rov...@cityplanner.biz >> >> <#m_763916225137827550_m_6288953976996346078_m_7400949173660353985_m_8838544706274826782_m_-8877376715419219462_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> >> ___ >> 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 > ___ QGIS-it-user mailing list QGIS-it-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/qgis-it-user
[Qgis-user] DB Browser connection via Spatialite
Excited to learn via this excellent tutorial [1] that i can connect my favorite SQL tool (DB Browser for SQLite) to the .gpkg files that i am just starting to build w/ QGIS, i gave it a try straight away and found that it does indeed recognize my .gpkg file as a readable database, such that i can explore the db structure and browse tables data -- Except for the "geom" column, which just has "blob" in every field (first clue it's not so simple!). Then i tried to make a small edit to one field of non-geographic data... And that made a mess of everything so i had to delete the layer and start over. So i wonder: maybe QGIS doesn't allow any other app to edit data in its .gpkg files? Reading deeper into tutorial [1], it seems that DB Browser needs a spatialite extension (mod_spatialite.dylib for Mac 64), which good folks at Fulcrum have kindly provided via their Github repo [2]... But following dead-simple instructions given in tutorial [1], my installation fails with the error msg: > Error loading extension: > dlopen(/Users/walterludwick/Desktop/mod_spatialite.dylib.dyylib, 10): image > not found (Strange: that redundant .dylib extension is not in the filepath i chose, but... So it goes) Anyway: i know this isn't the forum for DB Browser support, but because it is so widely adopted in QGIS (and FOSS more generally) world, i just wonder if anyone here is using it, and if so might be able to shed any light on this problem. ? NOTES: [1] Tutorial: https://www.fulcrumapp.com/blog/working-with-geodata/ [2] Spatialite for DB Browser: https://github.com/fulcrumapp/spatialite-bin ___ 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] Remote Sensing e Impianti fotovoltaici
Ciao, potresti spiegare meglio cosa ti serve mappare... Il RS é un mondo meraviglioso ed infinito. Prova ad entrare meglio nel dettaglio per capire che funzioni ti servono. Il gio 13 ago 2020, 19:35 Pj Hooker ha scritto: > Buongiorno a tutti, avrei bisogno di informazioni riguarda alla possibile > mappatura di impianti fotovoltaici. Io non ho esperienza in RS, ma > leggendo la documentazione, mi è parso di capire che si può fare. > Ho provato a contattare Luca Congedo un paio di giorni fa, ma non mi ha > ancora risposto, se è per caso in questa lista, vorrei scrivergli. > > Si tratta di una richiesta da un mio contatto che sembra avere un bel > progetto per l'Africa. > > Attendo vostre. > > Un saluto, > Pj. > > > - > Piergiorgio ROVEDA > Urban planner - www.cityplanner.biz > Coworking Login - MILANO - Via Stefanardo da Vimercate, 28 > mobile: +39 348 7448152 - email: piergiorgio.rov...@cityplanner.biz > > <#m_6288953976996346078_m_7400949173660353985_m_8838544706274826782_m_-8877376715419219462_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > ___ > 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
[QGIS-it-user] Remote Sensing e Impianti fotovoltaici
Buongiorno a tutti, avrei bisogno di informazioni riguarda alla possibile mappatura di impianti fotovoltaici. Io non ho esperienza in RS, ma leggendo la documentazione, mi è parso di capire che si può fare. Ho provato a contattare Luca Congedo un paio di giorni fa, ma non mi ha ancora risposto, se è per caso in questa lista, vorrei scrivergli. Si tratta di una richiesta da un mio contatto che sembra avere un bel progetto per l'Africa. Attendo vostre. Un saluto, Pj. - Piergiorgio ROVEDA Urban planner - www.cityplanner.biz Coworking Login - MILANO - Via Stefanardo da Vimercate, 28 mobile: +39 348 7448152 - email: piergiorgio.rov...@cityplanner.biz <#m_7400949173660353985_m_8838544706274826782_m_-8877376715419219462_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> ___ QGIS-it-user mailing list QGIS-it-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/qgis-it-user
Re: [Qgis-user] Adding layer slows down QGIS dramatically after adding a layer
On 8/13/20 3:57 PM, Peter Cornelissen wrote:
> Hi
>
> I am using a Geopackage with about 15 tables (a mixture of lines, polygons
> and points), but each of these tables are
> used 40 or 50 times with filters as many of the elements are used on multiple
> layers.
> However, I am now finding that as soon as I add a new layer QGIS slows down
> and it is taking 60 seconds or more to do almost any action that involves
> redrawing (zoom in/out/ pan etc) or even moving a layer within the layers
> panel. If I save the project, close down QGIS and restart, it is fine again
> until the next time.
>
> Any suggestions?
>
> Thanks, Peter
Looking at the attributes which are used in the filters, add 'indexes' too the
tables in the Geopackage?
In QGIS you can do that by creating a connection to the gpkg with DataBase
Manager and then:
'edit table' > tab indexes, > add index
A geopackage is a sqlite database, so if you have some sql-client (DB-manager,
DB-browser) you can fire the create index query there:
CREATE INDEX "foo_index" ON "mygeopackage" ("foo_column")
Note that these are plain indexes, no spatial ones.
IF your filters are spatial filters, then off course you need spatial indexes.
HTH
Regards,
Richard Duivenvoorde
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Adding layer slows down QGIS dramatically after adding a layer
Hi I am using a Geopackage with about 15 tables (a mixture of lines, polygons and points), but each of these tables are used 40 or 50 times with filters as many of the elements are used on multiple layers. However, I am now finding that as soon as I add a new layer QGIS slows down and it is taking 60 seconds or more to do almost any action that involves redrawing (zoom in/out/ pan etc) or even moving a layer within the layers panel. If I save the project, close down QGIS and restart, it is fine again until the next time. Any suggestions? Thanks, Peter ___ 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] Remote Sensing e Impianti fotovoltaici
Buongiorno a tutti, avrei bisogno di informazioni riguarda alla possibile mappatura di impianti fotovoltaici. Io non ho esperienza in RS, ma leggendo la documentazione, mi è parso di capire che si può fare. Ho provato a contattare Luca Congedo un paio di giorni fa, ma non mi ha ancora risposto, se è per caso in questa lista, vorrei scrivergli. Si tratta di una richiesta da un mio contatto che sembra avere un bel progetto per l'Africa. Attendo vostre. Un saluto, Pj. - Piergiorgio ROVEDA Urban planner - www.cityplanner.biz Coworking Login - MILANO - Via Stefanardo da Vimercate, 28 mobile: +39 348 7448152 - email: piergiorgio.rov...@cityplanner.biz <#m_8838544706274826782_m_-8877376715419219462_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> ___ QGIS-it-user mailing list QGIS-it-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/qgis-it-user
[Qgis-user] R: Qgis-user Digest, Vol 174, Issue 15
Thank you Christine No I didn't. I think this will not work for my purpouse. I am making pdf maps trough atlas function. There bare two layers whose labels are in conflict The atlas feature layer on the top, who has the label priority, and a second layer underneath the atlas layer. I want the labels of the bottom layer to be placed external to the surface of each atlas feature (top layer). Each bottom layer feature may contain many top layer features so If I move a bottom layer label with the label toolbar I think that the moved label will remain in its place and will not follow the atlas representation. So I need some way to authomatically force the bottom layer labels to remain outside the atlas feature surfaces. Did I explain myself? Pietro Message: 2 Date: Tue, 11 Aug 2020 13:54:23 -0700 (MST) From: Christine To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Label overlapping between layers Message-ID: <1597179263286-0.p...@n6.nabble.com> Content-Type: text/plain; charset=us-ascii Good evening Pietro, did you already consider to apply the functions of the label toolbar ? With the tools of the label toolbar you may rearrange the automatic positioning of the label (e.g. move, rotate). Regards, Christine AVVISO DI RISERVATEZZA Informazioni riservate possono essere contenute nel messaggio o nei suoi allegati. Se non siete i destinatari indicati nel messaggio, o responsabili per la sua consegna alla persona, o se avete ricevuto il messaggio per errore, siete pregati di non trascriverlo, copiarlo o inviarlo ad alcuno. In tal caso vi invitiamo a cancellare il messaggio ed i suoi allegati. Grazie. CONFIDENTIALITY NOTICE Confidential information may be contained in this message or in its attachments. If you are not the addressee indicated in this message, or responsible for message delivering to that person, or if you have received this message in error, you may not transcribe, copy or deliver this message to anyone. In that case, you should delete this message and its attachments. Thank you. ___ 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
