<div dir="ltr"><div dir="ltr" class="gmail_attr"><div>We worked with The Pennsylvania Horticultural Society in the greater Philadelphia area to build a <a href="http://pg-cloud.com/phs" target="_blank">Treeplotter application</a> that integrates roughly 30 Excel spreadsheets and ~10 user workflows. The tool handles public tree applications, site inspections, and tree planting tracking, as well as event/group management (Tree Tenders) and young tree monitoring (Tree Checkers).</div><div><br></div><div><div>Happy to go into more detail privately if there's interest from anyone on the list.</div></div><div><br></div><div>-Jacob</div></div><div dir="ltr" class="gmail_attr"><br></div><div dir="ltr" class="gmail_attr"><table style="border:none;border-collapse:collapse"><colgroup><col width="112"><col width="146"></colgroup><tbody><tr style="height:21pt"><td colspan="2" style="border-bottom:1pt solid rgb(43,104,156);vertical-align:top;padding:5pt">
<p style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><a href="https://www.planitgeo.com/" rel="nofollow" target="_blank"><span style="font-size:8pt;font-family:montserrat,sans-serif;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;width:123px;height:34px"><img height="34" src="https://lh6.googleusercontent.com/oIOo2bX2WjsJgiQllgJ2AkD6q7XJLiyq60G3vK192yOr5l6a-9-1qnZEqSTFUTRlTJ55RHWq0WEvJDaxbrVBo54uxBexsEKY-CkbXbjTcZr4sTSl0hCvx7ulfGYUdFC8ILTQGEoT" style="margin-left: 0px; margin-top: 0px;" width="123"></span></span></a><span style="font-size:16pt;font-family:montserrat,sans-serif;color:rgb(43,104,156);vertical-align:baseline;white-space:pre-wrap"> </span><span style="font-size:10pt;font-family:montserrat,sans-serif;color:rgb(43,104,156);vertical-align:baseline;white-space:pre-wrap"> </span><span style="font-size:10pt;font-family:montserrat,sans-serif;color:rgb(43,104,156);vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;width:18px;height:18px"><a href="https://www.linkedin.com/company/plan-it-geo/?viewAsMember=true" rel="nofollow" target="_blank"><img height="18" src="https://lh3.googleusercontent.com/8AVq0p5dxdgwoRGLDmV6x9eeIIE4gUPMzE9ZHh9P4LBkeZbt59cp3883L70fejtwcQhGbBhdfXKcr99bqCzEkGQnvziKFQjCYoqw_wQMxoR1Wj62gc5w2Ag48zJQmNZRP6FrW6lM" style="margin-left: 0px; margin-top: 0px;" width="18"></a> </span></span><a href="https://twitter.com/planitgeo2012" rel="nofollow" target="_blank"><span style="font-size:11pt;font-family:arial;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;width:18px;height:18px"><img height="18" src="https://lh6.googleusercontent.com/Vnmb7BeBpNPhgmUxrnsFzLPkR4fBU_xBPy9_7FGTyzAnHFf9uGIxmpBcM1L0HAdwIBbJhmZvwDErF3EZwxK1TGBvs-9MIcyvzNKa5Em8-yjTLnboha8_r5o1QZhTpdX-No_SWEJ2" style="margin-left: 0px; margin-top: 0px;" width="18"></span></span></a><span style="font-size:11pt;font-family:arial;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;width:18px;height:18px"><a href="https://www.facebook.com/PlanItGeo2012/" rel="nofollow" target="_blank"><img height="18" src="https://lh4.googleusercontent.com/EfRoLu0IO2nqaKBAxbtT2Ux9RRhAbPO8Zr17M_GmZMsWaPDE1ZgQMutLJZKJFbE7J2EmnLoUvCi-dhjx32DldH-sdVrZHMTc1QB6y-4xnVtwY4b0a-eMKDTGdCSWHa0-Fiv6_J3k" style="margin-left: 0px; margin-top: 0px;" width="18"></a> </span></span><a href="https://www.instagram.com/planitgeo/" rel="nofollow" target="_blank"><span style="font-size:11pt;font-family:arial;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;width:18px;height:18px"><img height="18" src="https://lh3.googleusercontent.com/DEwdHbIEXt1O6afbPUI_48wBiOJMvtNE2e72XMpr-HIsttditdg0Gf5GvJptHxj6q5kNXsgTv9-AbUStgyNSwUVxjLPrC_4wgPcoHvDksnaEZ_HSRjdVokddHJQXKqPy5Xo6_LnC" style="margin-left: 0px; margin-top: 0px;" width="18"></span></span></a></p>
</td></tr><tr style="height:0pt"><td style="border-top:1pt solid rgb(43,104,156);vertical-align:top;padding:5pt">
<p style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:montserrat,sans-serif;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;width:90px;height:90px"><img height="90" src="https://lh5.googleusercontent.com/j-GY7-mNR3AlGW-HhkaXSaRL8oRDvKc-FkiS3GhpDjxRQdF3Jtmsm3P5Jh5tWS55DzWf9XBetsVgX6Bz3yRWbiYs2j4rEs1_MK87yoqtZ7aaMBRNwa0Ojk_Az4_UesHeZcbZuKWd" style="margin-left: 0px; margin-top: 0px;" width="90"></span></span></p>
<br><a href="http://Treeplotter.com" target="_blank">Treeplotter.com</a><br><a href="http://PlanITgeo.com" target="_blank">PlanITgeo.com</a></td><td style="border-top:1pt solid rgb(255,255,255);vertical-align:top;padding:5pt">
<p style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12pt;font-family:montserrat,sans-serif;color:rgb(47,163,242);vertical-align:baseline;white-space:pre-wrap">Jacob Caggiano</span></p>
<p style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;font-family:montserrat,sans-serif;color:rgb(102,102,101);vertical-align:baseline;white-space:pre-wrap">TreePlotter™</span></p>
<p style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;font-family:montserrat,sans-serif;color:rgb(102,102,101);vertical-align:baseline;white-space:pre-wrap">Account Executive</span></p>
<p style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;font-family:montserrat,sans-serif;color:rgb(47,163,242);font-weight:700;vertical-align:baseline;white-space:pre-wrap">M:</span><span style="font-size:9pt;font-family:montserrat,sans-serif;color:rgb(102,102,101);font-weight:700;vertical-align:baseline;white-space:pre-wrap"> </span><span style="font-size:9pt;font-family:montserrat,sans-serif;color:rgb(102,102,101);vertical-align:baseline;white-space:pre-wrap">509.432.1674</span></p>
<p style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;font-family:montserrat,sans-serif;color:rgb(47,163,242);font-weight:700;vertical-align:baseline;white-space:pre-wrap">P:</span><span style="font-size:9pt;font-family:montserrat,sans-serif;vertical-align:baseline;white-space:pre-wrap"> </span><span style="font-size:9pt;font-family:montserrat,sans-serif;color:rgb(102,102,101);vertical-align:baseline;white-space:pre-wrap">303.</span><span style="font-size:9pt;font-family:montserrat,sans-serif;color:rgb(102,102,101);vertical-align:baseline;white-space:pre-wrap">214.5067</span></p></td></tr></tbody></table></div><div dir="ltr" class="gmail_attr"><br></div><div dir="ltr" class="gmail_attr">From: <strong class="gmail_sendername" dir="auto">Robert Liveanu via CANUFNET</strong> <span dir="auto"><<a href="mailto:canufnet@list.web.net" target="_blank">canufnet@list.web.net</a>></span><br>Date: Thu, Jan 9, 2020 at 8:08 AM<br>Subject: [CANUFNET] Following up on community planting projects<br>To: <<a href="mailto:canufnet@list.web.net" target="_blank">canufnet@list.web.net</a>><br>Cc: Robert Liveanu <<a href="mailto:foret@af2r.org" target="_blank">foret@af2r.org</a>><br></div><br><br><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"><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" 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/" 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 style="font-size:10.5pt;color:black"> </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/" 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/" 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/" 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" target="_blank">www.uneforetdepossibilites.com/jycrois</a></span></p></div></div></div></div></div></div>