170 likes | 367 Vues
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)
E N D
Colorado EDAS Enhancement and Index Development2004 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) • Build biological assessment and biological criteria tools for Colorado • Multimetric index (IBI) • O/E index
Upgrade EDAS • Enter habitat data • Upgrade EDAS to migrate data to STORET 2.1 • EDAS training
Data entry Geospatial Coverage • 435 Stations • 505 Benthic Macroinvertebrate Samples • 161 Habitat Samples • 55 Field Water Chemistry Samples
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
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.
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
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.
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
Upgrade Potential Enhancements • Data entry • Forms that look and feel like field, lab sheets • Reporting features • Creation of reports from data within EDAS
Upgrade Mississippi DEQ Data Entry forms
Upgrade: Reports
Upgrade Reports
Index development • Methods – sampling protocol recommendations • Multimetric index • RIVPACS (O/E) index (USU) • Training
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
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.