These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Environmental Conservation
- Data model and import order
The tables behind Environmental Conservation
Environmental Conservation ships with 11 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 11
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Sites and habitats:
Sites, habitat sites. Keep each surveyed boundary with its site and date.
Restoration cycles:
Restoration cycles, field tasks, Findings. Connect planned work and accepted measures to the effort under review.
Field evidence:
Observations, Findings. Preserve site scouting separately from reviewed cycle measures.
Treatments:
Treatment stocks, treatment usage, treatment applications. Distinguish stock lots, task consumption and site applications.
People and access:
Users, People. Keep assignments, applications and acceptance tied to named actors.
Every table, by feature
- Sites and habitats4
- Restoration cycles4
- Field tasks6
- Observations and findings5
- Treatments6
- People and access5
- Sites
Conservation sites and habitat plots with area, location and availability status
- Habitat sites
Surveyed habitat boundary geometry with survey date and area
Linked to Sites - Observations
Site scouting observations with measured value, unit and notes
Linked to Sites - Restoration cycles
Restoration cycles per site from planned start through establishing, closing and close
Linked to Sites
- Restoration cycles
Restoration cycles per site from planned start through establishing, closing and close
Linked to Sites - Sites
Conservation sites and habitat plots with area, location and availability status
- Field tasks
Planned and executed field work assigned to a person for a specific cycle
Linked to Sites, Restoration cycles, People - Findings
Recorded quantities with unit and condition, accepted by a reviewer
Linked to Restoration cycles, People
- Field tasks
Planned and executed field work assigned to a person for a specific cycle
Linked to Sites, Restoration cycles, People - Sites
Conservation sites and habitat plots with area, location and availability status
- Restoration cycles
Restoration cycles per site from planned start through establishing, closing and close
Linked to Sites - People
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users - Treatment usage
Treatment quantities consumed against a field task
Linked to Treatment stocks, Field tasks - Treatment stocks
Treatment stock lots with quantity on hand, unit and expiry
- Observations
Site scouting observations with measured value, unit and notes
Linked to Sites - Findings
Recorded quantities with unit and condition, accepted by a reviewer
Linked to Restoration cycles, People - Sites
Conservation sites and habitat plots with area, location and availability status
- Restoration cycles
Restoration cycles per site from planned start through establishing, closing and close
Linked to Sites - People
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users
- Treatment stocks
Treatment stock lots with quantity on hand, unit and expiry
- Treatment usage
Treatment quantities consumed against a field task
Linked to Treatment stocks, Field tasks - Treatment applications
Recorded treatment applications to a site by a named applicator
Linked to Sites, People - Field tasks
Planned and executed field work assigned to a person for a specific cycle
Linked to Sites, Restoration cycles, People - Sites
Conservation sites and habitat plots with area, location and availability status
- People
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users
- People
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users - Users
Users
Linked to Users - Field tasks
Planned and executed field work assigned to a person for a specific cycle
Linked to Sites, Restoration cycles, People - Findings
Recorded quantities with unit and condition, accepted by a reviewer
Linked to Restoration cycles, People - Treatment applications
Recorded treatment applications to a site by a named applicator
Linked to Sites, People
Keys and references
Use stable site and person references rather than copied display names. Every task needs its site, cycle and assignee. Each finding belongs to a cycle and names its accepting person. A treatment use belongs to a stock lot and task; an application belongs to a site and applicator. Keep quantity and unit together and preserve dates in their own fields. Reconcile the site on a cycle with the site on its tasks.
Migration order
- Load Users and People, then confirm the identity link for each operator and reviewer.
- Load Sites with their field codes, status, location and area.
- Load dated habitat sites surveys and Observations against the correct Sites.
- Load restoration cycles, then field tasks and Findings with their references.
- Load treatment stocks before treatment usage and treatment applications; reconcile lot quantities and sample site work.
Set up Environmental Conservation your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.