<div dir="ltr">Hi everyone,<div><br></div><div>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.</div><div><br></div><div>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.).</div><div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>Thank you! Cheers,<br clear="all"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><p class="MsoNormal"><br></p><p class="MsoNormal">Robert</p></div></div></div></div></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><p class="MsoNormal"><font color="#000000" face="Arial Narrow, sans-serif"><span style="font-size:18px">___</span></font></p><p class="MsoNormal"><font size="4"><span style="font-family:"Arial Narrow",sans-serif;color:rgb(171,201,38)">ROBERT LIVEANU</span><b><span style="font-family:"Arial Narrow",sans-serif;color:black">,</span></b></font><b><span style="font-family:Verdana,sans-serif;color:rgb(118,165,175)"> </span></b><i><span style="font-size:7.5pt;font-family:"Arial Narrow",sans-serif;color:black">MFC, B.Sc.</span></i><span style="color:black"><u></u><u></u></span></p><p class="MsoNormal" style="background-image:initial;background-position:initial;background-repeat:initial"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Agent en verdissement et éducation</span><span style="color:black"><u></u><u></u></span></p><p class="MsoNormal" style="background-image:initial;background-position:initial;background-repeat:initial"><b><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Association forestière des deux rives (AF2R)</span></b><span style="color:black"><u></u><u></u></span></p><p class="MsoNormal" style="background-image:initial;background-position:initial;background-repeat:initial"><span style="font-size:10pt;font-family:Arial,sans-serif"> </span><span style="color:black"><u></u><u></u></span></p><p class="MsoNormal" style="background-image:initial;background-position:initial;background-repeat:initial"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">870, avenue de Salaberry, local 103, Québec (Québec)  G1R 2T9</span><span style="color:black"><u></u><u></u></span></p><p class="MsoNormal" style="background-image:initial;background-position:initial;background-repeat:initial"><b><span style="font-size:10pt;font-family:"Arial Narrow",sans-serif;color:rgb(171,201,38)">T</span></b><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(171,201,38)"> </span><span style="font-size:10pt;font-family:Arial,sans-serif">418 522-0006 poste 3022</span><b><span style="font-size:10pt;font-family:Tahoma,sans-serif;color:rgb(118,165,175)"> </span></b><span style="font-size:10pt;font-family:Tahoma,sans-serif;color:rgb(171,201,38)">|</span><span style="font-size:10pt;font-family:"Arial Narrow",sans-serif;color:rgb(171,201,38)"> <b>F</b></span><span style="font-size:10pt;font-family:Arial,sans-serif"> 418 524-4112 </span><span style="color:black"><u></u><u></u></span></p><p class="MsoNormal" style="background-image:initial;background-position:initial;background-repeat:initial"><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(5,99,193)"><a href="mailto:foret@af2r.org" style="color:rgb(17,85,204)" target="_blank">foret@af2r.org</a></span><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(171,201,38)"> </span><span style="font-size:10pt;font-family:Tahoma,sans-serif;color:rgb(171,201,38)">|</span><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(5,99,193)"> <a href="http://www.af2r.org/" style="color:rgb(17,85,204)" target="_blank">www.af2r.or</a></span></p><p class="MsoNormal" style="background-image:initial;background-position:initial;background-repeat:initial"><span style="font-family:Arial,sans-serif"> </span><span style="color:black"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:black">Facebook :</span><span><span style="font-size:10.5pt;color:black"> </span></span><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(5,99,193)"><a href="https://www.facebook.com/Association-foresti%C3%A8re-des-deux-rives-AF2R-162253373811427/" style="color:rgb(17,85,204)" target="_blank"><i>Suivez l'AF2R</i></a></span><i><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(171,201,38)">  </span></i><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(171,201,38)">I  <a href="https://www.facebook.com/ParcMontWright/" style="color:rgb(17,85,204)" target="_blank"><i>Suivez le mont Wrigh</i><i><span style="color:purple">t</span></i></a>  I  </span><i><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(5,99,193)"><a href="https://www.facebook.com/uneforetdepossibilites/" style="color:rgb(17,85,204)" target="_blank">Suivez Une forêt de possibilités</a></span></i><span style="color:black"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:7.5pt;color:rgb(5,99,193)"><a href="https://uneforetdepossibilites.com/fr/jycrois" style="color:rgb(17,85,204)" target="_blank">www.uneforetdepossibilites.com/jycrois<br></a></span></p></div></div></div></div></div>