We gather here a number of small tools that are available for free download (see also Publications). Except as noted, we developed these tools ourselves. If you use any of them, we would greatly appreciate it if you could let us know about your experiences, corrections and suggestions.
In the late 1990s, good tree management applications were developed with support from the USDA Forest Service. As they appear not to be otherwise available online, we make them available here for download and use. All three will need settings adjusted to the local environment, an action explained in the detailed user's manuals that accompany each one.
- Microsoft Excel® spreadsheet. A basic inventory template that can be easily adapted by anyone reasonably familiar with a spreadsheet. Does not require Excel, and will run in any spreadsheet on any platform.
- Microsoft Access® databases. These require a familiarity with Access, but provide the ability to carry out many more advanced functions including the production of reports. Both come with Guides to orient the user. When first launched in a recent version of Windows, Access will want to update the software, which the user normally will just accept.
City Values worksheet
In order for i-Tree Streets to compute the very useful benefit-cost ratio, it requires a certain amount of data to be entered about City expenditures for tree management. This worksheet in Excel format serves three functions: 1) to organize and manage the collection of City data; 2) to help the City official involved in the collection of these data; and 3) to provide a ready Appendix for Streets projects reports so that the computational basis may be reviewed.
Data collector for Android devices
Using a free open-source app called ODK Collect from the Open Data Kit (ODK) people, anyone with an Android device--including Kindle Fire--can quickly and accurately record inventory data. Data can then be exported into a spreadsheet for use with i-Tree Streets. We have developed the form that is necessary and figured out how this is most easily done.
Interested in exploring the Statics Integrated Assessment method invented by Dr. Lothar Wessolly, we created a spreadsheet version of the load and safety calculator for desktop use. This tool is only meant for educational purposes; for professional purposes, the user is directed to the official version.
Field Load Estimator
As an aid to including potential load into the process of risk assessment, we developed a handy form for use in the field. For the documentation behind this sheet, consult the original article.
ISA BMP Tree Risk Assessment Lookup Template
Wanting to speed up tree risk assessment using the new method in the BMP Tree Risk Assessment (ISA 2011), we automated the lookup process and added additional tables. For the use of this spreadsheet, consult the original article.
Shoot Death Diagnosis
In an effort to avoid jumping to conclusions about the observation of shoot death, we developed a data dictionary in order to proceed step-wise through the process. For the argument behind this dictionary, consult the forthcoming article in Arborist News.
We have developed data-collection tools to accompany our new book on Urban Tree Health that include a smartphone app as well as a simple data sheet.
Data collector for Android devices
Using a free open-source app called ODK Collect from the Open Data Kit (ODK) people, anyone with an Android device--including Kindle Fire--can quickly and accurately record observations and interpretations on the health of an urban tree. Data can then be exported into a spreadsheet for use. We have developed the form that is necessary, following the methodology in our Urban Tree Health, and figured out how this can be done most easily.
For training and non-electronic use, we have developed a simple data sheet for field use. It provides an easy way for the user to collect health and (limited) non-health data, and to record the Health Score and summary.