I. Data Set Descriptors A. Title: Gaging station water sample data. Usage: Event based table used with water chemistry collection from 01-Oct-2019 to 30-Sep-2020 B. Accession Number: 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: 08-Jan-2024 2. Latest Archive Date: 3. Latest Metadata Update: 08-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_samp_2020.csv 2. Size: 721 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 7. Authentication Procedures: 8. Calculations: 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 file processed: metdat query: SELECT * FROM WS02_116_Table400 WHERE LOGGERID = 116 AND TmStamp BETWEEN '2019-10-01 00:05:00.0' AND '2020-10-01 00:00:00.0' ORDER BY TmStamp ASC (721 records) Data processing history: 08-Jan-2024: new GCE Data Structure 1.1 created ('newstruct') 08-Jan-2024: imported result set from SQL query on data source 'metdat' ('sql2struct') 08-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, SAMPLE_INST_0_0_01 and STAGE_INST_0_0_01 ('meta_template') 08-Jan-2024: updated 6 metadata fields in the Data, Dataset, Project, Status section(s) ('addmeta') 08-Jan-2024: updated title ('newtitle') 08-Jan-2024: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 08-Jan-2024: added column 'Site' at position 1 ('addcol') 08-Jan-2024: documented flagged and missing values in columns PROGID and STAGE_INST_0_0_01 as data set anomalies in the metadata ('add_anomalies') 08-Jan-2024: updated title ('newtitle') 08-Jan-2024: updated 1 metadata fields in the Dataset section(s) ('addmeta') 08-Jan-2024: updated title ('newtitle') 08-Jan-2024: updated 1 metadata fields in the Dataset section(s) ('addmeta') 08-Jan-2024: deleted column Date from the structure ('deletecols') 08-Jan-2024: added column 'Date' at position 2 ('addcol') 08-Jan-2024: flags for columns SiteID, VNOTCH_INST_0_0_01, SAMPLE_INST_0_0_01 and STAGE_INST_0_0_01 converted to data columns, flag codes updated in metadata ('flags2cols') 08-Jan-2024: updated 6 metadata fields in the Data section(s) ('addmeta') 08-Jan-2024: updated 15 metadata fields in the Status, Data sections to reflect attribute metadata ('updatecols') 08-Jan-2024: parsed and formatted metadata ('listmeta') B. Variable Information 1. Variable Name: column 1. Site column 2. Date column 3. RecNum column 4. SiteID column 5. Flag_SiteID column 6. LOGGERID column 7. PROGID column 8. VNOTCH_INST_0_0_01 column 9. Flag_VNOTCH_INST_0_0_01 column 10. SAMPLE_INST_0_0_01 column 11. Flag_SAMPLE_INST_0_0_01 column 12. STAGE_INST_0_0_01 column 13. Flag_STAGE_INST_0_0_01 2. Variable Definition: column 1. Site code column 2. Round off corrected corrected serial date column 3. RecNum column 4. SiteID column 5. QA/QC flags for SiteID (flagging criteria, where "x" is SiteID: ) column 6. Logger ID column 7. Program ID column 8. Binary indicator for V-notch. 1 = on, 0 = off column 9. 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 10. Water sample number column 11. QA/QC flags for Water sample number (flagging criteria, where "x" is SAMPLE_INST_0_0_01: x<0="I", x>999="I") column 12. Stage height column 13. 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") 3. Units of Measurement: column 1. column 2. yyyy-MM-dd HH:mm:ss column 3. count column 4. column 5. none column 6. none column 7. none column 8. none column 9. none column 10. count column 11. none column 12. ft column 13. none 4. Data Type a. Storage Type: column 1. string column 2. string column 3. integer column 4. floating-point column 5. string column 6. integer column 7. floating-point column 8. integer column 9. string column 10. integer column 11. string column 12. floating-point column 13. string b. Variable Codes: Flag_STAGE_INST_0_0_01: Q = questionable value c. Numeric Range: column 1. (none) column 2. (none) column 3. 0 to 768 column 4. 102 to 102 column 5. (none) column 6. 116 to 116 column 7. 20007 to 52499 column 8. 0 to 1 column 9. (none) column 10. 1 to 77 column 11. (none) column 12. 0.023 to 0.557 column 13. (none) d. Missing Value Code: NaN 5. Data Format a. Column Type: column 1. text column 2. text column 3. numerical column 4. numerical column 5. text column 6. numerical column 7. numerical column 8. numerical column 9. text column 10. numerical column 11. text column 12. numerical column 13. text b. Number of Columns: 13 c. Decimal Places: column 1. 0 column 2. 0 column 3. 0 column 4. 2 column 5. 0 column 6. 0 column 7. 1 column 8. 0 column 9. 0 column 10. 0 column 11. 0 column 12. 4 column 13. 0 6. Logical Variable Type: column 1. nominal (none) column 2. datetime (none) column 3. nominal (discrete) column 4. data (unspecified) column 5. coded value (none) column 6. nominal (discrete) column 7. nominal (continuous) column 8. data (discrete) column 9. coded value (none) column 10. data (discrete) column 11. coded value (none) column 12. data (continuous) column 13. coded value (none) 7. Flagging Criteria: column 1. none column 2. none column 3. x<0="I" column 4. none column 5. none column 6. flag_notinarray(x,[102,116])="I" column 7. flag_valuechange(x,0.1,0.1,1)="P" column 8. x>1="I";x<0="I" column 9. none column 10. x<0="I";x>999="I" column 11. none column 12. 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 13. none C. Data Anomalies: Values of 2 records in PROGID were flagged as P (undefined flag) for dates: 10/23/2019, 06/18/2020. Values of 11 records in STAGE_INST_0_0_01 were flagged as Q (questionable value) for dates: 06/17/2020-06/23/2020. 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: