Re: [Qgis-user] Query Builder - I thought I understood what I was doing.

[oisin.kelly.wild--- via QGIS-User]

Are you entering the filter in the expression builder from the attribute table. 
If so, type

substring("DateSale") in ('2021',  '2022', '2023', '2024')

This should filter the table to show features with "DateSale"='2021' or '2022' 
or '2023' or '2024'.

⁣Oisin

Get BlueMail for Android ​

On 12 Jun 2024, 20:01, at 20:01, Jeremy via QGIS-User 
 wrote:
>this explanation is opaque. can you explain how i use this in the query
>
>builder? is it a matter of adding an attribute that is calculated by
>the
>slicing?
>
>--
>This message would have been encrypted if you were using Delta Chat or
>some other autocrypt-compatible email client.
>
>I am also reachable by Signal, Matrix, SMS, and telephone calls.
>
>Find more information here:
>| Delta Chat  | https://delta.chat/en/ |
>| autocrypt   | https://autocrypt.org/ |
>| Signal  | https://signal.org/en/ |
>| Matrix  | https://element.io/|
>| SMS & telephone | +18149337465   |
>
>
>
>
>___
>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] Query Builder - I thought I understood what I was doing.

[oisin.kelly.wild--- via QGIS-User]

Sorry, slice doesn't work on expressions. Use

substring("DateSale", 7, 10)

⁣Oisin
07570 977449

Get BlueMail for Android ​

On 12 Jun 2024, 19:59, at 19:59, "oisin.kelly.w...@gmail.com" 
 wrote:
>ClIf its a string can use slice, e.g.
>"DateSale"[7:10] to return 
>
>
>⁣O
>
>Get BlueMail for Android ​
>
>On 12 Jun 2024, 19:40, at 19:40, Jeremy Swarm via QGIS-User
> wrote:
>>I have a set of vectors (it's a parcel map) from my county. This layer
>>has a number of attributes defined. I would like to filter the
>features
>>by an attribute called "DateSale". it is formatted MM/DD/. I
>>believe it is astring. I would like to find features which end with
>any
>>of 2021,2022,2023, ,or 2024. I have not been able to build a
>successful
>>filter with the query builder.
>>
>>
>>
>>___
>>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] Query Builder - I thought I understood what I was doing.

[oisin.kelly.wild--- via QGIS-User]

ClIf its a string can use slice, e.g.
"DateSale"[7:10] to return 


⁣O

Get BlueMail for Android ​

On 12 Jun 2024, 19:40, at 19:40, Jeremy Swarm via QGIS-User 
 wrote:
>I have a set of vectors (it's a parcel map) from my county. This layer
>has a number of attributes defined. I would like to filter the features
>by an attribute called "DateSale". it is formatted MM/DD/. I
>believe it is astring. I would like to find features which end with any
>of 2021,2022,2023, ,or 2024. I have not been able to build a successful
>filter with the query builder.
>
>
>
>___
>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] clip raster by layer mask

[oisin.kelly.wild--- via QGIS-User]

At step 4, Tick the box ' selected feature'

⁣Oisin

Get BlueMail for Android ​

On 30 May 2024, 20:49, at 20:49, Bernd Vogelgesang via QGIS-User 
 wrote:
>Did you e.g. try to copy the selected region to a memory layer and
>perform the clip with that? Maybe the outcome gives some clues …
>
>
>Cheers,
>
>Bernd
>Am 30.05.24 um 20:33 schrieb Sibylle Stöckli via QGIS-User:
>> Dear community
>>
>> I am using the QGIS tool "clip raster by layer mask".
>>
>> Here the process
>>
>> 1. open attribute table of layer maks
>>
>> 2. select one "region"
>>
>> 3. select the raster layer layer of that "region"
>>
>> 4. raster - extraction-clip raster layer maks
>>
>> Question: when checking the result, the assignment of the "region" is
>
>> wrong. The clipped "region" is not that one that was selected in step
>2.
>>
>> Is there anything else that may hamper the compatibility of both
>layers?
>> Both layers are EPSG:2056 (see figures). IS the Foat32 data type a
>problem?
>>
>> Raster layer:
>>
>> Layer mask “regions”
>>
>> Kind regards
>>
>> Sibylle
>>
>>
>> ___
>> 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
>
>--
>Dipl.-Geogr.
>Bernd Vogelgesang
>Kappel 17
>91355 Hiltpoltstein
>Tel: 09192-3499427
>mobil: 0163-1860160
>m...@berndvogelgesang.de
>
>
>
>___
>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] Can't accomplish comparisions between different Map Layer Table's

[oisin.kelly.wild--- via QGIS-User]

get_feature(layer, attribute, value)

This returns a feature. You can then wrap this in attributes() to return a 
dictionary of attribute names and  values.

You then add ['attributename'] on end to return value.

So for each table
something like

attributes(get_feature('table1', 'common-id-name', 
"common-id-name"))['H3centr-h9...']

Does this make sense

⁣Oisin


Get BlueMail for Android ​

On 14 May 2024, 20:35, at 20:35, Guillermo Parra  wrote:
>Hello Oisin,
>Thank you for your guidance regarding this topic, and I am sorry if I
>need further assistance, but I'm kind of new to QGIS.
>Regarding the need to define the layer for each attribute, will it work
>if I stated like I had wroten before?
>i.e.:'Table1.H3centr_h9_cobcubierto'  = 1
>OR 'Table2.H3centr_h9_cobcubierto' = 1 Will QGIS recognize it?
>And to find the comparable record, certaingly I can use a common id. So
>I will explore the getfeature( ) tool that you suggest, thank you very
>much.
>Regards.  
>
>Guillermo Parra Montealegre e-mail: meminp...@yahoo.com
>
>El martes, 14 de mayo de 2024, 13:23:07 GMT-6,
>oisin.kelly.w...@gmail.com  escribió:
>
>You definitely need to define the layer for each attribute (except the
>current layer).
>
>You also need a way to find the comparable record, e.g.
>(i) with a common id (use getfeature() to access attribute) or
>(ii) spatially use one of the overlay functions.
>
>Oisin
>
>Get BlueMail for Android On 14 May 2024, at 19:52, Guillermo Parra via
>QGIS-User  wrote:
>Hi,
>I have several tables with the same fields, same grid information, but
>different field data for each one (information from different
>providers, let's say).
>Particularly, I have a field with 0 and 1 which represent if each
>provider have, or not have coverage in that area.
>I want to compare the values of each table to set "1" if at least one
>of the providers have coverage in each area, or "0" if None of them
>have it, so I used the field calculator and the expression builder with
>this sql statement:
>if( 'H3centr_h9_cobcubierto'  = 1 OR 'H3centr_h9_cobcubierto' = 1
>OR'H3centroides_h9_cobGT3D cubierto' = 1
>OR'H3centroides_h9_cob_cubierto'  = '1' OR'H3centr_h9_cob_cubierto' =
>'1' OR'H3cent_cob_cubierto'  = '1' OR"H3centrR9_Tc3D_cubierto"  ='1',
>1, 0)
>The problem is that apparently it is considering only the last field in
>double quotes (which is in the same table that the new column where I
>want to fill the data), and the other fields apparently are beign
>ignored.
>I would guest that it would be better to specify the table and field
>where each data will be taken ( like  if(
>'Table1.H3centr_h9_cobcubierto'  = 1 OR 'Table2.H3centr_h9_cobcubierto'
>= 1 OR... etc.)but when I make double click over each layer field, QGIS
>writes it that way, so I asume it is correct.
>So, if someone have an idea on how I can make it work, I would greatly
>appreciate any suggestion.Thanks,
>Guillermo.
>
>Guillermo Parra Montealegre e-mail: meminp...@yahoo.com
>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] Can't accomplish comparisions between different Map Layer Table's

[oisin.kelly.wild--- via QGIS-User]

No it won't work. It's not SQL syntax, it's expression syntax. So you need to 
use a function to get the corresponding feature from another layer. Hence 
getfeature() or one of the  overlay_ functions.

You will end up with a long expression.

Or, you could use sql in dB manager?

⁣Oisin
07570 977449

Get BlueMail for Android ​

On 14 May 2024, 20:35, at 20:35, Guillermo Parra  wrote:
>Hello Oisin,
>Thank you for your guidance regarding this topic, and I am sorry if I
>need further assistance, but I'm kind of new to QGIS.
>Regarding the need to define the layer for each attribute, will it work
>if I stated like I had wroten before?
>i.e.:'Table1.H3centr_h9_cobcubierto'  = 1
>OR 'Table2.H3centr_h9_cobcubierto' = 1 Will QGIS recognize it?
>And to find the comparable record, certaingly I can use a common id. So
>I will explore the getfeature( ) tool that you suggest, thank you very
>much.
>Regards.  
>
>Guillermo Parra Montealegre e-mail: meminp...@yahoo.com
>
>El martes, 14 de mayo de 2024, 13:23:07 GMT-6,
>oisin.kelly.w...@gmail.com  escribió:
>
>You definitely need to define the layer for each attribute (except the
>current layer).
>
>You also need a way to find the comparable record, e.g.
>(i) with a common id (use getfeature() to access attribute) or
>(ii) spatially use one of the overlay functions.
>
>Oisin
>
>Get BlueMail for Android On 14 May 2024, at 19:52, Guillermo Parra via
>QGIS-User  wrote:
>Hi,
>I have several tables with the same fields, same grid information, but
>different field data for each one (information from different
>providers, let's say).
>Particularly, I have a field with 0 and 1 which represent if each
>provider have, or not have coverage in that area.
>I want to compare the values of each table to set "1" if at least one
>of the providers have coverage in each area, or "0" if None of them
>have it, so I used the field calculator and the expression builder with
>this sql statement:
>if( 'H3centr_h9_cobcubierto'  = 1 OR 'H3centr_h9_cobcubierto' = 1
>OR'H3centroides_h9_cobGT3D cubierto' = 1
>OR'H3centroides_h9_cob_cubierto'  = '1' OR'H3centr_h9_cob_cubierto' =
>'1' OR'H3cent_cob_cubierto'  = '1' OR"H3centrR9_Tc3D_cubierto"  ='1',
>1, 0)
>The problem is that apparently it is considering only the last field in
>double quotes (which is in the same table that the new column where I
>want to fill the data), and the other fields apparently are beign
>ignored.
>I would guest that it would be better to specify the table and field
>where each data will be taken ( like  if(
>'Table1.H3centr_h9_cobcubierto'  = 1 OR 'Table2.H3centr_h9_cobcubierto'
>= 1 OR... etc.)but when I make double click over each layer field, QGIS
>writes it that way, so I asume it is correct.
>So, if someone have an idea on how I can make it work, I would greatly
>appreciate any suggestion.Thanks,
>Guillermo.
>
>Guillermo Parra Montealegre e-mail: meminp...@yahoo.com
>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] Can't accomplish comparisions between different Map Layer Table's

[oisin.kelly.wild--- via QGIS-User]

You definitely need to define the layer for each attribute (except the current 
layer).

You also need a way to find the comparable record, e.g. 
(i) with a common id (use getfeature() to access attribute) or
(ii) spatially use one of the overlay functions.

Oisin

Get BlueMail for Android ​

On 14 May 2024, 19:52, at 19:52, Guillermo Parra via QGIS-User 
 wrote:
>Hi,
>I have several tables with the same fields, same grid information, but
>different field data for each one (information from different
>providers, let's say).
>Particularly, I have a field with 0 and 1 which represent if each
>provider have, or not have coverage in that area.
>I want to compare the values of each table to set "1" if at least one
>of the providers have coverage in each area, or "0" if None of them
>have it, so I used the field calculator and the expression builder with
>this sql statement:
>if( 'H3centr_h9_cobcubierto'  = 1 OR 'H3centr_h9_cobcubierto' = 1
>OR'H3centroides_h9_cobGT3D cubierto' = 1
>OR'H3centroides_h9_cob_cubierto'  = '1' OR'H3centr_h9_cob_cubierto' =
>'1' OR'H3cent_cob_cubierto'  = '1' OR"H3centrR9_Tc3D_cubierto"  ='1',
>1, 0)
>The problem is that apparently it is considering only the last field in
>double quotes (which is in the same table that the new column where I
>want to fill the data), and the other fields apparently are beign
>ignored.
>I would guest that it would be better to specify the table and field
>where each data will be taken ( like  if(
>'Table1.H3centr_h9_cobcubierto'  = 1 OR 'Table2.H3centr_h9_cobcubierto'
>= 1 OR... etc.)but when I make double click over each layer field, QGIS
>writes it that way, so I asume it is correct.
>So, if someone have an idea on how I can make it work, I would greatly
>appreciate any suggestion.Thanks,
>Guillermo.
>
>Guillermo Parra Montealegre e-mail: meminp...@yahoo.com
>
>
>
>___
>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] Moving many project files - bulk updating paths to tables?

[oisin.kelly.wild--- via QGIS-User]

If you use Python it should be fairly simple to enumerate all layers, test to 
see if they're file based and then use pattern matching to alter the file paths


⁣Oisin
07570 977449

Get BlueMail for Android ​

On 4 Apr 2024, 19:28, at 19:28, "Tony Shepherd (FarmMaps NZ) via QGIS-User" 
 wrote:
>Hi All
>
>
>
>I am sure I am not the first to ponder how to deal with this.  I have
>loads,
>thousands likely, of project files in a series of folders and
>subfolders.  I
>need to move those files and folders to a new location to enable other
>staff
>to use the project files and their associated shp files, geo packages,
>rasters etc.
>
>
>
>Essentially, I am shifting my entire collection of GIS work to a shared
>location for others to start using, so moving from a sole operator to a
>shared environment.
>
>
>
>In my old MapInfo days, I would simply do a bulk search and replace
>over the
>workspace files (text-based so this is easy) and change the paths that
>need
>changing and all would be ok.
>
>
>
>As qgz files are not easily modified through a text editor, are there
>any
>tools out there to enable bulk changing of file paths in those files?
>
>
>
>Any other approaches?
>
>
>
>Cheers
>
>Tony
>
>
>
>
>--
>
>Tony Shepherd
>
>  GeoSpatial Manager @ FarmMaps NZ & Photographer @ Shepherd Photos
>
>
>
>Phone - 027 435 6193  | Website -  
>shepherdphotos.co.nz
>
>Email - Maps   t...@farmmaps.nz  |  Email -
>Photos
> t...@shepherdphotos.co.nz
>
>Facebook  
>TonyShepherdPhotos
>
>
>
>
>
>
>
>
>
>
>
>
>
>___
>QGIS-User mailing list
>QGIS-User@lists.osgeo.org
>List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Adding virtual X & Y columns to a QGIS attribute form

[oisin.kelly.wild--- via QGIS-User]

Once you have created the virtual field, you can add them to your form. Open 
form properties,go to form, choose drag and drop form designer, add the 
available attributes from left hand panel to middle panel. Right hand panel is 
for form widget settings.

Hope that helps

⁣Get BlueMail for Android ​

On 21 Mar 2024, 21:27, at 21:27, Brent Wood via QGIS-User 
 wrote:
>Hi,
>
>I have created an attribute form for a QGIS layer.
>
>I want to add two fields to the form: the X & Y values of a point
>geometry column.
>
>I can't find any way to do this - if I don't use the form, it is easy
>to add the virtual columns as expressions ($x & $y) in the table view,
>but I want these in the form view, not the table view.
>
>
>Any suggestions appreciated.
>
>Brent Wood
>
>Principal Technician, Fisheries
>NIWA
>DDI:  +64 (4) 3860529
>[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png]
>
>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
>YouTube
>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.
>Note: This email is intended solely for the use of the addressee and
>may contain information that is confidential or subject to legal
>professional privilege. If you receive this email in error please
>immediately notify the sender and delete the email.
>
>
>
>
>___
>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