Database structure

Currently, the only supported database is SQLite. The schema is defined in this file.

The following tables are being used:

• comments table contains comments added to trees.
• files table is where information on uploaded images is kept.
• osm_trees table keeps a copy of related nodes from OSM.
• queue_messages table keeps messages for background data processing.
• species table contains data on tree species, used for autocomplete.
• trees table is where the latest version of all trees is kept.
• trees_props table is where changes to individual properties are logged.
• upload_tickets table stores temporary information on upload requests.
• users table stores information on all user accounts.

Tables

uploads

This table contains records of source files received from the user. Each file has a unique id, which is also the name of the file in the local file system. These files aren't used anywhere directly, but they are used for creating tree photos by submitting an upload id.