I. Data Set Descriptors A. Title: Daniela Di Iorio. 2015. Continuous salinity, temperature and depth measurements from moored hydrographic data loggers deployed at GCE7_Hydro (Altamaha River near Carrs Island, Georgia) from 01-Jan-2010 through 31-Dec-2010. Georgia Coastal Ecosystems LTER Data Catalog (data set PHY-GCEM-1101e; http://gce-lter.marsci.uga.edu/public/app/dataset_details.asp?accession=PHY-GCEM-1101e) B. Accession Number: PHY-GCEM-1101e C. Description 1. Originator(s): Name: Daniela Di Iorio Address: Department of Marine Sciences, University of Georgia, Athens, Georgia Postal Code: 30602 Country: USA Email: daniela@uga.edu 2. Abstract: Conductivity, temperature and pressure were measured continuously at Georgia Coastal Ecosystems LTER sampling location GCE7_Hydro (Altamaha River near Carrs Island, Georgia) from 01-Jan-2010 through 31-Dec-2010. Observations were logged at 30 minute intervals by moored Sea-Bird Electronics MicroCAT 37-SM data loggers and downloaded approximately semi-monthly. Salinity, depth and sigma-t (density anomaly) were calculated from the measured parameters using standard UNESCO algorithms. This data set was collected as part of the GCE-LTER Project continuous salinity, temperature and water level monitoring program. 3. Study Type: Monitoring 4. Study Themes: Physical Oceanography 5. LTER Core Areas: Inorganic Fluxes 6. Georeferences: geographic coordinates as data set columns 7. Submission Date: not submitted D. Keywords: conductivity, density, depth, Hydrographic Moorings, hydrography, Inorganic Nutrients, monitoring, mooring, pressure, salinity, sonde, temperature, water column, water quality II. Research Origin Descriptors A. Overall Project Description 1. Project Title: Georgia Coastal Ecosystems LTER III 2. Principal Investigators: Name: Merryl Alber Address: Dept. of Marine Sciences, University of Georgia, Athens, Georgia Postal Code: 30602-3636 Country: USA Email: malber@uga.edu Name: Steven C. Pennings Address: Department of Biology and Biochemistry, University of Houston, Houston, Texas Postal Code: 77204-5513 Country: USA Email: scpennin@central.uh.edu 3. Funding Period: 27-Dec-2006 to 17-Sep-2012 4. Objectives: The research proposed for GCE-III is designed to address how variations in salinity and inundation, driven by climate change and anthropogenic factors, affect biotic and ecosystem responses at different spatial and temporal scales, and to predict the consequences of these changes for habitat provisioning and carbon (C) sequestration across the coastal landscape. 5. Abstract: The Georgia Coastal Ecosystems (GCE) LTER is located along three adjacent sounds on the Atlantic coast and includes both intertidal marshes and estuaries. Long-term drivers of climate change, sea level rise and human alterations of the landscape will cause transitions in dominant habitat types (state changes) within the GCE domain by changing the amounts and patterns of water delivery across the landscape. These changes in water delivery can be conceptualized as presses and pulses in river inflow, local runoff, groundwater input, and tidal inundation, which will in turn manifest themselves as changes in salinity and inundation patterns in the domain. The research proposed for GCE-III is designed to address how variations in salinity and inundation, driven by climate change and anthropogenic factors, affect biotic and ecosystem responses at different spatial and temporal scales, and to predict the consequences of these changes for habitat provisioning and carbon (C) sequestration across the coastal landscape. The goals are to: 1) Track long-term changes in climate and human actions in the watershed and adjacent uplands, and evaluate the effects of these drivers on domain boundary conditions. 2) Describe temporal and spatial variability in physical, chemical, geological and biological, and to evaluate how they are affected by variations in river inflow and other boundary conditions. 3) Characterize the responses of three dominant habitats in the domain to pulses and presses in salinity and inundation. 4) Describe patterns of habitat provisioning and C sequestration and export in the GCE domain, and to evaluate how these might be affected by changes in salinity and inundation. These efforts will be synthesized into a synoptic understanding of both biotic and ecosystem responses to variations in salinity and inundation driven by climate change and human activities, which will be used to assess thresholds between habitats and the potential for state changes in the domain. 6. Funding Source: NSF OCE-9982133 and OCE-0620959 B. Sub-project Description 1. Site Description a. Geographic Location: GCE-AL -- Altamaha River, Georgia, USA GCE7_Hydro -- Hammersmith Creek hydrographic datalogger deployment Coordinates: GCE-AL -- NW: 81 34 56.3 W, 31 24 05.1 N NE: 81 14 16.6 W, 31 24 05.1 N SE: 81 14 16.6 W, 31 17 45.7 N SW: 81 34 56.3 W, 31 17 45.7 N GCE7_Hydro -- 81 28 31.7 W, 31 20 17.5 N b. Physiographic Region: GCE-AL -- Estuary and tidal marsh GCE7_Hydro -- Estuary and tidal marsh c. Landform Components: GCE-AL -- Intertidal marsh bordering sounds, tidal channels and creeks GCE7_Hydro -- Intertidal marsh bordering sounds, tidal channels and creeks d. Hydrographic Characteristics: GCE-AL -- Site encompasses the Altamaha River estuary and nearby tidal creeks, and is subject to 2-3.4m semi-diurnal tides. High freshwater input from the Altamaha River, one of the largest rivers in the Southeastern United States. GCE7_Hydro -- Site encompasses the Altamaha River estuary and nearby tidal creeks, and is subject to 2-3.4m semi-diurnal tides. High freshwater input from the Altamaha River, one of the largest rivers in the Southeastern United States. e. Topographic Attributes: GCE-AL -- Flat, with elevations ranging from 0-3.4m above mean low tide GCE7_Hydro -- Flat, with elevations ranging from 0-3.4m above mean low tide f. Geology, Lithology and Soils: GCE-AL -- unspecified GCE7_Hydro -- unspecified g. Vegetation Communities: GCE-AL -- unspecified GCE7_Hydro -- unspecified h. History of Land Use and Disturbance: i. Climate: Climate summary for Sapelo Island, Georgia, based on NWS data from 1980-2001: Daily-aggregated Values: Mean (sample standard deviation) mean air temperature: 19.78°C (6.98°C) minimum air temperature: 14.64°C (7.54°C) maximum air temperature: 24.62°C (6.78°C) total precipitation: 3.58mm (11.35mm) Yearly-aggregated Values: Mean (sample standard deviation) total precipitation (1981-2000): 1302mm (250mm) 2. Experimental or Sampling Design a. Design Characteristics: Conductivity, temperature and pressure were continuously monitored using an autonomous data-logging sensor package (sonde) that was moored to a piling and submerged 1-1.5m below mean low water. b. Permanent Plots: none c. Data Collection Duration and Frequency: The MicroCAT was programmed to autonomously measure and log conductivity, temperature and pressure at a sampling rate of 30 minutes (based on its internal chronometer). Upon retrieval the data was downloaded from the instrument via RS-232 serial communications and processed using custom Matlab(r) procedures to calculate depth (i.e. from pressure and latitude), salinity and sigma-t (i.e. from conductivity and temperature), and date and time components from sample time stamps. Beginning of Observations: 01-Jan-2010 End of Observations: 31-Dec-2010 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: Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 3342, last factory calibration 05-Mar-2004) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 2413, last factory calibration 29-Nov-2006) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 3746, last factory calibration 04-Apr-2008) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 1794, last factory calibration 19-Apr-2006) Moored CTD datalogger (Sea-Bird Electronics Inc., model MicroCAT 37-SM S/N 1793, last factory calibration 08-Jul-2010) c. Taxonomy and Systematics: not applicable d. Speclies List: e. Permit History: 4. Project Personnel a. Personnel: 1: Daniela Di Iorio 2: Wade M. Sheldon 3: Jacob Shalack 4: Daniel Saucedo b. Affiliations: 1: University of Georgia, Athens, Georgia 2: University of Georgia, Athens, Georgia 3: University of Georgia Marine Inst., Sapelo Island, Georgia 4: University of Georgia Marine Inst., Sapelo Island, Georgia III. Data Set Status and Accessibility A. Status 1. Latest Update: 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: 04-Mar-2011, Public: 03-Mar-2012 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-1101e_1_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: 07100342.asc (4318 records) 07100513.asc (3684 records) 07100846.asc (5084 records) 07101294.asc (4661 records) 07110293.asc (3738 records) Data processing history: 04-Mar-2010: data uploaded from SBE 37-SM MicroCAT using SEATERM software version 1.50 10-Mar-2010: new GCE Data Structure 1.1 created ('newstruct') 10-Mar-2010: data imported from processed SBE SM-37 sonde data file '07100342.asc' (4318 records) ('imp_gcesonde') 10-Mar-2010: deleted column Second from the structure ('deletecols') 10-Mar-2010: calculated numeric MATLAB serial date from individual date component columns, added 'Date' column at position 1 ('add_datecol') 10-Mar-2010: added column 'Instrument' at position 1 ('addcol') 10-Mar-2010: added column 'Latitude' at position 1 ('addcol') 10-Mar-2010: Q/C flagging criteria applied for column(s) Latitude, 'flags' field updated ('dataflag') 10-Mar-2010: added column 'Longitude' at position 1 ('addcol') 10-Mar-2010: Q/C flagging criteria applied for column(s) Longitude, 'flags' field updated ('dataflag') 10-Mar-2010: added column 'Site' at position 1 ('addcol') 10-Mar-2010: added column 'Calibration' at position 17 ('addcol') 10-Mar-2010: Q/C flagging criteria applied for column(s) Calibration, 'flags' field updated ('dataflag') 10-Mar-2010: updated 22 metadata fields in the Data, Dataset, Site, Status, Study, Supplement sections ('addmeta') 10-Mar-2010: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 10-Mar-2010: edited structure data ('ui_datagrid'): deleted record(s) 4317 and 4318 10-Mar-2010: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 01-Jun-2010: 3678 rows added at the bottom of the data set ('datamerge') 01-Jun-2010: updated 14 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 01-Jun-2010: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 01-Jun-2010: inserted 4 new records with date/time values and NaN/null data values (replicating common values in the non-data columns Site, Longitude, Latitude, Instrument, Calibration and Pump) to fill in date/time interval gaps in the data series ('fill_date_gaps') 01-Jun-2010: sorted by column Date(ascending) ('sortdata') 01-Jun-2010: 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') 01-Jun-2010: QA/QC flags assigned by visual inspection (ui_visualqc); flags set on Conductivity record(s): 4321, 4322, 4323, 4324, 4325, 4326, 4327, 4328, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4343, 4344, 4345, 4346, 4347, 4348, 4349, 4350, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365 and 4366 01-Jun-2010: manually edited data set metadata ('ui_editmetadata') 01-Jun-2010: edited data set title in structure and metadata ('ui_editor') 01-Jun-2010: copied QA/QC flags from column(s) Conductivity, Temperature and Pressure 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') 01-Jun-2010: converted values in column(s) Conductivity, Salinity and Sigma_t assigned QA/QC flag(s) Q (questionable value) or I (invalid value (out of range)) to NaN/empty: Conductivity record(s) 4321, 4322, 4323, 4324, 4325, 4326, 4327, 4328, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4343, 4344, 4345, 4346, 4347, 4348, 4349, 4350, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365 and 4366, Salinity record(s) 4321, 4322, 4323, 4324, 4325, 4326, 4327, 4328, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4343, 4344, 4345, 4346, 4347, 4348, 4349, 4350, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365 and 4366, Sigma_t record(s) 4321, 4322, 4323, 4324, 4325, 4326, 4327, 4328, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4343, 4344, 4345, 4346, 4347, 4348, 4349, 4350, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365 and 4366 ('nullflags') 01-Jun-2010: sorted by column Date(ascending) ('sortdata') 01-Jun-2010: replaced 4 missing values in column Temperature with estimated values based on 1D interpolation of Temperature as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 50 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 01-Jun-2010: 4 values in 'Temperature' were updated with new values ('update_data'): changed record 4317 from NaN to 10.361, changed record 4318 from NaN to 10.482, changed record 4319 from NaN to 10.597, changed record 4320 from NaN to 10.696 01-Jun-2010: Q/C flagging criteria applied for column(s) Temperature, 'flags' field updated ('dataflag') 01-Jun-2010: replaced 50 missing values in column Conductivity with estimated values based on 1D interpolation of Conductivity as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 50 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 01-Jun-2010: 50 values in 'Conductivity' were updated with new values ('update_data'): changed record 4317 from NaN to 0.006, changed record 4318 from NaN to 0.006, changed record 4319 from NaN to 0.006, changed record 4320 from NaN to 0.006, changed record 4321 from NaN to 0.006, changed record 4322 from NaN to 0.006, changed record 4323 from NaN to 0.006, changed record 4324 from NaN to 0.006, changed record 4325 from NaN to 0.006, changed record 4326 from NaN to 0.006, changed record 4327 from NaN to 0.006, changed record 4328 from NaN to 0.006, changed record 4329 from NaN to 0.006, changed record 4330 from NaN to 0.006, changed record 4331 from NaN to 0.006, changed record 4332 from NaN to 0.006, changed record 4333 from NaN to 0.006, changed record 4334 from NaN to 0.006, changed record 4335 from NaN to 0.006, changed record 4336 from NaN to 0.006, changed record 4337 from NaN to 0.006, changed record 4338 from NaN to 0.006, changed record 4339 from NaN to 0.006, changed record 4340 from NaN to 0.006, changed record 4341 from NaN to 0.006, changed record 4342 from NaN to 0.006, changed record 4343 from NaN to 0.006, changed record 4344 from NaN to 0.006, changed record 4345 from NaN to 0.006, changed record 4346 from NaN to 0.006, changed record 4347 from NaN to 0.006, changed record 4348 from NaN to 0.006, changed record 4349 from NaN to 0.006, changed record 4350 from NaN to 0.006, changed record 4351 from NaN to 0.006, changed record 4352 from NaN to 0.006, changed record 4353 from NaN to 0.006, changed record 4354 from NaN to 0.006, changed record 4355 from NaN to 0.006, changed record 4356 from NaN to 0.006, changed record 4357 from NaN to 0.006, changed record 4358 from NaN to 0.006, changed record 4359 from NaN to 0.006, changed record 4360 from NaN to 0.006, changed record 4361 from NaN to 0.006, changed record 4362 from NaN to 0.006, changed record 4363 from NaN to 0.006, changed record 4364 from NaN to 0.006, changed record 4365 from NaN to 0.006, changed record 4366 from NaN to 0.006 01-Jun-2010: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field updated ('dataflag') 01-Jun-2010: replaced 4 missing values in column Pressure with estimated values based on 1D interpolation of Pressure as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 50 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 01-Jun-2010: 4 values in 'Pressure' were updated with new values ('update_data'): changed record 4317 from NaN to 2.147, changed record 4318 from NaN to 2.010, changed record 4319 from NaN to 1.882, changed record 4320 from NaN to 1.764 01-Jun-2010: Q/C flagging criteria applied for column(s) Pressure, 'flags' field updated ('dataflag') 01-Jun-2010: replaced 4 missing values in column Depth with estimated values based on 1D interpolation of Depth as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 50 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 01-Jun-2010: 4 values in 'Depth' were updated with new values ('update_data'): changed record 4317 from NaN to 2.132, changed record 4318 from NaN to 1.996, changed record 4319 from NaN to 1.869, changed record 4320 from NaN to 1.752 01-Jun-2010: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated ('dataflag') 01-Jun-2010: replaced 50 missing values in column Salinity with estimated values based on 1D interpolation of Salinity as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 50 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 01-Jun-2010: 50 values in 'Salinity' were updated with new values ('update_data'): changed record 4317 from NaN to 0.039, changed record 4318 from NaN to 0.039, changed record 4319 from NaN to 0.039, changed record 4320 from NaN to 0.039, changed record 4321 from NaN to 0.039, changed record 4322 from NaN to 0.039, changed record 4323 from NaN to 0.039, changed record 4324 from NaN to 0.039, changed record 4325 from NaN to 0.040, changed record 4326 from NaN to 0.040, changed record 4327 from NaN to 0.040, changed record 4328 from NaN to 0.040, changed record 4329 from NaN to 0.040, changed record 4330 from NaN to 0.040, changed record 4331 from NaN to 0.040, changed record 4332 from NaN to 0.040, changed record 4333 from NaN to 0.040, changed record 4334 from NaN to 0.040, changed record 4335 from NaN to 0.040, changed record 4336 from NaN to 0.041, changed record 4337 from NaN to 0.041, changed record 4338 from NaN to 0.041, changed record 4339 from NaN to 0.041, changed record 4340 from NaN to 0.041, changed record 4341 from NaN to 0.041, changed record 4342 from NaN to 0.041, changed record 4343 from NaN to 0.041, changed record 4344 from NaN to 0.041, changed record 4345 from NaN to 0.041, changed record 4346 from NaN to 0.041, changed record 4347 from NaN to 0.041, changed record 4348 from NaN to 0.041, changed record 4349 from NaN to 0.041, changed record 4350 from NaN to 0.041, changed record 4351 from NaN to 0.041, changed record 4352 from NaN to 0.041, changed record 4353 from NaN to 0.041, changed record 4354 from NaN to 0.041, changed record 4355 from NaN to 0.042, changed record 4356 from NaN to 0.042, changed record 4357 from NaN to 0.042, changed record 4358 from NaN to 0.042, changed record 4359 from NaN to 0.042, changed record 4360 from NaN to 0.042, changed record 4361 from NaN to 0.042, changed record 4362 from NaN to 0.042, changed record 4363 from NaN to 0.042, changed record 4364 from NaN to 0.042, changed record 4365 from NaN to 0.042, changed record 4366 from NaN to 0.042 01-Jun-2010: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 01-Jun-2010: replaced 50 missing values in column Sigma_t with estimated values based on 1D interpolation of Sigma_t as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 50 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 01-Jun-2010: 50 values in 'Sigma_t' were updated with new values ('update_data'): changed record 4317 from NaN to -0.290, changed record 4318 from NaN to -0.290, changed record 4319 from NaN to -0.290, changed record 4320 from NaN to -0.290, changed record 4321 from NaN to -0.290, changed record 4322 from NaN to -0.291, changed record 4323 from NaN to -0.291, changed record 4324 from NaN to -0.291, changed record 4325 from NaN to -0.291, changed record 4326 from NaN to -0.291, changed record 4327 from NaN to -0.291, changed record 4328 from NaN to -0.291, changed record 4329 from NaN to -0.291, changed record 4330 from NaN to -0.291, changed record 4331 from NaN to -0.291, changed record 4332 from NaN to -0.291, changed record 4333 from NaN to -0.291, changed record 4334 from NaN to -0.291, changed record 4335 from NaN to -0.291, changed record 4336 from NaN to -0.291, changed record 4337 from NaN to -0.291, changed record 4338 from NaN to -0.291, changed record 4339 from NaN to -0.291, changed record 4340 from NaN to -0.291, changed record 4341 from NaN to -0.291, changed record 4342 from NaN to -0.292, changed record 4343 from NaN to -0.292, changed record 4344 from NaN to -0.292, changed record 4345 from NaN to -0.292, changed record 4346 from NaN to -0.292, changed record 4347 from NaN to -0.292, changed record 4348 from NaN to -0.292, changed record 4349 from NaN to -0.292, changed record 4350 from NaN to -0.292, changed record 4351 from NaN to -0.292, changed record 4352 from NaN to -0.292, changed record 4353 from NaN to -0.292, changed record 4354 from NaN to -0.292, changed record 4355 from NaN to -0.292, changed record 4356 from NaN to -0.292, changed record 4357 from NaN to -0.292, changed record 4358 from NaN to -0.292, changed record 4359 from NaN to -0.292, changed record 4360 from NaN to -0.292, changed record 4361 from NaN to -0.292, changed record 4362 from NaN to -0.293, changed record 4363 from NaN to -0.293, changed record 4364 from NaN to -0.293, changed record 4365 from NaN to -0.293, changed record 4366 from NaN to -0.293 01-Jun-2010: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated ('dataflag') 01-Jun-2010: manually edited data set metadata ('ui_editmetadata') 01-Jun-2010: documented flagged and missing values in columns Temperature, Conductivity, Pressure, Depth, Salinity and Sigma_t as data set anomalies in the metadata ('add_anomalies') 01-Jun-2010: manually edited data set metadata ('ui_editmetadata') 01-Jun-2010: manually edited data set metadata ('ui_editmetadata') 03-Sep-2010: 5082 rows added at the bottom of the data set ('datamerge') 03-Sep-2010: updated 14 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 03-Sep-2010: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 03-Sep-2010: manually edited data set metadata ('ui_editmetadata') 03-Sep-2010: edited data set title in structure and metadata ('ui_editor') 03-Sep-2010: inserted 10 new records with date/time values and NaN/null data values (replicating common values in the non-data columns Site, Longitude, Latitude, Instrument, Calibration and Pump) to fill in date/time interval gaps in the data series ('fill_date_gaps') 03-Sep-2010: sorted by column Date(ascending) ('sortdata') 03-Sep-2010: 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-Sep-2010: sorted by column Date(ascending) ('sortdata') 03-Sep-2010: replaced 10 missing values in column Temperature with estimated values based on 1D interpolation of Temperature as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 03-Sep-2010: 10 values in 'Temperature' were updated with new values ('update_data'): changed record 7999 from NaN to 24.225, changed record 8000 from NaN to 24.243, changed record 8001 from NaN to 24.270, changed record 8002 from NaN to 24.303, changed record 8003 from NaN to 24.339, changed record 8004 from NaN to 24.377, changed record 8005 from NaN to 24.414, changed record 8006 from NaN to 24.447, changed record 8007 from NaN to 24.474, changed record 8008 from NaN to 24.491 03-Sep-2010: Q/C flagging criteria applied for column(s) Temperature, 'flags' field updated ('dataflag') 03-Sep-2010: replaced 10 missing values in column Conductivity with estimated values based on 1D interpolation of Conductivity as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 03-Sep-2010: 10 values in 'Conductivity' were updated with new values ('update_data'): changed record 7999 from NaN to 0.010, changed record 8000 from NaN to 0.011, changed record 8001 from NaN to 0.011, changed record 8002 from NaN to 0.011, changed record 8003 from NaN to 0.011, changed record 8004 from NaN to 0.012, changed record 8005 from NaN to 0.012, changed record 8006 from NaN to 0.013, changed record 8007 from NaN to 0.014, changed record 8008 from NaN to 0.014 03-Sep-2010: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field updated ('dataflag') 03-Sep-2010: replaced 10 missing values in column Pressure with estimated values based on 1D interpolation of Pressure as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 03-Sep-2010: 10 values in 'Pressure' were updated with new values ('update_data'): changed record 7999 from NaN to 1.508, changed record 8000 from NaN to 1.600, changed record 8001 from NaN to 1.736, changed record 8002 from NaN to 1.905, changed record 8003 from NaN to 2.093, changed record 8004 from NaN to 2.287, changed record 8005 from NaN to 2.475, changed record 8006 from NaN to 2.644, changed record 8007 from NaN to 2.780, changed record 8008 from NaN to 2.872 03-Sep-2010: Q/C flagging criteria applied for column(s) Pressure, 'flags' field updated ('dataflag') 03-Sep-2010: replaced 10 missing values in column Depth with estimated values based on 1D interpolation of Depth as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 03-Sep-2010: 10 values in 'Depth' were updated with new values ('update_data'): changed record 7999 from NaN to 1.498, changed record 8000 from NaN to 1.589, changed record 8001 from NaN to 1.724, changed record 8002 from NaN to 1.892, changed record 8003 from NaN to 2.078, changed record 8004 from NaN to 2.271, changed record 8005 from NaN to 2.458, changed record 8006 from NaN to 2.626, changed record 8007 from NaN to 2.761, changed record 8008 from NaN to 2.852 03-Sep-2010: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated ('dataflag') 03-Sep-2010: replaced 10 missing values in column Salinity with estimated values based on 1D interpolation of Salinity as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 03-Sep-2010: 10 values in 'Salinity' were updated with new values ('update_data'): changed record 7999 from NaN to 0.054, changed record 8000 from NaN to 0.055, changed record 8001 from NaN to 0.056, changed record 8002 from NaN to 0.057, changed record 8003 from NaN to 0.058, changed record 8004 from NaN to 0.060, changed record 8005 from NaN to 0.063, changed record 8006 from NaN to 0.065, changed record 8007 from NaN to 0.068, changed record 8008 from NaN to 0.071 03-Sep-2010: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 03-Sep-2010: replaced 10 missing values in column Sigma_t with estimated values based on 1D interpolation of Sigma_t as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 12 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 03-Sep-2010: 10 values in 'Sigma_t' were updated with new values ('update_data'): changed record 7999 from NaN to -2.717, changed record 8000 from NaN to -2.720, changed record 8001 from NaN to -2.725, changed record 8002 from NaN to -2.732, changed record 8003 from NaN to -2.739, changed record 8004 from NaN to -2.746, changed record 8005 from NaN to -2.753, changed record 8006 from NaN to -2.759, changed record 8007 from NaN to -2.765, changed record 8008 from NaN to -2.768 03-Sep-2010: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated ('dataflag') 03-Sep-2010: manually edited data set metadata ('ui_editmetadata') 03-Sep-2010: documented flagged and missing values in columns Temperature, Conductivity, Pressure, Depth, Salinity and Sigma_t as data set anomalies in the metadata ('add_anomalies') 10-Dec-2010: 4658 rows added at the bottom of the data set ('datamerge') 10-Dec-2010: updated 14 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 10-Dec-2010: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 10-Dec-2010: manually edited data set metadata ('ui_editmetadata') 10-Dec-2010: edited data set title in structure and metadata ('ui_editor') 10-Dec-2010: inserted 6 new records with date/time values and NaN/null data values (replicating common values in the non-data columns Site, Longitude, Latitude, Instrument, Calibration and Pump) to fill in date/time interval gaps in the data series ('fill_date_gaps') 10-Dec-2010: sorted by column Date(ascending) ('sortdata') 10-Dec-2010: 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') 10-Dec-2010: sorted by column Date(ascending) ('sortdata') 10-Dec-2010: replaced 6 missing values in column Temperature with estimated values based on 1D interpolation of Temperature as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 14 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 10-Dec-2010: 6 values in 'Temperature' were updated with new values ('update_data'): changed record 13091 from NaN to 27.804, changed record 13092 from NaN to 27.830, changed record 13093 from NaN to 27.871, changed record 13094 from NaN to 27.925, changed record 13095 from NaN to 27.990, changed record 13096 from NaN to 28.064 10-Dec-2010: Q/C flagging criteria applied for column(s) Temperature, 'flags' field updated ('dataflag') 10-Dec-2010: replaced 6 missing values in column Conductivity with estimated values based on 1D interpolation of Conductivity as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 14 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 10-Dec-2010: 6 values in 'Conductivity' were updated with new values ('update_data'): changed record 13091 from NaN to 0.020, changed record 13092 from NaN to 0.019, changed record 13093 from NaN to 0.019, changed record 13094 from NaN to 0.018, changed record 13095 from NaN to 0.018, changed record 13096 from NaN to 0.018 10-Dec-2010: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field updated ('dataflag') 10-Dec-2010: replaced 6 missing values in column Pressure with estimated values based on 1D interpolation of Pressure as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 14 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 10-Dec-2010: 6 values in 'Pressure' were updated with new values ('update_data'): changed record 13091 from NaN to 1.543, changed record 13092 from NaN to 1.646, changed record 13093 from NaN to 1.797, changed record 13094 from NaN to 1.981, changed record 13095 from NaN to 2.179, changed record 13096 from NaN to 2.376 10-Dec-2010: Q/C flagging criteria applied for column(s) Pressure, 'flags' field updated ('dataflag') 10-Dec-2010: replaced 6 missing values in column Depth with estimated values based on 1D interpolation of Depth as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 14 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 10-Dec-2010: 6 values in 'Depth' were updated with new values ('update_data'): changed record 13091 from NaN to 1.532, changed record 13092 from NaN to 1.635, changed record 13093 from NaN to 1.785, changed record 13094 from NaN to 1.967, changed record 13095 from NaN to 2.164, changed record 13096 from NaN to 2.359 10-Dec-2010: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated ('dataflag') 10-Dec-2010: replaced 6 missing values in column Salinity with estimated values based on 1D interpolation of Salinity as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 14 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 10-Dec-2010: 6 values in 'Salinity' were updated with new values ('update_data'): changed record 13091 from NaN to 0.091, changed record 13092 from NaN to 0.090, changed record 13093 from NaN to 0.088, changed record 13094 from NaN to 0.086, changed record 13095 from NaN to 0.084, changed record 13096 from NaN to 0.083 10-Dec-2010: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 10-Dec-2010: replaced 6 missing values in column Sigma_t with estimated values based on 1D interpolation of Sigma_t as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 14 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 10-Dec-2010: 6 values in 'Sigma_t' were updated with new values ('update_data'): changed record 13091 from NaN to -3.641, changed record 13092 from NaN to -3.649, changed record 13093 from NaN to -3.661, changed record 13094 from NaN to -3.678, changed record 13095 from NaN to -3.698, changed record 13096 from NaN to -3.720 10-Dec-2010: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated ('dataflag') 10-Dec-2010: manually edited data set metadata ('ui_editmetadata') 10-Dec-2010: documented flagged and missing values in columns Temperature, Conductivity, Pressure, Depth, Salinity and Sigma_t as data set anomalies in the metadata ('add_anomalies') 10-Dec-2010: manually edited data set metadata ('ui_editmetadata') 14-Dec-2010: deleted columns Year, Month, Day, Hour and Minute from the structure ('deletecols') 14-Dec-2010: 332 values in 'Date' were updated with new values ('update_data') 14-Dec-2010: Q/C flagging criteria applied for column(s) Date, 'flags' field updated ('dataflag') 14-Dec-2010: Year, Month, Day, Hour and Minute datetime columns added after column Date ('add_datepartcols') 11-Mar-2011: 3733 rows added at the bottom of the data set ('datamerge') 11-Mar-2011: updated 14 metadata fields in the Data, Dataset, Status, Study, Supplement sections ('addmeta') 11-Mar-2011: Q/C flagging criteria applied, 'flags' field updated ('dataflag') 11-Mar-2011: manually edited data set metadata ('ui_editmetadata') 11-Mar-2011: edited data set title in structure and metadata ('ui_editor') 11-Mar-2011: inserted 4 new records with date/time values and NaN/null data values (replicating common values in the non-data columns Site, Longitude, Latitude, Instrument, Calibration and Pump) to fill in date/time interval gaps in the data series ('fill_date_gaps') 11-Mar-2011: sorted by column Date(ascending) ('sortdata') 11-Mar-2011: deleted existing datetime columns Year, Month, Day, Hour and Minute; updated Year, Month, Day, Hour and Minute datetime columns added after column Date ('add_datepartcols') 11-Mar-2011: sorted by column Date(ascending) ('sortdata') 11-Mar-2011: replaced 4 missing values in column Temperature with estimated values based on 1D interpolation of Temperature as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 11-Mar-2011: 4 values in 'Temperature' were updated with new values ('update_data'): changed record 17755 from NaN to 10.445, changed record 17756 from NaN to 10.397, changed record 17757 from NaN to 10.340, changed record 17758 from NaN to 10.275 11-Mar-2011: Q/C flagging criteria applied for column(s) Temperature, 'flags' field updated ('dataflag') 11-Mar-2011: replaced 4 missing values in column Conductivity with estimated values based on 1D interpolation of Conductivity as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 11-Mar-2011: 4 values in 'Conductivity' were updated with new values ('update_data'): changed record 17755 from NaN to 0.067, changed record 17756 from NaN to 0.061, changed record 17757 from NaN to 0.056, changed record 17758 from NaN to 0.050 11-Mar-2011: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field updated ('dataflag') 11-Mar-2011: replaced 4 missing values in column Pressure with estimated values based on 1D interpolation of Pressure as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 11-Mar-2011: 4 values in 'Pressure' were updated with new values ('update_data'): changed record 17755 from NaN to 2.420, changed record 17756 from NaN to 2.255, changed record 17757 from NaN to 2.091, changed record 17758 from NaN to 1.931 11-Mar-2011: Q/C flagging criteria applied for column(s) Pressure, 'flags' field updated ('dataflag') 11-Mar-2011: replaced 4 missing values in column Depth with estimated values based on 1D interpolation of Depth as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 11-Mar-2011: 4 values in 'Depth' were updated with new values ('update_data'): changed record 17755 from NaN to 2.403, changed record 17756 from NaN to 2.239, changed record 17757 from NaN to 2.077, changed record 17758 from NaN to 1.918 11-Mar-2011: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated ('dataflag') 11-Mar-2011: replaced 4 missing values in column Salinity with estimated values based on 1D interpolation of Salinity as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 11-Mar-2011: 4 values in 'Salinity' were updated with new values ('update_data'): changed record 17755 from NaN to 0.457, changed record 17756 from NaN to 0.418, changed record 17757 from NaN to 0.382, changed record 17758 from NaN to 0.340 11-Mar-2011: Q/C flagging criteria applied for column(s) Salinity, 'flags' field updated ('dataflag') 11-Mar-2011: replaced 4 missing values in column Sigma_t with estimated values based on 1D interpolation of Sigma_t as a function of Date using the MATLAB 8 function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option, excluding data gaps with more than 10 consecutive missing values, and flagging the estimated values as 'E' ('interp_missing') 11-Mar-2011: 4 values in 'Sigma_t' were updated with new values ('update_data'): changed record 17755 from NaN to 0.021, changed record 17756 from NaN to -0.004, changed record 17757 from NaN to -0.028, changed record 17758 from NaN to -0.055 11-Mar-2011: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated ('dataflag') 11-Mar-2011: manually edited data set metadata ('ui_editmetadata') 11-Mar-2011: documented flagged and missing values in columns Temperature, Conductivity, Pressure, Depth, Salinity and Sigma_t as data set anomalies in the metadata ('add_anomalies') 11-Mar-2011: manually edited data set metadata ('ui_editmetadata') 11-Mar-2011: query 'Year == 2010' run, returned 17520 of 21491 data rows ('querydata') 11-Mar-2011: automatically assigned study date metadata descriptors based on the range of date values in date/time columns (add_studydates) 11-Mar-2011: updated title ('newtitle') 11-Mar-2011: updated 2 metadata fields in the Dataset, Status sections ('newtitle') 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') 13-Feb-2015: copied QA/QC flags for column(s) Depth to column(s) Pressure, overwriting any existing flags, and set QA/QC criteria for destination column(s) to 'manual' ('copyflags') 27-Feb-2015: copied QA/QC flags for column(s) Depth to column(s) Pressure, overwriting any existing flags, and set QA/QC criteria for destination column(s) to 'manual' ('copyflags') 03-Jun-2015: query 'Year=2010' run, returned 17520 of 17520 data rows ('querydata') 03-Jun-2015: copied QA/QC flags from column(s) Conductivity and Temperature to column(s) Salinity and Sigma_t, merging copied flags with any existing flags, and set QA/QC criteria for destination column(s) to 'manual' ('copyflags') 03-Jun-2015: imported all documentation metadata from the template 'GCE_Sonde_GCE2', retaining existing attribute descriptors for all columns ('meta_template') 03-Jun-2015: updated 40 metadata fields in the Data, Dataset, Project, Site, Status, Study, Supplement sections ('addmeta') 03-Jun-2015: updated title ('newtitle') 03-Jun-2015: added geographic metadata based on matching values in column Station to location and station names registered in 'geo_locations.mat' ('add_sitemetadata') 03-Jun-2015: updated 8 metadata fields in the Site sections ('addmeta') 03-Jun-2015: updated title ('newtitle') 03-Jun-2015: updated 1 metadata fields in the Dataset sections ('addmeta') 03-Jun-2015: deleted columns Calibration and Pump from the structure ('deletecols') 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="I", Depth<0.15="Q", flag_valuechange(x,2,2,1,3)="Q", manual) column 14. Conductivity column 15. QA/QC flags for Conductivity (flagging criteria, where "x" is Conductivity: x<0="I", Depth<=0="I", Depth<0.15="Q", flag_valuechange(x,0.75,0.75,1,3)="Q", 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="I", x<0.05="X", 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="I", x<0.05="X", x>10="Q", manual) column 20. Salinity column 21. QA/QC flags for Salinity (flagging criteria, where "x" is Salinity: x<0="I", Depth<=0="I", Depth<0.15="Q", flag_valuechange(x,5,5,1,3)="Q", x>36="Q", 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: Depth<=0="I", Depth<0.15="Q", flag_valuechange(x,5,5,1,3)="Q", x<-5="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: E = unspecified Flag_Conductivity: E = unspecified Flag_Pressure: E = unspecified Flag_Depth: E = unspecified Flag_Salinity: E = unspecified Flag_Sigma_t: E = unspecified, Q = questionable value c. Numeric Range: column 1. 7 to 7 column 2. (none) column 3. -81.4755 to -81.4755 column 4. 31.3384 to 31.3384 column 5. 1793 to 3746 column 6. (none) column 7. 2010 to 2010 column 8. 1 to 12 column 9. 1 to 31 column 10. 0 to 23 column 11. 0 to 30 column 12. 3.5998 to 33.419 column 13. (none) column 14. 0.00412 to 0.76616 column 15. (none) column 16. 0.587 to 3.658 column 17. (none) column 18. 0.58294 to 3.6327 column 19. (none) column 20. 0.028235 to 3.6953 column 21. (none) column 22. -5.3598 to 0.13848 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="I";col_Depth<0.15="Q";flag_valuechange(x,2,2,1,3)="Q";man ually-assigned flags column 13. none column 14. x<0="I";col_Depth<=0="I";col_Depth<0.15="Q";flag_valuechange(x,0.75,0.75,1,3)="Q";manual ly-assigned flags column 15. none column 16. x<0="I";x<0.05="X";x>10="Q";manually-assigned flags column 17. none column 18. x<0="I";x<0.05="X";x>10="Q";manually-assigned flags column 19. none column 20. x<0="I";col_Depth<=0="I";col_Depth<0.15="Q";flag_valuechange(x,5,5,1,3)="Q";x>36="Q";man ually-assigned flags column 21. none column 22. col_Depth<=0="I";col_Depth<0.15="Q";flag_valuechange(x,5,5,1,3)="Q";x<-5="Q";x>28="Q";ma nually-assigned flags column 23. none C. Data Anomalies: Note that the sonde was removed from the protective tubing by parties unknown on 25-Mar-2010 and reinstalled in the tubing on 01-Apr-2010, resulting in a minor shift in deployment depth, but data collectiong continued normally so no values were flagged during this period. Converted values in column(s) Conductivity, Salinity and Sigma_t assigned QA/QC flag(s) Q (questionable value) or I (invalid value (out of range)) to NaN/empty: Conductivity record(s) 4321, 4322, 4323, 4324, 4325, 4326, 4327, 4328, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4343, 4344, 4345, 4346, 4347, 4348, 4349, 4350, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365 and 4366, Salinity record(s) 4321, 4322, 4323, 4324, 4325, 4326, 4327, 4328, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4343, 4344, 4345, 4346, 4347, 4348, 4349, 4350, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365 and 4366, Sigma_t record(s) 4321, 4322, 4323, 4324, 4325, 4326, 4327, 4328, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4343, 4344, 4345, 4346, 4347, 4348, 4349, 4350, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365 and 4366. Values of 27 records in Temperature were flagged as E (data value estimated by interpolation) for dates: 03/03/2010, 04/15/2010, 05/19/2010, 06/16/2010, 07/13/2010, 09/02/2010, 12/08/2010. Values of 73 records in Conductivity were flagged as E (data value estimated by interpolation) for dates: 03/03/2010-03/04/2010, 04/15/2010, 05/19/2010, 06/16/2010, 07/13/2010, 09/02/2010, 12/08/2010. Values of 27 records in Pressure were flagged as E (data value estimated by interpolation) for dates: 03/03/2010, 04/15/2010, 05/19/2010, 06/16/2010, 07/13/2010, 09/02/2010, 12/08/2010. Values of 27 records in Depth were flagged as E (data value estimated by interpolation) for dates: 03/03/2010, 04/15/2010, 05/19/2010, 06/16/2010, 07/13/2010, 09/02/2010, 12/08/2010. Values of 73 records in Salinity were flagged as E (data value estimated by interpolation) for dates: 03/03/2010-03/04/2010, 04/15/2010, 05/19/2010, 06/16/2010, 07/13/2010, 09/02/2010, 12/08/2010. Values of 73 records in Sigma_t were flagged as E (data value estimated by interpolation) for dates: 03/03/2010-03/04/2010, 04/15/2010, 05/19/2010, 06/16/2010, 07/13/2010, 09/02/2010, 12/08/2010. Values of 519 records in Sigma_t were flagged as Q (questionable value) for dates: 07/21/2010, 07/21/2010-07/22/2010, 07/22/2010-07/23/2010, 07/23/2010-07/24/2010, 07/24/2010-07/25/2010, 07/25/2010-07/26/2010, 07/26/2010-07/27/2010, 07/27/2010-07/28/2010, 07/28/2010-07/29/2010, 07/29/2010-07/30/2010, 07/30/2010-08/01/2010, 08/01/2010-08/02/2010, 08/02/2010-08/03/2010, 08/03/2010-08/04/2010, 08/04/2010-08/05/2010, 08/05/2010-08/06/2010, 08/06/2010-08/07/2010, 08/21/2010, 08/22/2010. V. Supplemental Descriptors A. Data Acquisition 1. Data Forms: Copies of CTD cast logs and raw data are maintained at the Georgia Coastal Ecosystems Information Management Office 2. Form Location: GCE-LTER Information Management Office, Dept. of Marine Sciences, University of Georgia, Athens, GA 30602 3. Data Entry Validation: not specified B. Quality Assurance/Quality Control Procedures: QA/QC flags are generated automatically according to domain criteria specified for each data column, then subsequently reviewed and revised as appropriate. Coded flag columns are generated for each data column, listing qualifier flags assigned to the data value on the corresponding row. C. Supplemental Materials: not applicable D. Computer Programs: Sea-Bird Electronics Sea-Soft version 4.246, MATLAB version 2013B E. Archival Practices: Data sets and documentation are stored in structured binary (Matlab 5.x files) and delimited ASCII text formats, and archived on magnetic tape and CD at the GCE LTER Information Management Office at the University of Georgia, Athens, Georgia, USA F. Publications: G. History of Data Set Usage 1. Data Request History: 2. Data Set Update History: 3. Review History: Instrument deployment, maintenance and retrieval observations: Sonde# 3342 Site# 7 Set up by J. Shalack Date 12/3/09 Time on 2200 GMT Date 12/3/09 Time into water 1942 Date 3/3/10 Time out of water 1935 Date 3/3/10 Time off 2105 Sample interval 1800 Deployment information Date 12/3/09 Time 1942 sal 0 temp 15.5 water depth na Retrieval information Date 3/3/10 Time 1935 ysi sal 0.0 ysi temp 10.5 water depth na Instrument condition sensor tube very clean Upload filename 07100342 Maintenance record Date 12/22/09 Time 1453 Sal 0.0 Temp 9.7 Depth 4.5m Condition - sensor tube clean Date 1/7/10 Time 1801 Sal 0.0 Temp 6.0 Depth 5.1m Condition- sensor tube na Date 1/28/10 Time 1636 Sal 0.1 Temp 11.6 Depth na Condition-sensor tube clean Date 2/8/10 Time 2139 Sal 0.0 Temp 8.7 Depth 4.1 m Condition- sensor tube very clean Instrument deployment, maintenance and retrieval observations: Sonde# 2413 Site# 7 Set up by J. Shalack Date 3/3/10 Time on 2200 GMT Date 3/3/10 Time into water 1935 Date 5/19/10 Time out of water 1244 Date 5/19/10 Time off 1620 Sample interval 1800 Deployment information Date 3/3/10 Time 1935 ysi sal 0.0 ysi temp 10.5 water depth na Retrieval information Date 5/19/10 Time 1244 sal 0 temp 26 water depth 3.3 m Instrument condition sensor tube very clean Upload filename 07100513 Maintenance record Date 3/15/10 Time 2118 Sal 0.2 Temp 14.7 Depth 3.4m Condition - sensor tube very clean Date 4/1/10 Time 2113 Sal 0.1 Temp 19.6 Depth 3.8m Condition- sensor tube very clean NOTE: Sonde was not in the pvc tube Date 4/15/10 Time 2223 Sal 0.2 Temp 21.7 Depth 3.3m Condition-sensor tube very clean Date 5/5/10 Time 1507 Sal 0.1 Temp 24.3 Depth na Condition- sensor tube very clean Instrument deployment, maintenance and retrieval observations: Sonde# 3746 Site# 7 Set up by J. Shalack Date 5/19/10 Time on 1800 UTC Date 5/19/10 Time into water 1244 Date 9/2/10 Time out of water 1437 Date 9/2/10 Time off 1620 Sample interval 1800 Deployment information Date 5/19/10 Time 1244 ysi sal 0 ysi temp 26 water depth 3.3m Retrieval information Date 9/2/10 Time 1437 ysi sal 0.1 ysi temp 27.8 water depth 3.6m Instrument condition sensor tube clean Upload filename 07100846 Maintenance record Date 6/4/10 Time 1431 Sal 0.1 Temp 27.0 Depth 3.0m Condition - sensor tube clean Date 6/15/10 Time 2357 Sal 0.1 Temp 30.1 Depth 2.7 m Condition- sensor tube clean Date 6/30/10 Time 1255 Sal 0.1 Temp 29.7 Depth 4.0m Condition-sensor tube very clean Date NA: check cruise log July 13-15, 2010 Time Sal Temp Depth m Condition- sensor tube Date 7/29/10 Time 1302 Sal 0.1 Temp 31.7 Depth 5.0m Condition- sensor tube very clean Date 8/12/10 Time 1843 Sal 0.3 Temp 31.5 Depth 4.5 Condition- sensor tube very clean Instrument deployment, maintenance and retrieval observations: Sonde#1794 Site# 7 Set up by J. Shalack Date 9/2/10 Time on 1800 UTC Date 9/2/10 Time into water 1437 Date 12/8/10 Time out of water 1846 Date 12/8/10 Time off 2050 Sample interval 1800 Deployment information Date 9/2/10 Time 1437 ysi sal 0.1 ysi temp 27.8 water depth 3.6m Retrieval information Date 12/8/10 Time 1846 ysi sal 0.4 ysi temp 10.4 water depth na Instrument condition- conductivity tube very clean Upload filename 07101294 Maintenance record Date 9/16/10 Time 1655 Sal 0.1 Temp 29.0 Depth na Condition - conductivity tube clean Date 9/29/10 Time 1443 Sal 0.2 Temp 27.1 Depth 4.5 m Condition- conductivity tube clean Date 10/18/10 Time 1839 Sal 0.1 Temp 23.1 Depth 4.1m Condition- conductivity tube clean Date 11/8/10 Time 2043 Sal 0.2 Temp 15.7 Depth 3.6 m Condition- conductivity tube clean Date 11/20/10 Time 1720 Sal 0.7 Temp 16.4 Depth 3.5m Condition- conductivity tube very clean Instrument deployment, maintenance and retrieval observations: Sonde# 1793 Site# 7 Set up by J. Shalack Date 12/8/10 Time on 2100 UTC Date 12/8/10 Time into water 1846 Date 2/24/11 Time out of water 1523 Date 2/24/11 Time off 1802 Sample interval 1800 Deployment information Date 12/8/10 Time 1846 ysi sal 0.4 ysi temp 10.4 water depth na Retrieval information Date 2/24/11 Time 1523 ysi sal 0.1 ysi temp 15.1 water depth 3.7 m Instrument condition- conductivity tube clean Upload filename 07110293 Maintenance record Date 12/20/10 Time 1902 Sal 0.1 Temp 8.4 Depth 3.2 m Condition - conductivity tube very clean Date 1/11/11 Time 1708 Sal 0.1 Temp 8.0 Depth na Condition- conductivity tube very clean Date 2/3/11 Time 1740 Sal 0.1 Temp 12.3 Depth 3.6 m Condition- conductivity tube very clean 4. Questions and Comments from Users: none