Excel template for STRATUM data
Moderators: i-Tree Support, i-Tree Team
Excel template for STRATUM data
I was talking at a conference yesterday with some STRATUM users, and we agreed that it was a pain to have everybody have to format the Excel spreadsheet with the right headers and then try to remember the right codes. I told them I would post a free template for general use, so here it is:
Click to download Streets data spreadsheet
Hope this helps other people--please let me know if you run into problems or have suggestions.
----------
BTW: by rights, a post like this belongs in a forum with a title such as "Tips and tricks"--any chance the i-Tree Team might create one and move this over there?
Click to download Streets data spreadsheet
Hope this helps other people--please let me know if you run into problems or have suggestions.
----------
BTW: by rights, a post like this belongs in a forum with a title such as "Tips and tricks"--any chance the i-Tree Team might create one and move this over there?
Last edited by Jerry on Thu Jan 19, 2012 10:35 am, edited 2 times in total.
Great
Thanks--and thanks!
It looks like attachments are not allowed on this new forum, is that correct?
It looks like attachments are not allowed on this new forum, is that correct?
Nope
The whole Attachment panel that is visible when I start to make a new post in the Trainer's Corner, for instance, is missing here.
Is this template still valid? I ask because I see on this page of the new (terrific) i-Tree website that there now is an Excel template that has a zillion additional fields. Are those fields required to be present for i-Tree Streets 3.0?
TIA
TIA
Streets- importing existing data
The old template for STRATUM should still work in the import process. Recognizing that there were a zillion new fields to accommodate the pest detection protocol, the import process has been simplified in Streets to allow users to import existing data that without requiring users to account for all the additional fields and fill in null values etc. Thus, users can import with a minimum of SpCode and DBH and Streets will create a database with the other fields.
Note: that you will need to go through the steps to make up a new project first with an empty database; save the new project. You can then do a File- Import- Inventory Data and navigate to your existing data to bring it into Streets.
I have copied information from pg 25 of the Streets manual below for reference for other users.
Formatting Existing InventoriesIf you are working with an existing inventory, you must format your data to conform to the Streets requirements. The end result will be a Microsoft Access database that includes at least Species and DBH fields, but can additionally include any of the 28 fields in Table 1 page 26 in the Streets manual and/or all of the fields used in the Pest protocol (see Appendix 3). The Access file can have any name, but the table within it containing the inventory must be called STRATUM_Inventory.
The requirements for formatting are as follows:
You are only required to include fields for which you have data. If, for example, you only have species and DBH data, your database will only need two columns.
The field names must appear exactly as they are shown in Table 1. Spelling is critical.
Your data must match the format shown in Table 1. For example, the SpCode field must be formatted as text and the DBH field must be formatted as a number.
Entries without data should be left blank or filled with zeros.
Access or Excel templates for Streets are available at www.itreetools.org > Resources.
Al
Note: that you will need to go through the steps to make up a new project first with an empty database; save the new project. You can then do a File- Import- Inventory Data and navigate to your existing data to bring it into Streets.
I have copied information from pg 25 of the Streets manual below for reference for other users.
Formatting Existing InventoriesIf you are working with an existing inventory, you must format your data to conform to the Streets requirements. The end result will be a Microsoft Access database that includes at least Species and DBH fields, but can additionally include any of the 28 fields in Table 1 page 26 in the Streets manual and/or all of the fields used in the Pest protocol (see Appendix 3). The Access file can have any name, but the table within it containing the inventory must be called STRATUM_Inventory.
The requirements for formatting are as follows:
You are only required to include fields for which you have data. If, for example, you only have species and DBH data, your database will only need two columns.
The field names must appear exactly as they are shown in Table 1. Spelling is critical.
Your data must match the format shown in Table 1. For example, the SpCode field must be formatted as text and the DBH field must be formatted as a number.
Entries without data should be left blank or filled with zeros.
Access or Excel templates for Streets are available at www.itreetools.org > Resources.
Al
A member of the i-Tree Team
We very much appreciate the use of the template for our work; however, we have found some discrepancies (and I am not sure I am allowed to attach a template). As we have been reformatting existing inventories, we have found some items that may cause fustration for users.
In the template, TreeID Zone StreetSeg CityManaged SpCode have an apostrophe before the word. This will need to be deleted before processing. Also note, TreeID is no longer used in Streets. It is now ID. The template is a great tool and we appreciate someone putting it together. These additions should make things a little easier.
In the template, TreeID Zone StreetSeg CityManaged SpCode have an apostrophe before the word. This will need to be deleted before processing. Also note, TreeID is no longer used in Streets. It is now ID. The template is a great tool and we appreciate someone putting it together. These additions should make things a little easier.
Well I put it together, as I describe in the first post of this thread, and am glad it was useful to you. I appreciate your looking at it carefully, and making such useful comments.
Would the i-Tree Team like to take this over at this point? They are welcome to change it and put it on their own server, and just redirect the link in the opening post.
I won't be able to turn to this until I come back from 2 weeks out the country anyway, so by then we should know how they would like to see this proceed.
Would the i-Tree Team like to take this over at this point? They are welcome to change it and put it on their own server, and just redirect the link in the opening post.
I won't be able to turn to this until I come back from 2 weeks out the country anyway, so by then we should know how they would like to see this proceed.
Streets Template
We also greatly appreciate helpful tools that users share with other i-Tree users as our resources are limited also. If you have modified the template posted by Jerry for use at Virginia Tech, you can upload the updated file using the "add an attachment" option in this thread for others to use in the future.
The development staff has an Excel spreadsheet (Streets Excel Import Template) on the server in the Resources - Archives section of the website that can be adapted to the data fields in one's inventory. Granted this template has all the fields added for the pest detection module but they can be deleted if not needed as can other fields that aren't being utilized.
Since users are now only required to have SpCode & DBH at a minimum to import an inventory into Streets, it may be confusing to add another template on the server that is showing the 17 fields required from the original STRATUM import process. http://www.itreetools.org/resources/archives.php
The development staff has an Excel spreadsheet (Streets Excel Import Template) on the server in the Resources - Archives section of the website that can be adapted to the data fields in one's inventory. Granted this template has all the fields added for the pest detection module but they can be deleted if not needed as can other fields that aren't being utilized.
Since users are now only required to have SpCode & DBH at a minimum to import an inventory into Streets, it may be confusing to add another template on the server that is showing the 17 fields required from the original STRATUM import process. http://www.itreetools.org/resources/archives.php
A member of the i-Tree Team