1 / 17

Colorado EDAS Enhancement and Index Development 2004

Colorado EDAS Enhancement and Index Development 2004. Tetra Tech, Inc. and Utah State University. Goal: improve WQCD’s capacity to incorporate biological data. Update and upgrade Colorado’s Ecological Data Application System (EDAS)

bairn
Download Presentation

Colorado EDAS Enhancement and Index Development 2004

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. Colorado EDAS Enhancement and Index Development2004 Tetra Tech, Inc. and Utah State University

  2. Goal: improve WQCD’s capacity to incorporate biological data • Update and upgrade Colorado’s Ecological Data Application System (EDAS) • Build biological assessment and biological criteria tools for Colorado • Multimetric index (IBI) • O/E index

  3. Upgrade EDAS • Enter habitat data • Upgrade EDAS to migrate data to STORET 2.1 • EDAS training

  4. Data entry Geospatial Coverage • 435 Stations • 505 Benthic Macroinvertebrate Samples • 161 Habitat Samples • 55 Field Water Chemistry Samples

  5. Data entry Data Entry • 73 stations • all with • Physical Habitat Visual Assessment • General Information • 47 have additional information • Cross Section (flow) • Field Water Chemistry • Pebble Count • Channel Information • Data entry completed except for a few needing clarification, quality control check not started

  6. Data entry Data Quality Control • 100% of data entry will be verified by a 2nd person (some one other than the data entry person). Any errors will be noted and corrected.

  7. Data entry Taxonomic Issues • 1245 total taxa • Compared with Integrated Taxonomic Information System (ITIS) the USEPA standard for taxonomy; http://www.itis.usda.gov/ • 913 matches • 332 non-matches • Non-standard taxonomic names • sp. • Stage (adult, pupae, larvae, etc.) • Will have to combine taxa before analysis • Functional Feeding Groups have multiple entries • Metrics written for only a single group not multiple • STORET won’t accept multiple listings

  8. Data entry Data Quality Issues • One relationship between Benthic Master Taxa and Benthic Data was removed • Have 18 orphaned taxa • 476 occurrences (i.e., samples) • 3,514 individuals • Will have to find the missing taxa names from bench sheets • Some habitat assessments are incomplete (missing a parameter value) so assessment will have to take this into account.

  9. Upgrade Database Enhancements • Will upgrade EDAS to the latest version that has more STORET features • Addition of Project, Trip, and Visit tables and from STORET • Will provide a way to migrate data from EDAS to STORET

  10. Upgrade Potential Enhancements • Data entry • Forms that look and feel like field, lab sheets • Reporting features • Creation of reports from data within EDAS

  11. Upgrade Mississippi DEQ Data Entry forms

  12. Upgrade: Reports

  13. Upgrade Reports

  14. Index development • Methods – sampling protocol recommendations • Multimetric index • RIVPACS (O/E) index (USU) • Training

  15. NPDES permits CAFO % Natural vegetation % Urban % Row crop Road density Mining Active Abandoned RCRA/CERCLA Hydrologic modification Landfills Information needed for least stressed identification – GIS based

  16. Habitat Embeddedness % fines Riparian condition Erosion/sedimentation Channel alteration Total score Chemical Conductivity pH SO4 Cl NO3 Total P Metals Information needed for least stressed identification – cont.

More Related