look up Confirm Arbiculture by pitney bowes
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
Do we need woodland and Area tables?
| 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 |
| Field | Type | Description |
|---|---|---|
| tree_id | INT | Tree primary Key |
| measurement_date | Date of measurement | |
| girth | INT | circumference |
| height | INT | Height estimate |
| 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? |
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