Re: [Qgis-user] question about DATE of satellite ESRI and Google basemaps in QuickMapServices Plugin

[Nicolas Cadieux via Qgis-user]

Hi,

Google earth has a slider option for selecting date but I have never seen this 
in a plugin. They always seem you show the latest version of the  scenes.  You 
will likely always  have a mix of dates in the images in Google earth because 
they seem to make spatial resolution the priority. As a result, you get winter 
scenes stitches with summer scenes in Canada were I work.   Not sure about the 
ESRI server…

If you need a good control on the date, you should download the images from the 
providers (like Nasa). That may cost you an arm and a leg for some plateformes. 
Some are free, some you must pay for.  It depends on what you need.

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 10 mars 2022 à 13:44, Nick Jadallah via Qgis-user 
>  a écrit :
> 
> 
> Hello, 
> 
> I have installed QuickMapServices for QGIS to have more basemap options. I 
> have used the "Google Satellite" and "ESRI Satellite" basemaps. It just 
> occurred to me that the YEAR in which these maps were published (i.e. which 
> year the satellite image data is from) is important for my project. Do you 
> know what year they are from? Or, if not, do you know where I can find this 
> information? 
> 
> Thank you very much for any help or guidance you can provide! 
> 
> 
> -Nick
> ___
> 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] question about DATE of satellite ESRI and Google basemaps in QuickMapServices Plugin

[Greg Troxel via Qgis-user]

Nick Jadallah via Qgis-user  writes:

> I have installed QuickMapServices for QGIS to have more basemap options. I
> have used the "Google Satellite" and "ESRI Satellite" basemaps. It just
> occurred to me that the YEAR in which these maps were published (i.e. which
> year the satellite image data is from) is important for my project. Do you
> know what year they are from? Or, if not, do you know where I can find this
> information?

When you read the Terms of Service for the Google maps to be sure your
use was within them*, did you notice contact information where you could
ask this?

* I haven't read them, because I assume my use is outside the TOS and
  just don't use Google map layers at all within qgis/webmaps.


signature.asc
Description: PGP signature
___
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

[Mike Breiding - Morgantown WV via Qgis-user]

  
  
I am so far out of
my depth here there is no measurement for it.

Thanks to all...
WV-Mike


On 3/10/2022 11:04 AM, chris hermansen wrote:
  

  
  
Mike and list,
  



  On Thu,
  Mar 10, 2022 at 5:07 AM Mike Breiding - Morgantown WV via
  Qgis-user 
  wrote:

  

  I appreciate you taking the time
  for writing such a detailed set of instructions.
  However, it is quicker for me to do it manually.
 
  If the process could be automated then of course it
  would be a different matter.
  I am working only with the ferns - less than a hundred
  records.
  The flower plants are over 2500.


  
  

  Perhaps others are better
  understanding how you want to visualize the distributions,
  but what I get from your description is that if you have
  100 (or 2500) species then you will have 100 (or 2500)
  maps, which sounds unwieldy to me.
  

  This paper https://www.sciencedirect.com/science/article/pii/S1574954116300097
  might have some interesting suggestions for you.
  

  Taken as a database design question,
  the idea of having 100 columns to record the presence or
  absence of each species is not elegant.  A more normalized
  approach would be to have your geometry table (geometry of
  counties and unique key, perhaps county name) and a
  separate table with multiple rows per county, one for each
  species present, along with the county unique key, and
  then a one-to-many table join between the two.

  

  Of course this doesn't necessarily
  help with the business of visualizing the data...

  


  
  -- 


  Chris Hermansen ·
  clhermansen "at" gmail "dot" com
  
  C'est ma façon de parler.

  



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

[Bernd Vogelgesang via Qgis-user]

Attachments are allowed, but you have to keep it under 100kb! So better sth 
like 50kb, if you also have a lot of textwith it

On 09.03.22 18:07, Mike Breiding - Morgantown WV via Qgis-user 
 wrote:

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 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] question about DATE of satellite ESRI and Google basemaps in QuickMapServices Plugin

[Bernd Vogelgesang via Qgis-user]

Hi,

I can remember that there was this question a while ago. Though I do not 
remember the answer.

But my guess is, that in Google Earth e.a. , you are shown the year of the 
picture, while those in Google Maps e.g. are sometimes different, and there is 
no way to find out how old they are.

Maybe for the ESRI-stuff you might have more luck using their REST-service to 
load those images (did this lng time ago, have no clue anymore)


Cheers,

Bernd

On 10.03.22 19:44, Nick Jadallah via Qgis-user  
wrote:

Hello,

I have installed QuickMapServices for QGIS to have more basemap options.
I have used the "Google Satellite" and "ESRI Satellite" basemaps. It
just occurred to me that the YEAR in which these maps were published
(i.e. which year the satellite image data is from) is important for my
project. Do you know what year they are from? Or, if not, do you know
where I can find this information?

Thank you very much for any help or guidance you can provide!


-Nick

___
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] question about DATE of satellite ESRI and Google basemaps in QuickMapServices Plugin

[Nick Jadallah via Qgis-user]

Hello,

I have installed QuickMapServices for QGIS to have more basemap options. I
have used the "Google Satellite" and "ESRI Satellite" basemaps. It just
occurred to me that the YEAR in which these maps were published (i.e. which
year the satellite image data is from) is important for my project. Do you
know what year they are from? Or, if not, do you know where I can find this
information?

Thank you very much for any help or guidance you can provide!


-Nick
___
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

[Bernd Vogelgesang via Qgis-user]

As long as the informations are this vague and we do not know what his
data-sets looks alike, there is no use in proposing a workflow.

The spreadsheet approach sounds horrible to me ;)

Bernd


Am 10.03.22 um 18:49 schrieb Nicolas Cadieux via Qgis-user:

Hi,

I’am not quite sure what processes you want automated but if the step
previously described suit your needs, then all the steps could be
incorporated into a model and this model, like any algorithm found in
« processing » can be batched.

Nicolas Cadieux
https://gitlab.com/njacadieux


Le 10 mars 2022 à 08:07, Mike Breiding - Morgantown WV via Qgis-user
 a écrit :


I appreciate you taking the time for writing such a detailed set of
instructions.
However, it is quicker for me to do it manually.

If the process could be automated then of course it would be a
different matter.
I am working only with the ferns - less than a hundred records.
The flower plants are over 2500.

Thanks,
WV-Mike
=
On 3/9/2022 3:46 PM, David Strip wrote:

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.


-- 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


___
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

[chris hermansen via Qgis-user]

Mike and list,

On Thu, Mar 10, 2022 at 5:07 AM Mike Breiding - Morgantown WV via Qgis-user
 wrote:

> I appreciate you taking the time for writing such a detailed set of
> instructions.
> However, it is quicker for me to do it manually.
>
> If the process could be automated then of course it would be a different
> matter.
> I am working only with the ferns - less than a hundred records.
> The flower plants are over 2500.
>

Perhaps others are better understanding how you want to visualize the
distributions, but what I get from your description is that if you have 100
(or 2500) species then you will have 100 (or 2500) maps, which sounds
unwieldy to me.

This paper
https://www.sciencedirect.com/science/article/pii/S1574954116300097 might
have some interesting suggestions for you.

Taken as a database design question, the idea of having 100 columns to
record the presence or absence of each species is not elegant.  A more
normalized approach would be to have your geometry table (geometry of
counties and unique key, perhaps county name) and a separate table with
multiple rows per county, one for each species present, along with the
county unique key, and then a one-to-many table join between the two.

Of course this doesn't necessarily help with the business of visualizing
the data...


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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,

I’am not quite sure what processes you want automated but if the step 
previously described suit your needs, then all the steps could be incorporated 
into a model and this model, like any algorithm found in « processing » can be 
batched.

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 10 mars 2022 à 08:07, Mike Breiding - Morgantown WV via Qgis-user 
>  a écrit :
> 
> 
> I appreciate you taking the time for writing such a detailed set of 
> instructions.
> However, it is quicker for me to do it manually.
> 
> If the process could be automated then of course it would be a different 
> matter.
> I am working only with the ferns - less than a hundred records.
> The flower plants are over 2500.
> 
> Thanks,
> WV-Mike
> =
>> On 3/9/2022 3:46 PM, David Strip wrote:
>> 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.
> 
>  -- 
> 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
___
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

[chris hermansen via Qgis-user]

Mauricio and list

On Thu, Mar 10, 2022, 05:21 Mauricio Vieira Cardoso Filho via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hi Andreas,
> Thanks for the info.
> I did the configuration you suggested, but the QGis was very slow. I'll
> see what I can configure inside PGBouncer to minimize this amount of
> connections.
>

Is the configuration slow when there is only one user? When there are 2, or
3? Is there a sharp drop in performance at some point?

>
May be worthwhile as well to check the amount of memory set aside per
connection in the PostgreSQL configuration.

Is your server running Linux or Windows or ...? Is it powerful enough to
support a lot of users?

Chris
___
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] Valori multipli in singola cella e ricercabili in Lizmap WC

[Roberto Brazzelli]

Ciao a tutti,
in una tabella se volessi raggruppare le righe evidenziate sotto in
un'unica riga dove per i campi che hanno valore uguale non c'è problema,
rimane quel singolo valore, ma dove i valori sono diversi vorrei riportarli
tutti in sequenza nella stessa cella ma in modo tale che siano poi
ricercabili individualmente (es. C21-01-008) con filtri in qgis ed anche
con i filtri x campo in Lizmap Webclient.

Grazie
Roberto


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

Re: [Qgis-user] QGIS - repeated connections

[Mauricio Vieira Cardoso Filho via Qgis-user]

Hi Andreas,
Thanks for the info.
I did the configuration you suggested, but the QGis was very slow. I'll see
what I can configure inside PGBouncer to minimize this amount of
connections.
Thank you all for the support and guidance.

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


Em qua., 9 de mar. de 2022 às 09:17, Andreas Neumann 
escreveu:

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

[Mike Breiding - Morgantown WV via Qgis-user]

  
  
I appreciate you
taking the time for writing such a detailed set of instructions.
However, it is quicker for me to do it manually.

If the process could be automated then of course it would be a
different matter.
I am working only with the ferns - less than a hundred records.
The flower plants are over 2500.

Thanks,
WV-Mike
=
On 3/9/2022 3:46 PM, David Strip wrote:
  

  
   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.
   


-- 
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

[Qgis-user] What happened to "Update SQL Layer"?

[Jonathan Schultz via Qgis-user]

I notice that sometime in the last few months the "Update SQL Layer" 
option that used to be accessible by right-clicking on a layer in the 
Layers Panel seems to have disappeared. (I'm not running QGUS 3.24.0) I 
used to find this function extremely useful for writing some extra SQL 
rather than being limited to a PostGIS table as is. The "Change Data 
Source" doesn't help as it offers no option to tweak the SQL. Is this 
function no longer available?


Thanks,
Jonathan
___
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] Riempimento null data

[pierluigi de rosa]

Grazie Andrea

il parametro DISTANCE effettivamente influisce sul risultato ed
aumentandolo a dismisura riesco ad ottenere un raster senza buchi.
Adesso ho un dubbio: volendo implementare il tool gdag:fillnodata in uno
script come faccio a determinare il valore DISTANCE corretto che riempie
effettivamente tutti i buchi?
Grazie
P

Il giorno gio 10 mar 2022 alle ore 09:45 Andrea Giudiceandrea <
andreaer...@libero.it> ha scritto:

> Ciao Pierluigi,
> Hai già visto le descrizioni del tool in QGIS [1] e di quello di GDAL su
> cui è basato [2]?
> come hai settato i parametri del tool e in particolare il parametro
> DISTANCE?
>
> A presto.
>
> Andrea
>
>
> [1]
>
> https://docs.qgis.org/3.22/en/docs/user_manual/processing_algs/gdal/rasteranalysis.html#fill-nodata
> [2] https://gdal.org/programs/gdal_fillnodata.html
>
> Il 10/03/2022 08:56, pierluigi de rosa ha scritto:
> > Buongiorno a tutti,
> > ho una domanda sul tool di processing gdal:fillnodata.
> ___
> QGIS-it-user mailing list
> QGIS-it-user@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/qgis-it-user
>


-- 
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