Query by values

To ensure that Treesta is multilingual and easy to maintain, the English terms are saved for the values (key) and the terms in the respective language (values) are output in the same way. To avoid querying for the English values, represent_value can be used. The query for deadwood as a characteristic in the crown can look like this:

represent_value( "features_crown") like '%deadwood%'

represent_value queries the value, not the key

"features_crown" is the field containing the value

like '%deadwood%' the value is like (like) deadwood. Anything before or after deadwood is irrelevant. This outputs all trees with deadwood, even if they are followed by, for example, clearance profile or preceded by a number to specify the order.