[QGIS-it-user] Riempimento null data

[pierluigi de rosa]

Buongiorno a tutti,
ho una domanda sul tool di processing gdal:fillnodata.
Esso permette di riempire le celle nulle di un raster attraverso una
interpolazione IDW dei valori vici.
Si tratta di un tool di apparente semplice utilizzo ma non ho capito perchè
nei vuoti più gradi (ho un vuoto di circa 250 celle) non riesce a riempirlo
completamente. se ne riduce la dimensione ma non si riempie del tutto.
Dove sbaglio?
grazie a tutti
P

-- 
Ing. Pierluigi De Rosa (PhD in Earth Science)
Contract Professor of Geographic Information System at University of Perugia
cel: 3497558268 / fax: 075 7823038
skype: pierluigi.derosa
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Automating creation of county distribution maps

[David Strip via Qgis-user]

  
  
As first step towards building a model as Nicolas has suggested:
I assume you have a layer with the county boundaries. Export this
layer as a CSV file, keeping only the name of each county in the
export step, and don't export the geometry.
Now open this file in your spreadsheet app of choice.
Add a new column for each plant species.
Put a one in that column for each county where the species is
present.
Save the file (still as CSV).

Open the county layer and the new CSV files in Ggis.
Open the properties window for the county layer and click on the
Joins tab.
Click on the "+" to add a new join. Join to the CSV layer, and
select the county names field as the join field for each.

Now your county layer has the plant species column.
To display a single species, open the properties window for the
county layer, select symbology. Set the symbology as rule based. To
color just those counties with species 1, your rule would say
something like Species1 = 1, where Species1 is the field name you
used. Pick a color/transparency of your choice, then set the "all
others" rules to be the background color you want.

That does it for one species. You can then export to tiff or
whatever. Getting it to cycle through all the different species is
for someone else to explain.
  

___
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] Model Designer - GDAL - Vector Conversion

[Nicolas Cadieux via Qgis-user]

Hi,
To my knowledge, the tab file does not need a FID column to work.  I may be 
wrong but a geopackage must have a FID column.  I am sure you could create that 
field afterwards in the model or create a geopackage and then a tab file.  

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 8 mars 2022 à 18:54, Johanna Botman via Qgis-user 
>  a écrit :
> 
> 
> Hi Brent,
> I think that is the way that I have to go. I was hoping that it would be a 
> good use of the Modeller
>  
> Johanna Botman
>  
> Assets / GIS Officer – Melton City Council
>  
>  
>  
> From: Brent Wood  
> Sent: Wednesday, 9 March 2022 10:50 AM
> To: qgis-user@lists.osgeo.org; Johanna Botman 
> Subject: Re: Model Designer - GDAL - Vector Conversion
>  
> You don't often get email from brent.w...@niwa.co.nz. Learn why this is 
> important
> Have you considered a script or batch file using ogr2ogr to do this for you?
>  
> Brent Wood
> 
> Principal Technician, Fisheries
> NIWA
> DDI:  +64 (4) 3860529
> From: Qgis-user  on behalf of Johanna 
> Botman via Qgis-user 
> Sent: Wednesday, March 9, 2022 12:41
> To: qgis-user@lists.osgeo.org 
> Subject: [Qgis-user] Model Designer - GDAL - Vector Conversion
>  
> I am trying to use the Model Designer to automate the creation of Tab files 
> from SQL Database Tables.
> I am using GDAL – Vector Conversion – Convert format
> The resulting Tab file is missing the Primary Key field.
> If use that same algorithm to export to a Geopackage, the PK is there.
> I know that I can right click the SQL Table and select Export. That Tab file 
> contains the PK. I need to export 30 tables so am looking for some automation.
>  
> Why does the algorithm produce a table without the key field?
>  
>  
>  
> Johanna Botman
>  
> Assets / GIS Officer – Melton City Council
>  
>  
>  
>  
>  
> 
> ***
> The information in this message is privileged and confidential, intended only 
> for the use of the individual or entity named above. If you are not the 
> intended recipient you are hereby notified to delete the message and that any 
> dissemination, copying or use of its content is strictly prohibited. If you 
> have received this message in error please notify the Melton City Council.
> ***
> 
> 
> Brent Wood 
> Principal Technician - GIS and Spatial Data Management
> Programme Leader - Environmental Information Delivery
> +64-4-386-0529
> 
> National Institute of Water & Atmospheric Research Ltd (NIWA)
> 301 Evans Bay Parade Hataitai Wellington New Zealand
> Connect with NIWA: niwa.co.nz Facebook LinkedIn Twitter Instagram
> To ensure compliance with legal requirements and to maintain cyber security 
> standards, NIWA's IT systems are subject to ongoing monitoring, activity 
> logging and auditing. This monitoring and auditing service may be provided by 
> third parties. Such third parties can access information transmitted to, 
> processed by and stored on NIWA's IT systems
> 
> ***
> The information in this message is privileged and confidential, intended only 
> for the use of the individual or entity named above. If you are not the 
> intended recipient you are hereby notified to delete the message and that any 
> dissemination, copying or use of its content is strictly prohibited. If you 
> have received this message in error please notify the Melton City Council.
> ***
> 
> ___
> 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] Automating creation of county distribution maps

[Nicolas Cadieux via Qgis-user]

Hi,

As a newbie, I would start doing is once by hand.  Then, the easiest way is to 
create a model. You can create a model in the processing plugin.  Make sure the 
plugin is activated and the panel opened. A model can permit you to link a 
number of algorithms together.  The other way is to go with python but that is 
more complicated.

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 9 mars 2022 à 12:06, Mike Breiding - Morgantown WV via Qgis-user 
>  a écrit :
> 
> Greetings,
> I want to create distribution maps by county occurrence for plant species 
> found in West Virginia.
> 
> What I hope is possible is to load all the county names where a specific 
> species occurs and then have a county map of West Virginia generated with the 
> counties where the species occurs shaded to a particular grey shade and 
> transparency.
> 
> And, while I am wishful thinking it would then be nice to have the output 
> saved to a new layer and then made to a tiff file. All automated a much as 
> possible.
> 
> If I do this manually I have to load the county outline and read a list of 
> county occurrence and then select each one , save to a new layer, choose the 
> shading color and transparency and then take a screen shot of the map area.
> 
> NOTE: I am newbie so if someone comes up with a way to do this I may or may 
> not understand what they are talking about.
> 
> 
> Thanks,
> WV-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

[QGIS-it-user] Popup menu tasto destro in Qgis

[Franco Cazzola]

Buongiorno a tutti

è possibile nascondere/eliminare delle voci dal menu di popup che viene 
visualizzato con il tasto dx del mouse su un tematismo nel pannello Layer ?

Vorrei nascondere le voci: rimuovi Layer, Attiva Modifiche, ecc


[cid:28e0dfbb-bc77-423c-bf96-3a60bcafbf1f]

S.O. Windows 10

QGis 3.16


Grazie

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

Re: [Qgis-user] Hello, new to QGIS

[Alessandro Pasotti via Qgis-user]

Hi,

you have several options: you can store the QGIS project on a remote
postgres DB and provided that the layer's data is also stored in a remote
accessible DB you should be ready to go.

If the data are stored on disk, you'll have to transfer them to the server
in order to have them accessible on the server.

Of course if you have other filesystem-based assets used by your project
(icons, svgs etc.) you need to transfer them as well, keeping paths
relative to the project path will make everything easier in that regard.

If you don't want/can store the project in the remote postgres DB you can
transfer the project and all other filesystem-based assets to the server.


Kind regards




On Wed, Mar 9, 2022 at 8:02 PM Ben Siewert via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hello,
>
> I'm new to QGIS. I'm a web developer and helping a friend with a QGIS
> project.
>
> I'm wondering how I can sync a local QGIS desktop project with a QGIS
> server.
>
> One thing I'm really confused about is on the QGIS server documentation, I
> need the url to point to a file (world.qgs in the docs, link here
> 
> ).
>
> So my question is:
>
> In order to sync project changes from the Desktop app to the server, do I
> need to only connect to the remote Postgres database? Or do I also need to
> upload this file and point the url to it?
>
> Or is it possible to only have to sync the database?
>
> Thanks a ton in advance, and I'm pretty impressed with this project!
>
> Ben
> ___
> 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

[Qgis-user] Hello, new to QGIS

[Ben Siewert via Qgis-user]

Hello,

I'm new to QGIS. I'm a web developer and helping a friend with a QGIS
project.

I'm wondering how I can sync a local QGIS desktop project with a QGIS
server.

One thing I'm really confused about is on the QGIS server documentation, I
need the url to point to a file (world.qgs in the docs, link here

).

So my question is:

In order to sync project changes from the Desktop app to the server, do I
need to only connect to the remote Postgres database? Or do I also need to
upload this file and point the url to it?

Or is it possible to only have to sync the database?

Thanks a ton in advance, and I'm pretty impressed with this project!

Ben
___
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] Attachment and links used for this list.

[Mike Breiding - Morgantown WV via Qgis-user]

  
  
Apparently attachments are not permitted and
  HTML links are scrubbed.
  How does one share a graphic with the list?
  WV-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] Automating creation of county distribution maps

[Mike Breiding - Morgantown WV via Qgis-user]

Greetings,
I want to create distribution maps by county occurrence for plant 
species found in West Virginia.


What I hope is possible is to load all the county names where a specific 
species occurs and then have a county map of West Virginia generated 
with the counties where the species occurs shaded to a particular grey 
shade and transparency.


And, while I am wishful thinking it would then be nice to have the 
output saved to a new layer and then made to a tiff file. All automated 
a much as possible.


If I do this manually I have to load the county outline and read a list 
of county occurrence and then select each one , save to a new layer, 
choose the shading color and transparency and then take a screen shot of 
the map area.


NOTE: I am newbie so if someone comes up with a way to do this I may or 
may not understand what they are talking about.



Thanks,
WV-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] Automating creation of county distribution maps

[Mike Breiding - Morgantown WV via Qgis-user]

  
  
 Greetings,
  I want to create distribution maps by county occurrence for plant
  species found in West Virginia.
  
  What I hope is possible is to load all the county names where a
  specific species occurs and then have a county map of West
  Virginia generated with the counties where the species occurs
  shaded to a particular grey shade and transparency.
  
  And, while I am wishful thinking it would then be nice to have the
  output saved to a new layer and then made to a tiff file. All
  automated a much as possible.
  
  If I do this manually I have to load the county outline and read a
  list of county occurrence and then select each one , save to a new
  layer, choose the shading color and transparency and then take a
  screen shot of the map area.
  
  NOTE: I am newbie so if someone comes up with a way to do this I
  may or may not understand what they are talking about.
  
  I have attached a screen shot which I hope makes it through.
  
  Thanks,
  WV-Mike

-- 
Mike Breiding
www.EpicRoadTrips.us
 
  

___
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 - repeated connections

[Andreas Neumann via Qgis-user]

Hi,

Yes, you can limit the nr of CPU cores that render in QGIS - and this 
will limit the PG connections.


Menu "Settings" --> "Options" --> "Rendering".

If you disable the checkbox "Render layers in parallel using many CPU 
cores", this will force QGIS to go single threaded for drawing - or you 
can use the setting to the right of it and set it to use max 2 CPU 
cores, which will restrict it to two connectsions max.


The much better solution, however, would be to use a connection pool 
solution (like pgBouncer). Then the idle connections will be temporarily 
disconnected from the PG server. See the pgBouncer documentation.


Greetings,

Andreas

On 2022-03-09 12:23, Mauricio Vieira Cardoso Filho via Qgis-user wrote:


Hi Alexandre,
Thanks for the answer. Is there any way to prevent this from happening? 
- I ask because I have many users who connect to the postgres database 
through QGIS and for each user connection, it is generating five 
connection sessions in the database. And that has killed Postgres's 
performance. Is there a way to prevent QGIS from generating this amount 
of connections?


Best Regards

Maurício Vieira Cardoso Filho
Gerente TI Infra
Tel: +556137995051
email : mcard...@topocart.com.br;
skype: mauricio.cardoso1974

Em ter., 8 de mar. de 2022 às 23:36, Alexandre Neto 
 escreveu:

Hello Mauricio,

That is "normal". Several different components of QGIS can establish 
different and independent connections to PostgreSQL. For example, the 
browser panel can create a connection, the database manager another, 
and so on.


Alexandre Neto

A terça, 8/03/2022, 20:14, Mauricio Vieira Cardoso Filho via Qgis-user 
 escreveu:
I use QGIS 3.16 and I'm having an operation that I believe to be 
abnormal. I use QGIS connected to a postgres database. My problem is 
that QGIS is creating five simultaneous connections for each database 
user. (For example, when opening qgis and connecting to the bank, on my 
server I have five connections created with my username). Does anyone 
have any idea what could be happening?


Best

Maurício Vieira Cardoso Filho
Gerente TI Infra
Tel: +556137995051
email : mcard...@topocart.com.br;
skype: mauricio.cardoso1974 
___

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] Model Designer - GDAL - Vector Conversion

[Richard Duivenvoorde via Qgis-user]

On 3/9/22 00:41, Johanna Botman via Qgis-user wrote:

I am trying to use the Model Designer to automate the creation of Tab files 
from SQL Database Tables.

I am using GDAL – Vector Conversion – Convert format

The resulting Tab file is missing the Primary Key field.

If use that same algorithm to export to a Geopackage, the PK is there.

I know that I can right click the SQL Table and select Export. That Tab file 
contains the PK. I need to export 30 tables so am looking for some automation.

Why does the algorithm produce a table without the key field?


Hi Johanna,

Are you using 'Convert Format' which 'uses' ogr2ogr to convert?

Because in that dialog you can add 'Advanced parameters' and if I am right you 
can add specific driver params there.

The 'tab'-driver though:
https://gdal.org/drivers/vector/mitab.html
does not mention a primary key...

I also found:
https://github.com/OSGeo/gdal/issues/2651
which mentions a  -preserve_fid (advanced param)
see https://gdal.org/programs/ogr2ogr.html

So you can actually add some specific gdal params there...?

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-user] QGIS - repeated connections

[Mauricio Vieira Cardoso Filho via Qgis-user]

Hi Alexandre,
Thanks for the answer. Is there any way to prevent this from happening? - I
ask because I have many users who connect to the postgres database through
QGIS and for each user connection, it is generating five connection
sessions in the database. And that has killed Postgres's performance. Is
there a way to prevent QGIS from generating this amount of connections?

Best Regards

Maurício Vieira Cardoso Filho
Gerente TI Infra
Tel: +556137995051
email : mcard...@topocart.com.br;
skype: mauricio.cardoso1974


Em ter., 8 de mar. de 2022 às 23:36, Alexandre Neto 
escreveu:

> Hello Mauricio,
>
> That is "normal". Several different components of QGIS can establish
> different and independent connections to PostgreSQL. For example, the
> browser panel can create a connection, the database manager another, and so
> on.
>
> Alexandre Neto
>
> A terça, 8/03/2022, 20:14, Mauricio Vieira Cardoso Filho via Qgis-user <
> qgis-user@lists.osgeo.org> escreveu:
>
>> I use QGIS 3.16 and I'm having an operation that I believe to be
>> abnormal. I use QGIS connected to a postgres database. My problem is that
>> QGIS is creating five simultaneous connections for each database user. (For
>> example, when opening qgis and connecting to the bank, on my server I have
>> five connections created with my username). Does anyone have any idea what
>> could be happening?
>>
>> Best
>> Maurício Vieira Cardoso Filho
>> Gerente TI Infra
>> Tel: +556137995051
>> email : mcard...@topocart.com.br;
>> skype: mauricio.cardoso1974
>> ___
>> 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