CATALOG DOCUMENTATION EMAP SURFACE WATERS PROGRAM LEVEL DATABASE Region 10 Washington Cascades (R0CE) 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 Washington Cascades (R0CE) 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_wa 1.5 Task Group Surface Waters 1.6 Data Set Identification Code 17 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 State of Oregon State of Washington U.S. Environmental Protection Agency, 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 September. 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 6, 1999 5.1.4 Sampling End Date September 7, 2000 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 ------------------------------------------------------------------------- 28 ALK_T Num 8 Total Alkalinity (mg\L) 5 ALK_T_F Char 10 Flag for Alkalinity 35 CL Num 8 Chloride (mg\L) 6 CL_F Char 10 Flag for Chloride 47 COM_EVNT Char 80 Sampling Event Comments 46 COM_FLD Char 80 Field Sampling Comments 42 COND Num 8 Stream Conductivity (uS/cm @25 oC) 7 COND_F Char 10 Flag for Stream Conductivity 44 CONQCPO Num 8 Cond. of QC Soln. Post Strm Cond. Meas. 8 CONQCPOF Char 10 Flag for CONQCPO 43 CONQCPR Num 8 Cond. of QC Soln. Pre Strm Cond. Meas. 9 CONQCPRF Char 10 Flag for CONQCPR 4 DATE_COL Num 8 MMDDYY Date of Data Collection in Field 45 DISCHRG Num 8 Stream Discharge (cfs) 10 DISCHRGF Char 10 Flag for Stream Discharge 41 DO Num 8 Stream Dissolved Oxygen (mg\L) 30 DOC Num 8 Dissolved Organic Carbon (mg\L) 11 DOC_F Char 10 Flag for Dissolved Organic Carbon 12 DO_F Char 10 Flag for Stream Dissolved Oxygen 25 DUPLICAT Num 8 Sample Measured (1=Initial, 2=Duplicate) 24 EVENT Char 10 3-digit Site Number|Visit_No (01 or 02) 27 EVT_D_S Char 10 Site Number|Visit_No|Duplicate|Split 23 LABID Num 8 Sample ID Number Assigned by Lab 31 NH3_N Num 8 Ammonia (mg\L) 13 NH3_N_F Char 10 Flag for Ammonia 32 NO23_N Num 8 Nitrite-Nitrate (mg\L) 14 NO23_N_F Char 10 Flag for Nitrite-Nitrate 38 PH Num 8 Stream pH 33 PHOS Num 8 Total Phosphorus (mg\L) 15 PHOS_F Char 10 Flag for Total Phosphorous 40 PHQCPOS Num 8 pH of QC Soln. Post Stream pH Meas. 16 PHQCPOSF Char 10 Flag for PHQCPOS 39 PHQCPRE Num 8 pH of QC Soln. Pre Stream pH Meas. 17 PHQCPREF Char 10 Flag for PHQCPRE 18 PH_F Char 10 Flag for Stream pH 1 SITE_ID Char 15 Site ID 36 SO4 Num 8 Sulfate (mg\L) 19 SO4_F Char 10 Flag for Sulfate 26 SPLIT Num 8 Half of Sample Analyzed (1 or 2) 37 TEMP_C Num 8 Stream Temperature (oC) 20 TEMP_C_F Char 10 Flag for Stream Temperature 34 TPN Num 8 Total Persulfate Nitrogen (mg\L) 21 TPN_F Char 10 Flag for Total Persulfate Nitrogen 29 TSS Num 8 Total Suspended Solids (mg\L) 22 TSS_F Char 10 Flag for Total Suspended Solids 3 VISIT_NO Num 8 Within Year Site Visit Number 2 YEAR Num 8 Year Sampled 7.1.1 Precision to which values are reported NA 7.1.2 Minimum Value in Data Set Name Min ------------------------------ ALK_T 5.43 CL 0.247 COND 13.7 CONQCPO 65.7 CONQCPR 66.5 DATE_COL 07/19/1999 DISCHRG 0.52 DO 7.7 DOC 0.4 DUPLICAT 1 LABID 279850 NH3_N 0.01 NO23_N 0.01 PH 6.21 PHOS 0.01 PHQCPOS 6.75 PHQCPRE 6.7 SO4 0.312 SPLIT 1 TEMP_C 3.3 TPN 0.01 TSS 1 VISIT_NO 1 YEAR 1999 7.1.3 Maximum Value in Data Set Name Max ------------------------------- ALK_T 39.7 CL 4.69 COND 81.2 CONQCPO 137.8 CONQCPR 133.4 DATE_COL 10/19/2000 DISCHRG 350 DO 13.3 DOC 6.6 DUPLICAT 2 LABID 99379027 NH3_N 0.049 NO23_N 0.529 PH 8.03 PHOS 0.53 PHQCPOS 7.21 PHQCPRE 7.07 SO4 17.2 SPLIT 2 TEMP_C 15.6 TPN 0.739 TSS 665 VISIT_NO 2 YEAR 2000 7.2 Data Record Example 7.2.1 Column Names for Example Records "ALK_T", "ALK_T_F", "CL", "CL_F", "COM_EVNT", "COM_FLD", "COND", "COND_F", "CONQCPO", "CONQCPOF", "CONQCPR", "CONQCPRF", "DATE_COL", "DISCHRG", "DISCHRGF", "DO", "DOC", "DOC_F", "DO_F", "DUPLICAT", "EVENT", "EVT_D_S", "LABID", "NH3_N", "NH3_N_F", "NO23_N", "NO23_N_F", "PH", "PHOS", "PHOS_F", "PHQCPOS", "PHQCPOSF", "PHQCPRE", "PHQCPREF", "PH_F", "SITE_ID", "SO4", "SO4_F", "SPLIT", "TEMP_C", "TEMP_C_F", "TPN", "TPN_F", "TSS", "TSS_F", "VISIT_NO", "YEAR" 7.2.2 Example Data Records 34.5, " ", 1.13, " ", " ", "Post QC pH missing/unit turned itself off.", 71.2, " ", 75.6, " ", 75.6, " ", 07/20/1999, 23.82, " ", 10.2, 1, "U", " ", 1, "00101", "0010111", 99299001, 0.023, " ", 0.014, " ", 7.57, 0.028, " ", ., "K", 6.91, " ", " ", "R0CE99-001", 1.61, " ", 1, 13.6, " ", 0.066, " ", 1, "U", 1, 1999 ., "K", ., "K", " ", " ", ., "K", ., "K", ., "K", 07/20/1999, ., "K", ., ., "K", "K", 1, "00101", "0010112", 99299001, ., "K", ., "K", ., 0.028, " ", ., "K", ., "K", "K", "R0CE99-001", ., "K", 2, ., "K", ., "K", 1, "U", 1, 1999 39.3, " ", 1.87, " ", " ", "Post QC pH out of range. No replicate flow.", 79, " ", 75.1, " ", 75.3, " ", 09/08/1999, ., "K", 11.4, 1, "U", " ", 2, "00102", "0010221", 99369024, 0.037, " ", 0.033, " ", ., 0.03, " ", 7.21, "H", 6.89, " ", "K", "R0CE99-001", 1.45, " ", 1, 10.9, " ", 0.088, " ", 1, "U", 2, 1999 39.7, " ", 1.5, " ", " ", "Post QC pH out of range", 81.2, " ", 75.1, " ", 75.3, " ", 09/08/1999, 13.78, " ", 11.3, 1, "U", " ", 1, "00102", "0010211", 99369023, 0.034, " ", 0.031, " ", ., 0.031, " ", 7.21, "H", 6.89, " ", "K", "R0CE99-001", 1.45, " ", 1, 10.9, " ", 0.089, " ", 15, " ", 2, 1999 15, " ", 0.382, " ", " ", " ", ., "K", ., "K", ., "K", 08/02/1999, ., "K", ., ., "K", "K", 1, "00701", "0070112", 99319006, 0.02, " ", ., "K", ., ., "K", ., "K", ., "K", "K", "R0CE99-007", 0.683, " ", 2, ., "K", ., "K", ., "K", 1, 1999 8. GEOGRAPHIC AND SPATIAL INFORMATION 8.1 Minimum Longitude -122 Degrees 30 Minutes 25 Seconds West (-122.507056 Decimal Degrees) 8.2 Maximum Longitude -121 Degrees 13 Minutes 25 Seconds West (-121.223858 Decimal Degrees) 8.3 Minimum Latitude 45 Degrees 41 Minutes 17 Seconds North (45.688187 Decimal Degrees) 8.4 Maximum Latitude 47 Degrees 28 Minutes 53 Seconds North (47.481605 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 R0CE Region 10 Washington Cascades (R0CE) 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