====== 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