I. Data Set Descriptors A. Title: Gage data from benchmark stations at the Andrews Experimental Forest (GSWS06) from 01-Oct-2015 to 01-Oct-2016 B. Accession Number: N/A C. Description 1. Originator(s): Sherri L. Johnson 2. Abstract: Stream temperature at stream gages and air temperature above the stream are measured at all stream gaging sites and at selected major stream confluences. Current temperature data are collected as hourly averages of instantaneous measurements. these data began ~1996. Historic data, starting in 1950 at Lookout Creek gage, are included at daily mean or maximum and minimum. 3. Study Type: 4. Study Themes: 5. LTER Core Areas: 6. Georeferences: 7. Submission Date: D. Keywords: II. Research Origin Descriptors A. Overall Project Description 1. Project Title: 2. Principal Investigators: Stanley V. Gregory, Christopher Daly, Randall C. Wildman, Julia A. Jones, Jeffrey J. McDonnell 3. Funding Period: to 4. Objectives: 5. Abstract: 6. Funding Source: B. Sub-project Description 1. Site Description a. Geographic Location: Coordinates: b. Physiographic Region: c. Landform Components: d. Hydrographic Characteristics: e. Topographic Attributes: f. Geology, Lithology and Soils: g. Vegetation Communities: h. History of Land Use and Disturbance: i. Climate: 2. Experimental or Sampling Design a. Design Characteristics: b. Permanent Plots: c. Data Collection Duration and Frequency: Beginning of Observations: End of Observations: 3. Research Methods a. Field and Laboratory Methods: b. Protocols: c. Instrumentation: d. Taxonomy and Systematics: e. Speclies List: f. Permit History: 4. Project Personnel a. Personnel: b. Affiliations: III. Data Set Status and Accessibility A. Status 1. Latest Update: 15-Nov-2023 2. Latest Archive Date: 3. Latest Metadata Update: 15-Nov-2023 4. Data Verification Status: B. Accessibility 1. Storage Location and Medium: Stored at on media: 2. Contact Person: Name: Position: Organization: Address: City: State: Postal Code: Phone: Email: UserID: 3. Copyright Restrictions: 4. Restrictions: a. Release Date: Affiliates: , Public: b. Citation: c. Disclaimer: 5. Costs: IV. Data Structural Descriptors A. Data Set File 1. File Name: gsws06_118_5min_2016.csv 2. Size: 105408 records 3. File Format: ASCII text (comma-separated value format) 3a. Delimiters: single comma 4. Header Information: 5 lines of ASCII text 5. Alphanumeric Attributes: 6. Quality Control Flag Codes: Q = questionable value, I = invalid value (out of range), E = data value estimated by interpolation 7. Authentication Procedures: 8. Calculations: EC_INST_0_0_01: EC_INST_0_0_01(microS/cm) = EC_INST_0_0_01(cmS cm^-1)*1000 9. Processing History: Software version: GCE Data Toolbox Version 3.9.10 (23-May-2022) Data structure version: GCE Data Structure 1.1 (29-Mar-2001) Original data files processed: metdat query: SELECT * FROM WS06_118_Table105 WHERE LOGGERID = 118 AND TmStamp BETWEEN '2015-10-01 00:05:00.0' AND '2016-10-01 00:00:00.0' ORDER BY TmStamp ASC (105404 records) sigma_airtemp_gaged_streams_leap_ak.csv (8784 records) FINAL_GAGE_WATTEMP_leap_ak.csv (8784 records) Data processing history: 15-Nov-2023: new GCE Data Structure 1.1 created ('newstruct') 15-Nov-2023: imported result set from SQL query on data source 'metdat' ('sql2struct') 15-Nov-2023: imported all documentation metadata from the template 'LNDB_GsWS06_3', updating descriptors for columns Date, RecNum, SiteID, LOGGERID, PROGID, VNOTCH_INST_0_0_01, STAGE_INST_0_0_01, EC_INST_0_0_01, WATERTEMP_INST_0_0_01, AIRTEMP_MEAN_150_0_01, AIRTEMP_MAX_150_0_01, AIRTEMP_MIN_150_0_01, WATERTEMP_MEAN_0_0_01, WATERTEMP_MAX_0_0_01, WATERTEMP_MIN_0_0_01 and BATTERY_INST_0_0_01 ('meta_template') 15-Nov-2023: updated 6 metadata fields in the Data, Dataset, Project, Status section(s) ('addmeta') 15-Nov-2023: updated title ('newtitle') 15-Nov-2023: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 15-Nov-2023: added column 'Site' at position 1 ('addcol') 15-Nov-2023: sorted by column Date(ascending) ('sortdata') 15-Nov-2023: removed 12 row(s) with duplicate values in the column(s) Date ('cleardupes') 15-Nov-2023: inserted 16 new records with date/time values and NaN/null data values (replicating common values in the non-data columns Site, RecNum, LOGGERID and PROGID) to fill in date/time interval gaps in the data series and assigned flag 'M' to inserted records ('pad_date_gaps') 15-Nov-2023: sorted by column Date(ascending) ('sortdata') 15-Nov-2023: Year, Month, Day, Hour and Minute datetime columns added after column Date ('add_datepartcols') 15-Nov-2023: sorted by columns Month(ascending), Day(ascending), Hour(ascending) ('sortdata') 15-Nov-2023: performed a lookup join of columns Month, Day and Hour on columns Month, Day and Hour from a second structure, returning column(s) Site, Date, Year, Minute, RecNum, SiteID, LOGGERID, PROGID, VNOTCH_INST_0_0_01, STAGE_INST_0_0_01, EC_INST_0_0_01, WATERTEMP_INST_0_0_01, AIRTEMP_MEAN_150_0_01, AIRTEMP_MAX_150_0_01, AIRTEMP_MIN_150_0_01, WATERTEMP_MEAN_0_0_01, WATERTEMP_MAX_0_0_01, WATERTEMP_MIN_0_0_01 and BATTERY_INST_0_0_01 from the first structure and column(s) air_TWOLO, air_TWOHI, air_THREELO, air_THREEHI, air_FOURLO, air_FOURHI, water_TWOLO, water_TWOHI, water_THREELO, water_THREEHI, water_FOURLO and water_FOURHI from the second structure (105408 rows) ('joindata') 15-Nov-2023: sorted by column Date(ascending) ('sortdata') 15-Nov-2023: imported all documentation metadata from the template 'LNDB_GsWS06_3', updating descriptors for columns Site, Date, RecNum, SiteID, LOGGERID, PROGID, VNOTCH_INST_0_0_01, STAGE_INST_0_0_01, EC_INST_0_0_01, WATERTEMP_INST_0_0_01, AIRTEMP_MEAN_150_0_01, AIRTEMP_MAX_150_0_01, AIRTEMP_MIN_150_0_01, WATERTEMP_MEAN_0_0_01, WATERTEMP_MAX_0_0_01, WATERTEMP_MIN_0_0_01 and BATTERY_INST_0_0_01 ('meta_template') 15-Nov-2023: updated 6 metadata fields in the Data, Dataset, Project, Status section(s) ('addmeta') 15-Nov-2023: updated title ('newtitle') 15-Nov-2023: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 15-Nov-2023: Q/C Criteria of column Site changed from 'manual' to ''; Q/C Criteria of column Date changed from 'x<0='I';manual' to 'x<0='I''; Q/C Criteria of column RecNum changed from 'x<0='I';manual' to 'x<0='I''; Q/C Criteria of column SiteID changed from 'manual' to ''; Q/C Criteria of column LOGGERID changed from 'flag_notinarray(x,[106,118])='Q';manual' to 'flag_notinarray(x,[101,115])='I''; Q/C Criteria of column VNOTCH_INST_0_0_01 changed from 'x>1='I';x<0='I';manual' to 'x>1='I';x<0='I''; Q/C Criteria of column STAGE_INST_0_0_01 changed from 'isnan(x)='M';manual' to 'isnan(x)='M''; Q/C Criteria of column AIRTEMP_MEAN_150_0_01 changed from 'x<-35='I';x>55='I';isnan(x)='M';xcol_air_FOURHI='Q';(col_AIRTE MP_MAX_150_0_01-col_AIRTEMP_MEAN_150_0_01)>1='Q'; (col_AIRTEMP_MEAN_150_0_01-col_AIRTEMP_MIN_150_0_01)>1='Q'; x>col_AIRTEMP_MAX_150_0_01='I'; x55='I';isnan(x)='M';(col_AIRTEMP_MAX_150_0_01-col_AIRTEMP_MEAN_150_0_01) >1='Q'; (col_AIRTEMP_MEAN_150_0_01-col_AIRTEMP_MIN_150_0_01)>1='Q'; x>col_AIRTEMP_MAX_150_0_01='I'; x55='I';isnan(x)='M';xcol_air_FOURHI='Q';manual' to 'x<-35='I';x>55='I';isnan(x)='M';xcol_air_FOURHI='Q''; Q/C Criteria of column AIRTEMP_MIN_150_0_01 changed from 'x<-35='I';x>55='I';isnan(x)='M';xcol_air_FOURHI='Q';manual' to 'x<-35='I';x>55='I';isnan(x)='M';xcol_air_FOURHI='Q''; Q/C Criteria of column WATERTEMP_MEAN_0_0_01 changed from 'x<-2='I';x>30='I';x<-1='Q';x>21='Q';isnan(x)='M';xcol_water_ FOURHI='Q';(col_WATERTEMP_MAX_0_0_01-col_WATERTEMP_MEAN_0_0_01)>1='Q'; (col_WATERTEMP_MEAN_0_0_01-col_WATERTEMP_MIN_0_0_01)>1='Q'; x>col_WATERTEMP_MAX_0_0_01='I'; x30='I';x<-1='Q';x>21='Q';isnan(x)='M';(col_WATERTEMP_MAX_0_0_01-col_WATER TEMP_MEAN_0_0_01)>1='Q'; (col_WATERTEMP_MEAN_0_0_01-col_WATERTEMP_MIN_0_0_01)>1='Q'; x>col_WATERTEMP_MAX_0_0_01='I'; x30='I';x<-1='Q';x>21='Q';isnan(x)='M';xcol_water_ FOURHI='Q';manual' to 'x<-2='I';x>30='I';x<-1='Q';x>21='Q';isnan(x)='M';xcol_water_ FOURHI='Q''; Q/C Criteria of column WATERTEMP_MIN_0_0_01 changed from 'x<-2='I';x>30='I';x<-1='Q';x>21='Q';isnan(x)='M';xcol_water_ FOURHI='Q';manual' to 'x<-2='I';x>30='I';x<-1='Q';x>21='Q';isnan(x)='M';xcol_water_ FOURHI='Q''; Q/C Criteria of column BATTERY_INST_0_0_01 changed from 'x<0='I';x<12='L';x>15='H';manual' to 'x<0='I';x<12='L';x>15='H''; ('apply_template') 15-Nov-2023: Precision of column AIRTEMP_MEAN_150_0_01 changed from 3 to 2; Precision of column WATERTEMP_MEAN_0_0_01 changed from 3 to 2; ('apply_template') 15-Nov-2023: Description of column AIRTEMP_MEAN_150_0_01 edited; ('apply_template') 15-Nov-2023: deleted columns Month, Day, Hour, Year, Minute, air_TWOLO, air_TWOHI, air_THREELO, air_THREEHI, water_TWOLO, water_TWOHI, water_THREELO and water_THREEHI from the structure ('deletecols') 15-Nov-2023: converted values in all columns assigned QA/QC flag(s) I (invalid value (out of range)) to NaN/empty, locking and replacing existing flags with 'M': 105408 records in LOGGERID, 2374 records in EC_INST_0_0_01 ('nullflags') 15-Nov-2023: sorted by column Date(ascending) ('sortdata') 15-Nov-2023: updated 1 metadata fields in the Data section(s) ('addmeta') 15-Nov-2023: replaced 4 missing values in column STAGE_INST_0_0_01 with estimated values based on 1D interpolation of STAGE_INST_0_0_01 as a function of Date using the MATLAB 9.912 function 'interp1' with the 'linear' (linear interpolation) method option, excluding data gaps with more than 5 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 15-Nov-2023: 4 values in 'STAGE_INST_0_0_01' were updated with new values ('update_data'): changed record 68439 from NaN to 0.0830, changed record 68440 from NaN to 0.0830, changed record 68441 from NaN to 0.0830, changed record 68442 from NaN to 0.0830 15-Nov-2023: Q/C flagging criteria applied for column(s) STAGE_INST_0_0_01, 'flags' field updated ('dataflag') 15-Nov-2023: replaced 9 missing values in column EC_INST_0_0_01 with estimated values based on 1D interpolation of EC_INST_0_0_01 as a function of Date using the MATLAB 9.912 function 'interp1' with the 'linear' (linear interpolation) method option, excluding data gaps with more than 5 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 15-Nov-2023: 9 values in 'EC_INST_0_0_01' were updated with new values ('update_data'): changed record 13740 from NaN to 0.0345, changed record 32143 from NaN to 0.0495, changed record 68439 from NaN to 0.0411, changed record 68440 from NaN to 0.0411, changed record 68441 from NaN to 0.0412, changed record 68442 from NaN to 0.0412, changed record 102377 from NaN to 0.0424, changed record 102378 from NaN to 0.0427, changed record 102379 from NaN to 0.0430 15-Nov-2023: Q/C flagging criteria applied for column(s) EC_INST_0_0_01, 'flags' field updated ('dataflag') 15-Nov-2023: replaced 4 missing values in column WATERTEMP_INST_0_0_01 with estimated values based on 1D interpolation of WATERTEMP_INST_0_0_01 as a function of Date using the MATLAB 9.912 function 'interp1' with the 'linear' (linear interpolation) method option, excluding data gaps with more than 5 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 15-Nov-2023: 4 values in 'WATERTEMP_INST_0_0_01' were updated with new values ('update_data'): changed record 68439 from NaN to 8.220, changed record 68440 from NaN to 8.220, changed record 68441 from NaN to 8.220, changed record 68442 from NaN to 8.220 15-Nov-2023: Q/C flagging criteria applied for column(s) WATERTEMP_INST_0_0_01, 'flags' field updated ('dataflag') 15-Nov-2023: replaced 4 missing values in column AIRTEMP_MEAN_150_0_01 with estimated values based on 1D interpolation of AIRTEMP_MEAN_150_0_01 as a function of Date using the MATLAB 9.912 function 'interp1' with the 'linear' (linear interpolation) method option, excluding data gaps with more than 5 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 15-Nov-2023: 4 values in 'AIRTEMP_MEAN_150_0_01' were updated with new values ('update_data'): changed record 68439 from NaN to 10.63, changed record 68440 from NaN to 10.62, changed record 68441 from NaN to 10.60, changed record 68442 from NaN to 10.59 15-Nov-2023: Q/C flagging criteria applied for column(s) AIRTEMP_MEAN_150_0_01, 'flags' field updated ('dataflag') 15-Nov-2023: replaced 4 missing values in column WATERTEMP_MEAN_0_0_01 with estimated values based on 1D interpolation of WATERTEMP_MEAN_0_0_01 as a function of Date using the MATLAB 9.912 function 'interp1' with the 'linear' (linear interpolation) method option, excluding data gaps with more than 5 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 15-Nov-2023: 4 values in 'WATERTEMP_MEAN_0_0_01' were updated with new values ('update_data'): changed record 68439 from NaN to 8.22, changed record 68440 from NaN to 8.22, changed record 68441 from NaN to 8.22, changed record 68442 from NaN to 8.22 15-Nov-2023: Q/C flagging criteria applied for column(s) WATERTEMP_MEAN_0_0_01, 'flags' field updated ('dataflag') 15-Nov-2023: copied QA/QC flags from column(s) WATERTEMP_INST_0_0_01 to column(s) WATERTEMP_MEAN_0_0_01, WATERTEMP_MAX_0_0_01 and WATERTEMP_MIN_0_0_01, merging copied flags with any existing flags, and set QA/QC criteria for destination column(s) to 'manual' ('copyflags') 15-Nov-2023: copied QA/QC flags from column(s) AIRTEMP_MEAN_150_0_01 to column(s) AIRTEMP_MAX_150_0_01 and AIRTEMP_MIN_150_0_01, merging copied flags with any existing flags, and set QA/QC criteria for destination column(s) to 'manual' ('copyflags') 15-Nov-2023: deleted column RecNum from the structure ('deletecols') 15-Nov-2023: documented flagged and missing values in columns SiteID, LOGGERID, PROGID, VNOTCH_INST_0_0_01, STAGE_INST_0_0_01, EC_INST_0_0_01, WATERTEMP_INST_0_0_01, AIRTEMP_MEAN_150_0_01, AIRTEMP_MAX_150_0_01, AIRTEMP_MIN_150_0_01, WATERTEMP_MEAN_0_0_01, WATERTEMP_MAX_0_0_01, WATERTEMP_MIN_0_0_01 and BATTERY_INST_0_0_01 as data set anomalies in the metadata ('add_anomalies') 15-Nov-2023: updated title ('newtitle') 15-Nov-2023: updated 1 metadata fields in the Dataset section(s) ('addmeta') 15-Nov-2023: updated title ('newtitle') 15-Nov-2023: updated 1 metadata fields in the Dataset section(s) ('addmeta') 15-Nov-2023: converted units of 'EC_INST_0_0_01' column and 2 QA/QC flag criteria parameters from cmS cm^-1 to microS/cm ('unit_convert') 15-Nov-2023: Q/C flagging criteria applied for column(s) EC_INST_0_0_01, 'flags' field updated ('dataflag') 15-Nov-2023: deleted columns air_FOURHI, air_FOURLO, water_FOURHI and water_FOURLO from the structure ('deletecols') 15-Nov-2023: deleted column Date from the structure ('deletecols') 15-Nov-2023: added column 'Date' at position 2 ('addcol') 15-Nov-2023: flags for columns SiteID, VNOTCH_INST_0_0_01, STAGE_INST_0_0_01, EC_INST_0_0_01, WATERTEMP_INST_0_0_01, AIRTEMP_MEAN_150_0_01, AIRTEMP_MAX_150_0_01, AIRTEMP_MIN_150_0_01, WATERTEMP_MEAN_0_0_01, WATERTEMP_MAX_0_0_01, WATERTEMP_MIN_0_0_01 and BATTERY_INST_0_0_01 converted to data columns, flag codes updated in metadata ('flags2cols') 15-Nov-2023: updated 6 metadata fields in the Data section(s) ('addmeta') 15-Nov-2023: updated 15 metadata fields in the Status, Data sections to reflect attribute metadata ('updatecols') 15-Nov-2023: parsed and formatted metadata ('listmeta') B. Variable Information 1. Variable Name: column 1. Site column 2. Date column 3. SiteID column 4. Flag_SiteID column 5. LOGGERID column 6. PROGID column 7. VNOTCH_INST_0_0_01 column 8. Flag_VNOTCH_INST_0_0_01 column 9. STAGE_INST_0_0_01 column 10. Flag_STAGE_INST_0_0_01 column 11. EC_INST_0_0_01 column 12. Flag_EC_INST_0_0_01 column 13. WATERTEMP_INST_0_0_01 column 14. Flag_WATERTEMP_INST_0_0_01 column 15. AIRTEMP_MEAN_150_0_01 column 16. Flag_AIRTEMP_MEAN_150_0_01 column 17. AIRTEMP_MAX_150_0_01 column 18. Flag_AIRTEMP_MAX_150_0_01 column 19. AIRTEMP_MIN_150_0_01 column 20. Flag_AIRTEMP_MIN_150_0_01 column 21. WATERTEMP_MEAN_0_0_01 column 22. Flag_WATERTEMP_MEAN_0_0_01 column 23. WATERTEMP_MAX_0_0_01 column 24. Flag_WATERTEMP_MAX_0_0_01 column 25. WATERTEMP_MIN_0_0_01 column 26. Flag_WATERTEMP_MIN_0_0_01 column 27. BATTERY_INST_0_0_01 column 28. Flag_BATTERY_INST_0_0_01 2. Variable Definition: column 1. Site code column 2. Round off corrected corrected serial date column 3. SiteID column 4. QA/QC flags for SiteID (flagging criteria, where "x" is SiteID: ) column 5. Logger ID column 6. Program ID column 7. Binary indicator for V-notch. 1 = on, 0 = off column 8. QA/QC flags for Binary indicator for V-notch. 1 = on, 0 = off (flagging criteria, where "x" is VNOTCH_INST_0_0_01: x>1="I", x<0="I") column 9. Stage height column 10. QA/QC flags for Stage height (flagging criteria, where "x" is STAGE_INST_0_0_01: isnan(x)="M", manual) column 11. Conductivity column 12. QA/QC flags for Conductivity (flagging criteria, where "x" is EC_INST_0_0_01: x<=5="I", x>=7000="I", isnan(x)="M", Date>=datenum("11/28/2020 06:25:00")&Date<=datenum("12/03/2020 12:00:00")="I", manual) column 13. Average temperature of water from EC column 14. QA/QC flags for Average temperature of water from EC (flagging criteria, where "x" is WATERTEMP_INST_0_0_01: x<-2="I", x>30="I", x<-1="Q", x>21="Q", isnan(x)="M", xwater_FOURHI="Q", (WATERTEMP_MAX_0_0_01-WATERTEMP_INST_0_0_01)>0.5="Q", (WATERTEMP_INST_0_0_01-WATERTEMP_MIN_0_0_01)>0.5="Q", x>WATERTEMP_MAX_0_0_01="I", x55="I", isnan(x)="M", (AIRTEMP_MAX_150_0_01-AIRTEMP_MEAN_150_0_01)>1="Q", (AIRTEMP_MEAN_150_0_01-AIRTEMP_MIN_150_0_01)>1="Q", x>AIRTEMP_MAX_150_0_01="I", x55="I", isnan(x)="M", xair_FOURHI="Q", manual) column 19. Minimum air temperature (240) column 20. QA/QC flags for Minimum air temperature (240) (flagging criteria, where "x" is AIRTEMP_MIN_150_0_01: x<-35="I", x>55="I", isnan(x)="M", xair_FOURHI="Q", manual) column 21. Average water temperature from EC column 22. QA/QC flags for Average water temperature from EC (flagging criteria, where "x" is WATERTEMP_MEAN_0_0_01: x<-2="I", x>30="I", x<-1="Q", x>21="Q", isnan(x)="M", (WATERTEMP_MAX_0_0_01-WATERTEMP_MEAN_0_0_01)>1="Q", (WATERTEMP_MEAN_0_0_01-WATERTEMP_MIN_0_0_01)>1="Q", x>WATERTEMP_MAX_0_0_01="I", x30="I", x<-1="Q", x>21="Q", isnan(x)="M", xwater_FOURHI="Q", manual) column 25. Minimum water temperature from EC column 26. QA/QC flags for Minimum water temperature from EC (flagging criteria, where "x" is WATERTEMP_MIN_0_0_01: x<-2="I", x>30="I", x<-1="Q", x>21="Q", isnan(x)="M", xwater_FOURHI="Q", manual) column 27. Battery supply level column 28. QA/QC flags for Battery supply level (flagging criteria, where "x" is BATTERY_INST_0_0_01: x<0="I", x<12="L", x>15="H") 3. Units of Measurement: column 1. column 2. yyyy-MM-dd HH:mm:ss column 3. column 4. none column 5. none column 6. none column 7. none column 8. none column 9. ft column 10. none column 11. microS/cm column 12. none column 13. deg c column 14. none column 15. deg c column 16. none column 17. deg c column 18. none column 19. deg c column 20. none column 21. deg c column 22. none column 23. deg c column 24. none column 25. deg c column 26. none column 27. volts column 28. none 4. Data Type a. Storage Type: column 1. string column 2. string column 3. floating-point column 4. string column 5. integer column 6. floating-point column 7. integer column 8. string column 9. floating-point column 10. string column 11. floating-point column 12. string column 13. floating-point column 14. string column 15. floating-point column 16. string column 17. floating-point column 18. string column 19. floating-point column 20. string column 21. floating-point column 22. string column 23. floating-point column 24. string column 25. floating-point column 26. string column 27. floating-point column 28. string b. Variable Codes: Flag_STAGE_INST_0_0_01: E = data value estimated by interpolation, M = unspecified Flag_EC_INST_0_0_01: E = data value estimated by interpolation, M = unspecified Flag_WATERTEMP_INST_0_0_01: E = data value estimated by interpolation, M = unspecified, Q = questionable value Flag_AIRTEMP_MEAN_150_0_01: E = data value estimated by interpolation, M = unspecified Flag_AIRTEMP_MAX_150_0_01: E = data value estimated by interpolation, M = unspecified, Q = questionable value Flag_AIRTEMP_MIN_150_0_01: E = data value estimated by interpolation, M = unspecified, Q = questionable value Flag_WATERTEMP_MEAN_0_0_01: E = data value estimated by interpolation, M = unspecified, Q = questionable value Flag_WATERTEMP_MAX_0_0_01: E = data value estimated by interpolation, M = unspecified, Q = questionable value Flag_WATERTEMP_MIN_0_0_01: E = data value estimated by interpolation, M = unspecified, Q = questionable value c. Numeric Range: column 1. (none) column 2. (none) column 3. 106 to 106 column 4. (none) column 5. (none) column 6. 25093 to 54558 column 7. 0 to 1 column 8. (none) column 9. 0.007 to 0.845 column 10. (none) column 11. 11 to 184 column 12. (none) column 13. 3.534 to 20.91 column 14. (none) column 15. -7.484 to 28.49 column 16. (none) column 17. -7.456 to 28.66 column 18. (none) column 19. -7.496 to 28.46 column 20. (none) column 21. 3.845 to 20.87 column 22. (none) column 23. 3.86 to 20.91 column 24. (none) column 25. 3.284 to 20.84 column 26. (none) column 27. 12.28 to 14.47 column 28. (none) d. Missing Value Code: NaN 5. Data Format a. Column Type: column 1. text column 2. text column 3. numerical column 4. text column 5. numerical column 6. numerical column 7. numerical column 8. text column 9. numerical column 10. text column 11. numerical column 12. text column 13. numerical column 14. text column 15. numerical column 16. text column 17. numerical column 18. text column 19. numerical column 20. text column 21. numerical column 22. text column 23. numerical column 24. text column 25. numerical column 26. text column 27. numerical column 28. text b. Number of Columns: 28 c. Decimal Places: column 1. 0 column 2. 0 column 3. 2 column 4. 0 column 5. 0 column 6. 1 column 7. 0 column 8. 0 column 9. 4 column 10. 0 column 11. 4 column 12. 0 column 13. 3 column 14. 0 column 15. 2 column 16. 0 column 17. 3 column 18. 0 column 19. 3 column 20. 0 column 21. 2 column 22. 0 column 23. 3 column 24. 0 column 25. 3 column 26. 0 column 27. 2 column 28. 0 6. Logical Variable Type: column 1. nominal (none) column 2. datetime (none) column 3. data (unspecified) column 4. coded value (none) column 5. nominal (discrete) column 6. nominal (continuous) column 7. data (discrete) column 8. coded value (none) column 9. data (continuous) column 10. coded value (none) column 11. data (continuous) column 12. coded value (none) column 13. data (continuous) column 14. coded value (none) column 15. data (continuous) column 16. coded value (none) column 17. data (continuous) column 18. coded value (none) column 19. data (continuous) column 20. coded value (none) column 21. data (continuous) column 22. coded value (none) column 23. data (continuous) column 24. coded value (none) column 25. data (continuous) column 26. coded value (none) column 27. data (continuous) column 28. coded value (none) 7. Flagging Criteria: column 1. none column 2. none column 3. none column 4. none column 5. flag_notinarray(x,[101,115])="I";manually-assigned flags column 6. flag_valuechange(x,0.1,0.1,1)="P" column 7. x>1="I";x<0="I" column 8. none column 9. isnan(x)="M";manually-assigned flags column 10. none column 11. x<=5="I";x>=7000="I";isnan(x)="M";col_Date>=datenum("11/28/2020 06:25:00")&col_Date<=datenum("12/03/2020 12:00:00")="I";manually-assigned flags column 12. none column 13. x<-2="I";x>30="I";x<-1="Q";x>21="Q";isnan(x)="M";xcol_water_FOUR HI="Q";(col_WATERTEMP_MAX_0_0_01-col_WATERTEMP_INST_0_0_01)>0.5="Q"; (col_WATERTEMP_INST_0_0_01-col_WATERTEMP_MIN_0_0_01)>0.5="Q"; x>col_WATERTEMP_MAX_0_0_01="I"; x55="I";isnan(x)="M";(col_AIRTEMP_MAX_150_0_01-col_AIRTEMP_MEAN_150_0_01)>1=" Q"; (col_AIRTEMP_MEAN_150_0_01-col_AIRTEMP_MIN_150_0_01)>1="Q"; x>col_AIRTEMP_MAX_150_0_01="I"; x55="I";isnan(x)="M";xcol_air_FOURHI="Q";manually-assig ned flags column 18. none column 19. x<-35="I";x>55="I";isnan(x)="M";xcol_air_FOURHI="Q";manually-assig ned flags column 20. none column 21. x<-2="I";x>30="I";x<-1="Q";x>21="Q";isnan(x)="M";(col_WATERTEMP_MAX_0_0_01-col_WATERTEMP _MEAN_0_0_01)>1="Q"; (col_WATERTEMP_MEAN_0_0_01-col_WATERTEMP_MIN_0_0_01)>1="Q"; x>col_WATERTEMP_MAX_0_0_01="I"; x30="I";x<-1="Q";x>21="Q";isnan(x)="M";xcol_water_FOUR HI="Q";manually-assigned flags column 24. none column 25. x<-2="I";x>30="I";x<-1="Q";x>21="Q";isnan(x)="M";xcol_water_FOUR HI="Q";manually-assigned flags column 26. none column 27. x<0="I";x<12="L";x>15="H" column 28. none C. Data Anomalies: Converted values in all columns assigned QA/QC flag(s) I (invalid value (out of range)) to NaN/empty, locking and replacing existing flags with 'M': 105408 records in LOGGERID, 2374 records in EC_INST_0_0_01. Values of 16 records in SiteID are missing for dates: 03/13/2016, 05/25/2016. Values of 105408 records in LOGGERID were flagged as M (undefined flag) for dates: 10/01/2015-10/01/2016. Values of 105408 records in LOGGERID are missing for dates: 10/01/2015-10/01/2016. Values of 4 records in PROGID are missing for date 05/25/2016. Values of 16 records in VNOTCH_INST_0_0_01 are missing for dates: 03/13/2016, 05/25/2016. Values of 4 records in STAGE_INST_0_0_01 were flagged as E (data value estimated by interpolation) for date 05/25/2016. Values of 12 records in STAGE_INST_0_0_01 were flagged as M (undefined flag) for date 03/13/2016. Values of 12 records in STAGE_INST_0_0_01 are missing for date 03/13/2016. Values of 9 records in EC_INST_0_0_01 were flagged as E (data value estimated by interpolation) for dates: 11/17/2015, 01/20/2016, 05/25/2016, 09/20/2016. Values of 2381 records in EC_INST_0_0_01 were flagged as M (undefined flag) for dates: 03/13/2016, 08/19/2016-08/20/2016, 08/20/2016-08/21/2016, 08/21/2016-08/22/2016, 08/22/2016-08/23/2016, 08/23/2016-08/24/2016, 08/24/2016-08/25/2016, 08/25/2016-08/26/2016, 08/26/2016-08/27/2016, 08/27/2016-08/28/2016, 08/28/2016-08/31/2016. Values of 2381 records in EC_INST_0_0_01 are missing for dates: 03/13/2016, 08/19/2016-08/20/2016, 08/20/2016-08/21/2016, 08/21/2016-08/22/2016, 08/22/2016-08/23/2016, 08/23/2016-08/24/2016, 08/24/2016-08/25/2016, 08/25/2016-08/26/2016, 08/26/2016-08/27/2016, 08/27/2016-08/28/2016, 08/28/2016-08/31/2016. Values of 4 records in WATERTEMP_INST_0_0_01 were flagged as E (data value estimated by interpolation) for date 05/25/2016. Values of 12 records in WATERTEMP_INST_0_0_01 were flagged as M (undefined flag) for date 03/13/2016. Values of 76 records in WATERTEMP_INST_0_0_01 were flagged as Q (questionable value) for dates: 11/25/2015, 12/13/2015, 12/14/2015, 12/20/2015, 12/23/2015, 12/24/2015, 12/25/2015, 12/26/2015, 12/27/2015, 12/28/2015, 01/20/2016, 03/14/2016, 03/15/2016, 03/22/2016, 07/27/2016, 08/25/2016, 08/26/2016, 08/27/2016, 08/28/2016, 08/29/2016, 08/31/2016. Values of 12 records in WATERTEMP_INST_0_0_01 are missing for date 03/13/2016. Values of 4 records in AIRTEMP_MEAN_150_0_01 were flagged as E (data value estimated by interpolation) for date 05/25/2016. Values of 12 records in AIRTEMP_MEAN_150_0_01 were flagged as M (undefined flag) for date 03/13/2016. Values of 12 records in AIRTEMP_MEAN_150_0_01 are missing for date 03/13/2016. Values of 4 records in AIRTEMP_MAX_150_0_01 were flagged as E (data value estimated by interpolation) for date 05/25/2016. Values of 12 records in AIRTEMP_MAX_150_0_01 were flagged as M (undefined flag) for date 03/13/2016. Values of 3 records in AIRTEMP_MAX_150_0_01 were flagged as Q (questionable value) for date 04/07/2016. Values of 16 records in AIRTEMP_MAX_150_0_01 are missing for dates: 03/13/2016, 05/25/2016. Values of 4 records in AIRTEMP_MIN_150_0_01 were flagged as E (data value estimated by interpolation) for date 05/25/2016. Values of 12 records in AIRTEMP_MIN_150_0_01 were flagged as M (undefined flag) for date 03/13/2016. The value of one record in AIRTEMP_MIN_150_0_01 was flagged as Q (questionable value) for date 04/07/2016. Values of 16 records in AIRTEMP_MIN_150_0_01 are missing for dates: 03/13/2016, 05/25/2016. Values of 4 records in WATERTEMP_MEAN_0_0_01 were flagged as E (data value estimated by interpolation) for date 05/25/2016. Values of 12 records in WATERTEMP_MEAN_0_0_01 were flagged as M (undefined flag) for date 03/13/2016. Values of 76 records in WATERTEMP_MEAN_0_0_01 were flagged as Q (questionable value) for dates: 11/25/2015, 12/13/2015, 12/14/2015, 12/20/2015, 12/23/2015, 12/24/2015, 12/25/2015, 12/26/2015, 12/27/2015, 12/28/2015, 01/20/2016, 03/14/2016, 03/15/2016, 03/22/2016, 07/27/2016, 08/25/2016, 08/26/2016, 08/27/2016, 08/28/2016, 08/29/2016, 08/31/2016. Values of 12 records in WATERTEMP_MEAN_0_0_01 are missing for date 03/13/2016. Values of 4 records in WATERTEMP_MAX_0_0_01 were flagged as E (data value estimated by interpolation) for date 05/25/2016. Values of 12 records in WATERTEMP_MAX_0_0_01 were flagged as M (undefined flag) for date 03/13/2016. Values of 77 records in WATERTEMP_MAX_0_0_01 were flagged as Q (questionable value) for dates: 11/25/2015, 12/13/2015, 12/14/2015, 12/20/2015, 12/23/2015, 12/24/2015, 12/25/2015, 12/26/2015, 12/27/2015, 12/28/2015, 01/20/2016, 03/14/2016, 03/15/2016, 03/22/2016, 07/27/2016, 08/25/2016, 08/26/2016, 08/27/2016, 08/28/2016, 08/29/2016, 08/31/2016. Values of 16 records in WATERTEMP_MAX_0_0_01 are missing for dates: 03/13/2016, 05/25/2016. Values of 4 records in WATERTEMP_MIN_0_0_01 were flagged as E (data value estimated by interpolation) for date 05/25/2016. Values of 12 records in WATERTEMP_MIN_0_0_01 were flagged as M (undefined flag) for date 03/13/2016. Values of 76 records in WATERTEMP_MIN_0_0_01 were flagged as Q (questionable value) for dates: 11/25/2015, 12/13/2015, 12/14/2015, 12/20/2015, 12/23/2015, 12/24/2015, 12/25/2015, 12/26/2015, 12/27/2015, 12/28/2015, 01/20/2016, 03/14/2016, 03/15/2016, 03/22/2016, 07/27/2016, 08/25/2016, 08/26/2016, 08/27/2016, 08/28/2016, 08/29/2016, 08/31/2016. Values of 16 records in WATERTEMP_MIN_0_0_01 are missing for dates: 03/13/2016, 05/25/2016. Values of 16 records in BATTERY_INST_0_0_01 are missing for dates: 03/13/2016, 05/25/2016. V. Supplemental Descriptors A. Data Acquisition 1. Data Forms: 2. Form Location: 3. Data Entry Validation: B. Quality Assurance/Quality Control Procedures: C. Supplemental Materials: D. Computer Programs: E. Archival Practices: F. Publications: G. History of Data Set Usage 1. Data Request History: 2. Data Set Update History: 3. Review History: 4. Questions and Comments from Users: