Re: [Qgis-user] Importing spreadsheet: Strange behaviour

2022-03-13 Thread Bernd Vogelgesang via Qgis-user 

Hi Andrea,

thanx for clarifying.

imho this is not a "wise" design decision. Maybe I am too less a pro,
but i can't think of any situation when someone seriously working with
table data does NOT want to have a column header. What would be the
advantage of that?

Ok, if this is a GDAL-design decision, then at least QGIS should have
default settings in the environment preventing this.

An ordinary user will never ever expect this behaviour nor find this
setting by himself.

Cheers,

Bernd


Am 13.03.22 um 08:55 schrieb Andrea Giudiceandrea:

*Bernd Vogelgesang*
/Sat Mar 12 14:13:04 PST 2022/

So: All-string tables will not be imported correctly. Always e.g. add an
id-field with number


Hi Bernd,
this is by design:
https://github.com/OSGeo/gdal/blob/1c5bc766513c4407f702bd8cd8bfa958ed61cfea/ogr/ogrsf_frmts/xlsx/ogrxlsxdatasource.cpp#L597-L598

Am 12.03.22 um 23:04 schrieb Jonas Küpper://

>/what should have fixed it as well would be to pass OGR_XLSX_HEADERS = />/FORCE 
to the provider while loading xlsx-files but a i couldn't find a />/way how to do 
that. (see https://gdal.org/drivers/vector/xlsx.html) /


Hi Jonas,
you can set a GDAL/OGR configuration option, like OGR_XLSX_HEADERS,
via the "Settings" -> "Options" -> "System" -> "Environment" setting
panel in QGIS.

Regards.

Andrea Giudiceandrea
___
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] Importing spreadsheet: Strange behaviour

2022-03-13 Thread Micha Silver via Qgis-user 

  
  


On 13/03/2022 10:22, Bernd Vogelgesang
  via Qgis-user wrote:


  
  Hi Andrea,
  thanx for clarifying.
  imho this is not a "wise" design decision. Maybe I am too less
a pro, but i can't think of any situation when someone seriously
working with table data does NOT want to have a column header.
What would be the advantage of that?



There are situations where the data table contains only data: no
  column headers. 




  Ok, if this is a GDAL-design decision, then at least QGIS
should have default settings in the environment preventing this.
  An ordinary user will never ever expect this behaviour nor find
this setting by himself.
  Cheers,
  Bernd
  
  
  
  Am 13.03.22 um 08:55 schrieb Andrea
Giudiceandrea:
  
  

Bernd Vogelgesang
  Sat Mar 12 14:13:04 PST 2022
  
  So: All-string tables will not be imported correctly. Always e.g. add an
id-field with number



Hi Bernd,
this is by design: https://github.com/OSGeo/gdal/blob/1c5bc766513c4407f702bd8cd8bfa958ed61cfea/ogr/ogrsf_frmts/xlsx/ogrxlsxdatasource.cpp#L597-L598

Am 12.03.22 um 23:04 schrieb Jonas Küpper: 

  > what should have fixed it as well would be to pass OGR_XLSX_HEADERS =
> FORCE to the provider while loading xlsx-files but a i couldn't find a
> way how to do that. (see https://gdal.org/drivers/vector/xlsx.html)



Hi Jonas,
you can set a GDAL/OGR configuration option, like
OGR_XLSX_HEADERS, via the "Settings" -> "Options" ->
"System" -> "Environment" setting panel in QGIS.

Regards.

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


-- 
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918
  

___
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] Importing spreadsheet: Strange behaviour

2022-03-13 Thread Bernd Vogelgesang via Qgis-user 

Hi Micha,


can you elobrate a bit more on these situations where the data has no
column header, cause I don't know them.


Bernd


Am 13.03.22 um 09:35 schrieb Micha Silver:



On 13/03/2022 10:22, Bernd Vogelgesang via Qgis-user wrote:


Hi Andrea,

thanx for clarifying.

imho this is not a "wise" design decision. Maybe I am too less a pro,
but i can't think of any situation when someone seriously working
with table data does NOT want to have a column header. What would be
the advantage of that?



There are situations where the data table contains only data: no
column headers.



Ok, if this is a GDAL-design decision, then at least QGIS should have
default settings in the environment preventing this.

An ordinary user will never ever expect this behaviour nor find this
setting by himself.

Cheers,

Bernd


Am 13.03.22 um 08:55 schrieb Andrea Giudiceandrea:

*Bernd Vogelgesang*
/Sat Mar 12 14:13:04 PST 2022/

So: All-string tables will not be imported correctly. Always e.g. add an
id-field with number


Hi Bernd,
this is by design:
https://github.com/OSGeo/gdal/blob/1c5bc766513c4407f702bd8cd8bfa958ed61cfea/ogr/ogrsf_frmts/xlsx/ogrxlsxdatasource.cpp#L597-L598

Am 12.03.22 um 23:04 schrieb Jonas Küpper://

>/what should have fixed it as well would be to pass OGR_XLSX_HEADERS = 
/>/FORCE to the provider while loading xlsx-files but a i couldn't
find a />/way how to do that. (see https://gdal.org/drivers/vector/xlsx.html) /


Hi Jonas,
you can set a GDAL/OGR configuration option, like OGR_XLSX_HEADERS,
via the "Settings" -> "Options" -> "System" -> "Environment" setting
panel in QGIS.

Regards.

Andrea Giudiceandrea


___
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

--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918
___
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] Importing spreadsheet: Strange behaviour

2022-03-13 Thread Micha Silver via Qgis-user 


On 13/03/2022 10:37, Bernd Vogelgesang wrote:


Hi Micha,


can you elobrate a bit more on these situations where the data has no 
column header, cause I don't know them.





Well, just a few theoretical examples:

I might have several tables of data from some sensor (i.e. rainfall, 
temperature) with dates, long/lat and column headers. Merging all the 
tables would cause the column headers to get repeated for each table. I 
usually just remove *all* column headers, then import, and point to the 
correct columns for long/lat.



When I extract values from a multiband raster at point locations (for 
some ML model) I get just columns of values; the actual column names are 
not important.



Hope that clarifies.



Bernd


Am 13.03.22 um 09:35 schrieb Micha Silver:



On 13/03/2022 10:22, Bernd Vogelgesang via Qgis-user wrote:


Hi Andrea,

thanx for clarifying.

imho this is not a "wise" design decision. Maybe I am too less a 
pro, but i can't think of any situation when someone seriously 
working with table data does NOT want to have a column header. What 
would be the advantage of that?




There are situations where the data table contains only data: no 
column headers.



Ok, if this is a GDAL-design decision, then at least QGIS should 
have default settings in the environment preventing this.


An ordinary user will never ever expect this behaviour nor find this 
setting by himself.


Cheers,

Bernd


Am 13.03.22 um 08:55 schrieb Andrea Giudiceandrea:

*Bernd Vogelgesang*
/Sat Mar 12 14:13:04 PST 2022/

So: All-string tables will not be imported correctly. Always e.g. add an
id-field with number


Hi Bernd,
this is by design: 
https://github.com/OSGeo/gdal/blob/1c5bc766513c4407f702bd8cd8bfa958ed61cfea/ogr/ogrsf_frmts/xlsx/ogrxlsxdatasource.cpp#L597-L598


Am 12.03.22 um 23:04 schrieb Jonas Küpper://
>/what should have fixed it as well would be to pass 
OGR_XLSX_HEADERS = />/FORCE to the provider while loading xlsx-files but a i couldn't 
find a />/way how to do that. (see https://gdal.org/drivers/vector/xlsx.html) /


Hi Jonas,
you can set a GDAL/OGR configuration option, like OGR_XLSX_HEADERS, 
via the "Settings" -> "Options" -> "System" -> "Environment" 
setting panel in QGIS.


Regards.

Andrea Giudiceandrea


___
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

--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918


--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918

___
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] Centra la vista in un punto

2022-03-13 Thread SB via Qgis-user 
Quale plugin installare per interrogare la mappa partendo dalle coordinate x e 
y ed ottenere ò'indicazione del punto sulla mappa?___
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] Importing spreadsheet: Strange behaviour

2022-03-13 Thread Bernd Vogelgesang via Qgis-user 

Hi Micha,

thank you.

And where in this theoretical situation exactly do you use drag and drop
of spreadsheets to the canvas in this process?

Bernd


Am 13.03.22 um 09:56 schrieb Micha Silver:


On 13/03/2022 10:37, Bernd Vogelgesang wrote:


Hi Micha,


can you elobrate a bit more on these situations where the data has no
column header, cause I don't know them.




Well, just a few theoretical examples:

I might have several tables of data from some sensor (i.e. rainfall,
temperature) with dates, long/lat and column headers. Merging all the
tables would cause the column headers to get repeated for each table.
I usually just remove *all* column headers, then import, and point to
the correct columns for long/lat.


When I extract values from a multiband raster at point locations (for
some ML model) I get just columns of values; the actual column names
are not important.


Hope that clarifies.



Bernd


Am 13.03.22 um 09:35 schrieb Micha Silver:



On 13/03/2022 10:22, Bernd Vogelgesang via Qgis-user wrote:


Hi Andrea,

thanx for clarifying.

imho this is not a "wise" design decision. Maybe I am too less a
pro, but i can't think of any situation when someone seriously
working with table data does NOT want to have a column header. What
would be the advantage of that?



There are situations where the data table contains only data: no
column headers.



Ok, if this is a GDAL-design decision, then at least QGIS should
have default settings in the environment preventing this.

An ordinary user will never ever expect this behaviour nor find
this setting by himself.

Cheers,

Bernd


Am 13.03.22 um 08:55 schrieb Andrea Giudiceandrea:

*Bernd Vogelgesang*
/Sat Mar 12 14:13:04 PST 2022/


So: All-string tables will not be imported correctly. Always e.g.
add an
id-field with number


Hi Bernd,
this is by design:
https://github.com/OSGeo/gdal/blob/1c5bc766513c4407f702bd8cd8bfa958ed61cfea/ogr/ogrsf_frmts/xlsx/ogrxlsxdatasource.cpp#L597-L598

Am 12.03.22 um 23:04 schrieb Jonas Küpper://

>/what should have fixed it as well would be to pass
OGR_XLSX_HEADERS = />/FORCE to the provider while loading
xlsx-files but a i couldn't find a />/way how to do that. (see
https://gdal.org/drivers/vector/xlsx.html) /


Hi Jonas,
you can set a GDAL/OGR configuration option, like
OGR_XLSX_HEADERS, via the "Settings" -> "Options" -> "System" ->
"Environment" setting panel in QGIS.

Regards.

Andrea Giudiceandrea


___
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

--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918



___
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] Centra la vista in un punto

2022-03-13 Thread Bernd Vogelgesang via Qgis-user 

Which plugin should I install to query the map from x and y coordinates
and get the point on the map?

https://www.deepl.com


Am 13.03.22 um 09:49 schrieb SB via Qgis-user:


Quale plugin installare per interrogare la mappa partendo dalle
coordinate x e y ed ottenere ò'indicazione del punto sulla mappa?


___
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] Centra la vista in un punto

2022-03-13 Thread Nicolas Cadieux via Qgis-user 
Hi,
My guess is that he is looking for « point sampling tool » or « coordinates 
capture » plugin. 

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 13 mars 2022 à 05:13, Bernd Vogelgesang via Qgis-user 
>  a écrit :
> 
> 
> Which plugin should I install to query the map from x and y coordinates and 
> get the point on the map?
> 
> https://www.deepl.com
> 
> 
> 
> Am 13.03.22 um 09:49 schrieb SB via Qgis-user:
>> Quale plugin installare per interrogare la mappa partendo dalle coordinate x 
>> e y ed ottenere ò'indicazione del punto sulla mappa?
>> 
>> 
>> 
>> ___
>> 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] Browser and Layout side bars now hidden

2022-03-13 Thread Mike Breiding - Morgantown WV via Qgis-user 

Greetings,
I have somehow made hidden the Browser Layout and side bars and now only 
the canvas is visible.

What must I do to have them visible again?

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] Browser and Layout side bars now hidden

2022-03-13 Thread David Strip via Qgis-user 

  
  
On 3/13/2022 8:27 AM, Mike Breiding - Morgantown WV via Qgis-user
wrote:
Greetings,
  
  I have somehow made hidden the Browser Layout and side bars and
  now only the canvas is visible.
  
  What must I do to have them visible again?
  


From the main menu bar -
View->Panels (near the bottom of the list)
Then tick the browser and layer checkboxes
  

___
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] Problems with Qgis

2022-03-13 Thread Mike Breiding - Morgantown WV via Qgis-user 

On 3/13/2022 8:13 AM, Bernd Vogelgesang wrote:
right-click somewhere in the grey area around the menu bar. A drop-down 
menu opens, with checkboxes for all kinds of panels and toolboxes.

Most probably you will have to reactivate them there


I found them but they are not docking now, they are free floating.
Thanks,
-Mike




Am 13.03.22 um 15:22 schrieb Mike Breiding - Morgantown WV:

I some how lost my Browser and Layout side bars.
Now I must try to correct this first.

I hope you have not given up on me.
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

[Qgis-user] Creating High Resolution Images from Pleiades DIMAP files

2022-03-13 Thread bobjones--- via Qgis-user 
Hello,

I would like to know the steps to follow within QGIS to create pan-sharpened 
images from Pléiades DIMAP data. Is there a Help discussion that outlines the 
steps I need to take? If not, would someone in the community care to show me 
the steps I need to follow?

I work on a MacBook Pro and have installed QGIS 3.16. Do I need to upgrade to 
v3.24 first?

Thanking you in advance.

Cheers!

Bob Jones
___
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] Centra la vista in un punto

2022-03-13 Thread Andrea Giudiceandrea via Qgis-user 
*soniaber1 at virgilio.it*soniaber1 at virgilio.it 


/Sun Mar 13 00:49:08 PST 2022/

Quale plugin installare per interrogare la mappa partendo dalle coordinate x e 
y ed ottenere ò'indicazione del punto sulla mappa?


Ciao soniaber1,
questa è una mailing list in lingua inglese.

Sarebbe meglio specificare, in inglese, in maniera più dettagliata, ciò 
che vuoi esattamente ottenere e quali dati esattamente hai a 
disposizione e in che formato.


Alternativamente potresti iscriverti alla mailing list in lingua 
italiana degli utenti di QGIS 
https://lists.osgeo.org/mailman/listinfo/qgis-it-user


Saluti.

Andrea

Hi soniaber1,
this is a mailing list in English language.

It could be better to specify in English a more detailed description of 
what you need to achieve and what data (and in what format) exactly you 
have.


Alternatively, you could subscribe to the QGIS users mailing list in 
Italian language at https://lists.osgeo.org/mailman/listinfo/qgis-it-user


Regards.

Andrea___
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] Creating High Resolution Images from Pleiades DIMAP files

2022-03-13 Thread Nicolas Cadieux via Qgis-user 

Hi,

I think you can work with 3.16.  If you open the processing toolbox, you 
will find a search bar.  Search for pansharpening. You will see an 
algorithm under GDAL.  If you install the OTB (orfeo-toolbox) plugin and 
activate it in the processing toolbox setting, you will find other 
pansharpening algorithms.   I believe that the Semi-Automatic 
Classification Plugin also has a pansharpening option  There was 
also Opticks but the web site is currently offline.  Not sure why.


https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/gdal/rastermiscellaneous.html#gdalpansharp

https://www.orfeo-toolbox.org/CookBook/Applications/app_Pansharpening.html

https://fromgistors.blogspot.com/2015/07/major-update-semi-automatic-44.html

http://opticks.org/

Nicolas


On 2022-03-13 1:16 p.m., bobjones--- via Qgis-user wrote:

Hello,

I would like to know the steps to follow within QGIS to create pan-sharpened 
images from Pléiades DIMAP data. Is there a Help discussion that outlines the 
steps I need to take? If not, would someone in the community care to show me 
the steps I need to follow?

I work on a MacBook Pro and have installed QGIS 3.16. Do I need to upgrade to 
v3.24 first?

Thanking you in advance.

Cheers!

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


--
Nicolas Cadieux
https://gitlab.com/njacadieux

___
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] Centra la vista in un punto

2022-03-13 Thread Nicolas Cadieux via Qgis-user 

Ciao,

While most messages in this list are in English, I don't think it 
qualifies as an official "English" mailing list.  Writing in English 
will get you more responses but one must not underestimate the power of 
google translate! :)  Just my grain of salt!


Nicolas Cadieux

On 2022-03-13 3:37 p.m., Andrea Giudiceandrea via Qgis-user wrote:
*soniaber1 at virgilio.it*soniaber1 at virgilio.it 


/Sun Mar 13 00:49:08 PST 2022/

Quale plugin installare per interrogare la mappa partendo dalle coordinate x e 
y ed ottenere ò'indicazione del punto sulla mappa?


Ciao soniaber1,
questa è una mailing list in lingua inglese.

Sarebbe meglio specificare, in inglese, in maniera più dettagliata, 
ciò che vuoi esattamente ottenere e quali dati esattamente hai a 
disposizione e in che formato.


Alternativamente potresti iscriverti alla mailing list in lingua 
italiana degli utenti di QGIS 
https://lists.osgeo.org/mailman/listinfo/qgis-it-user


Saluti.

Andrea

Hi soniaber1,
this is a mailing list in English language.

It could be better to specify in English a more detailed description 
of what you need to achieve and what data (and in what format) exactly 
you have.


Alternatively, you could subscribe to the QGIS users mailing list in 
Italian language at https://lists.osgeo.org/mailman/listinfo/qgis-it-user


Regards.

Andrea

___
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


--
Nicolas Cadieux
https://gitlab.com/njacadieux
___
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