I. Data Set Descriptors A. Title: Gaging station system data. Usage: Manually entered in-field data and post collection calibration from 16-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: gsws07_119_sys_2020.csv 2. Size: 59 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: 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 file processed: metdat query: SELECT * FROM WS07_119_SYS WHERE LOGGERID = 119 AND TmStamp BETWEEN '2019-10-01 00:05:00.0' AND '2020-10-01 00:00:00.0' ORDER BY TmStamp ASC (59 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_GsWS07_3', updating descriptors for columns Date, RecNum, SiteID, LOGGERID, PROGID, SITE_VISIT, EC_BRUSH, STAGE_RESET, WATER_SAMP, STAGE_HG, STAGE_MEAN_0_0_01, VNOTCH_INST_0_0_01, AIRTEMP_CHECK_150_0_01, AIRTEMP_MEAN_150_0_01, EC_CHECK_0_0_01, WATERTEMP_CHECK_0_0_01, WATERTEMP_MEAN_0_0_01, STAGE_INST_0_0_01, EC_INST_0_0_01 and WATERTEMP_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: Name of column TmStamp changed to Date; Name of column LoggerID changed to LOGGERID; Name of column ProgID changed to PROGID; Name of column STAGE_HOOK changed to STAGE_HG; Name of column STAGE_Avg changed to STAGE_MEAN_0_0_01; Name of column V_NOTCH_WEIR changed to VNOTCH_INST_0_0_01; Name of column AIRTEMP_CHECK changed to AIRTEMP_CHECK_150_0_01; Name of column AIR_TEMP_Avg changed to AIRTEMP_MEAN_150_0_01; Name of column EC_CHECK changed to EC_CHECK_0_0_01; Name of column WATERTEMP_CHECK changed to WATERTEMP_CHECK_0_0_01; Name of column CDH2O_TMP_Avg changed to WATERTEMP_MEAN_0_0_01; Name of column STAGE changed to STAGE_INST_0_0_01; Name of column C25mScm_1 changed to EC_INST_0_0_01; Name of column CDH2O_TMP changed to WATERTEMP_INST_0_0_01; ('apply_template') 08-Jan-2024: Units of column Date changed from '' to 'serial number'; Units of column RecNum changed from '' to 'count'; Units of column LOGGERID changed from '' to 'none'; Units of column PROGID changed from '' to 'none'; Units of column STAGE_MEAN_0_0_01 changed from '' to 'ft'; Units of column VNOTCH_INST_0_0_01 changed from '' to 'none'; Units of column AIRTEMP_CHECK_150_0_01 changed from '' to 'deg c'; Units of column AIRTEMP_MEAN_150_0_01 changed from '' to 'deg c'; Units of column WATERTEMP_CHECK_0_0_01 changed from '' to 'deg c'; Units of column WATERTEMP_MEAN_0_0_01 changed from '' to 'deg c'; Units of column STAGE_INST_0_0_01 changed from '' to 'ft'; Units of column EC_INST_0_0_01 changed from '' to 'cmS cm^-1'; Units of column WATERTEMP_INST_0_0_01 changed from '' to 'deg c'; ('apply_template') 08-Jan-2024: Data Type of column LOGGERID changed from 'f' to 'd'; Data Type of column PROGID changed from 'd' to 'f'; Data Type of column VNOTCH_INST_0_0_01 changed from 'f' to 'd'; ('apply_template') 08-Jan-2024: Variable Type of column RecNum changed from 'data' to 'nominal'; Variable Type of column LOGGERID changed from 'data' to 'nominal'; Variable Type of column PROGID changed from 'data' to 'nominal'; ('apply_template') 08-Jan-2024: Numeric Type of column SiteID changed from 'continous' to 'unspecified'; Numeric Type of column LOGGERID changed from 'continous' to 'discrete'; Numeric Type of column PROGID changed from 'discrete' to 'continuous'; Numeric Type of column SITE_VISIT changed from 'continous' to 'unspecified'; Numeric Type of column EC_BRUSH changed from 'continous' to 'unspecified'; Numeric Type of column STAGE_RESET changed from 'continous' to 'unspecified'; Numeric Type of column WATER_SAMP changed from 'continous' to 'unspecified'; Numeric Type of column STAGE_HG changed from 'continous' to 'unspecified'; Numeric Type of column STAGE_MEAN_0_0_01 changed from 'continous' to 'continuous'; Numeric Type of column VNOTCH_INST_0_0_01 changed from 'continous' to 'discrete'; Numeric Type of column AIRTEMP_CHECK_150_0_01 changed from 'continous' to 'continuous'; Numeric Type of column AIRTEMP_MEAN_150_0_01 changed from 'continous' to 'continuous'; Numeric Type of column EC_CHECK_0_0_01 changed from 'continous' to 'unspecified'; Numeric Type of column WATERTEMP_CHECK_0_0_01 changed from 'continous' to 'continuous'; Numeric Type of column WATERTEMP_MEAN_0_0_01 changed from 'continous' to 'continuous'; Numeric Type of column STAGE_INST_0_0_01 changed from 'continous' to 'continuous'; Numeric Type of column EC_INST_0_0_01 changed from 'continous' to 'continuous'; Numeric Type of column WATERTEMP_INST_0_0_01 changed from 'continous' to 'continuous'; ('apply_template') 08-Jan-2024: Q/C Criteria of column Date changed from '' to 'x<0='I''; Q/C Criteria of column RecNum changed from '' to 'x<0='I''; Q/C Criteria of column LOGGERID changed from '' to 'flag_notinarray(x,[107,119])='I''; Q/C Criteria of column PROGID changed from '' to 'flag_valuechange(x,0.1,0.1,1)='P''; Q/C Criteria of column STAGE_MEAN_0_0_01 changed from '' to 'isnan(x)='M';col_Date>=datenum('5/16/2017 14:55:00')&col_Date<=datenum('5/16/2017 23:55:00')='Q';%offset'; Q/C Criteria of column VNOTCH_INST_0_0_01 changed from '' to 'x>1='I';x<0='I''; Q/C Criteria of column AIRTEMP_CHECK_150_0_01 changed from '' to 'x<-35='I';x>55='I''; Q/C Criteria of column AIRTEMP_MEAN_150_0_01 changed from '' to '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'; x30='I';x<-1='Q';x>21='Q''; Q/C Criteria of column WATERTEMP_MEAN_0_0_01 changed from '' to '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'; x=datenum('5/16/2017 14:55:00')&col_Date<=datenum('5/16/2017 23:55:00')='Q';%offset'; Q/C Criteria of column EC_INST_0_0_01 changed from '' to 'x<=0.005='I';x>=7.0='I';isnan(x)='M''; Q/C Criteria of column WATERTEMP_INST_0_0_01 changed from '' to '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_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'; x=datenum("5/16/2017 14:55:00")&Date<=datenum("5/16/2017 23:55:00")="Q", %offset) column 20. Binary indicator for V-notch. 1 = on, 0 = off column 21. 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 22. Air temperature check from independent probe column 23. QA/QC flags for Air temperature check from independent probe (flagging criteria, where "x" is AIRTEMP_CHECK_150_0_01: x<-35="I", x>55="I") column 24. Average air temperature (255) column 25. QA/QC flags for Average air temperature (255) (flagging criteria, where "x" is AIRTEMP_MEAN_150_0_01: x<-35="I", x>55="I", isnan(x)="M", xair_FOURHI="Q", (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", x30="I", x<-1="Q", x>21="Q") column 32. Average water temperature from EC column 33. 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", xwater_FOURHI="Q", (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", x=datenum("5/16/2017 14:55:00")&Date<=datenum("5/16/2017 23:55:00")="Q", %offset) column 38. Conductivity column 39. QA/QC flags for Conductivity (flagging criteria, where "x" is EC_INST_0_0_01: x<=5="I", x>=7000="I", isnan(x)="M") column 40. Average temperature of water from EC column 41. 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", x=datenum("5/16/2017 14:55:00")&col_Date<=datenum("5/16/2017 23:55:00")="Q";%offset column 19. none column 20. x>1="I";x<0="I" column 21. none column 22. x<-35="I";x>55="I" column 23. none column 24. x<-35="I";x>55="I";isnan(x)="M";xcol_air_FOURHI="Q";(col_AIRTEMP_M AX_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"; x30="I";x<-1="Q";x>21="Q" column 31. none column 32. 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_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"; x=datenum("5/16/2017 14:55:00")&col_Date<=datenum("5/16/2017 23:55:00")="Q";%offset column 37. none column 38. x<=5="I";x>=7000="I";isnan(x)="M" column 39. none column 40. 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"; x