[CANUFNET] Following up on community planting projects

[Robert Liveanu]

Hi everyone,

I work at a non-profit in Quebec City where one of our main actions is to
carry out various planting projects on municipal, private, and
institutional lands - schools for example are a common location.

I wanted to pick your brains regarding how best to model a follow-up system
for our planting projects. Currently, the system here is Excel-based - each
planting project is its own file (based on a template), to be followed and
filled each year for n+5 years. Data that's collected includes things like
mortality rate and what interventions to follow through on (formative
pruning, removing stake, reapplying RCW, etc.).

Over the years this system has generated a large number of Excel files that
are difficult to sort through and to integrate into an efficient workflow
process. I wanted instead to create a GIS-based project, the idea being to
centralize all the data and have it generate interventions/workflow as it's
being used.

Has anyone done something like this, or used such a system in their work?
What kind of data model is used? I see it as different from a municipal
street/park tree inventory, as some of our planting projects can involve,
for example, hundreds of small caliper trees in a more ecological
restoration context, or hundreds of individual shrubs that would be
impossible/probably unnecessary to catalogue individually in a database,
but that still need to be followed up on in some way for planting success.
Any thoughts or comments much appreciated.

Thank you! Cheers,


Robert

___

ROBERT LIVEANU*,* *MFC, B.Sc.*

Agent en verdissement et éducation

*Association forestière des deux rives (AF2R)*



870, avenue de Salaberry, local 103, Québec (Québec)  G1R 2T9

*T* 418 522-0006 poste 3022 | *F* 418 524-4112

foret at af2r.org | www.af2r.or <http://www.af2r.org/>



Facebook : *Suivez l'AF2R*
<https://www.facebook.com/Association-foresti%C3%A8re-des-deux-rives-AF2R-162253373811427/>
  I  *Suivez le mont Wrigh**t* <https://www.facebook.com/ParcMontWright/>
I  *Suivez Une forêt de possibilités
<https://www.facebook.com/uneforetdepossibilites/>*

www.uneforetdepossibilites.com/jycrois
<https://uneforetdepossibilites.com/fr/jycrois>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.web.net/pipermail/canufnet/attachments/20200109/7f811180/attachment.htm>