&EPA United States Environmental Protection Agency Office of Research and Development Washington, DC 20460 EPA/60-0/3-91/028 November 1990 National Surface Water Survey Eastern Lake Survey Phase II Northeastern Lakes, Database Dictionary LAKE ------- EPA/600/3-91/028 November 1990 NATIONAL SURFACE WATER SURVEY: EASTERN LAKE SURVEY - PHASE II NORTHEASTERN LAKES, DATABASE DICTIONARY Septembers, 1991 Prepared by Michele M. Jimenez Robert G. Johnson Thomas C. Myers Bonnie D. Miller Mischell M. Lang Alison K Pollack Steven D. Reynolds Systems Applications, Inc. 101 Lucas Valley Road San Rafael, CA 94903 (415)472-4011 Thomas R. Whittier Mantech Environmental Technologies, Inc. Alan T. Herlihy Utah State University c/o U.S. EPA Environmental Research Laboratory 200 SW 35th St. Corvallis, OR 97333 ------- ACKNOWLEDGMENTS The research described in this database dictionary has been funded by the U.S. Environmental Protection Agency. This document has been prepared at the EPA Environmental Research Laboratory in Corvallis, Oregon, through contract no. 68-03-3439 with Systems Applications, Inc. (Kilkelly Environmental Associates), contract no. 68-C8-0006 with ManTech Environmental Technologies, Inc., and cooperative agreement no. CR815168 with Utah State University. The document has been subjected to the Agency's peer and administrative review and approved for publication. Mention of trade names or commercial products does not constitute endorsement or recommendation for use. ------- TABLE OF CONTENTS Section Page IMPORTANT NOTICE TO DATABASE USERS v 1. INTRODUCTION 1 Overview of the ELS-II Study 1 National Lake Survey - Phase I 1 Eastern Lake Survey - Phase II 2 Components of ELS-II Chemistry Surveys 4 Related ELS-II Activities 5 Purpose and Structure of This Report 5 2. DEVELOPMENT OF THE ELS-II DATABASE 7 Database Design 7 Creation of the Raw Data Sets 9 Creation of the verified Data Sets 10 Creation of the Validated Data Sets 10 Creation of the Enhanced (Final) Data Sets 11 Database Quality Control 11 3. DATA QUALITY ASSESSMENT 13 4. LIST OF VARIABLES 15 5. DEFINITIONS OF VARIABLES 31 6. DATA TAGS AND FLAGS 53 7. REFERENCES 59 APPENDIX A - Ancillary ELS-II Data Sets 61 APPENDIX B - ASCII Versions of ELS-II Data Sets 69 in ------- LIST OF FIGURES Figure Page 1-1 ELS-II study lakes 3 2-1 Flow diagram of the creation of the ELS-II databases 8 LIST OF TABLES Table Page 2-1 ELS-II Major Variables 12 4-1 Variables in the Reduced Validated Spring Seasonal (SPSVBM01) Data Set 16 4-2 Variables in the Reduced Validated Summer Seasonal (SUSVBM01) Data Set .... 20 4-3 Variables in the Reduced Validated Fall Seasonal (FASVBM01) Data Set 26 5-1 Definition of Variables, U.S. EPA Eastern Lake Survey - Phase II 33 6-1 Tag Code Definitions, U.S. EPA Eastern Lake Survey- Phase II 54 6-2 Flag Code Definitions, U.S. EPA Eastern Lake Survey- Phase II 55 IV ------- IMPORTANT NOTICE TO DATABASE USERS The Eastern Lake Survey - Phase II (ELS-II) seasonal chemistry data sets available for public distribution are DS3B, the reduced version of the validated database, and DS4A, the enhanced (final) database. The enhanced database is the easiest to use for general analysis. It contains one data line for each lakewater sample (replicates have been averaged) and the database has been readied to make population estimates as described in Section 2. The validated database contains all the unreplaced, unaveraged data, including some of the lakewater QA data. Database file names are: Number of Variables 188 148 257 194 SEASON Spring 1986 Summer 1986 Fall 1986 FILE NAME SPSVBM01 SPSFIM01 SUSVBM01 SUSFIM01 FASVBM01 FASFIM01 DATA TYPE Validated Enhanced Validated Enhanced Validated Enhanced n 234 146 301 270 265 239 199 156 Ancillary data sets from other ELS-II activities are discussed in Appendix A. Due to problems discovered during the verification and validation of the Phase II data, the data verification phase was repeated for selected analytes measured at both contract laboratories. The reevaluation resulted in a new "modified verified" database. Based on our analyses, we make the following recommendations for data use: 1. Chloride (variable name= CL98/CL11) values measured at one of the analytical laboratories should not be used. The suspect chloride values are present in the validated data set and the associated chloride flag variable (CL1 IF) has a Ul code. In the enhanced data set (DS4A), these suspect chloride values have been set to "missing" values. Population estimates for chloride should not be made for the summer and spring (all fall values were measured at the other analytical laboratory and are not considered suspect). 2. Field conductivity (variables - CxxxxlD and CON601D) measurements appear to be unreliable and should be interpreted with caution. These measurements were not validated. There were no problems detected with the laboratory conductivity (CONDI 1) values. 3. Total aluminum (ALTL11) data showed very poor agreement between laboratories and precision was highly variable. Discretion is advised in interpreting the total aluminum data. Note, these problems do not relate to total monomeric aluminum (ALD02), organic monomeric aluminum (ALO_02), or inorganic monomeric aluminum (ALDI98). 4. Air-equilibrated dissolved inorganic carbon (DICE11) and air-equilibrated pH (PHEQ11) showed some laboratory bias and poor precision at higher pH. It is strongly recommended that data users use the closed-system dissolved inorganic carbon (DIC02) and pH (PH02) measurements for data analysis. ------- The ELS-II was designed to estimate characteristics of an explicitly defined target population of lakes in the northeastern United States, not just the sampled lakes. To make inferences about the ELS-II population, it is necessary to weight each sample by the ELS-II weighting factor (variable WT2T99; see Section 5). The ELS-II sample weighting factor Indicates how many lakes in the ELS-II target population are represented by each sample. Details on making ELS-II population estimates are given in the ELS-II final report (Herlihy et al., 1991). VI ------- SECTION 1 INTRODUCTION Database management support for the U.S. Environmental Protection Agency's (EPA) Eastern Lake Survey - Phase II (ELS-II) was provided by Systems Applications, Inc (SAI). The major functions of the database management program were to create, update, distribute, and safeguard the various databases containing the information collected in the three seasonal chemistry surveys (spring, summer, and fall) of lakes in the northeastern United States. OVERVIEW OF THE ELS-II STUDY In cooperation with the National Acid Precipitation Assessment Program (NAPAP), the EPA conducted the National Surface Water Survey (NSWS), the purpose of which was to (1) document the chemical and biological status of lakes and streams in regions of the United States potentially sensitive to acidic deposition, and (2) select regionally representative surface waters so that changes in aquatic resources could be quantified through a long-term monitoring program. The NSWS consisted of two phases: • Phase I - a synoptic survey of lake and stream chemistry. • Phase II - an evaluation of the chemical variability and biological status of a subset of lakes sampled in Phase I. The NSWS, conducted between 1984 and 1986, consisted of two major components: the National Lake Survey, including the Eastern Lake Survey (Linthurst et al., 1986) and the Western Lake Survey (Landers et al., 1987), and the National Stream Survey (Kaufmann et al., 1988). The primary emphasis of the NSWS was to develop a regional and national perspective on the current status of surface water chemistry through the conduct of appropriate surveys rather than a process-oriented, cause-and-effect research program. National Lake Survey - Phase I The objectives of Phase I of the National Lake Survey were: To determine the percentage (by number and area) and location of lakes that are acidic in potentially susceptible regions of the United States. To assess the percentage (by number and area) and location of lakes that have low acid neutralizing capacity (ANC) in potentially susceptible regions of the United States. To select regionally characteristic lakes for further study in Phase II and for possible future long-term monitoring. ------- Phase I was specifically designed to provide the above information within definable confidence limits. Thus, a particular strength of Phase I of the lake survey was the quantitative assessment of the chemical characteristics of lakes within a probability sampling frame that allowed regional estimates to be made. An important limitation on these objectives was that issues concerning temporal variability and biological resources could not be addressed. These issues are of particular concern in Phase II of the lake survey. Eastern Lake Survey - Phase II The focus of ELS-II was on the northeastern United States (ELS Region 1). ELS-II involved the resampling of a subset of lakes in the northeastern United States sampled in ELS-I to determine chemical variability and biological status (Figure 1-1). Particular attention was given to lakes considered most susceptible to acidification. Chemical variability among lakes was examined by sampling the lakes during the spring, summer, and fall of 1986. Furthermore, within-index period variability was examined in the fall of 1986 to provide insight concerning the ability to detect chemical changes over time, and the precision of the estimates of the number of acidic lakes from Phase I. The primary objectives of ELS-II were to: • Assess the sampling error associated with the ELSII fall index sample. • Estimate the number of lakes with low acid neutralizing capacity (ANC) (i.e, potentially susceptible) that are not acidic in the fall but that are acidic in other seasons. • Establish seasonal water chemistry characteristics among lakes. The ELS-II sample lakes were selected from those ELS-I lakes with ANC < 400 ^eq/L, depth > 1.5 m, and low nitrogen or phosphorous concentrations, using a systematic random sample (see Herlihy et al., 1991). A total of 147 statistically selected lakes were targeted for field visitation during ELS-II in the spring, summer, and fall of 1986. In addition to these seasonal surveys, a variability study was conducted during the fall seasonal survey. The Fall Variability Study was designed to sample a subset of 50 of the ELS-II lakes at three different times at independently selected locations believed to be the deepest point in a lake during the fall index period. In situ measurements of pH, conductivity, temperature, and dissolved oxygen were made at 1.5 m below the surface and 1.5 m above the bottom in all lakes. If the lake was stratified (temperature difference > 4°C), depth profiles of the in situ measurements were made. Water samples for laboratory analyses were collected from the epilimnion at 1.5 m below the surface in lakes more than 3 m deep. In lakes less than 3 m deep, epilimnetic samples were collected at 0.5 m below the surface. ELS-II field operations are discussed in detail by Merritt and Sheppe (1988). ------- ---- Notiono! Luke Survey Boyndory • Pliose II Survey Site Figure 1-1. ELS-II study lakes. ------- Components of ELS-II Chemistry Surveys Spring Survey: Northeastern lakes in ELS-II were sampled once in the spring of 1986 in the epilimnion at the same location on the lake as the fall index sample in ELSI. Lakes were sampled as soon after ice-out as practical. Water samples were collected from 146 lakes between March 25 and May 3,1986. Summer Survey: ELS-II lakes were sampled once in the epilimnion in the summer of 1986 at the same location on the lake as the fall index sample in ELS-I. Water samples were collected from 147 lakes. In addition to the epilimnetic sample, a hypolimnetic sample was collected in 123 of these lakes. Hypolimnetic samples were drawn from the middle of the hypolimnion in stratified lakes, and at 1.5 m from the bottom in nonstratified lakes or lakes < 5 m deep. Hypolimnetic samples were not collected from lakes < 3 m deep. Summer seasonal survey samples were collected between July 23 and August 11, 1986. Fall Survey and Variability Study: A variability study was conducted in the fall of 1986 along with the regular seasonal survey to assess the within-season and within-lake spatial variability in lake chemistry. In addition to the fall seasonal survey of ELS-I sample locations, a subset of 50 ELS-II lakes, in 2 groups of 25, were selected for sampling at 2 additional times during the fall index period at 2 independently selected locations on the lake. Independent field crews selected the Fall Variability Study sampling locations at the time of the sample visits by locating a spot that appeared to be the deepest part of the lake, according to lake shape, surrounding topography, and depth measurements, in the same way the original ELS-I sites were chosen. A set of 25 fall variability lakes was randomly selected from all ELS-II lakes in each of two geographic regions of the northeastern United States: the Adirondacks and central and southeastern New England (Connecticut, Rhode Island, Massachusetts, and southern New Hampshire). Due to inclement weather and logistic constraints, only 41 of the 50 selected lakes (17 in the Adirondacks and 24 in central and southeastern New England) were sampled 3 times in the fall. ELS-II lakes not included in the Fall Variability Study were sampled only once in the fall, at the same location as the ELS-I sample. In total, water samples were collected from 152 lakes, 7 of which were special interest sites (lakes that were not part of the statistical sample but are of interest in comparing ELS-II results with those of other researchers). Only epilimnetic water samples were collected. All fall seasonal and variability study samples were collected between October 8 and November 14, 1986. Water samples were transported from the sample site in coolers containing frozen chemical refrigerant packs that maintained a temperature of approximately 4°C until they arrived at the central processing laboratory. Samples were shipped by overnight courier to ensure their arrival at the processing laboratory in Las Vegas, Nevada, on the morning after collection. ------- In almost all cases, processing laboratory analyses were completed and samples were preserved and split into aliquots within 36 hours after sampling. The samples were then shipped by overnight courier to a contracted analytical laboratory for chemical analysis. Two analytical laboratories analyzed samples during ELS-II. One laboratory performed all the spring analyses and the other performed all the fall analyses. Both laboratories analyzed summer samples. RELATED ELS-II ACTIVITIES The original plan for ELS-II called for fish studies in all the lakes for which chemical samples were to be collected. However, as a result of funding limitations, it was decided to restrict the fish studies to a subset of lakes located in the Upper Midwest (see Cusimano et al.,1990). The databases described in this dictionary contain only the lake chemistry data for the northeast lakes. In addition to the data included in the seasonal ELS-II databases, other parameters were measured in ELS-II lakes. In the summer, zooplankton data were collected in all the ELS-II lakes (described in Tessier and Horwitz, 1988, 1990). Also, summer trace metal and chlorophyll data were collected from ELS-II lakes. It was found, however, that the measured trace metal concentrations in most lakes were below the system detection limit calculated from field blanks, thus the data yielded little information. In addition, detailed bathymetric data were collected from 123 ELS-II lakes. Details and file names of these ancillary ELS-II data sets are discussed in Appendix A. Note that the trace metal data were not released due to the high detection limits. PURPOSE AND STRUCTURE OF THIS REPORT The purpose of this data dictionary is to provide information pertaining to the contents and structure of the ELS-II chemistry database. The data dictionary does not describe the design, protocols, or findings of the study, which are described in Herlihy et al. (1991). Section 2 describes the overall design and development of the ELS-II database. Section 3 is a summary of data quality. Section 4 identifies all variables in the database, and Section 5 provides detailed definitions of the variables. Section 6 describes 'tags" and "flags," which are two types of data qualifiers. ------- SECTION 2 DEVELOPMENT OF THE ELS-II DATABASE Representatives from the Systems Applications, Inc. (SAI), data management staff, the U.S. EPA Environmental Monitoring Systems Laboratory at Las Vegas (EMSL-Las Vegas), and the U.S. EPA Environmental Research Laboratory in Corvallis (ERL-Corvallis) met to define the responsibilities of each organization in developing the ELS-II databases. A data management plan for the ELS-II was developed from the meeting. The key steps in this activity are shown in Figure 2-1. Conceptually, ELS-II data management was similar to that of Phase I of the Eastern and Western Lake Surveys (Kanciruk et al., 1986,1987). The ELS-II database was developed using SAS software. Originally, all data files in the ELS-II database were processed into SAS relational (tabular) data files and were uploaded to a Prime 750 minicomputer at the Systems Applications offices. Data files were output to magnetic tape and transferred to the EPA's IBM mainframe computer at the EPA's National Computer Center, Research Triangle Park, North Carolina. The quality assurance staff at EMSL-Las Vegas and the project staff at ERL-Corvallis accessed the data sets at the National Computer Center. Problems found during verification and validation necessitated a reverification of the ELS-II chemistry data sets. EMSL-Las Vegas completed their reverification of the merged data sets by directly making changes to copies of the verified data sets to create the modified verified database. Staff at ERL-Corvallis transferred copies of the modified verified data to their VAX 8600 minicomputer for re-validation. After re-validation of the data, ERL-Corvallis staff downloaded the files to IBM compatible microcomputer diskettes for transfer to SAI. SAI and ERL-Corvallis staff then created the validated and final (enhanced) data sets on IBM compatible microcomputers using PC-SAS. DATABASE DESIGN The ELS-II database consists of information collected in three seasonal chemistry surveys (spring, summer, and fall of 1986). Four levels or versions of data sets were developed for each seasonal study. These versions were operationally defined as the raw, verified, validated, and enhanced (final) databases (Figure 2-1). Each raw data set (designated as DS1) contains the original data as reported on the field forms and by the analytical laboratories. The raw data sets were reviewed by the quality assurance (QA) staff at EMSL-Las Vegas to verify the reported results. A verified data set (version DS2) was developed from each raw data set. The raw and verified data sets for each seasonal survey were reviewed by staff at ERL-Corvallis to determine the quality of the data with respect to its intended use, resulting in the development of validated data sets. Two versions of each validated data set were created: a complete version ------- Assembly of Field/Lab Data Forms (EMSL-Las Vegas) Data Entry (Systems Applications, Inc.) Creation of Raw Data Bases (Systems Applications, Inc.) Data Verification (EMSL-Las Vegas) Creation of Verified Data Bases (Systems Applications, Inc.) Preliminary Data Validation (ERL-Corvallis) Data Validation (ERL-Corvaliis) Creation of Validated Data Bases (Systems Applications, Inc.) Instructions for Creation of Final Data Bases (ERL-Corvallis) Creation of Final Data Bases (Systems Applications, Inc.) Figure 2-1. Flow diagram of the creation of the ELS-II databases. ------- (DS3A) and a reduced version (DS3B) that contained fewer variables. The enhanced data set, used for calculating population estimates and data interpretation, was developed from the DS3B version. Only the reduced validated (DS3B) and the enhanced (DS4A) data sets are being distributed. This data dictionary documents the reduced validated and enhanced (final) data sets, DS3B and DS4A. Data set DS3B (validated) should be used by investigators who require unaveraged, unreplaced data. Verification and validation suspect values are present in data set DS3B and may be removed by the user if desired (validation outliers have a U code in the variable flag field). DS3B also contains some of the QA data. Data set DS4A (enhanced) is easier to use for general analysis (there is only one data line per lakewater sample) and is the data set used for making population estimates in the ELS-II data report. CREATION OF THE RAW DATA SETS Development of the raw data set involved checking the data forms from the field and analytical laboratories and entering the data from these forms. EMSL-Las Vegas provided copies of the field data forms for each seasonal chemistry survey, along with hard copies of summaries of the results of laboratory analyses for the spring seasonal chemistry survey. The data management staff developed data entry screens for the field data forms using the dBase III Plus software package implemented on IBM compatible microcomputers. The entry screens for the laboratory data were developed by modifying the data entry software package that EMSL-Las Vegas had developed for the ELS-II. EMSL-Las Vegas then provided the analytical laboratory data for the summer and fall seasonal chemistry surveys on diskettes as dBase compatible files. To insure accurate transcription of data from the field and laboratory forms, data were initially entered independently by two operators. After entry, each file was sorted and converted to an ASCII-format file. The two files were compared using a program written in the "C" programming language. The output was a listing of the data records and variables for which discrepancies were found. In addition, data records that occurred in one file but not the other were also identified. Entry errors, duplicate records, and missing records were subsequently corrected. The comparison procedure was repeated, and another list of discrepancies was output. At this point a member of the data management team reviewed any remaining discrepancies, and questions were referred to the QA staff at EMSL-Las Vegas. One of the data files was corrected and used in the creation of the raw data set. The dBase files containing analytical laboratory data were also converted to ASCII format, with each record written as a single line. A program was developed to break the lines into lengths compatible with the personal computer version of SAS. In a few cases, the dBase file was entered directly into a SAS data file using the PROC DBF procedure. For both field data and analytical data files, a SAS program was written to define the data file structure (variable ------- names, types, field widths, and labels) and read the ASCII file when necessary. The result of this operation was the creation of a raw data set in SAS. Copies of each raw data set were transferred to the National Computer Center, where they could be accessed from EMSL-Las Vegas and ERL-Corvallis. CREATION OF THE VERIFIED DATA SETS The QA staff at EMSL-Las Vegas subjected the raw data sets to a set of quality control (QC) checks and identified various modifications to the raw data (Mitchell-Hall et al, 1989). "Transaction files" were generated in SAS containing the changes that were to be made to the raw data sets. A preliminary version of each verified data set was generated by applying the transaction files to the raw data sets. The transaction files were transferred to the data management staff, who applied them to the official raw data sets. Each resulting verified data set was compared to its preliminary version. If the two data sets were identical, then the resultant updated data set was considered to be the verified data set for a seasonal chemistry survey. If the comparison failed, then the discrepancies were resolved by comparing the updated data set to the original data forms (Mitchell-Hall et al., 1989). Following verification, a reverification was performed because of suspected data quality problems, primarily with spring anion data. As a result of this special data assessment (described in detail in Mitchell-Hall et al., 1989), a new modified verified database was created that was then used in validation and in the creation of the validated and enhanced data sets. Copies of the modified verified data sets were transferred to the National Computer Center where they could be accessed from EMSL-Las Vegas and ERL-Corvallis. CREATION OF THE VALIDATED DATA SETS The validated data set for each seasonal survey was created by changing the verified set according to specific instructions from the project staff at ERL-Corvallis. The changes were implemented as individual transactions, that is, each transaction was made by running a SAS program on the appropriate verified data set to identify the data records of interest and to create a transaction file. Then the transaction file was applied to the verified data set to create the validated data set for each seasonal survey. In situations where one transaction was dependent on another, a temporary data set was created by applying the first transaction to the verified data set and then the second transaction to the temporary data set. Each resulting data set was checked against the verified data set and the instructions from ERL-Corvallis. Any discrepancies were resolved, and the result was considered the complete validated data set (version DS3A). The reduced validated data set (version DS3B) was created by eliminating some of the internal QA variables and empty flag fields from DS3A. The creation of the seasonal validated data sets involved (1) changing units from mg/L to ^eq/L where appropriate, 10 ------- (2) creating two new variables, mean Secchi depth (SECME98), and labile (inorganic) monomeric aluminum (ALDI98), calculated as the difference between total monomeric aluminum (ALD02) and organic monomeric aluminum (ALO_02), (3) adding physical data from detailed bathymetry derived by the Adirondack Lake Survey Corporation, (4) adding cluster and phase II weights, (5) rounding, (6) fixing miscellaneous errors, and (7) concatenating the validation flags to the verification flags. During validation, missing values and values with known errors based on relationships with other variables were identified and assigned validation flags (UO or Ul; see Section 4). Values with either a UO or Ul validation flag were deleted in the creation of the enhanced data set. Only the 24 major variables listed In Table 2-1 were validated in ELS-II. Population estimates cannot be made if there are missing values, thus missing values and validation outliers were replaced in the enhanced (but NOT in the validated) data set if they were required to make population estimates (epilimnion samples from target lakes). CREATION OF THE ENHANCED (FINAL) DATA SETS Several sets of instructions for the creation of the final data sets were provided by the project staff at ERL-Corvallis. The first set of instructions was applied to the validated data sets, and temporary data set were created. The next set of instructions was applied to the temporary final data sets, and new temporary data sets were created. This process continued until the data management staff had implemented all instructions. At this point, the final data sets were checked against the validated data sets and all the instructions from ERL-Corvallis. These final data sets were designated as the complete versions DS4A. The enhanced (final) data set (version DS4A) for each seasonal chemistry survey was constructed from DS3B by (1) deleting all trailer duplicates (SAMCD02= TD'), laboratory QA splits (SAMCD02='S'), and all values with a UO or Ul validation flag, (2) averaging all replicate values (from field duplicate samples), (3) changing negative values (except for ANC and BNC) to zero, and (4) replacing all missing values for the 24 major variables in Table 2-1 with values calculated from regression models, so that population estimates could be made. In addition, a drop code variable (DRPCDE) was added to the enhanced data set to distinguish the ELS-II target lake samples from nontarget samples. Only 30 values were replaced during the creation of the enhanced ELS-II data sets: 12 in the spring, 14 in the summer, and 4 in the fall. DATABASE QUALITY CONTROL All phases of the data management program included various quality control checks to minimize errors. Computer programs were checked by a person that was not involved in writing the code. Table 2-1. Major Variables Validated in ELS-II 11 ------- ACCO11 ALEX11 CL98 D1C02 FTL98 MN11 N0398 PTL11 ALD02 ALKA11 COLOR02 DOC 11 K98 NA98 PHEQ11 SO498 ALO_02 CA98 COND11 FEU MG98 NH498 PH02 SIO211 Comments, program logic, and test cases were examined. All data entry screens were examined to insure consistency of appearance with the field or laboratory forms and to insure that the data were stored in the correct fields. For each raw data set, a listing of variable names, data types, field widths, formats, and SAS labels (generated from the SAS CONTENTS procedure) was reviewed for errors. A listing of all values in each data set was generated and compared to either the original field data forms or listings of data on the original diskettes to verify that all data fields were present and in the correct format. In addition, individual data values were selected at random and compared with those on the original data forms or diskettes. For each verified data set, any discrepancies between the verified data sets developed at SA1 and at EMSL-Las Vegas were identified using the SAS COMPARE procedure. Listings from the SAS CONTENTS and PRINT procedures were reviewed in the same manner as were the raw data sets. In addition, the SAS log files were examined to insure that the appropriate processing steps had been completed. For the validated data sets, each transaction was checked individually. The SAS programs were checked for logic and internal documentation (i.e., comments). SAS log files were checked for errors and problems. SAS list files containing the actual data changes were examined to be certain that all validation changes requested by ERL-Corvallis were implemented. Listings generated by the SAS CONTENTS and PRINT procedures were reviewed in the same manner as were the raw and verified data sets. For the final data sets, all SAS programs were checked for logic and comments. SAS log and list files were examined for any errors or deviations from the ERL-Corvallis instructions. Listings from SAS CONTENTS and PRINT procedures were reviewed as described for the other data sets. 12 ------- SECTION 3 DATA QUALITY SUMMARY A detailed discussion of the ELS-II QA data is given in the ELS-II QA report (Mitchell-Hall et al., 1989) and summarized in the ELS-II data report (Herlihy et al., 1991). Two analytical laboratories and a central processing laboratory analyzed samples in the ELS-II. The central processing laboratory in Las Vegas analyzed PH02, D1C02, COLOR02, TURO2, ALD02, and ALO_02 (see Section 5 for variable definitions) in all seasons. One analytical laboratory analyzed all the other chemical data for the spring; the other analytical laboratory analyzed all the fall data. Summer samples were analyzed by both analytical laboratories. For most of the major analytes described in Table 2-1, data quality (precision and accuracy) in ELS-II was comparable to that achieved in the other components of the National Surface Water Survey. Chloride measurements made by one laboratory, however, are suspect (based on both the QA data and charge balance/calculated conductivity checks) and we recommend against their use in data interpretation. This would eliminate chloride data from the entire spring database and from about half the summer database. In addition, three other analytes appear to produce inconsistent QA results: air- equilibrated dissolved inorganic carbon (DICE11), air-equilibrated pH (PHEQ11), and total aluminum (ALTL11). The closed-system pH and dissolved inorganic carbon analyses (PH02 and DIC02), however, achieved acceptable precision. For all analytes, especially aluminum variables, nitrate, ammonia, and total phosphorous, care should be taken in interpreting values around and below the system detection limit (SDL). The SDL represents the concentration that was significantly greater (95% confidence) than field blank (deionized water) concentrations. SDLs for each variable are summarized in Mitchell-Hall etal. (1989). In summary, as listed in the notice to data users, we make the following recommendations for data use: 1. Chloride (CL98/CL11) values measured at one of the analytical laboratories should not be used. The suspect chloride values are present in the validated data set (DS3B) and the chloride flag (CL1 IF) has a Ul code. In the enhanced data set (DS4A), these suspect chloride values have been set to "missing" values. Population estimates for chloride should not be made for the summer and spring (all fall values were measured at the other analytical laboratory). 2. All field (in situ) conductivity (variables - Cxxxxl D and CON601D) measurements appear to be unreliable and should be interpreted with caution. These measurements were not validated. No problems were identified with laboratory conductivity (CONDI 1) values. 3. Total aluminum (ALTL11) data showed very poor agreement between laboratories and precision was highly variable. This problem is evident in all NSWS surveys. In addition, a number of total aluminum values were less than the total monomeric aluminum values. Discretion is advised in interpreting total aluminum data. These problems do not relate to total monomeric aluminum (ALD02), organic monomeric aluminum (ALO_02), or inorganic monomeric aluminum (ALDI98). 4. Air-equilibrated dissolved inorganic carbon (DICE11) and air-equilibrated pH (PHEQ11) showed some laboratory bias and poor precision at higher pH. Users are strongly advised to use the closed-system dissolved inorganic carbon (DIC02) and pH (PH)2) measurements for data analysis. 13 ------- SECTION 4 LIST OF VARIABLES The variables in the three seasonal reduced validated (DS3B) SAS data sets are listed in the following three tables produced using the SAS procedure CONTENTS. Table 4-1. Spring Seasonal Data Set Table 4-2. Summer Seasonal Data Set 0 Table 4-3. Fall Seasonal Data Set Variables are listed alphabetically, and each table provides the variable name, type (numeric or character), length (in bytes, as structured in SAS), format, and SAS label. Variable labels are printed as they appear in the SAS data sets. The use of all capital letters and "UEQ/L" and US/CM" for Veq/L' and VS/cm" are examples of constraints imposed by limitations of the computer character set. Units of measure are defined in Section 5. In addition to the variables listed in these tables, a drop code variable (DRPCDE) has been added to each enhanced (final) seasonal data set. DRPCDE is a numeric variable of length 8, format F8., which is used to distinguish target from nontarget lakewater samples. 14 ------- Table 4-1. Variables in the Reduced Validated Spring Seasonal (SPSVBM01) Data Set Variable ACCO11 ACCO11F ALD02 ALD02F ALDI98 ALEX 11 ALEX 1 IF ALKA11 ALKA11 ALO 02 ALO 02F ALTLT11 ALTL11F ANCAT98 ANDEF98 ANSUM98 BAT ID BNSTR99 C0151D C0151DF C04051D C06101D C08151D C10201D C12251D C14301D C16351D C18401D C20451D CA11 CA98 CA11F CATSU98 CL1 CL98 CL11F CLSTR99 CNTY99 CO398 COLOR02 COLOR02F CON601D CONCA98 COND11 CONDI IF CON BID CXX501D Type Num Char Num Char Num Num Char Num Char Num Char Num Char Num Num Num Num Num Num Char Num Num Num Num Num Num Num Num Num Num Num Char Num Num Num Char Num Char Num Num Char Num Num Num Char Num Num Length 8 12 8 12 8 8 12 8 12 8 12 8 12 8 8 8 8 8 8 12 8 8 8 8 8 8 8 8 8 8 8 12 8 8 a 12 8 5 8 8 12 8 8 8 12 8 8 Format F8.1 F8.4 F8.4 F8.4 F8.1 F8.4 F8.4 F8.4 F8.4 F8.4 F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8.3 F8.4 F8.4 F8.3 F8.4 8. F8.4 F8. F8. F8.4 F8.1 F8. F8. SAS Label CO2-AC1DITY (UEQ/L) FORM 1 1 FLAG FOR ACCO1 1 PCV ALUMINUM DISSOLVED (UG/L) FORM 2 FLAG FOR ALD02 LABILE MONOMERIC AL (UG/L) ALUMINUM-EXTRACTRACTABLE (UG/L) FORM 1 1 FLAG FOR ALEX 11 ALKALINITY (UEQ/L) FORM 1 1 FLAG FOR ALKA11 PCV ALUMINUM ORGANIC (UG/L) FORM 2 FLAG FOR ALO 02 TOTAL ALUMINUM (UG/L) FORM 1 1 FLAGFORALTL11 CATIONS/ANIONS RATIO CATSUM-ANSUM (UEQ/L) SUM OF ANIONS (UEQ/L) BATCH IDENTIFICATION NUMBER POPULATION SIZE BY STRATA CONDUCTIVITY (US/CM) AT 1.5 M FORM 1ID FLAG FOR CO 15 ID CONDUCTIVITY AT 4 OR 5 M (US/CM) FORM ID CONDUCTIVITY AT 6 OR 10 M (US/CM) FORM ID CONDUCTIVITY AT 8 OR 15 M (US/CM) FORM ID CONDUCTIVITY AT 10 OR 20 M (US/CM) FORM ID CONDUCTIVITY AT 12 OR 25 M (US/CM) FORM ID CONDUCTIVITY AT 14 OR 30 M (US/CM) FORM ID CONDUCTIVITY AT 16 OR 35 M (US/CM) FORM ID CONDUCTIVITY AT 18 OR 40 M (US/CM) FORM ID CONDUCTIVITY AT 20 OR 45 M (US/CM) FORM ID CALCIUM (MG/L) FORM 1 1 CALCIUM (UEQ/L) FLAG FOR CA 11 SUM OF CATIONS (UEQ/L) CHLORIDE ION (MG/L) FORM 1 1 CHLORIDE (UEQ/L) FLAG FOR CL 11 PHASEII CLUSTER (1, 2 or 3) FIPS CODE (ST, COUNTY) CARBONATE ALKALINITY (UEQ/L) COLOR (PCU) FORM 2 FLAG FOR COLOR 02 CONDUCTIVITY AT 0.6 * DEPTH (US/CM) FORM ID CALCULATED CONDUCTIVITY (US/CM) CONDUCTIVITY (US/CM) FORM 1 1 FLAGFORCOND11 CONDUCT AT BOTTOM- 1.5 M (US/CM) FORM ID CONDUCTIVITY AT 50 M (US/CM) FORM ID (Continued) 15 ------- Table 4-1. (Continued) Variable DATSH02 DATSH1D DATSMP DIC02 DIC02F DICE 11 DICE 1 IF DICI11 DICI11F DISM99 DOC 11 DOC11F DO 151D DO 601D DO BID DPCA1D DPSIT1D DPSITX1D DP 601D DP BID ELEV99 ELEVX99 FEU FE11F FTL11 FTL98 FTL11F H98 HCO398 HDEP99 HYDID1D HYTYP99 INOUT99 Kll K98 K11F LABNA02 LAKE ID LAKNA1D LAT99 LATDD99 LKID99 LKNAM99 LKSIZ99 LKSIZX99 LKVOL99 LKVOLX99 Type Num Num Num Num Char Num Char Num Char Num Num Char Num Num Num Num Num Num Num Num Num Num Num Char Num Num Char Num Num Num Char Char Char Num Num Char Char Char Char Char Num Char Char Num Num Num Num Length 8 8 8 8 12 8 12 8 12 8 8 12 8 8 8 8 8 8 8 8 8 8 8 12 8 8 12 8 8 8 4 9 6 8 8 12 30 7 30 10 8 7 30 8 8 8 8 Format DATE7. DATE7. DATE7. F8.3 F8.3 F8. F8.2 F8.2 F8.2 F8.2 F8. F8. F8. F8. F8. F8. F8. F8.3 F8.4 F8.4 F8.4 F8.4 F8.3 F8.3 F8.4 F8.4 F8.2 F8.2 F8.3 F8.3 SAS Label DATE SHIPPED FORM 2 DATE SHIPPED FORM ID DATE SAMPLED DIG (MG/L) FORM 2 FLAG FOR DIC02 DIC-EQUIL (MG/L) FORM 1 1 FLAG FOR DICE 11 DIC-INIT (MG/L) FORM 1 1 FLAGFORDICI11 DISTANCE FROM COAST (MILES) DOC (MG/L) FORM 1 1 FLAG FOR DOC 11 DISSOLVED OXYGEN (MG/L) 1.5 M FORM ID DISSOLVED OXYGEN AT 0.6 * DEPTH FORM ID DISOXYGEN (MG/L) BOTTOM-1.5 M FORM ID DEPTH CATEGORY 4 = <20 M 5 = >20 M FORM ID SITE DEPTH (M) FORM ID MAXIMUM LAKE DEPTH (M)-ALSC DEPTH 0.6 * BOTTOM (M) FORM ID DEPTH AT BOTTOM-1.5 M (M) FORM ID LAKE ELEVATION (M) LAKE ELEVATION (M)-ALSC IRON (UG/L) FORM 1 1 FLAG FOR FE 11 FLUORIDE (MG/L) FORM 1 1 FLUORIDE (UEQ/L) FLAG FOR FTL 11 HYDROGEN FROM PHAC1 1 (UEQ/L) HCO3 (UEQ/L) HYDROGEN ION DEPOSITION (G/M ** 2/YR) HYDROLAB METER IDENTIFIER CODE FORM ID HYDROLOGIC TYPE PRESENCE/ABSENCE OF INLETS/OUTLETS POTASSIUM (MG/L) FORM 1 1 POTASSIUM (UEQ/L) FLAG FOR Kll LABORATORY FOR ANALYSIS FORM 2 LAKE IDENTIFICATION NUMBER LAKE NAME FORM ID LATITUDE LATITUDE (DECIMAL DEGREES) ERLD-UMD ID/ALSC WSHED-POND ID LAKE NAME LAKE SURFACE AREA (HA) LAKE SURFACE AREA (HA) - ALSC CALC LAKE VOL (10 ** 6 CUM) DIG. LAKE VOL (10 ** 6 CUM) - ALSC (Continued) 16 ------- Table 4-1. (Continued) Variable LNGDD99 LONG99 MAPBG99 MAPSM99 MG11 MG98 MG11F MN11 MN11F NA11 NA98 NA11F NH411 NH498 NH411F NO311 NO398 NO311F NO3DP99 ORGIO98 PH02 PH0151D PH0151DF PH02F PHAC11 PHAC11F PHAL11 PHAL11F PHEQ11 PHEQ11F PH 60 ID PH BID PRCIP99 PREC1D PTL11 PTL11F RGSPC99 RPREC1D RT99 RTX99 RUNIN99 RUNOF99 RUNOFX99 SAM CD02 SAM ID S AMID 1 IF SBRGN99 Type Num Char Char Char Num Num Char Num Char Num Num Char Num Num Char Num Num Char Num Num Num Num Char Char Num Char Num Char Num Char Num Num Num Char Num Char Char Char Num Num Num Num Num Char Num Char Char Length 8 11 25 40 8 8 12 8 12 8 8 12 8 8 12 8 8 12 8 8 8 8 12 12 8 12 8 12 8 12 8 8 8 5 8 12 16 8 8 8 8 8 8 10 8 12 1 Format F8.4 F8.3 F8.4 F8.3 F8.3 F8.4 F8.3 F8.4 F8.4 F8.4 F8.2 F8.4 F8.2 F8.2 F8.2 F8.2 F8.2 F8.2 F8.2 F8.3 F8.4 F8.3 8.3 F8. F8.3 8.3 F8. SAS Label LONGITUDE (DECIMAL DEGREES) LONGITUDE MAP SHEET NAME (1:250,000 SCALE) MAP SHEET NAME, 15 OR 7.5 QUAD MAGNESIUM (MG/L) FORM 1 1 MAGNESIUM (UEQ/L) FLAG FOR MG 11 MANGANESE (UG/L) FORM 1 1 FLAG FOR MN 11 SODIUM (MG/L) FORM 1 1 SODIUM (UEQ/L) FLAG FOR NA 11 AMMONIUM ION (MG/L) FORM 1 1 AMMONIUM (UEQ/L) FLAG FOR NH4 11 NITRATE ION (MG/L) FORM 1 1 NITRATE (UEQ/L) FLAG FOR NO31 1 NITRATE DEPOSITION (G/M ** 2/YR) ORGANIC ANION (UEQ/L) STATION PH FORM 2 PHAT1.5MFORM ID FLAG FOR PH015ID FLAG FOR PH02 ACIDITY INITIAL PH FORM 1 1 FLAGFORPHAC11 ALKALINITY INITIAL PH FORM 1 1 FLAGFORPHAL11 AIR-EQUILIBRATED PH FORM 1 1 FLAGFORPHEQ11 PH AT 0.6 * DEPTH FORM ID PHATBOTTOM-1.5 M FORM ID PRECIPITATION (M/YR) PRECIPITATION FORM ID TOTAL PHOSPHORUS (UG/L) FORM 1 1 FLAG FOR PTL 11 REG SPEC LTM NRC DEW DER SAMPLE CLASS RATE OF PRECIPITATION FORM ID RESIDENCE TIME (YR) RESIDENCE TIME (YR)-ALSC ANNUAL RUNOFF INCHES FROM DIGIT MAP SURFACE WATER RUNOFF (M/YR) SURFACE WATER RUNOFF (M/YR)-ALSC SAMPLE CODE FORM 2 SAMPLE IDENTIFICATION NUMBER FLAG FOR SAM ID FORM 1 1 NSWS SUBREGION (Continued) 17 ------- Table 4-1. (Continued) Variable SECDI1D SECME98 SECRE1D SIO211 SIO211F SITETYP SO411 SO498 SO411F SO4DP99 SOBC98 SPLCD02 ST99 STRAT99 T04051D T06101D T08151D T10201D T12251D T14301D T16351D T18401D T20451D TIMRE1D TIMSM1D TM0151D TMP6O1D TMPA1D TMPD11D TMPD21D TMP BID TUR02 TUR02F TXX501D VISIT ID WALA99 WALAX99 WDIR1D WSDIS99 WSHED99 WSHEDX99 WSOTH99 WSPD1D WT1M99 WT10 99 WT2C99 WT2T99 Type Num Num Num Num Char Char Num Num Char Num Num Char Char Char Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Char Num Char Num Num Char Char Num Num Char Char Num Num Num Num Length 8 8 8 8 12 9 8 8 12 8 8 1 2 3 8 8 8 8 8 8 8 8 8 8 3 8 8 8 8 8 8 8 12 8 12 8 8 3 8 8 8 25 8 8 8 8 8 Format F8.1 8.1 F8.1 F8.3 F8.3 F8.4 F8.2 F8.4 F8. F8. F8. F8. F8. F8. F8. F8. F8. TIME5. TIME5. F8. F8. F8 F8. F8. F8. F8.2 F8.1 F8.2 8.2 F8.3 8.3 8.3 8.3 8.4 8.3 SAS Label SECCHI DEPTH:DISAPPEAR (M) FORM ID MEAN: SECCHI DISK DISAPPEAR, REAPPEAR (M) SECCHI DEPTH: REAPPEAR (M) FORM ID SILICA (MG /L) FORM 1 1 FLAGFORSIO211 SAMPLING SITE OR TYPE CODE SULFATE ION (MG/L) FORM 1 1 SULFATE (UEQ/L) FLAG FOR SO4 11 SULFATE DEPOSITION (G/M ** 2/YR) SUM OF BASE CATIONS (UEQ/L) SPLIT/SAMPLE CODE TO LAS VEGAS FORM 2 STATE (TWO-LETTER ABBREV) NSWS STRATA TEMPERATURE AT 4 OR 5 M (DEGC) FORM ID TEMPERATURE AT 6 OR 10 M (DEGC) FORM ID TEMPERATURE AT 8 OR 15 M (DEGC) FORM ID TEMPERATURE AT 10 OR 20 M (DEGC) FORM ID TEMPERATURE AT 12 OR 25 M (DEGC) FORM ID TEMPERATURE AT 14 OR 30 M (DEGC) FORM ID TEMPERATURE AT 16 OR 35 M (DEGC) FORM ID TEMPERATURE AT 18 OR 40 M (DEGC) FORM ID TEMPERATURE AT 20 OR 45 M (DEGC) FORM ID TIME RECEIVED (24H) HH:MM FORM ID TIME SAMPLED (24H) HH:MM FORM ID TEMPERATURE (DEGC) AT 1.5 M FORM ID TEMPERATURE AT 0.6 * DEPTH (DEGC) FORM ID AIR TEMPERATURE (DECG) FORM ID TEMP DIP 1.5 M-BOTTOM (DEGC) FORM ID TEMP DIP 1.5 M-0.6 * DEPTH (DEGC) FORM ID TEMP AT BOTTOM-i .5 M (DEGC) FORM ID TURBIDITY (MTU) FORM2 FLAG FOR TUR02 TEMPERATURE AT 50 M (DEGC) FORM ID VISIT FORM ID WATERSHED AREA/LAKE AREA WATERSHED AREA/LAKE AREA-ALSC ESTIMATED WIND DIRECTION FORM ID D)WELL I)ND L)OG M)INE R)OAD S)TOCK WATERSHED AREA (HA) WATERSHED AREA (HA)-ALSC DISTURB W/I 100 M-OTHER ESTIMATED WIND SPEED FORM ID MODIFIED PHASE I WEIGHT ORIGINAL PHASE I WEIGHT CONDITIONAL PHASE II WEIGHT TOTAL PHASE II WEIGHT 18 ------- Table 4-2. Variables in the Reduced Validated Summer Seasonal (SUSVBM01) Data Set Variable ACCES1D ACCO11 ACCO11F ALD02 ALD02F ALDI98 ALEX 11 ALEX 1 IF ALKA11 ALKA11F ALO 02 ALO 02F ALTLT11 ALTL11F ANCAT98 ANDEF98 ANSUM98 BAT ID BNSTR99 C0051D C0051DT C051D C0151DF C0251D C0251DT C0351D C0451D C0551D C0651D C0751D C0851D C0951D C1051D C1251D C1451D C1651D C1851D C2051D C2251D C2451D C2651D C2851D C3051D C3251D C3451D Type Char Num Char Num Char Num Num Char Num Char Num Char Num Char Num Num Num Num Num Num Char Num Char Num Char Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Length 3 8 12 8 12 8 8 12 8 12 8 12 8 12 8 8 8 8 8 8 6 8 12 8 6 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 Format F8.1 F8.4 F8.4 F8.4 F8.1 F8.4 F8.4 F8.4 F8.4 F8.4 F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. SAS Label ACCESS FORM ID CO2-ACIDITY (UEQ/L) FORM 1 1 FLAG FOR ACCO1 1 PCV ALUMINUM DISSOLVED (UG/L) FORM 2 FLAG FOR ALD02 LABILE MONOMERIC AL (UG/L) ALUMINUM-EXTRACTABLE (UG/L) FORM 1 1 FLAG FOR ALEX 11 ALKALINITY (UEQ/L) FORM 1 1 FLAGFORALKA11 PCV ALUMINUM ORGANIC (UG/L) FORM 2 FLAG FOR ALO 02 TOTAL ALUMINUM (UG/L) FORM 1 1 FLAGFORALTL11 CATIONS/ANIONS RATIO CATSUM-ANSUM (UEQ/L) SUM OF ANIONS (UEQ/L) BATCH IDENTIFICATION NUMBER POPULATION SIZE BY STRATA CONDUCTIVITY AT 0.5 M (US/CM) FORM ID TAGFORC0051D CONDUCTIVITY AT 1.5 M (US/CM) FORM ID FLAG FOR CO 15 ID CONDUCTIVITY AT 2.5 M (US/CM) FORM ID TAGFORC0251D CONDUCTIVITY AT 3.5 M (US/CM) FORM ID CONDUCTIVITY AT 4.5 M (US/CM) FORM ID CONDUCTIVITY AT 5.5 M (US/CM) FORM ID CONDUCTIVITY AT 6.5 M (US/CM) FORM ID CONDUCTIVITY AT 7.5 M (US/CM) FORM ID CONDUCTIVITY AT 8.5 M (US/CM) FORM ID CONDUCTIVITY AT 9.5 M (US/CM) FORM ID CONDUCTIVITY AT 10.5 M (US/CM) FORM ID CONDUCTIVITY AT 12.5 M (US/CM) FORM ID CONDUCTIVITY AT 14.5 M (US/CM) FORM ID CONDUCTIVITY AT 16.5 M (US/CM) FORM ID CONDUCTIVITY AT 18.5 M (US/CM) FORM ID CONDUCTIVITY AT 20.5 M (US/CM) FORM ID CONDUCTIVITY AT 22.5 M (US/CM) FORM ID CONDUCTIVITY AT 24.5 M (US/CM) FORM ID CONDUCTIVITY AT 26.5 M (US/CM) FORM ID CONDUCTIVITY AT 28.5 M (US/CM) FORM ID CONDUCTIVITY AT 30.5 M (US/CM) FORM ID CONDUCTIVITY AT 32.5 M (US/CM) FORM ID CONDUCTIVITY AT 34.5 M (US/CM) FORM ID 19 ------- C3651D Num C3851D Num Table 4-2. (Continued) Variable CA11 CA98 CA11F CATSU98 CHLOD D CHLOR1D CL11 CL98 CL11F CLSTR99 CNTY99 CO398 COLOR02 COLOR02F COMNT1DA COMNT1DB CONCA98 COND11 CONDI IF CONMH1D CONMH1DF CONMM1D CONMM1DT CONTH1D CON BID CRWID1 D DATSH02 DATSMP DIC02 DIC02F DICE 11 DICE 1 IF DICI11 DICI11F DISM99 DOC 11 DOC11F DOFIA1D DOFIT1D DOINT1D DOMH1D DOMM1D DOTH ID DOTH1DT Type Num Num Char Num Num Num Num Num Char Num Char Num Num Char Char Char Num Num Char Num Char Num Char Num Num Char Num Num Num Char Num Char Num Char Num Num Char Num Num Num Num Num Num Char 8 8 Length 8 8 12 8 8 8 8 8 12 8 5 8 8 12 200 200 8 8 12 8 12 8 6 8 8 20 8 8 8 12 8 12 8 12 8 8 12 8 8 8 8 8 8 6 F8. F8. Format F8.3 F8.4 F8.4 F8.1 F8.1 F8.3 F8.4 F8. F8.4 F8. F8.4 F8.1 F8. F8. F8. F8. DATE7. DATE7. F8.3 F8.3 F8.3 F8. F8.2 F8.2 F8.2 F8.2 F8.2 F8.2 F8.2 CONDUCTIVITY AT 36.5 M (US/CM) FORM ID CONDUCTIVITY AT 38.5 M (US/CM) FORM ID (Continued) SAS Label CALCIUM (MG/L) FORM 1 1 CALCIUM (UEQ/L) FLAG FOR CA1 1 SUM OF CATIONS (UEQ/L) CHLOROPHYLL VOLUME H2O D (ML) FORM ID CHLOROPHYLL VOLUME H2O R (ML) FORM ID CHLORIDE ION (MG/L) FORM 1 1 CHLORIDE (UEQ/L) FLAG FOR CL 11 PHASE II CLUSTER (1, 2 or 3) FIPS CODE (ST, COUNTY) CARBONATE ALKALINITY (UEQ/L) COLOR (PCU) FORM 2 FLAG FOR COLOR02 FIRST PART COMMENTS FORM ID SECOND PART COMMENTS FORM ID CALCULATED CONDUCTIVITY (US/CM) CONDUCTIVITY (US/CM) FORM 1 1 FLAGFORCOND11 CONDUCTIVITY AT MID-HYP (US/CM) FORM ID FLAG FOR CONMH1D CONDUCTIVITY AT MID-MET (US/CM) FORM ID TAG FOR CONMM1D CONDUCTIVITY AT TOP-HYP (US/CM) FORM ID CONDUCTIVITY AT BTM-1 .5 M (US/CM) FORM ID FIELD CREW ID FORM ID DATE SHIPPED FORM 2 DATE SAMPLED DIG (MG/L) FORM 2 FLAG FOR DIC02 DIC-EQUIL (MG/L) FORM 1 1 FLAG FOR DICE 11 DIC-INIT (MG/L) FORM 1 1 FLAGFORDICI11 DISTANCE FROM COAST (MILES) DOC (MG/L) FORM 1 1 FLAG FOR DOC 11 D.O. FINAL ACTUAL CALIB VALUE FORM ID D.O. FINAL THEOR CALIB VALUE FORM ID D.O. INITIAL THEOR CALIB VALUE FORM ID DISSOLVED OXYGEN AT MID-HYP FORM ID DISSOLVED OXYGEN AT MID-MET FORM ID DISSOLVED OXYGEN AT TOP-HYP FORM ID TAG FOR DOTH ID 20 ------- DO 05 ID DO 05 IDT DO 151D Num Char Num 8 6 8 F8.2 F8.2 DISSOLVED OXYGEN AT 0.5 M FORM ID TAG FORD 015D DISSOLVED OXYGEN (MG/L) 1.5 M FORM ID (Continued) Table ~2. (Continued) Variable DO BID DPMH1D DPMM1D DPMM1DT DPSCB1D DPSCM1D DPSIT1D DPSITX1D DPTH1D DP BID ELEV99 ELEVX99 FEU FE11F FTL11 FTL98 FTL11F H98 HCO398 HDEP99 HYDID1D HYTYP99 INOUT99 Kll K98 K11F LABNA02 LAKE ID LAKNA1D LAT99 LATDD99 LKID99 LKNAM99 LKSIZ99 LKSIZX99 LKVOL99 LKVOLX99 LNGDD99 LONG99 MAPBG99 MAPSM99 MG11 VMG98 Type Num Num Num Char Num Num Num Num Num Num Num Num Num Char Num Num Char Num Num Num Char Char Char Num Num Char Char Char Char Char Num Char Char Num Num Num Num Num Char Char Char Num Num Length 8 8 8 6 8 8 8 8 8 8 8 8 8 12 8 8 12 8 8 8 4 9 6 8 8 12 30 7 30 10 8 7 30 8 8 8 8 8 11 25 40 8 8 Format F8.2 F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8.3 F8.4 F8.4 F8.4 F8.4 F8.3 F8.3 F8.4 F8.4 F8.2 F8.2 F8.3 F8.3 F8.4 F8.3 F8.4 SAS Label DISOXYGEN (MG/L) BOTTOM-1..5 M FORM ID DEPTH AT MID-HYP (M) FORM ID DEPTH AT MID-MET (M) FORM ID TAGFORDPMM1D DEPTH SAMPLE COLL BTM-1.5M (M) FORM ID DEPTH SAMPLE COLL MID-HYP (M) FORM ID SITE DEPTH (M) FORM ID MAXIMUM LAKE DEPTH (M)-ALSC DEPTH AT TOP-HYP (M) FORM ID DEPTH AT BTM-1.5 M (M) FORM ID LAKE ELEVATION (M) LAKE ELEVATION (M)-ALSC IRON (UG/L) FORM 1 1 FLAG FOR FE 11 FLUORIDE (MG/L) FORM 1 1 FLUORIDE (UEQ/L) FLAG FOR FTL 11 HYDROGEN FROM PHAC1 1 (UEQ/L) HCO3 (UEQ/L) HYDROGEN ION DEPOSITION (G/M ** 2/YR) HYDROLAB METER IDENTIFIER CODE FORM HYDROLOGIC TYPE PRESENCE/ABSENCE OF INLETS/OUTLETS POTASSIUM (MG/L) FORM 1 1 POTASSIUM (UEQ/L) FLAG FOR Kll LABORATORY FOR ANALYSIS FORM 2 LAKE IDENTIFICATION NUMBER LAKE NAME FORM ID LATITUDE LATITUDE (DECIMAL DEGREES) ERLD-UMD ID/ALSC WSHED-POND ID LAKE NAME LAKE SURFACE AREA (HA) LAKE SURFACE AREA (HA)-ALSC CALC LAKE VOL (10 ** 6 CUM) DIG. LAKE VOL (10 ** 6 CUM)-ALSC LONGITUDE (DECIMAL DEGREES) LONGITUDE MAP SHEET NAME (1:250,000 SCALE) MAP SHEET NAME, 15 OR 7.5 QUAD MAGNESIUM (MG/L) FORM 1 1 MAGNESIUM (UEQ/L) ID 21 ------- MG11F MN11 MN11F NA11 Char Num Char Num 12 8 12 8 F8.3 F8.3 FLAG FOR MG 11 MANGANESE (UG/L) FORM 1 1 FLAG FOR MN 11 SODIUM (MG/L) FORM 1 1 (Continued) Table 4-2. (Continued) Variable NA98 NA11F NH411 NH498 NH411F NO311 NO398 NO311F NO3DP99 ORGIO98 PH02 PH0051D PH0151D PH02F PHAC11 PHAC11F PHAL11 PHAL11F PHEQ11 PHEQ11F PHMH1D PHMM1D PHTH1D PH BID PRCIP99 PREC1D PRECO1D PTL11 PTL11F RGSPC99 RPREC1D RT99 RTX99 RUNIN99 RUNOF99 RUNOFX99 SAMBL1D SAMBT1D SAMCD02 SAMD11D SAMD21D S AMID 1 IF Type Num Char Num Num Char Num Num Char Num Num Num Num Num Char Num Char Num Char Num Char Num Num Num Num Num Char Char Num Char Char Char Num Num Num Num Num Num Num Char Num Num Char Length 8 12 8 8 12 8 8 12 8 8 8 8 8 12 8 12 8 12 8 12 8 8 8 8 8 5 7 8 12 16 8 8 8 8 8 8 8 8 10 8 8 12 Format F8.4 F8.3 F8.4 F8.4 F8.4 F8.2 F8.4 F8.2 F8.2 F8.2 F8.2 F8.2 F8.2 F8.2 F8.2 F8.2 F8.2 FB.3 F8.4 F8.3 F8.3 F8. F8.3 F8.3 F8. F8. F8. F8. SAS Label SODIUM (UEQ/L) FLAG FOR NA 11 AMMONIUM ION (MG/L) FORM 1 1 AMMONIUM (UEQ/L) FLAG FOR NH4 11 NITRATE ION (MG/L) FORM 1 1 NITRATE (UEQ/L) FLAG FOR NO3 11 NITRATE DEPOSITION (G/M ** 2/YR) ORGANIC ANION (UEQ/L) STATION PH FORM 2 PH AT 0.5 M FORM ID PHAT1.5MFORM ID FLAG FOR PH02 ACIDITY INITIAL PH FORM 1 1 FLAGFORPHAC11 ALKALINITY INITIAL PH FORM 1 1 FLAGFORPHAL11 AIR-EQUILIBRATED PH FORM 1 1 FLAGFORPHEQ11 PH AT MID-HYP FORM ID PH AT MID-MET FORM ID PH AT TOP-HYP FORM ID PHATBTM-1.5MFORM ID PRECIPITATION (M/YR) PRECIPITATION FORM ID PRECIPITATION OBS (PR EV/CURRENT) FORM ID TOTAL PHOSPHORUS (UG/L) FORM 1 1 FLAG FOR PTL 11 REG SPEC LTM NRC DEW DER SAMPLE CLASS RATE OF PRECIPITATION FORM ID RESIDENCE TIME (YR) RESIDENCE TIME (YR)-ALSC ANNUAL RUNOFF INCHES FROM DIGIT MAP SURFACE WATER RUNOFF (M/YR) SURFACE WATER RUNOFF (M/YR)-ALSC SAMPLE ID FOR BLANK FORM ID SAMPLE ID BTM-1.5 M (6H21) FORM ID SAMPLE CODE FORM 2 SAMPLE ID DUPLICATE 1 FORM ID SAMPLE ID DUPLICATE 2 FORM ID FLAG FOR SAM ID FORM 1 1 22 ------- SAMMH1D SAMSF1D SAM ID SBRGN99 SCBLK1D Num Num Num Char Char 8 F8. 8 F8. 8 F8. 1 1 SAMPLE ID MID-HYP (6H1 1) FORM ID SAMPLE ID SFC-1.5 M (6E11) FORM ID SAMPLE IDENTIFICATION NUMBER NSWS SUBREGION BLANK SAMPLE COLLECTED (Y ORN) FORM ID (Continued) Table 4-2. (Continued) Variable SCD151D SCDBT1D SCDMH1D SCR151D SCRBT1D SCRMH1D SECDI1D SECDV1D SECME98 SECRE1D SIO211 SIO211F SITETYP SMSTR1D SMTR1D SO411 SO498 SO411F SO4DP99 SOBC98 SPLCD02 ST99 STRAT99 SUBID1D T0051D T0151D T0251D T0351D T0451D T0551D T0651D T0751D T0851D T0951D T1051D T1251D T1451D T1651D T1851D T2051D T2251D T2451D Type Char Char Char Char Char Char Num Char Num Num Num Char Char Num Num Num Num Char Num Num Char Char Char Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Length Format SAS Label 1 1 1 1 1 1 8 F8. 1 8 F8. 8 F8. DUPLICATE SAMP COLL AT 1.5 M FORM ID DUPLICATE SAMP COLL AT BTM-1.5 M FORM ID DUPLICATE SAMP COLL AT MID-HYP FORM ID ROUTINE SAMP COLL AT 1.5 M FORM ID ROUTINE SAMP COLL AT BTM-1.5 M FORM ID ROUTINE SAMP COLL AT MID-HYP FORM ID [ SECCHI DEPTH:DISAPPEAR (M) FORM ID SECCHI DEPTH Y= VISIBLE TO BOTTOM FORM ID [ MEAN: SECCHI DISK DISAPPEAR, REAPPEAR (M) [ SECCHI DEPTH: REAPPEAR (M) FORM ID 8 F8.3 SILICA (MG/L) FORM 1 1 12 9 8 F8. 8 F8. 8 F8.: FLAGFORSIO211 SAMPLING SITE OR TYPE CODE SAMPLE ID IN SUBSET TRIPLICATE FORM ID SAMPLE ID TRIPLICATE FORM ID 5 SULFATE ION (MG/L) FORM 1 1 8 F8.4 SULFATE (UEQ/L) 12 FLAG FOR SO4 11 8 F8.2 SULFATE DEPOSITION (G/M ** 2/YR) 8 F8.4 SUM OF BASE CATIONS (UEQ/L) 12 2 3 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. SPLIT/SAMPLE CODE TO LAS VEGAS FORM 2 STATE (TWO-LETTER ABBREV) NSWS STRATA BATCH ID FOR SUBSET BATCH FORM ID TEMPERATURE AT 0.5 M (DEGC) FORM ID TEMPERATURE AT 1.5 M (DEGC) FORM ID TEMPERATURE AT 2.5 M (DEGC) FORM ID TEMPERATURE AT 3.5 M (DEGC) FORM ID TEMPERATURE AT 4.5 M (DEGC) FORM ID TEMPERATURE AT 5.5 M (DEGC) FORM ID TEMPERATURE AT 6.5 M (DEGC) FORM ID TEMPERATURE AT 7.5 M (DEGC) FORM ID TEMPERATURE AT 8.5 M (DEGC) FORM ID TEMPERATURE AT 9.5 M (DEGC) FORM ID TEMPERATURE AT 10.5 M (DEGC) FORM ID TEMPERATURE AT 12.5 M (DEGC) FORM ID TEMPERATURE AT 14.5 M (DEGC) FORM ID TEMPERATURE AT 16.5 M (DEGC) FORM ID TEMPERATURE AT 18.5 M (DEGC) FORM ID TEMPERATURE AT 20.5 M (DEGC) FORM ID TEMPERATURE AT 22.5 M (DEGC) FORM ID TEMPERATURE AT 24.5 M (DEGC) FORM ID 23 ------- T2651D T2851D T3051D T3251D T3451D Num Num Num Num Num 8 8 8 8 8 F8. F8. F8. F8. F8. TEMPERATURE AT 26.5 M (DEGC) FORM ID TEMPERATURE AT 28.5 M (DEGC) FORM ID TEMPERATURE AT 30.5 M (DEGC) FORM ID TEMPERATURE AT 32.5 M (DEGC)FORM ID TEMPERATURE AT 34.5 M (DEGC)FORM ID (Continued) Table 4-2. (Continued) Variable T3651D T3851D TIMSM1D TMPA1D TMPMH1D TMPMM1D TMPTH1D TM BID TUR02 TUR02F WALA99 WALAX99 WDIR1D WSDIS99 WSHED99 WSHEDX99 WSOTH99 WSPD1D WT1M99 WT1O 99 WT2C99 WT2T99 Type Num Num Num Num Num Num Num Num Num Char Num Num Char Char Num Num Char Char Num Num Num Num Length 8 8 8 8 8 8 8 8 8 12 8 8 3 8 8 8 25 8 8 8 8 8 Format F8.1 F8.1 TIMES. F8. F8.1 F8.1 F8.1 F8.1 F8.2 F8.2 F8.2 F8.3 F8.3 F8.3 F8.3 F8.4 F8.3 SAS Label TEMPERATURE AT 36.5 M (DEGC) FORM ID TEMPERATURE AT 38.5 M (DEGC) FORM ID TIME SAMPLED (24H) HH:MM FORM ID AIR TEMPERATURE (DEGC) FORM ID TEMPERATURE AT MID-HYP (DEGC) FORM ID TEMPERATURE AT MID-MET (DEGC) FORM ID TEMPERATURE AT TOP-HYP (DEGC) FORM ID TEMPERATURE AT BTM-1.5 M (DEGC) FORM ID TURBIDITY (NTU) FORM 2 FLAG FOR TUR02 WATERSHED AREA/LAKE AREA WATERSHED AREA/LAKE AREA-ALSC ESTIMATED WIND DIRECTION FORM ID D)WELL I)ND L)OG M)INE R)OAD S)TOCK WATERSHED AREA (HA) WATERSHED AREA (HA)-ALSC DISTURB W/I 100 M-OTHER ESTIMATED WIND SPEED FORM ID MODIFIED PHASE I WEIGHT ORIGINAL PHASE I WEIGHT CONDITIONAL PHASE II WEIGHT TOTAL PHASE II WEIGHT 24 ------- Table 4-3. Variables in the Reduced Validated Fall Seasonal (FASVBM01) Data Set Variable ACCES1D ACCO11 ACCO11F ALD02 ALD02F ALDI98 ALEX 11 ALEX 1 IF ALKA11 ALKA11F ALO 02 ALO 02F ALTLT11 ALTL11F ANCAT98 ANDEF98 ANSUM98 BAT ID BNSTR99 C0151D C0151DF C04051D C06101D C08151D C10201D C12251D C14301D C16351D C18401D C20451D CA11 CA98 CA11F CATSU98 CL11 CL98 CL11F CLSTR99 CNTY99 CO398 COLOR02 COLOR02F COMNTA1D COMNTB1D CON601D CONCA98 COND11 Type Char Num Char Num Char Num Num Char Num Char Num Char Num Char Num Num Num Num Num Num Char Num Num Num Num Num Num Num Num Num Num Num Char Num Num Num Char Num Char Num Num Char Char Char Num Num Num Length 3 8 12 8 12 8 8 12 8 12 8 12 8 12 8 8 8 8 8 8 12 8 8 8 8 8 8 8 8 8 8 8 12 8 8 8 12 8 5 8 8 12 150 150 8 8 8 Format F8.1 F8.4 F8.4 F8.4 F8.1 F8.4 F8.4 F8.4 F8.4 F8.4 F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8. F8.3 F8.4 F8.4 F8.3 F8.4 F8. F8.4 F8. F8. F8.4 F8.1 SAS Label ACCESS FORM ID CO2-ACIDITY (UEQ/L) FORM 1 1 FLAG FOR ACCO1 1 PCV ALUMINUM DISSOLVED (UG/L) FORM 2 FLAGFQRALD02 LABILE MONOMERIC AL (UG/L) ALUMINUM-EXTRACTABLE (UG/L) FORM 1 1 FLAG FOR ALEX 11 ALKALINITY (UEQ/L) FORM 1 1 FLAGFORALKA11 PCV ALUMINUM ORGANIC (UG/L) FORM 2 FLAG FOR ALO 02 TOTAL ALUMINUM (UG/L) FORM 1 1 FLAG FORALTL11 CATIONS/ANIONS RATIO CATSUM-ANSUM (UEQ/L) SUM OF ANIONS (UEQ/L) BATCH IDENTIFICATION NUMBER POPULATION SIZE BY STRATA CONDUCTIVITY (US/CM) AT 1.5 M FORM ID FLAG FOR CO 15 ID CONDUCTIVITY AT 4 OR 5 M (US/CM) FORM ID CONDUCTIVITY AT 6 OR 10 M (US/CM) FORM ID CONDUCTIVITY AT 8 OR 15 M (US/CM) FORM ID CONDUCTIVITY AT 10 OR 20 M (US/CM) FORM ID CONDUCTIVITY AT 12 OR 25 M (US/CM) FORM ID CONDUCTIVITY AT 14 OR 30 M (US/CM) FORM ID CONDUCTIVITY AT 16 OR 35 M (US/CM) FORM ID CONDUCTIVITY AT 18 OR 40 M (US/CM) FORM ID CONDUCTIVITY AT 20 OR 45 M (US/CM) FORM ID CALCIUM (MG/L) FORM 1 1 CALCIUM (UEQ/L) FLAG FOR CA 11 SUM OF CATIONS (UEQ/L) CHLORIDE ION (MG/L) FORM 1 1 CHLORIDE (UEQ/L) FLAG FOR CL 11 PHASE II CLUSTER (1, 2 or 3) FIPS CODE (ST, COUNTY) CARBONATE ALKALINITY (UEQ/L) COLOR (PCU) FORM 2 FLAG FOR COLOR02 FIRST PART OF COMMENTS FORM ID SECOND PART OF COMMENTS FORM ID CONDUCTIVITY AT 0.6 * DEPTH (US/CM) FORM ID CALCULATED CONDUCTIVITY (US/CM) CONDUCTIVITY (US/CM) FORM 1 1 25 ------- Table 4-3. (Continued) Variable CONDI IF CON BID CXX501D DATSH02 DATSMP DIC02 DIC02F DICE 11 DICE 1 IF DICI11 DICI11F DISM99 DOC 11 DOC11F DO 151D DO 601D DO BID DPCAT1D DPSIT1D DPSITX1D DP 601D DP BID ELEV99 ELEVX99 FEU FE11F FTL11 FTL98 FTL11F H98 HCO398 HDEP99 HYDID1D HYTYP99 INOUT99 Kll K98 K11F LABNA02 LAKE ID LAKNA1D LAT99 LATDD99 LKID99 LKNAM99 LKSIZ99 LKSIZX99 Type Char Num Num Num Num Num Char Num Char Num Char Num Num Char Num Num Num Num Num Num Num Num Num Num Num Char Num Num Char Num Num Num Char Char Char Num Num Char Char Char Char Char Num Char Char Num Num Length 12 8 8 8 8 8 12 8 12 8 12 8 8 12 8 8 8 8 8 8 8 8 8 8 8 12 8 8 12 8 8 8 4 9 6 8 8 12 30 7 30 10 8 7 30 8 8 Format F8. F8. DATE7. DATE7. F8.3 F8.3 F8.3 F8. F8.2 F8.2 F8.2 F8.2 F8. F8.1 F8.1 F8.1 F8.1 F8.1 F8. 1 F8.3 F8.4 F8.4 F8.4 F8.4 F8.3 F8.3 F8.4 F8.4 F8.2 F8.2 (Continued) SAS Label FLAGFQRCOND11 CONDUCT AT BOTTOM- 1.5 M (US/CM) FORM ID CONDUCTIVITY AT 50 M (US/CM) FORM ID DATE SHIPPED FORM 2 DATE SAMPLED DIG (MG/L) FORM 2 FLAG FOR DIC02 DIC-EQUIL (MG/L) FORM 1 1 FLAG FOR DICE 11 DID-INIT (MG/L) FORM 1 1 FLAGFORDICI11 DISTANCE FROM COAST (MILES) DOC (MG/L) FORM 1 1 FLAG FOR DOC 11 DISSOLVED OXYGEN (MG/L) 1.5 M FORM ID DISSOLVED OXYGEN AT 0.6 * DEPTH FORM ID DIS OXYGEN (MG/L) BOTTOM-1.5 M FORM ID DEPTH CATEGORY 4 = <20 M 5 = >20 M FORM SITE DEPTH (M) FORM ID MAXIMUM LAKE DEPTH (M)-ALSC DEPTH 0.6 * BOTTOM (M) FORM ID DEPTH AT BOTTOM-1.5 M (M) FORM ID LAKE ELEVATION (M) LAKE ELEVATION (M)-ALSC IRON (UG/L) FORM 1 1 FLAG FOR FE 11 FLUORIDE (MG/L) FORM 1 1 FLUORIDE (UEQ/L) FLAG FOR FTL 11 HYDROGEN FROM PHAC1 1 (UEQ/L) HCO3 (UEQ/L) HYDROGEN ION DEPOSITION (G/M ** 2/YR) HYDROLAB METER IDENTIFIER CODE FORM HYDROLOGIC TYPE PRESENCE/ABSENCE OF INLETS/OUTLETS POTASSIUM (MG/L) FORM 1 1 POTASSIUM (UEQ/L) FLAG FOR Kll LABORATORY FOR ANALYSIS FORM 2 LAKE IDENTIFICATION NUMBER LAKE NAME FORM ID LATITUDE LATITUDE (DECIMAL DEGREES) ERLD-UMD ID/ALSC WSHED-POND ID LAKE NAME LAKE SURFACE AREA (HA) LAKE SURFACE AREA (HA)-ALSC ID ID 26 ------- Table 4-3. (Continued) Variable LKVOL99 LKVOLX99 LNGDD99 LONG99 MAPBG99 MAPSM99 MG11 MG98 MG11F MN11 MN11F NA11 NA98 NA11F NH411 NH498 NH411F NO311 NO398 NO311F NO3DP99 NVLAK1D OB SID ID ORGIO98 PH0151D PH0151DF PH02 PH02F PHAC11 PHAC11F PHAL11 PHAL11F PHEQ11 PHEQ11F PH 60 ID PH BID PRCIP99 PREC1D PRECO1D PTL11 PTL11F RGSPC99 RPREC1D RT99 RTX99 Type Num Num Num Char Char Char Num Num Char Num Char Num Num Char Num Num Char Num Num Char Num Char Char Num Num Char Num Char Num Char Num Char Num Char Num Num Num Char Char Num Char Char Char Num Num Length 8 8 8 11 25 40 8 8 12 8 12 8 8 12 8 8 12 8 8 12 8 1 6 8 8 12 8 12 8 12 8 12 8 1 8 8 8 5 7 8 12 16 8 8 8 Format F8.3 F8.3 F8.4 F8.3 F8.4 F8.3 F8.3 F8.4 F8.3 F8.4 F8.4 F8.4 F8.2 SAS Label CALC LAKE VOL (10 ** 6 CUM) DIG. LAKE VOL (10 ** 6 CUM)-ALSC LONGITUDE (DECIMAL DEGREES) LONGITUDE MAP SHEET NAME (1:250,000 SCALE) MAP SHEET NAME, 15 OR 7.5 QUAD MAGNESIUM (MG/L) FORM 1 1 MAGNESIUM (UEQ/L) FLAG FOR MG 11 MANGANESE (UG/L) FORM 1 1 FLAG FOR MN 11 SODIUM (MG/L) FORM 1 1 SODIUM (UEQ/L) FLAG FOR NA 11 AMMONIUM ION (MG/L) FORM 1 1 AMMONIUM (UEQ/L) FLAG FOR NH4 11 NITRATE ION (MG/L) FORM 1 1 NITRATE (UEQ/L) FLAG FOR NO3 11 NITRATE DEPOSITION (G/M ** 2/YR) (Continued) NON-VARIABILITY LAKE (Y ORN) FORM ID F8.4 F8.2 F8.2 F8.2 F8.2 F8.2 F8.2 F8.2 F8.3 F8.4 OBSERVER ID NUMBER FORM ID ORGANIC ANION (UEQ/L) PHAT1.5MFORM ID FLAG FOR PHO 15 ID STATION PH FORM 2 FLAG FOR PH02 ACIDITY INITIAL PH FORM 1 1 FLAGFORPHAC11 ALKALINITY INITIAL PH FORM 1 1 FLAG FOR PHAL1 1 AIR-EQUILIBRATED PH FORM 1 1 FLAGFORPHEQ11 PH AT 0.6 * DEPTH FORM ID PHATBOTTOM-1.5 M FORM ID PRECIPITATION (M/YR) PRECIPITATION FORM ID PRECIPITATION OBS (PRE/CURRENT) TOTAL PHOSPHORUS (UG/L) FORM 1 1 FLAG FOR PTL 11 FORM ID REG SPEC LTM NRC DEW DER SAMPLE CLASS F8.3 F8.3 RATE OF PRECIPITATION FORM ID RESIDENCE TIME (YR) RESIDENCE TIME (YR)-ALSC 27 ------- RUNIN99 RUNOF99 Num Num 8 F8. 8 F8.: ANNUAL RUNOFF INCHES FROM DIGIT MAP 5 SURFACE WATER RUNOFF (M/YR) Table 4-3. (Continued) Variable RUNOFX99 SAMBL1D SAMCD02 SAMDP1D S AMID 1 IF SAMRT1D SAM ID SBRGN99 SCBLK1D SCD151D SCR151D SECDI1D SECDV1D SECME98 SECRE1D SIO211 SIO211F SITETYP SO411 SO498 SO411F SO4DP99 SOBC98 SPRID1D ST99 STRAT99 T04051D T06101D T08151D T10201 D T12251D T14301D T16351D T18401D T20451D TIMSM1D TM0151D TMP601D TMPA1D TMPD11D TMPD21D TMP BID TUR02 Type Num Num Char Num Char Num Num Char Char Char Char Num Char Num Num Num Char Char Num Num Char Num Num Char Char Char Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Length Format SAS Label 8 F8.3 SURFACE WATER RUNOFF (M/YR)-ALSC 8 F8. 10 8 F8. 12 8 F8. 8 F8. 1 1 1 1 8 F8. 1 8 F8. 8 F8. 8 F8.: 12 9 SAMPLE ID FOR BLANK FORM ID SAMPLE CODE FORM 2 SAMPLE ID DUPLICATE FORM ID FLAG FOR SAM ID FORM 1 1 SAMPLE ID ROUTINE FORM ID SAMPLE IDENTIFICATION NUMBER NSWS SUBREGION BLANK SAMPLE COLLECTED AT 1.5 M FORM ID DUPLICATE SAMPLE COLL AT 1.5 M FORM ID ROUTINE SAMPLE COLL AT 1.5 M FORM ID [ SECCHI DEPTH:DISAPPEAR (M) FORM ID SECCHI DEPTH Y= VISIBLE TO BOTTOM FORM ID [ MEAN: SECCHI DISK DISAPPEAR, REAPPEAR (M) [ SECCHI DEPTH: REAPPEAR (M) FORM ID 5 SILICA (MG/L) FORM 1 1 FLAG FORSIO211 SAMPLING SITE OR TYPE CODE 8 F8.3 SULFATE ION (MG/L) FORM 1 1 8 F8.4 SULFATE (UEQ/L) 12 FLAG FOR SO4 11 8 F8.2 SULFATE DEPOSITION (G/M ** 2/YR) 8 F8.4 SUM OF BASE CATIONS (UEQ/L) 6 2 3 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 TI1V 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. 8 F8. SAMPLER ID NUMBER FORM ID STATE (IWO-LETTER ABBREV) NSWS STRATA TEMPERATURE AT 4 OR 5 M (DEGC) FORM ID TEMPERATURE AT 6 OR 10 M (DEGC) FORM ID TEMPERATURE AT 8 OR 15 M (DEGC) FORM ID TEMPERATURE AT 10 OR 20 M (DEGC) FORM ID TEMPERATURE AT 12 OR 25 M (DEGC) FORM ID TEMPERATURE AT 14 OR 30 M (DEGC) FORM ID TEMPERATURE AT 16 OR 35 M (DEGC) FORM ID TEMPERATURE AT 18 OR 40 M (DEGC) FORM ID TEMPERATURE AT 20 OR 45 M (DEGC) FORM ID IBS. TIME SAMPLED (24H) HH:MM FORM ID TEMPERATURE (DEGC) AT 1.5 M FORM ID TEMPERATURE AT 0.6 * DEPTH (DEGC) FORM ID AIR TEMPERATURE (DEGC) FORM ID TEMP DIP 1.5 M-BOTTOM (DEGC) FORM ID TEMP DIP 1.5 M-0.6 * DEPTH (DEGC) FORM ID TEMP AT BOTTOM-1.5 M (DEGC) FORM ID 8 F8.2 TURBIDITY (NTU) FORM 2 28 ------- TUR02F TXX501D VISIT ID WALA99 Char Num Num Num 12 F8.1 F8. F8.2 FLAG FOR TUR02 TEMPERATURE AT 50 M (DEGC) FORM ID VISIT FORM ID WATERSHED AREA/LAKE AREA Table 4-3. (Continued) Variable Type Length Format SAS Label WALAX99 WDIR1D WSDIS99 WSHED99 WSHEDX99 WSOTH99 WSPD1D WT1M99 WT1O_99 WT2C99 WT2T99 Num Char Char Num Num Char Char Num Num Num Num 25 F8~2 F8.3 F8.3 F8.3 F8.3 F8.4 F8.3 WATERSHED AREA/LAKE AREA-ALSC ESTIMATED WIND DIRECTION FORM ID D)WELL I)ND L)OG M)INE R)OAD S)TOCK WATERSHED AREA (HA) WATERSHED AREA (HA)-ALSC DISTURB W/l 100 M-OTHER ESTIMATED WIND SPEED FORM ID MODIFIED PHASE I WEIGHT ORIGINAL PHASE I WEIGHT CONDITIONAL PHASE II WEIGHT TOTAL PHASE II WEIGHT 29 ------- SECTION 5 DEFINITIONS OF VARIABLES Table 5-1 provides units of measure and extended definitions for variables in the reduced validated (DS3B) and final (DS4A) ELS-II data sets. The seasonal surveys in which each variable appears are indicated under the following headings: SPS Spring Seasonal Survey SUS Summer Seasonal Survey FAS Fall Seasonal Survey Table 5-1 also provides the name of the corresponding variable in the ELS-I database, as documented in the ELS-I data dictionary (Kanciruk et al, 1986). Tag and flag variables (coded as varT or varF) are not included in Table 5-1, as their definitions would always be "tag (or flag) for variable X" (see Section 6). In situ measurements are described by Kerfoot and Faber (1986) and Bonoff and Groeger (1986). EPA methods are from EPA (1983,1987). Processing laboratory operations and methods are described in Arent et al. (1988). DROP CODE VARIABLE A drop code variable (DRPCDE) has been added to each enhanced seasonal data set to facilitate making population estimates. Using this variable, it is possible to eliminate different subsets of lakes in the database that are not used in making population estimates. The DRPCDE variable is numeric, with the following values: 0 = ELS-II target population sample 1 = Non-ELS-I index location (fall variability study) 2 = Hypolimnion or bottom water sample (summer data) 3 = Non-ELS-II target lake This variable is useful because the ELS-II database contains data for lakes that are not among the 145 target ELS-II lakes used to make estimates of the 3,993 lakes in the ELS-II target population. Nontarget lakes have been assigned a DRPCDE value of 3. The summer data set contains hypolimnetic data for stratified lakes. In the ELS, index samples were defined as epilimnetic samples, so hypolimnetic data were not used as index values. Some lakes in the fall data set were visited two additional times, at independently selected points believed to be the deepest part of the lake, to examine within-season and site selection variability. The lake visit marked with SITETYP = 'V2' or SITETYP = 'NV' (nonvariability lake) was made to the site on the lake where the ELS-I sample was collected and is considered to be the "fall index sample" for seasonal comparisons. Other fall visits were not used to make ELS-II seasonal population estimates and thus were assigned a DRPCDE=1. In three lakes (1A1-008, 1A1-070, 1A3-046), a SITETYP = 'V2' sample was not collected, thus the visit with SITETYP = 'Vi' was considered to be the fall index sample and has a DRPCDE=0. Thus, to get the 145 target ELS-II lake index samples for each seasonal data set, it is necessary to exclude all observations with a DRPCDE > 0. 31 ------- Table 5-1. Definition of Variables, U.S. EPA Eastern Lake Survey - Phase II Variable Name Phase I Name SPS SUS FAS Units Definition ACCES1D ACCO11 ACCO11 X X X X X ALD02 ALDI98 ALEX 11 ALEX 11 X X X X X X X X X ALKA11 ALKA1 1 X X X ALO 02 X X X ALTL11 ALTL11 X X X Mode by which lake was accessed: H = helicopter, D = direct vehicle, W = wilderness. IJ.QO/L Carbon dioxide acidity (or base neutralizing capacity) is the measured acidity in a sample due to dissolved CO2, hydronium, and other acids. Measured in the analytical laboratory using base titration and Gran analysis. Mg/L Total monomeric aluminum as determined by pyrocatechol violet (PCV) colorimetry in the processing laboratory. Mg/L Inorganic (labile) monomeric aluminum, determined by difference: ALDI98 = ALD02 - ALO_02. Mg/L Extractable aluminum (an estimate of monomeric aluminum complexes) determined by complexation with 8-hydroxyquinoline and extraction with methyl-isobutyl ketone (MIBK) in the processing laboratory. The extract was then analyzed in the analytical laboratory using the method described by Hillmanetal. (1986). ,ueq/L Acid neutralizing capacity is a measure of the amount of acid necessary to neutralize the carbonate species, hydroxide, and other bases in a sample. Determined in the analytical laboratory in an unfiltered, unacidified aliquot, using acidimetric titration and modified Gran analysis (Hiliman etal, 1986; Kramer, 1984). Mg/L Organic (nonexchangeable) monomericaluminum as determined by pyrocatechol violet (PCV) colorimetry and the use of a strong cation exchange column in the processing laboratory. Mg/L Total aluminum, measured in the analytical laboratory in an unfiltered, acidified (HNO3) aliquot, using EPA method 202.2 (AAS, atomic absorption spectroscopy, graphite furnace). ANCAT98 ANCAT X X X Ratio of measured cations to measured anions: ANCAT98 = CATSU98/ANSUM98 (Continued) 32 ------- Table 5-1. (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition ANDEF98 ANDEF ANSUM98 ANSUM BAT ID COOS ID C0151D C0251D C0351D C04051D C0451D C0551D BAT ID BNSTR99 BNSTAR CON 1 XXX ^eq/L Anion deficit is the measured cations minus the measured anions: ANDEF98 = CATSU98 - ANSUM98. XXX ^eq/L Sum of major anion concentrations: ANSUM98 CL98 + FTL98 + N0398 + HC0398 + C0398 + S0498. XXX Batch identification number; lakewater and QA samples processed and analyzed together were given common batch numbers. Numeric variable in ELS-II, character variable in ELS-I. XXX Number of lakes identified in the ELS-I stratum (see STRAT99) from the USGS l:250,000-scale maps. Lakes to be sampled were randomly selected to represent this frame population. Profile Measurements Specific conductance profile measurements were taken when TMPD21D > 4°C. Profile measurement depths were determined by maximum lake depth measured (DPSIT1D). For the spring and fall surveys, if DPSIT1D < 20 m, profile measurements were taken at 4 m, and at 2-m increments to the bottom. If DPSIT1D > 20 m, the profile was taken at 5 m, and at 5-m increments to the bottom. For the summer survey, measurements were taken at 0.5 m and at 1-m increments to 10.5 m, there after at 2-m increments to 38.5 m. X ^S/cm Conductivity at 0.5 m. XXX ^S/cm Conductivity at 1.5 m. X ^S/cm Conductivity at 2.5 m. X ^S/cm Conductivity at 3.5 m. X X MS/cm Conductivity at 4 m (DPSIT1D < 20) or 5 m (DPSIT1D > 20). X ^S/cm Conductivity at 4.5 m. X ^S/cm Conductivity at 5.5 m. (Continued) 33 ------- Table 5-1. (Continued) Variable Phase I Name Name C06101D CON_2 C0651D C0751D C08151D CON_3 C0851D C0951D C 1020 ID CON_4 C1051D C 1225 ID CON_5 C1251D C 1430 ID CON_6 C1451D C16351D CON_7 C1651D C 1840 ID CON_8 C1851D C20451D CON_9 C2051D C2251D C2451D C2651D SPS SUS FAS Units X X MS/cm X MS/cm X juS/cm X X /uS/cm X /uS/cm X juS/cm X X MS/cm X MS/cm X X MS/cm X MS/cm X X MS/cm X MS/cm X X MS/cm X MS/cm X X MS/cm X juS/cm X X MS/cm X /uS/cm X juS/cm X MS/cm X MS/cm Definition Conductivity at 6 m (DPSIT1D < (DPCSI1D>20). Conductivity at 6.5 m. Conductivity at 7.5 m. Conductivity at 8 m (DPSIT1D < (DPCSI1D>20). Conductivity at 8.5 m. Conductivity at 9.5 m. Conductivity at 10 m (DPSIT1D< (DPSIT1D > 20). Conductivity at 10.5 m. Conductivity at 12 m (DPSIT1D < (DPSIT1D > 20). Conductivity at 12.5 m. 20) or 10m 20) or 15 m 20) or 20 m 20) or 25 m Conductivity at 14 m (DPSIT1D < 20) or 30 m (DPSIT1D > 20). Conductivity at 14.5 m. Conductivity at 16 m (DPSIT1 D < 20) or 35 m (DPSIT1D > 20). Conductivity at 16.5 m. Conductivity at 18 m (DPSIT1D< (DPSIT1D > 20) Conductivity at 18.5 m. 20) or 40 m Conductivity at 20 m (DPSIT1D < 20) or 45 m (DPSIT1D > 20). Conductivity at 20.5 m. Conductivity at 22.5 m. Conductivity at 24.5 m. Conductivity at 26.5 m. (Continued) 34 ------- Table 5-1. (Continued) Variable Phase I Name Name C2851D C3051D C3251D C3451D C3851D C3851D CXX501D CON_10 CA11 CA11 CA98 Cal6 CATSU98 CATSUM CHLOD1D CHLOR1D CL11 CL11 CL98 CL16 CLSTR99 CNTY99 COUNTY SPS SUS X X X X X X X X X X X X X X X X X X X X X X X FAS Units Definition ^S/cm Conductivity at 28.5 m. ^S/cm Conductivity at 30.5 m. ^S/cm Conductivity at 32.5 m. ^S/cm Conductivity at 34.5 m. ^S/cm Conductivity at 36.5 m. ^S/cm Conductivity at 38.5 m. X ^S/cm Conductivity at 50 m. X mg/L Dissolved calcium, measured in the analytical laboratory in filtered, acidified (HNO3) aliquot (EPA method 215.1, AAS, flame). X Meq/L Dissolved calcium: CA98 = CA11 * 49.90 Meq/mg. X IJ.QO/L Summation of major cation concentrations: CATSU98 = CA98 + MG98 + NA98 + K98 + NH498 + H98. mL Volume of duplicate sample for chlorophyll analysis. mL Volume replicate sample for chlorophyll analysis. X mg/L Chloride ion, measured in the analytical laboratory by ion chromatography in a filtered, unacidified aliquot (ASTM, 1984;O'Delletal, 1984). X Meq/L Chloride ion: CL98 = CL1 1 * 28.21 Meq/mg. X Phase II cluster: 1, 2 or 3. X Federal Information Processing Standard (USDC, 1979) state and county code. CO398 CO316 XXX Meq/L Carbonate, an estimate (Butler, 1982) of: CO32- = 4.996 x [PIC mg/LI x KjK2 [H+]2 ------- Table 5-1. (Continued) (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition COLOR02 COLVAL which is coded as: CO398 = 60009* (DICI11/12011)*ALPHA2*33.33 Where: ALPHA2 = Kl* K2/((10**(-PHAC11)) **2 + (10**-PHAC11)*K1 + K1*K2); and Kl = 4.3 x 10-7, and K2 = 5.61 x 10'11. XXX PCU True color measured in the processing laboratory by first centrifuging the sample to remove particles, then using a HACH Model CO-1 Comparator (EPA method 110.2, modified). X Comment from Form ID, first part. X Comment from Form ID, second part. X Comment from Form ID, first part. X Comment from Form ID, second part. X X ,uS/cm Conductivity at 0.6 * site depth (DPSIT1D). XXX ^S/cm Calculated conductance, sum of the products of ion concentration times equivalent conductance. Coded as: CONCA98 = [(CA98*59.47) + (MG98*53.0) +(K98*73.48) + (NA95*50.08) + (NH498*73.5) + (H98*349.65) + (SO498*80.0) + (HCO398*44.5) + (CL98*76.31) + (NO398*71 .42) + (FTL98*55.4) + (CO398*69.3) + (OH*198)J/1000. This calculation converts ^eq/L to f^S/cm. XXX ^S/cm Specific conductance, measured in the analytical laboratory using a conductivity cell (EPA method 120.1). X ^S/cm Conductivity at the mid-hypolimnetic depth. X ^S/cm Conductivity at the mid-metalimnetic depth. X ^S/cm Conductivity at the top-hypolimnetic depth. XXX ^S/cm Conductivity at bottom - 1.5 m. COMNT1DA COMMNT COMNT1DB COMMNT COMNTA1D COMMNT COMNTB1D COMMNT CON601D CON 60 CONCA98 CONCAL COND11 CONMH1D CONMM1D CONTH1D CON BID COND11 36 ------- CRWID1D CRW ID X Lake sampling crew identification number. (Continued) Table 5-1. (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition DATSH02 DATSHP DATSH1D DATSHP DATSMP DATSMP XXX Date samples were shipped from processing laboratories to the analytical laboratories. X Date samples were shipped from processing laboratory to the analytical laboratories. XXX Date lake was sampled. DIC02 DICVAL XXX mg/L Dissolved inorganic carbon, measured in the processing laboratory on a sample drawn directly into a syringe from the Van Dorn water sampler, filtered, and analyzed without exposure to the atmosphere, using a DOHRMANN DC-80 carbon analyzer with infrared spectrophotometric detector (EPA method 415.2, modified). DICE 11 DICE 11 XXX mg/L Air-equilibrated dissolved inorganic carbon, measured in the analytical laboratory in an unfiltered, unacidified aliquot bubbled with 300 ppm CO2, drawn into a syringe, filtered, and atmosphere analyzed without exposure to the (EPA method 415.2 modified, infrared spectro- photometric detector). DICI11 DICI11 X XX mg/L Dissolved inorganic carbon, measured in the analytical laboratory in an unfiltered, unacidified aliquot. The sample was drawn into a syringe, filtered, and analyzed without exposure to the atmosphere (EPA method 415.2 modified, infrared spectrophotometric detector). XXX miles Distance of the lake from the Atlantic Ocean. A calculated variable for lakes within 125 miles from the coastline (otherwise value is missing). Note that the units are in miles. DISM units were incorrectly labeled as km in ELS-I. DOC 11 XXX mg/L Dissolved organic carbon, measured in the analytical laboratory in a filtered, acidified (H2S04) aliquot (EPA method 415.2, infrared spectrophotometric detector). DISM99 DISM DOC 11 37 ------- (Continued) Table 5-1. (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition DOFIA1D DOFIT1D DOINT1D X X X DOMH1D DOMM1D DOTH ID DO_051D DO 15 ID X DO_601D X DO BID X DPCAT1D DP CAT X DPMH1D DPMM1D DPSCB1D DPSCM1D DPSITID SITDPM X DPSITX1D X DPTH1D X X X X X X X X X X X X X X X X X X X X m m m m m m Dissolved oxygen final actual calibration value form ID. Dissolved oxygen final theoretical calibration value form ID. Dissolved oxygen initial theoretical calibration value form ID. Dissolved oxygen at the mid-hypolimnetic depth. Dissolved oxygen at the mid-metalimnetic depth. Dissolved oxygen at the top-hypolimnetic depth. Dissolved oxygen at 0.5 m. Dissolved oxygen at 1.5 m. Dissolved oxygen at 0.6* depth. Dissolved oxygen at bottom - 1.5 m. Lake depth category, 4 (if DPSITID < 20 m) or 5 (if DPSITID > 20m). Mid-hypolimnetic depth. Mid-metalimnetic depth. Depth sample collected at bottom - 1.5 m. Depth sample collected at mid-hypolimnetic depth (m). Sampling site depth, measured using a depth sounder or weighted line. Not necessarily maximum lake depth. Maximum lake depth from ALSC bathymetry. Top hypolimnetic depth. 38 ------- Table 5-1. (Continued) (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition DP 60ID DP 60 DP BID DP B DRPCDE ELEV99 ELEV ELEVX99 FEU FEU FTL11 FTL98 H98 FTL11 FTL16 H16 HCO398 HCO316 X X X X X X X X X X X X X X X X X X X X X X X X X X X X X m Sixty percent of site depth: 0.6 * DPSIT1D. m Depth at which bottom temperature/conductance was measured: DP_B = DPSIT1D - 1.5 m. Drop code variable used to exclude nontarget observations. Coded as: 0=ELS-II target population sample, 1 = non-ELS-I index location (Fall Variability Study), 2=hypolimnion or bottom water sample (summer data), 3=non- ELS-II target lake. Only present in the enhanced (final) seasonal data sets. m Lake elevation, taken from USGS topographic maps (Subregion 1 D values revised from those in ELS-I). m Lake elevation from ALSC data. Mg/L Dissolved iron, measured in the analytical laboratory in a filtered, acidified (HNO3) aliquot (EPA method 236.1, AAS, flame). mg/L Total dissolved fluoride, measured in the analytical laboratory in a filtered, unacidified aliquot, analyzed using an ion-selective electrode (ISE, EPA method 340.2, modified). Total dissolved fluoride: FTL98 = FTL1 1*52.64 Hydrogen ion concentration: coded as H98 = (10**(-PHAC1 1))* 1000000. J.QO/L Bicarbonate, an estimate (Butler, 1982) of: HCO3.= 5.080 x [DICmg/LI x [H+1K, [H+]2 + [H+ ]Kj + KjK2 which is coded as: HCO398 = 61017 * (DICI11/12011) * ALPHA1 * 16.39; where ALPHA1 = ((10**(-PHAC11))*K1)/((10** (-PHAC11))**2 + (10**-PHAC11)*K1+K1* K2); and Kl = 4.3x 10'7' and K2 = 5.61 x io-n. 39 ------- Table 5-1. (Continued) (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition HDEP99 HDEP XXX g/m2 HYDID1D HYD ID X X X HYTYP99 HYDROTYP XXX INOUT99 IN OUT XXX Kll Kll XXX mg/L Average annual wet hydrogen ion deposition, derived from 1980-1982 Acid Deposition System data (Watson and Olsen, 1984). Depo- sition values for lakes were assigned by contouring both the hydrogen ion concentrations measured in precipitation and the precipitation volumes (see PRCIP99), interpolating values for 3.75 minute latitudel/longitude cells, and multiplying these paired cell values. Identification number for the HYDROLAB meter used for field measurements Hydrologic lake type, defined from geographic data. Classes are: CLOSED, DRAINAGE, RESERVOIR, and SEEPAGE Presence and/or absence of inlets and outlets, as determined from topographic maps: I/O = inlets and outlets present; NI/O = no inlets, outlets present; I/NO = inlets present, no outlets; NI/NO no inlets or outlets; RES = reservoir. Dissolved potassium, measured in the analytical laboratory in a filtered, acidified (HNO3) aliquot (EPA method 258.1,AAS, flame). K98 K16 XXX LABNA02 LABNAM XXX LAKE ID LAKE ID X X X Dissolved potassium: K98 = Ki 1*25.57 Name of the analytical laboratory that performed the analytical analyses. Seven-character unique identification code assigned to each lake. The first character represents the region (1, 2, or 3); the second character, the subregion; the third character, the alkalinity map class; a dash; and the last three digits are the assigned lake number. The first three characters also designate the stratum (see STRAT99). (Continued) 40 ------- Table 5-1. (Continued) Variable Phase I Name Name SPS SUS FAS Units Definition LAKNA1D LAKENAME XXX LAT99 LKNAM99 LAT XXX LATDD99 LAT DD X X X dee LKID99 LAKEID1 XXX XXX LKSIZ99 LAKE_SIZ X X X ha LKSIZX99 X X X ha LKVOL99 LAKE VOL XXX 106m3 LKVOLX99 XXX 106m3 LNGDD99 LONG DD X X X deg LONG99 LONG XXX MAPBG99 MAP BIG X X X Lake name taken from USGS topographic maps. When a number of small lakes were identified by only one name on the map, another qualifier was added to the name, such as "southern," to identify the lake. Where no name was listed, "(NO NAME)" was entered into the database as the lake name. Latitude taken from the USGS topographic maps in DD-MM-SS (degrees-minutes-seconds) format. Latitude expressed as degrees and decimal degrees in DD.DDDD format. ELS LAKE_ID cross reference with Adirondack Lake Survey Corporation (ALSC) ponds identification code (else missing). Lake name taken from USGS topographic maps. When a number of small lakes were identified by only one name on the map, another qualifier was added to the name, such as "southern," to identify the lake. Where no name was listed, "(NO NAME)" was entered into the database as the lake name. Lake surface area, measured using an electronic planimeter on USGS topographic maps. Lake surface area from ALSC bathymetry. Estimated lake volume: LKVOLO9 = ((LKSIZ99*10**4)*DPSIT1D*0.464)/10**6. Lake volume from ALSC bathymetry. Longitude expressed as degrees and decimal degrees in DDD.DDDD format. Longitude as read from the USGS topographic maps, in DDD-MM-SS format. Name of the 1:250,000 USGS topographic map on which the lake is located. 42 ------- Table 5-1. (Continued) (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition MAPSM99 MAP SML XXX MG11 MG98 MN11 NA11 NA98 NH411 NH498 NO311 MG11 MG16 MN11 NA11 NA16 NH411 NH416 NO311 XXX mg/L XXX XXX XXX mg/L XXX XXX mg/L XXX XXX mg/L NO398 NO316 XXX Meq/L NO3DP99 NO3DEP XXX g/m2 Name of the 15 minute or 7.5 minute USGS topographic map on which the lake is located. Dissolved magnesium, measured in the analytical laboratory in a filtered, acidified (HNO3) aliquot (EPA method 242.1, AAS, flame). Dissolved magnesium: MG98 = MG1 1*82.26 Dissolved manganese, measured in the analytical laboratory in a filtered, acidified (HNO3) aliquot (EPA method 243.1, AAS, flame). Dissolved sodium, measured in the analytical laboratory in a filtered, acidified (HNO3) aliquot (EPA method 273.1, AAS, flame). Dissolved sodium: NA98 = NA1 1*43.50 Ammonium ion, measured in the analytical laboratory in a sample from the filtered, acidified (H2SO4) aliquot (EPA method 350.1, colorimetric, automated). Ammonium ion: NH498 = NH41 1*55.44 NVLAK1D X Nitrate ion, measured in the analytical laboratory by ion chromatography in a filtered, unacidified aliquot (ASTM, 1984; O'Dell et al., 1984). Nitrate ion: N0398 =N0311*16.13 Meq/mg. Average annual nitrate ion deposition, derived from 1980-1982 Acid Deposition System data (Watson and Olsen, 1984). Lake deposition values were assigned by contouring both the nitrate ion concentrations measured in precipitation and the precipitation volumes (see PRCIP99), interpolating values for 3.75 minute latitude/longitude cells, and multiplying these paired cell values. Non-Fall Variability Study lake ORN). 43 ------- (Continued) Table 5-1. (Continued) Variable Name OB SID ID ORG1O98 Phase I Name ORGION SPS SUS FAS X XXX Units Definition Identification number of the observer. Meq/L Estimate of the organic anion concentration: ORG1O98 = PH0051D PH0151D PH02 PHAC11 PHAC11 PHAL11 PHAL11 PHEQ11 PHEQ11 PHMH1D PHMM1D PHTH1D PH 60ID PH 60 K*CT/(K + (10**(-PHAC11))); where: K= 10**(-Pk); CT = DOC11* 10; and PK = 0.96 + 0.9*PHAC11 - 0.039*PHAC11 **2. X pH pH measurement at 0.5 m. XXX pH pH measurement at 1.5 m. XXX pH pH measured in the processing laboratory on a sample drawn directly into a syringe from the Van Dorn water sampler, analyzed without exposure to the atmosphere. PH02 is the pH variable used to make ELS-II population estimates. XXX pH Initial pH from the acidity titration, measured in the analytical laboratory. A sample from an unfiltered, unacidified aliquot was placed into a CO2 free titration vessel and stirred. The pH was measured with an electrode (without exposure to the atmosphere) before addition of base titrant. XXX pH Initial pH from the alkalinity titration, measured in the analytical laboratory. A sample from the unfiltered, unacidified aliquot was placed into a titration vessel (not CO2 free) and stirred. The pH was measured with an electrode before the first addition of acid titrant. X X X pH Air-equilibrated pH, measured in the analytical laboratory in an unfiltered, unacidified aliquot bubbled with 300 ppm CO2. (EPA method 150.1, electrode). X pH pH at mid-hypolimnetic depth. X pH pH at mid-metalimnetic depth. X pH pH at top-hypolimnetic depth. X X pH pH at 0.6 * DPSIT1D. (Continued) 44 ------- Table 5-1. (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition PH BID PRCIP99 PH B PRECIP used PREC1D PRECO1D PYL1 1 PTL11 RGSPC99 REG SPC RPREC1D X X X pH pHatDPSITID-1.5m. XXX m/yr Annual precipitation. For ELS Region 1, derived from 30-year precipitation norm values (1951-1980) for 500 stations (National Climate Center, NOAA). Values were assigned for each lake by contouring the precipitation volume data and interpolating values for 3.75 minute latitude/longitude cells. Precipitation cell values were to weight the H+, SO42", and NO3 concentrations in precipitation samples. XXX Observed precipitation: none, rain, snow or sleet. X X 'Previous' or 'current' observed precipitation (see PREC1D). XXX Mg/L Total phosphorous, measured in the analytical laboratory in an unfiltered, acidified (H2SO4) aliquot, using either of two automated, colormetric phosphomolybdate methods: for normal phosphorus levels, using a 15-mm absorption cell; for low levels, a preliminary method using 50-mm absorption cell was employed (USGS method 1-4600- 78). XXX Reason for lake being sampled: REGULAR = part of the probability sample. REG/SPC/XXX = part of the probability sample, but also identified as being of special interest. SPC/XXX = of special interest only. The 'XXX' gives the reason for the special interest: XXX codes: LTM = an EPA long-term monitoring lake NRC = suggested by the National Research Council DEW = suggested by the state of New Jersey XXX Rate of observed precipitation: light, moderate, or heavy. (Continued) 45 ------- Table 5-1. (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition RT99 RT X X X yr Estimated hydraulic residence time, defined as years required to replace the volume of the lake. Calculated only or drainage lakes and reservoirs (see HYTYP99). RT99 - LA x site depth RTX99 X RUNIN99 RUNIN X RUNOF99 RUNOFF X RUNOFX99 X SAMBL1D SAMBT1D SAMCD02 SAMCOD X SAMD11D SAMD21D X X X X X X X X X X X X X X X runoff x (WSA - LA) + (precip x LA) where: WSA = watershed area; LA = lake area. Coded as: RT99 = ((LKSIZ99*10**4) * (DPSIT1D*0.464))/(((RUNIN99*2.54* 10**-2) * ((WSHED99*10**4) - (LKSIZ99*10**4))) + ((LKSIZ99*! 0**4)*(PRCIP99))). yr Residence time from ALSC bathymetry. in/yr Surface water runoff interpolated from USGS map. m/yr Surface water runoff interpolated from USGS map (Busby, 1966). RUNOF99 = RUNIN99* 0.025 rn/in. rn/yr Surface water runoff from ALSC data. Identification number for blank sample. Identification number for blank sample at bottom - 1.5 rn. Sample code indicating the type of sample: R = routine sample, D = duplicate sample, TD = processing lab duplicate, B = deionized water blank, S = lab split. First duplicate sample identification number (see SAMJD). Second duplicate sample identification number (see SAMJD). (Continue) 46 ------- Table 5-1. (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition SAMDP1D SAMMH1D SAMRT1D SAMSF1D SAM ID SAM ID X X X X XXX SBRGN99 SUB RON XXX Duplicate sample identification number (see SAM_ID). Sample ID mid-hypolimnetic depth (6H11) Routine sample identification number (see SAM_ID). Sample ID surface -1.5m (6E11) Identifies individual samples within a batch (see BATJD). In combination, BATJD and SAMJD are the unique sample identifiers. Subregions are areas within each region that are similar in water quality, physiography, vegetation, climate, and soil. The ELS-II used a letter A-E concatenated with the region number (All data from ELS region 1) as the subregion identifier. The 5 subregions in the ELS-II were: 1A: Adirondacks IB: Poconos/Catskills 1C: Central New England ID: Southern New England IE: Maine SCBLK1D X X 'Y' or TSf' indicating whether a blank sample was collected. SCD151D SCDBT1D SCDM1 D SCR151D SCRBT1D SCRMH1D X X X X X X X X Duplicate sample collected at 1.5 m form ID. Duplicate sample collected at bottom - 1.5 m. Duplicate sample collected at mid-hypolimnetic depth. Routine sample collected at 1.5 m. Routine sample collected at 1.5 m. Routine sample collected at bottom - 1.5 m. Routine sample collected at mid-hypolimnetic depth. (Continued) 47 ------- Table 5-1. (Continued) Variable Name SECDI1D SECDV1D SECME98 Phase I Name SECDIS SECMEAN SPS X X X SUS FAS X X X X X Units Definition rn Secchi disk disappearance depth. 'Y' indicates Secchi disk was visible to lake bottom. rn Mean of Secchi disk disappearance and reappearance SECRE1D SECREA X SIO211 SITETYP SIO211 X X depths. SECME98 is the lake depth if the disk was visible on the lake bottom. X X rn Secchi disk reappearance depth. X X rng/L Silica, measured in the analytical laboratory in an unfiltered aliquot (USGS method 1-2700-78, colorimetric, molybdate blue, automated method). X X Sampling site or type code. In summer: E= epilimnion (0.5 or 1.5 m depth), H=mid-hypolimnion, BTM=bottom (1.5 m above lake bottom). In fall: Vi first visit Fall Variability Study, V2 = second visit Fall Variability Study (sample taken at ELS-1 location), V3=third visit Fall Variability Study, NV = non-fall variability site (only one fall visit). In spring: value is missing (all samples from epilimnion). SMSTR1D SMTRD SO411 SO498 SO411 SO416 X X SO4DP99 SO4DEP X X Sample identification number for subset triplicate. X Sample identification number for triplicate. X X mg/L Sulfate ion, measured in the analytical laboratory by ion chromatography in a filtered, unacidified aliquot (ASTM, 1984;O'Delletal, 1984). X X Meq/L Sulfate ion: SO498 = SO411*20.82 Meq/mg. X X g/m2 Average annual sulfate ion deposition, derived from 1980-1982 Acid Deposition System data (Watson and Olsen, 1984). Lake deposition values were assigned by contouring both the sulfate ion concentrations (Continued) 48 ------- Table 5-1. (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition measured in precipitation and the precipitation volumes (see PRCIP99), interpolating values for 3.75 minute latitude/longitude cells, and multiplying these paired cell values. XXX Meq/L Sum of base cations: 50BC98 = NA98 + K98 + CA98 + MG98. X X Split code, indicates that duplicate sample aliquots were sent to cooperating analytical laboratories. X Identification number of the individual doing the sampling. XXX State: standard two-character U.S. Postal Service abbreviation. XXX ELS-I sampling strata ID code. ELS region, subregion, and expected alkalinity map class were used as stratification factors in ELS-I. Coded as a concatenation of the ELS subregion (SBRGN99) and alkalinity map class (1, 2, or 3). SOBC98 SOBC SPLCD02 SPLCOD SPRID1D ST99 ST STRAT99 STRAT SUBID1D T0051D T0151D TM0151D T0251D T0351D T04051D TMP_1 T0451D T0551D T06101D TMP_2 T0651D X X X X X X X X X X X °c °c X °C °c °c X °C °c °c X C °c Identification number for the subset batch. Temperature at 0.5 m. Temperature at 1.5 m. Temperature at 1.5 m. Temperature at 2.5 m. Temperature at 3.5 m. Temperature at 4 or 5 Temperature at 4.5 m. Temperature at 5.5 m. Temperature at 6 or 10 Temperature at 6.5 m. 49 ------- Table 5-1. (Continued) Variable Phase I Name Name T0751D T08151D TMP_3 T0851D T0951D T 1020 ID TMP_4 T1051D T 1225 ID TMP_5 T1251D T14301D TMP_6 T1451D T16351D TMP_7 T1651D T 1840 ID TMP_8 T1851D T20451D TMP 9 T2051D T2251D T2451D T2651D T2851D T3051D T3251D T3451D T3651D T3851D SPS SUS FAS X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X Units °c °c °c °c °c °c °c °c °c °c °c °c °c °c °c °c °c °c °c °c °c °c °c °c °c (Continued) Definition Temperature at 7.5 m. Temperature at 8 or 15 rn. Temperature at 8.5 m. Temperature at 9.5 m. Temperature at 10 or 20 m. Temperature at 10.5 m. Temperature at 12 or 25 m. Temperature at 12.5 m. Temperature at 14 or 30 m. Temperature at 14.5 m. Temperature at 16 or 35 m. Temperature at 16.5 m. Temperature at 18 or 40 m. Temperature at 18.5 m. Temperature at 20 or 45 m. Temperature at 20.5 m. Temperature at 22.5 m. Temperature at 24.5 m. Temperature at 26.5 m. Temperature at 28.5 m. Temperature at 30.5 m. Temperature at 32.5 m. Temperature at 34.5 m. Temperature at 36.5 m. Temperature at 38.5 m. (Continued) 50 ------- Table 5-1. (Continued) Variable Phase I Name Name TXX501D TMP 10 TIMRE1D TIMSM1D TMP601D TMP_60 TMPA1D AIRTMP TMPD11D TMPDF TMPD21D TMPDF2 TMPMH1D TMPMM1D TMPTH1D TMP BID TMP B TUR02 TURVAL VISIT ID WALA99 WALA WALAX99 WDIR1D SPS SUS FAS Units Definition X X °C Temperature at 50 m. X Time the processing laboratory received the sample in HH:MM format (24 h), form ID. XXX Time lake was sampled, in HH:MM format (24 h). X X °C Temperature at 0.6 * DPSIT1D. X X X °C Air temperature measured from the helicopter with a thermometer. X X °C Difference between top and bottom temperatures. X X °C Difference between temperature at 0.6* DPSIT1D and bottom, TMPD21D = TMP601D - TMP_B1D. X °C Temperature at mid-hypolimnetic depth. X °C Temperature at mid-metalimnetic depth. X °C Temperature at top-hypolimnetic depth. X X X °C Temperature at DPSIT1D - 1.5m. XXX NTU Turbidity, measured in the processing laboratory using a MONITEK model 2 Inephelometer, reported in nephelometric turbidity units (EPA method 180.1). X X Number of lake visit. XXX Ratio of watershed area to lake area. Watershed area includes lake area. XXX Ratio of watershed area to lake area from ALSC bathymetric data. XXX Estimated wind direction; N, NE, SE, S, SW, W or NW. (Continued) 51 ------- Table 5-1. (Continued) Variable Name Phase I Name SPS SUS FAS Units Definition WSDIS99 WS DIS WSHED99 WSHED WSHEDX99 WSOTH99 WS_OTH WSPD1D WT1M99 WT1O 99 WT2C99 WT2T99 XXX Disturbances of the natural environment in a watershed within 100 m of the shore as noted by field crew, where: D=dwellings, L=logging, R=roads, I = industry, M=mining, S=livestock. X X X ha Watershed area, the geographic area from which surface water drains into a particular lake, as determined using an electronic planimeter on USGS topographic maps. Lake area was included in watershed area. X X X ha Watershed area from ALSC data. XXX Disturbances of the natural environment in a watershed within 100 m of the shore, other than those described by WSDIS99, noted by field crew. XXX Estimated wind speed; no wind, light, moderate, or strong. XXX Modified (final) ELS-I sample weighting factor. Used to make ELS-I population estimates and in ELS-II population variance estimates. XXX Original (at time of ELS-II site selection) ELS-I sample weighting factor. Used in calculating the final ELS-II sample weighting factor and in ELS-II population variance estimates. XXX Conditional ELS-II inclusion weighting factor. Used in calculating the final ELS-II sample weighting factor and in ELS-II population variance estimates. XXX ELS-II sample weighting factor used in making population estimates; calculated as WT2T99= WT1O_99*WT2C99. The weighting factor indicates how many lakes in the ELS-II target population are represented by the sample lake. 52 ------- SECTION 6 DATA TAGS AND FLAGS Some variables in the ELS-I1 databases are designated as "tags" or "flags," that is, they provide information that qualifies individual values. Tags and flags are present only in the validated (DS3B) data set. Tags are one-letter codes that qualify data as recorded on the field or laboratory data forms. Tag variable names have the same name as the variable they qualify, but with the suffix T". For example, the variable MN11 has a tag variable designated MN1 IT. A list of the tag codes and their definitions is given in Table 6-1. Flags are two-character codes that were entered during the data verification and validation processes. Flag variable names have the same name as the variable qualified but with the suffix "F". For example, MN11 has a flag variable designated MN11 F. A list of the flag codes and their definitions is given in Table 6-2. Both tags and flags can contain multiple codes. If a variable has multiple codes, the codes are concatenated (no blank spaces) in alphabetic order. NOTE: With three exceptions, flags and tags in the ELS-II data sets apply only to values BEFORE reverification and the special data assessment. Data values were changed in the reverification process and thus the flags and tags may no longer apply to all of the values in the database. Only the UO and Ul flags (validation outliers), and X flags are completely correct. The old flags and tags have been kept in the database because they may be of some use in interpreting suspect data points. All changes made in the database during the reverification process are documented in Appendix A of the ELS-II QA report (Mitchell-Hall et al, 1989). 53 ------- Table 6-1. Tag Code Definitions, U.S. EPA Eastern Lake Survey - II Code Definition A Instrument unstable. B Redone, first reading not acceptable. C Instruments and sampling gear not vertical in water column. D Slow stabilization. E Sample destroyed during shipment. F Results outside of quality assurance criteria, with consent of the quality assurance manager. G Atypical result; already reanalyzed and confirmed by the laboratory manager. H Holding time exceeded quality assurance criteria; form 19 only. J Results not available; insufficient sample volume shipped to the analytical laboratory from the field. K Results not available; entire aliquot not shipped. L Results not available due to interference. M Results not available; sample lost or destroyed by analytical laboratory. N Not required. P Results outside of quality assurance criteria, but insufficient volume for reanalysis. 0 Results outside of quality assurance criteria. R Results from reanalysis. S Contamination suspected. T Leaking container. U Results not required by procedure; unnecessary. V Anion-cation balance (% ion balance difference) outside criteria due to high DOC. W Percent difference (%D) calculation (Form 14) outside criteria due to high DOC. X Available for miscellaneous comments in the field only. Y Available for miscellaneous comments in the field only. Z Available for miscellaneous comments in the field only. 54 ------- Table 6-2. Flag Code Definitions, U.S. EPA Eastern Lake Survey Phase II Code Definition AO Anion/cation percent ion balance difference was outside of criteria due to unknown cause. Al Anion/cation percent ion balance difference was outside of criteria due to other anion/cation not considered in calculation. A2 Anion/cation percent ion balance difference was outside of criteria due to anion contamination. A3 Anion/cation percent ion balance difference was outside of criteria due to cation contamination. A4 Anion/cation percent ion balance difference was outside of criteria due to unmeasured organic protolytes (fits Oliver Model). AS Anion/cation percent ion balance difference was outside of criteria due to possible analytical error; anion concentration too high. A6 Anion/cation percent ion balance difference was outside of criteria due to possible analytical error; cation concentration too low. A7 Anion/cation percent ion balance difference was outside of criteria due to possible analytical error; anion concentration too low. A8 Anion/cation percent ion balance difference was outside of criteria due to possible analytical error; cation concentration too high. A9 Anion/cation percent ion balance difference was outside of criteria due to possible analytical error; alkalinity measurement. BO External (field) blank was above expected criteria. (For pH, DIG, DOC, specific conductance, ANC, and BNC determinations where the blank was above expected criteria). Bl Internal (laboratory) blank was greater than the criteria for pH, DIG, DOC, and specific conductance. B2 External (field) blank was above expected criteria and contributed more than 20% to sample concentrations. (Flag not used for pH, DIC, DOC, specific conductance, acidity, and alkalinity determinations.) B3 Internal (laboratory) blank was more than twice the required detection limit and contributed more than 10% to the sample concentrations. (Flag not used for pH, DIC, DOC, specific conductance, acidity or alkalinity determinations.) Be Potential negative sample bias based on internal (laboratory) blank data. (Continued) 55 ------- Table 6-2. (Continued) Code Definition B5 Potential negative sample bias based on external (field) blank data. CO Percent conductance difference was outside of criteria due to an unknown cause. C1 Percent conductance difference was outside of criteria due to possible analytical error; anion concentration too high. C2 Percent conductance difference was outside of criteria due to anion contamination. C3 Percent conductance difference was outside of criteria due to cation contamination. C4 Percent conductance difference was outside of criteria due to unmeasured organic anions (fits Oliver Model). C5 Percent conductance difference was outside of criteria due to possible analytical error in conductivity measurement. C6 Percent conductance difference was outside of criteria due to possible analytical error; anion concentration too low. C7 Percent conductance difference was outside of criteria due to unmeasured anions/cations; anions/cations not considered in calculation (does not fit Oliver Model). C8 Percent conductance difference was outside of criteria due to possible analytical error; cation concentration too low. C9 Percent conductance difference was outside of criteria due to possible analytical error; cation concentration too high. Dl External (field) duplicate precision exceeded the maximum expected percent relative standard deviation but either the routine or the duplicate concentration was greater th ten times the required detection limit. D2 External (field) duplicate precision exceeded the system precision (the P95 of a standard normal distribution based on known audit concentrations). D3 Internal (laboratory) duplicate precision exceeded the maximum required percent relative standard deviation, and both the routine and duplicate sample concentrations were greater than ten times the required detection limit. FO Percent conductance difference exceeded criteria when in-situ field conductivity value y substituted. Fl Hillman/Krammer protolyte analysis program indicated field pH problem when streamside pH value was substituted. 56 ------- (Continued) Table 6-2. (Continued) Code Definition F2 Hillman/Kramrner protolyte analysis program indicated unexplained field pH/DIC problem when streamside pH value was substituted. F3 Hillman/Krammer protolyte analysis program indicated field problem; mobile processing laboratory pH. F4 Hillman/Krammer protolyte analysis program indicated field problem; mobile processing laboratory DIC. F5 Hillman/Krammer protolyte analysis program indicated field problem; unexplained (pH/DIC). F6 Percent conductance difference exceeded criteria when mobile processing laboratory conductivity value was substituted. HO The maximum holding time criteria were not met. LI Instrumental detection limit exceeded required detection limit and form 11 sample concentrations were less than ten times the instrumental detection limit. NO Audit sample value exceeded upper control limit. Nl Audit sample value below control limit. N2 Audit sample exceeded control limits due to suspect audit sample preparation. PO Laboratory problem; initial alkalinity pH. P1 Laboratory problem; initial acidity pH. P2 Laboratory problem; unexplained, initial alkalinity/acidity pH. P3 Laboratory problem; initial DIC. P4 Laboratory problem; air equilibrated pH/DIC. P5 Laboratory problem; unexplained, initial pH/DIC. P6 Laboratory problem; alkalinity determination. P7 Laboratory problem; acidity determination. Ql Quality control check sample was above contractual criteria. Q2 Quality control check sample was below contractual criteria. Q3 Insufficient number of quality control check samples were measured. (Continued) 57 ------- Table 6-2. (Continued) Code Definition Q4 No quality control check sample was performed. Q5 Detection limit quality control check sample was not two to three times the contract required detection limit and the measured value was outside twenty percent of the theoretical concentration. UO Known error based on relationships with other variables and/or impossible values or value is missing; substitution was made in Enhanced (Final) data sets. Ul Known error based on relationships with other variables, impossible value, or value is missing; data was deleted from the final data set and was not used in any of the calculations that created the final data set. The data was NOT substituted in the final set because an alternate sample was available (routine or duplicate) or the data was ..needed to make population estimates (summer hypolimnion sample, alternate visit in ti Fall Variability Study, or nontarget lake). VO Data value represents the average from the duplicate and routine measurement of the lake sample. WO Data value has possible measurement error, based on relationships with other variables. XO Invalid but confirmed databased on quality assurance review. These data should not I included in any statistical review. XI ALEX greater than ALTL where ALEX is greater than or equal to 0.015 mg/L and ALEX is greater than ALTL by 0.010 mg/L. X2 Invalid but confirmed data; potential aliquot switch. X3 Invalid but confirmed data; potential gross aliquot or parameter contamination. X4 Invalid but confirmed data; potential sample switch. X8 Suspect or potential aliquot contamination. ZO Original value was less than zero and has been replaced with zero. 58 ------- SECTION 7 REFERENCES Arent, U., M.O. Morison, and C.S. Soong. 1988. Eastern Lake Survey-Phase II, National Stream Survey-Phase 4 Processing Laboratory Operations Report. EPA 600/4-88/025, U.S Environmental Protection Agency, Office of Research and Development, Washington B.C. ASTM. 1984. Annual Book Of ASTM Standards, Vol. 11.01, Standard Test Methods for Anions in Water by Ion Chromatography. American Society for Testing and Materials, Philadelphia, Pennsylvania. Bonoff, M.B., and A.W. Groeger. 1986. National Surface Water Survey, Western Lake Survey—Phase 4 Field Operations Report [internal Report]. Environmental Monitoring Systems Laboratory, U.S. Environmental Protection Agency, Las Vegas, Nevada. Busby, M.W. 1966. "Annual Runoff in the Conterminous United States." In Hydrologic Investigations, Atlas HA-212. Geological Survey, U.S. Department of the Interior, Reston, Virginia. Butler, J.N. 1982. Carbon Dioxide Equilibria and their Applications. Addison-Wesley, Reading, Massachusetts. Cusimano, R.F., J.P. Baker, W.J. Warren-Hicks, V.Lesser, W.W. Taylor, M.C. Fabrizio, D.B. Hayes, and B.P. Baldigo. 1990. Fish Communities in Lakes in Subregion 2B (Upper Peninsula of Michigan) in Relation to Lake Acidity. EPA/600/3-89/021. U.S. Environmental Protection Agency, Washington, D.C. EPA. 1983. Methods for Chemical Analysis of Water and Wastes. EPA/600/4-79/020. U.S. Environmental Protection Agency, Washington, D.C. EPA. 1987. Handbook of Methods for Acid Deposition Studies: Laboratory Analysis for Surface Water Chemistry. EPA/600/4-7/026. U.S. Environmental Protection Agency, Washington, D.C. Herlihy, A.T., D.H. Landers, R.F. Cusimano, W.S. Overton, P.J. Wigington, Jr., A.K. Pollack, and T.E. Mitchell-Hall. 1991. Temporal Variability in Lakewater Chemistry in the Northeastern United States: Results of Phase II of the Eastern Lake Survey. EPA/600/3-91 /012. U.S. Environmental Protection Agency, Washington, D.C. Hillman, D.C.J., J.F. Potter, and S.J. Simon. 1986. National Surface Water Survey, Eastern Lake Survey- Phase I, Analytical Methods Manual. EPA/600/4-88/009. U.S. Environmental Protection Agency, Washington, D.C. Kanciruk, P., M. Gentry., R. McCord, L Hook, J. Eilers, and M. Best. 1986. National Surface Water Survey: Eastern Lake Survey - Phase 1, Database Dictionary. ORNL/TM-10153. Environmental Sciences Division, Oak Ridge National Laboratory, Oak Ridge, Tennessee (Publication 2778). Kanciruk, P., M. Gentry. R. McCord, L Hook, J. Eilers, and M. Best. 1987. National Surface Water Survey'.Western Lake Survey - Phase I, Data Base Dictionary. ORNL/TM-10307. Environmental Sciences Division, Oak Ridge National Laboratory, Oak Ridge, Tennessee (Publication 2838). Kaufmann, P.R., A.T. Herlihy, J.W. Elwood, M.E. Mitch, W.S. Overton, M.J. Sale, J.J. Messer, K.A. Cougan, D.V. Peck, K.H. Reckhow, A.J. Kinney, S.J. Christie, D.D. Bsroawn, C.A. Hagley, and H.I. Jager. 1988. Chemical Characteristics of Streams in the Mid-Atlantic and Southeastern United States. Volume I: Population Descriptions andPhysico-Chemical Relationships. EPA/600/3-88/021 a. U.S. Environmental Protection Agency, Washington, D.C., 397pp. 59 ------- Landers, D.H., J.M. Eilers, D.F. Brakke, W.S. Overton, P.E. Kellar, M.E. Silverstein, R.D. Schnobrod, R.E. Crowe, R.A. Linthurst, J.M. Omernik, S.A. Teague, and E.P. Meier. 1987. Characteristics of Lakes in the Western United States. Volume I. Population Descriptions andPhysico-Chemical Relationships. EPA/600/3-86/054a. U.S. Environmental Protection Agency, Washington, B.C., 176 pp. Linthurst, R.A., D.H. Landers, J.M. Eilers, D.F. Brakke, W.S. Overton, E.P. Meier, and RE Crowe. 1986. Characteristics of Lakes in the Eastern Unfted States. Volume L Population Descriptions and Physico-Chemical Relationships. EPA/600/4-86/007a. U.S. Environmental Protection Agency, Washington, D.C., 136 pp. Kerfoot, H.B., and M.L Faber. 1986. National Surface Water Survey, Western Lake Survey—Phase I, Analytical Methods Manual. EPA/600/8-87/038. U.S. Environmental Protection Agency, Washington, D.C. Kramer, J.R. 1984. Modified Gran Analysis for Acid and Base Tifrations. McMaster University, Hamilton, Ontario, Canada (Environmental Geochemistry Report No. 1984-2). Merritt, G.D., and V.A. Sheppe. 1988. Eastern Lake Survey - Phase II, Field Operations Report. EPA/600/4-88/024. U.S. Environmental Protection Agency, Las Vegas, Nevada. Mitchell-Hall, T.E., A.C. Neale, S.G. Paulsen, and J.E. Pollard. 1989. Eastern Lake Survey - Phase II: Quality Assurance Report. EPA/600/4-89/029. U.S. Environmental Protection Agency, Las Vegas, Nevada. O'Dell, J.W., J.D. Fluff, M.E. Gales, and G.D. McKee. 1984. Technical Additions to: Methods for Chemical Analysis of Water and Wastes. Method 300.0. The Determination of Inorganic in Water by Jon Chromatography. EPA-600/4- .8501 7. U.S. Environmental Protection Agency, Cincinnati, Ohio. Tessier, A.J., and R.J. Horwitz. 1988. Analysis and Interpretation of Zoo plankton Samples Collected During Phase II of the National Lakes Survey. The Academy of Natural Sciences of Philadelpl Report 88-18, Philadelphia, PA. Tessier, A.J., and R.J. Horwitz. 1990. Influence of water chemistry on size structure of zooplankton assemblages. Can. J Fish. Aquat Sci. 47:1937-1943. US DC. 1979. Counties and County Equivalents of the States of the United States and the District of Columbia. FIPS Pub 6-3. U.S. Department of Commerce, Bureau of Standards, Washington, D.C. Watson, C.R., and A.R. Olsen. 1984. Acid Deposition System (ADS) for Statistical Analysis Report: System Design and User Code Manual. EPA-600/8-84-023. U.S. Environmental Protection Agency, Research Triangle Park, North Carolina. 60 ------- APPENDIX A ANCILLARY ELS-II DATA SETS Other information was collected as part of ELS-II activities in addition to the data in the three seasonal ELS-II data sets described in the main body of this report. These data, found in the following data tiles, include zooplankton species abundance, chlorophyll concentrations, and bathymetry. File Name Contents n Number of Variables BATHYM Bathymetric data 129 14 SUSZOOP Summer 1986 Zooplankton data 491 144 SUSCHLA Summer 1986 Chlorophyll data 221 26 These data sets are discussed in detail in the following subsections. A.I BATHYMETRIC DATA A detailed bathymetric survey was conducted on 126 of the 145 ELS-II target lakes and 3 special- interest lakes. Transects were made across the lake and depths were recorded using a Lowrance X-15A depth chart recorder. Lake outlines were scaled up from 7.5 minute USGS maps using a zoom transfer scope. From these depth tracings and map outlines, a bathymetric map was constructed for each lake. These bathymetric maps were then used to quantify the variables in data set BATHYM given in Table A-l. Field surveys were performed by the Adirondack Lake Survey Corporation (ALSC) and SUNY Oswego. Data reduction was done by the ALSC. Note that some of these variables (surface area, watershed area, residence time) are present in the seasonal chemistry data sets based on map measurement during ELS-1. The variables in the BATHYM data set represent more detailed measurements made during the ELS-II bathymetric analyses. A.2 SUMMER ZOOPLANKTON DATA As part of the summer ELS-II data collection effort, zooplankton species abundance was analyzed at the index location in the deepest part of the lake. Three zooplankton tows were collected from this location using an 80-^m mesh Wisconsin bucket net, pulled vertically from 1 m above the lake bottom to the lake surface at a constant rate. These samples were preserved in a jar with buffered, sugar formalin and analyzed at the Academy of Natural Sciences of Philadelphia. Each jar was first examined for taxonomic composition to generate a comprehensive species list for each lake. Total abundance was determined on the entire jar if overall densities were less than 300 individuals. Otherwise, the counts were made from subsamples from the jar using a funnel splitter. In about 15% of the samples, replicate splits were counted. 61 ------- Details of the analyses and data interpretation can be found in Tessier and Horwitz (1988,1990). The data file with these data (SUSZOOP) contains the following variables: Variable Name Definition LAKE_ID Lake identification code JARID A two-digit code identifying the sample. The first digit (1, 2, or 3) identifies the tow number. The second digit (0 or 1) indicates the sample replicate number (some samples were counted twice). Rdxxxx Abundance of species xxxx in number of individuals per meter of net tow. In cases where the species was identified in the initial taxonomic examination but was not abundant enough to be counted after subsampling, the abundance was arbitrarily set to 0.01 individuals/meter tow. The zooplankton species names associated with each four-digit code number (xxxx) are given in Table A-2 and Appendix VI of Tessier and Horwitz (1988). There are 142 species represented by RDxxxx variables in file SUSZOOP. A.3 CHLOROPHYLL DATA As part of the summer seasonal sampling, samples were collected for chlorophyll analysis. Water from the epilimnion taken from the same Van Dorn sample as the ELS-II water chemistry sample was filtered through a 0.8-pm pore size polycarbonate filter. The filter was placed in an opaque centrifuge tube and transported frozen to the analysis laboratory. The filter was analyzed for chlorophyll-a, chlorophyll-b, and degradation products by spectrophotometry, fluorometry, and HPLC. The analytical methodology is described in Section 12 of the EPA Acidic Deposition Analytical Methods Manual (EPA, 1987). Variable listing and definitions for the SUSCHLA data set are given in Table A-3. Note that this data has been verified but not validated or enhanced. 62 ------- Table A-l. Listing and Definition of Variables in ELS-II Data Set BATHYM Variable Name Definition FRATE LAKE ID LAT DD LITTAREA LONG DD MAXDPM MEANDPM RUNOFF SAREA SHORLN SHRDEV VOLDV VOLUME WAREA Flushing rate in years, calculated as (watershed area*runoff)/lake volume. ELS Lake identification code. Latitude in decimal degrees. Littoral zone area in hectares, defined as the area of the lake with water less than 10 feet deep. Longitude in decimal degrees. Maximum lake depth in meters. Mean lake depth in meters, calculated as lake volume/lake area. Mean annual runoff in cm/yr. Lake surface area in ha, measured by planimetry. Shoreline length in kilometers, calculated by summing the distances between the x,y coordinate pairs along the shoreline contour. Index of shoreline development, calculated as, shoreline length / (2(:n;*lake area)05). This is Indicative of the deviation of the lake shoreline from a perfect circle (SHRDEV- 1 for a perfect circle). Lake volume development, calculated as 3*mean depth/max depth. This is indicative of the deviation of the lake volume from an inverted cone (VOLDV= 1 for a perfect inverted cone). Lake volume in 106 cubic meters Watershed Area in hectares, measured by planimetry. 63 ------- Table A-2. Species Code Numbers for Zooplankton Data in ELS-II Data Set SUSZOOP Species Code Species Name ROTIFERA 1000 Keratella earlinae 1001 K. chochlearis hispida 1002 Keratella crassa 1003 Keratella taurocephala 1004 K. cochlearis-cochlearis 1005 Keratella hieratis 1006 Keratella irregularis 1007 Keratella ticinersis 1008 Keratella c. robusta 1009 Keratella serrulata 1010 Kellicottia longispina 1011 Kellicottia bostoniensis 1030 Notholca labis 1031 Notholca squemula 1040 Brachionus urceolaris 1041 Brachionus quadridentatus 1050 Euchlanis dilatata 1051 Euchlanis petlucida 1060 Platyias petulus 1070 Mytilina spp. 1101 Lecane luna 1102 Lecane flexilis 1103 Lecane mira 1104 Lecane tudicola 1105 Lecane ungulata 1110 Monostyla lunaris 1400 Trichocerca multicrinis 1401 Trichocerca cylindrica 1402 Trichocerca pusillainis 1403 Trichocerca porcellus 1404 Trichocerca similis 1405 Trichocerca rousseleti 1406 Trichocerca lata 1407 Trichocerca elongata 1500 Gastropus hyptopus 1501 Gastropus sfylifer 1510 Ascomorpha ovalis 1511 Ascomorpha saltans 1512 Ascomorpha ecaudis 1800 Asplanchna priodonta 1809 Asptanchna sp. 1900 Polyarthra vulgaris 1901 Polyarthra euryptera 1902 Polyarthra remata 1903 Polyarthra major 1904 Polyarthra dolichoptera (Continued) Table A-2. (Continued) Species Code Species Name 1910 Synchaeta pectinata 64 ------- 1911 Synchaeta kitti 1912 Synchaeta oblonga 1921 Ploesoma truncatum 1922 Ploesoma lenticularie 1923 Ploesoma hudsoni 1924 Ploesoma triacanthum 2100 Filinasp. 2101 Filinia terminalis 2102 Filinia longiseta 2200 Hexarthra mira 2300 Conochilus unicornis 2301 Conochilus hippocrepis 2310 Conochiloides dossarius 2311 Conochiloides natans 3100 Colfotheca pelagica 3101 Collotheca mutabilis 3300 Unidentified rotifera CLADOCORA 4100 Leptodora kindtii 5101 Diaphanosoma birgei 5102 Diaphanosoma brachyurum 5110 Sida crystallina 5201 Holopedium gibberum 5301 Bosmina longirostris 5310 Eubosmina hegmanni 5311 Eubosmina tubican 5312 Eubosmina longispina 5501 Chydorus brevalibris 5502 Chydorus sphaericus 5509 Chydorus sp. 5510 Alona setulosa 5511 Alona guttata 5512 Alona circumfimbrata 5513 Alona barbula 5519 Alona sp. 5520 Alonella acutirostris 5530 Kurzia laissium 5540 Acroperus harpae 5550 Eurycercus lamellatus 5560 Graptoleberis testudinaria 5600 Polyphemus pediculum 5701 Daphnia catawba 5702 Daphnia galeata mandotae 5703 Daphnia rosea 5704 Daphnia ambigua (Continued) 65 ------- Table A-2. (Continued) Species Code Species Name 5705 Daphniapulex 5706 Daphnia parvula 5707 Daphnia schodleri 5708 Daphnia retrocurva 5709 Daphnia longiremis 5710 Daphnia dubia 5801 Scapholeberis mucronata 5802 Ceriodaphnia reticulata 5803 Ceriodaphnia lacustris 804 C. aftinia dubia 5805 Ceriodaphnia quadrangula 5809 Ceriodaphnia sp. COPEPODA 6300 Epischura lacustris 6301 Epischura nordenskioldi 6309 Epischura sp. 6401 Aglaodiaptomus Jeptopus 6402 A. spatulocrenatus 6411 Leptodiaptomus minutus 6412 Leptodiaptomus sicilis 6421 S. oregonensis 6422 Skistodiaptomus reighardi 6423 Skistodiaptomus pygmasus 6429 Skistodiaptomus sp. 6431 Onychodiaptomus birgei 6500 Unknown sp. calanoida 7100 Tropocyclops sp. 1 7101 Mesocyclops edax 7110 Tropocyclops sp. 2 7111 T. prasinus - mexicanus 7112 Tropocyclops prasinus 7121 Cyclops scutiger 7122 Cyclops sternus strenuus 7123 Cyclops vernalis 7124 C. bicuspidatus thomasi 7129 Cyclops sp. 7131 Orthocyclops modestus 7141 Eucyclops speratus 7142 Eucy clops agilus 7143 Eucy clops prionophonis 7144 Ectocyclops phaleratus 7160 Macrocyclops albidus 7200 Unknown sp. cyclopoida 7500 Ergasilus chautauquansis 8000 Nauplii (Continued) Table A-2. (Continued) Species Code Species Name 66 ------- MISCELLANEOUS 9100 Chaoborus punctipennis 9101 Chaoborus americanus 9102 Chaoborus flavicans 9199 Chaoborus sp. 9200 Mites 1 9201 Mites 2 9300 Ostracoda 67 ------- Table A-3. Listing and Definition of Variables in ELS-II Data Set SUSCHLA Variable Name Definition BATCH ID CHLA AC CHLA AR CHLA HC CHLA HT CHLB AR CHLB HT DAT ANAL DG AR DG HT FLU CHL FLU OIL FLU_SCL FLU STD FLU VAL LAKE ID SAM ID SAM_TYPE SAM VOL SQL VOL SPCCHLA SPC_CHLB SPECFILE SPEC_650 SPEC_665 SPEC 700 Batch identification code. Chlorophyll-a concentration based on HPLC peak area («g/L). HPLC chlornphyll-a peak area. Chlorophyll-a concentration based on HPLC peak height (wg/L). HPLC chlorophyll-a peak height. Chlorophyll-/? HPLC peak area. Chlorophyll-/? HPLC peak height. Date analyzed. Degradation products peak area. Degradation products peak height. Chlorophyll-a concentration from fluorometry (wg/L). Dilution factor for fluorometry measurement. Fluorometer scale. Fluorescence standard (measured). Fluorescence value. ELS-II Lake identification code. Sample identification code. Sample type (A = audit, R = routine lakewater sample, D = duplicate, T = triplicate) "L" code indicates a laboratory duplicate or triplicate. Sample volume (mL) Solvent volume (mL). Chlorophyll-a concentration from spectrophotometry (wg/L). Chlorophyll-/? concentration from spectrophotometry (w/L). Spectrophotometry file number. Spectrophotometry absorbance at 650 nm. Spectrophotometry absorbance at 665 nm. Spectrophotometry absorbance at 700 nm. 68 ------- APPENDIX B ASCII VERSIONS OF ELS-II DATA SETS The enhanced versions of the three seasonal chemistry data sets (SPSFIM01, SUSFIM01, and FASFIMOI) and the three auxiliary data sets (BATHYM, SUSZOOP, and SUSCHLA) are available as ASCII data sets. ASCII data are provided as 80-column card-image files. Card image format definitions for these six ASCII data sets are given in Tables B- 1 through B6. For all data lines, columns 79-80 contain the card number. Variable widths were transferred to the card image files using the formats in the SAS data sets. Dates are in DDMMMYY format and times are in HH:MM (24-hour clock) for all ASCII data sets. Missing numeric variables are represented as -999. These values should be removed prior to any data analysis. An example card image listing from Data File FASFIMOI .DAT is shown in Table B-7. All ASCII data sets have the same name as the equivalent SAS data set, but with a .DAT extension. 69 ------- Table B-l. Card-Image Format Definition, ELS-II Data Set SPSFIM01 Card # 2 2 2 2 2 2 2 2 3 o J o J 3 o J 3 3 o J 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6 Variable Name ACCO1 1 ALD02 ALDI98 ALEX11 ALKA11 ALO 02 ALTL11 ANCAT98 ANDEF98 ANSUM98 BNSTR99 C0151D C04051D C06101D C08151D C10201D C12251D C1430ID C16351D C18401D C20451D CA11 CA98 CAT8U98 CL11 CL98 CLSTR99 CNTY99 CO398 COLOR02 CON601D COND11 CON BID CXX501D DATSMP DIC02 DICE 11 DICI11 DISM99 DOC 11 DO 151D DO 60 ID DO BID DPCAT1D DPSIT1D DPSITX1D DP 601D DP BID Var. Type Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Char Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Format 8.1 8.4 8.4 8.4 8.1 8.4 8.4 6.4 8.4 8.4 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.3 8.4 8.4 8.3 8.4 8.0 5.0 8.4 8.0 8.0 8.1 8.0 8.0 7.0 8.3 8.3 8.3 8.0 8.2 8.2 8.2 8.2 8.1 8.0 8.1 8.1 8.1 Start Col. 1 10 20 30 40 50 60 70 1 10 20 30 40 50 80 70 1 10 20 30 40 50 60 70 1 10 20 30 36 48 56 66 1 10 20 29 39 49 59 69 1 10 20 30 40 50 60 70 End Col. 8 18 28 38 48 58 68 78 8 18 28 38 48 58 68 78 8 18 28 38 48 58 68 78 8 18 28 34 44 54 64 74 8 18 27 37 47 57 87 77 8 18 28 38 48 58 88 78 Label # CO2-ACIDITY (UEQ/L) FORM 11 PCV ALUMINUM DISSOLVED (UG/L) FORM 2 LABILE MONOMERIC AL (UG/L) ALUMINUM-EXTRACT ABLE (UG/L) FORM 11 ALKAUNITY (UEQ/L) FORM 11 PCV ALUMINUM ORGANIC (UG/L) FORM 2 TOTAL ALUMINUM (UG/L) FQRM 11 CATIONS/ANIONS RATIO CATSUM-ANSUM (UEQ/L) SUM OF ANIONS (UEQ/L) POPULATION SIZE BY STRATA CONDUCTIVITY (US/CM) AT 1.5M FORM ID CONDUCTIVITY AT 4 OR 5 M (US/CM) FORM ID CONDUCTIVITY AT 6 OR 1OM (US/CM) FORM ID CONDUCTIVITY AT 8 OR 1.5M (US/CM) FORM ID CONDUCTIVITY AT 10 OR 20M (USICM) FORM ID CONDUCTIVITY AT 12 OR 25M (US/CM) FORM ID CONDUCTIVITY AT 14 OR 30M (US/CM) FORM ID CONDUCTIVITY AT 16 OR 35M (US/CM) FORM ID CONDUCTIVITY AT 18 OR 40M (US/CM) FORM ID CONDUCTIVITY AT 20 OR 45M (US/CM) FORM ID CALCIUM (MG/L) FORM 11 CALCIUM (UEQ/L) SUM OF CATIONS (UEQ/L) CHLORIDE ION (MG/L) FORM 11 CHLORIDE (UEQ/L) PHASE II CLUSTER (1,2 or 3) FIPS CODE(ST,COUNTY) CARBONATE ALKAUNITY (UEQ/L) COLOR (PCU) FORM 2 CONDUCTIVITY AT 0.6*DEPTH(US/CM) FORM ID CONDUCTIVITY (US/CM) FORM 11 CONDUCT AT BOTTM-1.5M (US/CM) FORM ID CONDUCTIVITY AT 50 M (US/CM) FORM ID DATE SAMPLED DIC (MG/L) FORM 2 DIC-EQUIL (MG/L) FORM 11 DIC-INIT (MG/L) FORM 11 DISTANCE FROM COAST (MILES) DOC (MG/L) FORM 11 DISSOLVED OXYGEN (MG/L) 1.5M FORM ID DISSOLVED OXYGEN AT 0.6*DEPTH FORM ID DIS OXYGEN (MG/L) BOTTOM-1.5M FORM ID DEPTH CATEGORY 4= <20M 5=>20M FORM ID SITE DEPTH (M) FORM ID MAXIMUM LAKE DEPTH (M) - ALSC DEPTH 0.6*BOTTOM (M) FORM ID DEPTH AT BOTTOM-1.5M (M) FORM ID Card 1 2 2 2 2 2 2 2 2 3 o J o J 3 o J 3 3 o J 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6 70 ------- Table B-l. (Continued) Card # 7 7 7 7 7 7 7 7 8 8 8 8 8 8 9 9 9 9 9 10 10 10 10 10 11 11 11 12 12 12 12 13 13 13 13 13 13 13 13 14 14 14 14 14 14 14 14 Variable Name DRPCDE ELEV99 ELEVX99 FEU FTL11 FTL98 H98 HCO398 HDEP99 HYDID1D HYTYP99 INOUT99 Kll K98 LABNA02 LAKE ID LAT99" LATDD99 LKID99 LKNAM99 LKSIZ99 LKSIZX99 LKVOL99 LKVOLX99 LNGDD99 LONG99 MAPBG99 MAPSM99 MG11 MG98 MN11 NA11 NA98 NH411 NH498 NO311 NO398 NO3DDP99 ORGIO98 PH0151D PH02 PHAC11 PHAL11 PHEQ11 PH601D PH BID PRCI99 Var. Type Num Num Num Num Num Num Num Num Num Char Char Char Num Num Char Char Char Num Char Char Num Num Num Num Num Char Char Char Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Format 8.0 8.1 8.1 8.3 8.4 8.4 8.4 8.4 8.3 4.0 9.0 8.0 8.3 8.4 30.0 7.0 10.0 8.4 7.0 30.0 8.2 8.2 8.3 8.3 8.4 11.0 25.0 40.0 8.3 8.4 8.3 8.3 8.4 8.3 8.4 8.4 8.4 8.2 8.4 8.2 8.2 8.2 8.2 8.2 8.2 8.2 8.3 Start Col. 1 10 20 30 40 50 80 10 1 10 15 25 32 42 1 33 41 52 62 1 33 43 53 83 1 10 22 1 43 53 83 1 10 20 30 40 50 80 70 1 10 20 30 40 50 80 70 End Col. 8 18 28 38 48 58 68 78 8 13 23 30 40 50 31 39 50 80 68 31 41 51 61 71 8 20 48 41 51 61 71 8 18 28 38 48 58 68 78 8 18 28 38 48 58 68 78 Label Drop code for population estimates LAKE ELEVATION (M) LAKE ELEVATION (M) - ALSC IRON (UGIL) FORM 1 1 FLUORIDE (MG/L) FORM 1 1 FLUORIDE (UEQ/L) HYDROGEN FROM PHAC1 1 (UEQ/L) HCO3 (UEQ/L) HYDROGEN ION DEPOSITION (G/M**2/YR) HYDROLAB METER IDENTIFIER CODE FORM HYDROLOGIC TYPE PRESENSE/ABSENCE OF INLETS/OUTLETS POTASSIUM (MG/L) FORM 1 1 POTASSIUM (UEQ/L) LABORATORY FOR ANALYSIS FORM 2 LAKE IDENTIFICATION NUMBER ATITUDE LATITUDE (DECIMAL DEGREES) ERLD-UMD ID/ALSC WSHED-POND ID LAKE NAME LAKE SURFACE AREA (HA) LAKE SURFACE AREA (HA) - ALSC CALC LAKE VOL (1 0**6 CU M) DIG. LAKE VOL (10** 6 CU M) -ALSC LONGITUDE (DECIMAL DEGREES) LONGITUDE MAP SHEET NAME (1:250,000 SCALE) MAP SHEET NAME, 15 OR 7.5 QUAD MAGNESIUM (MG/L) FORM 1 1 MAGNESIUM (UEQ/L) MANGANESE (UG/L) FORM 1 1 SODIUM (MG/L) FORM 1 1 SODIUM (UEQ/L) AMMONIUM ION (MG/L) FORM 1 1 AMMONIUM (UEQ/L) NITRATE ION (MG/L) FORM 1 1 NITRATE (UEQ/L) NITRATE DEPOSITION (G/M**2~R) ORGANIC ANION (UEQ/L) PHAT1.5MFORM ID STATION PH FORM 2 ACIDITY IN-AL PH FORM 1 1 ALKAUNITY INITIAL PH FORM 1 1 AIR-EQUILIBRATED PH FORM 1 1 PH AT 0.6*DEPTH FORM ID PH AT BOTTOM-1.5M FORM ID PRECIPITATION (M/YR) Card # 7 7 7 7 7 7 7 7 8 ID 8 8 8 8 8 9 9 9 9 9 10 10 10 10 10 11 11 11 12 12 12 12 13 13 13 13 13 13 13 13 14 14 14 14 14 14 14 14 71 ------- Table B-l. (Continued) Card # 15 15 15 15 15 15 15 16 16 16 16 16 16 16 16 17 17 17 17 17 17 17 17 17 17 18 18 18 18 18 18 18 18 19 19 19 19 19 19 19 20 20 20 20 20 20 20 21 21 21 21 21 21 Variable Name PREC1D PTL11 RGSPC99 RPREC1D RT99 RTX99 RUNIN99 RUNOF99 RUNOFX99 SBRGN99 SECDI1D SECME98 SECRE1D SIO211 SITETYP SO411 SO498 SO4DP99 SOBC98 SPLCD02 ST99 STRAT99 T04051D T06101D T08151D T10201D T12251D T14301D T16351D T18401D T20451D TIMSM1D TM0151D TMP601D TMPA1D TMPD11D TMPD21D TMP BID TUR02 TXX501D VISIT1D WALA99 WALAX99 WDIR1D WSDIS99 WSHED99 WSHEDX99 WSOTH99 WSPD1D WT1M99 WT1O 99 WT2C99 WT2T99 Var. Type Char Num Char Char Num Num Num Num Num Char Num Num Num Num Char Num Num Num Num Char Char Char Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Char Num Num Char Char Num Num Char Char Num Num Num Num Format 5.0 8.4 16.0 8.0 8.3 8.3 8.0 8.3 8.3 1.0 8.1 8.1 8.1 8.3 9.0 8.3 8.4 8.2 8.4 1.0 2.0 3.0 8.1 8.1 8.1 8.1 8.1 8.1 8.1 8.1 8.1 5.0 8.1 8.1 8.0 8.1 8.1 8.1 8.2 8.1 12.0 8.2 8.2 3.0 8.0 8.3 8.3 25.0 8.0 8.3 8.3 8.4 8.3 Start Col. 1 8 18 35 44 54 64 1 10 20 22 32 42 52 62 1 10 20 30 40 42 45 49 59 69 1 10 20 30 40 50 80 67 1 10 20 30 40 50 60 1 15 25 35 39 48 58 1 28 37 47 57 67 End Col. 6 16 33 42 52 62 72 8 18 20 30 40 50 80 70 8 18 28 38 40 43 47 57 67 77 8 18 28 38 48 58 65 75 8 18 28 38 48 58 68 13 23 33 37 46 56 66 26 35 45 55 65 75 Label PRECIPITATION FORM ID TOTAL PHOSPHORUS (UG/L) FORM 11 REG SPEC LTM NRC DEW DER SAMPLE CLASS RATE OF PRECIPITATION FORM ID RESIDENCE TIME (YR) RESIDENCE TIME (YR) - ALSC ANNUAL RUNOFF INCHES FROM DIGIT MAP SURFACE WATER RUNOFF (M/YR) SURFACE WATER RUNOFF (M/YR) - ALSC NSWS SUBREGION SECCHI DEPTH: DISAPPEAR (M) FORM ID MEAN: SECCHI DISK DISAPPEAR, REAPPEAR (M) SECCHI DEPTH: REAPPEAR (M) FORM ID SILICA (MG/L) FORM 1 1 SAMPLING SITE OR TYPE CODE SULFATE ION (MG/L) FORM 11 SULFATE (UEQ/L) SULFATE DEPOSITION (G/M**2/YR) SUM OF BASE CATIONS (UEQ/L) SPLIT/SAMPLE CODE TO LAS VEGAS FORM 2 STATE (TWO-LETTER ABBREV) NSWS STRATA TEMPERATURE AT 4 OR 5 M (DEC C) FORM ID TEMPERATURE AT 6 OR 10 M (DEC C) FORM ID TEMPERATURE AT 8 OR 15 M (DEC C) FORM ID TEMPERATURE AT 10 OR 20M (DEC C) FORM ID TEMPERATURE AT 12 OR 25M (DEC C) FORM ID TEMPERATURE AT 14 OR 30M (DEC C) FORM ID TEMPERATURE AT 16 OR 35M (DEC C) FORM ID TEMPERATURE AT 18 OR 40M (DEC C) FORM ID TEMPERATURE AT 20 OR 45M (DEC C) FORM ID TIME SAMPLED (24 H) HH:MM FORM ID TEMPERATURE (DEC C) AT 1.5M FORM ID TEMPERATURE AT 0.6*DEPTH (DEC C) FORM ID AIR TEMPERATURE (DEC G) FORM ID TEMP DIF 1.5M-BOTTOM (DEC C) FORM ID TEMP DIF 1.5M-0.6*DEPTH (DEC C) FORM ID TEMP AT BOTTOM- 1.5M (DEC C) FORM ID TURBIDITY (MTU) FORM 2 TEMPERATURE AT 50 M (DEC C) FORM ID VISIT FORM ID WATERSHED AREA/LAKE AREA WATERSHED AREA/LAKE AREA - ALSC ESTIMATED WIND DIRECTION FORM ID D)WELL I)ND L)OG M)INE R)OAD S)TOCK WATERSHED AREA (HA) WATERSHED AREA (HA) - ALSC DISTURB W/1 1OOM - OTHER ESTIMATED WIND SPEED FORM ID MODIFIED PHASE I WEIGHT ORIGINAL PHASE I WEIGHT CONDITIONAL PHASE II WEIGHT TOTAL PHASE II WEIGHT Card # 15 15 15 15 15 15 15 16 16 16 16 16 16 16 16 17 17 17 17 17 17 17 17 17 17 18 18 18 18 18 18 18 18 19 19 19 19 19 19 19 20 20 20 20 20 20 20 21 21 21 21 21 21 72 ------- Table B-2. Card-Image Format Definition, ELS-II Data Set SUSFIM01 Card # 2 2 2 2 2 2 2 2 3 o J 3 o J o J 3 o J 3 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6 7 7 7 7 7 7 7 Variable Name ACCES1D ACCO11 ALD02 ALDI98 ALEX11 ALKA11 ALO 02 ALTL11 ANCAT98 ANDEF98 ANSUM98 BNSTR99 COOS ID C0151D C0251D C0351D C0451D C0551D C0651D C0751D C0851D C0951D C1051D C1251D C1451D C1651D C1851D C205ID C2251D C2451D C2651D C2851D C3051D C3251D C3451D C3651D C3851D CA11 CA98 CATSU98 CHLOD1D CHLOR1D CL11 CL98 CLSTR99 CNTY99 COS 98 COLOR02 COND11 CONMH1D CONMM1D CONTH1D CON BID CRWID1D DATSMP Var. Type Char Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Char Num Num Num Num Num Num Num Char Num Formal 3.0 8.1 8.4 8.4 8.4 8.1 8.4 8.4 8.4 8.4 8.4 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.3 8.4 8.4 8.1 8.1 8.3 8.4 8.0 5.0 8.4 8.0 8.1 8.0 8.0 8.0 8.0 20.0 7.0 Start Col. 1 6 16 26 36 46 56 66 1 10 20 30 40 50 80 70 1 10 20 30 40 50 60 70 1 10 20 30 40 50 80 70 1 10 20 30 40 50 80 70 1 10 20 30 40 50 58 66 1 10 20 30 40 50 71 End Col. 4 14 24 34 44 54 64 74 8 18 28 38 48 58 68 78 8 18 28 38 48 58 68 78 8 18 28 38 48 58 68 78 8 18 28 38 48 58 68 78 8 18 28 38 48 54 64 74 8 18 28 38 48 69 78 Label ACCESS FORM ID CO2-ACIDITY (UEQ/L) FORM 11 PCV ALUMINUM DISSOLVED (UG/L) FORM 2 LABILE MONOMERIC AL (UG/L) ALUMINUM-EXTRACT ABLE (UG/L) FORM 11 ALKAUNITY (UEQ/L) FORM 11 PCV ALUMINUM ORGANIC (UG/L) FORM 2 TOTAL ALUMINUM (UG/L) FORM 11 CATIONS/ANIONS RATIO CATSUM - ANSUM (UEQ/L) SUM OF ANIONS (UEQ/L) POPULATION SIZE BY STRATA CONDUCTIVITY AT 0.5 M (US/CM) FORM ID CONDUCTIVITY AT 1.5 M (US/CM) FORM ID CONDUCTIVITY AT 2.5 M (US/CM) FORM ID CONDUCTIVITY AT 3.5 M (US/CM) FORM ID CONDUCTIVITY AT 4.5 M (US/CM) FORM ID CONDUCTIVITY AT 5.5 M (US/CM) FORM ID CONDUCTIVITY AT 6.5 M (US/CM) FORM ID CONDUCTIVITY AT 7.5 M (US/CM) FORM ID CONDUCTIVITY AT 8.5 M (US/CM) FORM ID CONDUCTIVITY AT 9.5 M (US/CM) FORM ID CONDUCTIVITY AT 10.5 M (US/CM) FORM ID CONDUCTIVITY AT 12.5 M (US/CM) FORM ID CONDUCTIVITY AT 14.5 M (US/CM) FORM ID CONDUCTIVITY AT 16.5 M (US/CM) FORM ID CONDUCTIVITY AT 18.5 M (US/CM) FORM ID CONDUCTIVITY AT 20.5 M (US/CM) FORM ID CONDUCTIVITY AT 22.5 M (US/CM) FORM ID CONDUCTIVITY AT 24.5 M (US/CM) FORM ID CONDUCTIVITY AT 26.5 M (US/CM) FORM ID CONDUCTIVITY AT 28.5 M (US/CM) FORM ID CONDUCTIVITY AT 30.5 M (US/CM) FORM ID CONDUCTIVITY AT 32.5 M (US/CM) FORM ID CONDUCTIVITY AT 34.5 M (US/CM) FORM ID CONDUCTIVITY AT 38.5 M (US/CM) FORM ID CONDUCTIVITY AT 38.5 M (US/CM) FORM ID CALCIUM (MG/L) FORM 11 CALCIUM (UEQ/L) SUM OF CATIONS (UEQ/L) CHLOROPHYLL VOLUME H20 D (ML) FORM ID CHLOROPHYLL VOLUME H20 R (ML) FORM ID CHLORIDE ION (MG/L) FORM 11 CHLORIDE (UEQ/L) PHASE II CLUSTER (1,2 or 3) FIPS CODE(ST,COUNTY) CARBONATE ALKAUNITY (UEQ/L) COLOR (PCU) FORM 2 CONDUCTIVITY (US/CM) FORM 11 CONDUCTIVITY AT MID-HYP (US/CM) FORM ID CONDUCTIVITY AT MID-MET (US/CM) FORM ID CONDUCTIVITY AT TOP-HYP (US/CM) FORM ID CONDUCTIVITY AT BTM-1 .5M (US/CM) FORM ID FIELD CREW ID FORM ID DATE SAMPLED Card # 2 2 2 2 2 2 2 2 3 o J 3 o J o J 3 o J 3 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6 7 7 7 7 7 7 7 73 ------- Table B-2. (Continued) Card # 8 8 8 8 8 8 8 8 9 9 9 9 9 9 9 9 10 10 10 10 10 10 10 11 11 11 11 11 11 11 11 12 12 12 12 12 13 13 13 13 13 14 14 14 14 14 15 15 15 15 Variable Name DIC02 DICE 11 DICI11 DISM99 DOC 11 DOMH1D DOMMID DOTH ID DO 05 ID DO 151D DO~B1D DPMH1D DPMM1D DPSCB1D DPSCM1D DPSIT1D DPSITX1D DPTH1D DP BID DRPCDE ELEV99 ELEVX99 FEU FTL11 FTL98 H98 HCO398 HDEP99 HYDID1D HYTYP99 INOUT99 Kll K98 LABNA02 LAKE ID LAT99" LATDD99 LKID99 LKNAM99 LKSIZ99 LKS1ZX99 LKVOL99 LKVOLX99 LNGDD99 LONG99 MAPBG99 MAPSM99 MG11 MG98 MN11 Var. Type Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Char Char Char Num Num Char Char Char Num Char Char Num Num Num Nurn Num Char Char Char Num Num Num Format 8.3 8.3 8.3 8.0 8.2 8.2 8.2 8.2 8.2 8.2 8.2 8. 8. 8. 8. 8. 11 5 8. 8. 8.0 8. 6. 8.3 8.4 8.4 8.4 8.4 8.3 4.0 9.0 6.0 8.3 8.4 30.0 10.0 10.0 8.4 7.0 30.0 8.2 11.5 8.3 11.5 8.4 11.0 25.0 40.0 8.3 8.4 8.3 Start Col. 1 10 20 30 40 50 80 70 1 10 20 30 40 50 80 70 1 14 24 34 44 54 64 1 10 20 30 40 50 55 65 1 10 20 51 62 1 10 18 49 59 1 10 22 32 44 1 43 53 63 End Col. 8 18 28 38 48 58 68 78 8 18 28 38 48 58 68 78 12 22 32 42 52 62 72 8 18 28 38 48 53 63 70 8 18 49 60 71 8 16 47 57 69 8 20 30 42 68 41 51 61 71 Label DIG (MG/L) FORM 2 DIC-EQUIL (MG/L) FORM 1 1 DIC-INIT (MG/L) FORM 1 1 DISTANCE FROM COAST (MILES) DOC (MG/L) FORM 1 1 DISSOLVED OXYGEN AT MID-HYP FORM ID DISSOLVED OXYGEN AT MID-MET FORM ID DISSOLVED OXYGEN AT TOP-HYP FORM ID DISSOLVED OXYGEN AT 0.5 M FORM ID DISSOLVED OXYGEN (MG/L) 1.5M FORM ID DIS OXYGEN (MG/L) BOTTOM-1.5M FORM ID DEPTH AT MID-HYP (M) FORM ID DEPTH AT MID-MET (M) FORM ID DEPTH SAMPLE COLL BTM-1.5M (M) FORM ID DEPTH SAMPLE COLL MID-HYP (M) FORM ID SITE DEPTH (M) FORM ID MAXIMUM LAKE DEPTH (M) - ALSC DEPTH AT TOP-HYP (M) FORM ID DEPTH AT BTM-1.5M (M) FORM ID Drop code for population estimates LAKE ELEVATION (M) LAKE ELEVATION (M) - ALSC IRON (UG/L) FORM 1 1 FLUORIDE (MG/L) FORM 1 1 FLUORIDE (UEQ/L) HYDROGEN FROM PHAC1 1 (UEQ/L) HCO3 (UEQ/L) HYDROGEN ION DEPOSITION (G/M**2/YR) HYDROLAB METER IDENTIFIER CODE FORM ID HYDROLOGIC TYPE PRESENSE/ABSENCE OF INLETS/OUTLETS POTASSIUM (MG/L) FORM 1 1 POTASSIUM (UEQ/L) LABORATORY FOR ANALYSIS FORM 2 LAKE ID LATITUDE LATITUDE (DECIMAL DEGREES) ERLO-UMD ID/ALSC WSHED-POND ID LAKE NAME LAKE SURFACE AREA (HA) LAKE SURFACE AREA (HA) - ALSC CALC LAKE VOL (10**6 CU M) DIG. LAKE VOL (10** 6 CU M) -ALSC LONGITUDE (DECIMAL DEGREES) LONGITUDE MAP SHEET NAME (1:250,000 SCALE) MAP SHEET NAME, 15 OR 7.5 QUAD MAGNESIUM (MG/L) FORM 1 1 MAGNESIUM (UEQ/L) MANGANESE (UG/L) FORM 1 1 Card # 8 8 8 8 8 8 8 8 9 9 9 9 9 9 9 9 10 10 10 10 10 10 10 11 11 11 11 11 11 11 11 12 12 12 12 12 13 13 13 13 13 14 14 14 14 14 15 15 15 15 74 ------- Table B-2. (Continued) Card # 16 16 16 16 16 16 16 16 17 17 17 17 17 17 17 17 18 18 18 18 18 18 18 18 19 19 19 19 19 19 19 19 19 20 20 20 20 20 20 20 21 21 21 21 21 21 21 21 22 22 22 22 22 22 22 22 Variable Name NA11 NA98 NH411 NH498 NO311 NO398 NO3DP99 ORGIO98 PH0051D PH0151D PH02 PHA11 PHAL11 PHEQ11 PHMH1D PHMM1D PHTH1D PH BID PRCIP99 PREC1D PRECO1D PTL11 RGSPC99 RPREC1D RT99 RTX99 RUNIN99 RUNOF99 RUNOFX99 SBRGN99 SECDI1D SECOV1D SECME98 SECRE1D SIO211 SITETYP SO411 SO498 SO4DP99 SOBC98 SPLCD02 ST99 STRAT99 T0051D T0151D T0251D T0351D T0451D T0551D T0651D T0751D T0851D T0951D T1051D T1251D T1451D Var. Type Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Char Char Num Char Char Num Num Num Num Num Char Num Char Num Num Num Char Num Num Num Num Char Char Char Num Num Num Num Num Num Num Num Num Num Num Num Num Format 8.3 8.4 8.3 8.4 8.4 8.4 8.2 8.4 8.2 8.2 8.2 8.2 8.2 8.2 8.2 8.2 8.2 8.2 8.3 5.0 7.0 8.4 16.0 8.0 8.3 8.3 8.0 8.3 8.3 1.0 8.1 1.0 8.1 8.1 8.3 9.0 8.3 8.4 8.2 8.4 12.0 2.0 3.0 8. 8. 8. 8. 8. 8. 8. 8. 8. 8. 8. 8. Start Col. 1 10 20 30 40 50 80 70 1 10 20 30 40 50 60 70 1 10 20 30 38 44 54 71 1 10 20 30 40 50 52 62 64 1 10 20 30 40 50 80 1 15 18 22 32 42 52 62 1 10 20 30 40 50 60 70 End Col. 8 18 28 38 48 58 68 78 8 18 28 38 48 58 68 78 8 18 28 34 42 52 69 78 8 18 28 38 48 50 80 62 72 8 18 28 38 48 58 68 13 16 20 30 40 50 80 70 8 18 28 38 48 58 88 78 Label SODIUM (MG/L) FORM 11 SODIUM (UEQ/L) AMMONIUM ION (MG/L) FORM 11 AMMONIUM(UEQ/L) NITRATE ION (MG/L) FORM 1 1 NITRATE (UEQ/L) NITRATE DEPOSITION (G/M**2/YR) ORGANIC ANION (UQ/L) PHAT0.5MFORM1D PHATI.5MFORM1D STATION PH FORM 2 ACIDITY INITIAL PH FORM 1 1 ALKAUNTY INITIAL PH FORM 11 AIR-EQUILIBRATED PH FORM 11 PH AT MID-HYP FORM ID PH AT MID-MET FORM ID PH AT TOP-HYP FORM ID PH AT BTM-1.5M FORM ID PRECIPITATION (M/YR) PRECIPITATION FORM ID PRECIPITATION OBS (PREV/CURRENT) FORM ID TOTAL PHOSPHORUS (UG/L) FORM 11 REG SPEC LTM NRC DEW DER SAMPLE CLASS RATE OF PRECIPITATION FORM ID RESIDENCE TIME (YR) RESIDENCE TIME (YR) - ALSC ANNUAL RUNOFF INCHES FROM DIGIT MAP SURFACE WATER RUNOFF (M/YR) SURFACE WATER RUNOFF (M/YR) - ALSC NSWS SUBREGION SECCHI DEPTH: DISAPPEAR (M) FORM ID SECCHI DEPTH Y= VISIBLE TO BOTTOM FORM ID MEAN: SECHI DISK DISAPPEAR REAPPEAR (M) SECCHI DEPTH: REAPPEAR (M) FORM ID SILICA (MG/L) FORM 1 1 SAMPUNG SITE OR TYPE CODE SULFATE ION (MG/L) FORM 11 SULFATE (UEQ/L) SULFATE DEPOSITION (G/M**2/YR) SUM OF BASE CATIONS (UEQ/L) SPLIT/SAMPLE CODE TO LAS VEGAS FORM 2 STATE (TWO-LETTER ABBREV) NSWS STRATA TEMPERATURE AT 0.5 M (DEC C) FORM ID TEMPERATURE AT 1.5 M (DEC C) FORM ID TEMPERATURE AT 2.5 M (DEC C) FORM ID TEMPERATURE AT 3.5 M (DEC C) FORM ID TEMPERATURE AT 4.5 M (DEC C) FORM ID TEMPERATURE AT 5.5 M (DEC C) FORM ID TEMPERATURE AT 6.5 M (DEC C) FORM ID TEMPERATURE AT 7.5 M (DEC C) FORM ID TEMPERATURE AT 8.5 M (DEC C) FORM ID TEMPERATURE AT 9.5 M (DEC C) FORM ID TEMPERATURE AT 10.5 M (DEC C) FORM ID TEMPERATURE AT 12.5 M (DEC C) FORM ID TEMPERATURE AT 14.5 M (DEC C) FORM ID Card # 16 16 16 16 16 16 16 16 17 17 17 17 17 17 17 17 18 18 18 18 18 18 18 18 19 19 19 19 19 19 19 19 19 20 20 20 20 20 20 20 21 21 21 21 21 21 21 21 22 22 22 22 22 22 22 22 75 ------- Table B-2. (Continued) Card # 23 23 23 23 23 23 23 23 24 24 24 24 24 24 24 24 25 25 25 25 25 25 25 25 26 26 26 26 26 26 Variable Name T1651D T1851D T2051D T2251D T2451D T2651D T2851D T3051D T3251D T3451D T3651D T3851D TIMSM1D TMPA1D TMPMH1D TMPMM1D TMPTH1D TMP BID TUR02 WALA99 WALAX99 WDIR1D WSDIS99 WSHED99 WSHEDX99 WSOTH99 WSPD1D WT1M99 WT1O 99 WT2C9~9 Var. Type Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Char Char Num Num Char Char Num Num Num Start Format Col. 8. 8. 8. 8. 8. 8. 8. 8. 8. 8. 8. 8. 5.( 8.( 8. 8. 8. 8. 1 10 20 30 40 50 80 70 1 10 20 30 ) 40 ) 47 57 67 1 10 8.2 20 8.2 30 11.5 40 3.0 52 8.0 58 8.3 65 11.5 1 25.0 14 8.0 40 8.3 49 8.3 59 8.4 69 End Col. 8 18 28 38 48 58 68 78 8 18 28 38 45 55 65 75 8 18 28 38 50 54 63 73 12 38 47 57 67 77 Label TEMPERATURE AT 16.5 M DEG C FORM ID TEMPERATURE AT 18.5 M DEG C FORM ID TEMPERATURE AT 20.5 M DEG C FORM ID TEMPERATURE AT 22.5 M DEG C FORM ID TEMPERATURE AT 24.5 M DEG C FORM ID TEMPERATURE AT 26.5 M DEG C FORM ID TEMPERATURE AT 28.5 M DEG C FORM ID TEMPERATURE AT 30.5 M DEG C FORM ID TEMPERATURE AT 32.5 M (DEG C) FORM ID TEMPERATUREAT34.5 M (DEG C) FORM ID TEMPERATURE AT 36.5 M (DEG C) FORM ID TEMPERATURE AT 38.5 M (DEG C) FORM ID TIME SAMPLED (24 H) HH:MM FORM ID AIR TEMPERATURE (DEG C) FORM ID TEMPERATURE AT MID-HYP (DEG C) FORM ID TEMPERATURE AT MID-MET (DEG C) FORM ID TEMPERATURE AT TOP-HYP (DEG C) FORM ID TEMPERATURE AT BTM-1.5M (DEG C) FORM ID TURBIDITY (MTU) FORM 2 WATERSHED AREA/LAKE AREA WATERSHED AREA/LAKE AREA - ALSC ESTIMATED WIND DIRECTION FORM ID D)WELL I)ND L)OG M)INE R)OAD S)TOCK WATERSHED AREA (HA) WATERSHED AREA (HA) - ALSC DISTURBW/I 100M-OTHER ESTIMATED WIND SPEED FORM ID MODIFIED PHASE I WEIGHT ORIGINAL PHASE I WEIGHT CONDITIONAL PHASE II WEIGHT Card # 23 23 23 23 23 23 23 23 24 24 24 24 24 24 24 24 25 25 25 25 25 25 25 25 26 26 26 26 26 26 27 WT2T99 Num 8.3 TOTAL PHASE II WEIGHT 27 76 ------- Table B-3. Card-Image Format Definition, ELS-II Data Set FASFIM01 Card # 2 2 2 2 2 2 2 2 3 o J 3 o J 3 o J 3 o J 4 4 4 4 4 4 4 4 5 5 5 5 S S 5 5 6 6 8 8 6 6 6 7 7 7 7 7 7 7 7 Variable Name ACCES1D ACCO11 ALD02 ALDI98 ALEX11 ALKA11 ALO 02 ALTL11 ANCAT98 ANDEF98 ANSUM98 BNSTR99 C0151D C04051D C06101D C08151D C10201D C12251D C14301D C16351D C18401D C20451D CA11 CA98 CATSU98 CL11 CL98 CLSTR99 CNTY99 CO398 COLOR02 CON601D COND11 CON BID CXX501D DATSMP DIC02 DICE 11 DICI11 DISM99 DOC 11 DO 151D DO 60 ID DO BID DPCAT1D DPSIT1D DPSITX1D DP 60 ID DP BID DRPCDE ELEV99 ELEVX99 FEU FTL11 FTL98 Var. Type Char Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Char Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Format 3.0 8.1 8.4 8.4 8.4 8.1 8.4 8.4 8.4 8.4 8.4 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.3 8.4 8.4 8.3 8.4 8.0 5.0 8.4 8.0 8.0 8.1 8.0 8.0 7.0 8.3 8.3 8.3 8.0 8.2 8.2 8.2 8.2 8.0 8.1 11.5 8.1 8.1 8.0 8.1 8.1 8.3 8.4 8.4 Start Col. 1 6 16 26 36 46 58 66 1 10 20 30 40 50 60 70 1 10 20 30 40 50 60 70 1 10 20 30 40 46 56 66 1 10 20 30 39 49 59 69 1 10 20 30 40 50 80 1 10 20 30 40 50 80 70 End Col. 4 14 24 34 44 54 64 74 8 18 28 38 48 58 68 78 8 18 28 38 48 58 68 78 8 18 28 38 44 54 84 74 8 18 28 37 47 57 67 77 8 18 28 38 48 58 70 8 18 28 38 48 58 68 78 Label ACCESS FORM ID CO2-ACIDITY )UEQ/L) FORM 11 PCV ALUMINUM DISSOLVED (UG/L) FORM 2 LABILE MONOMERIC AL (UG/L) ALUMINUM-EXTRACT ABLE (UG/L) FORM 11 ALKAUNITY (UEQ/L) FORM 11 PCV ALUMINUM ORGANIC (UG/L) FORM 2 TOTAL ALUMINUM (UG/L) FORM 11 CATIONSIANIONS RATIO CATSUM - ANSUM (UEQ/L) SUM OF ANIONS (UEQ/L) POPULATION SIZE BY STRATA CONDUCTIVITY (US/CM) AT 1.5M FORM ID CONDUCTIVITY AT 4 OR 5 M (US/CM) FORM ID CONDUCTIVITY AT 6 OR 1OM (US/CM) FORM ID CONDUCTIVITY AT 8 OR 15 M (US/CM) FORM ID CONDUCTIVITY AT 10 OR 20M(US/CM) FORM ID CONDUCTIVITY AT 12 OR 25M(USICM) FORM ID CONDUCTIVITY AT 14 OR 30M(US/CM) FORM ID CONDUCTIVITY AT 16 OR 35M(USICM) FORM ID CONDUCTIVITY AT 18 OR 40M(US/CM) FORM ID CONDUCTIVITY AT 20 OR 45M(US/CM) FORM ID CALCIUM (MG/L) FORM 11 CALCIUM (UEQ/L) SUM OF CATIONS (UEQ/L) CHLORIDE ION (MG/L FORM 11 CHLORIDE (UEQ/L) PHASE II CLUSTER (1.2 or 3) FIPS CODE(ST,COUNTY) CARBONATE ALKAUNITY (UEQ/L) COLOR (PCU) FORM 2 CONDUCTIVITY AT 0.6*DEPTH(US/CM) FORM ID CONDUCTIVITY (US/CM) FORM 11 CONDUCT AT BOTTOM-1.5M (US/CM) FORM ID CONDUCTIVITY AT 50 M (US/CM) FORM ID DATE SAMPLED DIC (MG/L) FORM 2 DIC-EQUIL (MG/L) FORM 11 DIC-INIT (MG/L) FORM 11 DISTANCE FROM COAST (MILES) DOC (MG/L) FORM 11 DISSOLVED OXYGEN (MG/L) 1.5M FORM ID DISSOLVED OXYGEN AT 0.6*DEPTH FORM ID DIS OXYGEN (MG/L) BOTTOM-1.5M FORM ID DEPTH CATEGORY 4= <20M 5=>20M FORM ID SITE DEPTH (M) FORM ID MAXIMUM LAKE DEPTH (M) - ALSC DEPTH 0.6*BOTTOM (M) FORM ID DEPTH AT BOTTOM-1.5M (M) FORM ID Drop code for population estimates LAKE ELEVATION (M) LAKE ELEVATION (M) - ALSC IRON (UG/L) FORM 11 FLUORIDE (MG/L) FORM 11 FLUORIDE (UEQ/L) Card # 2 2 2 2 2 2 2 2 3 o J 3 o J 3 o J 3 o J 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 7 7 7 7 7 7 7 7 77 ------- Table B-3. (Continued) Card # 8 8 8 8 8 8 8 8 9 9 9 9 9 10 10 10 10 10 11 11 11 12 12 12 12 13 13 13 13 13 13 13 13 13 14 14 14 14 14 14 14 14 15 15 15 15 15 15 15 15 Variable Name H98 HCO398 HDEP99 HYDID1D HYTYP99 INOUT99 Kll K98 LABNA02 LAKE ID LAT99 LATDD99 LKID99 LKNAM99 LKSIZ99 LKSIZX99 LKVOL99 LKVOLX99 LNGDD99 LONG99 MAPBG99 MAPSM99 MG11 MG98 MN11 NA11 NA98 NH411 NH498 NO311 NO398 NO3DP99 NVLAK1D OB SID ID ORGIO98 PH0151D PH02 PHAC11 PHAL11 PHEQ11 PH 60 ID PH_B1D PRCIP99 PREC1D PRECO1D PTL11 RGSPC99 RPREC1D RT99 RTX99 Var. Type Num Num Num Char Char Char Num Num Char Char Char Num Char Char Num Num Num Num Num Char Char Char Num Num Num Num Num Num Num Num Num Num Char Char Num Num Num Num Num Num Num Num Num Char Char Num Char Char Num Num Format 8.4 8.4 8.3 4.0 9.0 6.0 8.3 8.4 30.0 10.0 10,0 8.4 7.0 30.0 8.2 11.5 8.3 11.5 8.4 11.0 25.0 40.0 8.3 8.4 8.3 8.3 8.4 8.3 8.4 8.4 8.4 8.2 1.0 6.0 8.4 8.2 8.2 8.2 8.2 8.2 8.2 8.2 8.3 5.0 7.0 8.4 16.0 8.0 8.3 8.3 Start Col. 1 10 20 30 35 45 52 62 1 33 44 55 65 1 33 43 55 65 1 10 22 I 43 53 63 1 10 20 30 40 50 80 70 72 1 10 20 30 40 50 80 70 1 10 16 24 34 51 80 70 End Col. 8 18 28 33 43 50 80 70 31 42 53 63 71 31 41 53 63 75 8 20 46 41 51 61 71 8 18 28 38 48 58 68 70 77 8 18 28 38 48 58 68 78 8 14 22 32 49 58 68 78 Label HYDROGEN FROM PH AC 11 (UEQ/L) HCO3 (UEQ/L) HYDROGEN ION DEPOSITION (G/M**2/YR) HYDROLAB METER IDENTIFIER CODE FORM ID HYDROLOGIC TYPE PRESENSE/ABSENCE OF INLETS/OUTLETS POTASSIUM (MG/L) FORM 11 POTASSIUM (UEQ/L) LABORATORY FOR ANALYSIS FORM 2 LAKE ID LATITUDE LATITUDE (DECIMAL DEGREES) ERLD-UMD ID/ALSC WSHED-POND ID LAKENAME LAKE SURFACE AREA (HA) LAKE SURFACE AREA (HA) - ALSC CALC LAKE VOL (10**6 CU M) DIG. LAKE VOL (10**6 CU M) -ALSC LONGITUDE (DECIMAL DEGREES) LONGITUDE MAP SHEET NAME (1:250,000 SCALE) MAP SHEET NAME, 15 OR 7.5 QUAD MAGNESIUM (MG/L) FORM 11 MAGNESIUM (UEQ/L) MANGANESE (UG/L) FORM 11 SODIUM (MG/L) FORM11 SODIUM (UEQ/L) AMMONIUM ION (MG/L) FORM 11 AMMONIUM (Ueq/L) NITRATE ION (MG/L) FORM1 1 NITRATE (UEQ/L) NITRATE DEPOSITION (G/M**2/YR) NON- VARIABILITY LAKE (Y OR N) FORM ID OBSERVER ID NUMBER FORM ID ORGANIC ANION (UEQ/L) PHAT1.5MFORM1D STATION PH FORM 2 ACIDITY INITIAL PH FORM 1 1 ALKAUNITY INITIAL PH FORM 11 AIR-EQUILIBRATED PH FORM 11 PH AT 0.6*DEPTH FORM ID PH AT BOTTOM-1.5M FORM ID PRECIPITATION (M/YR) PRECIPITATION FORM ID PRECIPITATION OBS (PREV/CURRENT) FORM ID TOTAL PHOSPHORUS (UG/L) FORM 11 REG SPEC LTM NRC DEW DER SAMPLE CLASS RATE OF PRECIPITATION FORM ID RESIDENCE TIME (YR) RESIDENCE TIME (YR) - ALSC Card # 8 8 8 8 8 8 8 8 9 9 9 9 9 10 10 10 10 10 11 11 11 12 12 12 12 13 13 13 13 13 13 13 13 13 14 14 14 14 14 14 14 14 15 15 15 15 15 15 15 15 78 ------- Table B-3. (Continued) Card # 16 16 16 16 16 16 16 16 16 17 17 17 17 17 17 17 17 17 18 18 18 18 18 18 18 18 19 19 19 19 19 19 19 19 20 20 20 20 20 20 20 20 21 21 21 21 21 21 Variable Name RUNIN99 RUNOF99 RUNOFX99 SAMRT1D SBRGN99 SECDI1D SECDV1D 8ECME98 SECRE1D SIO211 SITETYP SO411 SO498 SO4DP99 SOBC98 SPRID1D ST99 STRAT99 T04051D T06101D T08151D T10201D T12251D T14301D T16351D T18401D T20451D TIMSM1D TM0151D TMP601D TMPA1D TMPD11D TMPD21D TMP BID TUR02 TXX501D VISIT ID WALA99 WALAX99 WDIR1D WSDIS99 WSHED99 WSHEDX99 WSOTH99 WSPD1D WT1M99 WT1O 99 WT2C9~9 Var. Start Type Format Col. Num 8.0 1 Num 8.3 10 Num 8.: 5 20 Num 8.0 30 Char 1.0 40 Num 8. [ 42 Char 1.0 52 Num 8. Num 8. Num 8.: [ 54 [ 64 ] 1 Char 9.0 10 Num 8.: I 20 Num 8.4 30 Num 8.2 40 Num 8.4 50 Char 6.0 80 Char 2.0 67 Char 3.0 70 Num 8. Num 8. Num 8. Num 8. Num 8. Num 8. Num 8. Num 8. Num 8. Num 5.( Num 8. Num 8. Num 8.( Num 8. Num 8. Num 8. 1 10 20 30 40 50 80 70 1 ) 10 17 27 ) 37 47 57 67 Num 8.2 1 Num 8. [ 10 Num 8.0 20 Num 8.2 30 Num 11 .5 40 Char 3.0 52 Char 8.0 56 Num 8.3 65 Num 11 Char 25 .5 1 .0 14 Char 8.0 40 Num 8.: 5 49 Num 8.3 59 Num 8.4 69 End Col. 8 18 28 38 40 50 52 62 72 8 18 28 38 48 58 65 68 72 8 18 28 38 48 58 66 78 8 15 25 35 45 55 65 75 8 18 28 38 50 54 63 73 12 38 47 57 67 77 Label ANNUAL RUNOFF INCHES FROM DIGIT MAP SURFACE WATER RUNOFF (M/YR) SURFACE WATER RUNOFF (M/YR) - ALSC SAMPLE ID ROUTINE FORM ID NSWS SUBREGION SECCHI DEPTH: DISAPPEAR (M) FORM ID SECCHI DEPTH Y= VISIBLE TO BOTTOM FORM ID MEAN: SECHI DISK DISAPPEAR REAPPEAR (M) SECCHI DEPTH: REAPPEAR (M) FORM ID SILICA (MG/L) FORM 1 1 SAMPLING SITE OR TYPE CODE SULFATE ION (MG/L) FORM 1 1 SULFATE (UEO/L) SULFATE DEPOSITION (G/M**2/YR) SUM OF BASE CATIONS (UEQ/L) SAMPLER ID NUMBER FORM ID STATE (TWO-LETTER ABBREV) NSWS STRATA TEMPERATURE AT 4 OR 5 M (DEG C) FORM ID TEMPERATURE AT 6 OR 10 M (DEG C) FORM ID TEMPERATURE AT 8 OR 15 M (DEG C) FORM ID TEMPERATURE AT 10 OR 20M DEG C FORM ID TEMPERATURE AT 12 OR 25M DEG C FORM ID TEMPERATURE AT 14 OR 3 OM DEG C FORM ID TEMPERATURE AT 16 OR 35M DEG C FORM ID TEMPERATURE AT 18 OR 40M DEG C FORM ID TEMPERATURE AT 20 OR 45M (DEG C) FORM ID TIME SAMPLED (24 H) HH:MM FORM ID TEMPERATURE (DEG C) AT 1.5M FORM ID TEMPERATURE AT 0.6*DEPTH (DEG C) FORM ID AIR TEMPERATURE (DEG C) FORM ID TEMP DIP 1.5M-BOTTOM (DEG C) FORM ID TEMP DIP 1.5M-0.6*DEPTH (DEG C) FORM ID TEMP AT BOTTOM-105M (DEG C) FORM ID TURBIDITY (NTU) FORM 2 TEMPERATURE AT 50 M (DEGC) FORM ID VISIT FORM ID WATERSHED AREA/LAKE AREA WATERSHED AREA/LAKE AREA - ALSC ESTIMATED WIND DIRECTION FORM ID D)WELL I)ND L)OG M)INE R)OAD S)TOCK WATERSHED AREA (HA) WATERSHED AREA (HA)-ALSC DISTURBW/I 100M-OTHER ESTIMATED WIND SPEED FORM ID MODIFIED PHASE I WEIGHT ORIGINAL PHASE I WEIGHT CONDITIONAL PHASE II WEIGHT Card # 16 16 16 16 16 16 16 16 16 17 17 17 17 17 17 17 17 17 18 18 18 18 18 18 18 18 19 19 19 19 19 19 19 19 20 20 20 20 20 20 20 20 21 21 21 21 21 21 22 WT2T99 Num 8.3 TOTAL PHASE II WEIGHT 22 79 ------- Table B-4. Card-Image Format Definition, ELS-II Data Set BATHYM Card Variable Var. # Name Type Format Start Col. End Col. Label Card # 1 FRATE Num 8.3 1 8 FLUSHING RATE (YRS) [WAREA* RUNOFF /VOL] 1 1 LAKE ID Char 7.0 10 16 LAKE ID 1 1 LAT DD Num 8.4 18 28 LATITUDE (DECIMAL DEGREES) 1 1 LITTAREA Num 8.2 28 38 LITTORAL ZONE (<= 10 FT DEPTH) AREA (HA) 1 1 LONG DD Num 8.4 38 46 LONGITUDE (DECIMAL DEGREES) 1 1 MAXDPM Nurn 8.1 48 56 Maximum Depth (m) 1 1 MEANDPM Nurn 8.1 58 66 MEAN DEPTH (M) [VOL/AREA] 1 1 RUNOFF Num 8.3 68 76 RUNOFF (CM/YR) 1 2 SAREA Num 8.2 1 8 Lake Surface Area (ha) 2 2 SHORLN Num 8.3 10 18 SHORELINE LENGTH (KM) 2 2 SHRDEV Num 8.4 20 28 SHORELINE DEVELOPMENT (L/2SQRT(PI*A)) 2 2 VOLDV Num 8.4 30 38 VOLUME DEVEL. (3*MEAN DEPTH/MAX DEPTH) 2 2 VOLUME Num 8.3 40 48 LAKE VOLUME (10**6 CUBIC METERS) 2 2 WAREA Num 8.2 50 58 Watershed Area (ha) 2 80 ------- Table B-5. Card-Image Format Definition, ELS-II Data Set SUSZOOP Card # 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 3 3 3 3 3 3 3 4 4 4 4 4 4 4 5 5 5 5 5 5 5 6 6 6 6 6 6 6 7 7 7 7 7 7 7 Variable Name JARID LAKE ID RD1000 RD1001 RD1002 RD1003 RD1004 RD1005 RD1008 RD1007 RD1008 RD1009 RD1010 RD1011 RD1030 RD1031 RD1040 RD1041 RD1050 RD1051 RD1060 RD1070 RD1101 RD1102 RD1103 RD1104 RD1105 RD1110 RD1400 RD1401 RD1402 RD1403 RD1404 RD1405 RD1406 R01407 RD1500 RD1501 RD1510 RD1511 RD1512 RD1800 RD1809 RD1900 RD1901 RD1902 RD1903 RD1904 RD1910 RD1911 Var. Type Num Char Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Formal 2.0 7.0 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 Start Col. 1 4 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 End Col. Label 21 1 0 LAKE IDENTIFICATION NUMBER 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 Card # 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 3 3 3 3 3 3 4 4 4 4 4 4 4 5 5 5 5 5 5 5 6 6 6 6 6 6 6 7 7 7 7 7 7 7 Table B-5. (Continued) 81 ------- Card # 8 8 8 8 8 8 8 9 9 9 9 9 9 9 10 10 10 10 10 10 10 11 11 11 11 11 11 11 12 12 12 12 12 12 12 13 13 13 13 13 13 13 14 14 14 14 14 14 14 Variable Name RD1912 RD1921 RD1922 RD1923 RD1924 RD2100 RD2101 RD2102 RD2200 RD2300 RD230I RD2310 RD2311 RD3100 RD3101 RD3300 RD4100 RD51O1 RD5102 RD5110 RD5201 RD5301 RD5310 RD5311 RD5312 RD5501 RD5502 RD5509 RD5510 RD5511 RD5512 RD5513 RD5519 RD5520 RD5530 RD5540 RD5550 RD5560 RD5600 RD5701 RD5702 RD5703 RD5704 RD5705 RD5706 RD5707 RD5708 RD5709 RD5710 Var. Type Num Num Num Num Nurn Num Nurn Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Nurn Num Num Format 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 Start Col.. 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 End Col. 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 Card Label # 8 8 8 8 8 8 8 9 9 9 9 9 9 9 10 10 10 10 10 10 10 11 11 11 11 11 11 11 12 12 12 12 12 12 12 13 13 13 13 13 13 13 14 14 14 14 14 14 14 82 ------- Table B-5. (Continued) Card # 15 15 15 15 15 15 15 16 16 16 16 16 16 16 17 17 17 17 17 17 17 18 18 18 18 16 18 18 19 19 19 19 19 19 19 20 20 20 20 20 20 20 21 21 21 Variable Name RD5601 RD5602 RD5803 RD5804 RD5805 RD5809 RD6300 RD6301 RD6309 RD6401 RD6402 RD6411 RD6412 RD6421 RD6422 RD6423 RD6429 RD6431 RD6500 RD7100 RD7101 RD7110 RD7111 RD7112 RD7121 RD7122 RD7123 RD7124 RD7129 RD7131 RD7141 RD7142 RD7143 RD7144 RD7160 RD7200 RD7500 RD8000 RD9100 RD9101 RD9102 RD9199 RD9200 RD9201 RD9300 Var. Type Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Num Formal 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 Start Col. 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 32 42 52 62 1 12 22 End Col. 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 40 50 60 70 10 20 30 Card Label # 15 15 15 15 15 15 15 16 16 16 16 16 16 16 17 17 17 17 17 17 17 18 18 18 18 18 18 18 19 19 19 19 19 19 19 20 20 20 20 20 20 20 21 21 21 83 ------- Table B-6. Card-Image Format Definition, ELS-II Data Set SUSCHLA Card # I I 1 I I 1 1 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 4 4 4 Variable Name BATCH ID CHLA AC CHLA AR CHLATTC CHLATTT CHLB~AR CHLBTTT DAT ANAL DG AR DG~HT FLU CHL FLUT)IL FLITSCL FLU STD FLUIVAL LAKE ID SAM ID SAM~TYPE SA1VTVOL SOLVOL SPCCHLA SPC CHLB SPECFILE SPEC 650 SPEC~665 SPEC 700 Var. Type Num Num Num Num Num Num Num Char Num Num Nurn Nurn Num Char Num Char Nurn Char Num Num Num Num Char Num Num Num Format 8.0 9.3 9.3 9.3 9.3 9.3 9.3 10.0 9.3 9.3 9.3 9.3 9.3 2.0 9.3 7.0 8.0 4.0 9.3 9.3 9.3 9.3 10.0 9.3 9.3 9.3 Start Col. 1 10 20 30 40 50 60 1 13 23 33 43 53 63 66 1 10 20 25 35 45 55 65 1 12 22 End Col.. 8 18 28 38 48 58 68 11 21 31 41 51 61 64 74 8 18 23 33 43 53 63 74 10 20 30 Label BATCH ID CODE CHLa CONC. BASED ON PEAK AREA CHLa PEAK AREA CHLa CONC. BASED ON PEAK HIGHT CHLa PEAK HEIGHT CHLb PEAK AREA CHLb PEAK HEIGHT DATE ANALYZED DEGREDATION PRODUCTS PEAK AREA DEGREDATION PRODUCTS PEAK HEIGHT CONC. OF CHLa MEASURED WITH FLUOROMETER DILUTION FACTOR FOR FWOR. MEASUREMENT FLUOROMETER SCALE FLUORESCENCE STANDARD (MEASURED) FLUORESCENCE VALUE NSWS LAKE ID CODE SAMPLE ID CODE SAMPLE TYPE SAMPLE VOLUME SOLVENT VOLUME CONC.OF CHLA AS MEASURED WITH SPEC CONC. OF CHLb AS MEASURED WITH SPEC SPECTROPHOTOMETRY FILE SPECTROPHOTOMETRY @ 650 nm SPECTROPHOTOMETRY @ 665 nm SPECTROPHOTOMETRY ® 700 nm Card # 1 1 I 1 1 1 1 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 4 4 4 84 ------- Table B-7. Example Card-Image Listing for One Record In Data File FASFIM01.DAT 123 4567 8 12345678901234567890123456789012345678901234567890123456789012345678901234567890 H 28.6 63.6000 32.0000 31.7000 1.8 31.6000 140.2000 1 1.1965 22.8711 116.3700 711 3 -999 -999 -999 2 -999 -999 -999 -999 -999 -999 1.767 88.1730 3 139.2400 0.194 5.4730 1 36033 0.0000 25 -999 4 17.6 -999 -999 29OCT86 0.410 0.107 0.385 -999 5 3.60 10.80 -999.00 -999.00 -999 3.0 400000 6 -999.0 -999.0 1 497.1 497.0 23.000 0.0198 1.0420 7 1.8200 6.1270 0.042 BAB DRAINAGE I/O 0.302 7.7220 8 VERSAR 1A1-028 44-21' 10"N 44.3528 03-128 9 DRY CHANNEL POND 27.10 27.70000 0.302 0.72924 10 74.4375 74-26'15"W OGDENSBURG 11 7.5'X15' UPPER SARANAC LAKE 0.242 19.9070 11.000 12 0.497 21.6200 -0.000 -0.0000 0.0802 1.2940 1.19 N 90 13 31.9660 5.31 5.63 5.74 5.66 5.70 -999.00 -999.00 14 0.917 RAINPREV 4.8000 REG/ MODERATE 0.330 1.800 15 20 0.508 0.635 4 A -999.0 Y 3.0 -999.0 16 0.844 VI 4.920 102.4340 2.00 137.4219 84 NY 1A1 17 -999.0 -999.0 -999.0 -999.0 -999.0 -999.0 -999.0 -999.0 18 -999.0 10:10 8.2 -999.0 15 -999.0 -999.0 -999.0 19 0.40 -999.0 1 7.64 7.62094 SW DR 207.000 20 211.10000 MODERATE 9.633 9.633 1.2754 21 12.285 22 85 ------- |