I. Data Set Descriptors A. Title: Gage data from benchmark stations at the Andrews Experimental Forest (GSWS02) from 01-Oct-2017 to 01-Oct-2018 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: 07-Jan-2024 2. Latest Archive Date: 3. Latest Metadata Update: 07-Jan-2024 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: gsws02_116_5min_2018.csv 2. Size: 105120 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), H = unspecified, 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 WS02_116_Table105 WHERE LOGGERID = 116 AND TmStamp BETWEEN '2017-10-01 00:05:00.0' AND '2018-10-01 00:00:00.0' ORDER BY TmStamp ASC (105102 records) sigma_airtemp_gaged_streams_leap_ak.csv (8784 records) FINAL_GAGE_WATTEMP_leap_ak.csv (8784 records) Data processing history: 07-Jan-2024: new GCE Data Structure 1.1 created ('newstruct') 07-Jan-2024: imported result set from SQL query on data source 'metdat' ('sql2struct') 07-Jan-2024: imported all documentation metadata from the template 'LNDB_GsWS02_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') 07-Jan-2024: updated 6 metadata fields in the Data, Dataset, Project, Status section(s) ('addmeta') 07-Jan-2024: updated title ('newtitle') 07-Jan-2024: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 07-Jan-2024: added column 'Site' at position 1 ('addcol') 07-Jan-2024: inserted 18 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') 07-Jan-2024: sorted by column Date(ascending) ('sortdata') 07-Jan-2024: Year, Month, Day, Hour and Minute datetime columns added after column Date ('add_datepartcols') 07-Jan-2024: sorted by columns Month(ascending), Day(ascending), Hour(ascending) ('sortdata') 07-Jan-2024: 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 (105120 rows) ('joindata') 07-Jan-2024: sorted by column Date(ascending) ('sortdata') 07-Jan-2024: imported all documentation metadata from the template 'LNDB_GsWS02_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') 07-Jan-2024: updated 6 metadata fields in the Data, Dataset, Project, Status section(s) ('addmeta') 07-Jan-2024: updated title ('newtitle') 07-Jan-2024: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 07-Jan-2024: 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,[102,116])='I';manual' to 'flag_notinarray(x,[102,116])='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';flag_daterange(col_Date,{'07/20/2021 08:05:00','07/26/2021 15:25:00'})='Q';flag_daterange(col_Date,{'06/17/2020 13:15:00','06/23/2020 09:30:00'})='Q';manual' to 'isnan(x)='M';flag_daterange(col_Date,{'07/20/2021 08:05:00','07/26/2021 15:25:00'})='Q';flag_daterange(col_Date,{'06/17/2020 13:15:00','06/23/2020 09:30:00'})='Q''; 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_Date>=datenum('7/23/2020 08:40:00')&col_Date<=datenum('07/28/2020 18:00:00')='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'; x15='H';isnan(x)='M';manual' to 'x<0='I';x<12='L';x>15='H';isnan(x)='M''; ('apply_template') 07-Jan-2024: 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') 07-Jan-2024: Description of column AIRTEMP_MEAN_150_0_01 edited; ('apply_template') 07-Jan-2024: 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') 07-Jan-2024: 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': 2546 records in EC_INST_0_0_01 ('nullflags') 07-Jan-2024: sorted by column Date(ascending) ('sortdata') 07-Jan-2024: updated 1 metadata fields in the Data section(s) ('addmeta') 07-Jan-2024: replaced 64 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') 07-Jan-2024: 64 values in 'EC_INST_0_0_01' were updated with new values ('update_data'): changed record 5910 from NaN to 0.0190, changed record 5945 from NaN to 0.0185, changed record 5948 from NaN to 0.0153, changed record 6001 from NaN to 0.0181, changed record 6002 from NaN to 0.0193, changed record 6005 from NaN to 0.0258, changed record 6006 from NaN to 0.0213, changed record 6008 from NaN to 0.0170, changed record 6011 from NaN to 0.0153, changed record 6013 from NaN to 0.0146, changed record 6014 from NaN to 0.0146, changed record 6015 from NaN to 0.0147, changed record 6016 from NaN to 0.0148, changed record 6017 from NaN to 0.0148, changed record 6019 from NaN to 0.0166, changed record 6020 from NaN to 0.0183, changed record 6022 from NaN to 0.0186, changed record 6023 from NaN to 0.0171, changed record 6024 from NaN to 0.0156, changed record 6025 from NaN to 0.0141, changed record 6026 from NaN to 0.0127, changed record 6028 from NaN to 0.0142, changed record 6029 from NaN to 0.0171, changed record 6030 from NaN to 0.0201, changed record 6031 from NaN to 0.0231, changed record 6033 from NaN to 0.0271, changed record 6034 from NaN to 0.0281, changed record 6035 from NaN to 0.0291, changed record 6036 from NaN to 0.0301, changed record 6046 from NaN to 0.0170, changed record 6048 from NaN to 0.0179, changed record 6049 from NaN to 0.0200, changed record 6050 from NaN to 0.0221, changed record 6051 from NaN to 0.0242, changed record 6052 from NaN to 0.0264, changed record 6055 from NaN to 0.0243, changed record 6056 from NaN to 0.0168, changed record 6058 from NaN to 0.0089, changed record 6061 from NaN to 0.0169, changed record 6063 from NaN to 0.0193, changed record 6064 from NaN to 0.0183, changed record 6068 from NaN to 0.0146, changed record 6069 from NaN to 0.0115, changed record 6076 from NaN to 0.0141, changed record 6079 from NaN to 0.0175, changed record 6080 from NaN to 0.0182, changed record 6081 from NaN to 0.0189, changed record 6082 from NaN to 0.0196, changed record 6084 from NaN to 0.0183, changed record 6085 from NaN to 0.0163, changed record 6086 from NaN to 0.0144, changed record 6089 from NaN to 0.0182, changed record 6091 from NaN to 0.0096, changed record 6105 from NaN to 0.0226, changed record 6122 from NaN to 0.0265, changed record 6123 from NaN to 0.0253, changed record 6124 from NaN to 0.0240, changed record 6125 from NaN to 0.0227, changed record 6178 from NaN to 0.0288, changed record 6179 from NaN to 0.0288, changed record 7369 from NaN to 0.0334, changed record 15448 from NaN to 0.0262, changed record 86127 from NaN to 0.0050, changed record 86128 from NaN to 0.0050 07-Jan-2024: Q/C flagging criteria applied for column(s) EC_INST_0_0_01, 'flags' field updated ('dataflag') 07-Jan-2024: 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') 07-Jan-2024: 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') 07-Jan-2024: deleted column RecNum from the structure ('deletecols') 07-Jan-2024: documented flagged and missing values in columns SiteID, 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') 07-Jan-2024: updated title ('newtitle') 07-Jan-2024: updated 1 metadata fields in the Dataset section(s) ('addmeta') 07-Jan-2024: updated title ('newtitle') 07-Jan-2024: updated 1 metadata fields in the Dataset section(s) ('addmeta') 07-Jan-2024: 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') 07-Jan-2024: Q/C flagging criteria applied for column(s) EC_INST_0_0_01, 'flags' field updated ('dataflag') 07-Jan-2024: deleted columns air_FOURHI, air_FOURLO, water_FOURHI and water_FOURLO from the structure ('deletecols') 07-Jan-2024: deleted column Date from the structure ('deletecols') 07-Jan-2024: added column 'Date' at position 2 ('addcol') 07-Jan-2024: 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') 07-Jan-2024: updated 6 metadata fields in the Data section(s) ('addmeta') 07-Jan-2024: updated 15 metadata fields in the Status, Data sections to reflect attribute metadata ('updatecols') 07-Jan-2024: 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", flag_daterange(Date,{"07/20/2021 08:05:00","07/26/2021 15:25:00"})="Q", flag_daterange(Date,{"06/17/2020 13:15:00","06/23/2020 09:30:00"})="Q") 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", 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", Date>=datenum("7/23/2020 08:40:00")&Date<=datenum("07/28/2020 18:00:00")="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 (450) column 20. QA/QC flags for Minimum air temperature (450) (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", Date>=datenum("7/23/2020 08:40:00")&Date<=datenum("07/28/2020 18:00:00")="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", Date>=datenum("7/23/2020 08:40:00")&Date<=datenum("07/28/2020 18:00:00")="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", isnan(x)="M") 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: M = unspecified Flag_EC_INST_0_0_01: E = data value estimated by interpolation, M = unspecified Flag_WATERTEMP_INST_0_0_01: M = unspecified, Q = questionable value Flag_AIRTEMP_MEAN_150_0_01: M = unspecified, Q = questionable value Flag_AIRTEMP_MAX_150_0_01: M = unspecified, Q = questionable value Flag_AIRTEMP_MIN_150_0_01: M = unspecified, Q = questionable value Flag_WATERTEMP_MEAN_0_0_01: M = unspecified, Q = questionable value Flag_WATERTEMP_MAX_0_0_01: M = unspecified, Q = questionable value Flag_WATERTEMP_MIN_0_0_01: M = unspecified, Q = questionable value Flag_BATTERY_INST_0_0_01: M = unspecified c. Numeric Range: column 1. (none) column 2. (none) column 3. 102 to 102 column 4. (none) column 5. 116 to 116 column 6. 21807 to 44756 column 7. 0 to 1 column 8. (none) column 9. 0.001 to 0.685 column 10. (none) column 11. 5.0085 to 233.1512 column 12. (none) column 13. 0.158 to 24.95 column 14. (none) column 15. -8.24 to 29.14 column 16. (none) column 17. -8.22 to 29.33 column 18. (none) column 19. -8.28 to 28.94 column 20. (none) column 21. 0.218 to 24.92 column 22. (none) column 23. 0.504 to 24.99 column 24. (none) column 25. 0.13 to 24.88 column 26. (none) column 27. 12.05 to 14.85 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,[102,116])="I" 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";flag_daterange(col_Date,{"07/20/2021 08:05:00","07/26/2021 15:25:00"})="Q";flag_daterange(col_Date,{"06/17/2020 13:15:00","06/23/2020 09:30:00"})="Q" column 10. none column 11. x<=5="I";x>=7000="I";isnan(x)="M";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_Date>=datenum("7/23/2020 08:40:00")&col_Date<=datenum("07/28/2020 18:00:00")="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";col_Date>=datenum("7/23/2020 08:40:00")&col_Date<=datenum("07/28/2020 18:00:00")="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";col_Date>=datenum("7/23/2020 08:40:00")&col_Date<=datenum("07/28/2020 18:00:00")="Q";manually-assigned flags column 26. none column 27. x<0="I";x<12="L";x>15="H";isnan(x)="M" 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': 2546 records in EC_INST_0_0_01. Values of 18 records in SiteID are missing for dates: 11/16/2017, 12/12/2017. Values of 18 records in PROGID are missing for dates: 11/16/2017, 12/12/2017. Values of 18 records in VNOTCH_INST_0_0_01 are missing for dates: 11/16/2017, 12/12/2017. Values of 18 records in STAGE_INST_0_0_01 were flagged as M (undefined flag) for dates: 11/16/2017, 12/12/2017. Values of 18 records in STAGE_INST_0_0_01 are missing for dates: 11/16/2017, 12/12/2017. Values of 64 records in EC_INST_0_0_01 were flagged as E (data value estimated by interpolation) for dates: 10/21/2017, 10/22/2017, 10/26/2017, 11/23/2017, 07/27/2018. Values of 2500 records in EC_INST_0_0_01 were flagged as M (undefined flag) for dates: 10/21/2017, 10/22/2017, 10/22/2017-10/24/2017, 11/16/2017, 12/12/2017, 07/27/2018-08/02/2018. Values of 2500 records in EC_INST_0_0_01 are missing for dates: 10/21/2017, 10/22/2017, 10/22/2017-10/24/2017, 11/16/2017, 12/12/2017, 07/27/2018-08/02/2018. Values of 18 records in WATERTEMP_INST_0_0_01 were flagged as M (undefined flag) for dates: 11/16/2017, 12/12/2017. Values of 522 records in WATERTEMP_INST_0_0_01 were flagged as Q (questionable value) for dates: 10/11/2017, 10/24/2017, 02/13/2018, 02/24/2018, 02/28/2018, 03/04/2018, 06/18/2018, 07/27/2018, 07/28/2018, 07/29/2018, 07/30/2018, 07/31/2018, 08/01/2018, 08/02/2018, 08/21/2018, 09/17/2018. Values of 18 records in WATERTEMP_INST_0_0_01 are missing for dates: 11/16/2017, 12/12/2017. Values of 18 records in AIRTEMP_MEAN_150_0_01 were flagged as M (undefined flag) for dates: 11/16/2017, 12/12/2017. The value of one record in AIRTEMP_MEAN_150_0_01 was flagged as Q (questionable value) for date 07/17/2018. Values of 18 records in AIRTEMP_MEAN_150_0_01 are missing for dates: 11/16/2017, 12/12/2017. Values of 18 records in AIRTEMP_MAX_150_0_01 were flagged as M (undefined flag) for dates: 11/16/2017, 12/12/2017. The value of one record in AIRTEMP_MAX_150_0_01 was flagged as Q (questionable value) for date 07/17/2018. Values of 18 records in AIRTEMP_MAX_150_0_01 are missing for dates: 11/16/2017, 12/12/2017. Values of 18 records in AIRTEMP_MIN_150_0_01 were flagged as M (undefined flag) for dates: 11/16/2017, 12/12/2017. The value of one record in AIRTEMP_MIN_150_0_01 was flagged as Q (questionable value) for date 07/17/2018. Values of 18 records in AIRTEMP_MIN_150_0_01 are missing for dates: 11/16/2017, 12/12/2017. Values of 18 records in WATERTEMP_MEAN_0_0_01 were flagged as M (undefined flag) for dates: 11/16/2017, 12/12/2017. Values of 524 records in WATERTEMP_MEAN_0_0_01 were flagged as Q (questionable value) for dates: 10/11/2017, 10/24/2017, 02/13/2018, 02/24/2018, 02/28/2018, 03/04/2018, 06/18/2018, 07/27/2018, 07/28/2018, 07/29/2018, 07/30/2018, 07/31/2018, 08/01/2018, 08/02/2018, 08/21/2018, 09/17/2018. Values of 18 records in WATERTEMP_MEAN_0_0_01 are missing for dates: 11/16/2017, 12/12/2017. Values of 18 records in WATERTEMP_MAX_0_0_01 were flagged as M (undefined flag) for dates: 11/16/2017, 12/12/2017. Values of 529 records in WATERTEMP_MAX_0_0_01 were flagged as Q (questionable value) for dates: 10/11/2017, 10/24/2017, 02/13/2018, 02/24/2018, 02/28/2018, 03/04/2018, 06/18/2018, 07/27/2018, 07/28/2018, 07/29/2018, 07/30/2018, 07/31/2018, 08/01/2018, 08/02/2018, 08/21/2018, 09/17/2018. Values of 18 records in WATERTEMP_MAX_0_0_01 are missing for dates: 11/16/2017, 12/12/2017. Values of 18 records in WATERTEMP_MIN_0_0_01 were flagged as M (undefined flag) for dates: 11/16/2017, 12/12/2017. Values of 523 records in WATERTEMP_MIN_0_0_01 were flagged as Q (questionable value) for dates: 10/11/2017, 10/24/2017, 02/13/2018, 02/24/2018, 02/28/2018, 03/04/2018, 06/18/2018, 07/27/2018, 07/28/2018, 07/29/2018, 07/30/2018, 07/31/2018, 08/01/2018, 08/02/2018, 08/21/2018, 09/17/2018. Values of 18 records in WATERTEMP_MIN_0_0_01 are missing for dates: 11/16/2017, 12/12/2017. Values of 18 records in BATTERY_INST_0_0_01 were flagged as M (undefined flag) for dates: 11/16/2017, 12/12/2017. Values of 18 records in BATTERY_INST_0_0_01 are missing for dates: 11/16/2017, 12/12/2017. 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: