I. Data Set Descriptors A. Title: Jackson O. Blanton. 2004. Continuous salinity, temperature and depth measurements from moored hydrographic data loggers deployed at GCE6_Hydro (Doboy Sound south of Sapelo Island, Georgia) from 01-Jan-2003 through 31-Dec-2003. Georgia Coastal Ecosystems LTER Data Catalog (data set PHY-GCEM-0403d; http://gce-lter.marsci.uga.edu/public/app/dataset_details.asp?accession=PHY-GCEM-0403d) B. Accession Number: PHY-GCEM-0403d 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 GCE6_Hydro (Doboy Sound south of Sapelo Island, Georgia) from 01-Jan-2003 through 31-Dec-2003. 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: Mar 02, 2004 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-DB -- Doboy Sound, Georgia, USA GCE6_Hydro -- Doboy Sound hydrographic datalogger deployment south of Sapelo Island Coordinates: GCE-DB -- NW: 81 22 05.7 W, 31 27 20.4 N NE: 81 14 34.6 W, 31 27 20.4 N SE: 81 14 34.6 W, 31 20 27.4 N SW: 81 22 05.7 W, 31 20 27.4 N GCE6_Hydro -- 81 18 17.9 W, 31 23 36.5 N b. Physiographic Region: GCE-DB -- Estuary and tidal marsh GCE6_Hydro -- Estuary and tidal marsh c. Landform Components: GCE-DB -- Intertidal marsh bordering sounds, tidal channels and creeks GCE6_Hydro -- Intertidal marsh bordering sounds, tidal channels and creeks d. Hydrographic Characteristics: GCE-DB -- Site encompasses Doboy Sound and nearby tidal channels and creeks, and is subject to 2-3.4m semi-diurnal tides. GCE6_Hydro -- Site encompasses Doboy Sound and nearby tidal channels and creeks, and is subject to 2-3.4m semi-diurnal tides. e. Topographic Attributes: GCE-DB -- Flat, with elevations ranging from 0-3.4m above mean low tide GCE6_Hydro -- Flat, with elevations ranging from 0-3.4m above mean low tide f. Geology, Lithology and Soils: GCE-DB -- unspecified GCE6_Hydro -- unspecified g. Vegetation Communities: GCE-DB -- unspecified GCE6_Hydro -- unspecified h. History of Land Use and Disturbance: none recorded i. Climate: Climate summary for Sapelo Island, Georgia, based on NWS data from 1980-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-2003 End of Observations: 31-Dec-2003 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. b. Instrumentation: Method 1: SBE MicroCAT 37-SM (S/N 1667) Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT) Last calibration: Aug 07, 2001 Parameter: Conductivity (Accuracy: 0.0003 S/m, Readability: 0.00001 S/m, Range: 0 to 7 S/m) Protocol: Water passively circulates through an open internal-field conductivity cell equipped with an external tributyl tin antifoulant dispenser, and conductivity is measured using an ultra-precision Wien-Bridge oscillator with frequency counted by a high-stability reference crystal (<2 ppm/year drift rate). Parameter: Pressure (water) (Accuracy: 0.2m, Readability: 0.0004m, Range: 0 to 20m) Protocol: Pressure is measured using a micro-machined silicon diaphragm with embedded strain elements, and temperature compensation is performed by the SBE MicroCAT onboard cpu. Parameter: Temperature (water) (Accuracy: 0.002°C, Readability: 0.0001°C, Range: -5 to 35°C) Protocol: Temperature is measured by applying an AC excitation to a hermetically-sealed VISHAY reference resistor and an ultra-stable aged thermistor (drift rate typically less than 0.002°C/year). SBE MicroCAT 37-SM (S/N 1791) Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT) Last calibration: Feb 20, 2001 Parameter: Conductivity (Accuracy: 0.0003 S/m, Readability: 0.00001 S/m, Range: 0 to 7 S/m) Protocol: Water passively circulates through an open internal-field conductivity cell equipped with an external tributyl tin antifoulant dispenser, and conductivity is measured using an ultra-precision Wien-Bridge oscillator with frequency counted by a high-stability reference crystal (<2 ppm/year drift rate). Parameter: Pressure (water) (Accuracy: 0.2m, Readability: 0.0004m, Range: 0 to 20m) Protocol: Pressure is measured using a micro-machined silicon diaphragm with embedded strain elements, and temperature compensation is performed by the SBE MicroCAT onboard cpu. Parameter: Temperature (water) (Accuracy: 0.002°C, Readability: 0.0001°C, Range: -5 to 35°C) Protocol: Temperature is measured by applying an AC excitation to a hermetically-sealed VISHAY reference resistor and an ultra-stable aged thermistor (drift rate typically less than 0.002°C/year). SBE MicroCAT 37-SM (S/N 1794) Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT) Last calibration: Feb 20, 2001 Parameter: Conductivity (Accuracy: 0.0003 S/m, Readability: 0.00001 S/m, Range: 0 to 7 S/m) Protocol: Water passively circulates through an open internal-field conductivity cell equipped with an external tributyl tin antifoulant dispenser, and conductivity is measured using an ultra-precision Wien-Bridge oscillator with frequency counted by a high-stability reference crystal (<2 ppm/year drift rate). Parameter: Pressure (water) (Accuracy: 0.2m, Readability: 0.0004m, Range: 0 to 20m) Protocol: Pressure is measured using a micro-machined silicon diaphragm with embedded strain elements, and temperature compensation is performed by the SBE MicroCAT onboard cpu. Parameter: Temperature (water) (Accuracy: 0.002°C, Readability: 0.0001°C, Range: -5 to 35°C) Protocol: Temperature is measured by applying an AC excitation to a hermetically-sealed VISHAY reference resistor and an ultra-stable aged thermistor (drift rate typically less than 0.002°C/year). SBE MicroCAT 37-SM (S/N 1795) Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT) Last calibration: Feb 20, 2001 Parameter: Conductivity (Accuracy: 0.0003 S/m, Readability: 0.00001 S/m, Range: 0 to 7 S/m) Protocol: Water passively circulates through an open internal-field conductivity cell equipped with an external tributyl tin antifoulant dispenser, and conductivity is measured using an ultra-precision Wien-Bridge oscillator with frequency counted by a high-stability reference crystal (<2 ppm/year drift rate). Parameter: Pressure (water) (Accuracy: 0.2m, Readability: 0.0004m, Range: 0 to 20m) Protocol: Pressure is measured using a micro-machined silicon diaphragm with embedded strain elements, and temperature compensation is performed by the SBE MicroCAT onboard cpu. Parameter: Temperature (water) (Accuracy: 0.002°C, Readability: 0.0001°C, Range: -5 to 35°C) Protocol: Temperature is measured by applying an AC excitation to a hermetically-sealed VISHAY reference resistor and an ultra-stable aged thermistor (drift rate typically less than 0.002°C/year). Method 2: none Method 3: none c. Taxonomy and Systematics: Method 1: not applicable Method 2: not applicable Method 3: not applicable d. Speclies List: e. Permit History: Method 1: Permission obtained to install instruments on wooden pilings in Doboy Sound near Commodore Island Method 2: none Method 3: none 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: 31-Mar-2004 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-0403d_5_0.CSV 2. Size: 17520 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: 06020597.asc (3503 records) 06020796.asc (3596 records) 06021097.asc (3358 records) 06030194.asc (4658 records) 06030467.asc (4745 records) 06030791.asc (4659 records) 06031167.asc (5414 records) 06040295.asc (4409 records) Data processing history: 09-May-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 '06020597.asc' (3503 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: 3596 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: 3358 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: 4658 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) 1, deleted record(s) 15109, 15110, 15111, 15112, 15113 and 15114 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 2519 records in Conductivity; flags cleared on Conductivity record(s): 7720, 9730, 12864, 12865 and 13477 22-Apr-2003: Q/C flagging criteria of columns Temperature, Pressure, Depth, TotalDepth, 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): 2398, 3012, 4415, 5081, 5753, 8434, 8440, 11465 and 12863 ('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) 30-Jul-2003: query 'Year=2003' run, returned 270 of 15099 data rows ('querydata') 30-Jul-2003: automatically assigned study date metadata descriptors based on the range of date values in column Date (add_studydates) 30-Jul-2003: manually edited data set metadata ('ui_editmetadata') 30-Jul-2003: edited data set title in structure and metadata ('ui_editor') 30-Jul-2003: units of column Date edited ('ui_editor') 30-Jul-2003: 4740 rows added at the bottom of the data set ('datamerge') 30-Jul-2003: updated 18 metadata fields in the Data, Dataset, Site, Status, Study, Supplement sections ('addmeta') 30-Jul-2003: 4653 rows added at the bottom of the data set ('datamerge') 30-Jul-2003: updated 19 metadata fields in the Data, Dataset, Site, Status, Study, Supplement sections ('addmeta') 30-Jul-2003: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 30-Jul-2003: manually edited data set metadata ('ui_editmetadata') 30-Jul-2003: edited data set title in structure and metadata ('ui_editor') 30-Jul-2003: manually edited data set metadata ('ui_editmetadata') 14-Nov-2003: 5409 rows added at the bottom of the data set ('datamerge') 14-Nov-2003: updated 16 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 14-Nov-2003: manually edited data set metadata ('ui_editmetadata') 14-Nov-2003: edited data set title in structure and metadata ('ui_editor') 18-Feb-2004: 4405 rows added at the bottom of the data set ('datamerge') 18-Feb-2004: updated 15 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 18-Feb-2004: manually edited data set metadata ('ui_editmetadata') 18-Feb-2004: edited data set title in structure and metadata ('ui_editor') 18-Feb-2004: query 'Year=2003' run, returned 17478 of 19477 data rows ('querydata') 18-Feb-2004: automatically assigned study date metadata descriptors based on the range of date values in column Date (add_studydates) 18-Feb-2004: manually edited data set metadata ('ui_editmetadata') 02-Mar-2004: Q/C flagging criteria of columns Temperature, Depth, Salinity and Sigma_t edited ('ui_editor') 02-Mar-2004: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 02-Mar-2004: QA/QC flags assigned by visual inspection (ui_visualqc); flags set on 684 records in Conductivity; flags cleared on Conductivity record(s): 945 02-Mar-2004: 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) 31-Mar-2004: imported dataset, project, site, study, status metadata descriptors from the GCE Metabase ('imp_gcemetadata') 31-Mar-2004: updated 52 metadata fields in the Dataset, Project, Site, Status, Study sections ('imp_gcemetadata') 31-Mar-2004: documented flagged and missing values as data set anomalies in the metadata ('add_anomalies') 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 42 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 = 2003' run, returned 17520 of 17520 data rows ('querydata') 26-Sep-2008: automatically assigned study date metadata descriptors based on the range of date values in date/time columns (add_studydates) 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') 16-Jun-2009: 17 values in 'Longitude' were updated with new values ('update_data'): changed record 15098 from NaN to -81.304833, changed record 15099 from NaN to -81.304833, changed record 15100 from NaN to -81.304833, changed record 15101 from NaN to -81.304833, changed record 15102 from NaN to -81.304833, changed record 15103 from NaN to -81.304833, changed record 15104 from NaN to -81.304833, changed record 15105 from NaN to -81.304833, changed record 15106 from NaN to -81.304833, changed record 15107 from NaN to -81.304833, changed record 15108 from NaN to -81.304833, changed record 15109 from NaN to -81.304833, changed record 15110 from NaN to -81.304833, changed record 15111 from NaN to -81.304833, changed record 15112 from NaN to -81.304833, changed record 15113 from NaN to -81.304833, changed record 15114 from NaN to -81.304833 16-Jun-2009: Q/C flagging criteria applied for column(s) Longitude, 'flags' field updated ('dataflag') 16-Jun-2009: 17 values in 'Latitude' were updated with new values ('update_data'): changed record 15098 from NaN to 31.393500, changed record 15099 from NaN to 31.393500, changed record 15100 from NaN to 31.393500, changed record 15101 from NaN to 31.393500, changed record 15102 from NaN to 31.393500, changed record 15103 from NaN to 31.393500, changed record 15104 from NaN to 31.393500, changed record 15105 from NaN to 31.393500, changed record 15106 from NaN to 31.393500, changed record 15107 from NaN to 31.393500, changed record 15108 from NaN to 31.393500, changed record 15109 from NaN to 31.393500, changed record 15110 from NaN to 31.393500, changed record 15111 from NaN to 31.393500, changed record 15112 from NaN to 31.393500, changed record 15113 from NaN to 31.393500, changed record 15114 from NaN to 31.393500 16-Jun-2009: Q/C flagging criteria applied for column(s) Latitude, 'flags' field updated ('dataflag') 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=2003' run, returned 17520 of 17520 data rows ('querydata') 03-Jun-2015: deleted the following rows with values in any column assigned QA/QC flag(s) X (excise row flag): 10353 and 13802. ('cullflags') 03-Jun-2015: inserted 2 new records with date/time values and NaN/null data values (replicating common values in the non-data columns Site, Station, Longitude, Latitude, Instrument, Pump and Calibration) to fill in date/time interval gaps in the data series ('pad_date_gaps') 03-Jun-2015: sorted by column Date(ascending) ('sortdata') 03-Jun-2015: 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') 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: 954 records in Conductivity, 954 records in Salinity, 954 records in Sigma_t ('nullflags') 03-Jun-2015: converted dates in column(s) Date to format yyyy-mm-dd HH:MM:SS 03-Jun-2015: flags for columns Temperature, Conductivity, Pressure, Depth, Salinity and 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. Station column 3. Longitude column 4. Latitude column 5. Instrument column 6. Date column 7. Year column 8. Month column 9. Day column 10. Hour column 11. Minute column 12. Temperature column 13. Flag_Temperature column 14. Conductivity column 15. Flag_Conductivity column 16. Pressure column 17. Flag_Pressure column 18. Depth column 19. Flag_Depth column 20. Salinity column 21. Flag_Salinity column 22. Sigma_t column 23. Flag_Sigma_t 2. Variable Definition: column 1. Nearest nominal GCE-LTER sampling site column 2. Station determined by geographic lookup of coordinates in reference file 'geo_locations.mat' using a distance tolerance of 0.5km column 3. Geographic longitude in decimal degrees column 4. Geographic latitude in decimal degrees column 5. Serial number of the SBE 37-SM MicroCAT instrument used for the observations column 6. Calendar date and time of observation column 7. Calendar year column 8. Calendar month column 9. Calendar day column 10. Hours - GMT column 11. Minutes column 12. Water temperature column 13. QA/QC flags for Water temperature (flagging criteria, where "x" is Temperature: x<0="Q", x>35="Q", Depth<0.1="Q", flag_valuechange(x,5,5,3)="S", manual) column 14. Conductivity column 15. QA/QC flags for Conductivity (flagging criteria, where "x" is Conductivity: manual) column 16. Water pressure at sensor (approximately equivalent to water depth within 3% error) column 17. QA/QC flags for Water pressure at sensor (approximately equivalent to water depth within 3% error) (flagging criteria, where "x" is Pressure: x<0.2="Q", x>10="Q", manual) column 18. Water depth to the pressure sensor of the moored sonde column 19. QA/QC flags for Water depth to the pressure sensor of the moored sonde (flagging criteria, where "x" is Depth: x<0.1="Q", x>10="Q", manual) column 20. Salinity column 21. QA/QC flags for Salinity (flagging criteria, where "x" is Salinity: x<0="I", x>36="Q", Depth<0.1="Q", flag_valuechange(x,10,0,3)="S", manual) column 22. Sigma-t (i.e. Density-1) column 23. QA/QC flags for Sigma-t (i.e. Density-1) (flagging criteria, where "x" is Sigma_t: x<-5="Q", Depth<0.1="Q", x>28="Q", manual) 3. Units of Measurement: column 1. none column 2. none column 3. degrees column 4. degrees column 5. none column 6. yyyy-mm-dd HH:MM:SS - GMT column 7. YYYY column 8. MM column 9. DD column 10. hr column 11. min column 12. °C column 13. none column 14. S/m column 15. none column 16. dbar column 17. none column 18. m column 19. none column 20. PSU column 21. none column 22. kg/m^3 column 23. none 4. Data Type a. Storage Type: column 1. integer column 2. string column 3. floating-point column 4. floating-point column 5. integer column 6. string column 7. integer column 8. integer column 9. integer column 10. integer column 11. integer column 12. floating-point column 13. string column 14. floating-point column 15. string column 16. floating-point column 17. string column 18. floating-point column 19. string column 20. floating-point column 21. string column 22. floating-point column 23. string b. Variable Codes: Flag_Temperature: Q = questionable value Flag_Conductivity: Q = questionable value Flag_Pressure: Q = questionable value Flag_Depth: Q = questionable value Flag_Salinity: Q = questionable value Flag_Sigma_t: Q = questionable value c. Numeric Range: column 1. 6 to 6 column 2. (none) column 3. -81.3048 to -81.3048 column 4. 31.3935 to 31.3935 column 5. 1667 to 1795 column 6. (none) column 7. 2003 to 2003 column 8. 1 to 12 column 9. 1 to 31 column 10. 0 to 23 column 11. 0 to 30 column 12. 7.3241 to 30.3733 column 13. (none) column 14. 1.3688 to 5.3595 column 15. (none) column 16. 0.006 to 4.388 column 17. (none) column 18. 0.0059585 to 4.3576 column 19. (none) column 20. 9.3061 to 33.5115 column 21. (none) column 22. 5.4021 to 23.7049 column 23. (none) d. Missing Value Code: 5. Data Format a. Column Type: column 1. numerical column 2. text column 3. numerical column 4. numerical column 5. numerical column 6. text column 7. numerical column 8. numerical column 9. numerical column 10. numerical column 11. numerical column 12. numerical column 13. text column 14. numerical column 15. text column 16. numerical column 17. text column 18. numerical column 19. text column 20. numerical column 21. text column 22. numerical column 23. text b. Number of Columns: 23 c. Decimal Places: column 1. 0 column 2. 0 column 3. 6 column 4. 6 column 5. 0 column 6. 0 column 7. 0 column 8. 0 column 9. 0 column 10. 0 column 11. 0 column 12. 3 column 13. 0 column 14. 3 column 15. 0 column 16. 3 column 17. 0 column 18. 3 column 19. 0 column 20. 3 column 21. 0 column 22. 3 column 23. 0 6. Logical Variable Type: column 1. nominal (discrete) column 2. nominal (none) column 3. geographic coordinate (continuous) column 4. geographic coordinate (continuous) column 5. nominal (discrete) column 6. datetime (none) column 7. datetime (discrete) column 8. datetime (discrete) column 9. datetime (discrete) column 10. datetime (discrete) column 11. datetime (discrete) column 12. data (continuous) column 13. coded value (none) column 14. data (continuous) column 15. coded value (none) column 16. data (continuous) column 17. coded value (none) column 18. calculation (continuous) column 19. coded value (none) column 20. calculation (continuous) column 21. coded value (none) column 22. calculation (continuous) column 23. coded value (none) 7. Flagging Criteria: column 1. none column 2. flag_locationcoords(x,col_Longitude,col_Latitude,0.25,"sensitive","geo_locations.mat")=" Q" column 3. x<-180="Q";x>180="Q" column 4. x<-90="Q";x>90="Q" column 5. none column 6. none column 7. none column 8. x<1="I";x>12="I" column 9. x<1="I";x>31="I" column 10. x<0="I";x>24="I" column 11. x<0="I";x>60="I" column 12. x<0="Q";x>35="Q";col_Depth<0.1="Q";flag_valuechange(x,5,5,3)="S";manually-assigned flags column 13. none column 14. manually-assigned flags column 15. none column 16. x<0.2="Q";x>10="Q";manually-assigned flags column 17. none column 18. x<0.1="Q";x>10="Q";manually-assigned flags column 19. none column 20. x<0="I";x>36="Q";col_Depth<0.1="Q";flag_valuechange(x,10,0,3)="S";manually-assigned flags column 21. none column 22. x<-5="Q";col_Depth<0.1="Q";x>28="Q";manually-assigned flags column 23. none C. Data Anomalies: The value of one record in Temperature was flagged as I (invalid value (out of range)) on 08/04/2003. Values of 2 records in Temperature were flagged as Q (questionable value) for dates: 06/09/2003, 10/15/2003. Values of 955 records in Conductivity were flagged as I (invalid value (out of range)) for dates: 01/01/2003-01/06/2003, 01/12/2003-01/20/2003, 06/09/2003, 08/04/2003, 10/21/2003-10/27/2003. Values of 658 records in Conductivity were flagged as Q (questionable value) for dates: 10/02/2003-10/15/2003, 10/21/2003. The value of one record in Pressure was flagged as Q (questionable value) on 06/09/2003. Values of 2 records in Pressure were flagged as X (excise row flag) for dates: 08/04/2003, 10/15/2003. Values of 3 records in Depth were flagged as Q (questionable value) for dates: 06/09/2003, 08/04/2003, 10/15/2003. Values of 3 records in TotalDepth were flagged as Q (questionable value) for dates: 06/09/2003, 08/04/2003, 10/15/2003. Values of 955 records in Salinity were flagged as I (invalid value (out of range)) for dates: 01/01/2003-01/06/2003, 01/12/2003-01/20/2003, 06/09/2003, 08/04/2003, 10/21/2003-10/27/2003. Values of 658 records in Salinity were flagged as Q (questionable value) for dates: 10/02/2003-10/15/2003, 10/21/2003. Values of 955 records in Sigma_t were flagged as I (invalid value (out of range)) for dates: 01/01/2003-01/06/2003, 01/12/2003-01/20/2003, 06/09/2003, 08/04/2003, 10/21/2003-10/27/2003. Values of 658 records in Sigma_t were flagged as Q (questionable value) for dates: 10/02/2003-10/15/2003, 10/21/2003. deleted the following rows with values in any column assigned QA/QC flag(s) X (excise row flag): 10353 and 13802. 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 #06 serial#1667 S/N 1667 SITE 6 Set up by K. Helm Time on 1/6/03 1800GMT Time into water 1/6/03 1502GMT Time out of water 04/15/03 1413GMT Time off 04/15/03 1449 GMT Sample Interval 1800sec. Deployment Information Date 1/6/03 Time 1502GMT YSI sal 24.7 Ysi temp11.6 Water depth 20'-7" Sensor height above bottom 7'-0" Retrieval Information Date 04/15/03 Time 1413GMT YSI sal 23.6 Ysi temp 19.6 Water depth 20'-7" Instrument condition Sensor tube - very clean Upload file name 06030467 Maintenance Record Date 1/20/03 Time 1855 GMT Ysi sal 24.5 Ysi temp 9.0 Water depth - 14.9" Sensor tube - very clean Date 2/3/03 Time 1800 GMT Ysi sal 26.3 Ysi temp 11.0 Water depth 17'-9" sensor tube - very clean Date 2/19/03 Time 1325 GMT Ysi sal 26.1 Ysi temp 12.0 Water depth 22'-6" Sensor tube - very clean Date 3/3/03 Time 1625GMT Ysi sal 24.3 Ysi temp 13.7 Water depth 19'-5" Sensor tube - very clean Date 3/17/03 Time 1625 Ysi Sal 20.1 Ysi Temp 15.8 Depth 14'-6" Cond sensor tube- very clean Date 4/1/03 Time 1705 Ysi sal 17.4 Ysi temp 17.9 Depth 16'-4" Cond sensor tube very clean Instrument deployment, maintenance and retrieval observations: site #06 serial#1791 S/N 1791 SITE 6 Set up by K. Helm Time on 4/15/03 1700GMT Time into water 4/15/03 1417GMT Time out of water 07/21/03 1510GMT Time off 07/21/03 1857 GMT Sample Interval 1800sec. Deployment Information Date 4/15/03 Time 1417GMT YSI sal 23.6 Ysi temp 19.6 Water depth 20'-3" Sensor height above bottom 7' Retrieval Information Date 07/21/03 Time 1510 GMT YSI sal 20.9 Ysi temp 28.9 Water depth 17'-3" Instrument condition Sensor tube - very clean Upload file name 06030791 Maintenance Record Date 4/28/03 Time 1549 GMT Ysi sal 19.9 Ysi temp 22.0 Water depth - 13'-7" Sensor tube - very clean Date 5/13/03 Time 1417 GMT Ysi sal 26.7 Ysi temp 23.8 Water depth 13'-6" sensor tube - very clean Date 5/27/03 Time 1404 GMT Ysi sal 21.7 Ysi temp 26.6 Water depth 17'-9" Sensor tube - very clean Date 6/09/03 Time 1353 GMT Ysi sal 20.1 Ysi temp 26.6 Water depth 14'-6" Sensor tube - very clean Date 6/23/03 Time 1230 Ysi Sal 22.1Ysi Temp 27.6 Depth 16'-5" Cond sensor tube -very clean Date 7/8/03 Time 1415 Ysi sal 21.1 Ysi temp 29.2 Depth 15'-2" Cond sensor tube very clean Instrument deployment, maintenance and retrieval observations: site #06 serial#1667 S/N 1667 SITE 6 Set up by K. Helm Time on 7/21/03 2000GMT Time into water 7/21/03 1512 GMT Time out of water 11/11/03 1211 GMT Time off 11/11/03 1505 GMT Sample Interval 1800sec. Deployment Information Date 7/21/03 Time 1512GMT YSI sal 20.9 Ysi temp 28.9 Water depth 17'-3" Sensor height above bottom 7'-0" Retrieval Information Date 11/11/03 Time 1211 GMT YSI sal 29.3 Ysi temp 19.5 Water depth 17'-11" Instrument condition Sensor tube - clog/hose clean Upload file name 06031167 Maintenance Record Date 8/04/03 Time 1553 GMT Ysi sal 26.7 Ysi temp 28.3 Water depth - 21'-2" Sensor tube - very clean Date 8/18/03 Time 1526 GMT Ysi sal 25.7 Ysi temp 28.9 Water depth 18'-1" sensor tube - very clean Date 9/03/03 Time 1408 GMT Ysi sal 21.5 Ysi temp 30.1 Water depth 16'-8" Sensor tube - very clean Date 9/15/03 Time 1700 GMT Ysi sal 28.8 Ysi temp 27.4 Water depth 18'-11" Sensor tube - very clean Date 9/29/03 Time 1217 Ysi Sal 28.3 Ysi Temp 25.8 Depth 20'-0" Cond sensor tube -very clean Date 10/15/03 Time 1223 Ysi sal 29.3 Ysi temp 22.4 Depth 18'-6" Cond sensor tube clog/hose clean Date 10/27/03 Time 1810 Ysi sal 30.2 Ysi temp 23.4 Depth 18'-6" Cond. Sensor tube - clog/hoseclean Instrument deployment, maintenance and retrieval observations: site #6 serial#1795 S/N 1795 SITE 6 Set up by K. Helm Time on 11/11/03 2100GMT Time into water 11/11/03 1211GMT Time out of water 02/11/04 1513GMT Time off 02/11/04 1738 GMT Sample Interval 1800sec. Deployment Information Date 11/11/03 Time 1211GMT YSI sal 29.3 Ysi temp 19.5 Water depth 17'-11" Sensor height above bottom 7'-0" Retrieval Information Date 02/11/04 Time 1513 GMT YSI sal 28.0 Ysi temp 11.6 Water depth 17'-8" Instrument condition Sensor tube - very clean Upload file name 06040295 Maintenance Record Date 11/20/03 Time 1711 GMT Ysi sal 27.0 Ysi temp 19.5 Water depth - 16'-5" Sensor tube - very clean Date 12/5/03 Time 1503 GMT Ysi sal 30.0 Ysi temp 14.2 Water depth 15'-7" sensor tube - very clean Date 12/18/03 Time 1557 GMT Ysi sal 27.3 Ysi temp 11.7 Water depth 15'-0" Sensor tube - very clean Date 1/06/04 Time 1348 GMT Ysi sal 27.1 Ysi temp 13.9 Water depth 18'-2" Sensor tube - very clean Date 1/20/04 Time 1523 Ysi Sal 30.0 Ysi Temp 10.5 Depth 15'-0" Cond sensor tube -very clean Date 2/3/04 Time 1542 Ysi sal 26.5 Ysi temp 10.4 Depth 15'-5" Cond sensor tube very clean 4. Questions and Comments from Users: none