[Qgis-user] GDAL problem

[Grant Boxer via Qgis-user]

Hi all, when I try to pansharpen an image using gdal, I get the following
message. Any thoughts?

 

QGIS version: 3.26.2-Buenos Aires

QGIS code revision: feec3d3b

Qt version: 5.15.3

Python version: 3.9.5

GDAL version: 3.5.1

GEOS version: 3.10.3-CAPI-1.16.1

PROJ version: Rel. 9.1.0, September 1st, 2022

PDAL version: 2.4.3 (git-version: 6311a6)

Algorithm started at: 2022-09-10T11:24:16

Algorithm 'Pansharpening' starting.

Input parameters:

{ 'EXTRA' : '', 'OPTIONS' : '', 'OUTPUT' :
'D:/Projects/REE/PRS_L2D_STD_20210502012240_20210502012244_0001/SWIR_Panshar
pened.vrt', 'PANCHROMATIC' :
'D:/Projects/REE/PRS_L2D_STD_20210502012240_20210502012244_0001/NolansBore_S
pectraCube_SWIR.tif', 'RESAMPLING' : 2, 'SPECTRAL' :
'D:/Projects/REE/PRS_L2D_STD_20210502012240_20210502012244_0001/NolansBore_S
pectraCube_SWIR.tif' }

 

GDAL command:

gdal_pansharpen.bat
D:\Projects\REE\PRS_L2D_STD_20210502012240_20210502012244_0001\NolansBore_Sp
ectraCube_SWIR.tif
D:\Projects\REE\PRS_L2D_STD_20210502012240_20210502012244_0001\NolansBore_Sp
ectraCube_SWIR.tif
D:/Projects/REE/PRS_L2D_STD_20210502012240_20210502012244_0001/SWIR_Pansharp
ened.vrt -r cubic -of VRT

GDAL command output:

Process gdal_pansharpen.bat failed to start. Either gdal_pansharpen.bat is
missing, or you may have insufficient permissions to run the program.

Execution failed after 0.17 seconds

 

Loading resulting layers

Algorithm 'Pansharpening' finished

 

 

 

___
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] il prossimo splashscreen di QGIS sarà dedicato a Firenze

[Stefano Campus]

Domani ci provo
s.

Il ven 9 set 2022, 21:13 Totò Fiandaca  ha
scritto:

> Buonasera a tutt@,
> Anita sta già iniziando a creare il progetto GIMP per realizzare lo
> splashscreen e quindi occorre accelerare un po' la presentazione di
> proposte nel mio repository:
> https://github.com/pigreco/splashscreen_QGIS328_Firenze.
>
> Entro questa settimana, Rossella scriverà ad Anita e le indicherà il mio
> repository con tutte le proposte arrivate.
> Penso che poi Anita sceglierà l'immagine più appropriata secondo i suoi
> canoni: per esempio: immagine con almeno 3000 px e con ben in evidenza la
> scritta, nell'immagine, di Firenze.
>
> Affrettatevi!
>
> saluti
>
>
>
> Il giorno ven 9 set 2022 alle ore 09:32 Totò Fiandaca <
> pigrecoinfin...@gmail.com> ha scritto:
>
>> Ciao Iacopo,
>> grazie per la tua idea e realizzazione dello splashscreen, per favore
>> aggiungilo al repository (se hai difficoltà, fammelo sapere).
>>
>> saluti
>>
>> Il giorno ven 9 set 2022 alle ore 09:28 Iacopo <
>> iac...@controgeografie.net> ha scritto:
>>
>>> Sottopongo, per ora in lista, una
>>> ipotesi:
>>> https://drive.google.com/file/d/1mZjvVUDM4cEFrOJEo_tEGPe2CBq4IWU1/view?usp=sharing
>>>
>>> La carta della catena, che ho utilizzato, è una pietra miliare della
>>> cartografia. Si tratta in realtà di una vista, ma viene quasi sempre
>>> chiamata carta perché costituisce il primo esempio di uso della
>>> prospettiva per rappresentare una città. Dietro ci sono le teorie
>>> matematiche di Paolo dal Pozzo Toscanelli e la lezione del disegno in
>>> prospettiva di Leon Battista Alberti che, seguendo gli stessi metodi,
>>> poi realizzò la prima pianta di Roma. Insomma la madre della
>>> cartografia moderna in scala, cosa che potrebbe sostenere di usarla
>>> per lo spalsh di un moderno software gis (non che la mappa del Molini o
>>> eventualmente del Bonsiglnori del 1584 non siano ottime idee).
>>>
>>> Saluti
>>>
>>> Iacopo
>>> ___
>>> QGIS-it-user mailing list
>>> QGIS-it-user@lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/qgis-it-user
>>>
>>
>>
>> --
>> *Ing. Salvatore Fiandaca*
>> *mobile*.:+39 327.493.8955
>> *m*: *pigrecoinfin...@gmail.com *
>> *C.F*.: FNDSVT71E29Z103G
>> *P.IVA*: 06597870820
>> *membro QGIS Italia - http://qgis.it/ *
>> *socio GFOSS.it - *http://gfoss.it/
>> *blog:*
>> * https://pigrecoinfinito.com/  FB:
>> Co-admin - https://www.facebook.com/qgis.it/
>> **
>>  *
>> *TW:  **https://twitter.com/totofiandaca
>> *
>>
>> 43°51'0.54"N  10°34'27.62"E - EPSG:4326
>>
>> “Se la conoscenza deve essere aperta a tutti,
>> perchè mai limitarne l’accesso?”
>> R. Stallman
>>
>> Questo documento, allegati inclusi, contiene informazioni di proprietà di
>> FIANDACA SALVATORE e deve essere utilizzato esclusivamente dal destinatario
>> in relazione alle finalità per le quali è stato ricevuto. E' vietata
>> qualsiasi forma di riproduzione o divulgazione senza l'esplicito consenso
>> di FIANDACA SALVATORE. Qualora fosse stato ricevuto per errore si prega
>> di informare tempestivamente il mittente e distruggere la copia in proprio
>> possesso.
>>
>>
>>
>
> --
> *Ing. Salvatore Fiandaca*
> *mobile*.:+39 327.493.8955
> *m*: *pigrecoinfin...@gmail.com *
> *C.F*.: FNDSVT71E29Z103G
> *P.IVA*: 06597870820
> *membro QGIS Italia - http://qgis.it/ *
> *socio GFOSS.it - *http://gfoss.it/
> *blog:*
> * https://pigrecoinfinito.com/  FB: Co-admin
> - https://www.facebook.com/qgis.it/ **
>  *
> *TW:  **https://twitter.com/totofiandaca
> *
>
> 43°51'0.54"N  10°34'27.62"E - EPSG:4326
>
> “Se la conoscenza deve essere aperta a tutti,
> perchè mai limitarne l’accesso?”
> R. Stallman
>
> Questo documento, allegati inclusi, contiene informazioni di proprietà di
> FIANDACA SALVATORE e deve essere utilizzato esclusivamente dal destinatario
> in relazione alle finalità per le quali è stato ricevuto. E' vietata
> qualsiasi forma di riproduzione o divulgazione senza l'esplicito consenso
> di FIANDACA SALVATORE. Qualora fosse stato ricevuto per errore si prega
> di informare tempestivamente il mittente e distruggere la copia in proprio
> possesso.
>
>
> ___
> 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] il prossimo splashscreen di QGIS sarà dedicato a Firenze

[Totò Fiandaca]

Buonasera a tutt@,
Anita sta già iniziando a creare il progetto GIMP per realizzare lo
splashscreen e quindi occorre accelerare un po' la presentazione di
proposte nel mio repository:
https://github.com/pigreco/splashscreen_QGIS328_Firenze.

Entro questa settimana, Rossella scriverà ad Anita e le indicherà il mio
repository con tutte le proposte arrivate.
Penso che poi Anita sceglierà l'immagine più appropriata secondo i suoi
canoni: per esempio: immagine con almeno 3000 px e con ben in evidenza la
scritta, nell'immagine, di Firenze.

Affrettatevi!

saluti



Il giorno ven 9 set 2022 alle ore 09:32 Totò Fiandaca <
pigrecoinfin...@gmail.com> ha scritto:

> Ciao Iacopo,
> grazie per la tua idea e realizzazione dello splashscreen, per favore
> aggiungilo al repository (se hai difficoltà, fammelo sapere).
>
> saluti
>
> Il giorno ven 9 set 2022 alle ore 09:28 Iacopo 
> ha scritto:
>
>> Sottopongo, per ora in lista, una
>> ipotesi:
>> https://drive.google.com/file/d/1mZjvVUDM4cEFrOJEo_tEGPe2CBq4IWU1/view?usp=sharing
>>
>> La carta della catena, che ho utilizzato, è una pietra miliare della
>> cartografia. Si tratta in realtà di una vista, ma viene quasi sempre
>> chiamata carta perché costituisce il primo esempio di uso della
>> prospettiva per rappresentare una città. Dietro ci sono le teorie
>> matematiche di Paolo dal Pozzo Toscanelli e la lezione del disegno in
>> prospettiva di Leon Battista Alberti che, seguendo gli stessi metodi,
>> poi realizzò la prima pianta di Roma. Insomma la madre della
>> cartografia moderna in scala, cosa che potrebbe sostenere di usarla
>> per lo spalsh di un moderno software gis (non che la mappa del Molini o
>> eventualmente del Bonsiglnori del 1584 non siano ottime idee).
>>
>> Saluti
>>
>> Iacopo
>> ___
>> QGIS-it-user mailing list
>> QGIS-it-user@lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/qgis-it-user
>>
>
>
> --
> *Ing. Salvatore Fiandaca*
> *mobile*.:+39 327.493.8955
> *m*: *pigrecoinfin...@gmail.com *
> *C.F*.: FNDSVT71E29Z103G
> *P.IVA*: 06597870820
> *membro QGIS Italia - http://qgis.it/ *
> *socio GFOSS.it - *http://gfoss.it/
> *blog:*
> * https://pigrecoinfinito.com/  FB: Co-admin
> - https://www.facebook.com/qgis.it/ **
>  *
> *TW:  **https://twitter.com/totofiandaca
> *
>
> 43°51'0.54"N  10°34'27.62"E - EPSG:4326
>
> “Se la conoscenza deve essere aperta a tutti,
> perchè mai limitarne l’accesso?”
> R. Stallman
>
> Questo documento, allegati inclusi, contiene informazioni di proprietà di
> FIANDACA SALVATORE e deve essere utilizzato esclusivamente dal destinatario
> in relazione alle finalità per le quali è stato ricevuto. E' vietata
> qualsiasi forma di riproduzione o divulgazione senza l'esplicito consenso
> di FIANDACA SALVATORE. Qualora fosse stato ricevuto per errore si prega
> di informare tempestivamente il mittente e distruggere la copia in proprio
> possesso.
>
>
>

-- 
*Ing. Salvatore Fiandaca*
*mobile*.:+39 327.493.8955
*m*: *pigrecoinfin...@gmail.com *
*C.F*.: FNDSVT71E29Z103G
*P.IVA*: 06597870820
*membro QGIS Italia - http://qgis.it/ *
*socio GFOSS.it - *http://gfoss.it/
*blog:*
* https://pigrecoinfinito.com/  FB: Co-admin
- https://www.facebook.com/qgis.it/ **
 *
*TW:  **https://twitter.com/totofiandaca
*

43°51'0.54"N  10°34'27.62"E - EPSG:4326

“Se la conoscenza deve essere aperta a tutti,
perchè mai limitarne l’accesso?”
R. Stallman

Questo documento, allegati inclusi, contiene informazioni di proprietà di
FIANDACA SALVATORE e deve essere utilizzato esclusivamente dal destinatario
in relazione alle finalità per le quali è stato ricevuto. E' vietata
qualsiasi forma di riproduzione o divulgazione senza l'esplicito consenso
di FIANDACA SALVATORE. Qualora fosse stato ricevuto per errore si prega di
informare tempestivamente il mittente e distruggere la copia in proprio
possesso.
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Faster Intersects

[Raymond Nijssen via Qgis-user]

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 mailto:qgis-user-boun...@lists.osgeo.org>> 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://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Faster Intersects

[Dennis Burgess via Qgis-user]

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 
mailto:qgis-user-boun...@lists.osgeo.org>> 
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://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Faster Intersects

[Alexandre Neto via Qgis-user]

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 <
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://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Hire a QGIS Contractor

[Dennis Burgess via Qgis-user]

Looking for a contractor that can either speak with us and/or exchange emails 
in English for QGIS .    Anyone please hit me off-list 


[LTI-Full_175px]
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?
[Gold 
Star][Green
 
Light][Yellow
 
Light][Red
 
Light]

___
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

[Dennis Burgess via Qgis-user]

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

Re: [Qgis-user] Faster Intersects

[Raymond Nijssen via Qgis-user]

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

Re: [Qgis-user] Faster Intersects

[Dennis Burgess via Qgis-user]

Is there a postGIS or other community, I need an automated method to move data 
from MSSQL to POSTGIS for processing? And will postgis run faster than MSSQL?  
Will it use all cores?


[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 11:19 AM
To: Dennis Burgess 
Cc: QGIS User 
Subject: Re: [Qgis-user] Faster Intersects

I don't know what is your data format, but make sure you have spatial index in 
it.

For things with millions of points I would move the data into PostGIS for 
definitely faster processing.

Alexandre Neto
User Support


A sexta, 9/09/2022, 15:50, Dennis Burgess via Qgis-user 
mailto:qgis-user@lists.osgeo.org>> escreveu:
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

Re: [Qgis-user] Faster Intersects

[Alexandre Neto via Qgis-user]

I don't know what is your data format, but make sure you have spatial index
in it.

For things with millions of points I would move the data into PostGIS for
definitely faster processing.

Alexandre Neto
User Support


A sexta, 9/09/2022, 15:50, Dennis Burgess via Qgis-user <
qgis-user@lists.osgeo.org> escreveu:

> 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] QGIS freezes at loading screen

[Torben Kreuzberg via Qgis-user]

Hello everyone, 

 

i have the following problem:

when i try to start QGIS it freezes at the loading screen at last step ("QGIS is ready"/"QGIS ist startklar").

It happens at the start of every project i try to open.

 

The problem appears since i changed from my office into homeoffice. Perhaps it is related to this.

 

If you need any further information just let me know. Have a nice weekend!

 

Greetings

Torben

 

 
___
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] Faster Intersects

[Dennis Burgess via Qgis-user]

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

Re: [QGIS-it-user] il prossimo splashscreen di QGIS sarà dedicato a Firenze

[Totò Fiandaca]

Ciao Iacopo,
grazie per la tua idea e realizzazione dello splashscreen, per favore
aggiungilo al repository (se hai difficoltà, fammelo sapere).

saluti

Il giorno ven 9 set 2022 alle ore 09:28 Iacopo 
ha scritto:

> Sottopongo, per ora in lista, una
> ipotesi:
> https://drive.google.com/file/d/1mZjvVUDM4cEFrOJEo_tEGPe2CBq4IWU1/view?usp=sharing
>
> La carta della catena, che ho utilizzato, è una pietra miliare della
> cartografia. Si tratta in realtà di una vista, ma viene quasi sempre
> chiamata carta perché costituisce il primo esempio di uso della
> prospettiva per rappresentare una città. Dietro ci sono le teorie
> matematiche di Paolo dal Pozzo Toscanelli e la lezione del disegno in
> prospettiva di Leon Battista Alberti che, seguendo gli stessi metodi,
> poi realizzò la prima pianta di Roma. Insomma la madre della
> cartografia moderna in scala, cosa che potrebbe sostenere di usarla
> per lo spalsh di un moderno software gis (non che la mappa del Molini o
> eventualmente del Bonsiglnori del 1584 non siano ottime idee).
>
> Saluti
>
> Iacopo
> ___
> QGIS-it-user mailing list
> QGIS-it-user@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/qgis-it-user
>


-- 
*Ing. Salvatore Fiandaca*
*mobile*.:+39 327.493.8955
*m*: *pigrecoinfin...@gmail.com *
*C.F*.: FNDSVT71E29Z103G
*P.IVA*: 06597870820
*membro QGIS Italia - http://qgis.it/ *
*socio GFOSS.it - *http://gfoss.it/
*blog:*
* https://pigrecoinfinito.com/  FB: Co-admin
- https://www.facebook.com/qgis.it/ **
 *
*TW:  **https://twitter.com/totofiandaca
*

43°51'0.54"N  10°34'27.62"E - EPSG:4326

“Se la conoscenza deve essere aperta a tutti,
perchè mai limitarne l’accesso?”
R. Stallman

Questo documento, allegati inclusi, contiene informazioni di proprietà di
FIANDACA SALVATORE e deve essere utilizzato esclusivamente dal destinatario
in relazione alle finalità per le quali è stato ricevuto. E' vietata
qualsiasi forma di riproduzione o divulgazione senza l'esplicito consenso
di FIANDACA SALVATORE. Qualora fosse stato ricevuto per errore si prega di
informare tempestivamente il mittente e distruggere la copia in proprio
possesso.
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] il prossimo splashscreen di QGIS sarà dedicato a Firenze

[Iacopo]

Sottopongo, per ora in lista, una
ipotesi: 
https://drive.google.com/file/d/1mZjvVUDM4cEFrOJEo_tEGPe2CBq4IWU1/view?usp=sharing

La carta della catena, che ho utilizzato, è una pietra miliare della
cartografia. Si tratta in realtà di una vista, ma viene quasi sempre
chiamata carta perché costituisce il primo esempio di uso della
prospettiva per rappresentare una città. Dietro ci sono le teorie
matematiche di Paolo dal Pozzo Toscanelli e la lezione del disegno in
prospettiva di Leon Battista Alberti che, seguendo gli stessi metodi,
poi realizzò la prima pianta di Roma. Insomma la madre della
cartografia moderna in scala, cosa che potrebbe sostenere di usarla
per lo spalsh di un moderno software gis (non che la mappa del Molini o
eventualmente del Bonsiglnori del 1584 non siano ottime idee).

Saluti

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

Re: [Qgis-user] Using QGIS Server python API from system's default Python

[Alessandro Pasotti via Qgis-user]

Probably not the answer you are looking for but I strongly recommend
you to use Linux for development and deployment (a virtual machine
will work just fine): it will make your developer life much easier.

We (https://github.com/g3w-suite/g3w-admin) have a Django-based
application with QGIS API embedded, it works very well and I can
recommend that approach.

Kind regards.



On Fri, Sep 9, 2022 at 5:13 AM MA via Qgis-user
 wrote:
>
> Hello,
>
> I'm starting to investigate and decide how to manage QGIS server access
> from within a Django project.
>
> The EMBEDDING option looks amazing for this I think but I'm having
> issues (as expected). Tried to make symlinks of python QGIS from OSGEO4W
> to my default /site-packages/ dir and it seems to work, except the PyQt
> part. Tried installing PyQt to same version Qgis uses (using the output
> version mismatch from error messages), but still not, can't start the
> server.
>
> There are common workarounds people uses to circumvent this?
>
> In my case if the option is to move all the framework to inside OSGEO4W
> python then my option will be trying  other approaches like creating
> python plugins for the scheme I need.
>
> So I'm hoping using it the way I described initially is feasible/possible.
>
> Thanks!
>
> Rodrigo
>
>
> ___
> 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



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
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