130 likes | 598 Views
Storm Damage Assessment Protocol. Analysis and Reporting. Overview. Estimating Engine Report Means Resources. Estimating engine. Engine built as Excel ® spreadsheet 6 worksheets Home/ReadMe – navigation, help PreStorm Data – setup data PreStorm Analysis – preliminary analysis
E N D
Storm Damage Assessment Protocol Analysis and Reporting
Overview • Estimating Engine • Report Means • Resources
Estimating engine • Engine built as Excel® spreadsheet • 6 worksheets • Home/ReadMe – navigation, help • PreStorm Data – setup data • PreStorm Analysis – preliminary analysis • PostStorm Data – damage data • PostStorm Analysis – report form • Codes, lookup tables – functional elements • Use of Excel® based on user survey
Procedure • Methods I • Starts with field data • Simple scaling by street miles • Relies on sample size being sufficient for damage variance • No statistics applied for emergency use
Procedure • Methods II • Pruning, removals: straightforward • Debris: depends • Pre-storm data • Uses calculated tree density • No pre-storm data • Uses estimated tree density (Very low, Low, etc.) • Based on data from 13 Northeastern communities • Local costs used, tho averages suggested
Report • = Calculation page (PostAnalysis tab) • Methods visible • Advantages • Credibility • Ease, speed
Validation • Sampling indicated on report • Means of random sampling • Percent street miles sampled • Numbers derived right on sheet • Debris • Pruning, removal • Local costs shown http://www.photolibrary.fema.gov/photodata/low/10940.jpg
Future • Wish list • Add 6-mo. damage inventory • Tree-by-tree • Inspired by FS method after Katrina • Convert to single VB app • Integrate with STRATUM • Will depend on available time and money http://www.nrri.umn.edu/ecoview/tree3.jpg
Resources • One-stop shopping: • www.itreetools.org • Resource/Learning Center • Protocols, reports • 8pp glossy brochure