Open Gustry opened 3 years ago
3.16: create uuid regexp_replace(uuid(), '[{}]', '')
Create values from existing values (categorization)
CASE
WHEN lower(trim("juveniles")) = 'oui' THEN 'oui'
WHEN lower(trim("juveniles")) = 'non' THEN 'non'
ELSE 'nsp'
END
Get the code of the corresponding glossary feature
aggregate(
layer:='especes_chiro',
aggregate:='max', expression:="cd_nom",
filter:=trim("nom_scientifique")=trim(attribute(@parent,'espece'))
)
attributes(
get_feature( 'especes_chiro', 'espece', "espece")
)['cd_nom']
to_date("date", 'dd/MM/yyyy')
aggregate(
layer:='commune',
aggregate:='max', expression:="code_commune",
filter:=intersects($geometry, buffer(geometry(@parent), 50))
)
We need some practical exercises :
It's nice to provide an EDIGEO export as geopackage in a training for the last one
I assign myself, but others are welcome of course ! :)