I. Data Set Descriptors A. Title: Gaging station water sample data. Usage: Event based table used with water chemistry collection from 01-Oct-2018 to 30-Sep-2019 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: 07-Jan-2024 2. Latest Archive Date: 3. Latest Metadata Update: 07-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_samp_2019.csv 2. Size: 831 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 MACK_114_Table400 WHERE LOGGERID = 114 AND TmStamp BETWEEN '2018-10-01 00:05:00.0' AND '2019-10-01 00:00:00.0' ORDER BY TmStamp ASC (831 records) Data processing history: 07-Jan-2024: new GCE Data Structure 1.1 created ('newstruct') 07-Jan-2024: imported result set from SQL query on data source 'metdat' ('sql2struct') 07-Jan-2024: imported all documentation metadata from the template 'LNDB_GsMACK_3', updating descriptors for columns Date, RecNum, SiteID, LOGGERID, PROGID, SAMPLE_INST_0_0_01 and STAGE_INST_0_0_01 ('meta_template') 07-Jan-2024: updated 3 metadata fields in the Data, Dataset, Status section(s) ('addmeta') 07-Jan-2024: updated title ('newtitle') 07-Jan-2024: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 07-Jan-2024: added column 'Site' at position 1 ('addcol') 07-Jan-2024: documented flagged and missing values in column PROGID as data set anomalies in the metadata ('add_anomalies') 07-Jan-2024: updated title ('newtitle') 07-Jan-2024: updated 1 metadata fields in the Dataset section(s) ('addmeta') 07-Jan-2024: updated title ('newtitle') 07-Jan-2024: updated 1 metadata fields in the Dataset section(s) ('addmeta') 07-Jan-2024: deleted column Date from the structure ('deletecols') 07-Jan-2024: added column 'Date' at position 2 ('addcol') 07-Jan-2024: flags for columns SiteID, SAMPLE_INST_0_0_01 and STAGE_INST_0_0_01 converted to data columns, flag codes updated in metadata ('flags2cols') 07-Jan-2024: updated 6 metadata fields in the Data section(s) ('addmeta') 07-Jan-2024: updated 15 metadata fields in the Status, Data sections to reflect attribute metadata ('updatecols') 07-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. SAMPLE_INST_0_0_01 column 9. Flag_SAMPLE_INST_0_0_01 column 10. STAGE_INST_0_0_01 column 11. 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. Instantaneous measurement of SiteID column 5. QA/QC flags for Instantaneous measurement of SiteID (flagging criteria, where "x" is SiteID: ) column 6. LoggerID column 7. Program ID column 8. Water sample number column 9. QA/QC flags for Water sample number (flagging criteria, where "x" is SAMPLE_INST_0_0_01: x<0="I", x>999="I") column 10. Stage height column 11. QA/QC flags for Stage height (flagging criteria, where "x" is STAGE_INST_0_0_01: isnan(x)="M") 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. count column 9. none column 10. ft column 11. none 4. Data Type a. Storage Type: column 1. string column 2. string column 3. integer column 4. integer column 5. string column 6. integer column 7. floating-point column 8. integer column 9. string column 10. floating-point column 11. string b. Variable Codes: c. Numeric Range: column 1. (none) column 2. (none) column 3. 632 to 1462 column 4. 111 to 111 column 5. (none) column 6. 114 to 114 column 7. 8077 to 26829 column 8. 1 to 94 column 9. (none) column 10. 0.095 to 1.956 column 11. (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 b. Number of Columns: 11 c. Decimal Places: column 1. 0 column 2. 0 column 3. 0 column 4. 0 column 5. 0 column 6. 0 column 7. 1 column 8. 0 column 9. 0 column 10. 4 column 11. 0 6. Logical Variable Type: column 1. nominal (none) column 2. datetime (none) column 3. nominal (discrete) column 4. data (discrete) 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 (continuous) column 11. 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,[111,114])="I" column 7. flag_valuechange(x,0.1,0.1,1)="P" column 8. x<0="I";x>999="I" column 9. none column 10. isnan(x)="M" column 11. none C. Data Anomalies: The value of one record in PROGID was flagged as P (undefined flag) for date 12/05/2018. 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: