E-TRAC User`s Manual
Contents
1. 02 2 222 2 00 een nnn n ence eee n nnn n ene e een n ence eneneeeennneceees Canker Indicate if there is a canker and if known whether it is caused by a fungus or insect mechanical damage Crack Indicate if there is a crack and if so what type Or indicate if there are multiple cracks Deadwood Indicate if the entire tree is dead one or more branches are dead or if a branch is broken and lodged Decay Indicate if there is decay and or a cavity Poor Arch Poor Branch Crown Architecture Indicate if the branches are equally dispersed around the tree or if the crown is unbalanced Also indicate if one or more branches are abnormally formed or if branches have been topped or storm damaged Weak Union Weak Branch Union Indicate if one or more branches are weakly attached due to included bark epicormic sprouting or both DEFECTS TRUNK 2 2 2222 nnn nn nn nn nnn nnn nnn enn enn nnn nnn nnn e nee en eee n ee nnees Canker Indicate if there is a canker and if known whether it is caused by a fungus or insect mechanical damage Crack Indicate if there is a crack and if so what type Or indicate if there are multiple cracks Decay Indicate if there is decay and or a cavity Shell outermost layer of undecayed wood If there is decay indicate the thickness of the remaining shell undecayed outer layer surrounding the decay column Take 3 measurements and record the average A2. E TRAC Installation and Operation Page 25 You may export your data from the Archived_SurveyData table in ETRAC MDB to an EXCEL spreadsheet CSV files at any time This export can be filtered by a user defined date range Also CSV files can easily be imported into various other database and statistical programs RGE Edt Tree Costing and Estimating Reports About Suryvewor List Species List amp E Electronic Tree Ri Risk one Descriptions Customize Fisk A ating Street List Export Data to Excel CS file Create an E TARAC Storage Card Storage Card Data Transfer E mit Excel Export Include Tree Inventory Dates Yan 1 2007 TO May 5 2007 Create File Exit Where do you want to place the CSW file G My Documents 3 State CERT Data 4 My Computer O foodstock Mills Er a My Network Places PSL EPMLEOO CSY My Recent AJAX Control Toolkit Bah EPIEMJOO CS Y Document i Bluejaydata on ned NET 2005 Projects ay a 9 ETRAC NewReports Shortcut to WB S8 Hazard_Tree_ETRAC_PLUS_PLUS Gos 2005 Projects O Lawnside Desktop 9 Misc Clutter lt O Munis Conversion G MySQL_Tools 9 Nelar 2 Park payroll en O Park Accounting O RASDAR hy Documents My Computer ile namg iMyTreeData CSV oc Cancel E TRAC Installation and Operation Page 26 Appendix A Installing the NET Compact Framework The Pocket PC portion of the E TRAC program requires that the Microso
3. The PDA portion of the program requires the use of a storage card Different models of Pocket PCs may use different types of storage media Typically these may be referred to as SD Cards Compact Flash SD Mini Multimedia Cards or Trans Flash cards Storage cards are inexpensive and rapidly getting more so A 1GB card will hold the data for many thousands of trees The tree data is automatically deleted from the cards after it is imported into the PC database so they are reusable IMPORTANT If your Pocket PC accepts more than one kind of storage card like some Dell AXIM models it is important that you only insert ONE at a time in the device when using E TRAC The E TRAC Pocket PC program will try to detect your storage card when it runs and may be confused if there is more than one there Field data is transferred to the E TRAC desktop program by using a card reader attached to your desktop laptop computer Typically these readers use a USB port to connect to your computer You should be able to find a reader that works with your storage card at an office supply or electronics store for around 25 E TRAC will NOT work with a Macintosh unless you have installed Windows nor will it work with any PDA running the Palm OS IMPORTANT NOTE ABOUT ACTIVESYNC Ifyou don t have ActiveSync or for VISTA users Windows Mobile Device Center installed and you are not using your Pocket PC for anything other
4. DO NEF Pa MODERATE ase ER ET Rear AC FA GIWEET ACACIA Yiieetacom 1 iatsei1 FEk Zoe HIGH Haa SAFO is Teet i Tree ID Rikzome t Street Mame O loati Specks BH ate Eval Fkk Rating Do NEF 4 Pt AGH HAZa RD ag a TWATER ST Pear ac MPMLFOR NETTIE E EEEN EACAN 1i HGHhHazaFD i0 MANT Fear SCS NMULGA Ps SO 2 HIGHHASARD 0 _ MAINST Rear AC AN MULGS PG OB 2005 sd sas int E TRAC Installation and Operation Page 24 Trees Needing A Specific Corrective Action Report This report is similar to the previous Trees Needing Corrective Actions report The difference is that is contains ONLY the specific corrective action you select Trees Needing a Specific Comective Acton Include Risk Ratings 0 Select Corrective Action 03 Remove Tree Include Risk one ies ALL HHN F L Report will be sorted by Street Address Print Report Exit pF Trees Needing a Specific Gausslies Acton id 4 1 2 BE aq oF Trees Needing 05 Remove Tree Risk Rating 0 i Fek Zoe MODERAT i Pree iee Se ep Dae Eval Sane Patt g DO NEP ee HE DERATE ATWATER ST a ee eee 2345611 FEk zore HIGH Haini Z Tees i Tree Rek oe Ste SteetName Lat Specks ae Eval Reb Rating Corectve Actors DO NE i Pe HG H HAZARD ain ATIWATER ST ee CM o ETT EE C woei 5 12a45 5 10 11 2 H HHAZARD 50 MAINST Rear ACANMULGA OE 2591011
5. Data Entry Tip Sheets Edit Tree Costing and Estimating Reports About Surveyor List Electronic Tree Risk Export Data to Excel CSW file Create an ETRAC Storage Card Storage Card Data Transfer Gelert Starane Card E e Add Edit Delete Risk Zones Risk Zone ESTREMELY HIGH Edit Delete E TRAC Installation and Operation Page 8 Customize your list of streets There are TWO methods for entering your street list Method one involves directly entering them and checking those that should be transferred to the PDA for field lookup JET Edit i Tree Costing and Estimating Reports About Surveyor List Species List Risk one Descriptions Customize Risk Rating Street List A E TRAC Electronic Tree Risk Assess Export Data to Excel CSW file Street Listing JACME ST w ALLEN ST 4 ATWATER TR BLONIAR A LN w BOSTON AD BROWN AD CADWELL ST DWIGHT AD EWERGREEN TR FLINT ST FOREST HILLS BD Import Streets from an Excel CSV File GREEN LH HAPPY LH This wall allow you to import a list of streets from an Excel CS Comma Separated Yaluez M p file See the manual for instructions on how to create this file The StreeetNames MUST be MAIN ST in the FIRST column of the file any other columns are ignored OAK HOLLOW AD OFARE CR Street names imported here are ADDED to any existing Street names already in your iT REE street list An attempt is made
6. program to Device or Storage Card select Device The CAB file will install E TRAC to the My Device Program Files ETRAC_PDA folder You can always run it by using File Explorer to navigate to that location and tapping the file However it s more convenient to find it on your menu and or program desktop It s easy to put a shortcut to the program in those places To create a shortcut on your Pocket PC Using File Explorer on your Pocket PC navigate to My Device Program Files ETRAC_PDA and find the ETRAC file It has a red triangle next to it Press AND HOLD your stylus on this file until an animated circle and a drop down menu appears Select COPY Now navigate to My Device Windows Start Menu Programs Find a BLANK space in that folder and press and hold your stylus there The animated circle and menu will appear Select Paste Shortcut NOT Paste here This puts a shortcut to E TRAC on your Pocket PC program desktop If you also want it on your START MENU just move up one level to My Device Windows Start Menu and PASTE SHORTCUT again Your Pocket PC may automatically delete the CAB file from your storage card If it did not use File Explorer to do that E TRAC Installation and Operation Page 4 Step 3 Install the E TRAC Desktop program on your PC If you have a previous version of the E TRAC desktop program inst
7. than E TRAC we recommend that you NOT install it If you already have it installed and it starts whenever you insert your Pocket PC in its cradle then we recommend that you shut it down before doing any E TRAC operations f ts technically possible to transfer files to and from the Pocket PC using ActiveSync but unless you are an experienced ActiveSync user it will cause you some confusion and we don t recommend it E TRAC Installation and Operation Page 3 Step 1 Set up your Pocket PC Refer to Appendix A You must determine the version of the NET Compact Framework which is on your Pocket PC and install Version 2 if necessary DO NOT SKIP THIS STEP Please note that it is NOT necessary to install or use Microsoft ActiveSync or the VISTA equivalent You may still need the cradle or sync cable that came with your Pocket PC in order to charge the battery but you WILL NOT be using it to transfer data Step 2 Install the E TRAC program on your Pocket PC One of the files you got when you downloaded E TRAC is ETRAC_PDA CAB Using your desktop PC and storage card reader copy ETRAC_PDA CAB to a storage card Insert the card in your Pocket PC On your Pocket PC use File Explorer a program to find the CAB file on the card and tap it to run it You may be warned that the file is from an unknown publisher If you get this message just tap Yes to continue If you are asked whether you wish to install the
8. the questions just delete all the response alternatives and while it WILL show on the PDA that question will NOT be counted in the calculated Risk Rating Question label Size of Defective part Not Assessed lt 4 Inches 4 20 inches Any response alternative left gt 20 inches BLANK will NOT appear on the PDA E TRAC Installation and Operation Page 10 Step 5 Create an E TRAC storage card The E TRAC program uses the storage card to transfer information between the PC and Pocket PC When you start the E TRAC Pocket PC program it will look for a properly formatted E TRAC storage card If it can t find it it will protest and close down The following exercise will create a storage card with some default values for the configuration items You may easily change them later Using your DESKTOP PC insert a storage card in your reader and connect it to the PC where you installed the E TRAC program Start the E TRAC program J61 Edit i Tree Costing and Estimating Reports About Surveyor List Species List Risk Zone Descriptions p A E T RAC Customize Risk Rating ge Streetia e Electronic Tree Risk Assessment Calculator Export Data to Excel CSW file Create Update an ETRAC Storage Card gt torage Card Data Transfer Exit a5 Select Storage Card E c SYSTEM Refresh List WV Save Individual Tree Files from PDA to this computer after data Transfer Import Field Data from Storage Card W Set up your PDA Spe
9. E TRAC Electronic Tree Risk Assessment Calculator Installation and Operation Manual October 2008 File Edit Costing and Estimating Reports About A E TRAC r Storage Card Data Transter Select Storage Card E c SYSTEM Refresh List W Save Individual Tree Files fram PDA to this computer after data Transfer Import Field Data from Storage Card USDA Forest Service Canng fer ibe Land and Serving People E TA 3 39 E TRAC Electronic Tree Risk Assessment Calculator Friday January 11 7008 Add Trees Fiew Edit Delete a Tree Storage Card detected NOT LOGGED IM 4 treefs on file version 20080111 E TRAC Installation and Operation Page 1 Table of Contents WHAT YOU WILL NEED TO RUN E TRAC 200 eecceeeeeeeeeees 3 SEPE SOLID YOUR Pocket PC sari ci cascswsscecmeetcnvwaconch isaagiainenvraaesduaenanian wonaeeolnnaseenieatiae 4 Step 2 Install the E TRAC program on your Pocket PC eeccccceeeeeeeees 4 Step 3 Install the E TRAC desktop program on your laptop desktop PC 5 Step 4 Customize your lists e g surveyors streets Species sssssssseeeesse 6 11 Feld SULVCY OLS aa A ONA 6 SPECIES eaaa 7 Community Risk Zones ccccccccccceeceeseseeeeeeeeeeeeaaes 8 US CUS aati fares sar vaca E E E T 9 Tree Rsk RIOS n tinned teentaaniaen 11 Step 5 Create an E TRAC storage Cardoner E EE 12 Step 6 Use the E TRAC program to collect f
10. alled please go to the Control Panel on your desktop PC and UNINSTALL it When you obtained the E TRAC program you received a file entitled Install ETRAC_Desktop ZIP This compressed file contains the three files you will need to install the Desktop Program Q First unzip the files in the ZIP file to a temporary folder somewhere on your PC It does not matter where you create this temporary folder as long as you can find it It s probably most convenient to create it on your Windows Desktop The 3 files in the ZIP file are SETUP EXE SETUP LST ETRAC_DESKTOP CAB Q Locate your temporary folder and run SETUP EXE by double clicking it a You may get one or more messages during the setup which tell you that A file being copied is not newer than the file currently on your system Each time you see such a message click the YES button to keep your current file Q Follow the instructions on the screen to install the program It will suggest installing the program to C Program Files ETRAC_Desktop on your computer It is best to let it do that If you want to change where the program is installed you may do so E TRAC Installation and Operation Page 5 Step 4 Customize your lists e g surveyors streets species The desktop program is very simple to operate Click the START button on your PC VISTA users will click the Windows globe icon Select ALL PROGRAMS and navigate to ETRAC_Desktop to run the program The screen s
11. ame Species List Species ABBA ABIES BALSAMEA J ABCO ABIES CONCOLOR AC ACER SFF TACGIACER GINNALA ACNE ACER NEGUNDO ACNI ACER NIGRUM ACPL ACER PLATANOIDES KIELC d Edit Delete mooo Erd Ad Exit Method TWO We have included the STATUM Species database which was placed on your computer when you installed E TRAC It contains a number of tables which list Tree Species by Climate Zone You select the climate zone appropriate for your location and import the list of species into E TRAC Reports About 4 A E TRAC a Customize Risk Rating J Electronic Tree Risk Assessment Street List Export Data to Excel CSW file Az Storage Card Data Transfer CreateUpdate an ETRAC Storage Card n zh rs Select Storage Card E c SYSTEM S K en Import Tree Species By Climate Zone Import Tree Species By Climate Zone lf you do this IT WILL REPLACE any species list that may already be in ETRAC Step 1 Locate Stratum_Species_List MDE Enter Path or Browse for the file C Program Files ETRAC_Desktop Stratum Species Database mdb Step Select from the available climate zones im this file Refresh Climate one List 0 Pacific Northwest Step 3 Indicate Preference f Import COMMON Mame I C Import SCIENTIFIC Name E TRAC Installation and Operation Page 7 Modify your Community Risk Zones as desired for details see the Urban Tree Risk Management Guide and the E TRAC Field
12. ation just enter ONE DBH range for that Corrective Action and define a range to cover ALL the trees in your survey i e 0 to 999 inches Cost Estimates for Selected Corrective Action DEH gt DEH lt Estimated Cost 0 359 200 00 Enter Cost Information Es piece Sc u0n Se ee er ot Add New Delete Print Cost Matrix Save and Exit E TRAC Installation and Operation Page 21 E TRAC File Edt i Tree Costing and Estimating Man mie Risk Reduction Cost Summary Reinspection Report Trees Needing Corrective Action Trees Needing 4 Specie Corrective Acton Print Corrective Action Code Reference Sheet PDF ssment Calculator raoa caina amr g Select Storage Card Sc SYSTEM Refresh List W Save Individual Tree Files from PDA to this computer after data Transter Import Field Data from Storage Card All E TRAC reports are based on the contents of the _Archived_SurveyData table in ETRAC MDB Risk Reduction Cost Summary report For this report to work properly you must assign costs to EACH of the 11 Corrective Actions See the section earlier in this document on how to do that The report allows you to select a date range based on the date the tree was surveyed and a Risk Rating range You then pick the corrective actions to include and the way in which you wish to have the report sorted Cost Report Options Include Tree Inventory Dates ee Jan 1 2007 To Dec31 2007 gt Conect
13. cies List W Set up your PDA Street List i Customized your Tree Risk Ratings i Customized your Community Risk ones Select Storage Card e Place the Storage Card in the Reader Select it from the list above and press this button Thiz process will have NO effect on any field tree data which may be on the storage card Check all the boxes Select the location of your storage card from the drop down list Press the button After a few seconds a confirmation message should appear You can now close the E TRAC desktop program Remove the storage card insert it into your Pocket PC and start the E TRAC Pocket PC program The E TRAC program should find the storage card and the main menu should appear E TRAC Installation and Operation Page 11 Step 6 Use the E TRAC program to collect field data on your Pocket PC If you followed the installation recommendations and created a shortcut to the E TRAC program you will find the program on your Pocket PC under Programs It has an icon which 1s a red triangle with an exclamation point in it Games Electronic Tree Risk Assessment Calculator gt Friday January 25 2008 Messenger B Bs Add Trees otes Pictures Pocket Excel Yiew Edit Delete a Tree I Storage Card detected Pocket MSM ira ih NOT LOGGED IN ar una 6 treets on file Version 0080125 The following pages walk you through how to collect data on the Pocket PC Refer to pa
14. e Specify the name of the street for street trees or name of the park for park trees Location Specify the location of the tree in relation to the orientation to the building e g front side or indicate if the tree is located in a street island median or park Species Indicate the species If unknown choose unknown If the species is not listed choose other and type it on the notes page last screen DBH Record the trunk diameter at breast height 4 5 Site Notes Use a number or descriptive text to indicate a more precise location of the tree if there are multiple trees at that same address median or park This is particularly important if there are multiple trees of the same species and trunk diameter INS RN cc cae Physical Obstruction Indicate if the tree branches are too low over the sidewalk road or both Visual Obstruction Indicate if the tree branches are blocking views of a critical or non critical sign or sight lines at an intersection or driveway Utility Conflict Indicate if tree branches are interfering with primary electric wires secondary electric wires service drop wires to a house or non electric wires e g phone cable Data can also be added directly into the desktop program without a Pocket PC E TRAC Installation and Operation Page 16 See the Urban Tree Risk Management Guide Chapter 3 p 41 88 for details regarding defects DEFECTS CROWN BRANCHES
15. ersion 1 AND Version 2 installed that is ok If you need to install the NET Compact Framework we recommend that you use the CAB files we provide on the E TRAC web site you can also download them directly from Microsoft Determine which file you need based on the table below If you guess incorrectly it simply won t work and you can then pick the other one Pocket PC Operating System CAB file required Windows Mobile 6 NONE Windows Mobile 5 NETCFv2 armv4i cab Windows Mobile 2003 or 2003SE NETCFv2 ppc arm4 cab Using your storage card reader copy the correct CAB file to a storage card Insert the storage card in your Pocket PC Use File Explorer to navigate to the Storage Card find the CAB file and tap it to run it If you have the correct file it will begin to install the Compact Framework If you get an error message try using the other CAB file If you are asked whether you wish to install to the DEVICE or the CARD select DEVICE You may be prompted to restart your Pocket PC after the installation After the installation is completed you may use File Explorer to delete the CAB file from your storage card your Pocket PC may delete it automatically for you E TRAC Installation and Operation Page 27
16. ft NET Compact Framework Version 2 be installed on your mobile device If you have a Windows Mobile 6 device you should already have the proper version of the Compact Framework pre installed You will need a Pocket PC GPAQ AXIM or similar device running Windows Mobile 2003 Windows Mobile 2003SE Windows Mobile 5 or Windows Mobile 6 E TRAC will not work with older versions of the Mobile operating system The first step is to determine what operating system is on your Pocket PC device On your Pocket PC select SETTINGS Then select the SYSTEM tab and tap the ABOUT icon If the version number begins with a 4 5 or 6 the chances are pretty good that you are ok proceed to the second step If not search www microsoft com to see if NET Compact Framework 2 can be installed on your device Please be aware that Microsoft licenses many versions of their mobile operating system to manufacturers who adapt it to their own purposes This results in devices with a variety of screen sizes and shapes and other factors which may or may not be compatible with E TRAC The second step is to determine if you have the correct version of the NET Compact Framework on your Pocket PC On your Pocket PC select PROGRAMS and then FILE EXPLORER Using File Explorer navigate to the WINDOWS folder You will find a file named CGAUTIL Tap this file to run it If the version number is 2 0 6129 0 or higher you are all set You may also be told that you have both V
17. ges 17 20 for technical details on field data entry E TRAC Installation and Operation Page 12 Survey Date Tree ID EE January 2008 ES Address Street or Park Name al Sie 1 2 3 4 5 E 6 7 8 9 10 11 12 Location Side 13 14 15 16 17 18 19 Species 20 21 22 23 24 Bias 26 ach me Sel ee DBH 34 5 6 7 8 3 Use MENU Today 1 25 08 Please Identify Yourself pile Motes li 213 4 5 6 7 8 9 0 1 keyboard Tap a wlel r t y ljulijol p et cee etal Chale sel Click to pop up a to navigate Select Community Risk Zone C HIGH HAZARD 4 Donna Murphy shifty x c Y bjnjm F cuj NJi te Continue E Back Next CANCEL a oF is pire EH Eri TEA F PE hh oO ae ha oE TAT ae AO ma ac I sis 89 c e GEEA ID of currently selected tree will display at the top of each screen Physical Obstruction 1 Sidewalk Clearance isual Obstruction 1 Critical si Y gt After entering this Utility Conflict information you have the option to do a FULL Secondary assessment or proceed immediately to the Risk about Defects or just recordRisk Ratings Screen Ratings forthis tre You may enter detailed informati n Back Next Full Next Ratings Only Ej E TRAC Installation and Operation Page 13 DEFECTS CROWN BRANCHES DEFECTS TRUNK Canker 1 Fungal Crack 0 None Canker 2 Insec
18. hen a stem or branch is split in half defect s affecting gt 40 of the tree s circumference or CRR and extensive decay or crack s weak branch union with crack and decay leaning tree with recent root breakage or soil mounding and a crack or extensive decay dead branches broken hangers or with a crack dead trees standing dead with other defects such as cracks hangers extensive decay or major root damage visual obstruction of traffic signs lights or intersections physical obstruction of pedestrian or vehicular traffic Size of Defective Part 1 3 points 0 L NA not applicable because there are no defects and targets Parts less than 4 inches in diameter Parts from 4 to 20 inches in diameter Parts greater than 20 inches in diameter E TRAC Installation and Operation Page 18 Prob Target Impact Probability of Target Impact 1 3 points 1 Occasional Use Low use roads and park trails parking lots adjacent to low use areas natural areas such as woods or riparian zones transition areas with limited public use industrial areas 2 Intermediate Use Moderate to low use school playgrounds parks and picnic areas parking lots adjacent to moderate use areas secondary roads neighborhoods and park trails within moderate to high use areas and dispersed campgrounds 3 Frequent Use Emergency access routes medical and emergency facilities and shelters and handicap access areas high use school playgrounds park
19. hown below should appear Set up your Surveyors Risk Zone Descriptions Risk Ratings Street and Species lists Once established they are saved in the ETRAC MDB database The settings are transferred to the storage card when you select Create an ETRAC Storage Card from the menu shown above The settings are read by the Pocket PC each time the card is inserted and the Pocket PC E TRAC program is started Creating and ETRAC storage card does NOT erase any Tree data which may be on the storage card To customize lists select File from the menu E TRAC EV im eee clit Costing and Estaating Reports About y Survevor List Import Species by Climate one Edit Species List FE A E TRAC Risk Zone Descriptions e i Customize Risk Fating wa Electronic Tree Risk Assessment Calculator Street List Export Data to Excel CS file Create Update an ETRAC Stofage Card a Select Storage Card E c SYSTEM Refresh List Storage Card Data Transfer Ww Save Individual Tree Files from POA to this computer after data Transter Import Field Data from Storage Card Forest Service Canng tor ibe Land and Saving People Add your field surveyors Surveyor List Edit Delete E TRAC Installation and Operation Page 6 Customize your list of species There are TWO options for getting Tree Species into the system Method ONE is to input each one as follows ETRAC will accept either the common or scientific species n
20. ibe the reason Re inspect Select the year to schedule a re inspection if needed CORRECTIVE ACTIONS 0 220222220022 een n nnn n nnn nn nnn nen n nee n nese nneee een nnneeneeeeeenneeens Put a check mark next to each corrective action needed If more than one action is needed you may prioritize these by using the notes section to record which are of greatest priority e g prune1 Use this space to write any details not captured elsewhere in the program For example 1 Add a tree species that was not in the pre programmed dropdown list 2 Prioritize corrective actions e g prune1 E TRAC Installation and Operation Page 19 Step 7 Transfer field data from the Pocket PC to the laptop desktop program File Edt Tree Costing and Estimating Reports About A E TRAC Storage Card Data Transfer Select Storage Card Se f i W Save Individual Tree Files from PDA to this computer after data Transter Import Field Data from Storage Card Connect your card reader to the desktop laptop PC Insert the storage card containing field tree data in the card reader Select the location of the storage card from the drop down list If you check the Save Individual Tree Files from PDA box your individual tree files from the storage card will be archived on the desktop PC All files imported on a particular date will be saved in a common folde
21. ield data on your Pocket PC 13 20 Pocket PC sereen SHOtS i sicsitcciSerianeiassdcesaendeitters 13 16 Field Data Entry Tip Sheets i2 c snscscenicceesatevcetes 17 20 Step 7 Transfer data from the Pocket PC to your laptop desktop PC 21 SeP o Analyze heres U ea so taneananiaieaniennensayeieacedaiehes tinct eaeh in eaeieepabeanesads 22 27 Cenerale TEP OLS 35 5ccdc4e hstctaicane eek iapestacaceteh aoe 22 26 Export the data oreinen ana 27 Appendix A Installing the NET Compact Framework cccccccccceeeeeeeseeeeeees 28 E TRAC Installation and Operation Page 2 WHAT YOU WILL NEED TO RUN E TRAC E TRAC consists of TWO programs One program runs on your Pocket PC PDA and is used to collect field data Another program runs on your PC or laptop and is used to view and edit the data print reports and export the data to other programs if desired You will need the following in order to run E TRAC v A PC running Windows 2000 XP or VISTA v A Pocket PC PDA running Windows Mobile 2003 2003SE Mobile 5 or Mobile 6 v One or more storage cards suitable for your Pocket PC v A storage card reader connected to your PC The PC program receives the field data enables you to view and edit it and allows you to create a variety of reports The PC program also permits you to configure the E TRAC program For instance you use this program to establish lists of surveyors streets tree species costs etc
22. ive Actions to Include W Move Target W Prune Deadwood Y Reduce Height I Limit Access IV PruneWeakwood M Cable Brace IW Remove Tree i Prune Clear M Crvtwildlife wW Treat SGR W Thin Crown All None Include Trees With Risk Ratings gt 0 And lt 10 gt Report Sort Order Cost High to Low Street ane C Cost Low to High Street Print hepor l Risk Rating High to Low Street C Street Cost High to Low i C TreelD Exit E TRAC Installation and Operation Page 22 Each tree which meets your selection criteria will be listed in the order which you specified E TRAC will calculate the estimated risk reduction cost for each tree based on the corrective actions identified in the survey for that tree Click these buttons to see Click to print other pages the report Cost Report Risk Reduction Cost Summary Sorted by Cost High to Low Street Tree ID f Steet S tRetName tion Specks HO RR Rate Cost O oaa A s ATWATERST OO Rear AG FA Si EET AG AGIA oo E E e E Ne ACM HAILFOIL WATTLE 10 J a0 O o oa S RST Re PART E T E X E E i2 pT Click to Zoom the report view Re inspection Report ta Reinspection Report Options For Inspections Due In w Oli oz wW O35 w g4 2007 Include Risk Ratings During the field survey E TRAC allows you Fom o To 10 to enter the YEAR you would like to re inspect a particular t
23. lso indicate the trunk diameter where the maximum decay is suspected If there is an opening crack or cavity in the shell indicate the size of that opening as a percent of the trunk diameter at the point of the opening Poor Arch Poor Trunk Architecture e Indicate if there is are codominant stems located relatively low on the tree or if there are codominant stems without a branch bark ridge BBR e Also indicate if the tree is leaning with tension buckling soil mounding or root damage DEFECTS ROOTS 2 22 220 n nnn n en nn nnn en nn nner n een nee n een e sees Buried Deep Indicate if there is too much soil over the roots and if it occurred at planting or during a grade change fill Injury Indicate if the roots have sustained some type of damage yes If known specify the type Decay Indicate if the roots show signs of decay Poor Arch Poor Root Architecture e Indicate if the there are stem encircling circling but not compressing the trunk or girdling roots e Indicate if the roots are equally dispersed around the tree or if they are unbalanced only on one side Also indicate if the roots are confined to a relatively small or narrow area E TRAC Installation and Operation Page 17 RISK RATINGS See Urban Tree Risk Management Guide Chapter 3 p 101 106 for details Prob Failure Probability of Failure 1 4 points 1 Low some minor defects present minor branch cr
24. own dieback minor defects or wounds 2 Moderate several moderate defects present 3 High stem decay or cavity within safe shell limits shell thickness gt 1 inch of sound wood for each 6 inches of stem diameter crack s without extensive decay defect s affecting 30 40 of the tree s circumference crown damage breakage hardwoods up to 50 pines up to 30 weak branch union major branch or codominant stem has included bark stem girdling roots lt 40 tree s circumference with compressed wood root damage lt 40 of roots damaged within the CRR multiple or significant defects present stem decay or cavity approaching shell safety limits shell thickness lt 1 inch of sound wood for each 6 inches of stem diameter cracks particularly those in contact with the soil or associated with other defects defect s affecting gt 40 of the tree s circumference crown damage breakage hardwoods gt 50 pines gt 30 weak branch union with crack or decay girdling roots with gt 40 of tree s circumference with compressed wood root damage gt 40 of roots damaged within the CRR leaning tree with recent root breakage or soil mounding crack or extensive decay dead tree standing dead without other significant defects 4 Extremely High multiple and significant defects present visual obstruction of traffic signs lights or intersections stem decay or cavity at or exceeding shell safety limits and severe crack cracks w
25. r which will be created and named to reflect that date After a successful data import the individual files will be deleted from the storage card A E TRAC 25 Electronic Tree Risk Assessment Calculator Tree Count x z _Petesh List omputer after data Transter E TRAC Installation and Operation Page 20 Step 8 Analyze the results Setting up Costing Estimates for the Risk Reduction Cost Summary Report A E TRAC Flartranir Tras Biel Accacemant fMalruilatar Enter Cost Information X Corrective Action E TRAC provides reporting to help you J01 Move Target estimate the cost of various Risk Reduction scenarios In order to make this work you will need to assign cost estimates to each of the 11 Corrective Actions Enter Cost Information Conective Action Cost Estimates for Selected Corrective Action Add a Cost Estimate for selected DBH Range and Corrective Action Add New Delete Tree For DEH ejo and DEH lt f0 Est Cost is 250 For example 3 to 6 would cover DBH FROM 3 0 in TO 5 99 in Print Cost Matris Save and Exit Note that the estimates are by DBH Range You may define these ranges any way you wish It is important that they DO NOT overlap and that they cover the FULL RANGE of DBH measures in your survey Print Gost batris If you decide that a particular Corrective Action DOES NOT depend on DBH in your situ
26. ree Include Risk one This report lists all such trees by Quarter and Year Sort Report By You may filter the report by Risk Zone or f Tree ID l C Risk Rating Hi to Low and Street Address include all Risk Zones C Street Address and Risk Rating f Risk Rating Hi to Low Print Report Exit a A F Eas J ils Reinspection Report Reinspection Report FOR 2007 ALL RISK ZONES Sorted by Hazard Rating Teel Reksowe Ste SteetName sss locata Specks O O O ooo o O DEH ae wall eed FER Fatiq THIGH HAZ Zapp 200 ATWATER ST Fear ACMEMILFCHIL WATTLE g oa 3 2006 O ee PT HIGH HASARO 50 MAIN ST Rear AC AN MULGA P66 S 2006 O 23 O MODERATE ATWATER ST Rear ACFA 5W EET A ACI T en e l E TRAC Installation and Operation Page 23 Trees Needing Corrective Actions Report This report lists trees optionally by Risk Zone which require ANY Corrective Action You may further filter the report by the Risk Rating Trees Needing Corrective Actions Include Risk Ratings gt 0 Include A sk one ALL XEN L Report will be sorted by Street Address and will ONLY mclude trees identified as needing one or more corective acthons Print Report Exit Trees Needing Corechve Actions 4 1 Oo 4 Trees Needing Corrective Actions Risk Rating 0 Risk Zore MODERATE C Teed Treed Rikzome t Steet Name 0 bent Specks BA Dae Eval Pkk Rating
27. s and picnic areas bus stops visitor centers shelters and park administrative buildings and residences main thoroughfares and congested intersections in high use areas parking lots adjacent to high use areas interpretive signs kiosks scenic vistas and campsites particularly drive in Other Risk Factors 0 2 points This category is to be used if professional judgement suggests the need to modify the numeric risk rating due to extenuating risk factors such as Tree Species When tree species characteristics become a factor in risk rating For example some tree species are very poor wood decay compartmentalizers such as basswood beech and birch and some tree species have growth patterns that make them more vulnerable to certain defects such as weak branch unions silver maple and branching shedding beech Site Factors Site conditions exist that significantly increase the probability of failure such as Site Changes grade changes removal of adjacent trees construction injury etc Soil Conditions shallow soils saturated soils highly compacted soils etc Standing Dead Trees Extensive numbers of standing dead trees exist ex EAB and there is a need to prioritize tree removals ex 1 dead for 3 years 2 dead for gt 3 years Length of Inspection Cycle If trees are likely to fail before the next scheduled risk inspection Description of Other Risk Factor s If points are added due to other risk factors specifically descr
28. sition when the keyboard is activated It returns to the original position when the keyboard is deactivated E 1 Move Target T Prune Clear 2 Limit Access 8 Thin Crown _ 4 Treat SGR 6 Prune Weakwood PO orerar oe A SOSPOREST HILLS RD MOT A STREET TREE 12FOREST HILLS RO SoFOREST HILLS RD 1235HAKEF RD Edit Tree Delete Tree Back Done Eaj Ta p 5 ra e led F EF fa Tasi Jaa E TRAC Installation and Operation 3 Remove Tree 9 Reduce Height 10 Cable Brace 5 Prune Deadwd 11 Cyrt Wildlife 2 4 0 10 Back Savre Done E Page 15 E TRAC FIELD DATA ENTRY TIP SHEETS Version 1 1 January 2008 E TRAC is an electronic data collection tool that complements the U S Forest Service s publication Urban Tree Risk Management A Community Guide to Program Planning and Management It is available on the website where you obtained the E TRAC program or directly at http www na fs fed us spfo pubs uf utrmm Select Community Risk Zone See Urban Tree Risk Management Guide Chapter 2 p 22 26 for details If the community is divided into community tree risk zones then select the appropriate risk zone ADD TREE oc ee Tree ID Enter a unique number for each new tree ETRAC will automatically increment by one each time a new tree is entered on the PDA Address Specify the house building number Street or Park Nam
29. t Mechanical Crack 0 None T Decay 1 Decaying Wood kd o Open Deadwood 1 Entire Tree Decay 1 Decaying Wood Poor Arch Poor Arch 1 Low Codominant Weak Union Back Next Back Next Prob Failure 2 Moderate ka Size of Defective part 7 Buried Deep 1 Planted Prob Target Impact 2 Intermediate Use ha Other Risk z Injury 0 Mone k Decay 0 None Poor Arch 1 Wo SGR s Description of Other Risk Factors Enter any text you desire here D Roots Intact j 0D Roots Intai using the pop up keyboard or the character recognition features Reinspect Rating 6 ooo iF none 2010 7 Back Next E Back Next FI ABP oera oe DEFECTS ROOTS E TRAC Installation and Operation Page 14 F SS Prob Failure 2 Moderate Size of Defective part Description of Other Risk Factor s Enter any text you desire here using the pop up keyboard or Character recognition features l i 123 1 2 3 4 5 6 7 8 9 0 Tablalwlelr t yjulijolpi ei CaPjals d fla m atk it sy shift z x c b njm cula A te gt Back Next Eg You may edit and delete previously entered trees E TRAC will not allow you to repeat a Tree ID on the Pocket PC CORRECTIVE ACTIONS Remove nails and staples trom NOTE bark Note that the text entry box changes po
30. to check for and exclude EXACT duplicates You will need to PARKER ST scan your street list to make sure that any unintended duplicates caused by small mispellings FIHE satay or non standardization are deleted AT 53 E SHAKER PO Please review your Excel file to make sure that there are NO COMMAS or SPLICE ST z APOSTROPHES within a Street Name as this may confuse the impor routine Place a CHECK next to those street names you wish to have available on the Surveyors PDAs Find CSW file and Import the Data Create File for PDAs Make sure you click the Create File for POA button if you are going to transfer your selections to the Pocket PC device Note that you may also me import a street list from an EXCEL file Add Raed Delete All Exit i Cg Import a Street List from an Excel File E TRAC Installation and Operation Page 9 Customize the Tree Risk Ratings for details see the Urban Tree Risk Management Guide and the E TRAC Field Data Entry Tip Sheets Edit Tree Costing and Estimating Reports About Surveyor List Species List Risk one Descriptions A E TRAC Electronic Tree Risk Assess Customize Risk Rating Street List Export Data to Excel CSW file Create an ETRAC Storage Card Customize Risk Rating The Rizk Rating consists of FOUR questions You may re define the title and the content of each question All FOUR questions will appear on the PDA screen IF you wish NOT to use one or more of
Download Pdf Manuals
Related Search