generate_users_arcade_expression.md

Generate a user-based arcade expression

This script can generate a simple Arcade Expression that can be used when visualizing track or LKL data in a map. It takes a CSV file and at least two columns (username, category) and it will generate an expression to use in a map.

The expression can be used as part of the layer symbology or as part of a popup configuration to display additional information about the tracked user.

Supports Python 3.6+

Example Input CSV:

username	category
user1	Medic
user2	Firefighter

Resulting Output:

if ($feature.created_user == 'user1') {
    return 'Medic'
}

else if ($feature.created_user == 'user2') {
    return 'Firefighter'
}

return ''

---

The script uses these arguments:

• --file <csv-file> - the CSV file to read
• --username-column <column-name> - the column in the CSV file containing the usernames of the tracked users
• --other-column <column-name> - the column in the CSV file containing the values to associate with the users (e.g. a category)

Example Usage 1 - Printing to console

python generate_users_arcade_expression.py --file users.csv --username-column usernames --other-column category

Example Usage 2 - Direct to file

python generate_users_arcade_expression.py --file users.csv --file users.csv --username-column usernames --other-column category > output.txt

Example Usage 3 - Direct to Clipboard on Mac

python generate_users_arcade_expression.py --file users.csv --file users.csv --username-column usernames --other-column category | pbcopy

Example Usage 4 - Direct to Clipboard on Windows

python generate_users_arcade_expression.py --file users.csv --file users.csv --username-column usernames --other-column category | CLIP

What it does

1. Reads the provided CSV file
2. Generates an if/else if based arcade expression like:
3. Prints the expression