I. Data Set Descriptors A. Title: Meteorological data from Climatic Station at the Andrews Forest. Variables include: Precipitation from 01-Oct-2016 to 01-Oct-2017 B. Accession Number: C. Description 1. Originator(s): Christopher Daly 2. Abstract: A three-level hydro-climatic network for data. 3. Study Type: 4. Study Themes: 5. LTER Core Areas: 6. Georeferences: 7. Submission Date: D. Keywords: Air temperature, precipitation 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: 15-Nov-2023 2. Latest Archive Date: 3. Latest Metadata Update: 15-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: cs2met_clrg_15min_2017.csv 2. Size: 35041 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: M = Missing value, I = Invalid value (out of range), Q = Questionable value, L = Low value, H = High value, R = Reduced volume stored in sample tank, V = Flags values n greater than or m less than the mean of the preceding N readings, E = data value estimated by interpolation 7. Authentication Procedures: 8. Calculations: PRECIP_INST_250_0_02: PRECIP_INST_250_0_02(mm) = PRECIP_INST_250_0_02(in)*25.4 PRECIP_TOT_250_0_02: PRECIP_TOT_250_0_02(mm) = PRECIP_TOT_250_0_02(in)*25.4 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 metdat.dbo.CS2MET_CLRG_Table1 WHERE TmStamp BETWEEN '2016-10-01 00:00:00.0' AND '2017-10-01 00:00:00.0' ORDER BY TmStamp ASC (35041 records) Data processing history: 15-Nov-2023: new GCE Data Structure 1.1 created ('newstruct') 15-Nov-2023: imported result set from SQL query on data source 'metdat' ('sql2struct') 15-Nov-2023: imported all documentation metadata from the template 'LNDB_Cs2Met_CLRG', updating descriptors for columns Date, RecNum, BATTERY_MIN, ActTemp, PRECIP_INST_250_0_02 and PRECIP_TOT_250_0_02 ('meta_template') 15-Nov-2023: updated 6 metadata fields in the Data, Dataset, Status section(s) ('addmeta') 15-Nov-2023: updated title ('newtitle') 15-Nov-2023: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 15-Nov-2023: Name of column TmStamp changed to Date; Name of column GageMinV changed to BATTERY_MIN; Name of column ActDepth changed to PRECIP_INST_250_0_02; Name of column ReportPCP changed to PRECIP_TOT_250_0_02; ('apply_template') 15-Nov-2023: Units of column Date changed from '' to 'serial number'; Units of column RecNum changed from '' to 'count'; Units of column BATTERY_MIN changed from '' to 'volts'; Units of column ActTemp changed from '' to 'deg c'; Units of column PRECIP_INST_250_0_02 changed from '' to 'in'; Units of column PRECIP_TOT_250_0_02 changed from '' to 'in'; ('apply_template') 15-Nov-2023: Variable Type of column RecNum changed from 'data' to 'nominal'; ('apply_template') 15-Nov-2023: Numeric Type of column BATTERY_MIN changed from 'continous' to 'continuous'; Numeric Type of column ActTemp changed from 'continous' to 'continuous'; Numeric Type of column PRECIP_INST_250_0_02 changed from 'continous' to 'continuous'; Numeric Type of column PRECIP_TOT_250_0_02 changed from 'continous' to 'continuous'; ('apply_template') 15-Nov-2023: Q/C Criteria of column Date changed from '' to 'x<0='I''; Q/C Criteria of column RecNum changed from '' to 'isnan(x)='M';x<0='I''; Q/C Criteria of column BATTERY_MIN changed from '' to 'isnan(x)='M';x<0='I';x>=0 & x<=11.5='L';x>15.5='H''; Q/C Criteria of column ActTemp changed from '' to 'isnan(x)='M''; Q/C Criteria of column PRECIP_INST_250_0_02 changed from '' to 'isnan(x)='M';flag_valuechange(x,12.7,25,1)='R';x<0='I';x>=15='Q';col_Date>=datenum(' 09/30/2020 09:00:00')&col_Date<=datenum('09/30/2020 09:15:00')='R';col_Date>=datenum('11/08/2021 09:45:00')&col_Date<=datenum('11/08/2021 10:45:00')='R''; Q/C Criteria of column PRECIP_TOT_250_0_02 changed from '' to 'isnan(x)='M';x<0='I';col_ActTemp>=50='Q';col_ActTemp<=-30='Q';x>=0.9842='I';x>0.5118 10='Q';col_Date>=datenum('02/12/2018 12:00:00')&col_Date<=datenum('02/13/2018 12:00:00')='Q';col_Date>=datenum('04/08/2019 01:00:00')&col_Date<=datenum('04/09/2019 20:00:00')='Q';col_Date>=datenum('12/24/2021 12:00:00')&col_Date<=datenum('12/27/2021 15:00:00')='Q''; ('apply_template') 15-Nov-2023: Precision of column Date changed from 0 to 7; Precision of column BATTERY_MIN changed from 3 to 2; Precision of column ActTemp changed from 3 to 2; Precision of column PRECIP_INST_250_0_02 changed from 3 to 4; ('apply_template') 15-Nov-2023: Descriptions of columns Date, RecNum, BATTERY_MIN, ActTemp, PRECIP_INST_250_0_02 and PRECIP_TOT_250_0_02 edited; ('apply_template') 15-Nov-2023: deleted columns collMinVolt_1, collMinVolt_2, collMinVolt_3, Cycles_1, Cycles_2, Cycles_3, WetTime_1, WetTime_2, WetTime_3, DryTime_1, DryTime_2, DryTime_3, MissedTime_1, MissedTime_2, MissedTime_3, operatingMode15, blockedSec, scan10 and keepAliveSec from the structure ('deletecols') 15-Nov-2023: converted units of 'PRECIP_INST_250_0_02' column and 2 QA/QC flag criteria parameters from in to mm ('unit_convert') 15-Nov-2023: Q/C flagging criteria applied for column(s) PRECIP_INST_250_0_02, 'flags' field updated ('dataflag') 15-Nov-2023: converted units of 'PRECIP_TOT_250_0_02' column and 3 QA/QC flag criteria parameters from in to mm ('unit_convert') 15-Nov-2023: Q/C flagging criteria applied for column(s) PRECIP_TOT_250_0_02, 'flags' field updated ('dataflag') 15-Nov-2023: added column 'Site' at position 1 ('addcol') 15-Nov-2023: sorted by column Date(ascending) ('sortdata') 15-Nov-2023: removed 4 row(s) with duplicate values in the column(s) Date ('cleardupes') 15-Nov-2023: inserted 4 new records with date/time values and NaN/null data values (replicating common values in the non-data columns Site and RecNum) to fill in date/time interval gaps in the data series and assigned flag 'M' to inserted records ('pad_date_gaps') 15-Nov-2023: sorted by column Date(ascending) ('sortdata') 15-Nov-2023: 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': 6 records in PRECIP_INST_250_0_02, 3 records in PRECIP_TOT_250_0_02 ('nullflags') 15-Nov-2023: sorted by column Date(ascending) ('sortdata') 15-Nov-2023: updated 1 metadata fields in the Data section(s) ('addmeta') 15-Nov-2023: replaced 4 missing values in column ActTemp with estimated values based on 1D interpolation of ActTemp as a function of Date using the MATLAB 9.912 function 'interp1' with the 'linear' (linear interpolation) method option, excluding data gaps with more than 5 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 15-Nov-2023: 4 values in 'ActTemp' were updated with new values ('update_data'): changed record 15561 from NaN to 3.29, changed record 15562 from NaN to 3.29, changed record 15563 from NaN to 3.29, changed record 15564 from NaN to 3.29 15-Nov-2023: Q/C flagging criteria applied for column(s) ActTemp, 'flags' field updated ('dataflag') 15-Nov-2023: replaced 4 missing values in column PRECIP_INST_250_0_02 with estimated values based on 1D interpolation of PRECIP_INST_250_0_02 as a function of Date using the MATLAB 9.912 function 'interp1' with the 'linear' (linear interpolation) method option, excluding data gaps with more than 5 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 15-Nov-2023: 4 values in 'PRECIP_INST_250_0_02' were updated with new values ('update_data'): changed record 15561 from NaN to 81.9616, changed record 15562 from NaN to 81.9629, changed record 15563 from NaN to 81.9642, changed record 15564 from NaN to 81.9655 15-Nov-2023: Q/C flagging criteria applied for column(s) PRECIP_INST_250_0_02, 'flags' field updated ('dataflag') 15-Nov-2023: documented flagged and missing values in columns Site, Date, RecNum, BATTERY_MIN, ActTemp, PRECIP_INST_250_0_02, PRECIP_TOT_250_0_02, OPDCounts and ActDepthRA as data set anomalies in the metadata ('add_anomalies') 15-Nov-2023: updated title ('newtitle') 15-Nov-2023: updated 1 metadata fields in the Dataset section(s) ('addmeta') 15-Nov-2023: updated title ('newtitle') 15-Nov-2023: updated 1 metadata fields in the Dataset section(s) ('addmeta') 15-Nov-2023: added column 'PRECIP_ACC_250_0_02' at position 8 ('addcol') 15-Nov-2023: copied QA/QC flags from column(s) PRECIP_TOT_250_0_02 to column(s) PRECIP_ACC_250_0_02, merging copied flags with any existing flags, and set QA/QC criteria for destination column(s) to 'manual' ('copyflags') 15-Nov-2023: copied QA/QC flags from column(s) PRECIP_INST_250_0_02 to column(s) PRECIP_TOT_250_0_02, merging copied flags with any existing flags, and set QA/QC criteria for destination column(s) to 'manual' ('copyflags') 15-Nov-2023: copied QA/QC flags from column(s) PRECIP_TOT_250_0_02 to column(s) PRECIP_ACC_250_0_02, merging copied flags with any existing flags, and set QA/QC criteria for destination column(s) to 'manual' ('copyflags') 15-Nov-2023: deleted column Date from the structure ('deletecols') 15-Nov-2023: added column 'Date' at position 2 ('addcol') 15-Nov-2023: flags for columns BATTERY_MIN, ActTemp, PRECIP_INST_250_0_02, PRECIP_TOT_250_0_02, PRECIP_ACC_250_0_02, OPDCounts and ActDepthRA converted to data columns, flag codes updated in metadata ('flags2cols') 15-Nov-2023: updated 6 metadata fields in the Data section(s) ('addmeta') 15-Nov-2023: updated 15 metadata fields in the Status, Data sections to reflect attribute metadata ('updatecols') 15-Nov-2023: parsed and formatted metadata ('listmeta') B. Variable Information 1. Variable Name: column 1. Site column 2. Date column 3. RecNum column 4. BATTERY_MIN column 5. Flag_BATTERY_MIN column 6. ActTemp column 7. Flag_ActTemp column 8. PRECIP_INST_250_0_02 column 9. Flag_PRECIP_INST_250_0_02 column 10. PRECIP_TOT_250_0_02 column 11. Flag_PRECIP_TOT_250_0_02 column 12. PRECIP_ACC_250_0_02 column 13. Flag_PRECIP_ACC_250_0_02 column 14. OPDCounts column 15. Flag_OPDCounts column 16. ActDepthRA column 17. Flag_ActDepthRA 2. Variable Definition: column 1. Site code column 2. Round off corrected corrected serial date column 3. Record number column 4. Minimum sampler battery voltage for the reporting period column 5. QA/QC flags for Minimum sampler battery voltage for the reporting period (flagging criteria, where "x" is BATTERY_MIN: isnan(x)="M", x<0="I", x>=0 & x<=11.5="L", x>15.5="H", manual) column 6. Panel temperature of logger column 7. QA/QC flags for Panel temperature of logger (flagging criteria, where "x" is ActTemp: isnan(x)="M", manual) column 8. Instantaneous measurement of ActDepth column 9. QA/QC flags for Instantaneous measurement of ActDepth (flagging criteria, where "x" is PRECIP_INST_250_0_02: isnan(x)="M", flag_valuechange(x,12.7,25,1)="R", x<0="I", x>=381="Q", Date>=datenum("09/30/2020 09:00:00")&Date<=datenum("09/30/2020 09:15:00")="R", Date>=datenum("11/08/2021 09:45:00")&Date<=datenum("11/08/2021 10:45:00")="R", manual) column 10. 15 minute total precipitation from ReportPCP column 11. QA/QC flags for 15 minute total precipitation from ReportPCP (flagging criteria, where "x" is PRECIP_TOT_250_0_02: isnan(x)="M", x<0="I", ActTemp>=50="Q", ActTemp<=-30="Q", x>=24.9987="I", x>13="Q", Date>=datenum("02/12/2018 12:00:00")&Date<=datenum("02/13/2018 12:00:00")="Q", Date>=datenum("04/08/2019 01:00:00")&Date<=datenum("04/09/2019 20:00:00")="Q", Date>=datenum("12/24/2021 12:00:00")&Date<=datenum("12/27/2021 15:00:00")="Q", manual) column 12. Cumulative sum of total precipitation column 13. QA/QC flags for Cumulative sum of total precipitation (flagging criteria, where "x" is PRECIP_ACC_250_0_02: manual) column 14. OPDCounts column 15. QA/QC flags for OPDCounts (flagging criteria, where "x" is OPDCounts: manual) column 16. ActDepthRA column 17. QA/QC flags for ActDepthRA (flagging criteria, where "x" is ActDepthRA: manual) 3. Units of Measurement: column 1. column 2. yyyy-MM-dd HH:mm:ss column 3. count column 4. volts column 5. none column 6. deg c column 7. none column 8. mm column 9. none column 10. mm column 11. none column 12. mm column 13. none column 14. column 15. none column 16. column 17. none 4. Data Type a. Storage Type: column 1. string column 2. string column 3. integer column 4. floating-point column 5. string column 6. floating-point column 7. string column 8. floating-point column 9. string column 10. floating-point column 11. string column 12. floating-point column 13. string column 14. integer column 15. string column 16. floating-point column 17. string b. Variable Codes: Flag_BATTERY_MIN: M = Missing value Flag_ActTemp: E = data value estimated by interpolation Flag_PRECIP_INST_250_0_02: E = data value estimated by interpolation, M = Missing value, Q = Questionable value, R = Reduced volume stored in sample tank Flag_PRECIP_TOT_250_0_02: E = data value estimated by interpolation, M = Missing value, Q = Questionable value, R = Reduced volume stored in sample tank Flag_PRECIP_ACC_250_0_02: E = data value estimated by interpolation, M = Missing value, Q = Questionable value, R = Reduced volume stored in sample tank Flag_OPDCounts: M = Missing value Flag_ActDepthRA: M = Missing value c. Numeric Range: column 1. (none) column 2. (none) column 3. 199026 to 234066 column 4. 11.95 to 12.56 column 5. (none) column 6. -11.63 to 38.25 column 7. (none) column 8. 41.2393 to 403.7985 column 9. (none) column 10. 0 to 19.558 column 11. (none) column 12. 0 to 2872.4859 column 13. (none) column 14. 0 to 0 column 15. (none) column 16. -2.1187 to 15.8973 column 17. (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. text column 8. numerical column 9. text column 10. numerical column 11. text column 12. numerical column 13. text column 14. numerical column 15. text column 16. numerical column 17. text b. Number of Columns: 17 c. Decimal Places: column 1. 0 column 2. 0 column 3. 0 column 4. 2 column 5. 0 column 6. 2 column 7. 0 column 8. 4 column 9. 0 column 10. 4 column 11. 0 column 12. 2 column 13. 0 column 14. 0 column 15. 0 column 16. 3 column 17. 0 6. Logical Variable Type: column 1. nominal (none) column 2. datetime (none) column 3. nominal (discrete) column 4. data (continuous) column 5. coded value (none) column 6. data (continuous) column 7. coded value (none) column 8. data (continuous) column 9. coded value (none) column 10. data (continuous) column 11. coded value (none) column 12. data (continuous) column 13. coded value (none) column 14. data (discrete) column 15. coded value (none) column 16. data (continous) column 17. coded value (none) 7. Flagging Criteria: column 1. manually-assigned flags column 2. none column 3. isnan(x)="M";x<0="I";manually-assigned flags column 4. isnan(x)="M";x<0="I";x>=0 & x<=11.5="L";x>15.5="H";manually-assigned flags column 5. none column 6. isnan(x)="M";manually-assigned flags column 7. none column 8. isnan(x)="M";flag_valuechange(x,12.7,25,1)="R";x<0="I";x>=381="Q";col_Date>=datenum("09/ 30/2020 09:00:00")&col_Date<=datenum("09/30/2020 09:15:00")="R";col_Date>=datenum("11/08/2021 09:45:00")&col_Date<=datenum("11/08/2021 10:45:00")="R";manually-assigned flags column 9. none column 10. isnan(x)="M";x<0="I";col_ActTemp>=50="Q";col_ActTemp<=-30="Q";x>=24.9987="I";x>13="Q";co l_Date>=datenum("02/12/2018 12:00:00")&col_Date<=datenum("02/13/2018 12:00:00")="Q";col_Date>=datenum("04/08/2019 01:00:00")&col_Date<=datenum("04/09/2019 20:00:00")="Q";col_Date>=datenum("12/24/2021 12:00:00")&col_Date<=datenum("12/27/2021 15:00:00")="Q";manually-assigned flags column 11. none column 12. manually-assigned flags column 13. none column 14. manually-assigned flags column 15. none column 16. manually-assigned flags column 17. 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': 6 records in PRECIP_INST_250_0_02, 3 records in PRECIP_TOT_250_0_02. Values of 4 records in Site were flagged as M (Missing value) for date 03/12/2017. Values of 4 records in Date were flagged as M (Missing value) for date 03/12/2017. Values of 4 records in RecNum were flagged as M (Missing value) for date 03/12/2017. Values of 4 records in RecNum are missing for date 03/12/2017. Values of 4 records in BATTERY_MIN were flagged as M (Missing value) for date 03/12/2017. Values of 4 records in BATTERY_MIN are missing for date 03/12/2017. Values of 4 records in ActTemp were flagged as E (data value estimated by interpolation) for date 03/12/2017. Values of 4 records in PRECIP_INST_250_0_02 were flagged as E (data value estimated by interpolation) for date 03/12/2017. Values of 6 records in PRECIP_INST_250_0_02 were flagged as M (Missing value) for date 01/03/2017. Values of 102 records in PRECIP_INST_250_0_02 were flagged as Q (Questionable value) for dates: 10/13/2016-10/14/2016, 12/12/2016. Values of 17 records in PRECIP_INST_250_0_02 were flagged as R (Reduced volume stored in sample tank) for dates: 10/14/2016, 10/18/2016, 11/21/2016, 12/12/2016, 12/13/2016, 01/03/2017, 01/10/2017, 02/09/2017, 03/07/2017, 03/09/2017, 03/29/2017, 04/26/2017, 06/06/2017, 09/26/2017. Values of 6 records in PRECIP_INST_250_0_02 are missing for date 01/03/2017. Values of 7 records in PRECIP_TOT_250_0_02 were flagged as M (Missing value) for dates: 10/14/2016, 12/13/2016, 01/03/2017, 03/12/2017. Values of 2 records in PRECIP_TOT_250_0_02 were flagged as Q (Questionable value) for dates: 11/21/2016, 01/03/2017. Values of 7 records in PRECIP_TOT_250_0_02 are missing for dates: 10/14/2016, 12/13/2016, 01/03/2017, 03/12/2017. Values of 4 records in OPDCounts were flagged as M (Missing value) for date 03/12/2017. Values of 4 records in OPDCounts are missing for date 03/12/2017. Values of 4 records in ActDepthRA were flagged as M (Missing value) for date 03/12/2017. Values of 4 records in ActDepthRA are missing for date 03/12/2017. 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: