# Precipitation chemistry concentrations and fluxes, HJ Andrews Experimental Forest, 1969 to present ## Dataset - **Database Code:** CP002 - **Title:** Precipitation chemistry concentrations and fluxes, HJ Andrews Experimental Forest, 1969 to present - **Abstract:** Collection and analyses of precipitation chemistry were initiated in 1969 at the low-elevation Primary Met site, and in 1973 at a mid-elevation Hi-15 site. Rain collection samples accumulate from one week to three weeks in bulk and NADP type collectors and then are transported to Cooperative Chemical Analytical Laboratory (CCAL) for analysis. Analytes include nitrogen, phosphorus, carbon, and cations and anions as well as pH, conductivity, alkalinity and particulate sediment. Concentration and volume of precipitation are combined for inflow. Dry deposition chemistry concentrations began in 1989 and are analyzed 2-4 times per year at one site. The original objectives were to evaluate precipitation chemistry inputs versus chemistry outputs in streamflow from forested watersheds. The study has evolved into a general monitoring effort for precipitation chemistry that is among the least contaminated of any within the USA. This study is conducted in conjunction with Andrews streamflow chemistry (CF002) and the U.S. National Atmospheric Deposition Program (NADP). - **Keywords:** hydrology; water chemistry; precipitation; chemical properties; concentration; suspended solids; timber harvest; inorganic nutrients; nutrients; water; inorganic nutrients - **Temporal coverage:** 1968-10-01 to 2019-05-22 - **Principal Investigator:** Sherri L. Johnson ## Data Entities 1. CP00201 2. CP00202 3. CP00203 4. CP00206 ## Entity 1: CP00201 ### Attribute list - **STCODE** — varchar, enum Study code - **CP002** — Study code CP002 - **ENTITY** — numeric(1.000000), range 1.0000 1.0000, number Entity number - **SITECODE** — varchar, enum Precipitation or dry deposition collector site code - **RCADMN** — Andrews Administrative Site rain collector (WS 9&10 RC) - **RCHI15** — Andrews original HI-15 rain collector - **RCHIR7** — Andrews Watershed 7 NADP-style rain collector - **RCHID7** — Andrews Watershed 7 NADP-style dry deposition collector - **RCHIF7** — Andrews Watershed 7 bulk collector - wet and dry deposition - **WATERYEAR** — numeric(1.000000), range 1969.0000 2019.0000, number Water year of sample or annual summary (October-September) - **DATE_TIME** — datetime, freetext Collection date and time (PST) of the precipitation sample - sample represents deposition from the previous sample date and time. Assume beginning date of first sample period for each collector is October 1st. - **LABNO** — varchar, freetext Lab number code for sample - **TYPE** — varchar, enum Sample type indicator - indicates dry deposition samples and other qualifying information - **S** — Sample saved and combined with the following collection due to insufficient water for analyses - samples were no longer saved and combined after 1981 - **P** — Partial sample - precipitation was not collected successfully over the entire period (includes problems with NADP-style collector motor or samples that may have overflowed) - **YE** — Year end marker allows summary by water year - this is not a sample. Flux values are calculated from precip ending Sep 30 and use analyte concentrations from the following sample. 'YE' markers are inserted every Sep 30. - **C** — Sample is combined with preceeding saved sample(s) for analysis. Combined samples of this type are not used after 1981. - **DW** — Dry deposition sample - dry bucket contains rain water - **F** — Sample is successfully collected over the entire period - a "Full" sample. - **N** — No sample is collected - generally indicates periods of little or no rain, but can be a lost sample. - **DF** — Dry deposition sample - sample is dry and not contaminated with precipitation water - **B** — Biased sample - Lid on NADP sampler malfunctions and sample includes dry deposition - **DC** — Dry deposition sample - dry bucket contains rain water and other insects/contaminants - **PRECIP_CM** — numeric(0.010000), range 0.0000 61.8700, centimeters Precipitation in centimeters for the exact sample period. Based on precipitation stations CS2MET or PRIMET (beginning WY 2003) for collector RCADMN and H15MET or CENMET (beginning WY 2006) for collectors RCHIF7, RCHIR7 and RCHI15. - **PCODE** — varchar, enum Precipitation value qualifier code - **N** — No precipitation recorded for period. For saved sample (type='S'), precipitation for this period is included in the following period. - **E** — Estimated precipitation - **A** — Accepted value for precipitation - **Q** — Precipitation value is questionable - **M** — Missing value - **PH** — numeric(0.100000), range 3.0000 7.4000, pH units pH (hydrogen concentration); method: glass electrode - **PHCODE** — varchar, enum pH value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - **Q** — Value is questionable (used beginning in 1991) - **COND** — numeric(0.400000), range 0.0000 576.4000, micro siemens per centimeter Specific conductance; method: wheatstone bridge - **CONDCODE** — varchar, enum Conductivity value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **ALK** — numeric(0.020000), range 0.0000 15.3700, milligrams per liter Alkalinity as calcium carbonate (CaCO3); method: electrometric titration to pH 4.5; all data is converted from the formerly used units of bicarbonate carbon (HCO3-C) - **ALKCODE** — varchar, enum Alkalinity value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **SSED** — numeric(0.010000), range 0.0000 796.0000, milligrams per liter Suspended sediment concentration; method: nonfiltrable residue, gravimetric - **SSEDCODE** — varchar, enum Suspended sediment value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - **Q** — Value is questionable (used beginning in 1991) - **SI** — numeric(0.050000), range 0.0000 8.9100, milligrams per liter Silica as silicon concentration; method: automated molybdenum blue - **SICODE** — varchar, enum Silica value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **UTP** — numeric(0.002000), range 0.0000 1483.0000, milligrams per liter Unfiltered total phosphorus concentration; method: persulfate/H2SO4 digestion, ascorbic acid finish - **UTPCODE** — varchar, enum Unfiltered total phosphorus value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **TDP** — numeric(0.002000), range 0.0000 6.0500, milligrams per liter Total dissolved phosphorus concentration; method: persulfate/H2SO4 digestion, ascorbic acid finish - **TDPCODE** — varchar, enum Total dissolved phosphorus value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **PARTP** — numeric(0.002000), range 0.0000 1482.6000, milligrams per liter Particulate P, also known as total suspended phosphorus - not measured analytically; mathematically determined by subtraction of Total Dissolved P (TDP) from Unfiltered Total P (UTP) - **PARTPCODE** — varchar, enum Particulate P value qualifier code - **N** — No derived value is calculated due to missing analytical components - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **PO4P** — numeric(0.001000), range 0.0000 5.9930, milligrams per liter Ortho phosphorus concentration, soluble reactive phosphorus, phosphate (PO4-P); method: ascorbic acid finish - **PO4PCODE** — varchar, enum Ortho phosphorus value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **UTN** — numeric(0.010000), range 0.0000 15.9900, milligrams per liter Total nitrogen concentration (unfiltered sample); method: persulfate digestion and analysis by automated colorimetric analysis; instrument: Technicon Auto-Analyzer II - **UTNCODE** — varchar, enum Unfiltered total nitrogen value qualifier code - **A** — Accepted value - **E** — Estimated value - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **N** — No analytical measurement or no derived value calculated due to missing analytical components - **TDN** — numeric(0.010000), range 0.0000 14.3700, milligrams per liter Total dissolved nitrogen concentration (filtered sample); method: persulfate digestion and analysis by automated colorimetric analysis; instrument: Technicon Auto-Analyzer II - **TDNCODE** — varchar, enum Total dissolved nitrogen value qualifier code - **A** — Accepted value - **E** — Estimated value - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **N** — No analytical measurement or no derived value calculated due to missing analytical components - **DON** — numeric(0.010000), range 0.0000 10.8700, milligrams per liter Dissolved organic nitrogen - not measured analytically; mathematically determined by subtracting NH3-N and NO3-N from Total dissolved nitrogen. Values before May 2005 are determined by TKN minus NH3-N. - **DONCODE** — varchar, enum Dissolved organic nitrogen value qualifier code - **N** — No derived value is calculated due to missing analytical components - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **PARTN** — numeric(0.010000), range 0.0000 5.1000, milligrams per liter Particulate N, also known as total suspended nitrogen - not measured analytically; mathematically determined by subtraction of Total dissolved nitrogen (TDN) from Unfiltered Total nitrogen (UTN). Values before May 2005 are determined by UTKN minus TKN. - **PARTNCODE** — varchar, enum Particulate N value qualifier code - **N** — No derived value is calculated due to missing analytical components - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **UTKN** — numeric(0.010000), range 0.0000 2.6700, milligrams per liter Total Kjeldahl nitrogen concentration on unfiltered sample; method: Kjeldahl digestion H2SO4, CuSO4/KCl, nessler finish - **UTKNCODE** — varchar, enum Unfiltered total Kjeldahl nitrogen value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **TKN** — numeric(0.010000), range 0.0000 14.3100, milligrams per liter Total Kjeldahl nitrogen concentration on filtered sample (dissolved); method: Kjeldahl digestion H2SO4, CuSO4/KCl, nessler finish - **TKNCODE** — varchar, enum Total Kjeldahl nitrogen value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **NH3N** — numeric(0.003000), range 0.0000 3.9160, milligrams per liter Ammonia-nitrogen (NH3-N) concentration, ammonia as nitrogen; method: automated phenate - **NH3NCODE** — varchar, enum NH3-N value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **C** — Value confirmed, contamination suspected (code use begins May 2007) - **NO3N** — numeric(0.001000), range 0.0000 1.8800, milligrams per liter Nitrate-nitrogen (NO3-N), nitrate + nitrite as nitrogen concentration; method: automated cadmium reduction - **NO3NCODE** — varchar, enum NO3-N value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **C** — Value confirmed, contamination suspected (code use begins May 2007) - **NA** — numeric(0.010000), range 0.0000 18.2300, milligrams per liter Na, dissolved sodium (filtrable) concentration; method flame atomic absorption spectroscopy - **NACODE** — varchar, enum Na value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **K** — numeric(0.030000), range 0.0000 18.2000, milligrams per liter K, dissolved potassium (filtrable) concentration; method flame atomic absorption spectroscopy - **KCODE** — varchar, enum K value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **CA** — numeric(0.060000), range 0.0000 5.5600, milligrams per liter Ca, dissolved calcium (filtrable) concentration; method flame atomic absorption spectroscopy - **CACODE** — varchar, enum Ca value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **MG** — numeric(0.020000), range 0.0000 15.9500, milligrams per liter Mg, dissolved magnesium (filtrable) concentration; method flame atomic absorption spectroscopy - **MGCODE** — varchar, enum Mg value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **SO4S** — numeric(0.020000), range 0.0000 4.8900, milligrams per liter SO4-S (dissolved) concentration, sulfate as sulfur; method ion chromatography (automated barium sulfate before 1993) - **SO4SCODE** — varchar, enum SO4-S value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **CL** — numeric(0.010000), range 0.0000 47.2000, milligrams per liter Chloride (dissolved) concentration; method: ion chromatography (automated ferric thiocyanate before 1993) - **CLCODE** — varchar, enum Cl value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **DOC** — numeric(0.050000), range 0.0000 26.8000, milligrams per liter DOC, dissolved organic carbon concentration; method: combustion - **DOCCODE** — varchar, enum DOC value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **PVOL** — numeric(0.001000), range 0.0080 19.9800, kilograms Sample volume from precipitation collector; for dry deposition sample - includes any precipitation collected and DI water added to sample for analysis - **PVOLCODE** — varchar, enum Sample volume qualifier code - **Q** — Sample volume value is questionable - typically implies volume is measured correctly, but volume does not represent the entire collection period - **N** — No sample volume value available - **A** — Accepted value - **K** — Volume is precipitation plus added DIW (usually 250 ml). concentration values are based on this volume. - **L** — Volume of lab water (DIW) added to dry bucket (usually 250 ml). concentration values are based on this volume. - **M** — Volume is precipitation in dry bucket (liters). Concentration values are based on this volume. No DIW added to the precipitation water. - **ANCA** — numeric(0.100000), range 0.1200 6.9500, number Anion-cation ratio: micro equivalence ratio of anions to cations by calculation - provided only as an analytical check. Requires anions: ALK, SO4S, CL, NO3N, PO4P, cations: pH, Na, K, Ca, Mg, NH4N - **ANCACODE** — varchar, enum Anion-cation ratio qualifier code - **N** — No anion-cation ratio calculation determined due to missing analytical components - **D** — Derived anion-cation ratio value is based on the full set of anions and cations - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values ## Entity 2: CP00202 ### Attribute list - **STCODE** — varchar, enum Study code - **CP002** — Study code CP002 - **ENTITY** — numeric(1.000000), range 2.0000 2.0000, number Entity number - **SITECODE** — varchar, enum Precipitation or dry deposition collector site code - **RCADMN** — Andrews Administrative Site rain collector (WS 9&10 RC) - **RCHI15** — Andrews original HI-15 rain collector - **RCHIR7** — Andrews Watershed 7 NADP-style rain collector - **RCHID7** — Andrews Watershed 7 NADP-style dry deposition collector - **RCHIF7** — Andrews Watershed 7 bulk collector - wet and dry deposition - **WATERYEAR** — numeric(1.000000), range 1969.0000 2018.0000, number Water year of sample or annual summary (October-September) - **DATE_TIME** — datetime, freetext Collection date and time (PST) of the precipitation sample - sample represents deposition from the previous sample date and time. Assume beginning date of first sample period for each collector is October 1st. - **LABNO** — varchar, freetext Lab number code for sample - **TYPE** — varchar, enum Sample type indicator - indicates dry deposition samples and other qualifying information - **S** — Sample saved and combined with the following collection due to insufficient water for analyses - samples were no longer saved and combined after 1981 - **P** — Partial sample - precipitation was not collected successfully over the entire period (includes problems with NADP-style collector motor or samples that may have overflowed) - **YE** — Year end marker allows summary by water year - this is not a sample. Flux values are calculated from precip ending Sep 30 and use analyte concentrations from the following sample. 'YE' markers are inserted every Sep 30. - **C** — Sample is combined with preceeding saved sample(s) for analysis. Combined samples of this type are not used after 1981. - **DW** — Dry deposition sample - dry bucket contains rain water - **F** — Sample is successfully collected over the entire period - a "Full" sample. - **N** — No sample is collected - generally indicates periods of little or no rain, but can be a lost sample. - **DF** — Dry deposition sample - sample is dry and not contaminated with precipitation water - **B** — Biased sample - Lid on NADP sampler malfunctions and sample includes dry deposition - **DC** — Dry deposition sample - dry bucket contains rain water and other insects/contaminants - **PRECIP_CM** — numeric(0.025000), range 0.0000 140.8900, centimeters Precipitation in centimeters for the exact sample period. Based on CS2MET (RCADMN) or H15MET (RCHIR7, RCHI15) meteorological station precipitation. - **PCODE** — varchar, enum Precipitation value qualifier code - **N** — No precipitation recorded for period. For saved sample (type='S'), precipitation for this period is included in the following period. - **E** — Estimated precipitation - **A** — Accepted value for precipitation - **Q** — Precipitation value is questionable - **M** — Missing value - **ALK_INPUT** — numeric(0.050000), range 0.0000 19.4600, kilograms per hectare Alkalinity inflow as CaCO3 (units have been converted for all values from bicarbonate (HCO3-C) to calcium carbonate) - **ALKCODE** — varchar, enum Alkalinity value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **SSED_INPUT** — numeric(0.050000), range 0.0000 54.8300, kilograms per hectare Suspended sediment inflow - **SSEDCODE** — varchar, enum Suspended sediment value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - **Q** — Value is questionable (used beginning in 1991) - **SI_INPUT** — numeric(0.050000), range 0.0000 9.9800, kilograms per hectare Silica inflow - **SICODE** — varchar, enum Silica value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **UTP_INPUT** — numeric(0.005000), range 0.0000 0.4720, kilograms per hectare Unfiltered total phosphorus inflow - **UTPCODE** — varchar, enum Unfiltered total phosphorus value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **TDP_INPUT** — numeric(0.005000), range 0.0000 0.4270, kilograms per hectare Total dissolved phosphorus inflow - **TDPCODE** — varchar, enum Total dissolved phosphorus value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **PARTP_INPUT** — numeric(0.005000), range 0.0000 0.2590, kilograms per hectare Particulate P inflow - not measured analytically; mathematically determined by subtraction of Total Dissolved P (TDP) from Unfiltered Total P (UTP) - **PARTPCODE** — varchar, enum Particulate P value qualifier code - **N** — No derived value is calculated due to missing analytical components - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **PO4P_INPUT** — numeric(0.005000), range 0.0000 0.4760, kilograms per hectare Ortho phosphorus (PO4-P) inflow - **PO4PCODE** — varchar, enum Ortho phosphorus value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **UTN_INPUT** — numeric(0.010000), range 0.0000 1.4000, kilograms per hectare Total nitrogen inflow (unfiltered sample) - **UTNCODE** — varchar, enum Unfiltered total nitrogen value qualifier code - **A** — Accepted value - **E** — Estimated value - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **N** — No analytical measurement or no derived value calculated due to missing analytical components - **TDN_INPUT** — numeric(0.010000), range 0.0000 5.0000, kilograms per hectare Total dissolved nitrogen inflow (filtered sample) - **TDNCODE** — varchar, enum Total dissolved nitrogen value qualifier code - **A** — Accepted value - **E** — Estimated value - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **N** — No analytical measurement or no derived value calculated due to missing analytical components - **DON_INPUT** — numeric(0.010000), range 0.0000 3.7800, kilograms per hectare Dissolved organic N inflow - not measured analytically; mathematically determined by subtracting NH3-N and NO3-N from Total dissolved nitrogen. Values before May 2005 are determined by TKN minus NH3-N - **DONCODE** — varchar, enum Dissolved organic nitrogen value qualifier code - **N** — No derived value is calculated due to missing analytical components - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **PARTN_INPUT** — numeric(0.010000), range 0.0000 1.1900, kilograms per hectare Particulate N inflow - not measured analytically; mathematically determined by subtraction of Total dissolved nitrogen (TDN) from Unfiltered Total nitrogen (UTN). Values before May 2005 are determined by UTKN minus TKN. - **PARTNCODE** — varchar, enum Particulate N value qualifier code - **N** — No derived value is calculated due to missing analytical components - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **UTKN_INPUT** — numeric(0.010000), range 0.0000 1.3500, kilograms per hectare Unfiltered total Kjeldahl nitrogen inflow - **UTKNCODE** — varchar, enum Unfiltered total Kjeldahl nitrogen value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **TKN_INPUT** — numeric(0.010000), range 0.0000 4.9800, kilograms per hectare Total Kjeldahl nitrogen (dissolved) inflow - **TKNCODE** — varchar, enum Total Kjeldahl nitrogen value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **NH3N_INPUT** — numeric(0.005000), range 0.0000 1.1960, kilograms per hectare Ammonia-nitrogen (NH3-N) inflow - **NH3NCODE** — varchar, enum NH3-N value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **C** — Value confirmed, contamination suspected (code use begins May 2007) - **NO3N_INPUT** — numeric(0.005000), range 0.0000 0.3940, kilograms per hectare Nitrate-nitrogen (NO3-N) inflow - **NO3NCODE** — varchar, enum NO3-N value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **C** — Value confirmed, contamination suspected (code use begins May 2007) - **NA_INPUT** — numeric(0.020000), range 0.0000 2.8400, kilograms per hectare Sodium inflow - **NACODE** — varchar, enum Na value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **K_INPUT** — numeric(0.020000), range 0.0000 1.4100, kilograms per hectare Potassium inflow - **KCODE** — varchar, enum K value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **CA_INPUT** — numeric(0.060000), range 0.0000 3.6300, kilograms per hectare Calcium inflow - **CACODE** — varchar, enum Ca value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **MG_INPUT** — numeric(0.020000), range 0.0000 1.1600, kilograms per hectare Magnesium inflow - **MGCODE** — varchar, enum Mg value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **SO4S_INPUT** — numeric(0.020000), range 0.0000 4.3800, kilograms per hectare SO4-S (sulfate-sulfur) inflow - **SO4SCODE** — varchar, enum SO4-S value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **CL_INPUT** — numeric(0.020000), range 0.0000 5.9700, kilograms per hectare Chloride inflow - **CLCODE** — varchar, enum Cl value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **DOC_INPUT** — numeric(0.020000), range 0.0000 7.4800, kilograms per hectare Dissolved organic carbon inflow - **DOCCODE** — varchar, enum DOC value qualifier code - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ## Entity 3: CP00203 ### Attribute list - **STCODE** — varchar, enum Study code - **CP002** — Study code CP002 - **ENTITY** — numeric(1.000000), range 3.0000 3.0000, number Entity number - **SITECODE** — varchar, enum Precipitation or dry deposition collector site code - **RCADMN** — Andrews Administrative Site rain collector (WS 9&10 RC) - **RCHI15** — Andrews original HI-15 rain collector - **RCHIR7** — Andrews Watershed 7 NADP-style rain collector - **RCHID7** — Andrews Watershed 7 NADP-style dry deposition collector - **RCHIF7** — Andrews Watershed 7 bulk collector - wet and dry deposition - **WATERYEAR** — numeric(1.000000), range 1969.0000 2018.0000, number Water year of sample or annual summary (October-September) - **PRECIP_YR** — numeric(0.250000), range 126.5900 331.0400, centimeters Total annual precipitation for the wateryear - **PCODE_YR** — varchar, enum Annual precipitation value qualifier code - **I** — Incomplete, parts of year missing from annual summary - **A** — All precipitation is included and not estimated for the wateryear - **E** — Total includes estimated precipitation values - **Q** — Precipitation total may be questionable for some periods of the wateryear - **PH_YR** — numeric(0.100000), range 4.6000 6.0000, pH units Mean annual pH - **PHCODE_YR** — varchar, enum Annual pH value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - **COND_YR** — numeric(0.400000), range 2.9000 15.2000, micro siemens per centimeter Mean annual specific conductivity concentration - **CONDCODE_YR** — varchar, enum Annual conductivity value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **ALK_YR** — numeric(0.020000), range 0.2100 2.5000, milligrams per liter Mean annual alkalinity concentration as CaCO3 (calcium carbonate) - all values have been converted from HCO3-C (bi-carbonate) - **ALKCODE_YR** — varchar, enum Annual alkalinity qualifier value code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **SSED_YR** — numeric(0.010000), range 0.0900 4.9400, milligrams per liter Mean annual suspended sediment concentratiom - **SSEDCODE_YR** — varchar, enum Annual suspended sediment value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - **SI_YR** — numeric(0.050000), range 0.0000 0.5200, milligrams per liter Mean annual silica concentration - **SICODE_YR** — varchar, enum Annual silica value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **UTP_YR** — numeric(0.002000), range 0.0000 0.0250, milligrams per liter Mean annual unfiltered total phosphorus concentration - **UTPCODE_YR** — varchar, enum Annual unfiltered total phosphorus value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **TDP_YR** — numeric(0.002000), range 0.0000 0.0210, milligrams per liter Mean annual total dissolved phosphorus concentration - **TDPCODE_YR** — varchar, enum Annual total dissolved phosphorus value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **PARTP_YR** — numeric(0.002000), range 0.0000 0.0140, milligrams per liter Mean annual particulate P - not measured analytically; mathematically determined by subtraction of Total Dissolved P (TDP) from Unfiltered Total P (UTP) - **PARTPCODE_YR** — varchar, enum Annual particulate P value qualifier code - **N** — No derived values are calculated for the entire water year - **D** — Annual value based on derived values - **D*** — Annual value based on derived values; one or more values measured below the detection limit - **DE** — Annual value based on derived values; one or more values estimated - **DQ** — Annual value based on derived values; one or more values questionable - **ID** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values - **ID*** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit - **IDE** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated - **IDQ** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable - **PO4P_YR** — numeric(0.001000), range 0.0000 0.0170, milligrams per liter Mean annual ortho phosphorus (PO4-P) concentration - **PO4PCODE_YR** — varchar, enum Annual ortho phosphorus value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **UTN_YR** — numeric(0.010000), range 0.0300 0.3500, milligrams per liter Mean annual total nitrogen concentration (unfiltered samples) - **UTNCODE_YR** — varchar, enum Annual unfiltered total nitrogen value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **D** — Annual value based on derived values - **D*** — Annual value based on derived values; one or more values measured below the detection limit - **DE** — Annual value based on derived values; one or more values estimated - **DQ** — Annual value based on derived values; one or more values questionable - **ID** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values - **ID*** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit - **IDE** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated - **IDQ** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable - **TDN_YR** — numeric(0.010000), range 0.0200 0.2200, milligrams per liter Mean annual total dissolved nitrogen concentration - **TDNCODE_YR** — varchar, enum Annual total dissolved nitrogen value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **D** — Annual value based on derived values - **D*** — Annual value based on derived values; one or more values measured below the detection limit - **DE** — Annual value based on derived values; one or more values estimated - **DQ** — Annual value based on derived values; one or more values questionable - **ID** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values - **ID*** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit - **IDE** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated - **IDQ** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable - **DON_YR** — numeric(0.010000), range 0.0000 0.1600, milligrams per liter Mean annual dissolved organic N concentration - not measured analytically; mathematically determined by subtracting NH3-N and NO3-N from Total dissolved nitrogen. Values before May 2005 are determined by TKN minus NH3-N - **DONCODE_YR** — varchar, enum Annual dissolved organic N value qualifier code - **N** — No derived values are calculated for the entire water year - **D** — Annual value based on derived values - **D*** — Annual value based on derived values; one or more values measured below the detection limit - **DE** — Annual value based on derived values; one or more values estimated - **DQ** — Annual value based on derived values; one or more values questionable - **ID** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values - **ID*** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit - **IDE** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated - **IDQ** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable - **PARTN_YR** — numeric(0.010000), range 0.0000 0.1300, milligrams per liter Mean annual particulate N concentration - not measured analytically; mathematically determined by subtraction of Total dissolved nitrogen (TDN) from Unfiltered Total nitrogen (UTN). Values before May 2005 are determined by UTKN minus TKN. - **PARTNCODE_YR** — varchar, enum Annual particulate N value qualifier code - **N** — No derived values are calculated for the entire water year - **D** — Annual value based on derived values - **D*** — Annual value based on derived values; one or more values measured below the detection limit - **DE** — Annual value based on derived values; one or more values estimated - **DQ** — Annual value based on derived values; one or more values questionable - **ID** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values - **ID*** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit - **IDE** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated - **IDQ** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable - **UTKN_YR** — numeric(0.010000), range 0.0200 0.3300, milligrams per liter Mean annual unfiltered total Kjeldahl nitrogen concentration - **UTKNCODE_YR** — varchar, enum Annual unfiltered total Kjeldahl nitrogen value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **TKN_YR** — numeric(0.010000), range 0.0100 0.2000, milligrams per liter Mean annual total Kjeldahl nitrogen concentration (dissolved) - **TKNCODE_YR** — varchar, enum Annual total Kjeldahl nitrogen value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **NH3N_YR** — numeric(0.003000), range 0.0000 0.0520, milligrams per liter Mean annual ammonia (NH3-N) concentration - **NH3NCODE_YR** — varchar, enum Annual NH3-N value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **NO3N_YR** — numeric(0.001000), range 0.0030 0.0520, milligrams per liter Mean annual nitrate-nitrogen (NO3-N) concentration - **NO3NCODE_YR** — varchar, enum Annual NO3-N value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **NA_YR** — numeric(0.010000), range 0.0600 0.6400, milligrams per liter Mean annual sodium concentration - **NACODE_YR** — varchar, enum Annual Na value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **K_YR** — numeric(0.030000), range 0.0100 0.2500, milligrams per liter Mean annual potassium concentration - **KCODE_YR** — varchar, enum Annual K value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **CA_YR** — numeric(0.060000), range 0.0200 0.3700, milligrams per liter Mean annual calcium concentration - **CACODE_YR** — varchar, enum Annual Ca value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **MG_YR** — numeric(0.020000), range 0.0200 0.1000, milligrams per liter Mean annual magnesium concentration - **MGCODE_YR** — varchar, enum Annual Mg value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **SO4S_YR** — numeric(0.020000), range 0.0200 0.4200, milligrams per liter Mean annual SO4-S (sulfate-sulfur) concentration - **SO4SCODE_YR** — varchar, enum Annual SO4-S value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **CL_YR** — numeric(0.010000), range 0.2000 1.6600, milligrams per liter Mean annual chloride concentration - **CLCODE_YR** — varchar, enum Annual Cl value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **DOC_YR** — numeric(0.050000), range 0.1000 1.4400, milligrams per liter Mean annual dissolved organic carbon concentration - **DOCCODE_YR** — varchar, enum Annual DOC value qualifier code - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ## Entity 4: CP00206 ### Attribute list - **STCODE** — varchar, enum Study code - **CP002** — Study code CP002 - **ENTITY** — numeric(1.000000), range 6.0000 6.0000, number Entity number - **SITECODE** — varchar, enum Precipitation or dry deposition collector site code - **RCADMN** — Andrews Administrative Site rain collector (WS 9&10 RC) - **RCHI15** — Andrews original HI-15 rain collector - **RCHIR7** — Andrews Watershed 7 NADP-style rain collector - **RCHID7** — Andrews Watershed 7 NADP-style dry deposition collector - **RCHIF7** — Andrews Watershed 7 bulk collector - wet and dry deposition - **WATERYEAR** — numeric(1.000000), range 1969.0000 2020.0000, number Water year of sample or annual summary (October-September) - **DATE_TIME** — datetime, freetext Collection date and time (PST) of the precipitation sample - sample represents deposition from the previous sample date and time. Assume beginning date of first sample period for each collector is October 1st. - **LABNO** — varchar, freetext Lab number code for sample - **TYPE** — varchar, enum Sample type indicator - indicates dry deposition samples and other qualifying information - **S** — Sample saved and combined with the following collection due to insufficient water for analyses - samples were no longer saved and combined after 1981 - **P** — Partial sample - precipitation was not collected successfully over the entire period (includes problems with NADP-style collector motor or samples that may have overflowed) - **YE** — Year end marker allows summary by water year - this is not a sample. Flux values are calculated from precip ending Sep 30 and use analyte concentrations from the following sample. 'YE' markers are inserted every Sep 30. - **C** — Sample is combined with preceeding saved sample(s) for analysis. Combined samples of this type are not used after 1981. - **DW** — Dry deposition sample - dry bucket contains rain water - **F** — Sample is successfully collected over the entire period - a "Full" sample. - **N** — No sample is collected - generally indicates periods of little or no rain, but can be a lost sample. - **DF** — Dry deposition sample - sample is dry and not contaminated with precipitation water - **B** — Biased sample - Lid on NADP sampler malfunctions and sample includes dry deposition - **DC** — Dry deposition sample - dry bucket contains rain water and other insects/contaminants - **QCCODE** — varchar, enum Quality control sample codes are assigned to samples collected for examining integrity of proportional sample analysis - **NA** — Water sample is not a quality control sample - **QZ** — Miscellaneous quality control water sample - **QA_SAMPLE** — varchar, freetext Quality assurance sample number assigned if sample water is further analyzed for internal laboratory purposes - **SAMPLER_TYPE** — varchar, enum Type of water sampler or method used to collect water - **BC** — Bulk collection includes both wet and dry deposition - **NP** — NADP-type sampler that separates wet deposition from dry deposition - **RC** — Bulk samples from original, locally-designed rain collectors that includes both wet and dry deposition - **LOW_VOLUME** — varchar, enum Indicator of a low volume sampler that may restrict the breadth of laboratory analyses - **N** — Sample is of sufficient volume for laboratory analyses - **Y** — Sample is low volume and laboratory analyses may be limited - **FIELD_COMMENTS** — varchar, freetext Field comments related to the collection of the water sample - **LAB_COMMENTS** — varchar, freetext Laboratory comments related to the handling and analyses of the sample - **SEQ_INDEX** — numeric(1.000000), range 1.0000 9233.0000, number Sequential index generated primarily by the temporal order in which samples are collected ## Attribute Definitions **ALK** Alkalinity as calcium carbonate (CaCO3); method: electrometric titration to pH 4.5; all data is converted from the formerly used units of bicarbonate carbon (HCO3-C) **ALKCODE** Alkalinity value qualifier code **ALKCODE_YR** Annual alkalinity qualifier value code **ALK_INPUT** Alkalinity inflow as CaCO3 (units have been converted for all values from bicarbonate (HCO3-C) to calcium carbonate) **ALK_YR** Mean annual alkalinity concentration as CaCO3 (calcium carbonate) - all values have been converted from HCO3-C (bi-carbonate) **ANCA** Anion-cation ratio: micro equivalence ratio of anions to cations by calculation - provided only as an analytical check. Requires anions: ALK, SO4S, CL, NO3N, PO4P, cations: pH, Na, K, Ca, Mg, NH4N **ANCACODE** Anion-cation ratio qualifier code **CA** Ca, dissolved calcium (filtrable) concentration; method flame atomic absorption spectroscopy **CACODE** Ca value qualifier code **CACODE_YR** Annual Ca value qualifier code **CA_INPUT** Calcium inflow **CA_YR** Mean annual calcium concentration **CL** Chloride (dissolved) concentration; method: ion chromatography (automated ferric thiocyanate before 1993) **CLCODE** Cl value qualifier code **CLCODE_YR** Annual Cl value qualifier code **CL_INPUT** Chloride inflow **CL_YR** Mean annual chloride concentration **COND** Specific conductance; method: wheatstone bridge **CONDCODE** Conductivity value qualifier code **CONDCODE_YR** Annual conductivity value qualifier code **COND_YR** Mean annual specific conductivity concentration **DATE_TIME** Collection date and time (PST) of the precipitation sample - sample represents deposition from the previous sample date and time. Assume beginning date of first sample period for each collector is October 1st. **DOC** DOC, dissolved organic carbon concentration; method: combustion **DOCCODE** DOC value qualifier code **DOCCODE_YR** Annual DOC value qualifier code **DOC_INPUT** Dissolved organic carbon inflow **DOC_YR** Mean annual dissolved organic carbon concentration **DON** Dissolved organic nitrogen - not measured analytically; mathematically determined by subtracting NH3-N and NO3-N from Total dissolved nitrogen. Values before May 2005 are determined by TKN minus NH3-N. **DONCODE** Dissolved organic nitrogen value qualifier code **DONCODE_YR** Annual dissolved organic N value qualifier code **DON_INPUT** Dissolved organic N inflow - not measured analytically; mathematically determined by subtracting NH3-N and NO3-N from Total dissolved nitrogen. Values before May 2005 are determined by TKN minus NH3-N **DON_YR** Mean annual dissolved organic N concentration - not measured analytically; mathematically determined by subtracting NH3-N and NO3-N from Total dissolved nitrogen. Values before May 2005 are determined by TKN minus NH3-N **ENTITY** Entity number **FIELD_COMMENTS** Field comments related to the collection of the water sample **K** K, dissolved potassium (filtrable) concentration; method flame atomic absorption spectroscopy **KCODE** K value qualifier code **KCODE_YR** Annual K value qualifier code **K_INPUT** Potassium inflow **K_YR** Mean annual potassium concentration **LABNO** Lab number code for sample **LAB_COMMENTS** Laboratory comments related to the handling and analyses of the sample **LOW_VOLUME** Indicator of a low volume sampler that may restrict the breadth of laboratory analyses **MG** Mg, dissolved magnesium (filtrable) concentration; method flame atomic absorption spectroscopy **MGCODE** Mg value qualifier code **MGCODE_YR** Annual Mg value qualifier code **MG_INPUT** Magnesium inflow **MG_YR** Mean annual magnesium concentration **NA** Na, dissolved sodium (filtrable) concentration; method flame atomic absorption spectroscopy **NACODE** Na value qualifier code **NACODE_YR** Annual Na value qualifier code **NA_INPUT** Sodium inflow **NA_YR** Mean annual sodium concentration **NH3N** Ammonia-nitrogen (NH3-N) concentration, ammonia as nitrogen; method: automated phenate **NH3NCODE** NH3-N value qualifier code **NH3NCODE_YR** Annual NH3-N value qualifier code **NH3N_INPUT** Ammonia-nitrogen (NH3-N) inflow **NH3N_YR** Mean annual ammonia (NH3-N) concentration **NO3N** Nitrate-nitrogen (NO3-N), nitrate + nitrite as nitrogen concentration; method: automated cadmium reduction **NO3NCODE** NO3-N value qualifier code **NO3NCODE_YR** Annual NO3-N value qualifier code **NO3N_INPUT** Nitrate-nitrogen (NO3-N) inflow **NO3N_YR** Mean annual nitrate-nitrogen (NO3-N) concentration **PARTN** Particulate N, also known as total suspended nitrogen - not measured analytically; mathematically determined by subtraction of Total dissolved nitrogen (TDN) from Unfiltered Total nitrogen (UTN). Values before May 2005 are determined by UTKN minus TKN. **PARTNCODE** Particulate N value qualifier code **PARTNCODE_YR** Annual particulate N value qualifier code **PARTN_INPUT** Particulate N inflow - not measured analytically; mathematically determined by subtraction of Total dissolved nitrogen (TDN) from Unfiltered Total nitrogen (UTN). Values before May 2005 are determined by UTKN minus TKN. **PARTN_YR** Mean annual particulate N concentration - not measured analytically; mathematically determined by subtraction of Total dissolved nitrogen (TDN) from Unfiltered Total nitrogen (UTN). Values before May 2005 are determined by UTKN minus TKN. **PARTP** Particulate P, also known as total suspended phosphorus - not measured analytically; mathematically determined by subtraction of Total Dissolved P (TDP) from Unfiltered Total P (UTP) **PARTPCODE** Particulate P value qualifier code **PARTPCODE_YR** Annual particulate P value qualifier code **PARTP_INPUT** Particulate P inflow - not measured analytically; mathematically determined by subtraction of Total Dissolved P (TDP) from Unfiltered Total P (UTP) **PARTP_YR** Mean annual particulate P - not measured analytically; mathematically determined by subtraction of Total Dissolved P (TDP) from Unfiltered Total P (UTP) **PCODE** Precipitation value qualifier code **PCODE_YR** Annual precipitation value qualifier code **PH** pH (hydrogen concentration); method: glass electrode **PHCODE** pH value qualifier code **PHCODE_YR** Annual pH value qualifier code **PH_YR** Mean annual pH **PO4P** Ortho phosphorus concentration, soluble reactive phosphorus, phosphate (PO4-P); method: ascorbic acid finish **PO4PCODE** Ortho phosphorus value qualifier code **PO4PCODE_YR** Annual ortho phosphorus value qualifier code **PO4P_INPUT** Ortho phosphorus (PO4-P) inflow **PO4P_YR** Mean annual ortho phosphorus (PO4-P) concentration **PRECIP_CM** Precipitation in centimeters for the exact sample period. Based on CS2MET (RCADMN) or H15MET (RCHIR7, RCHI15) meteorological station precipitation. **PRECIP_YR** Total annual precipitation for the wateryear **PVOL** Sample volume from precipitation collector; for dry deposition sample - includes any precipitation collected and DI water added to sample for analysis **PVOLCODE** Sample volume qualifier code **QA_SAMPLE** Quality assurance sample number assigned if sample water is further analyzed for internal laboratory purposes **QCCODE** Quality control sample codes are assigned to samples collected for examining integrity of proportional sample analysis **SAMPLER_TYPE** Type of water sampler or method used to collect water **SEQ_INDEX** Sequential index generated primarily by the temporal order in which samples are collected **SI** Silica as silicon concentration; method: automated molybdenum blue **SICODE** Silica value qualifier code **SICODE_YR** Annual silica value qualifier code **SITECODE** Precipitation or dry deposition collector site code **SI_INPUT** Silica inflow **SI_YR** Mean annual silica concentration **SO4S** SO4-S (dissolved) concentration, sulfate as sulfur; method ion chromatography (automated barium sulfate before 1993) **SO4SCODE** SO4-S value qualifier code **SO4SCODE_YR** Annual SO4-S value qualifier code **SO4S_INPUT** SO4-S (sulfate-sulfur) inflow **SO4S_YR** Mean annual SO4-S (sulfate-sulfur) concentration **SSED** Suspended sediment concentration; method: nonfiltrable residue, gravimetric **SSEDCODE** Suspended sediment value qualifier code **SSEDCODE_YR** Annual suspended sediment value qualifier code **SSED_INPUT** Suspended sediment inflow **SSED_YR** Mean annual suspended sediment concentratiom **STCODE** Study code **TDN** Total dissolved nitrogen concentration (filtered sample); method: persulfate digestion and analysis by automated colorimetric analysis; instrument: Technicon Auto-Analyzer II **TDNCODE** Total dissolved nitrogen value qualifier code **TDNCODE_YR** Annual total dissolved nitrogen value qualifier code **TDN_INPUT** Total dissolved nitrogen inflow (filtered sample) **TDN_YR** Mean annual total dissolved nitrogen concentration **TDP** Total dissolved phosphorus concentration; method: persulfate/H2SO4 digestion, ascorbic acid finish **TDPCODE** Total dissolved phosphorus value qualifier code **TDPCODE_YR** Annual total dissolved phosphorus value qualifier code **TDP_INPUT** Total dissolved phosphorus inflow **TDP_YR** Mean annual total dissolved phosphorus concentration **TKN** Total Kjeldahl nitrogen concentration on filtered sample (dissolved); method: Kjeldahl digestion H2SO4, CuSO4/KCl, nessler finish **TKNCODE** Total Kjeldahl nitrogen value qualifier code **TKNCODE_YR** Annual total Kjeldahl nitrogen value qualifier code **TKN_INPUT** Total Kjeldahl nitrogen (dissolved) inflow **TKN_YR** Mean annual total Kjeldahl nitrogen concentration (dissolved) **TYPE** Sample type indicator - indicates dry deposition samples and other qualifying information **UTKN** Total Kjeldahl nitrogen concentration on unfiltered sample; method: Kjeldahl digestion H2SO4, CuSO4/KCl, nessler finish **UTKNCODE** Unfiltered total Kjeldahl nitrogen value qualifier code **UTKNCODE_YR** Annual unfiltered total Kjeldahl nitrogen value qualifier code **UTKN_INPUT** Unfiltered total Kjeldahl nitrogen inflow **UTKN_YR** Mean annual unfiltered total Kjeldahl nitrogen concentration **UTN** Total nitrogen concentration (unfiltered sample); method: persulfate digestion and analysis by automated colorimetric analysis; instrument: Technicon Auto-Analyzer II **UTNCODE** Unfiltered total nitrogen value qualifier code **UTNCODE_YR** Annual unfiltered total nitrogen value qualifier code **UTN_INPUT** Total nitrogen inflow (unfiltered sample) **UTN_YR** Mean annual total nitrogen concentration (unfiltered samples) **UTP** Unfiltered total phosphorus concentration; method: persulfate/H2SO4 digestion, ascorbic acid finish **UTPCODE** Unfiltered total phosphorus value qualifier code **UTPCODE_YR** Annual unfiltered total phosphorus value qualifier code **UTP_INPUT** Unfiltered total phosphorus inflow **UTP_YR** Mean annual unfiltered total phosphorus concentration **WATERYEAR** Water year of sample or annual summary (October-September) ## Enumerated Domains ### STCODE - **CP002** — Study code CP002 ### SITECODE - **RCADMN** — Andrews Administrative Site rain collector (WS 9&10 RC) - **RCHI15** — Andrews original HI-15 rain collector - **RCHIR7** — Andrews Watershed 7 NADP-style rain collector - **RCHID7** — Andrews Watershed 7 NADP-style dry deposition collector - **RCHIF7** — Andrews Watershed 7 bulk collector - wet and dry deposition ### TYPE - **S** — Sample saved and combined with the following collection due to insufficient water for analyses - samples were no longer saved and combined after 1981 - **P** — Partial sample - precipitation was not collected successfully over the entire period (includes problems with NADP-style collector motor or samples that may have overflowed) - **YE** — Year end marker allows summary by water year - this is not a sample. Flux values are calculated from precip ending Sep 30 and use analyte concentrations from the following sample. 'YE' markers are inserted every Sep 30. - **C** — Sample is combined with preceeding saved sample(s) for analysis. Combined samples of this type are not used after 1981. - **DW** — Dry deposition sample - dry bucket contains rain water - **F** — Sample is successfully collected over the entire period - a "Full" sample. - **N** — No sample is collected - generally indicates periods of little or no rain, but can be a lost sample. - **DF** — Dry deposition sample - sample is dry and not contaminated with precipitation water - **B** — Biased sample - Lid on NADP sampler malfunctions and sample includes dry deposition - **DC** — Dry deposition sample - dry bucket contains rain water and other insects/contaminants ### PCODE - **N** — No precipitation recorded for period. For saved sample (type='S'), precipitation for this period is included in the following period. - **E** — Estimated precipitation - **A** — Accepted value for precipitation - **Q** — Precipitation value is questionable - **M** — Missing value ### PHCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - **Q** — Value is questionable (used beginning in 1991) ### CONDCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### ALKCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### SSEDCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - **Q** — Value is questionable (used beginning in 1991) ### SICODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### UTPCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### TDPCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### PARTPCODE - **N** — No derived value is calculated due to missing analytical components - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values ### PO4PCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### UTNCODE - **A** — Accepted value - **E** — Estimated value - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **N** — No analytical measurement or no derived value calculated due to missing analytical components ### TDNCODE - **A** — Accepted value - **E** — Estimated value - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values - **N** — No analytical measurement or no derived value calculated due to missing analytical components ### DONCODE - **N** — No derived value is calculated due to missing analytical components - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values ### PARTNCODE - **N** — No derived value is calculated due to missing analytical components - **D** — Derived value - mathematically determined from other analytical measurements - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values ### UTKNCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### TKNCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### NH3NCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **C** — Value confirmed, contamination suspected (code use begins May 2007) ### NO3NCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) - **C** — Value confirmed, contamination suspected (code use begins May 2007) ### NACODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### KCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### CACODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### MGCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### SO4SCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### CLCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### DOCCODE - **A** — Accepted value - **E** — Estimated value - **N** — No analytical measurement - ***** — Value is below detection limit for analysis (used beginning in 1991) - **Q** — Value is questionable (used beginning in 1991) ### PVOLCODE - **Q** — Sample volume value is questionable - typically implies volume is measured correctly, but volume does not represent the entire collection period - **N** — No sample volume value available - **A** — Accepted value - **K** — Volume is precipitation plus added DIW (usually 250 ml). concentration values are based on this volume. - **L** — Volume of lab water (DIW) added to dry bucket (usually 250 ml). concentration values are based on this volume. - **M** — Volume is precipitation in dry bucket (liters). Concentration values are based on this volume. No DIW added to the precipitation water. ### ANCACODE - **N** — No anion-cation ratio calculation determined due to missing analytical components - **D** — Derived anion-cation ratio value is based on the full set of anions and cations - **D*** — Derived value - mathematically determined from other analytical measurements, one or more of which were below the detection limit - **DE** — Derived value - mathematically determined from other analytical measurements, one or more of which were estimated values - **DQ** — Derived value - mathematically determined from other analytical measurements, one or more of which were questionable values ### PCODE_YR - **I** — Incomplete, parts of year missing from annual summary - **A** — All precipitation is included and not estimated for the wateryear - **E** — Total includes estimated precipitation values - **Q** — Precipitation total may be questionable for some periods of the wateryear ### PHCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable ### CONDCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### ALKCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### SSEDCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable ### SICODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### UTPCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### TDPCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### PARTPCODE_YR - **N** — No derived values are calculated for the entire water year - **D** — Annual value based on derived values - **D*** — Annual value based on derived values; one or more values measured below the detection limit - **DE** — Annual value based on derived values; one or more values estimated - **DQ** — Annual value based on derived values; one or more values questionable - **ID** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values - **ID*** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit - **IDE** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated - **IDQ** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable ### PO4PCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### UTNCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **D** — Annual value based on derived values - **D*** — Annual value based on derived values; one or more values measured below the detection limit - **DE** — Annual value based on derived values; one or more values estimated - **DQ** — Annual value based on derived values; one or more values questionable - **ID** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values - **ID*** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit - **IDE** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated - **IDQ** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable ### TDNCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit - **D** — Annual value based on derived values - **D*** — Annual value based on derived values; one or more values measured below the detection limit - **DE** — Annual value based on derived values; one or more values estimated - **DQ** — Annual value based on derived values; one or more values questionable - **ID** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values - **ID*** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit - **IDE** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated - **IDQ** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable ### DONCODE_YR - **N** — No derived values are calculated for the entire water year - **D** — Annual value based on derived values - **D*** — Annual value based on derived values; one or more values measured below the detection limit - **DE** — Annual value based on derived values; one or more values estimated - **DQ** — Annual value based on derived values; one or more values questionable - **ID** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values - **ID*** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit - **IDE** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated - **IDQ** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable ### PARTNCODE_YR - **N** — No derived values are calculated for the entire water year - **D** — Annual value based on derived values - **D*** — Annual value based on derived values; one or more values measured below the detection limit - **DE** — Annual value based on derived values; one or more values estimated - **DQ** — Annual value based on derived values; one or more values questionable - **ID** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values - **ID*** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values measured below the detection limit - **IDE** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are estimated - **IDQ** — Annual value incomplete; one or more values are missing for part of the year; annual value based on derived values of which one or more values are questionable ### UTKNCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### TKNCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### NH3NCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### NO3NCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### NACODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### KCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### CACODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### MGCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### SO4SCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### CLCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### DOCCODE_YR - **Q** — Annual value includes questionable values - **N** — No analyses conducted in water year - **A** — Annual value is accepted - **E** — Annual value includes estimated values - **I** — Annual value incomplete; one or more values are missing for part of the year - **I*** — Annual value incomplete; one or more values are missing for part of the year; one or more values measured below the detection limit - **IE** — Annual value incomplete; one or more values are missing for part of the year; one or more values estimated - **IQ** — Annual value incomplete; one or more values are missing for part of the year; one or more values questionable - ***** — Annual value includes one or more values measured below the detection limit ### QCCODE - **NA** — Water sample is not a quality control sample - **QZ** — Miscellaneous quality control water sample ### SAMPLER_TYPE - **BC** — Bulk collection includes both wet and dry deposition - **NP** — NADP-type sampler that separates wet deposition from dry deposition - **RC** — Bulk samples from original, locally-designed rain collectors that includes both wet and dry deposition ### LOW_VOLUME - **N** — Sample is of sufficient volume for laboratory analyses - **Y** — Sample is low volume and laboratory analyses may be limited