1 / 34

Tools for Data Management and Reporting: Levels 2 and 3

Tools for Data Management and Reporting: Levels 2 and 3. June 18, 2008 Forbes Boyle & Michael Lee CVS-EEP Project Manager & Data Entry Tool Author. OBJECTIVES. Vegetation Monitoring Data Walk-Thru Level 2 Data Entry: Tips for Faster Data Entry Levels 1 and 2 QA / QC Procedures

Download Presentation

Tools for Data Management and Reporting: Levels 2 and 3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Tools for Data Management and Reporting: Levels 2 and 3 June 18, 2008 Forbes Boyle & Michael Lee CVS-EEP Project Manager & Data Entry Tool Author

  2. OBJECTIVES • Vegetation Monitoring Data Walk-Thru • Level 2 Data Entry: Tips for Faster Data Entry • Levels 1 and 2 QA / QC Procedures • Levels 1 and 2 Report Generation • Introduction to Level 3 Data Entry

  3. VMD Resampling • Step 1: Go to the Reports Tab under the Main Menu >> Datasheets for Resampling

  4. VMD Resampling • Step 2: On the “Resample Plots” Form, update year fields if incorrect.

  5. VMD Resampling • Step 3: On the “Resample Plots” Form, update Plot Level fields if desired.

  6. VMD Resampling • Step 3: Print Datasheets of desired monitoring plots.

  7. VMD Field Datasheets

  8. VMD Resampling • Step 4: RESAMPLE!!! • Step 5: Enter data in the existing Entry Tool for that Project.

  9. VMD Data Entry Tool

  10. VMD Woody Stem Data Entry Tool

  11. Level 2 Data Entry • TOTAL WOODY STEM INVENTORY PLOTS: Planted woody stems + natural regeneration.

  12. Level 2 Fast and Efficient Data Entry! • Don't forget the header info (especially minimum stem size sampled = cut-off).

  13. Level 2 Fast and Efficient Data Entry! • Magic Species List and Species Lookup

  14. Level 2 Fast and Efficient Data Entry! TAB / SPACE BAR: Next Field UP/DOWN ARROW: Adjacent Row ENTER: Next Species Row, First Field MOUSE: To add in Subsample %

  15. Level 2 Fast and Efficient Data Entry! • Often, there is just one size category, or the smaller categories are absent • To jump to a particular size: • Press and hold ctrl, then enter the size of the stem class (lower bound, e.g. 30 or 45), then release ctrl • If you enter a size less than 40cm, the default of 1 stem is filled in (you can change the number if not 1) • If you enter a size of 40cm or greater, that size is entered in the first box for stems at least 40cm

  16. A stem isn't planted after all • Sometimes stems are added in the Planted Stems Form, but later someone determines that it should be included as a natural stem instead. • Previously, you had to delete this stem and add it in the Natural Stems Form. • Now, you can change a stem to "natural" with a couple of clicks….

  17. A planted, no wait, a natural stem! • At the bottom of the Planted Stems Form, click the button: Change stems to "natural" or undo • A new green box appears with "N" for natural stems and "P" for planted. Double-click on the "P" to change the stem from planted to natural. Double-click the "N" to return the stem to a planted stem. • Click the button at the bottom of the screen again to change all stems on the plot to natural or to planted (you'll be prompted to confirm that). • Natural stems will still be shown on the Planted Stems Form, with the flag "Natural STEM: NOT PLANTED" and will not be included in planted stem density in Excel reports or when printing monitoring reports.

  18. Quality Assurance / Quality Control

  19. Quality Assurance / Quality Control:Embedding Errors 410

  20. Quality Assurance / Quality Control:Embedding Errors

  21. Quality Assurance / Quality Control:Embedding Errors

  22. Quality Assurance / Quality Control:Embedding Errors

  23. Using the Data Entry Tool to Generate Simple Reports • Summary of stems per plot in Excel. • Can choose a subset of plots in "Configurable Stats." • Can be copied and pasted into a Word document and used in larger written reports.

  24. Using the Data Entry Tool to Generate Simple Reports • Export to Excel to provide spreadsheets of stem data, including: • Plot Metadata (location, level, year, number of stems [planted and natural], stems per acre. • Total number of stems per acre by project • Tally of damage – no damage AND vigor categories of stems by species and type • Total number of planted/natural stems by plot

  25. Plot Metadata

  26. Total Number of Stems per Acre by Project Vigor by Species

  27. ….or use “Customizable Statistics” to only look at a subset of plots

  28. Level 3 Data Entry • COMMUNITY OCCURRENCE PLOTS: • Used to document abundance of most common species within a plot: COVER CLASS VALUES • Meets standards of Ecological Society of America (ESA) AND Federal Geographic Data Committee (FGDC) to classify vegetation within US National Vegetation Classification (NVC) • Woody stem tallies from Level 2 may also be used

  29. Level 3: Plot Data Entry • Similar to the Levels 1 and 2, except these fields added: • 1) Community Classification Determination • 2) Cover By Strata Definition • 3) Extra Geomorphology and Hydrology values • Digital Data Entry Form mimics Field Data Entry Sheets

  30. Community Classification • Step 1: Generate List of NVC Associations: CEGL codes

  31. Community Classification • Step 2: Read community descriptions of acceptable community types (based on named geography, title descriptions, etc.): • http://www.vegbank.org/

  32. Community Classification • Step 3: Select acceptable community type(s), label degree of fit (Excellent, Good, Fair, Poor, Wrong), label confidence of classication (High, Medium, Low), and enter Classifier(s).

  33. Level 3 Cover Data Entry • Similar to the stems forms. • Magic species picklist or search for species (more species are shown, not just the woody species). • After entering a cover value, it moves cursor to next field. • Use arrow keys and enter key • Header data appears after you start a row.

  34. QUESTIONS??

More Related