I. Data Set Descriptors A. Title: Jackson O. Blanton. 2015. Daily Summary of Continuous salinity, temperature and depth measurements from moored hydrographic data loggers deployed at GCE8_Hydro (Altamaha River near Aligator Creek, Georgia) from 01-Jan-2002 through 31-Dec-2002. Georgia Coastal Ecosystems LTER Data Catalog (data set PHY-GCEM-0303f2; http://gce-lter.marsci.uga.edu/public/app/dataset_details.asp?accession=PHY-GCEM-0303f2) B. Accession Number: PHY-GCEM-0303f2 C. Description 1. Originator(s): Name: Jackson O. Blanton Address: 10 Ocean Science Circle, Savannah, Georgia Postal Code: 31411 Country: USA Email: jack.blanton@skio.usg.edu 2. Abstract: Conductivity, temperature and pressure were measured continuously at Georgia Coastal Ecosystems LTER sampling location GCE8_Hydro (Altamaha River near Aligator Creek, Georgia) from 01-Jan-2002 through 31-Dec-2002. 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, 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 Project 2. Principal Investigators: Name: James T. Hollibaugh Address: Dept. of Marine Sciences, University of Georgia, Athens, Georgia Postal Code: 30602-3636 Country: USA Email: aquadoc@uga.edu 3. Funding Period: May 01, 2000 to May 01, 2006 4. Objectives: To investigate the linkages between coastal and distant upland areas in central Georgia mediated by surface and ground water delivery to the coastal zone. This will be addressed by examining the relationship between variability in environmental factors driven by river flow, primarily salinity, and ecosystem processes and structure. 5. Abstract: We propose to establish a Long Term Ecological Research site on the central Georgia coast in the vicinity of Sapelo Island. This is a barrier island and marsh complex with the Altamaha River, one of the largest and least developed rivers on the east coast of the US, as the primary source of fresh water. The proposed study would investigate the linkages between local and distant upland areas mediated by water - surface water and ground water - delivery to the coastal zone. We would explicitly examine the relationship between variability in environmental factors driven by river flow, primarily salinity because we can measure it at high frequency, and ecosystem processes and structure. We will accomplish this by comparing estuary/marsh complexes separated from the Altamaha River by one or two lagoonal estuary/marsh complexes that damp and attenuate the river signal. This spatial gradient is analogous to the temporal trend in riverine influence expected as a result of development in the watershed. We will implement a monitoring system that documents physical and biological variables and use the time trends and spatial distributions of these variables and of their variance structure to address questions about the factors controlling distributions, trophic structure, diversity, and biogeochemistry. An existing GIS-based hydrologic model will be modified to incorporate changes in river water resulting from changes in land use patterns that can be expected as the watershed develops. This model will be linked to ecosystem models and will serve as an heuristic and management tool. Another consequence of coastal development is that as river flow decreases, groundwater flow increases and becomes nutrified. We will compare the effects of ground water discharge from the surficial aquifer in relatively pristine (Sapelo Island) versus more urbanized (mainland) sites to assess the relative importance of fresh water versus nutrients to productivity, structure and biomass turnover rate in marshes influenced by groundwater. We will also investigate the effect of marine processes (tides, storm surge) on mixing across the fresh/salt interface in the surficial aquifer. Additional physical studies will relate the morphology of salt marsh - tidal creek channel complexes to tidal current distributions and exchange. These findings will be incorporated into a physical model that will be coupled to an existing ecosystem model. The land/ocean margin ecosystem lies at the interface between two ecosystems in which distinctly different groups of decomposers control organic matter degradation. The terrestrial ecosystem is largely dominated by fungal decomposers, while bacterial decomposers dominate the marine ecosystem. Both groups are important in salt marsh-dominated ecosystems. Specific studies will examine, at the level of individual cells and hyphae, the relationship bacteria and fungi in the consortia that decompose standing dead Spartina and other marsh plants and examine how, or if, this changes along the salinity gradient. 6. Funding Source: NSF OCE 9982133 B. Sub-project Description 1. Site Description a. Geographic Location: GCE-AL -- Altamaha River, Georgia, USA GCE8_Hydro -- Alligator 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 GCE8_Hydro -- 81 24 36.2 W, 31 18 37.0 N b. Physiographic Region: GCE-AL -- Estuary and tidal marsh GCE8_Hydro -- Estuary and tidal marsh c. Landform Components: GCE-AL -- Intertidal marsh bordering sounds, tidal channels and creeks GCE8_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. GCE8_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 GCE8_Hydro -- Flat, with elevations ranging from 0-3.4m above mean low tide f. Geology, Lithology and Soils: GCE-AL -- unspecified GCE8_Hydro -- unspecified g. Vegetation Communities: GCE-AL -- unspecified GCE8_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-2002 End of Observations: 31-Dec-2002 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 1796, last factory calibration 24-Feb-2001) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 1996, last factory calibration 10-Aug-2001) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 1794, last factory calibration 20-Feb-2001) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 1795, last factory calibration 20-Feb-2001) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 1667, last factory calibration 07-Aug-2001) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 1793, last factory calibration 24-Feb-2001) c. Taxonomy and Systematics: not applicable d. Speclies List: e. Permit History: 4. Project Personnel a. Personnel: 1: Jackson O. Blanton 2: Julie Amft 3: Kenneth Helm 4: Wade M. Sheldon b. Affiliations: 1: Skidaway Institute of Oceanography, Savannah, Georgia 2: Skidaway Institute of Oceanography, Savannah, Georgia 3: University of Georgia Marine Institute, Sapelo Island, Georgia 4: University of Georgia, Athens, Georgia III. Data Set Status and Accessibility A. Status 1. Latest Update: 03-Jun-2015 2. Latest Archive Date: 3. Latest Metadata Update: 03-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: Mar 17, 2003, Public: May 01, 2003 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-0303f2_Daily_5_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, E = data value estimated by interpolation 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: 08020196.asc (3507 records) 08020396.asc (3072 records) 08020594.asc (2977 records) 08020795.asc (3365 records) 08021067.asc (3410 records) 08030193.asc (4659 records) Data processing history: 08-Jan-2002: data uploaded from SBE 37-SM MicroCAT using SEATERM software version 1.21 15-Jan-2003: new GCE Data Structure 1.1 created ('newstruct') 15-Jan-2003: data imported from processed SBE SM-37 sonde data file '08020196.asc' (3507 records) ('imp_gcesonde') 15-Jan-2003: updated 25 metadata fields in the Data, Dataset, Site, Status, Study, Supplement sections ('addmeta') 15-Jan-2003: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 15-Jan-2003: 3072 rows added at the bottom of the data set ('datamerge') 15-Jan-2003: updated 11 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 15-Jan-2003: 2977 rows added at the bottom of the data set ('datamerge') 15-Jan-2003: updated 11 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 15-Jan-2003: 3365 rows added at the bottom of the data set ('datamerge') 15-Jan-2003: updated 11 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 15-Jan-2003: 3410 rows added at the bottom of the data set ('datamerge') 15-Jan-2003: updated 11 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 15-Jan-2003: 4659 rows added at the bottom of the data set ('datamerge') 15-Jan-2003: updated 11 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 15-Jan-2003: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 15-Jan-2003: manually edited data set metadata ('ui_editmetadata') 15-Jan-2003: edited data set title in structure and metadata ('ui_editor') 20-Feb-2003: edited structure data ('ui_datagrid'): deleted record(s) 3505, 3506, 3507 and 3508, deleted record(s) 6575, deleted record(s) 9551, deleted record(s) 12911, 12912, 12913, 12914 and 12915, deleted record(s) 16317, 16318, 16319 and 16320, deleted record(s) 20972, 20973, 20974 and 20975 20-Feb-2003: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 20-Feb-2003: updated 2 metadata fields in the Data, Status sections ('addmeta') 20-Feb-2003: QA/QC flags assigned by visual inspection (ui_visualqc); flags set on 1349 records in Conductivity; flags cleared on Conductivity record(s): 13508, 13509, 14970, 14971, 15657 and 15658; flags cleared on Salinity record(s): 12382, 13076, 15358 and 15409 22-Apr-2003: Q/C flagging criteria of columns Temperature, Pressure, Depth, Salinity and Sigma_t edited ('ui_editor') 22-Apr-2003: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 29-Jul-2003: deleted the following rows in all columns with values in any column assigned QA/QC flag(s) X (excise row flag): 7632, 17363 and 18085 ('cullflags') 29-Jul-2003: added QA/QC flags from column(s) Conductivity, Temperature and Pressure to flags for column(s) Salinity and Sigma_t, and set QA/QC criteria to 'manual' (copyflags) 29-Jul-2003: query 'Year == 2002' run, returned 17511 of 20968 data rows ('querydata') 29-Jul-2003: automatically assigned study date metadata descriptors based on the range of date values in column Date (add_studydates) 29-Jul-2003: manually edited data set metadata ('ui_editmetadata') 29-Jul-2003: edited data set title in structure and metadata ('ui_editor') 15-Oct-2004: edited units and description for column Date to change 'Julian days' to 'serial day' ('juliandate2serialdate') 24-Jan-2005: updated 2 metadata fields in the Dataset, Status sections ('addmeta') 15-Sep-2005: updated 3 metadata fields in the Status sections ('addmeta') 24-Feb-2006: updated 2 metadata fields in the Dataset, Status sections ('addmeta') 24-Feb-2006: inserted 9 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') 24-Feb-2006: sorted by column Date(ascending) ('sortdata') 24-Feb-2006: 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') 17-Apr-2006: standardized case of date component column units to prevent unit conversion issues ('batch_update_datetime'): updated units for column Year from 'yyyy' to 'YYYY'; updated units for column Month from 'mm' to 'MM'; updated units for column Day from 'dd' to 'DD' 26-Sep-2008: query 'Year = 2002' run, returned 17520 of 17520 data rows ('querydata') 26-Sep-2008: updated title ('newtitle') 26-Sep-2008: updated 2 metadata fields in the Dataset, Status sections ('newtitle') 26-Sep-2008: updated 3 metadata fields in the Status sections ('addmeta') 22-Apr-2011: updated 3 metadata fields in the Status sections ('addmeta') 22-Apr-2011: updated 3 metadata fields in the Status sections ('addmeta') 16-Nov-2011: matched 17520 out of 17520 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') 03-Jun-2015: query 'Year=2002' 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_GCE1', retaining existing attribute descriptors for all columns ('meta_template') 03-Jun-2015: updated 44 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') 03-Jun-2015: deleted columns TotalDepth, Calibration and Pump from the structure ('deletecols') 03-Jun-2015: converted values in all columns assigned QA/QC flag(s) I (invalid value (out of range)) to NaN/empty: 739 records in Conductivity, 739 records in Salinity, 739 records in Sigma_t ('nullflags') 03-Jun-2015: sorted by column Date(ascending) ('sortdata') 03-Jun-2015: updated 1 metadata fields in the Data sections ('addmeta') 03-Jun-2015: replaced 9 missing values in column Temperature with estimated values based on 1D interpolation of Temperature as a function of Date using the MATLAB 8.2 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') 03-Jun-2015: 9 values in 'Temperature' were updated with new values ('update_data'): changed record 4448 from NaN to 21.997, changed record 9727 from NaN to 30.050, changed record 9728 from NaN to 30.132, changed record 9729 from NaN to 30.250, changed record 9730 from NaN to 30.391, changed record 13137 from NaN to 27.876, changed record 13138 from NaN to 27.870, changed record 14185 from NaN to 22.463, changed record 14907 from NaN to 19.143 03-Jun-2015: Q/C flagging criteria applied for column(s) Temperature, 'flags' field updated ('dataflag') 03-Jun-2015: replaced 9 missing values in column Conductivity with estimated values based on 1D interpolation of Conductivity as a function of Date using the MATLAB 8.2 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') 03-Jun-2015: 9 values in 'Conductivity' were updated with new values ('update_data'): changed record 4448 from NaN to 0.144, changed record 9727 from NaN to 1.170, changed record 9728 from NaN to 1.410, changed record 9729 from NaN to 1.674, changed record 9730 from NaN to 1.887, changed record 13137 from NaN to 0.273, changed record 13138 from NaN to 0.276, changed record 14185 from NaN to 1.034, changed record 14907 from NaN to 0.462 03-Jun-2015: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field updated ('dataflag') 03-Jun-2015: replaced 9 missing values in column Pressure with estimated values based on 1D interpolation of Pressure as a function of Date using the MATLAB 8.2 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') 03-Jun-2015: 9 values in 'Pressure' were updated with new values ('update_data'): changed record 4448 from NaN to 2.112, changed record 9727 from NaN to 2.190, changed record 9728 from NaN to 1.946, changed record 9729 from NaN to 1.703, changed record 9730 from NaN to 1.482, changed record 13137 from NaN to 1.688, changed record 13138 from NaN to 1.916, changed record 14185 from NaN to 2.546, changed record 14907 from NaN to 2.413 03-Jun-2015: Q/C flagging criteria applied for column(s) Pressure, 'flags' field updated ('dataflag') 03-Jun-2015: replaced 9 missing values in column Depth with estimated values based on 1D interpolation of Depth as a function of Date using the MATLAB 8.2 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') 03-Jun-2015: 9 values in 'Depth' were updated with new values ('update_data'): changed record 4448 from NaN to 2.097, changed record 9727 from NaN to 2.174, changed record 9728 from NaN to 1.932, changed record 9729 from NaN to 1.691, changed record 9730 from NaN to 1.471, changed record 13137 from NaN to 1.676, changed record 13138 from NaN to 1.903, changed record 14185 from NaN to 2.528, changed record 14907 from NaN to 2.396 03-Jun-2015: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated ('dataflag') 03-Jun-2015: replaced 9 missing values in column Salinity with estimated values based on 1D interpolation of Salinity as a function of Date using the MATLAB 8.2 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') 03-Jun-2015: 9 values in 'Salinity' were updated with new values ('update_data'): changed record 4448 from NaN to 0.787, changed record 9727 from NaN to 6.007, changed record 9728 from NaN to 7.336, changed record 9729 from NaN to 8.796, changed record 9730 from NaN to 9.973, changed record 13137 from NaN to 1.327, changed record 13138 from NaN to 1.344, changed record 14185 from NaN to 6.171, changed record 14907 from NaN to 2.822 03-Jun-2015: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 03-Jun-2015: replaced 9 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.2 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') 03-Jun-2015: 9 values in 'Sigma_t' were updated with new values ('update_data'): changed record 4448 from NaN to -1.626, changed record 9727 from NaN to 0.117, changed record 9728 from NaN to 1.066, changed record 9729 from NaN to 2.096, changed record 9730 from NaN to 2.923, changed record 13137 from NaN to -2.734, changed record 13138 from NaN to -2.719, changed record 14185 from NaN to 2.329, changed record 14907 from NaN to 0.532 03-Jun-2015: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated ('dataflag') 03-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) 03-Jun-2015: updated title ('newtitle') 03-Jun-2015: updated 1 metadata fields in the Dataset sections ('addmeta') 03-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') 03-Jun-2015: 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') 03-Jun-2015: converted values in all columns assigned QA/QC flag(s) I (invalid value (out of range)) to NaN/empty: Daily_Min_Conductivity record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_Max_Conductivity record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_Mean_Conductivity record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_StdDev_Conductivity record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_SE_Conductivity record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_Min_Salinity record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_Max_Salinity record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_Mean_Salinity record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_StdDev_Salinity record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_SE_Salinity record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_Min_Sigma_t record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_Max_Sigma_t record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_Mean_Sigma_t record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_StdDev_Sigma_t record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260, Daily_SE_Sigma_t record(s) 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 259 and 260 ('nullflags') 03-Jun-2015: updated 1 metadata fields in the Study sections ('addmeta') 03-Jun-2015: converted dates in column(s) Date to format yyyy-mm-dd 03-Jun-2015: 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') 03-Jun-2015: updated 6 metadata fields in the Data sections ('addmeta') 03-Jun-2015: updated 15 metadata fields in the Status, Data sections to reflect attribute metadata ('updatecols') 03-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. Flag_Daily_Min_Conductivity column 25. Daily_Max_Conductivity column 26. Flag_Daily_Max_Conductivity column 27. Daily_Mean_Conductivity column 28. Flag_Daily_Mean_Conductivity column 29. Daily_StdDev_Conductivity column 30. Flag_Daily_StdDev_Conductivity column 31. Daily_SE_Conductivity column 32. Flag_Daily_SE_Conductivity column 33. Missing_Pressure column 34. Percent_Missing_Pressure column 35. Flagged_Pressure column 36. Percent_Flagged_Pressure column 37. Daily_Num_Pressure column 38. Daily_Min_Pressure column 39. Daily_Max_Pressure column 40. Daily_Mean_Pressure column 41. Daily_StdDev_Pressure column 42. Daily_SE_Pressure column 43. Missing_Depth column 44. Percent_Missing_Depth column 45. Flagged_Depth column 46. Percent_Flagged_Depth column 47. Daily_Num_Depth column 48. Daily_Min_Depth column 49. Daily_Max_Depth column 50. Daily_Mean_Depth column 51. Daily_StdDev_Depth column 52. Daily_SE_Depth column 53. Missing_Salinity column 54. Percent_Missing_Salinity column 55. Flagged_Salinity column 56. Percent_Flagged_Salinity column 57. Daily_Num_Salinity column 58. Daily_Min_Salinity column 59. Flag_Daily_Min_Salinity column 60. Daily_Max_Salinity column 61. Flag_Daily_Max_Salinity column 62. Daily_Mean_Salinity column 63. Flag_Daily_Mean_Salinity column 64. Daily_StdDev_Salinity column 65. Flag_Daily_StdDev_Salinity column 66. Daily_SE_Salinity column 67. Flag_Daily_SE_Salinity column 68. Missing_Sigma_t column 69. Percent_Missing_Sigma_t column 70. Flagged_Sigma_t column 71. Percent_Flagged_Sigma_t column 72. Daily_Num_Sigma_t column 73. Daily_Min_Sigma_t column 74. Flag_Daily_Min_Sigma_t column 75. Daily_Max_Sigma_t column 76. Flag_Daily_Max_Sigma_t column 77. Daily_Mean_Sigma_t column 78. Flag_Daily_Mean_Sigma_t column 79. Daily_StdDev_Sigma_t column 80. Flag_Daily_StdDev_Sigma_t column 81. Daily_SE_Sigma_t column 82. Flag_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. 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 25. Daily Maximum Conductivity column 26. 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 27. Daily Mean Conductivity column 28. 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 29. Daily Sample Standard Deviation of Conductivity column 30. 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 31. Daily Standard Error of Conductivity column 32. 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 33. Number of missing observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 34. Percent missing observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 35. Number of QC/QA-flagged observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 36. Percent QC/QA-flagged observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 37. Daily Observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 38. Daily Minimum Water pressure at sensor (approximately equivalent to water depth within 3% error) column 39. Daily Maximum Water pressure at sensor (approximately equivalent to water depth within 3% error) column 40. Daily Mean Water pressure at sensor (approximately equivalent to water depth within 3% error) column 41. Daily Sample Standard Deviation of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 42. Daily Standard Error of Water pressure at sensor (approximately equivalent to water depth within 3% error) column 43. Number of missing observations of Water depth to the pressure sensor of the moored sonde column 44. Percent missing observations of Water depth to the pressure sensor of the moored sonde column 45. Number of QC/QA-flagged observations of Water depth to the pressure sensor of the moored sonde column 46. Percent QC/QA-flagged observations of Water depth to the pressure sensor of the moored sonde column 47. Daily Observations of Water depth to the pressure sensor of the moored sonde column 48. Daily Minimum Water depth to the pressure sensor of the moored sonde column 49. Daily Maximum Water depth to the pressure sensor of the moored sonde column 50. Daily Mean Water depth to the pressure sensor of the moored sonde column 51. Daily Sample Standard Deviation of Water depth to the pressure sensor of the moored sonde column 52. Daily Standard Error of Water depth to the pressure sensor of the moored sonde column 53. Number of missing observations of Salinity column 54. Percent missing observations of Salinity column 55. Number of QC/QA-flagged observations of Salinity column 56. Percent QC/QA-flagged observations of Salinity column 57. Daily Observations of Salinity column 58. Daily Minimum Salinity column 59. 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 60. Daily Maximum Salinity column 61. 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 62. Daily Mean Salinity column 63. 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 64. Daily Sample Standard Deviation of Salinity column 65. 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 66. Daily Standard Error of Salinity column 67. 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 68. Number of missing observations of Sigma-t (i.e. Density-1) column 69. Percent missing observations of Sigma-t (i.e. Density-1) column 70. Number of QC/QA-flagged observations of Sigma-t (i.e. Density-1) column 71. Percent QC/QA-flagged observations of Sigma-t (i.e. Density-1) column 72. Daily Observations of Sigma-t (i.e. Density-1) column 73. Daily Minimum Sigma-t (i.e. Density-1) column 74. 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 75. Daily Maximum Sigma-t (i.e. Density-1) column 76. 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 77. Daily Mean Sigma-t (i.e. Density-1) column 78. 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 79. Daily Sample Standard Deviation of Sigma-t (i.e. Density-1) column 80. 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 81. Daily Standard Error of Sigma-t (i.e. Density-1) column 82. 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. 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. none column 25. S/m column 26. none column 27. S/m column 28. none column 29. S/m column 30. none column 31. S/m column 32. none column 33. count column 34. % column 35. count column 36. % column 37. count column 38. dbar column 39. dbar column 40. dbar column 41. dbar column 42. dbar column 43. count column 44. % column 45. count column 46. % column 47. count column 48. m column 49. m column 50. m column 51. m column 52. m column 53. count column 54. % column 55. count column 56. % column 57. count column 58. PSU column 59. none column 60. PSU column 61. none column 62. PSU column 63. none column 64. PSU column 65. none column 66. PSU column 67. none column 68. count column 69. % column 70. count column 71. % column 72. count column 73. kg/m^3 column 74. none column 75. kg/m^3 column 76. none column 77. kg/m^3 column 78. none column 79. kg/m^3 column 80. none column 81. kg/m^3 column 82. none 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. string column 25. floating-point column 26. string column 27. floating-point column 28. string column 29. floating-point column 30. string column 31. floating-point column 32. string column 33. integer column 34. floating-point column 35. integer column 36. floating-point column 37. integer column 38. floating-point column 39. floating-point column 40. floating-point column 41. floating-point column 42. floating-point column 43. integer column 44. floating-point column 45. integer column 46. floating-point column 47. integer column 48. floating-point column 49. floating-point column 50. floating-point column 51. floating-point column 52. floating-point column 53. integer column 54. floating-point column 55. integer column 56. floating-point column 57. integer column 58. floating-point column 59. string column 60. floating-point column 61. string column 62. floating-point column 63. string column 64. floating-point column 65. string column 66. floating-point column 67. string column 68. integer column 69. floating-point column 70. integer column 71. floating-point column 72. integer column 73. floating-point column 74. string column 75. floating-point column 76. string column 77. floating-point column 78. string column 79. floating-point column 80. string column 81. floating-point column 82. 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. 8 to 8 column 2. -81.4094 to -81.4094 column 3. 31.3106 to 31.3106 column 4. (none) column 5. 2002 to 2002 column 6. 1 to 12 column 7. 1 to 31 column 8. 0 to 0 column 9. 0 to 0 column 10. 0 to 4 column 11. 0 to 7.6923 column 12. 48 to 48 column 13. 7.4715 to 31.2135 column 14. 8.2592 to 32.5384 column 15. 7.9179 to 31.7977 column 16. 0.098869 to 0.86271 column 17. 0.014271 to 0.12452 column 18. 0 to 48 column 19. 0 to 100 column 20. 0 to 48 column 21. 0 to 50 column 22. 0 to 48 column 23. 0.00972 to 1.8648 column 24. (none) column 25. 0.02214 to 4.9515 column 26. (none) column 27. 0.013609 to 3.4767 column 28. (none) column 29. 0.0030012 to 1.1001 column 30. (none) column 31. 0.00043319 to 0.15878 column 32. (none) column 33. 0 to 0 column 34. 0 to 0 column 35. 0 to 4 column 36. 0 to 7.6923 column 37. 48 to 48 column 38. 0.129 to 2.246 column 39. 2.506 to 3.8 column 40. 1.5991 to 2.7609 column 41. 0.16507 to 0.91625 column 42. 0.023826 to 0.13225 column 43. 0 to 0 column 44. 0 to 0 column 45. 0 to 4 column 46. 0 to 7.6923 column 47. 48 to 48 column 48. 0.12811 to 2.2305 column 49. 2.4887 to 3.7737 column 50. 1.588 to 2.7418 column 51. 0.16393 to 0.90991 column 52. 0.023661 to 0.13133 column 53. 0 to 48 column 54. 0 to 100 column 55. 0 to 48 column 56. 0 to 50 column 57. 0 to 48 column 58. 0.060901 to 9.9111 column 59. (none) column 60. 0.13985 to 29.6144 column 61. (none) column 62. 0.084645 to 20.6338 column 63. (none) column 64. 0.018926 to 6.9345 column 65. (none) column 66. 0.0027317 to 1.0009 column 67. (none) column 68. 0 to 48 column 69. 0 to 100 column 70. 0 to 48 column 71. 0 to 50 column 72. 0 to 48 column 73. -3.8602 to 3.0115 column 74. (none) column 75. -2.8326 to 17.9745 column 76. (none) column 77. -3.2119 to 11.7616 column 78. (none) column 79. 0.028201 to 5.3223 column 80. (none) column 81. 0.0040705 to 0.76821 column 82. (none) 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. text column 25. numerical column 26. text column 27. numerical column 28. text column 29. numerical column 30. text column 31. numerical column 32. text 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. text column 60. numerical column 61. text column 62. numerical column 63. text column 64. numerical column 65. text column 66. numerical column 67. text column 68. numerical column 69. numerical column 70. numerical column 71. numerical column 72. numerical column 73. numerical column 74. text column 75. numerical column 76. text column 77. numerical column 78. text column 79. numerical column 80. text column 81. numerical column 82. text b. Number of Columns: 82 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. 0 column 25. 3 column 26. 0 column 27. 4 column 28. 0 column 29. 4 column 30. 0 column 31. 5 column 32. 0 column 33. 0 column 34. 2 column 35. 0 column 36. 2 column 37. 0 column 38. 3 column 39. 3 column 40. 4 column 41. 4 column 42. 5 column 43. 0 column 44. 2 column 45. 0 column 46. 2 column 47. 0 column 48. 3 column 49. 3 column 50. 4 column 51. 4 column 52. 5 column 53. 0 column 54. 2 column 55. 0 column 56. 2 column 57. 0 column 58. 3 column 59. 0 column 60. 3 column 61. 0 column 62. 4 column 63. 0 column 64. 4 column 65. 0 column 66. 5 column 67. 0 column 68. 0 column 69. 2 column 70. 0 column 71. 2 column 72. 0 column 73. 3 column 74. 0 column 75. 3 column 76. 0 column 77. 4 column 78. 0 column 79. 4 column 80. 0 column 81. 5 column 82. 0 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. coded value (none) column 25. calculation (continuous) column 26. coded value (none) column 27. calculation (continuous) column 28. coded value (none) column 29. calculation (continuous) column 30. coded value (none) column 31. calculation (continuous) column 32. coded value (none) column 33. calculation (discrete) column 34. calculation (continuous) column 35. calculation (discrete) column 36. calculation (continuous) column 37. calculation (discrete) column 38. calculation (continuous) column 39. calculation (continuous) column 40. calculation (continuous) column 41. calculation (continuous) column 42. calculation (continuous) column 43. calculation (discrete) column 44. calculation (continuous) column 45. calculation (discrete) column 46. calculation (continuous) column 47. calculation (discrete) column 48. calculation (continuous) column 49. calculation (continuous) column 50. calculation (continuous) column 51. calculation (continuous) column 52. calculation (continuous) column 53. calculation (discrete) column 54. calculation (continuous) column 55. calculation (discrete) column 56. calculation (continuous) column 57. calculation (discrete) column 58. calculation (continuous) column 59. coded value (none) column 60. calculation (continuous) column 61. coded value (none) column 62. calculation (continuous) column 63. coded value (none) column 64. calculation (continuous) column 65. coded value (none) column 66. calculation (continuous) column 67. coded value (none) column 68. calculation (discrete) column 69. calculation (continuous) column 70. calculation (discrete) column 71. calculation (continuous) column 72. calculation (discrete) column 73. calculation (continuous) column 74. coded value (none) column 75. calculation (continuous) column 76. coded value (none) column 77. calculation (continuous) column 78. coded value (none) column 79. calculation (continuous) column 80. coded value (none) column 81. calculation (continuous) column 82. 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. 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. none column 25. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 26. none 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. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 30. none column 31. col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc ent_Flagged_Conductivity>35="Q" column 32. none column 33. none column 34. none column 35. none column 36. none column 37. none column 38. col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag ged_Pressure>35="Q" 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. none column 44. none column 45. none column 46. none column 47. none column 48. col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De pth>35="Q" 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. none column 54. none column 55. none column 56. none column 57. none column 58. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 59. none column 60. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 61. none column 62. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 63. none column 64. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 65. none column 66. col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag ged_Salinity>35="Q" column 67. none column 68. none column 69. none column 70. none column 71. none column 72. none column 73. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 74. none column 75. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 76. none column 77. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 78. none column 79. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 80. none column 81. col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge d_Sigma_t>35="Q" column 82. none C. Data Anomalies: Values of 16 records in Daily_Min_Conductivity were flagged as I (invalid value (out of range)). Values of 14 records in Daily_Min_Conductivity were flagged as Q (questionable value). Values of 13 records in Daily_Min_Conductivity are missing. Values of 16 records in Daily_Max_Conductivity were flagged as I (invalid value (out of range)). Values of 14 records in Daily_Max_Conductivity were flagged as Q (questionable value). Values of 13 records in Daily_Max_Conductivity are missing. Values of 16 records in Daily_Mean_Conductivity were flagged as I (invalid value (out of range)). Values of 14 records in Daily_Mean_Conductivity were flagged as Q (questionable value). Values of 13 records in Daily_Mean_Conductivity are missing. Values of 16 records in Daily_StdDev_Conductivity were flagged as I (invalid value (out of range)). Values of 14 records in Daily_StdDev_Conductivity were flagged as Q (questionable value). Values of 13 records in Daily_StdDev_Conductivity are missing. Values of 16 records in Daily_SE_Conductivity were flagged as I (invalid value (out of range)). Values of 14 records in Daily_SE_Conductivity were flagged as Q (questionable value). Values of 13 records in Daily_SE_Conductivity are missing. Values of 16 records in Daily_Min_Salinity were flagged as I (invalid value (out of range)). Values of 14 records in Daily_Min_Salinity were flagged as Q (questionable value). Values of 13 records in Daily_Min_Salinity are missing. Values of 16 records in Daily_Max_Salinity were flagged as I (invalid value (out of range)). Values of 14 records in Daily_Max_Salinity were flagged as Q (questionable value). Values of 13 records in Daily_Max_Salinity are missing. Values of 16 records in Daily_Mean_Salinity were flagged as I (invalid value (out of range)). Values of 14 records in Daily_Mean_Salinity were flagged as Q (questionable value). Values of 13 records in Daily_Mean_Salinity are missing. Values of 16 records in Daily_StdDev_Salinity were flagged as I (invalid value (out of range)). Values of 14 records in Daily_StdDev_Salinity were flagged as Q (questionable value). Values of 13 records in Daily_StdDev_Salinity are missing. Values of 16 records in Daily_SE_Salinity were flagged as I (invalid value (out of range)). Values of 14 records in Daily_SE_Salinity were flagged as Q (questionable value). Values of 13 records in Daily_SE_Salinity are missing. Values of 16 records in Daily_Min_Sigma_t were flagged as I (invalid value (out of range)). Values of 14 records in Daily_Min_Sigma_t were flagged as Q (questionable value). Values of 13 records in Daily_Min_Sigma_t are missing. Values of 16 records in Daily_Max_Sigma_t were flagged as I (invalid value (out of range)). Values of 14 records in Daily_Max_Sigma_t were flagged as Q (questionable value). Values of 13 records in Daily_Max_Sigma_t are missing. Values of 16 records in Daily_Mean_Sigma_t were flagged as I (invalid value (out of range)). Values of 14 records in Daily_Mean_Sigma_t were flagged as Q (questionable value). Values of 13 records in Daily_Mean_Sigma_t are missing. Values of 16 records in Daily_StdDev_Sigma_t were flagged as I (invalid value (out of range)). Values of 14 records in Daily_StdDev_Sigma_t were flagged as Q (questionable value). Values of 13 records in Daily_StdDev_Sigma_t are missing. Values of 16 records in Daily_SE_Sigma_t were flagged as I (invalid value (out of range)). Values of 14 records in Daily_SE_Sigma_t were flagged as Q (questionable value). Values of 13 records in Daily_SE_Sigma_t are missing. 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: Data format is validated during download by Sea-Bird Electronics Sea-Soft version 4.246, and also by custom data import programs in the GCE Data Toolbox for Matlab. 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: unspecified G. History of Data Set Usage 1. Data Request History: unspecified 2. Data Set Update History: not updated 3. Review History: Instrument deployment, maintenance and retrieval observations: site #8 serial#1996 S/N 1996 SITE 8 Set up by K. Helm Time on 1/07/02 1530GMT Time into water 1/07/02 1532GMT Time out of water 3/12/02 1439GMT Time off 3/12/02 1539:15 GMT Sample Interval 1800sec. Deployment Information Date 1/7/02 Time 1532GMT YSI sal 2.4 Ysi temp 8.5 Water depth 16.6' Sensor height above bottom 151" Retrieval Information Date 03/12/02 Time 1439 GMT YSI sal 2.3 Ysi temp 16.6 Water depth 23.4' Instrument condition Sensor tube very clean Upload file name 8020396 NOTE I have two sondes who's serial#s end with 96. Because of limited characters available to name a file, I have elected to always drop the 1st. zero (ie 8 instead of 08) of file name. This will id sonde 1996 vs.1796! Maintenance Record Date 1/22/02 Time 1516GMT Ysi sal 0.8 Ysi temp 13.5 Water depth 18.7' Sensor tube clean except for a shell fragment. I could see thru it. Date 1/29/02 Time 1735GMT Ysi sal 9.0 Ysi temp 16.5 Water depth 20.7' Sensor tube very clean Date 2/13/02 Time 1330GMT Ysi sal 3.7 Ysi temp 13.9 Water depth 24.4' Sensor tube very clean Date 2/26/02 Time 1415GMT Ysi sal 5.8 Ysi temp 14.3 Water depth 24.7' Sensor tube very clean Instrument deployment, maintenance and retrieval observations: site #08 serial#1794 S/N 1794 SITE 8 Set up by K. Helm Time on 3/12/02 1500GMT Time into water 3/12/02 1442GMT Time out of water 5/13/02 1449GMT Time off 5/13/02 1547 GMT Sample Interval 1800sec. Deployment Information Date 3/12/02 Time 1442GMT YSI sal 2.3 Ysi temp 16.6 Water depth 23.4' Sensor height above bottom 15.1' Retrieval Information Date 05/13/02 Time 1449 GMT YSI sal 7.8 Ysi temp 28.1 Water depth 22.3' Instrument condition Sensor tube -very clean Upload file name 08020594 Maintenance Record Date 3/23/02 Time 1526GMT Ysi sal 0.2 Ysi temp 19.7 Water depth 18.8' Sensor tube -clogged with crabs-hosed clean Date 4/3/02 Time 1525GMT Ysi sal 0.2 Ysi temp 22.3 Water depth 21.3' sensor tube -very clean Date 4/17/02 Time 1438GMT Ysi sal 0.6 Ysi temp 23.5 Water depth 22.4' Sensor tube - very clean Date 4/29/02 Time 1733GMT Ysi sal 2.9 Ysi temp 25.2 Water depth 21.7' Sensor tube - very clean Instrument deployment, maintenance and retrieval observations: site #8 serial#1795 S/N 1995 SITE 8 Set up by K. Helm Time on 5/13/02 1500GMT Time into water 5/13/02 1450GMT Time out of water 7/22/02 1435GMT Time off 7/22/02 1754 GMT Sample Interval 1800sec. Deployment Information Date 5/13/02 Time 1450GMT YSI sal 7.8 Ysi temp 28.1 Water depth 22.3' Sensor height above bottom 15.1' Retrieval Information Date 7/22/02 Time 1435GMT YSI sal 15.4 Ysi temp 30.1 Water depth 24.0' Instrument condition Sensor tube - clogged hosed clean Upload file name 08020795 Maintenance Record Date 5/28/02 Time 1333GMT Ysi sal 10.0 Ysi temp 25.1 Water depth 23.,0' Sensor tube -very clean-pvc pipe reamed Date 6/11/02 Time 1439GMT Ysi sal 12.0 Ysi temp 27.6 Water depth 22.7' sensor tube -very clean Date 6/25/02 Time 1447GMT Ysi sal 8.2Ysi temp 27.1 Water depth 22.7' Sensor tube - very clean Date 7/11/02 Time 1443GMT Ysi sal 11.8 Ysi temp 30.3 Water depth 22.2' Sensor tube - sensor tube clean Instrument deployment, maintenance and retrieval observations: site #08 serial#1667 S/N 1667 SITE 8 Set up by K. Helm Time on 7/22/02 1700GMT Time into water 7/22/02 1439GMT Time out of water 10/01/02 1536GMT Time off 10/01/02 1704 GMT Sample Interval 1800sec. Deployment Information Date 7/22/02 Time 1439GMT YSI sal 15.4 Ysi temp 30.1 Water depth 24'-0" Sensor height above bottom 15'-1"" Retrieval Information Date 10/01/02 Time 1536GMT YSI sal 0.4 Ysi temp 28.3 Water depth 21'-10"" Instrument condition Sensor tube - very clean Upload file name 08021067 Maintenance Record Date 8/05/02 Time 1443 GMT Ysi sal 11.7 Ysi temp 29.7 Water depth 18'-8" Sensor tube - very clean Date 8/20/02 Time 1206 GMT Ysi sal 16.2 Ysi temp 29.6 Water depth 26' sensor tube - clean Date 9/03/02 Time 1407 GMT Ysi sal 12.1 Ysi temp 27.8 Water depth 19'-6" Sensor tube - clogged-hosed clean Date 9/18/02 Time 1503GMT Ysi sal 8.3 Ysi temp 28.7 Water depth 21'-8" Sensor tube - sensor tube- clogged hosed clean Instrument deployment, maintenance and retrieval observations: site #08 serial#1793 S/N 1793 SITE 8 Set up by K. Helm Time on 10/01/02 1700GMT Time into water 10/01/02 1538GMT Time out of water 01/06/03 1603GMT Time off 01/06/03 1833 GMT Sample Interval 1800sec. Deployment Information Date 10/01/02 Time 1538GMT YSI sal 0.4 Ysi temp 28.3 Water depth 21'-10" Sensor height above bottom 15'-1" Retrieval Information Date 01/06/03 Time 1603GMT YSI sal 0.1 Ysi temp 9.7 Water depth 26'-2" Instrument condition Sensor tube - clogged hosed clean Upload file name 08030693 Maintenance Record Date 10/23/02 Time 1153 GMT Ysi sal 6.0 Ysi temp 22.4 Water depth 26'-0" Sensor tube - clogged hosed clean Date 11/7/02 Time 1253 GMT Ysi sal 3.5 Ysi temp 18.9 Water depth 26'-6" sensor tube - clogged-hosed clean Date 11/21/02 Time 1538 GMT Ysi sal 3.2 Ysi temp 15.5 Water depth 26'-6" Sensor tube - clogged hosed clean Date 12/03/02 Time 1625GMT Ysi sal 0.3 Ysi temp 11.3 Water depth 23'-2" Sensor tube - sensor tube- very clean Date 12/16/02 Time 1502 Ysi Sal 1.9 Ysi Temp 10.2 Depth 21'-9" Cond sensor tube very clean 4. Questions and Comments from Users: none