CATALOG DOCUMENTATION EMAP SURFACE WATERS PROGRAM LEVEL DATABASE Region 10 Oregon Deschutes Basin (R0ORDES) Water Chemistry TABLE OF CONTENTS 1. DATA SET IDENTIFICATION 2. INVESTIGATOR INFORMATION 3. DATA SET ABSTRACT 4. OBJECTIVES AND INTRODUCTION 5. DATA ACQUISTITION AND PROCESSING METHODS 6. DATA MANIPULATIONS 7. DATA DESCRIPTION 8. GEOGRAPHIC AND SPATIAL INFORMATION 9. QUALITY CONTROL / QUALITY ASSURANCE 10. DATA ACCESS 11. REFERENCES 12. TABLE OF ACRONYMS 13. PERSONNEL INFORMATION 1. DATA SET IDENTIFICATION 1.1 Title of Catalog Document EMAP SURFACE WATERS DATABASE Region 10 Oregon Deschutes Basin (R0ORDES) Water Chemistry 1.2 Authors of the Catalog Entry U.S. EPA NHEERL Western Ecology Division Corvallis, OR 1.3 Catalog Revision Date June 14, 2004 1.4 Data Set Name chem 1.5 Task Group Surface Waters 1.6 Data Set Identification Code 28 1.7 Version 001 1.8 Requested Acknowledgment These data were produced as part of the U.S. EPA's Environmental Monitoring and Assessment Program (EMAP). If you publish these data or use them for analyses in publication, EPA requires a standard statement for work it has supported: 'Although the data described in this article have been funded wholly or in part by the U.S. Environmental Protection Agency through its EMAP Surface Waters Program, it has not been subjected to Agency review, and therefore does not necessarily reflect the view of the Agency and no official endorsement of the conclusions should be inferred.' 2. INVESTIGATOR INFORMATION 2.1 Principal Investigator Spencer Peterson U.S. Environmental Protection Agency NHEERL Western Ecology Division 200 S.W. 35th Street Corvallis, OR 97333 2.2 Investigation Participant- Sample Collection U.S. Environmental Protection Agency Office of Research and Development, Region 10 3. DATA SET ABSTRACT 3.1 Abstract of the Data Set The primary function of the stream water chemistry samples is to determine acid-base status, trophic state, and classification of water chemistry type. There are two components of collecting water chemistry data: collecting samples of stream water to ship to the analytical laboratory and obtaining in situ or streamside measurements. Temperature, pH, DO, and conductivity were collected in situ. Nutrients, sulfate, chloride, ammonia, TSS, ANC, and DOC were grab samples taken at mid-channel for each reach and shipped to the analytical laboratory. 3.2 Keywords for the Data Set Acid neutralizing capacity, ammonia, sulfate, chloride, specific conductance, dissolved organic carbon, nitrate, total nitrogen, dissolved oxygen, pH, temperature, total phosphorus, total suspended solids, water chemistry 4. OBJECTIVES AND INTRODUCTION 4.1 Program Objectives The Environmental Monitoring and Assessment Program (EMAP) was designed to periodically estimate the status and trends of the Nation's ecological resources on a regional basis. EMAP provides a strategy to identify and bound the extent, magnitude and location of environmental degradation and improvement on a regional scale based on a probability-based statistical survey design. 4.2 Data Set Objective This data set is part of a demonstration project to evaluate approaches to monitoring streams in EMAP. The data set contains the results of field analysis of chemistry from a water column sample taken during spring low flow. 4.3 Data Set Background Discussion Water chemistry in streams is analyzed for two purposes. First, to understand the chemical habitat within which biota must exist so that we can understand the biological potential of the system and second, to evaluate the chemical quality of the water for the purposes of determine the potential stresses to which the biota are exposed. 4.4 Summary of Data Set Parameters Water chemistry parameters from the field are reported for one sample taken at the midpoint of the selection stream reach. These include: acid neutralizing capacity, chloride, specific conductance, dissolved organic carbon, dissolved oxygen, nitrate, total nitrogen, pH, total phosphorus, total suspended solids, and temperature. 5. DATA ACQUISITION AND PROCESSING METHODS 5.1 Data Acquisition 5.1.1 Sampling Objective To obtain a single grab sample of stream water for the purposes of chemical analysis during a sampling window from July through October. 5.1.2 Sample Collection Methods Summary A grab sample was taken below the surface using a 500 ml. beaker and then transferred to a 4-L Cubitainer. Temperature, pH, DO, and conductivity were collected in situ using a YSI meter according to the protocols identified in Lazorchak et.al (1998). 5.1.3 Sampling Start Date July 7, 1997 5.1.4 Sampling End Date October 1, 1997 5.1.5 Platform NA 5.1.6 Sampling Gear 500 ml beaker, dissolved oxygen/temperature meter with probe, conductivity meter, 500 mL plastic bottle, field themometer, 4-L cubitainer, 60 mL plastic syringes and valves. 5.1.7 Manufacturer of Instruments YSI Incorperated, Yellow Springs, OH - Model 85 Handheld Oxygen, Conductivity, Salinity, and Temperature System Operations Manual. Syringe by Mininert. 5.1.8 Key Variables NA 5.1.9 Sampling Method Calibration NA 5.1.10 Sample Collection Quality Control See Lazorchak, et al. 1998. 5.1.11 Sample Collection Method Reference Lazorchak, J.M., Klemm, D.J., and Peck D.V. (editors). 1998. Environmental Monitoring and Assessment Program- Surface Waters: Field Operations and Methods for Measuring the Ecological Condition of Wadeable Streams. EPA/620/R-94/004F. U.S. Environmental Protection Agency, Washington, D.C. Chaloud, D.J. and D.V. Peck. 1994. Environmental Monitoring and Assessment Program: Integrated Quality Assurance Project Plan for the Surface Waters Resource Group, 1994 Activities. EPA 600/X-91/080, Rev. 2.00. U.S. Environmental Protection Agency, Las Vegas, Nevada. 5.1.12 Sample Collection Method Deviations NA 5.2 DATA PREPARATION AND SAMPLE PROCESSING 5.2.1 Sample Processing Objective See Lazorchak, J.M., Klemm, D.J., and Peck D.V. (editors). 1998 and Chaloud, D.J. and D.V. Peck. 1994. 5.2.2 Sample Processing Methods Summary See Lazorchak, J.M., Klemm, D.J., and Peck D.V. (editors). 1998 and Chaloud, D.J. and D.V. Peck. 1994. 5.2.3 Sample Processing Method Calibration See Lazorchak, J.M., Klemm, D.J., and Peck D.V. (editors). 1998 and Chaloud, D.J. and D.V. Peck. 1994. 5.2.4 Sample Processing Quality Control See Lazorchak, J.M., Klemm, D.J., and Peck D.V. (editors). 1998 and Chaloud, D.J. and D.V. Peck. 1994. 5.2.5 Sample Processing Method Reference See Lazorchak, J.M., Klemm, D.J., and Peck D.V. (editors). 1998 and Chaloud, D.J. and D.V. Peck. 1994. 6. DATA MANIPULATIONS 6.1 Name of New or Modified Values None 6.2 Data Manipulation Description Chaloud, D.J. and D.V. Peck. 1994. 7. DATA DESCRIPTION 7.1 Description of Parameters Parameter Data Parameter # Name Type Len Format Label --------------------------------------------------------------------- 34 ALKALIN Num 8 Alkalinity CaCO3 mg/L 5 ALKA_F Char 10 Alkalinity, flags 31 BOD5 Num 8 BOD (5 day) mg/L 6 BOD5_F Char 10 BOD (5 day) flags 26 CFS Num 8 Stream Flow cfs 7 CFS_F Char 10 Stream Flow flags 24 CHANNEL Char 3 Channel status wet/dry/mud 44 CL Num 8 Chloride, dissolved mg/L 8 CL_F Char 10 Chloride, dissolved flags 32 COD Num 8 COD (low level) mg/L 9 COD_F Char 10 COD (low level) flags 10 COLL_F Char 10 Collection flags 28 COND_FIE Num 8 Conductivity - field uS/cm 46 COND_LAB Num 8 Conductivity - lab uS/cm 4 DATE_COL Num 8 MMDDYY Data collection date mm/dd/yy 29 DIO Num 8 Dissolved Oxygen mg/L 30 DIO_SAT Num 8 Dissolved Oxygen Saturation % 43 DOC Num 8 Dissolved Organic Carbon, C mg/L 11 DOC_F Char 10 Disolved Organic Carbon, C, flags 41 DOP Num 8 Phosphorus,disolved ortho phosphate mg/L 12 DOP_F Char 10 Phosphorus,disolved ortho phosphate flag 25 H2OTEMP Num 8 Water Temperature C 37 NH34 Num 8 NH3+NH4 N Total mg/L 13 NH34_F Char 10 NH3+NH4 N Total flags 39 NO23 Num 8 NO2+NO3 Nitrogen mg/L 14 NO23_F Char 10 NO2+NO3 Nitrogen flags 38 NOKJ Num 8 Total Kjeld Nitrogen mg/L 15 NOKJ_F Char 10 Total Kjeld Nitrogen flags 40 PHOS Num 8 Phosphorus, Total mg/L 16 PHOS_F Char 10 Phosphorus, Total flags 33 PH_FIELD Num 8 pH - field SU 47 PH_LAB Num 8 pH - lab SU 35 RESID Num 8 Residue, total mg/L 36 RESID_NF Num 8 Residue, total non filterable mg/L 17 RESN_F Char 10 Residue, total non filterable flags 23 SITEDESP Char 64 Site name description 1 SITE_ID Char 15 Site identification code 45 SO4 Num 8 Sulfate, dissolved as S mg/L 18 SO4_F Char 10 Sulfate, dissolved as S, flags 22 STORET Num 8 STORET number 21 SVN_ID Char 8 Site visit number 48 TIME_COL Num 8 Data collection time hh:mm 42 TOC Num 8 Total Organic Carbon, C mg/L 19 TOC_F Char 10 Total Organic Carbon, C flags 27 TURB Num 8 Turbidity NTU 20 TURB_F Char 10 Turbidity flags 3 VISIT_NO Num 8 Visit number 2 YEAR Num 8 Sample Year 7.1.1 Precision to which values are reported NA 7.1.2 Minimum Value in Data Set Name Min ------------------------------ ALKALIN 14 BOD5 0.1 CFS 0 CL 0.5 COD 5 COND_FIE 26 COND_LAB . DATE_COL 07/07/1997 DIO 3 DIO_SAT 33 DOC 1 DOP 0.005 H2OTEMP 6.6 NH34 0.02 NO23 0.02 NOKJ 0.2 PHOS 0.01 PH_FIELD 7 PH_LAB 7.3 RESID 14 RESID_NF 1 SO4 0.2 STORET 405678 TIME_COL 30600 TOC 1 TURB 1 VISIT_NO 1 YEAR 1997 7.1.3 Maximum Value in Data Set Name Max ------------------------------- ALKALIN 340 BOD5 3 CFS 124.47 CL 12 COD 20 COND_FIE 722 COND_LAB . DATE_COL 10/01/1997 DIO 12.9 DIO_SAT 150 DOC 10 DOP 0.074 H2OTEMP 26.1 NH34 0.08 NO23 0.16 NOKJ 0.8 PHOS 0.13 PH_FIELD 8.9 PH_LAB 7.3 RESID 520 RESID_NF 46 SO4 100 STORET 405704 TIME_COL 66600 TOC 17 TURB 28 VISIT_NO 2 YEAR 1997 7.2 Data Record Example 7.2.1 Column Names for Example Records "ALKALIN", "ALKA_F", "BOD5", "BOD5_F", "CFS", "CFS_F", "CHANNEL", "CL", "CL_F", "COD", "COD_F", "COLL_F", "COND_FIE", "COND_LAB", "DATE_COL", "DIO", "DIO_SAT", "DOC", "DOC_F", "DOP", "DOP_F", "H2OTEMP", "NH34", "NH34_F", "NO23", "NO23_F", "NOKJ", "NOKJ_F", "PHOS", "PHOS_F", "PH_FIELD", "PH_LAB", "RESID", "RESID_NF", "RESN_F", "SITEDESP", "SITE_ID", "SO4", "SO4_F", "STORET", "SVN_ID", "TIME_COL", "TOC", "TOC_F", "TURB", "TURB_F", "VISIT_NO", "YEAR" 7.2.2 Example Data Records 75, " ", 0.4, " ", 0.86, " ", "wet", 0.8, " ", 9, " ", "10", 150, ., 07/30/1997, 8.5, 106, 3, " ", 0.008, " ", 18.2, 0.02, " ", 0.02, "K", 0.2, " ", 0.02, " ", 8.4, ., 120, 1, "K", "LITTLE SUMMIT CREEK AT RM 0.4", "ORDS97-001", 0.2, " ", 405689, "97027REM", 45900, 3, " ", 2, " ", 1, 1997 285, " ", 0.1, " ", 0.69, " ", "wet", 3, " ", 5, " ", "10", 576, ., 09/24/1997, 9.4, 106, 4, " ", 0.01, " ", 14, 0.08, " ", 0.02, "K", 0.2, " ", 0.02, " ", 8.3, ., 390, 5, " ", "COW CR AT RM 2.4", "ORDS97-003", 26, " ", 405683, "97019REM", 45600, 3, " ", 3, " ", 1, 1997 259, " ", 0.1, " ", 0.58, " ", "wet", 3, " ", 6, " ", "10", 469, ., 07/16/1997, 8.5, 110, 6, " ", 0.009, " ", 20.9, 0.02, " ", 0.02, "K", 0.2, " ", 0.01, " ", 8.5, ., 350, 2, " ", "COW CR AT RM 2.4", "ORDS97-003", 21, " ", 405683, "97020REM", 48900, 3, " ", 2, " ", 2, 1997 ., " ", ., " ", ., " ", "mud", ., " ", ., " ", " ", ., ., 07/24/1997, ., ., ., " ", ., " ", ., ., " ", ., " ", ., " ", ., " ", ., ., ., ., " ", "PAULINA CR AT RM 2.0", "ORDS97-009", ., " ", 405686, "97029REM", ., ., " ", ., " ", 1, 1997 189, " ", ., " ", 1.4, "J", "wet", 0.9, " ", 5, "K", "10", 189, ., 07/28/1997, ., ., 6, " ", 0.027, " ", 21, 0.03, " ", 0.02, "K", 0.2, " ", 0.04, " ", 8.4, ., 170, 1, "K", "ROBA CR NEAR PAULINA", "ORDS97-010", 0.5, " ", 405687, "97030REM", 61800, 2, " ", 1, " ", 1, 1997 8. GEOGRAPHIC AND SPATIAL INFORMATION 8.1 Minimum Longitude -121 Degrees 56 Minutes 44 Seconds West (-121.945818 Decimal Degrees) 8.2 Maximum Longitude -119 Degrees 55 Minutes 38 Seconds West (-119.927334 Decimal Degrees) 8.3 Minimum Latitude 43 Degrees 20 Minutes 36 Seconds North (43.343393 Decimal Degrees) 8.4 Maximum Latitude 44 Degrees 35 Minutes 11 Seconds North (44.586607 Decimal Degrees) 8.5 Name of Area or Region EPA Region 10 - The sampling area included the Coast Range Ecoregion and the Yakima River Basin (Columbia Basin Ecoregion). 9. QUALITY CONTROL / QUALITY ASSURANCE 9.1 Data Quality Objectives See Chaloud and Peck (1994), Merritt (1994), and Hayslip (1993). 9.2 Quality Assurance Procedures See Chaloud and Peck (1994), Merritt (1994), and Hayslip (1993). 9.3 Unassessed Errors NA 10. DATA ACCESS 10.1 Data Access Procedures Data can be downloaded from the WWW site or contact personnel listed in Section 10.3. 10.2 Data Access Restrictions Data can only be accessed from the WWW server. 10.3 Data Access Contact Persons Gretchen Hayslip Environmental Services Division Region 10 U.S. Environmental Protection Agency 1200 Sixth Avenue, ES-097 Seattle, WA 98101 Ph 206-553-1685 Fax 206-553-0119 email hayslip.gretchen@epamail.epa.gov Marlys Cappaert CSC c/o U.S. Environmental Protection Agency NHEERL Western Ecology Division 200 S.W. 35th Street Corvallis, OR 97333 Ph 541-754-4467 Fax 541-754-4716 Email cappaert@mail.cor.epa.gov 10.4 Data Set Format Data files are in ASCII comma-delimited format. 10.5 Information Concerning Anonymous FTP Data cannot be accessed via ftp. 10.6 Information Concerning WWW Data can be downloaded from http://www.epa.gov/emap. 10.7 EMAP CD-ROM Containing the Data Data are not available on CD-ROM. 11. REFERENCES Chaloud, D.J. and D.V. Peck. 1994. Environmental Monitoring and Assessment Program - Surface Waters: Integrated Quality Assurance Project Plan for the Surface Waters Resource Group. U.S. Environmental Protection Agency. Office of Research and Development. Washington, D.C. Hayslip, G. A. (editor). 1993. EPA Region 10 In-stream Biological Monitoring Handbook (for wadeable streams in the Pacific Northwest). U. S. Environmental Protection Agency - Region 10, Environmental Services Division, Seattle, WA 98101. EPA-910/9-92-013. Hayslip, G., D.J. Klemm, J.M. Lazorchak. 1994. Environmental Monitoring and Assessment Program Surface Waters and Region 10 Regional Environmental Monitoring and Assessment Program: 1994 Pilot Field Operations and Methods Manual for Streams on the Coast Range Ecoregion of Oregon and Washington and the Yakima River Basin. Office of Research and Development, U.S. Environmental Protection Agency, Cincinnati, OH. Merritt, G.D. 1994. Biological Assessment of wadeable Streams in the Coast Range Ecoregion and the Yakima River Basin: Final Quality Assurance Project Plan. Washington State Department of Ecology, Environmental Investigations and Laboratory Services, Olympia, WA, 15 pp. Plafkin, J.L., M.T. Barbour, K.D. Porter, S.K. Gross, and R.M Hughes. 1989. Rapid Bioassessment Protocols for Use in Streams and Rivers: Benthic Macroinvertebrates and Fish. EPA 440/4-89/001. U.S. Environmental Protection Agency, Office of Water, Washington, D.C. 12. TABLE OF ACRONYMS EMAP Environmental Monitoring and Assessment Program EPA U.S.Environmental Protection Agency NHEERL National Health and Environmental Effects Research Laboratory CSC Computer Sciences Corporation R-EMAP Regional Environmental Monitoring and Assessment Program R0ORDES Region 10 Oregon Deschutes Basin (R0ORDES) 13. PERSONNEL INFORMATION Project Manager Gretchen Hayslip Environmental Services Division Region 10 U.S. Environmental Protection Agency 1200 Sixth Avenue, ES-097 Seattle, WA 98101 Ph 206-553-1685 Fax 206-553-0119 email hayslip.gretchen@epamail.epa.gov R-EMAP Project Leader for Washington State Glenn Merritt Washington State Department of Ecology Watershed Assessments Section 300 Desmond Drive, P.O. Box 47710 Olympia, WA 98504-7710 Ph 206-407-6777 Fax 206-407-6884 R-EMAP Project Leader for Oregon Rick Hafele Oregon Department of Environmental Quality 811 SW 6th Avenue Portland, OR 97204-1390 Ph 503-229-5983 Fax 503-229-6124 Email rick.hafele@state.or.us Quality Assurance Officer Dave Peck U.S. Environmental Protection Agency NHEERL Western Ecology Division 200 S.W. 35th Street Corvallis, OR 97333 Ph 541-754-4426 Fax 541-754-4716 Email davep@mail.cor.epa.gov Information Management, EMAP-Surface Waters Marlys Cappaert CSC c/o U.S. Environmental Protection Agency NHEERL Western Ecology Division 200 S.W. 35th Street Corvallis, OR 97333 Ph 541-754-4467 Fax 541-754-4716 Email cappaert@mail.cor.epa.gov