I. Data Set Descriptors A. Title: Daniela Di Iorio. 2015. Daily Summary of Continuous salinity, temperature and depth measurements from moored hydrographic data loggers deployed at GCE7_Hydro (Altamaha River near Carrs Island, Georgia) from 01-Jan-2011 through 31-Dec-2011. Georgia Coastal Ecosystems LTER Data Catalog (data set PHY-GCEM-1201e; http://gce-lter.marsci.uga.edu/public/app/dataset_details.asp?accession=PHY-GCEM-1201e) B. Accession Number: PHY-GCEM-1201e C. Description 1. Originator(s): Name: Daniela Di Iorio Address: Department of Marine Sciences, University of Georgia, Athens, Georgia Postal Code: 30602 Country: USA Email: daniela@uga.edu 2. Abstract: Conductivity, temperature and pressure were measured continuously at Georgia Coastal Ecosystems LTER sampling location GCE7_Hydro (Altamaha River near Carrs Island, Georgia) from 01-Jan-2011 through 31-Dec-2011. 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 Fluxes 6. Georeferences: geographic coordinates as data set columns 7. Submission Date: not submitted D. Keywords: conductivity, density, depth, Hydrographic Moorings, hydrography, Inorganic Nutrients, monitoring, mooring, pressure, salinity, sonde, temperature, water column, water quality II. Research Origin Descriptors A. Overall Project Description 1. Project Title: Georgia Coastal Ecosystems LTER III 2. Principal Investigators: Name: Merryl Alber Address: Dept. of Marine Sciences, University of Georgia, Athens, Georgia Postal Code: 30602-3636 Country: USA Email: malber@uga.edu Name: Steven C. Pennings Address: Department of Biology and Biochemistry, University of Houston, Houston, Texas Postal Code: 77204-5513 Country: USA Email: scpennin@central.uh.edu 3. Funding Period: 27-Dec-2006 to 17-Sep-2012 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-9982133 and OCE-0620959 B. Sub-project Description 1. Site Description a. Geographic Location: GCE-AL -- Altamaha River, Georgia, USA GCE7_Hydro -- Hammersmith Creek hydrographic datalogger deployment Coordinates: GCE-AL -- NW: 81 34 56.3 W, 31 24 05.1 N NE: 81 14 16.6 W, 31 24 05.1 N SE: 81 14 16.6 W, 31 17 45.7 N SW: 81 34 56.3 W, 31 17 45.7 N GCE7_Hydro -- 81 28 31.7 W, 31 20 17.5 N b. Physiographic Region: GCE-AL -- Estuary and tidal marsh GCE7_Hydro -- Estuary and tidal marsh c. Landform Components: GCE-AL -- Intertidal marsh bordering sounds, tidal channels and creeks GCE7_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. GCE7_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 GCE7_Hydro -- Flat, with elevations ranging from 0-3.4m above mean low tide f. Geology, Lithology and Soils: GCE-AL -- unspecified GCE7_Hydro -- unspecified g. Vegetation Communities: GCE-AL -- unspecified GCE7_Hydro -- unspecified h. History of Land Use and Disturbance: i. Climate: Climate summary for Sapelo Island, Georgia, based on NWS data from 1980-2001: Daily-aggregated Values: Mean (sample standard deviation) mean air temperature: 19.78°C (6.98°C) minimum air temperature: 14.64°C (7.54°C) maximum air temperature: 24.62°C (6.78°C) total precipitation: 3.58mm (11.35mm) Yearly-aggregated Values: Mean (sample standard deviation) total precipitation (1981-2000): 1302mm (250mm) 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: 01-Jan-2011 End of Observations: 31-Dec-2011 3. Research Methods a. Field and Laboratory Methods: 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. 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. 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. 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. Instrumentation: Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 1793, last factory calibration 08-Jul-2010) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 6440, last factory calibration 20-Aug-2008) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 1791, last factory calibration 27-Jan-2011) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 6440, last factory calibration 20-Aug-2008) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 2539, last factory calibration 19-Apr-2011) c. Taxonomy and Systematics: not applicable d. Speclies List: e. Permit History: 4. Project Personnel a. Personnel: 1: Daniela Di Iorio 2: Wade M. Sheldon 3: Jacob Shalack 4: Daniel Saucedo b. Affiliations: 1: University of Georgia, Athens, Georgia 2: University of Georgia, Athens, Georgia 3: University of Georgia Marine Inst., Sapelo Island, Georgia 4: University of Georgia Marine Inst., Sapelo Island, Georgia III. Data Set Status and Accessibility A. Status 1. Latest Update: 04-Jun-2015 2. Latest Archive Date: 3. Latest Metadata Update: 04-Jun-2015 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. Position: GCE-LTER Information Manager Address: Dept. of Marine Sciences, University of Georgia, Athens, Georgia Postal Code: 30602-3636 Country: USA Email: gcelter@uga.edu 3. Copyright Restrictions: not copyrighted 4. Restrictions: All publications based on this data set must cite the contributor and Georgia Coastal Ecosystems LTER project, and two copies of the manuscript must be submitted to the GCE-LTER Information Management Office. a. Release Date: Affiliates: 02-Feb-2012, Public: 01-Feb-2013 b. Citation: Data provided by the Georgia Coastal Ecosystems Long Term Ecological Research Project, supported by funds from National Science Foundation Grants OCE-9982133, OCE-0620959 and OCE-1237140 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-1201e_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.3 (06-Apr-2015) Data structure version: GCE Data Structure 1.1 (29-Mar-2001) Original data files processed: 07110293.asc (3738 records) 07110640.asc (5041 records) 07110691.asc (242 records) 07110940.cnv (4119 records) 07120139.cnv (6586 records) Data processing history: 24-Feb-2011: data uploaded from SBE 37-SM MicroCAT using SEATERM software version 1.59 04-Mar-2011: new GCE Data Structure 1.1 created ('newstruct') 04-Mar-2011: data imported from processed SBE SM-37 sonde data file '07110293.asc' (3738 records) ('imp_gcesonde') 04-Mar-2011: deleted column Second from the structure ('deletecols') 04-Mar-2011: calculated numeric MATLAB serial date from individual date component columns, added 'Date' column at position 1 ('add_datecol') 04-Mar-2011: added column 'Instrument' at position 1 ('addcol') 04-Mar-2011: added column 'Pump' at position 2 ('addcol') 04-Mar-2011: Q/C flagging criteria applied for column(s) Pump, 'flags' field updated ('dataflag') 04-Mar-2011: added column 'Latitude' at position 1 ('addcol') 04-Mar-2011: Q/C flagging criteria applied for column(s) Latitude, 'flags' field updated ('dataflag') 04-Mar-2011: added column 'Longitude' at position 1 ('addcol') 04-Mar-2011: Q/C flagging criteria applied for column(s) Longitude, 'flags' field updated ('dataflag') 04-Mar-2011: added column 'Site' at position 1 ('addcol') 04-Mar-2011: added column 'Calibration' at position 18 ('addcol') 04-Mar-2011: Q/C flagging criteria applied for column(s) Calibration, 'flags' field updated ('dataflag') 04-Mar-2011: updated 22 metadata fields in the Data, Dataset, Site, Status, Study, Supplement sections ('addmeta') 04-Mar-2011: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 04-Mar-2011: edited structure data ('ui_datagrid'): deleted record(s) 3734, 3735, 3736, 3737 and 3738 04-Mar-2011: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 11-Mar-2011: query 'Year == 2011' run, returned 2623 of 3733 data rows ('querydata') 11-Mar-2011: automatically assigned study date metadata descriptors based on the range of date values in date/time columns (add_studydates) 11-Mar-2011: updated title ('newtitle') 11-Mar-2011: updated 2 metadata fields in the Dataset, Status sections ('newtitle') 14-Jun-2011: 5036 rows added at the bottom of the data set ('datamerge') 14-Jun-2011: updated 13 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 14-Jun-2011: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 14-Jun-2011: manually edited data set metadata ('ui_editmetadata') 14-Jun-2011: edited data set title in structure and metadata ('ui_editor') 14-Jun-2011: inserted 3 new records with date/time values and NaN/null data values (replicating common values in the non-data columns Site, Longitude, Latitude, Instrument, Pump and Calibration) to fill in date/time interval gaps in the data series ('fill_date_gaps') 14-Jun-2011: sorted by column Date(ascending) ('sortdata') 14-Jun-2011: 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') 14-Jun-2011: updated 2 metadata fields in the Data, Status sections ('ui_interp_missing') 14-Jun-2011: sorted by column Date(ascending) ('sortdata') 14-Jun-2011: replaced 3 missing values in column Temperature with estimated values based on 1D interpolation of Temperature as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Jun-2011: 3 values in 'Temperature' were updated with new values ('update_data'): changed record 2624 from NaN to 15.064, changed record 2625 from NaN to 15.110, changed record 2626 from NaN to 15.157 14-Jun-2011: Q/C flagging criteria applied for column(s) Temperature, 'flags' field updated ('dataflag') 14-Jun-2011: replaced 3 missing values in column Conductivity with estimated values based on 1D interpolation of Conductivity as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Jun-2011: 3 values in 'Conductivity' were updated with new values ('update_data'): changed record 2624 from NaN to 0.012, changed record 2625 from NaN to 0.020, changed record 2626 from NaN to 0.028 14-Jun-2011: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field updated ('dataflag') 14-Jun-2011: replaced 3 missing values in column Pressure with estimated values based on 1D interpolation of Pressure as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Jun-2011: 3 values in 'Pressure' were updated with new values ('update_data'): changed record 2624 from NaN to 1.934, changed record 2625 from NaN to 2.187, changed record 2626 from NaN to 2.465 14-Jun-2011: Q/C flagging criteria applied for column(s) Pressure, 'flags' field updated ('dataflag') 14-Jun-2011: replaced 3 missing values in column Depth with estimated values based on 1D interpolation of Depth as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Jun-2011: 3 values in 'Depth' were updated with new values ('update_data'): changed record 2624 from NaN to 1.921, changed record 2625 from NaN to 2.172, changed record 2626 from NaN to 2.448 14-Jun-2011: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated ('dataflag') 14-Jun-2011: replaced 3 missing values in column Salinity with estimated values based on 1D interpolation of Salinity as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Jun-2011: 3 values in 'Salinity' were updated with new values ('update_data'): changed record 2624 from NaN to 0.071, changed record 2625 from NaN to 0.119, changed record 2626 from NaN to 0.167 14-Jun-2011: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 14-Jun-2011: 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 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Jun-2011: 3 values in 'Sigma_t' were updated with new values ('update_data'): changed record 2624 from NaN to -0.850, changed record 2625 from NaN to -0.824, changed record 2626 from NaN to -0.797 14-Jun-2011: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated ('dataflag') 14-Jun-2011: documented flagged and missing values in columns Temperature, Conductivity, Pressure, Depth, Salinity and Sigma_t as data set anomalies in the metadata ('add_anomalies') 14-Jun-2011: manually edited data set metadata ('ui_editmetadata') 08-Sep-2011: 241 rows added at the bottom of the data set ('datamerge') 08-Sep-2011: updated 14 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 08-Sep-2011: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 08-Sep-2011: 4113 rows added at the bottom of the data set ('datamerge') 08-Sep-2011: updated 14 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 08-Sep-2011: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 08-Sep-2011: manually edited data set metadata ('ui_editmetadata') 08-Sep-2011: edited data set title in structure and metadata ('ui_editor') 08-Sep-2011: inserted 13 new records with date/time values and NaN/null data values (replicating common values in the non-data columns Site, Longitude, Latitude, Instrument, Pump and Calibration) to fill in date/time interval gaps in the data series ('fill_date_gaps') 08-Sep-2011: sorted by column Date(ascending) ('sortdata') 08-Sep-2011: 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') 08-Sep-2011: manually edited data set metadata ('ui_editmetadata') 08-Sep-2011: updated 2 metadata fields in the Data, Status sections ('ui_interp_missing') 08-Sep-2011: sorted by column Date(ascending) ('sortdata') 08-Sep-2011: replaced 13 missing values in column Temperature with estimated values based on 1D interpolation of Temperature as a function of Date using the MATLAB 8.3 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 15 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 08-Sep-2011: 13 values in 'Temperature' were updated with new values ('update_data'): changed record 7663 from NaN to 29.567, changed record 7664 from NaN to 29.604, changed record 7665 from NaN to 29.662, changed record 7666 from NaN to 29.735, changed record 7667 from NaN to 29.820, changed record 7668 from NaN to 29.913, changed record 7669 from NaN to 30.009, changed record 7670 from NaN to 30.105, changed record 7671 from NaN to 30.196, changed record 7672 from NaN to 30.277, changed record 7914 from NaN to 30.856, changed record 7915 from NaN to 30.822, changed record 7916 from NaN to 30.769 08-Sep-2011: Q/C flagging criteria applied for column(s) Temperature, 'flags' field updated ('dataflag') 08-Sep-2011: replaced 13 missing values in column Conductivity with estimated values based on 1D interpolation of Conductivity as a function of Date using the MATLAB 8.3 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 15 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 08-Sep-2011: 13 values in 'Conductivity' were updated with new values ('update_data'): changed record 7663 from NaN to 0.034, changed record 7664 from NaN to 0.037, changed record 7665 from NaN to 0.041, changed record 7666 from NaN to 0.047, changed record 7667 from NaN to 0.054, changed record 7668 from NaN to 0.062, changed record 7669 from NaN to 0.072, changed record 7670 from NaN to 0.083, changed record 7671 from NaN to 0.094, changed record 7672 from NaN to 0.107, changed record 7914 from NaN to 0.048, changed record 7915 from NaN to 0.051, changed record 7916 from NaN to 0.057 08-Sep-2011: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field updated ('dataflag') 08-Sep-2011: replaced 13 missing values in column Pressure with estimated values based on 1D interpolation of Pressure as a function of Date using the MATLAB 8.3 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 15 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 08-Sep-2011: 13 values in 'Pressure' were updated with new values ('update_data'): changed record 7663 from NaN to 1.133, changed record 7664 from NaN to 1.252, changed record 7665 from NaN to 1.431, changed record 7666 from NaN to 1.653, changed record 7667 from NaN to 1.901, changed record 7668 from NaN to 2.159, changed record 7669 from NaN to 2.410, changed record 7670 from NaN to 2.638, changed record 7671 from NaN to 2.825, changed record 7672 from NaN to 2.956, changed record 7914 from NaN to 1.269, changed record 7915 from NaN to 1.493, changed record 7916 from NaN to 1.774 08-Sep-2011: Q/C flagging criteria applied for column(s) Pressure, 'flags' field updated ('dataflag') 08-Sep-2011: replaced 13 missing values in column Depth with estimated values based on 1D interpolation of Depth as a function of Date using the MATLAB 8.3 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 15 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 08-Sep-2011: 13 values in 'Depth' were updated with new values ('update_data'): changed record 7663 from NaN to 1.125, changed record 7664 from NaN to 1.244, changed record 7665 from NaN to 1.421, changed record 7666 from NaN to 1.642, changed record 7667 from NaN to 1.888, changed record 7668 from NaN to 2.144, changed record 7669 from NaN to 2.394, changed record 7670 from NaN to 2.619, changed record 7671 from NaN to 2.805, changed record 7672 from NaN to 2.935, changed record 7914 from NaN to 1.260, changed record 7915 from NaN to 1.483, changed record 7916 from NaN to 1.762 08-Sep-2011: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated ('dataflag') 08-Sep-2011: replaced 13 missing values in column Salinity with estimated values based on 1D interpolation of Salinity as a function of Date using the MATLAB 8.3 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 15 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 08-Sep-2011: 13 values in 'Salinity' were updated with new values ('update_data'): changed record 7663 from NaN to 0.150, changed record 7664 from NaN to 0.162, changed record 7665 from NaN to 0.181, changed record 7666 from NaN to 0.206, changed record 7667 from NaN to 0.238, changed record 7668 from NaN to 0.276, changed record 7669 from NaN to 0.319, changed record 7670 from NaN to 0.366, changed record 7671 from NaN to 0.418, changed record 7672 from NaN to 0.474, changed record 7914 from NaN to 0.206, changed record 7915 from NaN to 0.221, changed record 7916 from NaN to 0.248 08-Sep-2011: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 08-Sep-2011: replaced 13 missing values in column Sigma_t with estimated values based on 1D interpolation of Sigma_t as a function of Date using the MATLAB 8.3 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 15 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 08-Sep-2011: 13 values in 'Sigma_t' were updated with new values ('update_data'): changed record 7663 from NaN to -4.107, changed record 7664 from NaN to -4.106, changed record 7665 from NaN to -4.105, changed record 7666 from NaN to -4.102, changed record 7667 from NaN to -4.099, changed record 7668 from NaN to -4.095, changed record 7669 from NaN to -4.090, changed record 7670 from NaN to -4.084, changed record 7671 from NaN to -4.076, changed record 7672 from NaN to -4.067, changed record 7914 from NaN to -4.458, changed record 7915 from NaN to -4.437, changed record 7916 from NaN to -4.401 08-Sep-2011: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated ('dataflag') 08-Sep-2011: manually edited data set metadata ('ui_editmetadata') 08-Sep-2011: documented flagged and missing values in columns Temperature, Conductivity, Pressure, Depth, Salinity and Sigma_t as data set anomalies in the metadata ('add_anomalies') 16-Nov-2011: matched 12029 out of 12029 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) 16-Nov-2011: added column 'Station' at position 2 ('addcol') 16-Nov-2011: Q/C flagging criteria applied for column(s) Station, 'flags' field updated ('dataflag') 16-Nov-2011: added geographic metadata based on matching values in column Station to location and station names registered in 'geo_locations.mat' ('add_sitemetadata') 16-Nov-2011: updated 9 metadata fields in the Site, Status sections ('add_sitemetadata') 14-Apr-2012: 6581 rows added at the bottom of the data set ('datamerge') 14-Apr-2012: updated 14 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 14-Apr-2012: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 14-Apr-2012: manually edited data set metadata ('ui_editmetadata') 14-Apr-2012: edited data set title in structure and metadata ('ui_editor') 14-Apr-2012: inserted 7 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 ('fill_date_gaps') 14-Apr-2012: sorted by column Date(ascending) ('sortdata') 14-Apr-2012: 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') 14-Apr-2012: query 'Year=2011' run, returned 17520 of 18617 data rows ('querydata') 14-Apr-2012: automatically assigned study date metadata descriptors based on the range of date values in date/time columns (add_studydates) 14-Apr-2012: manually edited data set metadata ('ui_editmetadata') 14-Apr-2012: edited data set title in structure and metadata ('ui_editor') 14-Apr-2012: updated 2 metadata fields in the Data, Status sections ('ui_interp_missing') 14-Apr-2012: sorted by column Date(ascending) ('sortdata') 14-Apr-2012: replaced 7 missing values in column Temperature with estimated values based on 1D interpolation of Temperature as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Apr-2012: 7 values in 'Temperature' were updated with new values ('update_data'): changed record 12030 from NaN to 27.853, changed record 12031 from NaN to 27.861, changed record 12032 from NaN to 27.875, changed record 12033 from NaN to 27.894, changed record 12034 from NaN to 27.918, changed record 12035 from NaN to 27.948, changed record 12036 from NaN to 27.983 14-Apr-2012: Q/C flagging criteria applied for column(s) Temperature, 'flags' field updated ('dataflag') 14-Apr-2012: replaced 7 missing values in column Conductivity with estimated values based on 1D interpolation of Conductivity as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Apr-2012: 7 values in 'Conductivity' were updated with new values ('update_data'): changed record 12030 from NaN to 0.452, changed record 12031 from NaN to 0.393, changed record 12032 from NaN to 0.339, changed record 12033 from NaN to 0.291, changed record 12034 from NaN to 0.248, changed record 12035 from NaN to 0.209, changed record 12036 from NaN to 0.175 14-Apr-2012: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field updated ('dataflag') 14-Apr-2012: replaced 7 missing values in column Pressure with estimated values based on 1D interpolation of Pressure as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Apr-2012: 7 values in 'Pressure' were updated with new values ('update_data'): changed record 12030 from NaN to 2.102, changed record 12031 from NaN to 1.922, changed record 12032 from NaN to 1.739, changed record 12033 from NaN to 1.566, changed record 12034 from NaN to 1.411, changed record 12035 from NaN to 1.288, changed record 12036 from NaN to 1.206 14-Apr-2012: Q/C flagging criteria applied for column(s) Pressure, 'flags' field updated ('dataflag') 14-Apr-2012: replaced 7 missing values in column Depth with estimated values based on 1D interpolation of Depth as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Apr-2012: 7 values in 'Depth' were updated with new values ('update_data'): changed record 12030 from NaN to 2.087, changed record 12031 from NaN to 1.908, changed record 12032 from NaN to 1.727, changed record 12033 from NaN to 1.555, changed record 12034 from NaN to 1.402, changed record 12035 from NaN to 1.279, changed record 12036 from NaN to 1.197 14-Apr-2012: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated ('dataflag') 14-Apr-2012: replaced 7 missing values in column Salinity with estimated values based on 1D interpolation of Salinity as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Apr-2012: 7 values in 'Salinity' were updated with new values ('update_data'): changed record 12030 from NaN to 2.273, changed record 12031 from NaN to 1.961, changed record 12032 from NaN to 1.680, changed record 12033 from NaN to 1.430, changed record 12034 from NaN to 1.206, changed record 12035 from NaN to 1.007, changed record 12036 from NaN to 0.831 14-Apr-2012: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 14-Apr-2012: replaced 7 missing values in column Sigma_t with estimated values based on 1D interpolation of Sigma_t as a function of Date using the MATLAB 7.13 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 14-Apr-2012: 7 values in 'Sigma_t' were updated with new values ('update_data'): changed record 12030 from NaN to -2.013, changed record 12031 from NaN to -2.244, changed record 12032 from NaN to -2.453, changed record 12033 from NaN to -2.642, changed record 12034 from NaN to -2.815, changed record 12035 from NaN to -2.975, changed record 12036 from NaN to -3.124 14-Apr-2012: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated ('dataflag') 14-Apr-2012: manually edited data set metadata ('ui_editmetadata') 14-Apr-2012: documented flagged and missing values in columns Temperature, Conductivity, Pressure, Depth, Salinity and Sigma_t as data set anomalies in the metadata ('add_anomalies') 14-Apr-2012: manually edited data set metadata ('ui_editmetadata') 13-Feb-2015: copied QA/QC flags for column(s) Depth to column(s) Pressure, overwriting any existing flags, and set QA/QC criteria for destination column(s) to 'manual' ('copyflags') 27-Feb-2015: copied QA/QC flags for column(s) Depth to column(s) Pressure, overwriting any existing flags, and set QA/QC criteria for destination column(s) to 'manual' ('copyflags') 03-Jun-2015: query 'Year=2011' run, returned 17520 of 17520 data rows ('querydata') 03-Jun-2015: 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') 03-Jun-2015: imported all documentation metadata from the template 'GCE_Sonde_GCE2', retaining existing attribute descriptors for all columns ('meta_template') 03-Jun-2015: updated 40 metadata fields in the Data, Dataset, Project, Site, Status, Study, Supplement sections ('addmeta') 03-Jun-2015: updated title ('newtitle') 03-Jun-2015: added geographic metadata based on matching values in column Station to location and station names registered in 'geo_locations.mat' ('add_sitemetadata') 03-Jun-2015: updated 8 metadata fields in the Site sections ('addmeta') 03-Jun-2015: updated title ('newtitle') 03-Jun-2015: updated 1 metadata fields in the Dataset sections ('addmeta') 04-Jun-2015: deleted columns Calibration and Pump from the structure ('deletecols') 04-Jun-2015: performed daily statistical aggregation on data columns Temperature, Conductivity, Pressure, Depth, Salinity and Sigma_t by grouping on columns Site, Longitude, Latitude, Year, Month and Day (aggr_datetime) 04-Jun-2015: updated title ('newtitle') 04-Jun-2015: updated 1 metadata fields in the Dataset sections ('addmeta') 04-Jun-2015: 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 4 ('add_datecol') 04-Jun-2015: updated 1 metadata fields in the Study sections ('addmeta') 04-Jun-2015: converted dates in column(s) Date to format yyyy-mm-dd 04-Jun-2015: updated 6 metadata fields in the Data sections ('addmeta') 04-Jun-2015: updated 15 metadata fields in the Status, Data sections to reflect attribute metadata ('updatecols') 04-Jun-2015: parsed and formatted metadata ('listmeta') B. Variable Information 1. Variable Name: column 1. Site column 2. Longitude column 3. Latitude column 4. Date column 5. Year column 6. Month column 7. Day column 8. Missing_Temperature column 9. Percent_Missing_Temperature column 10. Flagged_Temperature column 11. Percent_Flagged_Temperature column 12. Daily_Num_Temperature column 13. Daily_Min_Temperature column 14. Daily_Max_Temperature column 15. Daily_Mean_Temperature column 16. Daily_StdDev_Temperature column 17. Daily_SE_Temperature column 18. Missing_Conductivity column 19. Percent_Missing_Conductivity column 20. Flagged_Conductivity column 21. Percent_Flagged_Conductivity column 22. Daily_Num_Conductivity column 23. Daily_Min_Conductivity column 24. Daily_Max_Conductivity column 25. Daily_Mean_Conductivity column 26. Daily_StdDev_Conductivity column 27. Daily_SE_Conductivity column 28. Missing_Pressure column 29. Percent_Missing_Pressure column 30. Flagged_Pressure column 31. Percent_Flagged_Pressure column 32. Daily_Num_Pressure column 33. Daily_Min_Pressure column 34. Daily_Max_Pressure column 35. Daily_Mean_Pressure column 36. Daily_StdDev_Pressure column 37. Daily_SE_Pressure column 38. Missing_Depth column 39. Percent_Missing_Depth column 40. Flagged_Depth column 41. Percent_Flagged_Depth column 42. Daily_Num_Depth column 43. Daily_Min_Depth column 44. Daily_Max_Depth column 45. Daily_Mean_Depth column 46. Daily_StdDev_Depth column 47. Daily_SE_Depth column 48. Missing_Salinity column 49. Percent_Missing_Salinity column 50. Flagged_Salinity column 51. Percent_Flagged_Salinity column 52. Daily_Num_Salinity column 53. Daily_Min_Salinity column 54. Daily_Max_Salinity column 55. Daily_Mean_Salinity column 56. Daily_StdDev_Salinity column 57. Daily_SE_Salinity column 58. Missing_Sigma_t column 59. Percent_Missing_Sigma_t column 60. Flagged_Sigma_t column 61. Percent_Flagged_Sigma_t column 62. Daily_Num_Sigma_t column 63. Daily_Min_Sigma_t column 64. Daily_Max_Sigma_t column 65. Daily_Mean_Sigma_t column 66. Daily_StdDev_Sigma_t column 67. Daily_SE_Sigma_t 2. Variable Definition: column 1. Nearest nominal GCE-LTER sampling site column 2. Geographic longitude in decimal degrees column 3. Geographic latitude in decimal degrees column 4. Fractional MATLAB serial day (based on 1 = January 1, 0000) column 5. Calendar year column 6. Calendar month column 7. Calendar day column 8. Number of missing observations of Water temperature column 9. Percent missing observations of Water temperature column 10. Number of QC/QA-flagged observations of Water temperature column 11. Percent QC/QA-flagged observations of Water temperature column 12. Daily Observations of Water temperature column 13. Daily Minimum Water temperature column 14. Daily Maximum Water temperature column 15. Daily Mean Water temperature column 16. Daily Sample Standard Deviation of Water temperature column 17. Daily Standard Error of Water temperature column 18. Number of missing observations of Conductivity column 19. Percent missing observations of Conductivity column 20. Number of QC/QA-flagged observations of Conductivity column 21. Percent QC/QA-flagged observations of Conductivity column 22. Daily Observations of Conductivity column 23. Daily Minimum Conductivity column 24. Daily Maximum Conductivity column 25. Daily Mean Conductivity column 26. Daily Sample Standard Deviation of Conductivity column 27. Daily Standard Error of Conductivity column 28. Number of missing observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 29. Percent missing observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 30. Number of QC/QA-flagged observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 31. Percent QC/QA-flagged observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 32. Daily Observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 33. Daily Minimum Water pressure at sensor (approximately equivalent to water depth within 3% error) column 34. Daily Maximum Water pressure at sensor (approximately equivalent to water depth within 3% error) column 35. Daily Mean Water pressure at sensor (approximately equivalent to water depth within 3% error) column 36. Daily Sample Standard Deviation of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 37. Daily Standard Error of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 38. Number of missing observations of Water depth to the pressure sensor of the moored sonde column 39. Percent missing observations of Water depth to the pressure sensor of the moored sonde column 40. Number of QC/QA-flagged observations of Water depth to the pressure sensor of the moored sonde column 41. Percent QC/QA-flagged observations of Water depth to the pressure sensor of the moored sonde column 42. Daily Observations of Water depth to the pressure sensor of the moored sonde column 43. Daily Minimum Water depth to the pressure sensor of the moored sonde column 44. Daily Maximum Water depth to the pressure sensor of the moored sonde column 45. Daily Mean Water depth to the pressure sensor of the moored sonde column 46. Daily Sample Standard Deviation of Water depth to the pressure sensor of the moored sonde column 47. Daily Standard Error of Water depth to the pressure sensor of the moored sonde column 48. Number of missing observations of Salinity column 49. Percent missing observations of Salinity column 50. Number of QC/QA-flagged observations of Salinity column 51. Percent QC/QA-flagged observations of Salinity column 52. Daily Observations of Salinity column 53. Daily Minimum Salinity column 54. Daily Maximum Salinity column 55. Daily Mean Salinity column 56. Daily Sample Standard Deviation of Salinity column 57. Daily Standard Error of Salinity column 58. Number of missing observations of Sigma-t (i.e. Density-1) column 59. Percent missing observations of Sigma-t (i.e. Density-1) column 60. Number of QC/QA-flagged observations of Sigma-t (i.e. Density-1) column 61. Percent QC/QA-flagged observations of Sigma-t (i.e. Density-1) column 62. Daily Observations of Sigma-t (i.e. Density-1) column 63. Daily Minimum Sigma-t (i.e. Density-1) column 64. Daily Maximum Sigma-t (i.e. Density-1) column 65. Daily Mean Sigma-t (i.e. Density-1) column 66. Daily Sample Standard Deviation of Sigma-t (i.e. Density-1) column 67. Daily Standard Error of Sigma-t (i.e. Density-1) 3. Units of Measurement: column 1. none column 2. degrees column 3. degrees column 4. yyyy-mm-dd column 5. YYYY column 6. MM column 7. DD column 8. count column 9. % column 10. count column 11. % column 12. count column 13. °C column 14. °C column 15. °C column 16. °C column 17. °C column 18. count column 19. % column 20. count column 21. % column 22. count column 23. S/m column 24. S/m column 25. S/m column 26. S/m column 27. S/m column 28. count column 29. % column 30. count column 31. % column 32. count column 33. dbar column 34. dbar column 35. dbar column 36. dbar column 37. dbar column 38. count column 39. % column 40. count column 41. % column 42. count column 43. m column 44. m column 45. m column 46. m column 47. m column 48. count column 49. % column 50. count column 51. % column 52. count column 53. PSU column 54. PSU column 55. PSU column 56. PSU column 57. PSU column 58. count column 59. % column 60. count column 61. % column 62. count column 63. kg/m^3 column 64. kg/m^3 column 65. kg/m^3 column 66. kg/m^3 column 67. kg/m^3 4. Data Type a. Storage Type: column 1. integer column 2. floating-point column 3. floating-point column 4. string column 5. integer column 6. integer column 7. integer column 8. integer column 9. floating-point column 10. integer column 11. floating-point column 12. integer column 13. floating-point column 14. floating-point column 15. floating-point column 16. floating-point column 17. floating-point column 18. integer column 19. floating-point column 20. integer column 21. floating-point column 22. integer column 23. floating-point column 24. floating-point column 25. floating-point column 26. floating-point column 27. floating-point column 28. integer column 29. floating-point column 30. integer column 31. floating-point column 32. integer column 33. floating-point column 34. floating-point column 35. floating-point column 36. floating-point column 37. floating-point column 38. integer column 39. floating-point column 40. integer column 41. floating-point column 42. integer column 43. floating-point column 44. floating-point column 45. floating-point column 46. floating-point column 47. floating-point column 48. integer column 49. floating-point column 50. integer column 51. floating-point column 52. integer column 53. floating-point column 54. floating-point column 55. floating-point column 56. floating-point column 57. floating-point column 58. integer column 59. floating-point column 60. integer column 61. floating-point column 62. integer column 63. floating-point column 64. floating-point column 65. floating-point column 66. floating-point column 67. floating-point b. Variable Codes: c. Numeric Range: column 1. 7 to 7 column 2. -81.4755 to -81.4755 column 3. 31.3384 to 31.3384 column 4. (none) column 5. 2011 to 2011 column 6. 1 to 12 column 7. 1 to 31 column 8. 0 to 0 column 9. 0 to 0 column 10. 0 to 10 column 11. 0 to 17.2414 column 12. 48 to 48 column 13. 5.8786 to 32.1112 column 14. 6.7607 to 33.3622 column 15. 6.3142 to 32.46 column 16. 0.093 to 0.69905 column 17. 0.013423 to 0.1009 column 18. 0 to 0 column 19. 0 to 0 column 20. 0 to 10 column 21. 0 to 17.2414 column 22. 48 to 48 column 23. 0.00668 to 0.25199 column 24. 0.00705 to 2.4985 column 25. 0.0068223 to 1.014 column 26. 4.212e-05 to 0.66186 column 27. 6.0795e-06 to 0.095531 column 28. 0 to 0 column 29. 0 to 0 column 30. 0 to 10 column 31. 0 to 17.2414 column 32. 48 to 48 column 33. 0.735 to 2.068 column 34. 2.567 to 3.492 column 35. 1.7395 to 2.8467 column 36. 0.41861 to 0.74421 column 37. 0.060422 to 0.10742 column 38. 0 to 0 column 39. 0 to 0 column 40. 0 to 10 column 41. 0 to 17.2414 column 42. 48 to 48 column 43. 0.72992 to 2.0537 column 44. 2.5492 to 3.4678 column 45. 1.7275 to 2.827 column 46. 0.41571 to 0.73906 column 47. 0.060003 to 0.10667 column 48. 0 to 0 column 49. 0 to 0 column 50. 0 to 10 column 51. 0 to 17.2414 column 52. 48 to 48 column 53. 0.041579 to 1.3644 column 54. 0.042414 to 15.7107 column 55. 0.041914 to 5.6848 column 56. 0.00014193 to 4.1453 column 57. 2.0486e-05 to 0.59832 column 58. 0 to 0 column 59. 0 to 0 column 60. 0 to 10 column 61. 0 to 17.2414 column 62. 48 to 48 column 63. -5.2082 to -0.016389 column 64. -4.3868 to 9.4428 column 65. -4.6518 to 1.8624 column 66. 0.0060339 to 3.1299 column 67. 0.00087092 to 0.45177 d. Missing Value Code: 5. Data Format a. Column Type: column 1. numerical column 2. numerical column 3. numerical column 4. text column 5. numerical 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. numerical column 26. numerical column 27. numerical column 28. numerical column 29. numerical column 30. numerical column 31. numerical column 32. numerical column 33. numerical 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. numerical column 61. numerical column 62. numerical column 63. numerical column 64. numerical column 65. numerical column 66. numerical column 67. numerical b. Number of Columns: 67 c. Decimal Places: column 1. 0 column 2. 6 column 3. 6 column 4. 0 column 5. 0 column 6. 0 column 7. 0 column 8. 0 column 9. 2 column 10. 0 column 11. 2 column 12. 0 column 13. 3 column 14. 3 column 15. 4 column 16. 4 column 17. 5 column 18. 0 column 19. 2 column 20. 0 column 21. 2 column 22. 0 column 23. 3 column 24. 3 column 25. 4 column 26. 4 column 27. 5 column 28. 0 column 29. 2 column 30. 0 column 31. 2 column 32. 0 column 33. 3 column 34. 3 column 35. 4 column 36. 4 column 37. 5 column 38. 0 column 39. 2 column 40. 0 column 41. 2 column 42. 0 column 43. 3 column 44. 3 column 45. 4 column 46. 4 column 47. 5 column 48. 0 column 49. 2 column 50. 0 column 51. 2 column 52. 0 column 53. 3 column 54. 3 column 55. 4 column 56. 4 column 57. 5 column 58. 0 column 59. 2 column 60. 0 column 61. 2 column 62. 0 column 63. 3 column 64. 3 column 65. 4 column 66. 4 column 67. 5 6. Logical Variable Type: column 1. nominal (discrete) column 2. geographic coordinate (continuous) column 3. geographic coordinate (continuous) column 4. datetime (none) column 5. datetime (discrete) column 6. datetime (discrete) column 7. datetime (discrete) column 8. calculation (discrete) column 9. calculation (continuous) column 10. calculation (discrete) column 11. calculation (continuous) column 12. calculation (discrete) column 13. calculation (continuous) column 14. calculation (continuous) column 15. calculation (continuous) column 16. calculation (continuous) column 17. calculation (continuous) column 18. calculation (discrete) column 19. calculation (continuous) column 20. calculation (discrete) column 21. calculation (continuous) column 22. calculation (discrete) column 23. calculation (continuous) column 24. calculation (continuous) column 25. calculation (continuous) column 26. calculation (continuous) column 27. calculation (continuous) column 28. calculation (discrete) column 29. calculation (continuous) column 30. calculation (discrete) column 31. calculation (continuous) column 32. calculation (discrete) column 33. calculation (continuous) column 34. calculation (continuous) column 35. calculation (continuous) column 36. calculation (continuous) column 37. calculation (continuous) column 38. calculation (discrete) column 39. calculation (continuous) column 40. calculation (discrete) column 41. calculation (continuous) column 42. calculation (discrete) column 43. calculation (continuous) column 44. calculation (continuous) column 45. calculation (continuous) column 46. calculation (continuous) column 47. calculation (continuous) column 48. calculation (discrete) column 49. calculation (continuous) column 50. calculation (discrete) column 51. calculation (continuous) column 52. calculation (discrete) column 53. calculation (continuous) column 54. calculation (continuous) column 55. calculation (continuous) column 56. calculation (continuous) column 57. calculation (continuous) column 58. calculation (discrete) column 59. calculation (continuous) column 60. calculation (discrete) column 61. calculation (continuous) column 62. calculation (discrete) column 63. calculation (continuous) column 64. calculation (continuous) column 65. calculation (continuous) column 66. calculation (continuous) column 67. calculation (continuous) 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. col_Percent_Missing_Temperature>35="I";col_Percent_Missing_Temperature>15="Q";col_Percen t_Flagged_Temperature>35="Q" 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. none column 19. none column 20. none column 21. none column 22. none column 23. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 24. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 25. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 26. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 27. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 28. none column 29. none column 30. none column 31. none column 32. none column 33. col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag ged_Pressure>35="Q" column 34. col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag ged_Pressure>35="Q" column 35. col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag ged_Pressure>35="Q" column 36. col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag ged_Pressure>35="Q" column 37. col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag ged_Pressure>35="Q" column 38. none column 39. none column 40. none column 41. none column 42. none column 43. col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De pth>35="Q" column 44. col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De pth>35="Q" column 45. col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De pth>35="Q" column 46. col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De pth>35="Q" column 47. col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De pth>35="Q" column 48. none column 49. none column 50. none column 51. none column 52. none column 53. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 54. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 55. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 56. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 57. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 58. none column 59. none column 60. none column 61. none column 62. none column 63. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 64. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 65. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 66. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 67. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" C. Data Anomalies: 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: not specified 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: G. History of Data Set Usage 1. Data Request History: 2. Data Set Update History: 3. Review History: Instrument deployment, maintenance and retrieval observations: Sonde# 1793 Site# 7 Set up by J. Shalack Date 12/8/10 Time on 2100 UTC Date 12/8/10 Time into water 1846 Date 2/24/11 Time out of water 1523 Date 2/24/11 Time off 1802 Sample interval 1800 Deployment information Date 12/8/10 Time 1846 ysi sal 0.4 ysi temp 10.4 water depth na Retrieval information Date 2/24/11 Time 1523 ysi sal 0.1 ysi temp 15.1 water depth 3.7 m Instrument condition- conductivity tube clean Upload filename 07110293 Maintenance record Date 12/20/10 Time 1902 Sal 0.1 Temp 8.4 Depth 3.2 m Condition - conductivity tube very clean Date 1/11/11 Time 1708 Sal 0.1 Temp 8.0 Depth na Condition- conductivity tube very clean Date 2/3/11 Time 1740 Sal 0.1 Temp 12.3 Depth 3.6 m Condition- conductivity tube very clean Instrument deployment, maintenance and retrieval observations: Sonde# 6440 Site# 7 Set up by J.Shalack Date 2/24/11 Time on 1700 UTC Date 2/24/11 Time into water 1523 Date 6/9/11 Time out of water 1443 Date 6/9/11 Time off 1722 Sample interval 1800 Deployment information Date 2/24/11 Time 1523 ysi sal 0.1 ysi temp 15.1 water depth 3.7 m Retrieval information Date 6/9/11 Time 1443 ysi sal 0.1 ysi temp 29.6 water depth 2.9 m Instrument condition- conductivity tube very clean Upload filename 07110640 Maintenance record Date 3/11/11 Time 1432 Sal 0.1 Temp 15.3 Depth 3.1 m Condition - conductivity tube very clean Date 3/17/11 Time 1632 Sal 0.1 Temp 17.5 Depth 3.6 m Condition - conductivity tube very clean Date 4/4/11 Time 1853 Sal 0.1 Temp 18.3 Depth 3.7 m Condition - conductivity tube very clean Date 4/18/11 Time 1703 Sal 0.1 Temp 20.2 Depth na Condition - conductivity tube very clean Date 5/3/11 Time 1718 Sal 0.1 Temp 24.9 Depth 3.3 m Condition - conductivity tube very clean Date 5/9/11 Time 1348 Sal 0.1 Temp 23.1 Depth 3.3 m Condition - conductivity tube very clean Date 5/24/11 Time 1601 Sal 0.1 Temp 28.1 Depth 4.0 m Condition - conductivity tube very clean Instrument deployment, maintenance and retrieval observations: Sonde# 1791 Site# 7 Set up by Shalack Date 6/9/11 Time on 2000 UTC Date 6/9/11 Time into water 1443 Date 6/14/11 Time out of water 2002 Date 6/14/11 Time off na Sample interval 1800 Deployment information Date 6/9/11 Time 1443 ysi sal 0.1 ysi temp 29.6 water depth 2.9 m Retrieval information Date 6/14/11 Time 2002 ysi sal 0.2 ysi temp 31.0 water depth na Instrument condition- conductivity tube very clean Upload filename 07110691 Instrument deployment, maintenance and retrieval observations: Sonde# 6440 Site# 7 Set up by J. Shalack Date 6/14/11 Time on 2200 UTC Date 6/14/11 Time into water 2002 Date 9/8/11 Time out of water 1416 Date 9/8/11 Time off 1728 Sample interval 1800 Deployment information Date 6/14/11 Time 2002 ysi sal 0.2 ysi temp 31.0 water depth na Retrieval information Date 9/8/11 Time 1416 ysi sal 2.2 ysi temp 27.8 water depth 3.8 m Instrument condition- conductivity tube very clean Upload filename 07110940 Maintenance record Date 6/22/11 Time 1732 Sal 0.8 Temp 31.4 Depth 4.8m Condition - conductivity tube clean Date 7/5/11 Time 1507 Sal 0.5 Temp 30.9 Depth na Condition - conductivity tube very clean Date 7/20/11 Time 1405 Sal 0.2 Temp 29.3 Depth na Condition - conductivity tube clean Date 8/5/11 Time 1405 Sal 0.2 Temp 31.8 Depth na Condition - conductivity tube very clean Date 8/15/11 Time 2233 Sal 0.4 Temp 32.1 Depth 2.6 m Condition - conductivity tube very clean Date 8/30/11 Time 2132 Sal 1.2 Temp 31.1 Depth 2.7 m Condition - conductivity tube clean Instrument deployment, maintenance and retrieval observations: Sonde# 2539 Site# 7 Set up by J Shalack & C Reddy Date 9/8/11 Time on 1800 UTC Date 9/8/11 Time into water 1416 Date 1/23/12 Time out of water 2002 Date 1/23/12 Time off 2240 Sample interval 1800 Deployment information Date 9/8/11 Time 1416 ysi sal 2.2 ysi temp 27.8 water depth 3.8 m Retrieval information Date 1/23/12 Time 2002 ysi sal 0.3 ysi temp 14.2 water depth 3.0 m Instrument condition- conductivity tube Very Clean Upload filename 07120139 Maintenance record Date 9/25/11 Time 2005 Sal 0.8 Temp 27.2 Depth 3.0 m Condition - conductivity tube Very Clean Date 10/5/11 Time 1715 Sal 0.3 Temp 23.8 Depth 3.9 m Condition - conductivity tube Very Clean Date 10/21/11 Time 1540 Sal 0.3 Temp 20.2 Depth 2.4 m Condition - conductivity tube Very Clean Date 11/3/11 Time 1623 Sal 0.4 Temp 18.1 Depth n/a m Condition - conductivity tube Very Clean Date 11/17/11 Time 1445 Sal 0.5 Temp 18.8 Depth 3.5 m Condition - conductivity tube Very Clean Date 12/6/11 Time 1747 Sal 0.5 Temp 16.4 Depth 2.8 m Condition - conductivity tube Very Clean Date 12/18/11 Time 1533 Sal 0.2 Temp 13.5 Depth n/a m Condition - conductivity tube Very Clean Date 1/19/12 Time 2050 Sal 0.6 Temp 12.3 Depth 2.6 m Condition - conductivity tube Clean. Cable hook around shackle - up ~4cm. 4. Questions and Comments from Users: none