[CANUFNET] Following up on community planting projects

[Jacob Caggiano]

We worked with The Pennsylvania Horticultural Society in the greater
Philadelphia area to build a Treeplotter application
<http://pg-cloud.com/phs> 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).

Happy to go into more detail privately if there's interest from anyone on
the list.

-Jacob

<https://www.planitgeo.com/>
<https://www.linkedin.com/company/plan-it-geo/?viewAsMember=true>
<https://twitter.com/planitgeo2012>
<https://www.facebook.com/PlanItGeo2012/>
<https://www.instagram.com/planitgeo/>


Treeplotter.com
PlanITgeo.com

Jacob Caggiano

TreePlotter™

Account Executive


M: 509.432.1674

P: 303.214.5067

From: Robert Liveanu via CANUFNET <canufnet at list.web.net>
Date: Thu, Jan 9, 2020 at 8:08 AM
Subject: [CANUFNET] Following up on community planting projects
To: <canufnet at list.web.net>
Cc: Robert Liveanu <foret at af2r.org>


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/20200115/4cc836b2/attachment-0001.htm>