I. Data Set Descriptors A. Title: Gage data from benchmark stations at the Andrews Experimental Forest (GSWS02) 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: gsws02_116_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 WS02_116_Table105 WHERE LOGGERID = 116 AND TmStamp BETWEEN '2015-10-01 00:05:00.0' AND '2016-10-01 00:00:00.0' ORDER BY TmStamp ASC (105405 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_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') 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 15 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_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') 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,[102,116])='I';manual' to 'flag_notinarray(x,[102,116])='I''; Q/C Criteria of column PROGID changed from 'flag_valuechange(x,0.1,0.1,1)='P';manual' to 'flag_valuechange(x,0.1,0.1,1)='P''; 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'; x30='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';manual' to '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''; 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';col_Date>=datenum('7/23/2020 08:40:00')&col_Date<=datenum('07/28/2020 18:00:00')='Q';manual' to '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''; 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': 1711 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 3 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: 3 values in 'STAGE_INST_0_0_01' were updated with new values ('update_data'): changed record 16129 from NaN to 0.1010, changed record 23329 from NaN to 0.3525, changed record 33697 from NaN to 0.2340 15-Nov-2023: Q/C flagging criteria applied for column(s) STAGE_INST_0_0_01, 'flags' field updated ('dataflag') 15-Nov-2023: replaced 211 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: 211 values in 'EC_INST_0_0_01' were updated with new values ('update_data'): changed record 1830 from NaN to 0.0617, changed record 16129 from NaN to 0.0366, changed record 20953 from NaN to 0.0074, changed record 20954 from NaN to 0.0092, changed record 20955 from NaN to 0.0110, changed record 20969 from NaN to 0.0122, changed record 20970 from NaN to 0.0116, changed record 20971 from NaN to 0.0110, changed record 20973 from NaN to 0.0136, changed record 20974 from NaN to 0.0169, changed record 20988 from NaN to 0.0109, changed record 20989 from NaN to 0.0155, changed record 20992 from NaN to 0.0091, changed record 20994 from NaN to 0.0103, changed record 20996 from NaN to 0.0125, changed record 21003 from NaN to 0.0116, changed record 21004 from NaN to 0.0124, changed record 21014 from NaN to 0.0197, changed record 21015 from NaN to 0.0176, changed record 21016 from NaN to 0.0155, changed record 21017 from NaN to 0.0134, changed record 21028 from NaN to 0.0101, changed record 21030 from NaN to 0.0090, changed record 21031 from NaN to 0.0107, changed record 21032 from NaN to 0.0125, changed record 21037 from NaN to 0.0088, changed record 21038 from NaN to 0.0114, changed record 21039 from NaN to 0.0141, changed record 21041 from NaN to 0.0164, changed record 21042 from NaN to 0.0161, changed record 21043 from NaN to 0.0157, changed record 21045 from NaN to 0.0102, changed record 21047 from NaN to 0.0072, changed record 21048 from NaN to 0.0093, changed record 21060 from NaN to 0.0167, changed record 21061 from NaN to 0.0139, changed record 21062 from NaN to 0.0110, changed record 21063 from NaN to 0.0082, changed record 21082 from NaN to 0.0137, changed record 21084 from NaN to 0.0107, changed record 21085 from NaN to 0.0110, changed record 21086 from NaN to 0.0113, changed record 21087 from NaN to 0.0115, changed record 21108 from NaN to 0.0080, changed record 21113 from NaN to 0.0128, changed record 21114 from NaN to 0.0193, changed record 21116 from NaN to 0.0239, changed record 21119 from NaN to 0.0116, changed record 21123 from NaN to 0.0164, changed record 21126 from NaN to 0.0151, changed record 21129 from NaN to 0.0193, changed record 21130 from NaN to 0.0227, changed record 21132 from NaN to 0.0226, changed record 21133 from NaN to 0.0192, changed record 22327 from NaN to 0.0182, changed record 22328 from NaN to 0.0164, changed record 22329 from NaN to 0.0145, changed record 22331 from NaN to 0.0123, changed record 22332 from NaN to 0.0120, changed record 22333 from NaN to 0.0117, changed record 22334 from NaN to 0.0114, changed record 22336 from NaN to 0.0090, changed record 22354 from NaN to 0.0105, changed record 22355 from NaN to 0.0128, changed record 22356 from NaN to 0.0151, changed record 22358 from NaN to 0.0144, changed record 22359 from NaN to 0.0113, changed record 22361 from NaN to 0.0086, changed record 22362 from NaN to 0.0088, changed record 22363 from NaN to 0.0091, changed record 22369 from NaN to 0.0161, changed record 22370 from NaN to 0.0198, changed record 22375 from NaN to 0.0160, changed record 22378 from NaN to 0.0126, changed record 22385 from NaN to 0.0125, changed record 22388 from NaN to 0.0065, changed record 22395 from NaN to 0.0106, changed record 22396 from NaN to 0.0140, changed record 22398 from NaN to 0.0151, changed record 22399 from NaN to 0.0129, changed record 22406 from NaN to 0.0069, changed record 22408 from NaN to 0.0067, changed record 22409 from NaN to 0.0082, changed record 22410 from NaN to 0.0096, changed record 22411 from NaN to 0.0111, changed record 22413 from NaN to 0.0096, changed record 22417 from NaN to 0.0108, changed record 22419 from NaN to 0.0126, changed record 22420 from NaN to 0.0110, changed record 22423 from NaN to 0.0131, changed record 22428 from NaN to 0.0095, changed record 22429 from NaN to 0.0111, changed record 22433 from NaN to 0.0127, changed record 22434 from NaN to 0.0126, changed record 22436 from NaN to 0.0127, changed record 22439 from NaN to 0.0106, changed record 22441 from NaN to 0.0072, changed record 22443 from NaN to 0.0101, changed record 22444 from NaN to 0.0119, changed record 22449 from NaN to 0.0141, changed record 22450 from NaN to 0.0115, changed record 22451 from NaN to 0.0088, changed record 22455 from NaN to 0.0131, changed record 22458 from NaN to 0.0137, changed record 22459 from NaN to 0.0135, changed record 22461 from NaN to 0.0110, changed record 22462 from NaN to 0.0087, changed record 22466 from NaN to 0.0091, changed record 22472 from NaN to 0.0089, changed record 22473 from NaN to 0.0124, changed record 22475 from NaN to 0.0167, changed record 22477 from NaN to 0.0155, changed record 22478 from NaN to 0.0135, changed record 22481 from NaN to 0.0067, changed record 22484 from NaN to 0.0085, changed record 22488 from NaN to 0.0110, changed record 22489 from NaN to 0.0108, changed record 22490 from NaN to 0.0106, changed record 22496 from NaN to 0.0179, changed record 22503 from NaN to 0.0071, changed record 22508 from NaN to 0.0082, changed record 22511 from NaN to 0.0124, changed record 22512 from NaN to 0.0107, changed record 22513 from NaN to 0.0090, changed record 22515 from NaN to 0.0089, changed record 22516 from NaN to 0.0106, changed record 22517 from NaN to 0.0122, changed record 22519 from NaN to 0.0132, changed record 22523 from NaN to 0.0102, changed record 22524 from NaN to 0.0102, changed record 22525 from NaN to 0.0102, changed record 22528 from NaN to 0.0106, changed record 22530 from NaN to 0.0096, changed record 22535 from NaN to 0.0100, changed record 22536 from NaN to 0.0089, changed record 22538 from NaN to 0.0085, changed record 22545 from NaN to 0.0106, changed record 22547 from NaN to 0.0147, changed record 22550 from NaN to 0.0127, changed record 22551 from NaN to 0.0111, changed record 22554 from NaN to 0.0075, changed record 22555 from NaN to 0.0076, changed record 22557 from NaN to 0.0146, changed record 22559 from NaN to 0.0233, changed record 22563 from NaN to 0.0074, changed record 22564 from NaN to 0.0087, changed record 22565 from NaN to 0.0099, changed record 22570 from NaN to 0.0143, changed record 22573 from NaN to 0.0167, changed record 22583 from NaN to 0.0173, changed record 22584 from NaN to 0.0134, changed record 22585 from NaN to 0.0096, changed record 22587 from NaN to 0.0062, changed record 22588 from NaN to 0.0067, changed record 22589 from NaN to 0.0072, changed record 22590 from NaN to 0.0077, changed record 22591 from NaN to 0.0082, changed record 22595 from NaN to 0.0100, changed record 22596 from NaN to 0.0112, changed record 22597 from NaN to 0.0125, changed record 22599 from NaN to 0.0128, changed record 22600 from NaN to 0.0118, changed record 22601 from NaN to 0.0108, changed record 22602 from NaN to 0.0098, changed record 22605 from NaN to 0.0121, changed record 22608 from NaN to 0.0216, changed record 22641 from NaN to 0.0095, changed record 22642 from NaN to 0.0096, changed record 22644 from NaN to 0.0096, changed record 22645 from NaN to 0.0093, changed record 22646 from NaN to 0.0091, changed record 22663 from NaN to 0.0118, changed record 22664 from NaN to 0.0122, changed record 22665 from NaN to 0.0127, changed record 22667 from NaN to 0.0133, changed record 22668 from NaN to 0.0135, changed record 22669 from NaN to 0.0138, changed record 22670 from NaN to 0.0140, changed record 22671 from NaN to 0.0142, changed record 22673 from NaN to 0.0129, changed record 22674 from NaN to 0.0113, changed record 22676 from NaN to 0.0110, changed record 22677 from NaN to 0.0122, changed record 22678 from NaN to 0.0134, changed record 22687 from NaN to 0.0086, changed record 22689 from NaN to 0.0103, changed record 22690 from NaN to 0.0147, changed record 22692 from NaN to 0.0169, changed record 22693 from NaN to 0.0146, changed record 22694 from NaN to 0.0123, changed record 22695 from NaN to 0.0100, changed record 22697 from NaN to 0.0074, changed record 22698 from NaN to 0.0072, changed record 22699 from NaN to 0.0069, changed record 22700 from NaN to 0.0066, changed record 22701 from NaN to 0.0064, changed record 22703 from NaN to 0.0083, changed record 22704 from NaN to 0.0105, changed record 22707 from NaN to 0.0121, changed record 22709 from NaN to 0.0150, changed record 22710 from NaN to 0.0184, changed record 22714 from NaN to 0.0149, changed record 22715 from NaN to 0.0190, changed record 22717 from NaN to 0.0175, changed record 22727 from NaN to 0.0224, changed record 22736 from NaN to 0.0273, changed record 23329 from NaN to 0.0307, changed record 33697 from NaN to 0.0334, changed record 78216 from NaN to 0.0490, changed record 102709 from NaN to 0.0565, changed record 102710 from NaN to 0.0560 15-Nov-2023: Q/C flagging criteria applied for column(s) EC_INST_0_0_01, 'flags' field updated ('dataflag') 15-Nov-2023: replaced 3 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: 3 values in 'WATERTEMP_INST_0_0_01' were updated with new values ('update_data'): changed record 16129 from NaN to 4.296, changed record 23329 from NaN to 6.518, changed record 33697 from NaN to 6.683 15-Nov-2023: Q/C flagging criteria applied for column(s) WATERTEMP_INST_0_0_01, 'flags' field updated ('dataflag') 15-Nov-2023: replaced 3 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: 3 values in 'AIRTEMP_MEAN_150_0_01' were updated with new values ('update_data'): changed record 16129 from NaN to -1.44, changed record 23329 from NaN to 1.25, changed record 33697 from NaN to 3.12 15-Nov-2023: Q/C flagging criteria applied for column(s) AIRTEMP_MEAN_150_0_01, 'flags' field updated ('dataflag') 15-Nov-2023: replaced 3 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: 3 values in 'WATERTEMP_MEAN_0_0_01' were updated with new values ('update_data'): changed record 16129 from NaN to 4.30, changed record 23329 from NaN to 6.52, changed record 33697 from NaN to 6.68 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, 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", 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", 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", 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") 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, Q = questionable value 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. 102 to 102 column 4. (none) column 5. 116 to 116 column 6. 48168 to 48168 column 7. 0 to 1 column 8. (none) column 9. 0.005 to 0.887 column 10. (none) column 11. 5.0171 to 64.0678 column 12. (none) column 13. 1.998 to 19.61 column 14. (none) column 15. -7.389 to 29.49 column 16. (none) column 17. -7.36 to 29.63 column 18. (none) column 19. -7.411 to 29.39 column 20. (none) column 21. 1.998 to 19.63 column 22. (none) column 23. 2.008 to 19.65 column 24. (none) column 25. 1.989 to 19.57 column 26. (none) column 27. 12.03 to 14.95 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";manually-assigned flags 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" 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': 1711 records in EC_INST_0_0_01. Values of 15 records in SiteID are missing for dates: 11/26/2015, 12/21/2015, 01/26/2016, 03/13/2016. Values of 15 records in VNOTCH_INST_0_0_01 are missing for dates: 11/26/2015, 12/21/2015, 01/26/2016, 03/13/2016. Values of 3 records in STAGE_INST_0_0_01 were flagged as E (data value estimated by interpolation) for dates: 11/26/2015, 12/21/2015, 01/26/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 211 records in EC_INST_0_0_01 were flagged as E (data value estimated by interpolation) for dates: 10/07/2015, 11/26/2015, 12/12/2015, 12/13/2015, 12/17/2015, 12/18/2015, 12/21/2015, 01/26/2016, 06/28/2016, 09/21/2016. Values of 1515 records in EC_INST_0_0_01 were flagged as M (undefined flag) for dates: 12/12/2015, 12/12/2015-12/13/2015, 12/17/2015, 12/18/2015, 03/13/2016, 08/04/2016-08/09/2016. Values of 1515 records in EC_INST_0_0_01 are missing for dates: 12/12/2015, 12/12/2015-12/13/2015, 12/17/2015, 12/18/2015, 03/13/2016, 08/04/2016-08/09/2016. Values of 3 records in WATERTEMP_INST_0_0_01 were flagged as E (data value estimated by interpolation) for dates: 11/26/2015, 12/21/2015, 01/26/2016. Values of 12 records in WATERTEMP_INST_0_0_01 were flagged as M (undefined flag) for date 03/13/2016. Values of 18 records in WATERTEMP_INST_0_0_01 were flagged as Q (questionable value) for dates: 10/07/2015, 08/05/2016, 08/06/2016, 08/07/2016, 08/09/2016, 09/21/2016, 09/27/2016. Values of 12 records in WATERTEMP_INST_0_0_01 are missing for date 03/13/2016. Values of 3 records in AIRTEMP_MEAN_150_0_01 were flagged as E (data value estimated by interpolation) for dates: 11/26/2015, 12/21/2015, 01/26/2016. Values of 12 records in AIRTEMP_MEAN_150_0_01 were flagged as M (undefined flag) for date 03/13/2016. The value of one record in AIRTEMP_MEAN_150_0_01 was flagged as Q (questionable value) for date 05/01/2016. Values of 12 records in AIRTEMP_MEAN_150_0_01 are missing for date 03/13/2016. Values of 3 records in AIRTEMP_MAX_150_0_01 were flagged as E (data value estimated by interpolation) for dates: 11/26/2015, 12/21/2015, 01/26/2016. Values of 12 records in AIRTEMP_MAX_150_0_01 were flagged as M (undefined flag) for date 03/13/2016. The value of one record in AIRTEMP_MAX_150_0_01 was flagged as Q (questionable value) for date 05/01/2016. Values of 15 records in AIRTEMP_MAX_150_0_01 are missing for dates: 11/26/2015, 12/21/2015, 01/26/2016, 03/13/2016. Values of 3 records in AIRTEMP_MIN_150_0_01 were flagged as E (data value estimated by interpolation) for dates: 11/26/2015, 12/21/2015, 01/26/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 05/01/2016. Values of 15 records in AIRTEMP_MIN_150_0_01 are missing for dates: 11/26/2015, 12/21/2015, 01/26/2016, 03/13/2016. Values of 3 records in WATERTEMP_MEAN_0_0_01 were flagged as E (data value estimated by interpolation) for dates: 11/26/2015, 12/21/2015, 01/26/2016. Values of 12 records in WATERTEMP_MEAN_0_0_01 were flagged as M (undefined flag) for date 03/13/2016. Values of 18 records in WATERTEMP_MEAN_0_0_01 were flagged as Q (questionable value) for dates: 10/07/2015, 08/05/2016, 08/06/2016, 08/07/2016, 08/09/2016, 09/21/2016, 09/27/2016. Values of 12 records in WATERTEMP_MEAN_0_0_01 are missing for date 03/13/2016. Values of 3 records in WATERTEMP_MAX_0_0_01 were flagged as E (data value estimated by interpolation) for dates: 11/26/2015, 12/21/2015, 01/26/2016. Values of 12 records in WATERTEMP_MAX_0_0_01 were flagged as M (undefined flag) for date 03/13/2016. Values of 18 records in WATERTEMP_MAX_0_0_01 were flagged as Q (questionable value) for dates: 10/07/2015, 08/05/2016, 08/06/2016, 08/07/2016, 08/09/2016, 09/21/2016, 09/27/2016. Values of 15 records in WATERTEMP_MAX_0_0_01 are missing for dates: 11/26/2015, 12/21/2015, 01/26/2016, 03/13/2016. Values of 3 records in WATERTEMP_MIN_0_0_01 were flagged as E (data value estimated by interpolation) for dates: 11/26/2015, 12/21/2015, 01/26/2016. Values of 12 records in WATERTEMP_MIN_0_0_01 were flagged as M (undefined flag) for date 03/13/2016. Values of 18 records in WATERTEMP_MIN_0_0_01 were flagged as Q (questionable value) for dates: 10/07/2015, 08/05/2016, 08/06/2016, 08/07/2016, 08/09/2016, 09/21/2016, 09/27/2016. Values of 15 records in WATERTEMP_MIN_0_0_01 are missing for dates: 11/26/2015, 12/21/2015, 01/26/2016, 03/13/2016. Values of 15 records in BATTERY_INST_0_0_01 are missing for dates: 11/26/2015, 12/21/2015, 01/26/2016, 03/13/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: