Table of Contents
OpenWoodland Ideas
look up Confirm Arbiculture by pitney bowes
Database Fields
observations, age, not freeform, select from attributes. (young, semi-mature, mature, late mature, senile, dead)
Anticipated Life, 1-5, 6-10, 11-20, 21-40, >40.
Beaufort scale, look up
Trunk cavity, >30%, 15-30%, <30%, n/a.
dead wood, <50%, >50%
decay, 30, 15_.30
dieback,
generalcondition, not assesed, dead, good health, advanced decline, poor health, reasonable health, prime health
root assesment, same as above
site risk, near public road, etc..
species risk, eg disease
trunk condition, veneer log, saw log, posts etc.
trunk lean, north-s-e-w
DB structure
Do we need woodland and Area tables?
Tree table
| Field | Type | Notes |
|---|---|---|
| Serial Number | INT | Primary Key |
| Area | Text VARCHAR 20? | Area where located, maybe map reference |
| SpeciesCode | INT | Eg oak, ash. |
| Description | Text VARCHAR | Free text to describe tree |
| Planted | Date | When planted if known |
| Added | Date | when added to system, may be the same as “Planted” |
| AddedBy | VARCHAR | Username who added |
| Modified | Date | Last modification date |
| ModBy | VARCHAR | Username who modified |
Growth Table
| Field | Type | Description |
|---|---|---|
| tree_id | INT | Tree primary Key |
| measurement_date | Date of measurement | |
| girth | INT | circumference |
| height | INT | Height estimate |
Species Table
| Field | Type | Description |
|---|---|---|
| id | INT | Primary Key |
| common_name | VARCHAR | Coloquial name, eg. Oak |
| botanical_name | VARCHAR | eg. Quercus Robur |
| genus_name | VARCHAR | eg. Quercus |
| type | VARCHAR | Broadleaf/Deciduoud/Evergreen - Normalise? |
Pages in app
Index
add tree
maint tree - eg. add measurement, pruned, felled
add measurement to tree
add species / code
add area
password / username profile maintainance
export data / subset of data to csv
View
by tree id
by species
by area
by planted date