-
Notifications
You must be signed in to change notification settings - Fork 2
trees table
Justin Forest edited this page May 11, 2024
·
2 revisions
The trees table contains information on all trees, either added directly, or coming from OSM.
See this file for the up to date definition.
| Field | Type | Description |
|---|---|---|
| id | unsigned | Unique tree id, a snowflake. |
| osm_id | unsigned | OSM node id, assigned on import or after pushing a locally added tree to OSM. |
| lat | float | Latitude. |
| lon | float | Longitude. |
| species | text | Tree definition. Latin species, genus or whatever the user types. |
| notes | text? | Something notable about the tree. |
| height | float? | Height in meters, if known. |
| circumference | float? | Trunk circumference at chest level, in meters, if known. |
| diameter | float? | Crown diameter in meters, if known. |
| added_at | unsigned | UNIX timestamp when the tree was added to the database. |
| updated_at | unsigned | Timestamp of when the tree was last updated. |
| added_by | unsigned | The id of the user who added this tree. |
| thumbnail_id | unsigned? | Last uploaded file id. |