I. Data Set Descriptors A. Title: Gage data from benchmark stations at the Andrews Experimental Forest (GSMACK) from 01-Oct-2023 to 06-May-2024 B. Accession Number: N/A C. Description 1. Originator(s): Name: Position: Organization: Address: City: State: Postal Code: Phone: Email: UserID: 2. Abstract: Data imported by parsing the ASCII text file 'sigma_airtemp_gaged_streams_leap_ak.csv' and automatically assigning numerical descriptors based on value inspection. Data imported by parsing the ASCII text file 'FINAL_GAGE_WATTEMP_leap_ak.csv' and automatically assigning numerical descriptors based on value inspection. 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: Name: Position: Organization: Address: City: State: Postal Code: Phone: Email: UserID: 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: 06-May-2024 2. Latest Archive Date: 3. Latest Metadata Update: 06-May-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: gsmack_114_5min_2024.csv 2. Size: 63038 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 files processed: metdat query: SELECT * FROM MACK_114_Table105 WHERE LOGGERID = 114 AND TmStamp BETWEEN '2023-10-01 00:05:00.0' AND '2024-10-01 00:00:00.0' ORDER BY TmStamp ASC (63038 records) sigma_airtemp_gaged_streams_leap_ak.csv (8784 records) FINAL_GAGE_WATTEMP_leap_ak.csv (8784 records) Data processing history: 06-May-2024: new GCE Data Structure 1.1 created ('newstruct') 06-May-2024: imported result set from SQL query on data source 'metdat' ('sql2struct') 06-May-2024: imported all documentation metadata from the template 'LNDB_GsMACK_3', updating descriptors for columns Date, RecNum, SiteID, LOGGERID, PROGID, STAGE_INST_0_0_01, FISHSTAGE_INST_0_0_01, PRECIP_INST_455_0_02, 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') 06-May-2024: updated 3 metadata fields in the Data, Dataset, Status section(s) ('addmeta') 06-May-2024: updated title ('newtitle') 06-May-2024: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 06-May-2024: added column 'Site' at position 1 ('addcol') 06-May-2024: Year, Month, Day, Hour and Minute datetime columns added after column Date ('add_datepartcols') 06-May-2024: sorted by columns Month(ascending), Day(ascending), Hour(ascending) ('sortdata') 06-May-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, STAGE_INST_0_0_01, FISHSTAGE_INST_0_0_01, PRECIP_INST_455_0_02, 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 (63038 rows) ('joindata') 06-May-2024: sorted by column Date(ascending) ('sortdata') 06-May-2024: imported all documentation metadata from the template 'LNDB_GsMACK_3', updating descriptors for columns Site, Date, RecNum, SiteID, LOGGERID, PROGID, STAGE_INST_0_0_01, FISHSTAGE_INST_0_0_01, PRECIP_INST_455_0_02, 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') 06-May-2024: updated 3 metadata fields in the Data, Dataset, Status section(s) ('addmeta') 06-May-2024: updated title ('newtitle') 06-May-2024: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 06-May-2024: Q/C Criteria of column Date changed from 'x<0='I'' to ''; 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_AIRTE MP_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_1 50_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';xcol_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'; x1200="I", flag_valuechange(x,25,25,1)="R", isnan(x)="M") column 13. Increment corrected total precipitation column 14. QA/QC flags for Increment corrected total precipitation (flagging criteria, where "x" is PRECIP_TOT_455_0_02: manual) column 15. Cumulative sum of total precipitation column 16. QA/QC flags for Cumulative sum of total precipitation (flagging criteria, where "x" is PRECIP_ACC_455_0_02: manual) column 17. Conductivity column 18. 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 19. Instantaneous water temperature from EC column 20. QA/QC flags for Instantaneous water temperature 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 25. Minimum air temperature (395mm) column 26. QA/QC flags for Minimum air temperature (395mm) (flagging criteria, where "x" is AIRTEMP_MIN_150_0_01: x<-35="I", x>55="I", isnan(x)="M", xair_FOURHI="Q") column 27. Average water temperature from EC column 28. 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", xFOURHI="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", x30="I", x<-1="Q", x>21="Q", isnan(x)="M", xwater_FOURHI="Q", manual) column 31. Minimum water temperature from EC column 32. 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 33. Battery supply level column 34. 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. ft column 8. none column 9. ft column 10. none column 11. mm column 12. none column 13. mm column 14. none column 15. mm column 16. none column 17. microS/cm 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. deg c column 28. none column 29. deg c column 30. none column 31. deg c column 32. none column 33. volts column 34. none 4. Data Type a. Storage Type: column 1. string column 2. string column 3. integer column 4. string column 5. integer column 6. floating-point column 7. floating-point 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 column 29. floating-point column 30. string column 31. floating-point column 32. string column 33. floating-point column 34. string b. Variable Codes: Flag_PRECIP_INST_455_0_02: R = unspecified Flag_PRECIP_TOT_455_0_02: F = unspecified, J = unspecified, R = unspecified Flag_PRECIP_ACC_455_0_02: F = unspecified, J = unspecified, R = unspecified Flag_EC_INST_0_0_01: M = unspecified Flag_WATERTEMP_INST_0_0_01: M = unspecified Flag_AIRTEMP_MAX_150_0_01: Q = questionable value Flag_AIRTEMP_MIN_150_0_01: Q = questionable value Flag_WATERTEMP_MEAN_0_0_01: M = unspecified Flag_WATERTEMP_MAX_0_0_01: M = unspecified Flag_WATERTEMP_MIN_0_0_01: M = unspecified Flag_BATTERY_INST_0_0_01: H = unspecified c. Numeric Range: column 1. (none) column 2. (none) column 3. 111 to 111 column 4. (none) column 5. 114 to 114 column 6. 31215 to 57707 column 7. 0.114 to 3.252 column 8. (none) column 9. -0.048 to 0.73 column 10. (none) column 11. 27.43 to 648.8 column 12. (none) column 13. 0 to 89.4 column 14. (none) column 15. 0 to 2418.74 column 16. (none) column 17. 9.7937 to 84.3215 column 18. (none) column 19. 0.641 to 11.56 column 20. (none) column 21. -4.624 to 22.03 column 22. (none) column 23. -4.614 to 22.13 column 24. (none) column 25. -4.625 to 21.9 column 26. (none) column 27. 0.662 to 11.56 column 28. (none) column 29. 0.68 to 11.57 column 30. (none) column 31. 0.641 to 11.56 column 32. (none) column 33. 12.1 to 15.37 column 34. (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 column 29. numerical column 30. text column 31. numerical column 32. text column 33. numerical column 34. text b. Number of Columns: 34 c. Decimal Places: column 1. 0 column 2. 0 column 3. 0 column 4. 0 column 5. 0 column 6. 1 column 7. 4 column 8. 0 column 9. 3 column 10. 0 column 11. 2 column 12. 0 column 13. 2 column 14. 0 column 15. 2 column 16. 0 column 17. 4 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 column 29. 3 column 30. 0 column 31. 3 column 32. 0 column 33. 2 column 34. 0 6. Logical Variable Type: column 1. nominal (none) column 2. datetime (none) column 3. data (discrete) column 4. coded value (none) column 5. nominal (discrete) column 6. nominal (continuous) column 7. data (continuous) column 8. coded value (none) column 9. data (unspecified) 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) column 29. data (continuous) column 30. coded value (none) column 31. data (continuous) column 32. coded value (none) column 33. data (continuous) column 34. coded value (none) 7. Flagging Criteria: column 1. none column 2. none column 3. none column 4. none column 5. flag_notinarray(x,[111,114])="I" column 6. flag_valuechange(x,0.1,0.1,1)="P" column 7. isnan(x)="M";flag_daterange(col_Date,{"12/01/2024 08:40:00","02/14/2024 13:35:00"})="Q" column 8. none column 9. isnan(x)="M" column 10. none column 11. x<0="I";x>1200="I";flag_valuechange(x,25,25,1)="R";isnan(x)="M" column 12. none column 13. manually-assigned flags column 14. none column 15. manually-assigned flags column 16. none column 17. x<=5="I";x>=7000="I";isnan(x)="M";manually-assigned flags column 18. none column 19. 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 24. none column 25. x<-35="I";x>55="I";isnan(x)="M";xcol_air_FOURHI="Q" column 26. none column 27. x<-2="I";x>30="I";x<-1="Q";x>21="Q";isnan(x)="M";xcol_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";xcol_water_FOUR HI="Q";manually-assigned flags column 30. none column 31. x<-2="I";x>30="I";x<-1="Q";x>21="Q";isnan(x)="M";xcol_water_FOUR HI="Q";manually-assigned flags column 32. none column 33. x<0="I";x<12="L";x>15="H";isnan(x)="M" column 34. 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': 2 records in EC_INST_0_0_01, 2 records in WATERTEMP_INST_0_0_01. The value of one record in PROGID was flagged as P (undefined flag) for date 12/05/2023. Values of 14 records in PRECIP_INST_455_0_02 were flagged as R (undefined flag) for dates: 10/25/2023, 11/14/2023, 12/05/2023, 01/18/2024, 01/27/2024, 02/07/2024, 02/27/2024, 03/20/2024, 04/09/2024, 05/01/2024. Values of 7 records in EC_INST_0_0_01 were flagged as M (undefined flag) for date 12/05/2023. Values of 7 records in EC_INST_0_0_01 are missing for date 12/05/2023. Values of 7 records in WATERTEMP_INST_0_0_01 were flagged as M (undefined flag) for date 12/05/2023. Values of 7 records in WATERTEMP_INST_0_0_01 are missing for date 12/05/2023. Values of 7 records in AIRTEMP_MAX_150_0_01 were flagged as Q (questionable value) for date 12/29/2023. Values of 2 records in AIRTEMP_MIN_150_0_01 were flagged as Q (questionable value) for date 12/29/2023. Values of 8 records in WATERTEMP_MEAN_0_0_01 were flagged as M (undefined flag) for date 12/05/2023. Values of 8 records in WATERTEMP_MEAN_0_0_01 are missing for date 12/05/2023. Values of 8 records in WATERTEMP_MAX_0_0_01 were flagged as M (undefined flag) for date 12/05/2023. Values of 8 records in WATERTEMP_MAX_0_0_01 are missing for date 12/05/2023. Values of 8 records in WATERTEMP_MIN_0_0_01 were flagged as M (undefined flag) for date 12/05/2023. Values of 8 records in WATERTEMP_MIN_0_0_01 are missing for date 12/05/2023. Values of 8 records in BATTERY_INST_0_0_01 were flagged as H (unspecified) for dates: 03/06/2024, 04/05/2024. 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: