colorado edas enhancement and index development 2004
Post on 31-Dec-2015
37 Views
Preview:
DESCRIPTION
TRANSCRIPT
Colorado EDAS Enhancement and Index Development
2004Tetra 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
Geospatial Coverage
• 435 Stations– 505 Benthic Macroinvertebrate Samples– 161 Habitat Samples– 55 Field Water Chemistry Samples
Data entry
#S
#S#S#S
#S#S
#S
#S#S #S #S
#S#S#S
#S
#S
#S#S
#S
#S
#S #S
#S
#S
#S#S
#S#S
#S #S#S#S
#S#S
#S
#S#S#S#S
#S#S
#S
#S#S#S
#S
#S
#S
#S#S
#S
#S#S#S
#S#S
#S#S#S
#S
#S
#S
#S#S#S
#S#S#S#S
#S
#S#S#S#S#S#S #S
#S
#S
#S#S#S
#S
#S#S
#S
#S#S
#S#S#S#S#S
#S#S#S #S
#S
#S#S#S
#S#S#S
#S#S
#S#S#S#S#S#S
#S#S#S#S#S#S #S
#S
#S#S#S#S
#S#S
#S #S#S#S
#S#S#S#S#S
#S
#S
#S
#S
#S
#S#S#S#S#S#S#S
#S#S#S#S#S#S#S
#S#S
#S
#S#S#S #S #S#S#S
#S#S#S#S
#S
#S#S
#S
#S
#S #S#S #S#S
#S #S#S#S#S#S
#S
#S
#S
#S#S
#S
#S#S
#S#S #S
#S#S#S#S #S
#S#S#S
#S
#S
#S
#S
#S#S
#S
#S
#S
#S#S
#S#S
#S
#S#S#S
#S
#S#S
#S
#S
#S
#S
#S#S#S#S#S#S#S#S#S#S
#S#S#S#S
#S#S #S
#S #S#S#S#S
#S#S#S#S#S
#S#S #S#S
#S#S
#S
#S
#S
#S
#S#S
#S
#S
#S#S#S#S#S
#S
#S
#S
#S
#S
#S
#S#S #S
#S#S#S
#S#S
#S#S
#S #S#S#S
#S#S
#S#S
#S#S
#S
#S#S
#S#S#S
#S
#S #S#S#S#S
#S
#S#S#S
#S#S#S#S #S#S#S
#S#S#S#S#S
#S
#S
#S
#S#S#S
#S#S
#S
#S#S
#S
#S#S
#S#S#S
#S#S
#S #S#S
#S#S
#S#S
#S#S#S
#S#S
#S
#S#S#S
#S
#S#S
#S#S
#S
#S
#S#S #S
#S#S
#S
#S
#S
#S#S
#S
#S#S
#S
#S
#S #S
#S
%U%U %U
%U%U
%U
%U
%U
%U
%U%U
%U
%U
%U%U
%U%U
%U%U %U
%U
%U
%U
%U %U%U
%U%U
%U
%U
%U
%U
%U
%U
%U %U%U
%U
%U %U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U%U
%U
%U %U%U%U
%U
%U
%U%U%U
%U
%U
%U%U
%U
%U%U
%U
%U
%U
%U%U
%U%U
%U
%U
%U%U
%U%U%U
%U%U
%U %U
%U
%U
%U
%U
%U%U%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U %U
%U
%U
%U
%U
%U
%U%U
%U%U
%U
%U %U
%U%U
%U%U
%U
%U
%U
%U
%U
%U
%U
%U
%U%U
%U
%U
%U
%U
%U%U
%U
%U
%U
%U
%U%U
%U%U %U%U
%U%U
%U%U
%U
%U%U
%U %U
%U%U%U
%U$T
$T$T$T$T$T$T$T
$T
$T$T
$T
$T$T$T
$T
$T
$T$T$T $T
$T
$T
$T$T
$T
$T
$T
$T
$T
$T$T$T$T
$T$T$T
$T
$T
$T
$T$T
$T
$T
$T
$T
$T$T
$T
$T
$T
$T $T$T$T$T$T$T$T$T
$T $T$T
$T
$T$T
$T$T$T$T$T$T$T$T$T $T$T
$T
$T
$T $T $T$T
$T
%U%U
%U
%U
%U%U
%U
%U
%U%U
%U
%U
%U
%U%U
%U
%U
%U
%U
%U
%U
%U
%U%U
%U
%U%U
%U %U
%U
%U%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U%U
%U
%U
%U
%U%U
%U
%U
%U
%U
%U
%U
%U
%U%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
%U
Southern Rockies
Arizona/New Mexico Plateau
Wyoming Basin
Colorado Plateaus
Southwestern Tablelands
Western High Plains
EcoregionsArizona/New Mexico MountainsArizona/New Mexico PlateauColorado PlateausNebraska Sand HillsNorthwestern Great PlainsSouthern RockiesSouthwestern TablelandsWasatch and Uinta MountainsWestern High PlainsWyoming Basin
CO BasinsStatesCO RF1
#S CO DPHE%U REMAP
NAWQA
$T Benthos
%U EMAP - 2000
200 0 200 400 Miles
N
EW
S
Colorado Sampling Sites
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.
Data entry
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
Data Entry formsUpgrade
Mississippi DEQ
Upgrade:
Reports
Upgrade
Reports
Index development
• Methods – sampling protocol recommendations
• Multimetric index
• RIVPACS (O/E) index (USU)
• Training
Information needed for least stressed identification – GIS based
• NPDES permits• CAFO• % Natural vegetation• % Urban• % Row crop• Road density
• Mining– Active
– Abandoned
• RCRA/CERCLA• Hydrologic
modification• Landfills
Information needed for least stressed identification – cont.
Habitat• Embeddedness• % fines• Riparian condition• Erosion/sedimentation• Channel alteration• Total score
Chemical• Conductivity• pH• SO4• Cl• NO3• Total P• Metals
top related