Urban forest analysis tools

Free Tree Inventory software

Desktop software

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.
  Click to download Template and Guide
• 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.
  • Basic database.
    Click to download Template and Guide
  • Advanced database developed by Jill Mahon Johnson, then with the Vermont Cooperative Extension.
    Click to download Template and Guide

i-Tree Streets

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.
Click to download

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.
Installation and Use

Risk assessment

SIA Calculator

Click to download

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.

Click to download

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.

Click to download [xls to zip]

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.

Shoot death data dictionary

Health