I. Data Set Descriptors A. Title: Daniela Di Iorio. 2019. Daily Summary of Continuous salinity, temperature and depth measurements from moored hydrographic data loggers deployed at GCE11_Hydro (Altamaha River near Lewis Creek, Georgia) from 01-Jan-2018 through 31-Dec-2018. Georgia Coastal Ecosystems LTER Data Catalog (data set PHY-GCEM-1907i; http://gce-lter.marsci.uga.edu/data/PHY-GCEM-1907i) B. Accession Number: PHY-GCEM-1907i C. Description 1. Originator(s): Name: Daniela Di Iorio Address: Dept. of Marine Sciences University of Georgia Athens, Georgia 30602-3636 Country: USA Email: daniela@uga.edu 2. Abstract: Conductivity, temperature and pressure were measured continuously at Georgia Coastal Ecosystems LTER sampling location GCE11_Hydro (Altamaha River near Lewis Creek, Georgia) from 01-Jan-2018 through 31-Dec-2018. Observations were logged at 30 minute intervals by moored Sea-Bird Electronics MicroCAT 37-SM data loggers and downloaded approximately semi-monthly. Salinity, depth and sigma-t (density anomaly) were calculated from the measured parameters using standard UNESCO algorithms. This data set was collected as part of the GCE-LTER Project continuous salinity, temperature and water level monitoring program. 3. Study Type: Monitoring 4. Study Themes: Physical Oceanography 5. LTER Core Areas: Inorganic Matter 6. Georeferences: geographic coordinates as data columns 7. Submission Date: Jul 01, 2019 D. Keywords: conductivity, daily, density, depth, GCE, GCE11, Georgia, Georgia Coastal Ecosystems, Hydrographic Moorings, hydrography, Inorganic Matter, inorganic nutrients, LTER, monitoring, mooring, pressure, salinity, Sapelo Island, sonde, temperature, USA, water column, water quality II. Research Origin Descriptors A. Overall Project Description 1. Project Title: Georgia Coastal Ecosystems LTER Project III 2. Principal Investigators: Name: Merryl Alber Address: Dept. of Marine Sciences University of Georgia Athens, Georgia 30602-3636 Country: USA Email: malber@uga.edu 3. Funding Period: Nov 01, 2012 to Nov 01, 2018 4. Objectives: The research proposed for GCE-III is designed to address how variations in salinity and inundation, driven by climate change and anthropogenic factors, affect biotic and ecosystem responses at different spatial and temporal scales, and to predict the consequences of these changes for habitat provisioning and carbon (C) sequestration across the coastal landscape. 5. Abstract: The Georgia Coastal Ecosystems (GCE) LTER is located along three adjacent sounds on the Atlantic coast and includes both intertidal marshes and estuaries. Long-term drivers of climate change, sea level rise and human alterations of the landscape will cause transitions in dominant habitat types (state changes) within the GCE domain by changing the amounts and patterns of water delivery across the landscape. These changes in water delivery can be conceptualized as presses and pulses in river inflow, local runoff, groundwater input, and tidal inundation, which will in turn manifest themselves as changes in salinity and inundation patterns in the domain. The research proposed for GCE-III is designed to address how variations in salinity and inundation, driven by climate change and anthropogenic factors, affect biotic and ecosystem responses at different spatial and temporal scales, and to predict the consequences of these changes for habitat provisioning and carbon (C) sequestration across the coastal landscape. The goals are to: 1) Track long-term changes in climate and human actions in the watershed and adjacent uplands, and evaluate the effects of these drivers on domain boundary conditions. 2) Describe temporal and spatial variability in physical, chemical, geological and biological, and to evaluate how they are affected by variations in river inflow and other boundary conditions. 3) Characterize the responses of three dominant habitats in the domain to pulses and presses in salinity and inundation. 4) Describe patterns of habitat provisioning and C sequestration and export in the GCE domain, and to evaluate how these might be affected by changes in salinity and inundation. These efforts will be synthesized into a synoptic understanding of both biotic and ecosystem responses to variations in salinity and inundation driven by climate change and human activities, which will be used to assess thresholds between habitats and the potential for state changes in the domain. 6. Funding Source: NSF OCE 1237140 B. Sub-project Description 1. Site Description a. Geographic Location: GCE-AL -- Altamaha River, Georgia, USA GCE11_Hydro -- Lewis Creek hydrographic datalogger deployment Coordinates: GCE-AL -- NW: 081 34 56.32 W, 31 24 05.05 N NE: 081 14 16.57 W, 31 24 05.05 N SE: 081 14 16.57 W, 31 17 45.72 N SW: 081 34 56.32 W, 31 17 45.72 N GCE11_Hydro -- 81 29 34.1 W, 31 22 45.8 N b. Physiographic Region: GCE-AL -- Estuary and tidal marsh GCE11_Hydro -- Estuary and tidal marsh c. Landform Components: GCE-AL -- Intertidal marsh bordering sounds, tidal channels and creeks GCE11_Hydro -- Intertidal marsh bordering sounds, tidal channels and creeks d. Hydrographic Characteristics: GCE-AL -- Site encompasses the Altamaha River estuary and nearby tidal creeks, and is subject to 2-3.4m semi-diurnal tides. High freshwater input from the Altamaha River, one of the largest rivers in the Southeastern United States. GCE11_Hydro -- Site encompasses the Altamaha River estuary and nearby tidal creeks, and is subject to 2-3.4m semi-diurnal tides. High freshwater input from the Altamaha River, one of the largest rivers in the Southeastern United States. e. Topographic Attributes: GCE-AL -- Flat, with elevations ranging from 0-3.4m above mean low tide GCE11_Hydro -- Flat, with elevations ranging from 0-3.4m above mean low tide f. Geology, Lithology and Soils: GCE-AL -- unspecified GCE11_Hydro -- unspecified g. Vegetation Communities: GCE-AL -- unspecified GCE11_Hydro -- unspecified h. History of Land Use and Disturbance: none recorded i. Climate: Climate summary for Sapelo Island, Georgia, based on NWS data from 1980-2010: Daily-aggregated Values: Mean (sample standard deviation) mean air temperature: 20.09°C (7.28°C) minimum air temperature: 15.02°C (7.96°C) maximum air temperature: 24.82°C (6.98°C) total precipitation: 3.26mm (10.3mm) Yearly-aggregated Daily Values: Mean (sample standard deviation) total precipitation (1980-2010): 1124mm (266mm) 2. Experimental or Sampling Design a. Design Characteristics: Conductivity, temperature and pressure were continuously monitored using an autonomous data-logging sensor package (sonde) that was moored to a piling and submerged 1-1.5m below mean low water. b. Permanent Plots: none c. Data Collection Duration and Frequency: The MicroCAT was programmed to autonomously measure and log conductivity, temperature and pressure at a sampling rate of 30 minutes (based on its internal chronometer). Upon retrieval the data was downloaded from the instrument via RS-232 serial communications and processed using custom Matlab(r) procedures to calculate depth (i.e. from pressure and latitude), salinity and sigma-t (i.e. from conductivity and temperature), and date and time components from sample time stamps. Beginning of Observations: Jan 01, 2018 End of Observations: Dec 31, 2018 3. Research Methods a. Field and Laboratory Methods: Method 1: Deployment -- The MicroCAT was mounted inside a protective PVC pipe enclosure and attached to a wooden piling (~12 inch diameter) that was driven firmly into the substrate. The enclosure was constructed from a 10-foot length of 6-inch (internal diameter) PVC pipe that was perforated all over by drilling 1.5-inch holes (at approximately 4-inch spacing); this permits proper water circulation within the enclosure. The bottom of the PVC pipe was submerged about 5 feet below the water surface at low tide and bolted (vertically) to the piling. The MicroCAT was deployed by lowering it into the enclosure on a 0.375-inch stainless steel cable, and bolting the cable to the piling, so that the bottom of the data logger was ~3 inches above the bottom of the PVC pipe. A weighted surveyor's tape was then used to measure the distance from the substrate to the pressure sensor on the MicroCAT for calculation of total water column depth from pressure readings. The mooring was inspected every 1-3 weeks, and any visible fouling of the enclosure or MicroCAT was removed with a brush or scaper. Method 2: Retrieval and Calibration -- At the end of each measurement period (approximately 2 months), the MicroCAT was unshackled from the cable and returned to the laboratory. The stored data was uploaded to a computer using a RS-232 serial cable and Sea-Bird Electronics SEATERM software. The MicroCAT was then cleaned to remove encrusting material and calibrated with a reference instrument at 4 to 5 salinity levels, generally ranging from 30 to 5 PSU. Method 3: Data Processing -- Data were processed after each retrieval using custom programs in the GCE Data Toolbox for MATLAB (parse_37sm and imp_gcesonde). Depth was calculated from recorded pressure and latitude values, and salinity and sigma-t were calculated from recorded conductivity and temperature values using standard UNESCO algorithms (reference: Unesco. 1983. Algorithms for computation of fundamental properties of seawater, 1983. Unesco Technical Papers in Marine Science No. 44, 53 pp.). Data were then plotted and visually inspected for evidence of biofouling of the conductivity sensor (i.e. prolonged periods of damped tidal oscillation in conductivity signal with no corresponding changes in temperature signal and no wind or rainfall events recorded at nearby monitoring stations, or periods of damped oscillation immediately followed by normal oscillation after instrument maintenance or replacement). Conductivity values recorded during periods of suspected biofouling were flagged as I (invalid) if visible fouling was noted in maintenance logs, and Q (questionable) if no visible fouling was noted. Method 4: Daily Aggregation -- The finalized 30-minute resolution data set was filtered to remove any remaining invalid values (i.e. assigned qualifier flags of 'I' = invalid value or 'X' = excise row), then padded with empty rows to produce a monotonic time series data set with even time steps. The data records were then aggregated (grouped) by Year, Month, Day, Site, Longitude and Latitude, and relevant summary statistics were calculated for each measured variable in each group and added as data columns. Quality control rules were defined for each calculated column to flag statistics based on days with more than 35% missing values as invalid, and more than 10% missing values or 35% flagged values as questionable. Columns listing the number and percentage of missing and flagged values in the original data set for each day were also added as data columns for reference by quality control rules. Following aggregation, summary statistics flagged as invalid were removed from the daily-aggregated data set and converted to missing (NaN). b. Protocols: Method 1: none Method 2: none Method 3: none Method 4: none c. Instrumentation: Method 1: SBE MicroCAT 37-SM (S/N 1793) Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT) Last Calibration: Jun 16, 2015 Parameter: Conductivity (Accuracy: 0.0003 S/m, Readability: 0.00001 S/m, Range: 0 to 7 S/m) Protocol: Water passively circulates through an open internal-field conductivity cell equipped with an external tributyl tin antifoulant dispenser, and conductivity is measured using an ultra-precision Wien-Bridge oscillator with frequency counted by a high-stability reference crystal (<2 ppm/year drift rate). Parameter: Pressure (water) (Accuracy: 0.2m, Readability: 0.0004m, Range: 0 to 20m) Protocol: Pressure is measured using a micro-machined silicon diaphragm with embedded strain elements, and temperature compensation is performed by the SBE MicroCAT onboard cpu. Parameter: Temperature (water) (Accuracy: 0.002°C, Readability: 0.0001°C, Range: -5 to 35°C) Protocol: Temperature is measured by applying an AC excitation to a hermetically-sealed VISHAY reference resistor and an ultra-stable aged thermistor (drift rate typically less than 0.002°C/year). SBE MicroCAT 37-SM (S/N 2413, with pump) Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT) Last Calibration: Apr 06, 2012 Parameter: Conductivity (Accuracy: 0.0003 S/m, Readability: 0.00001 S/m, Range: 0 to 7 S/m) Protocol: Prior to each timed measurement the conductivity cell is opened and water is pumped for 0.5 sec, then conductivity is measured using an ultra-precision Wien-Bridge oscillator with frequency counted by a high-stability reference crystal (<2 ppm/year drift rate). The cell is closed between measurements and tributyl tin antifoulant is released into the tubing. Parameter: Pressure (water) (Accuracy: 0.2m, Readability: 0.0004m, Range: 0 to 20m) Protocol: Pressure is measured using a micro-machined silicon diaphragm with embedded strain elements, and temperature compensation is performed by the SBE MicroCAT onboard cpu. Parameter: Temperature (water) (Accuracy: 0.002°C, Readability: 0.0001°C, Range: -5 to 35°C) Protocol: Temperature is measured by applying an AC excitation to a hermetically-sealed VISHAY reference resistor and an ultra-stable aged thermistor (drift rate typically less than 0.002°C/year). SBE MicroCAT 37-SM (S/N 3746) Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT) Last Calibration: Nov 29, 2012 Parameter: Conductivity (Accuracy: 0.0003 S/m, Readability: 0.00001 S/m, Range: 0 to 7 S/m) Protocol: Prior to each timed measurement the conductivity cell is opened and water is pumped for 0.5 sec, then conductivity is measured using an ultra-precision Wien-Bridge oscillator with frequency counted by a high-stability reference crystal (<2 ppm/year drift rate). The cell is closed between measurements and tributyl tin antifoulant is released into the tubing. Parameter: Pressure (water) (Accuracy: 0.2m, Readability: 0.0004m, Range: 0 to 20m) Protocol: Pressure is measured using a micro-machined silicon diaphragm with embedded strain elements, and temperature compensation is performed by the SBE MicroCAT onboard cpu. Parameter: Temperature (water) (Accuracy: 0.002°C, Readability: 0.0001°C, Range: -5 to 35°C) Protocol: Temperature is measured by applying an AC excitation to a hermetically-sealed VISHAY reference resistor and an ultra-stable aged thermistor (drift rate typically less than 0.002°C/year). SBE MicroCAT 37-SM (S/N 4961) Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT) Last Calibration: Jan 07, 2014 Parameter: Conductivity (Accuracy: 0.0003 S/m, Readability: 0.00001 S/m, Range: 0 to 7 S/m) Protocol: Water passively circulates through an open internal-field conductivity cell equipped with an external tributyl tin antifoulant dispenser, and conductivity is measured using an ultra-precision Wien-Bridge oscillator with frequency counted by a high-stability reference crystal (<2 ppm/year drift rate). Parameter: Pressure (water) (Accuracy: 0.2m, Readability: 0.0004m, Range: 0 to 20m) Protocol: Pressure is measured using a micro-machined silicon diaphragm with embedded strain elements, and temperature compensation is performed by the SBE MicroCAT onboard cpu. Parameter: Temperature (water) (Accuracy: 0.002°C, Readability: 0.0001°C, Range: -5 to 35°C) Protocol: Temperature is measured by applying an AC excitation to a hermetically-sealed VISHAY reference resistor and an ultra-stable aged thermistor (drift rate typically less than 0.002°C/year). Method 2: none Method 3: none Method 4: none d. Taxonomy and Systematics: Method 1: not applicable Method 2: Method 3: Method 4: e. Speclies List: f. Permit History: Method 1: none Method 2: none Method 3: none Method 4: none 4. Project Personnel a. Personnel: 1: Daniela Di Iorio 2: Jacob Shalack 3: Wade M. Sheldon, Jr. 4: Adam Sapp 5: Dontrece Smith 6: Alyssa Peterson 7: Brendan Manley b. Affiliations: 1: University of Georgia, Athens, Georgia 2: University of Georgia Marine Institute, Sapelo Island, Georgia 3: University of Georgia, Athens, Georgia 4: University of Georgia, Athens, Georgia 5: University of Georgia Marine Institute, Sapelo Island, Georgia 6: University of Georgia, Sapelo Island, Georgia 7: University of Georgia, Sapelo Island, GA III. Data Set Status and Accessibility A. Status 1. Latest Update: 05-Mar-2021 2. Latest Archive Date: 05-Mar-2021 3. Latest Metadata Update: 05-Mar-2021 4. Data Verification Status: New submission B. Accessibility 1. Storage Location and Medium: Stored at GCE-LTER Data Management Office Dept. of Marine Sciences Univ. of Georgia Athens, GA 30602-3636 USA on media: electronic data download (WWW) or compact disk 2. Contact Person: Name: Wade M. Sheldon, Jr. Address: 130 Marine Sciences Marine Sciences Building Athens, Georgia 30602-3636 Country: USA Email: sheldon@uga.edu 3. Copyright Restrictions: not copyrighted 4. Restrictions: This information is licensed under a Creative Commons Attribution 4.0 International License (see: https://creativecommons.org/licenses/by/4.0/). The consumer of these data ("Data User" herein) has an ethical obligation to cite it appropriately in any publication that results from its use. The Data User should realize that these data may be actively used by others for ongoing research and that coordination may be necessary to prevent duplicate publication. The Data User is urged to contact the authors of these data if any questions about methodology or results occur. Where appropriate, the Data User is encouraged to consider collaboration or co-authorship with the authors. The Data User should realize that misinterpretation of data may occur if used out of context of the original study. While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed. All data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data. a. Release Date: Affiliates: Jul 01, 2019, Public: Jul 01, 2020 b. Citation: Data provided by the Georgia Coastal Ecosystems Long Term Ecological Research Project, supported by funds from NSF OCE 1237140 (data set PHY-GCEM-1907i) c. Disclaimer: The user assumes all responsibility for errors in judgement based on interpretation of data and analyses presented in this data set. 5. Costs: free electronic data download via WWW, distribution on CD may be subject to nominal processing and handling fee IV. Data Structural Descriptors A. Data Set File 1. File Name: PHY-GCEM-1907i_Daily_1_0.CSV 2. Size: 365 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: none 6. Quality Control Flag Codes: Q = questionable value, I = invalid value (out of range), S = spike/noise, X = excise row flag 7. Authentication Procedures: not specified 8. Calculations: Depth(m) = sw_dpth(Pressure(dbar),Latitude(deg)) -- sw_dpth (salt water depth from pressure) Matlab function, Revision: 1.3, Date: 10-Oct-1994 (C)1992 CSIRO, Phil Morgan (morgan@ml.csiro.au) [Salinity(psu),Sigma_t] = salsig2(Depth(m),Temperature(C),Conductivity(mmho/cm)) -- salsig2 (salinity and sigma-t from conductivity, temperature and depth) Matlab function Revision 06-May-1992 by V. Holliday, as modified by Tom Gross and Julie Amft (julie@skio.peachnet.edu) 9. Processing History: Software version: GCE Data Toolbox Version 3.9.9b (06-Mar-2019) Data structure version: GCE Data Structure 1.1 (29-Mar-2001) Original data files processed: 11180313.asc (4454 records) 11180694.asc (4082 records) 11180991.asc (4623 records) 11181299.cnv (3988 records) 11190394.asc (4674 records) Data processing history: 22-Mar-2018: data uploaded from SBE 37-SM MicroCAT using SEATERM software version 1.59 26-Sep-2018: new GCE Data Structure 1.1 created ('newstruct') 26-Sep-2018: data imported from processed SBE SM-37 sonde data file '11180313.asc' (4454 records) ('imp_gcesonde') 26-Sep-2018: deleted column Second from the structure ('deletecols') 26-Sep-2018: calculated calendar date in MATLAB serial day (base 1/1/0000) format from individual date component columns Year, Month, Day, Hour and Minute, added 'Date' column at position 1 ('add_datecol') 26-Sep-2018: added column 'Instrument' at position 1 ('addcol') 26-Sep-2018: added column 'Pump' at position 2 ('addcol') 26-Sep-2018: Q/C flagging criteria applied for column(s) Pump, 'flags' field updated ('dataflag') 26-Sep-2018: added column 'Latitude' at position 1 ('addcol') 26-Sep-2018: Q/C flagging criteria applied for column(s) Latitude, 'flags' field updated ('dataflag') 26-Sep-2018: added column 'Longitude' at position 1 ('addcol') 26-Sep-2018: Q/C flagging criteria applied for column(s) Longitude, 'flags' field updated ('dataflag') 26-Sep-2018: added column 'Site' at position 1 ('addcol') 26-Sep-2018: matched 4454 out of 4454 geographic coordinates in columns Latitude and Longitude to coordinates for registered locations in the file 'geo_locations.mat' within a distance tolerance of 0.5km (add_locations) 26-Sep-2018: added column 'Station' at position 2 ('addcol') 26-Sep-2018: Q/C flagging criteria applied for column(s) Station, 'flags' field updated ('dataflag') 26-Sep-2018: added geographic metadata based on matching values in column Station to location and station names registered in 'geo_locations.mat' ('add_sitemetadata') 26-Sep-2018: updated 8 metadata fields in the Site sections ('addmeta') 26-Sep-2018: added column 'Calibration' at position 19 ('addcol') 26-Sep-2018: Q/C flagging criteria applied for column(s) Calibration, 'flags' field updated ('dataflag') 26-Sep-2018: updated 13 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 26-Sep-2018: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 26-Sep-2018: edited structure data ('ui_datagrid'): deleted record(s) 4451, 4452, 4453 and 4454 26-Sep-2018: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 27-Sep-2018: 4075 rows added at the bottom of the data set from 'Data from Sea-Bird Electronics 37-SM MicroCAT sonde S/N 1794 deployed at GCE11_Hydro (Lewis Creek hydrographic datalogger deployment) from 22-Mar-2018 to 15-Jun-2018' ('datamerge') 27-Sep-2018: updated 12 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 27-Sep-2018: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 27-Sep-2018: 4614 rows added at the bottom of the data set from 'Data from Sea-Bird Electronics 37-SM MicroCAT sonde S/N 1791 deployed at GCE11_Hydro (Lewis Creek hydrographic datalogger deployment) from 15-Jun-2018 to 19-Sep-2018' ('datamerge') 27-Sep-2018: updated 12 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 27-Sep-2018: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 27-Sep-2018: query 'Year==2018' run, returned 12559 of 13139 data rows ('querydata') 27-Sep-2018: automatically assigned study date metadata descriptors based on the range of date values in date/time columns (add_studydates) 27-Sep-2018: manually edited data set metadata ('ui_editmetadata') 27-Sep-2018: edited data set title in structure and metadata ('ui_editor') 27-Sep-2018: edited structure data ('ui_datagrid'): deleted record(s) 3871 and 3872 27-Sep-2018: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 27-Sep-2018: updated 1 metadata fields in the Data sections ('addmeta') 27-Sep-2018: sorted rows by measurement date prior to applying drift corrections ('correct_drift') 27-Sep-2018: corrected values in column Conductivity for sensor drift over the date range 22-Mar-2018 15:00:00 to 15-Jun-2018 12:00:00 by applying a constant correction of -0.010155 ('correct_drift') 27-Sep-2018: 4073 values in 'Conductivity' were updated with new values ('update_data') 27-Sep-2018: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field updated ('dataflag') 27-Sep-2018: manually added 'C' flags to 4073 records in column(s) Conductivity excluding NaN/empty values ('addflags') 27-Sep-2018: updated 1 metadata fields in the Data sections ('addmeta') 27-Sep-2018: sorted rows by measurement date prior to applying drift corrections ('correct_drift') 27-Sep-2018: corrected values in column Conductivity for sensor drift over the date range 22-Mar-2018 15:00:00 to 15-Jun-2018 12:00:00 by applying a linearly-weighted correction varying from 0 to -0.0061025 ('correct_drift') 27-Sep-2018: 4073 values in 'Conductivity' were updated with new values ('update_data') 27-Sep-2018: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field updated ('dataflag') 27-Sep-2018: manually added 'C' flags to 4073 records in column(s) Conductivity excluding NaN/empty values ('addflags') 27-Sep-2018: updated 1 metadata fields in the Data sections ('addmeta') 27-Sep-2018: sorted rows by measurement date prior to applying drift corrections ('correct_drift') 27-Sep-2018: corrected values in column Salinity for sensor drift over the date range 22-Mar-2018 15:00:00 to 15-Jun-2018 12:00:00 by applying a constant correction of -0.05702 ('correct_drift') 27-Sep-2018: 4073 values in 'Salinity' were updated with new values ('update_data') 27-Sep-2018: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 27-Sep-2018: manually added 'C' flags to 4073 records in column(s) Salinity excluding NaN/empty values ('addflags') 27-Sep-2018: updated 1 metadata fields in the Data sections ('addmeta') 27-Sep-2018: sorted rows by measurement date prior to applying drift corrections ('correct_drift') 27-Sep-2018: corrected values in column Salinity for sensor drift over the date range 22-Mar-2018 15:00:00 to 15-Jun-2018 12:00:00 by applying a linearly-weighted correction varying from 0 to -0.017926 ('correct_drift') 27-Sep-2018: 4073 values in 'Salinity' were updated with new values ('update_data') 27-Sep-2018: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 27-Sep-2018: manually added 'C' flags to 4073 records in column(s) Salinity excluding NaN/empty values ('addflags') 27-Sep-2018: manually edited data set metadata ('ui_editmetadata') 27-Sep-2018: documented flagged values in columns Conductivity and Salinity as data set anomalies in the metadata ('add_anomalies') 18-Mar-2019: 3979 rows added at the bottom of the data set from 'Data from Sea-Bird Electronics 37-SM MicroCAT sonde S/N 16699 deployed at GCE11_Hydro (Lewis Creek hydrographic datalogger deployment) from 19-Sep-2018 to 11-Dec-2018' ('datamerge') 18-Mar-2019: updated 13 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 18-Mar-2019: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 18-Mar-2019: manually edited data set metadata ('ui_editmetadata') 18-Mar-2019: edited data set title in structure and metadata ('ui_editor') 18-Mar-2019: inserted 3 new records with date/time values and NaN/null data values (replicating common values in the non-data columns Site, Station, Longitude, Latitude, Instrument, Pump and Calibration) to fill in date/time interval gaps in the data series ('pad_date_gaps') 18-Mar-2019: sorted by column Date(ascending) ('sortdata') 18-Mar-2019: deleted existing datetime columns Year, Month, Day, Hour and Minute; updated Year, Month, Day, Hour and Minute datetime columns added after column Date ('add_datepartcols') 18-Mar-2019: updated 1 metadata fields in the Data sections ('addmeta') 18-Mar-2019: sorted by column Date(ascending) ('sortdata') 18-Mar-2019: replaced 3 missing values in column Temperature with estimated values based on 1D interpolation of Temperature as a function of Date using the MATLAB 9.5 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 18-Mar-2019: 3 values in 'Temperature' were updated with new values ('update_data'): changed record 3871 from NaN to 16.541, changed record 3872 from NaN to 16.569, changed record 12560 from NaN to 29.425 18-Mar-2019: Q/C flagging criteria applied for column(s) Temperature, 'flags' field updated ('dataflag') 18-Mar-2019: replaced 3 missing values in column Conductivity with estimated values based on 1D interpolation of Conductivity as a function of Date using the MATLAB 9.5 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 18-Mar-2019: 3 values in 'Conductivity' were updated with new values ('update_data'): changed record 3871 from NaN to 0.011, changed record 3872 from NaN to 0.011, changed record 12560 from NaN to 0.024 18-Mar-2019: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field updated ('dataflag') 18-Mar-2019: replaced 3 missing values in column Pressure with estimated values based on 1D interpolation of Pressure as a function of Date using the MATLAB 9.5 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 18-Mar-2019: 3 values in 'Pressure' were updated with new values ('update_data'): changed record 3871 from NaN to 1.611, changed record 3872 from NaN to 1.796, changed record 12560 from NaN to 0.990 18-Mar-2019: Q/C flagging criteria applied for column(s) Pressure, 'flags' field updated ('dataflag') 18-Mar-2019: replaced 3 missing values in column Depth with estimated values based on 1D interpolation of Depth as a function of Date using the MATLAB 9.5 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 18-Mar-2019: 3 values in 'Depth' were updated with new values ('update_data'): changed record 3871 from NaN to 1.600, changed record 3872 from NaN to 1.783, changed record 12560 from NaN to 0.983 18-Mar-2019: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated ('dataflag') 18-Mar-2019: replaced 3 missing values in column Salinity with estimated values based on 1D interpolation of Salinity as a function of Date using the MATLAB 9.5 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 18-Mar-2019: 3 values in 'Salinity' were updated with new values ('update_data'): changed record 3871 from NaN to 0.064, changed record 3872 from NaN to 0.064, changed record 12560 from NaN to 0.109 18-Mar-2019: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 18-Mar-2019: replaced 3 missing values in column Sigma_t with estimated values based on 1D interpolation of Sigma_t as a function of Date using the MATLAB 9.5 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 18-Mar-2019: 3 values in 'Sigma_t' were updated with new values ('update_data'): changed record 3871 from NaN to -1.084, changed record 3872 from NaN to -1.071, changed record 12560 from NaN to -4.097 18-Mar-2019: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated ('dataflag') 02-May-2019: 4668 rows added at the bottom of the data set from 'Data from Sea-Bird Electronics 37-SM MicroCAT sonde S/N 1794 deployed at GCE11_Hydro (Lewis Creek hydrographic datalogger deployment) from 11-Dec-2018 to 18-Mar-2019' ('datamerge') 02-May-2019: updated 13 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 02-May-2019: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 02-May-2019: query 'Year==2018' run, returned 17520 of 21207 data rows ('querydata') 02-May-2019: automatically assigned study date metadata descriptors based on the range of date values in date/time columns (add_studydates) 02-May-2019: manually edited data set metadata ('ui_editmetadata') 02-May-2019: edited data set title in structure and metadata ('ui_editor') 02-May-2019: manually edited data set metadata ('ui_editmetadata') 02-May-2019: documented flagged values in columns Temperature, Conductivity, Pressure, Depth, Salinity and Sigma_t as data set anomalies in the metadata ('add_anomalies') 05-Mar-2021: query 'Year=2018' run, returned 17520 of 17520 data rows ('querydata') 05-Mar-2021: copied QA/QC flags from column(s) Conductivity and Temperature to column(s) Salinity and Sigma_t, merging copied flags with any existing flags, and set QA/QC criteria for destination column(s) to 'manual' ('copyflags') 05-Mar-2021: imported all documentation metadata from the template 'GCE_Sonde', retaining existing attribute descriptors for all columns ('meta_template') 05-Mar-2021: updated 41 metadata fields in the Data, Dataset, Project, Site, Status, Study, Supplement sections ('addmeta') 05-Mar-2021: updated title ('newtitle') 05-Mar-2021: added geographic metadata based on matching values in column Station to location and station names registered in 'geo_locations.mat' ('add_sitemetadata') 05-Mar-2021: updated 8 metadata fields in the Site sections ('addmeta') 05-Mar-2021: updated title ('newtitle') 05-Mar-2021: updated 1 metadata fields in the Dataset sections ('addmeta') 05-Mar-2021: performed daily statistical aggregation on data columns Temperature, Conductivity, Pressure, Depth, Salinity and Sigma_t by grouping on columns Site, Station, Longitude, Latitude, Year, Month and Day (aggr_datetime) 05-Mar-2021: updated title ('newtitle') 05-Mar-2021: updated 1 metadata fields in the Dataset sections ('addmeta') 05-Mar-2021: calculated calendar date in MATLAB serial day (base 1/1/0000) format from individual date component columns Year, Month and Day, added 'Date' column at position 5 ('add_datecol') 05-Mar-2021: documented flagged and missing values in columns Daily_Min_Conductivity, Daily_Max_Conductivity, Daily_Mean_Conductivity, Daily_StdDev_Conductivity, Daily_SE_Conductivity, Daily_Min_Salinity, Daily_Max_Salinity, Daily_Mean_Salinity, Daily_StdDev_Salinity, Daily_SE_Salinity, Daily_Min_Sigma_t, Daily_Max_Sigma_t, Daily_Mean_Sigma_t, Daily_StdDev_Sigma_t and Daily_SE_Sigma_t as data set anomalies in the metadata ('add_anomalies') 05-Mar-2021: sorted by column Date(ascending) ('sortdata') 05-Mar-2021: updated 1 metadata fields in the Study sections ('addmeta') 05-Mar-2021: updated 1 metadata fields in the Dataset sections ('addmeta') 05-Mar-2021: imported Dataset, Project, Site, Study, Status, Supplement metadata descriptors from the GCE Metabase ('imp_gcemetadata') 05-Mar-2021: updated 57 metadata fields in the Dataset, Project, Site, Status, Study, Supplement sections ('addmeta') 05-Mar-2021: manually edited data set metadata ('ui_editmetadata') 05-Mar-2021: edited data set title in structure and metadata ('ui_editor') 05-Mar-2021: updated 1 metadata fields in the Dataset sections ('addmeta') 05-Mar-2021: imported Dataset, Project, Site, Study, Status, Supplement metadata descriptors from the GCE Metabase ('imp_gcemetadata') 05-Mar-2021: updated 57 metadata fields in the Dataset, Project, Site, Status, Study, Supplement sections ('addmeta') 05-Mar-2021: manually edited data set metadata ('ui_editmetadata') 05-Mar-2021: edited data set title in structure and metadata ('ui_editor') 05-Mar-2021: updated 1 metadata fields in the Dataset sections ('addmeta') 05-Mar-2021: imported Dataset, Project, Site, Study, Status, Supplement metadata descriptors from the GCE Metabase ('imp_gcemetadata') 05-Mar-2021: updated 57 metadata fields in the Dataset, Project, Site, Status, Study, Supplement sections ('addmeta') 05-Mar-2021: manually edited data set metadata ('ui_editmetadata') 05-Mar-2021: edited data set title in structure and metadata ('ui_editor') 05-Mar-2021: converted dates in column(s) Date to format yyyy-mm-dd HH:MM:SS 05-Mar-2021: flags for columns Daily_Min_Conductivity, Daily_Max_Conductivity, Daily_Mean_Conductivity, Daily_StdDev_Conductivity, Daily_SE_Conductivity, Daily_Min_Salinity, Daily_Max_Salinity, Daily_Mean_Salinity, Daily_StdDev_Salinity, Daily_SE_Salinity, Daily_Min_Sigma_t, Daily_Max_Sigma_t, Daily_Mean_Sigma_t, Daily_StdDev_Sigma_t and Daily_SE_Sigma_t converted to data columns, flag codes updated in metadata ('flags2cols') 05-Mar-2021: updated 6 metadata fields in the Data sections ('addmeta') 05-Mar-2021: updated 15 metadata fields in the Status, Data sections to reflect attribute metadata ('updatecols') 05-Mar-2021: parsed and formatted metadata ('listmeta') B. Variable Information 1. Variable Name: column 1. Site column 2. Station column 3. Longitude column 4. Latitude column 5. Date column 6. Year column 7. Month column 8. Day column 9. Missing_Temperature column 10. Percent_Missing_Temperature column 11. Flagged_Temperature column 12. Percent_Flagged_Temperature column 13. Daily_Num_Temperature column 14. Daily_Min_Temperature column 15. Daily_Max_Temperature column 16. Daily_Mean_Temperature column 17. Daily_StdDev_Temperature column 18. Daily_SE_Temperature column 19. Missing_Conductivity column 20. Percent_Missing_Conductivity column 21. Flagged_Conductivity column 22. Percent_Flagged_Conductivity column 23. Daily_Num_Conductivity column 24. Daily_Min_Conductivity column 25. Flag_Daily_Min_Conductivity column 26. Daily_Max_Conductivity column 27. Flag_Daily_Max_Conductivity column 28. Daily_Mean_Conductivity column 29. Flag_Daily_Mean_Conductivity column 30. Daily_StdDev_Conductivity column 31. Flag_Daily_StdDev_Conductivity column 32. Daily_SE_Conductivity column 33. Flag_Daily_SE_Conductivity column 34. Missing_Pressure column 35. Percent_Missing_Pressure column 36. Flagged_Pressure column 37. Percent_Flagged_Pressure column 38. Daily_Num_Pressure column 39. Daily_Min_Pressure column 40. Daily_Max_Pressure column 41. Daily_Mean_Pressure column 42. Daily_StdDev_Pressure column 43. Daily_SE_Pressure column 44. Missing_Depth column 45. Percent_Missing_Depth column 46. Flagged_Depth column 47. Percent_Flagged_Depth column 48. Daily_Num_Depth column 49. Daily_Min_Depth column 50. Daily_Max_Depth column 51. Daily_Mean_Depth column 52. Daily_StdDev_Depth column 53. Daily_SE_Depth column 54. Missing_Salinity column 55. Percent_Missing_Salinity column 56. Flagged_Salinity column 57. Percent_Flagged_Salinity column 58. Daily_Num_Salinity column 59. Daily_Min_Salinity column 60. Flag_Daily_Min_Salinity column 61. Daily_Max_Salinity column 62. Flag_Daily_Max_Salinity column 63. Daily_Mean_Salinity column 64. Flag_Daily_Mean_Salinity column 65. Daily_StdDev_Salinity column 66. Flag_Daily_StdDev_Salinity column 67. Daily_SE_Salinity column 68. Flag_Daily_SE_Salinity column 69. Missing_Sigma_t column 70. Percent_Missing_Sigma_t column 71. Flagged_Sigma_t column 72. Percent_Flagged_Sigma_t column 73. Daily_Num_Sigma_t column 74. Daily_Min_Sigma_t column 75. Flag_Daily_Min_Sigma_t column 76. Daily_Max_Sigma_t column 77. Flag_Daily_Max_Sigma_t column 78. Daily_Mean_Sigma_t column 79. Flag_Daily_Mean_Sigma_t column 80. Daily_StdDev_Sigma_t column 81. Flag_Daily_StdDev_Sigma_t column 82. Daily_SE_Sigma_t column 83. Flag_Daily_SE_Sigma_t 2. Variable Definition: column 1. Nearest nominal GCE-LTER sampling site column 2. Station determined by geographic database lookup of coordinates in columns Latitude and Longitude using a distance tolerance of 0.5km from registered station location column 3. Geographic longitude in decimal degrees column 4. Geographic latitude in decimal degrees column 5. Fractional MATLAB serial day (based on 1 = January 1, 0000) column 6. Calendar year column 7. Calendar month column 8. Calendar day column 9. Number of missing observations of Water temperature column 10. Percent missing observations of Water temperature column 11. Number of QC/QA-flagged observations of Water temperature column 12. Percent QC/QA-flagged observations of Water temperature column 13. Daily Observations of Water temperature column 14. Daily Minimum Water temperature column 15. Daily Maximum Water temperature column 16. Daily Mean Water temperature column 17. Daily Sample Standard Deviation of Water temperature column 18. Daily Standard Error of Water temperature column 19. Number of missing observations of Conductivity column 20. Percent missing observations of Conductivity column 21. Number of QC/QA-flagged observations of Conductivity column 22. Percent QC/QA-flagged observations of Conductivity column 23. Daily Observations of Conductivity column 24. Daily Minimum Conductivity column 25. QA/QC flags for Daily Minimum Conductivity (flagging criteria, where "x" is Daily_Min_Conductivity: Percent_Missing_Conductivity>35="I", Percent_Missing_Conductivity>15="Q", Percent_Flagged_Conductivity>35="Q") column 26. Daily Maximum Conductivity column 27. QA/QC flags for Daily Maximum Conductivity (flagging criteria, where "x" is Daily_Max_Conductivity: Percent_Missing_Conductivity>35="I", Percent_Missing_Conductivity>15="Q", Percent_Flagged_Conductivity>35="Q") column 28. Daily Mean Conductivity column 29. QA/QC flags for Daily Mean Conductivity (flagging criteria, where "x" is Daily_Mean_Conductivity: Percent_Missing_Conductivity>35="I", Percent_Missing_Conductivity>15="Q", Percent_Flagged_Conductivity>35="Q") column 30. Daily Sample Standard Deviation of Conductivity column 31. QA/QC flags for Daily Sample Standard Deviation of Conductivity (flagging criteria, where "x" is Daily_StdDev_Conductivity: Percent_Missing_Conductivity>35="I", Percent_Missing_Conductivity>15="Q", Percent_Flagged_Conductivity>35="Q") column 32. Daily Standard Error of Conductivity column 33. QA/QC flags for Daily Standard Error of Conductivity (flagging criteria, where "x" is Daily_SE_Conductivity: Percent_Missing_Conductivity>35="I", Percent_Missing_Conductivity>15="Q", Percent_Flagged_Conductivity>35="Q") column 34. Number of missing observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 35. Percent missing observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 36. Number of QC/QA-flagged observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 37. Percent QC/QA-flagged observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 38. Daily Observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 39. Daily Minimum Water pressure at sensor (approximately equivalent to water depth within 3% error) column 40. Daily Maximum Water pressure at sensor (approximately equivalent to water depth within 3% error) column 41. Daily Mean Water pressure at sensor (approximately equivalent to water depth within 3% error) column 42. Daily Sample Standard Deviation of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 43. Daily Standard Error of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 44. Number of missing observations of Water depth to the pressure sensor of the moored sonde column 45. Percent missing observations of Water depth to the pressure sensor of the moored sonde column 46. Number of QC/QA-flagged observations of Water depth to the pressure sensor of the moored sonde column 47. Percent QC/QA-flagged observations of Water depth to the pressure sensor of the moored sonde column 48. Daily Observations of Water depth to the pressure sensor of the moored sonde column 49. Daily Minimum Water depth to the pressure sensor of the moored sonde column 50. Daily Maximum Water depth to the pressure sensor of the moored sonde column 51. Daily Mean Water depth to the pressure sensor of the moored sonde column 52. Daily Sample Standard Deviation of Water depth to the pressure sensor of the moored sonde column 53. Daily Standard Error of Water depth to the pressure sensor of the moored sonde column 54. Number of missing observations of Salinity column 55. Percent missing observations of Salinity column 56. Number of QC/QA-flagged observations of Salinity column 57. Percent QC/QA-flagged observations of Salinity column 58. Daily Observations of Salinity column 59. Daily Minimum Salinity column 60. QA/QC flags for Daily Minimum Salinity (flagging criteria, where "x" is Daily_Min_Salinity: Percent_Missing_Salinity>35="I", Percent_Missing_Salinity>15="Q", Percent_Flagged_Salinity>35="Q") column 61. Daily Maximum Salinity column 62. QA/QC flags for Daily Maximum Salinity (flagging criteria, where "x" is Daily_Max_Salinity: Percent_Missing_Salinity>35="I", Percent_Missing_Salinity>15="Q", Percent_Flagged_Salinity>35="Q") column 63. Daily Mean Salinity column 64. QA/QC flags for Daily Mean Salinity (flagging criteria, where "x" is Daily_Mean_Salinity: Percent_Missing_Salinity>35="I", Percent_Missing_Salinity>15="Q", Percent_Flagged_Salinity>35="Q") column 65. Daily Sample Standard Deviation of Salinity column 66. QA/QC flags for Daily Sample Standard Deviation of Salinity (flagging criteria, where "x" is Daily_StdDev_Salinity: Percent_Missing_Salinity>35="I", Percent_Missing_Salinity>15="Q", Percent_Flagged_Salinity>35="Q") column 67. Daily Standard Error of Salinity column 68. QA/QC flags for Daily Standard Error of Salinity (flagging criteria, where "x" is Daily_SE_Salinity: Percent_Missing_Salinity>35="I", Percent_Missing_Salinity>15="Q", Percent_Flagged_Salinity>35="Q") column 69. Number of missing observations of Sigma-t (i.e. Density-1) column 70. Percent missing observations of Sigma-t (i.e. Density-1) column 71. Number of QC/QA-flagged observations of Sigma-t (i.e. Density-1) column 72. Percent QC/QA-flagged observations of Sigma-t (i.e. Density-1) column 73. Daily Observations of Sigma-t (i.e. Density-1) column 74. Daily Minimum Sigma-t (i.e. Density-1) column 75. QA/QC flags for Daily Minimum Sigma-t (i.e. Density-1) (flagging criteria, where "x" is Daily_Min_Sigma_t: Percent_Missing_Sigma_t>35="I", Percent_Missing_Sigma_t>15="Q", Percent_Flagged_Sigma_t>35="Q") column 76. Daily Maximum Sigma-t (i.e. Density-1) column 77. QA/QC flags for Daily Maximum Sigma-t (i.e. Density-1) (flagging criteria, where "x" is Daily_Max_Sigma_t: Percent_Missing_Sigma_t>35="I", Percent_Missing_Sigma_t>15="Q", Percent_Flagged_Sigma_t>35="Q") column 78. Daily Mean Sigma-t (i.e. Density-1) column 79. QA/QC flags for Daily Mean Sigma-t (i.e. Density-1) (flagging criteria, where "x" is Daily_Mean_Sigma_t: Percent_Missing_Sigma_t>35="I", Percent_Missing_Sigma_t>15="Q", Percent_Flagged_Sigma_t>35="Q") column 80. Daily Sample Standard Deviation of Sigma-t (i.e. Density-1) column 81. QA/QC flags for Daily Sample Standard Deviation of Sigma-t (i.e. Density-1) (flagging criteria, where "x" is Daily_StdDev_Sigma_t: Percent_Missing_Sigma_t>35="I", Percent_Missing_Sigma_t>15="Q", Percent_Flagged_Sigma_t>35="Q") column 82. Daily Standard Error of Sigma-t (i.e. Density-1) column 83. QA/QC flags for Daily Standard Error of Sigma-t (i.e. Density-1) (flagging criteria, where "x" is Daily_SE_Sigma_t: Percent_Missing_Sigma_t>35="I", Percent_Missing_Sigma_t>15="Q", Percent_Flagged_Sigma_t>35="Q") 3. Units of Measurement: column 1. none column 2. none column 3. degrees column 4. degrees column 5. yyyy-mm-dd HH:MM:SS column 6. YYYY column 7. MM column 8. DD column 9. count column 10. % column 11. count column 12. % column 13. count column 14. °C column 15. °C column 16. °C column 17. °C column 18. °C column 19. count column 20. % column 21. count column 22. % column 23. count column 24. S/m column 25. none column 26. S/m column 27. none column 28. S/m column 29. none column 30. S/m column 31. none column 32. S/m column 33. none column 34. count column 35. % column 36. count column 37. % column 38. count column 39. dbar column 40. dbar column 41. dbar column 42. dbar column 43. dbar column 44. count column 45. % column 46. count column 47. % column 48. count column 49. m column 50. m column 51. m column 52. m column 53. m column 54. count column 55. % column 56. count column 57. % column 58. count column 59. PSU column 60. none column 61. PSU column 62. none column 63. PSU column 64. none column 65. PSU column 66. none column 67. PSU column 68. none column 69. count column 70. % column 71. count column 72. % column 73. count column 74. kg/m^3 column 75. none column 76. kg/m^3 column 77. none column 78. kg/m^3 column 79. none column 80. kg/m^3 column 81. none column 82. kg/m^3 column 83. none 4. Data Type a. Storage Type: column 1. integer column 2. string column 3. floating-point column 4. floating-point column 5. string column 6. integer column 7. integer column 8. integer column 9. integer column 10. floating-point column 11. integer column 12. floating-point column 13. integer column 14. floating-point column 15. floating-point column 16. floating-point column 17. floating-point column 18. floating-point column 19. integer column 20. floating-point column 21. integer column 22. floating-point column 23. integer column 24. floating-point column 25. string column 26. floating-point column 27. string column 28. floating-point column 29. string column 30. floating-point column 31. string column 32. floating-point column 33. string column 34. integer column 35. floating-point column 36. integer column 37. floating-point column 38. integer column 39. floating-point column 40. floating-point column 41. floating-point column 42. floating-point column 43. floating-point column 44. integer column 45. floating-point column 46. integer column 47. floating-point column 48. integer column 49. floating-point column 50. floating-point column 51. floating-point column 52. floating-point column 53. floating-point column 54. integer column 55. floating-point column 56. integer column 57. floating-point column 58. integer column 59. floating-point column 60. string column 61. floating-point column 62. string column 63. floating-point column 64. string column 65. floating-point column 66. string column 67. floating-point column 68. string column 69. integer column 70. floating-point column 71. integer column 72. floating-point column 73. integer column 74. floating-point column 75. string column 76. floating-point column 77. string column 78. floating-point column 79. string column 80. floating-point column 81. string column 82. floating-point column 83. string b. Variable Codes: Flag_Daily_Min_Conductivity: Q = questionable value Flag_Daily_Max_Conductivity: Q = questionable value Flag_Daily_Mean_Conductivity: Q = questionable value Flag_Daily_StdDev_Conductivity: Q = questionable value Flag_Daily_SE_Conductivity: Q = questionable value Flag_Daily_Min_Salinity: Q = questionable value Flag_Daily_Max_Salinity: Q = questionable value Flag_Daily_Mean_Salinity: Q = questionable value Flag_Daily_StdDev_Salinity: Q = questionable value Flag_Daily_SE_Salinity: Q = questionable value Flag_Daily_Min_Sigma_t: Q = questionable value Flag_Daily_Max_Sigma_t: Q = questionable value Flag_Daily_Mean_Sigma_t: Q = questionable value Flag_Daily_StdDev_Sigma_t: Q = questionable value Flag_Daily_SE_Sigma_t: Q = questionable value c. Numeric Range: column 1. 11 to 11 column 2. (none) column 3. -81.4928 to -81.4928 column 4. 31.3794 to 31.3794 column 5. (none) column 6. 2018 to 2018 column 7. 1 to 12 column 8. 1 to 31 column 9. 0 to 0 column 10. 0 to 0 column 11. 0 to 2 column 12. 0 to 4 column 13. 48 to 48 column 14. 4.9809 to 29.6577 column 15. 5.5636 to 31.0221 column 16. 5.3194 to 30.2828 column 17. 0.075834 to 0.59262 column 18. 0.010946 to 0.085538 column 19. 0 to 0 column 20. 0 to 0 column 21. 0 to 48 column 22. 0 to 50 column 23. 48 to 48 column 24. 0.005503 to 0.030359 column 25. (none) column 26. 0.005989 to 0.2093 column 27. (none) column 28. 0.0057888 to 0.07176 column 29. (none) column 30. 1.7583e-05 to 0.044767 column 31. (none) column 32. 2.5379e-06 to 0.0064616 column 33. (none) column 34. 0 to 0 column 35. 0 to 0 column 36. 0 to 2 column 37. 0 to 4 column 38. 48 to 48 column 39. 0.3 to 2.119 column 40. 2.113 to 3.091 column 41. 1.2618 to 2.5718 column 42. 0.19682 to 0.65505 column 43. 0.028408 to 0.094548 column 44. 0 to 0 column 45. 0 to 0 column 46. 0 to 2 column 47. 0 to 4 column 48. 48 to 48 column 49. 0.29792 to 2.1043 column 50. 2.0984 to 3.0696 column 51. 1.253 to 2.554 column 52. 0.19546 to 0.65051 column 53. 0.028212 to 0.093893 column 54. 0 to 0 column 55. 0 to 0 column 56. 0 to 48 column 57. 0 to 50 column 58. 48 to 48 column 59. 0.037127 to 0.13752 column 60. (none) column 61. 0.039167 to 1.013 column 62. (none) column 63. 0.038363 to 0.33585 column 64. (none) column 65. 5.4883e-05 to 0.21533 column 66. (none) column 67. 7.9217e-06 to 0.03108 column 68. (none) column 69. 0 to 0 column 70. 0 to 0 column 71. 0 to 48 column 72. 0 to 50 column 73. 48 to 48 column 74. -4.6121 to 0.010678 column 75. (none) column 76. -4.1937 to 0.077314 column 77. (none) column 78. -4.3824 to 0.020667 column 79. (none) column 80. 0.004113 to 0.16185 column 81. (none) column 82. 0.00059366 to 0.023362 column 83. (none) d. Missing Value Code: 5. Data Format a. Column Type: column 1. numerical column 2. text column 3. numerical column 4. numerical column 5. text column 6. numerical column 7. numerical column 8. numerical column 9. numerical column 10. numerical column 11. numerical column 12. numerical column 13. numerical column 14. numerical column 15. numerical column 16. numerical column 17. numerical column 18. numerical column 19. numerical column 20. numerical column 21. numerical column 22. numerical column 23. numerical column 24. numerical column 25. text column 26. numerical column 27. text column 28. numerical column 29. text column 30. numerical column 31. text column 32. numerical column 33. text column 34. numerical column 35. numerical column 36. numerical column 37. numerical column 38. numerical column 39. numerical column 40. numerical column 41. numerical column 42. numerical column 43. numerical column 44. numerical column 45. numerical column 46. numerical column 47. numerical column 48. numerical column 49. numerical column 50. numerical column 51. numerical column 52. numerical column 53. numerical column 54. numerical column 55. numerical column 56. numerical column 57. numerical column 58. numerical column 59. numerical column 60. text column 61. numerical column 62. text column 63. numerical column 64. text column 65. numerical column 66. text column 67. numerical column 68. text column 69. numerical column 70. numerical column 71. numerical column 72. numerical column 73. numerical column 74. numerical column 75. text column 76. numerical column 77. text column 78. numerical column 79. text column 80. numerical column 81. text column 82. numerical column 83. text b. Number of Columns: 83 c. Decimal Places: column 1. 0 column 2. 0 column 3. 6 column 4. 6 column 5. 0 column 6. 0 column 7. 0 column 8. 0 column 9. 0 column 10. 2 column 11. 0 column 12. 2 column 13. 0 column 14. 3 column 15. 3 column 16. 4 column 17. 4 column 18. 5 column 19. 0 column 20. 2 column 21. 0 column 22. 2 column 23. 0 column 24. 3 column 25. 0 column 26. 3 column 27. 0 column 28. 4 column 29. 0 column 30. 4 column 31. 0 column 32. 5 column 33. 0 column 34. 0 column 35. 2 column 36. 0 column 37. 2 column 38. 0 column 39. 3 column 40. 3 column 41. 4 column 42. 4 column 43. 5 column 44. 0 column 45. 2 column 46. 0 column 47. 2 column 48. 0 column 49. 3 column 50. 3 column 51. 4 column 52. 4 column 53. 5 column 54. 0 column 55. 2 column 56. 0 column 57. 2 column 58. 0 column 59. 3 column 60. 0 column 61. 3 column 62. 0 column 63. 4 column 64. 0 column 65. 4 column 66. 0 column 67. 5 column 68. 0 column 69. 0 column 70. 2 column 71. 0 column 72. 2 column 73. 0 column 74. 3 column 75. 0 column 76. 3 column 77. 0 column 78. 4 column 79. 0 column 80. 4 column 81. 0 column 82. 5 column 83. 0 6. Logical Variable Type: column 1. nominal (discrete) column 2. nominal (none) column 3. geographic coordinate (continuous) column 4. geographic coordinate (continuous) column 5. datetime (none) column 6. datetime (discrete) column 7. datetime (discrete) column 8. datetime (discrete) column 9. calculation (discrete) column 10. calculation (continuous) column 11. calculation (discrete) column 12. calculation (continuous) column 13. calculation (discrete) column 14. calculation (continuous) column 15. calculation (continuous) column 16. calculation (continuous) column 17. calculation (continuous) column 18. calculation (continuous) column 19. calculation (discrete) column 20. calculation (continuous) column 21. calculation (discrete) column 22. calculation (continuous) column 23. calculation (discrete) column 24. calculation (continuous) column 25. coded value (none) column 26. calculation (continuous) column 27. coded value (none) column 28. calculation (continuous) column 29. coded value (none) column 30. calculation (continuous) column 31. coded value (none) column 32. calculation (continuous) column 33. coded value (none) column 34. calculation (discrete) column 35. calculation (continuous) column 36. calculation (discrete) column 37. calculation (continuous) column 38. calculation (discrete) column 39. calculation (continuous) column 40. calculation (continuous) column 41. calculation (continuous) column 42. calculation (continuous) column 43. calculation (continuous) column 44. calculation (discrete) column 45. calculation (continuous) column 46. calculation (discrete) column 47. calculation (continuous) column 48. calculation (discrete) column 49. calculation (continuous) column 50. calculation (continuous) column 51. calculation (continuous) column 52. calculation (continuous) column 53. calculation (continuous) column 54. calculation (discrete) column 55. calculation (continuous) column 56. calculation (discrete) column 57. calculation (continuous) column 58. calculation (discrete) column 59. calculation (continuous) column 60. coded value (none) column 61. calculation (continuous) column 62. coded value (none) column 63. calculation (continuous) column 64. coded value (none) column 65. calculation (continuous) column 66. coded value (none) column 67. calculation (continuous) column 68. coded value (none) column 69. calculation (discrete) column 70. calculation (continuous) column 71. calculation (discrete) column 72. calculation (continuous) column 73. calculation (discrete) column 74. calculation (continuous) column 75. coded value (none) column 76. calculation (continuous) column 77. coded value (none) column 78. calculation (continuous) column 79. coded value (none) column 80. calculation (continuous) column 81. coded value (none) column 82. calculation (continuous) column 83. coded value (none) 7. Flagging Criteria: column 1. none column 2. none column 3. none column 4. none column 5. none column 6. none column 7. none column 8. none column 9. none column 10. none column 11. none column 12. none column 13. none column 14. col_Percent_Missing_Temperature>35="I";col_Percent_Missing_Temperature>15="Q";col_Percen t_Flagged_Temperature>35="Q" column 15. col_Percent_Missing_Temperature>35="I";col_Percent_Missing_Temperature>15="Q";col_Percen t_Flagged_Temperature>35="Q" column 16. col_Percent_Missing_Temperature>35="I";col_Percent_Missing_Temperature>15="Q";col_Percen t_Flagged_Temperature>35="Q" column 17. col_Percent_Missing_Temperature>35="I";col_Percent_Missing_Temperature>15="Q";col_Percen t_Flagged_Temperature>35="Q" column 18. col_Percent_Missing_Temperature>35="I";col_Percent_Missing_Temperature>15="Q";col_Percen t_Flagged_Temperature>35="Q" column 19. none column 20. none column 21. none column 22. none column 23. none column 24. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 25. none column 26. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 27. none column 28. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 29. none column 30. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 31. none column 32. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 33. none column 34. none column 35. none column 36. none column 37. none column 38. none column 39. col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag ged_Pressure>35="Q" column 40. col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag ged_Pressure>35="Q" column 41. col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag ged_Pressure>35="Q" column 42. col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag ged_Pressure>35="Q" column 43. col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag ged_Pressure>35="Q" column 44. none column 45. none column 46. none column 47. none column 48. none column 49. col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De pth>35="Q" column 50. col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De pth>35="Q" column 51. col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De pth>35="Q" column 52. col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De pth>35="Q" column 53. col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De pth>35="Q" column 54. none column 55. none column 56. none column 57. none column 58. none column 59. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 60. none column 61. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 62. none column 63. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 64. none column 65. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 66. none column 67. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 68. none column 69. none column 70. none column 71. none column 72. none column 73. none column 74. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 75. none column 76. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 77. none column 78. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 79. none column 80. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 81. none column 82. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 83. none C. Data Anomalies: Values of 84 records in Daily_Min_Conductivity were flagged as Q (questionable value). Values of 84 records in Daily_Max_Conductivity were flagged as Q (questionable value). Values of 84 records in Daily_Mean_Conductivity were flagged as Q (questionable value). Values of 84 records in Daily_StdDev_Conductivity were flagged as Q (questionable value). Values of 84 records in Daily_SE_Conductivity were flagged as Q (questionable value). Values of 84 records in Daily_Min_Salinity were flagged as Q (questionable value). Values of 84 records in Daily_Max_Salinity were flagged as Q (questionable value). Values of 84 records in Daily_Mean_Salinity were flagged as Q (questionable value). Values of 84 records in Daily_StdDev_Salinity were flagged as Q (questionable value). Values of 84 records in Daily_SE_Salinity were flagged as Q (questionable value). Values of 84 records in Daily_Min_Sigma_t were flagged as Q (questionable value). Values of 84 records in Daily_Max_Sigma_t were flagged as Q (questionable value). Values of 84 records in Daily_Mean_Sigma_t were flagged as Q (questionable value). Values of 84 records in Daily_StdDev_Sigma_t were flagged as Q (questionable value). Values of 84 records in Daily_SE_Sigma_t were flagged as Q (questionable value). V. Supplemental Descriptors A. Data Acquisition 1. Data Forms: Copies of CTD cast logs and raw data are maintained at the Georgia Coastal Ecosystems Information Management Office 2. Form Location: GCE-LTER Information Management Office, Dept. of Marine Sciences, University of Georgia, Athens, GA 30602 3. Data Entry Validation: B. Quality Assurance/Quality Control Procedures: QA/QC flags are generated automatically according to domain criteria specified for each data column, then subsequently reviewed and revised as appropriate. Coded flag columns are generated for each data column, listing qualifier flags assigned to the data value on the corresponding row. C. Supplemental Materials: not applicable D. Computer Programs: Sea-Bird Electronics Sea-Soft version 4.246, MATLAB version 2013B E. Archival Practices: Data sets and documentation are stored in structured binary (Matlab 5.x files) and delimited ASCII text formats, and archived on magnetic tape and CD at the GCE LTER Information Management Office at the University of Georgia, Athens, Georgia, USA F. Publications: not specified G. History of Data Set Usage 1. Data Request History: not specified 2. Data Set Update History: none 3. Review History: none 4. Questions and Comments from Users: none