I. Data Set Descriptors A. Title: Gage data from benchmark stations at the Andrews Experimental Forest (GSWS07) from 06-May-2015 to 01-Oct-2015 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: 14-Nov-2023 2. Latest Archive Date: 3. Latest Metadata Update: 14-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: gsws07_119_5min_2015.csv 2. Size: 42419 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 WS07_119_Table105 WHERE LOGGERID = 119 AND TmStamp BETWEEN '2014-10-01 00:05:00.0' AND '2015-10-01 00:00:00.0' ORDER BY TmStamp ASC (42419 records) sigma_airtemp_gaged_streams_leap_ak.csv (8784 records) FINAL_GAGE_WATTEMP_leap_ak.csv (8784 records) Data processing history: 14-Nov-2023: new GCE Data Structure 1.1 created ('newstruct') 14-Nov-2023: imported result set from SQL query on data source 'metdat' ('sql2struct') 14-Nov-2023: imported all documentation metadata from the template 'LNDB_GsWS07_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') 14-Nov-2023: updated 6 metadata fields in the Data, Dataset, Project, Status section(s) ('addmeta') 14-Nov-2023: updated title ('newtitle') 14-Nov-2023: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 14-Nov-2023: added column 'Site' at position 1 ('addcol') 14-Nov-2023: Year, Month, Day, Hour and Minute datetime columns added after column Date ('add_datepartcols') 14-Nov-2023: sorted by columns Month(ascending), Day(ascending), Hour(ascending) ('sortdata') 14-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 (42419 rows) ('joindata') 14-Nov-2023: sorted by column Date(ascending) ('sortdata') 14-Nov-2023: imported all documentation metadata from the template 'LNDB_GsWS07_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') 14-Nov-2023: updated 6 metadata fields in the Data, Dataset, Project, Status section(s) ('addmeta') 14-Nov-2023: updated title ('newtitle') 14-Nov-2023: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 14-Nov-2023: Q/C Criteria of column LOGGERID changed from 'flag_notinarray(x,[107,119])='I'' to 'flag_notinarray(x,[101,115])='I''; 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'; x30='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'; x1="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", Date>=datenum("5/16/2017 14:55:00")&Date<=datenum("5/16/2017 23:55:00")="Q", %offset) 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", (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") column 19. Minimum air temperature (255) column 20. QA/QC flags for Minimum air temperature (255) (flagging criteria, where "x" is AIRTEMP_MIN_150_0_01: x<-35="I", x>55="I", isnan(x)="M", xair_FOURHI="Q") 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_EC_INST_0_0_01: E = data value estimated by interpolation Flag_WATERTEMP_INST_0_0_01: Q = questionable value Flag_AIRTEMP_MAX_150_0_01: Q = questionable value Flag_AIRTEMP_MIN_150_0_01: Q = questionable value Flag_WATERTEMP_MEAN_0_0_01: Q = questionable value Flag_WATERTEMP_MAX_0_0_01: Q = questionable value Flag_WATERTEMP_MIN_0_0_01: Q = questionable value c. Numeric Range: column 1. (none) column 2. (none) column 3. 107 to 107 column 4. (none) column 5. (none) column 6. 36266 to 36266 column 7. 0 to 1 column 8. (none) column 9. 0.001 to 0.303 column 10. (none) column 11. 47.7178 to 62.4565 column 12. (none) column 13. 5.891 to 13.7 column 14. (none) column 15. 0.693 to 33.26 column 16. (none) column 17. 0.708 to 33.32 column 18. (none) column 19. 0.688 to 33.19 column 20. (none) column 21. 5.891 to 13.7 column 22. (none) column 23. 5.891 to 13.96 column 24. (none) column 25. 5.891 to 13.69 column 26. (none) column 27. 12.5 to 13.51 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";col_Date>=datenum("5/16/2017 14:55:00")&col_Date<=datenum("5/16/2017 23:55:00")="Q";%offset 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_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" column 18. none column 19. x<-35="I";x>55="I";isnan(x)="M";xcol_air_FOURHI="Q" 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': 42419 records in LOGGERID, 1 records in EC_INST_0_0_01. Values of 42419 records in LOGGERID were flagged as M (undefined flag) for dates: 05/06/2015-10/01/2015. Values of 42419 records in LOGGERID are missing for dates: 05/06/2015-10/01/2015. The value of one record in EC_INST_0_0_01 was flagged as E (data value estimated by interpolation) for date 06/09/2015. Values of 8 records in WATERTEMP_INST_0_0_01 were flagged as Q (questionable value) for dates: 05/13/2015, 06/09/2015, 07/21/2015, 08/24/2015. Values of 16 records in AIRTEMP_MAX_150_0_01 were flagged as Q (questionable value) for dates: 06/08/2015, 07/30/2015. Values of 11 records in AIRTEMP_MIN_150_0_01 were flagged as Q (questionable value) for dates: 06/08/2015, 07/30/2015. Values of 8 records in WATERTEMP_MEAN_0_0_01 were flagged as Q (questionable value) for dates: 05/13/2015, 06/09/2015, 07/21/2015, 08/24/2015. Values of 8 records in WATERTEMP_MAX_0_0_01 were flagged as Q (questionable value) for dates: 05/13/2015, 06/09/2015, 07/21/2015, 08/24/2015. Values of 8 records in WATERTEMP_MIN_0_0_01 were flagged as Q (questionable value) for dates: 05/13/2015, 06/09/2015, 07/21/2015, 08/24/2015. 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: