I. Data Set Descriptors A. Title: Gaging station system data. Usage: Manually entered in-field data and post collection calibration from 15-Oct-2019 to 01-Sep-2020 B. Accession Number: C. Description 1. Originator(s): Name: Position: Organization: Address: City: State: Postal Code: Phone: Email: UserID: 2. Abstract: 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: 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: gsmack_114_sys_2020.csv 2. Size: 57 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 MACK_114_SYS WHERE LOGGERID = 114 AND TmStamp BETWEEN '2019-10-01 00:05:00.0' AND '2020-10-01 00:00:00.0' ORDER BY TmStamp ASC (57 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_GsMACK_3', updating descriptors for columns Date, RecNum, SiteID, LOGGERID, PROGID, SITE_VISIT, EC_BRUSH, STAGE_RESET, WATER_SAMP, STAGE_HG, AIRTEMP_CHECK_150_0_01, EC_CHECK, WATERTEMP_CHECK_0_0_01, STAGE_INST_0_0_01, FISHSTAGE_INST_0_0_01, AIRTEMP_MEAN_150_0_01, EC_INST_0_0_01 and WATERTEMP_INST_0_0_01 ('meta_template') 08-Jan-2024: updated 3 metadata fields in the Data, Dataset, 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 AIRTEMP_CHECK changed to AIRTEMP_CHECK_150_0_01; Name of column WATERTEMP_CHECK changed to WATERTEMP_CHECK_0_0_01; Name of column STAGE changed to STAGE_INST_0_0_01; Name of column FISHSTAGE changed to FISHSTAGE_INST_0_0_01; Name of column AIR_TEMP_Avg changed to AIRTEMP_MEAN_150_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 SITE_VISIT changed from '' to 'number'; Units of column EC_BRUSH changed from '' to 'number'; Units of column STAGE_RESET changed from '' to 'number'; Units of column WATER_SAMP changed from '' to 'HHMM'; Units of column STAGE_HG changed from '' to 'feet'; Units of column AIRTEMP_CHECK_150_0_01 changed from '' to 'deg C'; Units of column EC_CHECK changed from '' to 'mS cm-1'; Units of column WATERTEMP_CHECK_0_0_01 changed from '' to 'deg C'; Units of column STAGE_INST_0_0_01 changed from '' to 'ft'; Units of column FISHSTAGE_INST_0_0_01 changed from '' to 'ft'; Units of column AIRTEMP_MEAN_150_0_01 changed from '' to 'deg c'; 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 SiteID changed from 'f' to 'd'; Data Type of column LOGGERID changed from 'f' to 'd'; Data Type of column PROGID changed from 'd' to 'f'; Data Type of column SITE_VISIT changed from 'f' to 'd'; Data Type of column EC_BRUSH changed from 'f' to 'd'; Data Type of column STAGE_RESET changed from 'f' to 'd'; Data Type of column WATER_SAMP 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 'discrete'; 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 'discrete'; Numeric Type of column EC_BRUSH changed from 'continous' to 'discrete'; Numeric Type of column STAGE_RESET changed from 'continous' to 'discrete'; Numeric Type of column WATER_SAMP changed from 'continous' to 'discrete'; Numeric Type of column STAGE_HG changed from 'continous' to 'continuous'; Numeric Type of column AIRTEMP_CHECK_150_0_01 changed from 'continous' to 'continuous'; Numeric Type of column EC_CHECK changed from 'continous' to 'continuous'; Numeric Type of column WATERTEMP_CHECK_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 FISHSTAGE_INST_0_0_01 changed from 'continous' to 'unspecified'; Numeric Type of column AIRTEMP_MEAN_150_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,[111,114])='I''; Q/C Criteria of column PROGID changed from '' to 'flag_valuechange(x,0.1,0.1,1)='P''; Q/C Criteria of column AIRTEMP_CHECK_150_0_01 changed from '' to 'x<-35='I';x>55='I''; Q/C Criteria of column WATERTEMP_CHECK_0_0_01 changed from '' to 'x<-2='I';x>30='I';x<-1='Q';x>21='Q''; Q/C Criteria of column STAGE_INST_0_0_01 changed from '' to 'isnan(x)='M''; Q/C Criteria of column FISHSTAGE_INST_0_0_01 changed from '' to 'isnan(x)='M''; 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_AIRTE MP_MIN_150_0_01)>1='Q';x>col_AIRTEMP_MAX_150_0_01='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'; x55="I") column 20. Instantaneous measurement of EC_CHECK column 21. QA/QC flags for Instantaneous measurement of EC_CHECK (flagging criteria, where "x" is EC_CHECK: ) column 22. Instantaneous measurement of WATERTEMP_CHECK column 23. QA/QC flags for Instantaneous measurement of WATERTEMP_CHECK (flagging criteria, where "x" is WATERTEMP_CHECK_0_0_01: x<-2="I", x>30="I", x<-1="Q", x>21="Q") column 24. STAGE_HGTM column 25. QA/QC flags for STAGE_HGTM (flagging criteria, where "x" is STAGE_HGTM: ) column 26. Stage height column 27. QA/QC flags for Stage height (flagging criteria, where "x" is STAGE_INST_0_0_01: isnan(x)="M") column 28. Stage height at fish gage column 29. QA/QC flags for Stage height at fish gage (flagging criteria, where "x" is FISHSTAGE_INST_0_0_01: isnan(x)="M") column 30. FISHLADDER_CHECK column 31. QA/QC flags for FISHLADDER_CHECK (flagging criteria, where "x" is FISHLADDER_CHECK: ) column 32. Average air temperature (395mm) column 33. QA/QC flags for Average air temperature (395mm) (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", x=7000="I", isnan(x)="M") column 36. Instantaneous water temperature from EC column 37. 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" column 19. none column 20. none column 21. none column 22. x<-2="I";x>30="I";x<-1="Q";x>21="Q" column 23. none column 24. none column 25. none column 26. isnan(x)="M" column 27. none column 28. isnan(x)="M" column 29. none column 30. none column 31. none column 32. 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";x=7000="I";isnan(x)="M" column 35. none column 36. 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