I. Data Set Descriptors
A. Title: Daniela Di Iorio. 2023. Continuous salinity, temperature and depth measurements from
moored hydrographic data loggers deployed at GCE1_Hydro (Sapelo River near Eulonia, Georgia)
from 01-Jan-2022 through 31-Dec-2022. Georgia Coastal Ecosystems LTER Data Catalog (data set
PHY-GCEM-2311a; /data/PHY-GCEM-2311a)
B. Accession Number: PHY-GCEM-2311a
C. Description
1. Originator(s):
Name: Daniela Di Iorio
Address: Dept. of Marine Sciences
University of Georgia
Athens, Georgia 30602-3636
Country: USA
Email: daniela@uga.edu
2. Abstract: Conductivity, temperature and pressure were measured continuously at Georgia
Coastal Ecosystems LTER sampling location GCE1_Hydro (Sapelo River near Eulonia, Georgia)
from 01-Jan-2022 through 31-Dec-2022. Observations were logged at 30 minute intervals by
moored Sea-Bird Electronics MicroCAT 37-SM data loggers and downloaded approximately
quarterly. 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: Other Site Research
6. Georeferences: geographic coordinates as data columns
7. Submission Date: Mar 03, 2023
D. Keywords: conductivity, density, depth, GCE, Georgia, Georgia Coastal Ecosystems,
Hydrographic Moorings, hydrography, Inorganic Fluxes, inorganic nutrients, LTER, monitoring,
mooring, pressure, salinity, Sapelo Island, sonde, temperature, USA, water column, water
quality
II. Research Origin Descriptors
A. Overall Project Description
1. Project Title: Georgia Coastal Ecosystems LTER - IV
2. Principal Investigators:
Name: Merryl Alber
Address: Dept. of Marine Sciences
University of Georgia
Athens, Georgia 30602-3636
Country: USA
Email: malber@uga.edu
3. Funding Period: Feb 01, 2019 to Jan 31, 2025
4. Objectives: The GCE-LTER project has four goals. 1) Track environmental and human drivers
that can cause perturbations in our focal ecosystems. This will be accomplished this
through continuing long-term measurements of climate, water chemistry, oceanic exchange,
and human activities on the landscape. 2) Describe temporal and spatial variability in
physical, chemical, geological and biological characteristics of the study system (coastal
wetland complexes) and how they respond to external drivers. This will be accomplished
through field monitoring in combination with remote sensing and modeling. 3) Characterize
the ecological responses of intertidal marshes to disturbance. This will be accomplished
by ongoing monitoring and experimental work to evaluate system responses to major
perturbations in three key marsh habitats (changes in inundation and predator exclusion in
Spartina-dominated salt marshes; increases in salinity in fresh marshes; changes in runoff
in high marshes), by implementing standardized experimental disturbances along salinity
and elevation gradients, and by tracking responses to natural disturbances. 4) Evaluate
ecosystem properties at the landscape level (habitat distribution, net and gross primary
production, C budgets) and assess the cumulative effects of disturbance on these
properties. The project will also develop relationships between drivers and response
variables, which can be used to predict the effects of future changes. This will be
accomplished through a combination of data synthesis, remote sensing and modeling.
5. Abstract: The Georgia Coastal Ecosystems (GCE) Long Term Ecological Research (LTER)
program, based at the University of Georgia Marine Institute on Sapelo Island, Georgia,
was established in 2000 to study long-term change in coastal ecosystems. Estuaries (places
where salt water from the ocean mixes with fresh water from the land) and their adjacent
marshes provide food and refuge for fish, shellfish and birds; protect the shoreline from
storms; help to keep the water clean; and store carbon. The GCE LTER researchers study
marshes and estuaries to understand how these ecosystems function, to track how they
change over time, and to predict how they might be affected by future changes in climate
and human activities. They accomplish this by tracking the major factors that can cause
long-term change in coastal areas (e.g. sea level, rainfall, upstream development), and
measuring the effects of these factors on the study site. They also conduct focused
studies to assess how key marsh habitats will respond to major changes expected in the
future, including large-scale experiments to evaluate the effects of a) increases in the
salinity of the water that floods freshwater marshes (mimicking drought and/or sea level
rise), b) changes in water runoff from land into the upland marsh border (mimicking
drought or upland development), and c) exclusion of larger organisms in the salt marsh
(mimicking long-term declines in predators). During this award they will initiate
additional studies to systematically evaluate how coastal wetlands respond to
disturbances. Disturbances, or disruptions in the environment, are particularly important
to understand in the context of long-term background changes such as increasing sea level,
and GCE researchers are working to assess the cumulative effects of multiple disturbances
on the landscape. The GCE education and outreach program works to share an understanding
of coastal ecosystems with teachers and students, coastal managers, citizen scientist and
the general public.
6. Funding Source: NSF OCE 1832178
B. Sub-project Description
1. Site Description
a. Geographic Location:
GCE-SP -- Sapelo River, Georgia, USA
GCE1_Hydro -- Eulonia hydrographic datalogger deployment
Coordinates:
GCE-SP --
NW: 081 25 55.13 W, 31 33 34.66 N
NE: 081 09 14.84 W, 31 33 34.66 N
SE: 081 09 14.84 W, 31 30 59.89 N
SW: 081 25 55.13 W, 31 30 59.89 N
GCE1_Hydro -- 81 25 26.3 W, 31 32 14.9 N
b. Physiographic Region:
GCE-SP -- Estuary and tidal marsh
GCE1_Hydro -- Estuary and tidal marsh
c. Landform Components:
GCE-SP -- Intertidal marsh bordering sounds, tidal channels and creeks
GCE1_Hydro -- Intertidal marsh bordering sounds, tidal channels and creeks
d. Hydrographic Characteristics:
GCE-SP -- Site includes the Sapelo River and Sapelo Sound, and is subject to 2-3.4m
semi-diurnal tides. Sapelo Sound is a lagunal estuary system, with minimal
freshwater stream or river input.
GCE1_Hydro -- Site includes the Sapelo River and Sapelo Sound, and is subject to 2-3.4m
semi-diurnal tides. Sapelo Sound is a lagunal estuary system, with minimal
freshwater stream or river input.
e. Topographic Attributes:
GCE-SP -- Flat, with elevations ranging from 0-3.4m above mean low tide
GCE1_Hydro -- Flat, with elevations ranging from 0-3.4m above mean low tide
f. Geology, Lithology and Soils:
GCE-SP -- unspecified
GCE1_Hydro -- unspecified
g. Vegetation Communities:
GCE-SP -- unspecified
GCE1_Hydro -- unspecified
h. History of Land Use and Disturbance: none recorded
i. Climate: Climate summary for Sapelo Island, Georgia, based on NWS data from 1980-2010:
Daily-aggregated Values: Mean (sample standard deviation)
mean air temperature: 20.09°C (7.28°C)
minimum air temperature: 15.02°C (7.96°C)
maximum air temperature: 24.82°C (6.98°C)
total precipitation: 3.26mm (10.3mm)
Yearly-aggregated Daily Values: Mean (sample standard deviation)
total precipitation (1980-2010): 1124mm (266mm)
2. Experimental or Sampling Design
a. Design Characteristics: Conductivity, temperature and pressure were continuously
monitored using an autonomous data-logging sensor package (sonde) that was moored to a
piling and submerged 1-1.5m below mean low water.
b. Permanent Plots: none
c. Data Collection Duration and Frequency: The MicroCAT was programmed to autonomously
measure and log conductivity, temperature and pressure at a sampling rate of 30 minutes
(based on its internal chronometer). Upon retrieval the data was downloaded from the
instrument via RS-232 serial communications and processed using custom Matlab(r)
procedures to calculate depth (i.e. from pressure and latitude), salinity and sigma-t
(i.e. from conductivity and temperature), and date and time components from sample time
stamps.
Beginning of Observations: Jan 01, 2022
End of Observations: Dec 31, 2022
3. Research Methods
a. Field and Laboratory Methods:
Method 1: Deployment -- The MicroCAT was mounted inside a protective PVC pipe enclosure
and attached to a wooden piling (~12 inch diameter) that was driven firmly into the
substrate. The enclosure was constructed from a 10-foot length of 6-inch (internal
diameter) PVC pipe that was perforated all over by drilling 1.5-inch holes (at
approximately 4-inch spacing); this permits proper water circulation within the
enclosure. The bottom of the PVC pipe was submerged about 5 feet below the water
surface at low tide and bolted (vertically) to the piling. The MicroCAT was deployed
by lowering it into the enclosure on a 0.375-inch stainless steel cable, and bolting
the cable to the piling, so that the bottom of the data logger was ~3 inches above
the bottom of the PVC pipe. A weighted surveyor's tape was then used to measure the
distance from the substrate to the pressure sensor on the MicroCAT for calculation
of total water column depth from pressure readings. The mooring was inspected every
1-3 weeks, and any visible fouling of the enclosure or MicroCAT was removed with a
brush or scaper.
Method 2: Retrieval and Calibration -- At the end of each measurement period
(approximately 2 months), the MicroCAT was unshackled from the cable and returned to
the laboratory. The stored data was uploaded to a computer using a RS-232 serial
cable and Sea-Bird Electronics SEATERM software. The MicroCAT was then cleaned to
remove encrusting material and calibrated with a reference instrument at 4 to 5
salinity levels, generally ranging from 30 to 5 PSU.
Method 3: Data Processing -- Data were processed after each retrieval using custom
programs in the GCE Data Toolbox for MATLAB (parse_37sm and imp_gcesonde). Depth was
calculated from recorded pressure and latitude values, and salinity and sigma-t were
calculated from recorded conductivity and temperature values using standard UNESCO
algorithms (reference: Unesco. 1983. Algorithms for computation of fundamental
properties of seawater, 1983. Unesco Technical Papers in Marine Science No. 44, 53
pp.). Data were then plotted and visually inspected for evidence of biofouling of
the conductivity sensor (i.e. prolonged periods of damped tidal oscillation in
conductivity signal with no corresponding changes in temperature signal and no wind
or rainfall events recorded at nearby monitoring stations, or periods of damped
oscillation immediately followed by normal oscillation after instrument maintenance
or replacement). Conductivity values recorded during periods of suspected biofouling
were flagged as I (invalid) if visible fouling was noted in maintenance logs, and Q
(questionable) if no visible fouling was noted.
Method 4: Daily Aggregation -- The finalized 30-minute resolution data set was filtered
to remove any remaining invalid values (i.e. assigned qualifier flags of 'I' =
invalid value or 'X' = excise row), then padded with empty rows to produce a
monotonic time series data set with even time steps. The data records were then
aggregated (grouped) by Year, Month, Day, Site, Longitude and Latitude, and relevant
summary statistics were calculated for each measured variable in each group and
added as data columns. Quality control rules were defined for each calculated column
to flag statistics based on days with more than 35% missing values as invalid, and
more than 10% missing values or 35% flagged values as questionable. Columns listing
the number and percentage of missing and flagged values in the original data set for
each day were also added as data columns for reference by quality control rules.
Following aggregation, summary statistics flagged as invalid were removed from the
daily-aggregated data set and converted to missing (NaN).
b. Protocols:
Method 1: none
Method 2: none
Method 3: none
Method 4: none
c. Instrumentation:
Method 1:
SBE MicroCAT 37-SM (S/N 1790)
Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT)
Last Calibration: May 14, 2021
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: Aug 01, 2020
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 2398, with pump)
Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT)
Last Calibration: Aug 04, 2020
Parameter: Conductivity (Accuracy: 0.0003 S/m, Readability: 0.00001 S/m, Range: 0
to 7 S/m)
Protocol: Prior to each timed measurement the conductivity cell is opened and
water is pumped for 0.5 sec, then conductivity is measured using an
ultra-precision Wien-Bridge oscillator with frequency counted by a
high-stability reference crystal (<2 ppm/year drift rate). The cell is closed
between measurements and tributyl tin antifoulant is released into the tubing.
Parameter: Pressure (water) (Accuracy: 0.2m, Readability: 0.0004m, Range: 0 to
20m)
Protocol: Pressure is measured using a micro-machined silicon diaphragm with
embedded strain elements, and temperature compensation is performed by the SBE
MicroCAT onboard cpu.
Parameter: Temperature (water) (Accuracy: 0.002°C, Readability: 0.0001°C, Range:
-5 to 35°C)
Protocol: Temperature is measured by applying an AC excitation to a
hermetically-sealed VISHAY reference resistor and an ultra-stable aged
thermistor (drift rate typically less than 0.002°C/year).
SBE MicroCAT 37-SM (S/N 9960)
Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT)
Last Calibration: Aug 02, 2019
Parameter: Conductivity (Accuracy: 0.0003 S/m, Readability: 0.00001 S/m, Range: 0
to 7 S/m)
Protocol: Water passively circulates through an open internal-field conductivity
cell equipped with an external tributyl tin antifoulant dispenser, and
conductivity is measured using an ultra-precision Wien-Bridge oscillator with
frequency counted by a high-stability reference crystal (<2 ppm/year drift
rate).
Parameter: Pressure (water) (Accuracy: 0.2m, Readability: 0.0004m, Range: 0 to
20m)
Protocol: Pressure is measured using a micro-machined silicon diaphragm with
embedded strain elements, and temperature compensation is performed by the SBE
MicroCAT onboard cpu.
Parameter: Temperature (water) (Accuracy: 0.002°C, Readability: 0.0001°C, Range:
-5 to 35°C)
Protocol: Temperature is measured by applying an AC excitation to a
hermetically-sealed VISHAY reference resistor and an ultra-stable aged
thermistor (drift rate typically less than 0.002°C/year).
Method 2: none
Method 3: none
Method 4: none
d. Taxonomy and Systematics:
Method 1:
Method 2:
Method 3:
Method 4:
e. Speclies List:
f. Permit History:
Method 1: none
Method 2: none
Method 3: none
Method 4: none
4. Project Personnel
a. Personnel:
1: Daniela Di Iorio
2: Wade M. Sheldon, Jr.
3: Adam Sapp
4: John Thomas Williams
5: Jonah Michael Rigdon
6: Laura Price Hollander
b. Affiliations:
1: University of Georgia, Athens, Georgia
2: University of Georgia, Athens, Georgia
3: University of Georgia, Athens, Georgia
4: University of Georgia Marine Institute, Sapelo Island, GA
5: University of Georgia Marine Institute
6: University of Georgia, Sapelo Island, Georgia
III. Data Set Status and Accessibility
A. Status
1. Latest Update: 03-Mar-2024
2. Latest Archive Date: 03-Mar-2024
3. Latest Metadata Update: 03-Mar-2024
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: Adam Sapp
Address: Department of Marine Sciences
University of Georgia
Athens, Georgia 30602
Country: USA
Email: asapp@uga.edu
3. Copyright Restrictions: not copyrighted
4. Restrictions: This information is licensed under a Creative Commons Attribution 4.0
International License (see: https://creativecommons.org/licenses/by/4.0/). The consumer of
these data ("Data User" herein) has an ethical obligation to cite it appropriately in any
publication that results from its use. The Data User should realize that these data may be
actively used by others for ongoing research and that coordination may be necessary to
prevent duplicate publication. The Data User is urged to contact the authors of these data
if any questions about methodology or results occur. Where appropriate, the Data User is
encouraged to consider collaboration or co-authorship with the authors. The Data User
should realize that misinterpretation of data may occur if used out of context of the
original study. While substantial efforts are made to ensure the accuracy of data and
associated documentation, complete accuracy of data sets cannot be guaranteed. All data
are made available "as is." The Data User should be aware, however, that data are updated
periodically and it is the responsibility of the Data User to check for new versions of
the data. The data authors and the repository where these data were obtained shall not be
liable for damages resulting from any use or misinterpretation of the data.
a. Release Date: Affiliates: Mar 03, 2023, Public: Mar 03, 2024
b. Citation: Data provided by the Georgia Coastal Ecosystems Long Term Ecological Research
Project, supported by funds from NSF OCE 1832178 (data set PHY-GCEM-2311a)
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-2311a_Daily_1_0.CSV
2. Size: 365 records
3. File Format: ASCII text (comma-separated value format)
3a. Delimiters: single comma
4. Header Information: 5 lines of ASCII text
5. Alphanumeric Attributes: none
6. Quality Control Flag Codes: Q = questionable value, I = invalid value (out of range), S =
spike/noise, X = excise row flag, E = data value estimated by interpolation
7. Authentication Procedures: not specified
8. Calculations:
Depth(m) = sw_dpth(Pressure(dbar),Latitude(deg)) -- sw_dpth (salt water depth from
pressure) Matlab function, Revision: 1.3, Date: 10-Oct-1994 (C)1992 CSIRO, Phil Morgan
(morgan@ml.csiro.au)
[Salinity(psu),Sigma_t] = salsig2(Depth(m),Temperature(C),Conductivity(mmho/cm)) --
salsig2 (salinity and sigma-t from conductivity, temperature and depth) Matlab function
Revision 06-May-1992 by V. Holliday, as modified by Tom Gross and Julie Amft
(julie@skio.peachnet.edu)
9. Processing History:
Software version: GCE Data Toolbox Version 3.9.10 (23-May-2022)
Data structure version: GCE Data Structure 1.1 (29-Mar-2001)
Original data files processed:
01220390.asc (5722 records)
01220673.cnv (4661 records)
012209698.cnv (4329 records)
01230157.cnv (5711 records)
01230361.asc (3372 records)
Data processing history:
21-Mar-2022: data uploaded from SBE 37-SM MicroCAT using SEATERM software version 1.59
04-Apr-2022: new GCE Data Structure 1.1 created ('newstruct')
04-Apr-2022: data imported from processed SBE SM-37 sonde data file '01220390.asc'
(5722 records) ('imp_gcesonde')
04-Apr-2022: deleted column Second from the structure ('deletecols')
04-Apr-2022: calculated calendar date in MATLAB serial day (base 1/1/0000) format from
individual date component columns Year, Month, Day, Hour and Minute, added 'Date'
column at position 1 ('add_datecol')
04-Apr-2022: added column 'Instrument' at position 1 ('addcol')
04-Apr-2022: added column 'Pump' at position 2 ('addcol')
04-Apr-2022: Q/C flagging criteria applied for column(s) Pump, 'flags' field updated
('dataflag')
04-Apr-2022: added column 'Latitude' at position 1 ('addcol')
04-Apr-2022: Q/C flagging criteria applied for column(s) Latitude, 'flags' field
updated ('dataflag')
04-Apr-2022: added column 'Longitude' at position 1 ('addcol')
04-Apr-2022: Q/C flagging criteria applied for column(s) Longitude, 'flags' field
updated ('dataflag')
04-Apr-2022: added column 'Site' at position 1 ('addcol')
04-Apr-2022: matched 5722 out of 5722 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)
04-Apr-2022: added column 'Station' at position 2 ('addcol')
04-Apr-2022: Q/C flagging criteria applied for column(s) Station, 'flags' field updated
('dataflag')
04-Apr-2022: added geographic metadata based on matching values in column Station to
location and station names registered in 'geo_locations.mat' ('add_sitemetadata')
04-Apr-2022: updated 8 metadata fields in the Site sections ('addmeta')
04-Apr-2022: added column 'Calibration' at position 19 ('addcol')
04-Apr-2022: Q/C flagging criteria applied for column(s) Calibration, 'flags' field
updated ('dataflag')
04-Apr-2022: updated 13 metadata fields in the Data, Dataset, Status, Study, Supplement
sections ('addmeta')
04-Apr-2022: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
04-Apr-2022: edited structure data ('ui_datagrid'): deleted record(s) 1, 2, 3, 4, 5715,
5716, 5717, 5718, 5719, 5720, 5721 and 5722
04-Apr-2022: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
04-Apr-2022: query 'Year==2022' run, returned 3634 of 5710 data rows ('querydata')
04-Apr-2022: automatically assigned study date metadata descriptors based on the range
of date values in date/time columns (add_studydates)
04-Apr-2022: manually edited data set metadata ('ui_editmetadata')
04-Apr-2022: edited data set title in structure and metadata ('ui_editor')
13-Oct-2022: 4654 rows added at the bottom of the data set from 'Data from Sea-Bird
Electronics 37-SM MicroCAT sonde S/N 24073 deployed at GCE1_Hydro (Eulonia
hydrographic datalogger deployment) from 17-Mar-2022 to 22-Jun-2022' ('datamerge')
13-Oct-2022: updated 12 metadata fields in the Data, Dataset, Status, Study, Supplement
sections ('addmeta')
13-Oct-2022: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
13-Oct-2022: 4321 rows added at the bottom of the data set from 'Data from Sea-Bird
Electronics 37-SM MicroCAT sonde S/N 16698 deployed at GCE1_Hydro (Eulonia
hydrographic datalogger deployment) from 22-Jun-2022 to 20-Sep-2022' ('datamerge')
13-Oct-2022: updated 12 metadata fields in the Data, Dataset, Status, Study, Supplement
sections ('addmeta')
13-Oct-2022: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
13-Oct-2022: manually edited data set metadata ('ui_editmetadata')
13-Oct-2022: edited data set title in structure and metadata ('ui_editor')
13-Oct-2022: 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')
13-Oct-2022: sorted by column Date(ascending) ('sortdata')
13-Oct-2022: 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')
13-Oct-2022: updated 1 metadata fields in the Data sections ('addmeta')
13-Oct-2022: sorted by columns Site(ascending), Station(ascending),
Longitude(ascending), Latitude(ascending), Date(ascending) ('sortdata')
13-Oct-2022: sorted by columns Site(ascending), Station(ascending),
Longitude(ascending), Latitude(ascending) ('sortdata')
13-Oct-2022: replaced 2 missing values in column Temperature with estimated values
based on 1D interpolation of Temperature as a function of Date using the MATLAB 9.5
function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method
option, excluding data gaps with more than 12 consecutive missing values, and
flagging the estimated values as 'E'' ('interp_missing')
13-Oct-2022: 2 values in 'Temperature' were updated with new values ('update_data'):
changed record 3635 from NaN to 19.106, changed record 8290 from NaN to 29.269
13-Oct-2022: Q/C flagging criteria applied for column(s) Temperature, 'flags' field
updated ('dataflag')
13-Oct-2022: replaced 2 missing values in column Conductivity with estimated values
based on 1D interpolation of Conductivity as a function of Date using the MATLAB 9.5
function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method
option, excluding data gaps with more than 12 consecutive missing values, and
flagging the estimated values as 'E'' ('interp_missing')
13-Oct-2022: 2 values in 'Conductivity' were updated with new values ('update_data'):
changed record 3635 from NaN to 2.926, changed record 8290 from NaN to 4.212
13-Oct-2022: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field
updated ('dataflag')
13-Oct-2022: replaced 2 missing values in column Pressure with estimated values based
on 1D interpolation of Pressure as a function of Date using the MATLAB 9.5 function
'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option,
excluding data gaps with more than 12 consecutive missing values, and flagging the
estimated values as 'E'' ('interp_missing')
13-Oct-2022: 2 values in 'Pressure' were updated with new values ('update_data'):
changed record 3635 from NaN to 0.638, changed record 8290 from NaN to 0.704
13-Oct-2022: Q/C flagging criteria applied for column(s) Pressure, 'flags' field
updated ('dataflag')
13-Oct-2022: replaced 2 missing values in column Depth with estimated values based on
1D interpolation of Depth as a function of Date using the MATLAB 9.5 function
'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option,
excluding data gaps with more than 12 consecutive missing values, and flagging the
estimated values as 'E'' ('interp_missing')
13-Oct-2022: 2 values in 'Depth' were updated with new values ('update_data'): changed
record 3635 from NaN to 0.634, changed record 8290 from NaN to 0.699
13-Oct-2022: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated
('dataflag')
13-Oct-2022: replaced 2 missing values in column Salinity with estimated values based
on 1D interpolation of Salinity as a function of Date using the MATLAB 9.5 function
'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option,
excluding data gaps with more than 12 consecutive missing values, and flagging the
estimated values as 'E'' ('interp_missing')
13-Oct-2022: 2 values in 'Salinity' were updated with new values ('update_data'):
changed record 3635 from NaN to 20.683, changed record 8290 from NaN to 24.774
13-Oct-2022: Q/C flagging criteria applied for column(s) Salinity, 'flags' field
updated ('dataflag')
13-Oct-2022: replaced 2 missing values in column Sigma_t with estimated values based on
1D interpolation of Sigma_t as a function of Date using the MATLAB 9.5 function
'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option,
excluding data gaps with more than 12 consecutive missing values, and flagging the
estimated values as 'E'' ('interp_missing')
13-Oct-2022: 2 values in 'Sigma_t' were updated with new values ('update_data'):
changed record 3635 from NaN to 14.092, changed record 8290 from NaN to 14.358
13-Oct-2022: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated
('dataflag')
13-Oct-2022: manually edited data set metadata ('ui_editmetadata')
01-Aug-2023: 5702 rows added at the bottom of the data set from 'Data from Sea-Bird
Electronics 37-SM MicroCAT sonde S/N 24057 deployed at GCE1_Hydro (Eulonia
hydrographic datalogger deployment) from 20-Sep-2022 to 17-Jan-2023' ('datamerge')
01-Aug-2023: updated 12 metadata fields in the Data, Dataset, Status, Study, Supplement
section(s) ('addmeta')
01-Aug-2023: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
01-Aug-2023: 3360 rows added at the bottom of the data set from 'Data from Sea-Bird
Electronics 37-SM MicroCAT sonde S/N 4961 deployed at GCE1_Hydro (Eulonia
hydrographic datalogger deployment) from 17-Jan-2023 to 28-Mar-2023' ('datamerge')
01-Aug-2023: updated 12 metadata fields in the Data, Dataset, Status, Study, Supplement
section(s) ('addmeta')
01-Aug-2023: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
01-Aug-2023: query 'Year==2022' run, returned 17519 of 21673 data rows ('querydata')
01-Aug-2023: automatically assigned study date metadata descriptors based on the range
of date values in date/time columns (add_studydates)
01-Aug-2023: manually edited data set metadata ('ui_editmetadata')
01-Aug-2023: edited data set title in structure and metadata ('ui_editor')
01-Aug-2023: inserted 1 new record 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')
01-Aug-2023: sorted by column Date(ascending) ('sortdata')
01-Aug-2023: 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-Aug-2023: updated 1 metadata fields in the Data section(s) ('addmeta')
01-Aug-2023: sorted by column Date(ascending) ('sortdata')
01-Aug-2023: replaced 1 missing value in column Temperature with an estimated value
based on 1D interpolation of Temperature as a function of Date using the MATLAB 9.5
function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method
option, excluding data gaps with more than 12 consecutive missing values, and
flagging the estimated values as 'E' ('interp_missing')
01-Aug-2023: 1 value in 'Temperature' was updated with a new value ('update_data'):
changed record 12612 from NaN to 26.267
01-Aug-2023: Q/C flagging criteria applied for column(s) Temperature, 'flags' field
updated ('dataflag')
01-Aug-2023: replaced 1 missing value in column Conductivity with an estimated value
based on 1D interpolation of Conductivity as a function of Date using the MATLAB 9.5
function 'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method
option, excluding data gaps with more than 12 consecutive missing values, and
flagging the estimated values as 'E' ('interp_missing')
01-Aug-2023: 1 value in 'Conductivity' was updated with a new value ('update_data'):
changed record 12612 from NaN to 0.235
01-Aug-2023: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field
updated ('dataflag')
01-Aug-2023: replaced 1 missing value in column Pressure with an estimated value based
on 1D interpolation of Pressure as a function of Date using the MATLAB 9.5 function
'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option,
excluding data gaps with more than 12 consecutive missing values, and flagging the
estimated values as 'E' ('interp_missing')
01-Aug-2023: 1 value in 'Pressure' was updated with a new value ('update_data'):
changed record 12612 from NaN to 0.691
01-Aug-2023: Q/C flagging criteria applied for column(s) Pressure, 'flags' field
updated ('dataflag')
01-Aug-2023: replaced 1 missing value in column Depth with an estimated value based on
1D interpolation of Depth as a function of Date using the MATLAB 9.5 function
'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option,
excluding data gaps with more than 12 consecutive missing values, and flagging the
estimated values as 'E' ('interp_missing')
01-Aug-2023: 1 value in 'Depth' was updated with a new value ('update_data'): changed
record 12612 from NaN to 0.686
01-Aug-2023: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated
('dataflag')
01-Aug-2023: replaced 1 missing value in column Salinity with an estimated value based
on 1D interpolation of Salinity as a function of Date using the MATLAB 9.5 function
'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option,
excluding data gaps with more than 12 consecutive missing values, and flagging the
estimated values as 'E' ('interp_missing')
01-Aug-2023: 1 value in 'Salinity' was updated with a new value ('update_data'):
changed record 12612 from NaN to 1.194
01-Aug-2023: Q/C flagging criteria applied for column(s) Salinity, 'flags' field
updated ('dataflag')
01-Aug-2023: replaced 1 missing value in column Sigma_t with an estimated value based
on 1D interpolation of Sigma_t as a function of Date using the MATLAB 9.5 function
'interp1' with the 'pchip' (piecewise cubic Hermite interpolation) method option,
excluding data gaps with more than 12 consecutive missing values, and flagging the
estimated values as 'E' ('interp_missing')
01-Aug-2023: 1 value in 'Sigma_t' was updated with a new value ('update_data'):
changed record 12612 from NaN to -2.399
01-Aug-2023: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated
('dataflag')
24-Aug-2023: sorted by column Instrument(ascending) ('sortdata')
24-Aug-2023: QA/QC flags assigned by visual inspection (ui_visualqc); flags cleared on
193 records in Conductivity
24-Aug-2023: sorted by column Date(ascending) ('sortdata')
24-Aug-2023: sorted by column Instrument(ascending) ('sortdata')
24-Aug-2023: QA/QC flags assigned by visual inspection (ui_visualqc); flags cleared on
2634 records in Salinity
24-Aug-2023: sorted by column Date(ascending) ('sortdata')
24-Aug-2023: sorted by column Instrument(ascending) ('sortdata')
24-Aug-2023: QA/QC flags assigned by visual inspection (ui_visualqc); flags cleared on
2294 records in Sigma_t
24-Aug-2023: sorted by column Date(ascending) ('sortdata')
24-Aug-2023: replaced values matching 'Instrument==16698' in column(s) Conductivity
with NaN ('num_replace')
24-Aug-2023: 4321 values in 'Conductivity' were updated with new values ('update_data')
24-Aug-2023: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field
updated ('dataflag')
24-Aug-2023: replaced values matching 'Instrument==16698' in column(s) Salinity with
NaN ('num_replace')
24-Aug-2023: 4321 values in 'Salinity' were updated with new values ('update_data')
24-Aug-2023: Q/C flagging criteria applied for column(s) Salinity, 'flags' field
updated ('dataflag')
24-Aug-2023: replaced values matching 'Instrument==16698' in column(s) Sigma_t with NaN
('num_replace')
24-Aug-2023: 4321 values in 'Sigma_t' were updated with new values ('update_data')
24-Aug-2023: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated
('dataflag')
24-Aug-2023: sorted by column Date(ascending) ('sortdata')
24-Aug-2023: performed daily statistical aggregation on data columns Temperature,
Conductivity, Pressure, Depth, Salinity and Sigma_t by grouping on columns Site,
Station, Longitude, Latitude, Year, Month and Day (aggr_datetime)
24-Aug-2023: updated title ('newtitle')
24-Aug-2023: updated 1 metadata fields in the Dataset section(s) ('addmeta')
24-Aug-2023: calculated calendar date in MATLAB serial day (base 1/1/0000) format from
individual date component columns Year, Month and Day, added 'Date' column at
position 5 ('add_datecol')
24-Aug-2023: documented flagged values in columns Daily_Min_Conductivity,
Daily_Max_Conductivity, Daily_Mean_Conductivity, Daily_StdDev_Conductivity,
Daily_SE_Conductivity, Daily_Min_Salinity, Daily_Max_Salinity, Daily_Mean_Salinity,
Daily_StdDev_Salinity, Daily_SE_Salinity, Daily_Min_Sigma_t, Daily_Max_Sigma_t,
Daily_Mean_Sigma_t, Daily_StdDev_Sigma_t and Daily_SE_Sigma_t as data set anomalies
in the metadata ('add_anomalies')
03-Mar-2024: updated 1 metadata fields in the Dataset section(s) ('addmeta')
03-Mar-2024: imported Dataset, Project, Site, Study, Status, Supplement metadata
descriptors from the GCE Metabase ('imp_gcemetadata')
03-Mar-2024: updated 57 metadata fields in the Dataset, Project, Site, Status, Study,
Supplement section(s) ('addmeta')
03-Mar-2024: converted dates in column(s) Date to format yyyy-mm-dd HH:MM:SS
03-Mar-2024: flags for columns Daily_Min_Conductivity, Daily_Max_Conductivity,
Daily_Mean_Conductivity, Daily_StdDev_Conductivity, Daily_SE_Conductivity,
Daily_Min_Salinity, Daily_Max_Salinity, Daily_Mean_Salinity, Daily_StdDev_Salinity,
Daily_SE_Salinity, Daily_Min_Sigma_t, Daily_Max_Sigma_t, Daily_Mean_Sigma_t,
Daily_StdDev_Sigma_t and Daily_SE_Sigma_t converted to data columns, flag codes
updated in metadata ('flags2cols')
03-Mar-2024: updated 6 metadata fields in the Data section(s) ('addmeta')
03-Mar-2024: updated 15 metadata fields in the Status, Data sections to reflect
attribute metadata ('updatecols')
03-Mar-2024: parsed and formatted metadata ('listmeta')
B. Variable Information
1. Variable Name:
column 1. Site
column 2. Station
column 3. Longitude
column 4. Latitude
column 5. Date
column 6. Year
column 7. Month
column 8. Day
column 9. Missing_Temperature
column 10. Percent_Missing_Temperature
column 11. Flagged_Temperature
column 12. Percent_Flagged_Temperature
column 13. Daily_Num_Temperature
column 14. Daily_Min_Temperature
column 15. Daily_Max_Temperature
column 16. Daily_Mean_Temperature
column 17. Daily_StdDev_Temperature
column 18. Daily_SE_Temperature
column 19. Missing_Conductivity
column 20. Percent_Missing_Conductivity
column 21. Flagged_Conductivity
column 22. Percent_Flagged_Conductivity
column 23. Daily_Num_Conductivity
column 24. Daily_Min_Conductivity
column 25. Flag_Daily_Min_Conductivity
column 26. Daily_Max_Conductivity
column 27. Flag_Daily_Max_Conductivity
column 28. Daily_Mean_Conductivity
column 29. Flag_Daily_Mean_Conductivity
column 30. Daily_StdDev_Conductivity
column 31. Flag_Daily_StdDev_Conductivity
column 32. Daily_SE_Conductivity
column 33. Flag_Daily_SE_Conductivity
column 34. Missing_Pressure
column 35. Percent_Missing_Pressure
column 36. Flagged_Pressure
column 37. Percent_Flagged_Pressure
column 38. Daily_Num_Pressure
column 39. Daily_Min_Pressure
column 40. Daily_Max_Pressure
column 41. Daily_Mean_Pressure
column 42. Daily_StdDev_Pressure
column 43. Daily_SE_Pressure
column 44. Missing_Depth
column 45. Percent_Missing_Depth
column 46. Flagged_Depth
column 47. Percent_Flagged_Depth
column 48. Daily_Num_Depth
column 49. Daily_Min_Depth
column 50. Daily_Max_Depth
column 51. Daily_Mean_Depth
column 52. Daily_StdDev_Depth
column 53. Daily_SE_Depth
column 54. Missing_Salinity
column 55. Percent_Missing_Salinity
column 56. Flagged_Salinity
column 57. Percent_Flagged_Salinity
column 58. Daily_Num_Salinity
column 59. Daily_Min_Salinity
column 60. Flag_Daily_Min_Salinity
column 61. Daily_Max_Salinity
column 62. Flag_Daily_Max_Salinity
column 63. Daily_Mean_Salinity
column 64. Flag_Daily_Mean_Salinity
column 65. Daily_StdDev_Salinity
column 66. Flag_Daily_StdDev_Salinity
column 67. Daily_SE_Salinity
column 68. Flag_Daily_SE_Salinity
column 69. Missing_Sigma_t
column 70. Percent_Missing_Sigma_t
column 71. Flagged_Sigma_t
column 72. Percent_Flagged_Sigma_t
column 73. Daily_Num_Sigma_t
column 74. Daily_Min_Sigma_t
column 75. Flag_Daily_Min_Sigma_t
column 76. Daily_Max_Sigma_t
column 77. Flag_Daily_Max_Sigma_t
column 78. Daily_Mean_Sigma_t
column 79. Flag_Daily_Mean_Sigma_t
column 80. Daily_StdDev_Sigma_t
column 81. Flag_Daily_StdDev_Sigma_t
column 82. Daily_SE_Sigma_t
column 83. Flag_Daily_SE_Sigma_t
2. Variable Definition:
column 1. Nearest nominal GCE-LTER sampling site
column 2. Station determined by geographic database lookup of coordinates in columns
Latitude and Longitude using a distance tolerance of 0.5km from registered station
location
column 3. Geographic longitude in decimal degrees
column 4. Geographic latitude in decimal degrees
column 5. Calendar date and time of observation
column 6. Calendar year
column 7. Calendar month
column 8. Calendar day
column 9. Number of missing observations of Water temperature
column 10. Percent missing observations of Water temperature
column 11. Number of QC/QA-flagged observations of Water temperature
column 12. Percent QC/QA-flagged observations of Water temperature
column 13. Daily Observations of Water temperature
column 14. Daily Minimum Water temperature
column 15. Daily Maximum Water temperature
column 16. Daily Mean Water temperature
column 17. Daily Sample Standard Deviation of Water temperature
column 18. Daily Standard Error of Water temperature
column 19. Number of missing observations of Conductivity
column 20. Percent missing observations of Conductivity
column 21. Number of QC/QA-flagged observations of Conductivity
column 22. Percent QC/QA-flagged observations of Conductivity
column 23. Daily Observations of Conductivity
column 24. Daily Minimum Conductivity
column 25. QA/QC flags for Daily Minimum Conductivity (flagging criteria, where "x" is
Daily_Min_Conductivity: Percent_Missing_Conductivity>40="I",
Percent_Missing_Conductivity>10="Q", Percent_Flagged_Conductivity>30="Q")
column 26. Daily Maximum Conductivity
column 27. QA/QC flags for Daily Maximum Conductivity (flagging criteria, where "x" is
Daily_Max_Conductivity: Percent_Missing_Conductivity>40="I",
Percent_Missing_Conductivity>10="Q", Percent_Flagged_Conductivity>30="Q")
column 28. Daily Mean Conductivity
column 29. QA/QC flags for Daily Mean Conductivity (flagging criteria, where "x" is
Daily_Mean_Conductivity: Percent_Missing_Conductivity>40="I",
Percent_Missing_Conductivity>10="Q", Percent_Flagged_Conductivity>30="Q")
column 30. Daily Sample Standard Deviation of Conductivity
column 31. QA/QC flags for Daily Sample Standard Deviation of Conductivity (flagging
criteria, where "x" is Daily_StdDev_Conductivity: Percent_Missing_Conductivity>40="I",
Percent_Missing_Conductivity>10="Q", Percent_Flagged_Conductivity>30="Q")
column 32. Daily Standard Error of Conductivity
column 33. QA/QC flags for Daily Standard Error of Conductivity (flagging criteria, where
"x" is Daily_SE_Conductivity: Percent_Missing_Conductivity>40="I",
Percent_Missing_Conductivity>10="Q", Percent_Flagged_Conductivity>30="Q")
column 34. Number of missing observations of Water pressure at sensor (approximately
equivalent to water depth within 3% error)
column 35. Percent missing observations of Water pressure at sensor (approximately
equivalent to water depth within 3% error)
column 36. Number of QC/QA-flagged observations of Water pressure at sensor (approximately
equivalent to water depth within 3% error)
column 37. Percent QC/QA-flagged observations of Water pressure at sensor (approximately
equivalent to water depth within 3% error)
column 38. Daily Observations of Water pressure at sensor (approximately equivalent to
water depth within 3% error)
column 39. Daily Minimum Water pressure at sensor (approximately equivalent to water depth
within 3% error)
column 40. Daily Maximum Water pressure at sensor (approximately equivalent to water depth
within 3% error)
column 41. Daily Mean Water pressure at sensor (approximately equivalent to water depth
within 3% error)
column 42. Daily Sample Standard Deviation of Water pressure at sensor (approximately
equivalent to water depth within 3% error)
column 43. Daily Standard Error of Water pressure at sensor (approximately equivalent to
water depth within 3% error)
column 44. Number of missing observations of Water depth to the pressure sensor of the
moored sonde
column 45. Percent missing observations of Water depth to the pressure sensor of the
moored sonde
column 46. Number of QC/QA-flagged observations of Water depth to the pressure sensor of
the moored sonde
column 47. Percent QC/QA-flagged observations of Water depth to the pressure sensor of the
moored sonde
column 48. Daily Observations of Water depth to the pressure sensor of the moored sonde
column 49. Daily Minimum Water depth to the pressure sensor of the moored sonde
column 50. Daily Maximum Water depth to the pressure sensor of the moored sonde
column 51. Daily Mean Water depth to the pressure sensor of the moored sonde
column 52. Daily Sample Standard Deviation of Water depth to the pressure sensor of the
moored sonde
column 53. Daily Standard Error of Water depth to the pressure sensor of the moored sonde
column 54. Number of missing observations of Salinity
column 55. Percent missing observations of Salinity
column 56. Number of QC/QA-flagged observations of Salinity
column 57. Percent QC/QA-flagged observations of Salinity
column 58. Daily Observations of Salinity
column 59. Daily Minimum Salinity
column 60. QA/QC flags for Daily Minimum Salinity (flagging criteria, where "x" is
Daily_Min_Salinity: Percent_Missing_Salinity>40="I", Percent_Missing_Salinity>10="Q",
Percent_Flagged_Salinity>30="Q")
column 61. Daily Maximum Salinity
column 62. QA/QC flags for Daily Maximum Salinity (flagging criteria, where "x" is
Daily_Max_Salinity: Percent_Missing_Salinity>40="I", Percent_Missing_Salinity>10="Q",
Percent_Flagged_Salinity>30="Q")
column 63. Daily Mean Salinity
column 64. QA/QC flags for Daily Mean Salinity (flagging criteria, where "x" is
Daily_Mean_Salinity: Percent_Missing_Salinity>40="I", Percent_Missing_Salinity>10="Q",
Percent_Flagged_Salinity>30="Q")
column 65. Daily Sample Standard Deviation of Salinity
column 66. QA/QC flags for Daily Sample Standard Deviation of Salinity (flagging criteria,
where "x" is Daily_StdDev_Salinity: Percent_Missing_Salinity>40="I",
Percent_Missing_Salinity>10="Q", Percent_Flagged_Salinity>30="Q")
column 67. Daily Standard Error of Salinity
column 68. QA/QC flags for Daily Standard Error of Salinity (flagging criteria, where "x"
is Daily_SE_Salinity: Percent_Missing_Salinity>40="I", Percent_Missing_Salinity>10="Q",
Percent_Flagged_Salinity>30="Q")
column 69. Number of missing observations of Sigma-t (i.e. Density-1)
column 70. Percent missing observations of Sigma-t (i.e. Density-1)
column 71. Number of QC/QA-flagged observations of Sigma-t (i.e. Density-1)
column 72. Percent QC/QA-flagged observations of Sigma-t (i.e. Density-1)
column 73. Daily Observations of Sigma-t (i.e. Density-1)
column 74. Daily Minimum Sigma-t (i.e. Density-1)
column 75. QA/QC flags for Daily Minimum Sigma-t (i.e. Density-1) (flagging criteria,
where "x" is Daily_Min_Sigma_t: Percent_Missing_Sigma_t>40="I",
Percent_Missing_Sigma_t>10="Q", Percent_Flagged_Sigma_t>30="Q")
column 76. Daily Maximum Sigma-t (i.e. Density-1)
column 77. QA/QC flags for Daily Maximum Sigma-t (i.e. Density-1) (flagging criteria,
where "x" is Daily_Max_Sigma_t: Percent_Missing_Sigma_t>40="I",
Percent_Missing_Sigma_t>10="Q", Percent_Flagged_Sigma_t>30="Q")
column 78. Daily Mean Sigma-t (i.e. Density-1)
column 79. QA/QC flags for Daily Mean Sigma-t (i.e. Density-1) (flagging criteria, where
"x" is Daily_Mean_Sigma_t: Percent_Missing_Sigma_t>40="I",
Percent_Missing_Sigma_t>10="Q", Percent_Flagged_Sigma_t>30="Q")
column 80. Daily Sample Standard Deviation of Sigma-t (i.e. Density-1)
column 81. QA/QC flags for Daily Sample Standard Deviation of Sigma-t (i.e. Density-1)
(flagging criteria, where "x" is Daily_StdDev_Sigma_t: Percent_Missing_Sigma_t>40="I",
Percent_Missing_Sigma_t>10="Q", Percent_Flagged_Sigma_t>30="Q")
column 82. Daily Standard Error of Sigma-t (i.e. Density-1)
column 83. QA/QC flags for Daily Standard Error of Sigma-t (i.e. Density-1) (flagging
criteria, where "x" is Daily_SE_Sigma_t: Percent_Missing_Sigma_t>40="I",
Percent_Missing_Sigma_t>10="Q", Percent_Flagged_Sigma_t>30="Q")
3. Units of Measurement:
column 1. none
column 2. none
column 3. degrees
column 4. degrees
column 5. yyyy-mm-dd HH:MM:SS
column 6. YYYY
column 7. MM
column 8. DD
column 9. count
column 10. %
column 11. count
column 12. %
column 13. count
column 14. °C
column 15. °C
column 16. °C
column 17. °C
column 18. °C
column 19. count
column 20. %
column 21. count
column 22. %
column 23. count
column 24. S/m
column 25. none
column 26. S/m
column 27. none
column 28. S/m
column 29. none
column 30. S/m
column 31. none
column 32. S/m
column 33. none
column 34. count
column 35. %
column 36. count
column 37. %
column 38. count
column 39. dbar
column 40. dbar
column 41. dbar
column 42. dbar
column 43. dbar
column 44. count
column 45. %
column 46. count
column 47. %
column 48. count
column 49. m
column 50. m
column 51. m
column 52. m
column 53. m
column 54. count
column 55. %
column 56. count
column 57. %
column 58. count
column 59. PSU
column 60. none
column 61. PSU
column 62. none
column 63. PSU
column 64. none
column 65. PSU
column 66. none
column 67. PSU
column 68. none
column 69. count
column 70. %
column 71. count
column 72. %
column 73. count
column 74. kg/m^3
column 75. none
column 76. kg/m^3
column 77. none
column 78. kg/m^3
column 79. none
column 80. kg/m^3
column 81. none
column 82. kg/m^3
column 83. none
4. Data Type
a. Storage Type:
column 1. integer
column 2. string
column 3. floating-point
column 4. floating-point
column 5. string
column 6. integer
column 7. integer
column 8. integer
column 9. integer
column 10. floating-point
column 11. integer
column 12. floating-point
column 13. integer
column 14. floating-point
column 15. floating-point
column 16. floating-point
column 17. floating-point
column 18. floating-point
column 19. integer
column 20. floating-point
column 21. integer
column 22. floating-point
column 23. integer
column 24. floating-point
column 25. string
column 26. floating-point
column 27. string
column 28. floating-point
column 29. string
column 30. floating-point
column 31. string
column 32. floating-point
column 33. string
column 34. integer
column 35. floating-point
column 36. integer
column 37. floating-point
column 38. integer
column 39. floating-point
column 40. floating-point
column 41. floating-point
column 42. floating-point
column 43. floating-point
column 44. integer
column 45. floating-point
column 46. integer
column 47. floating-point
column 48. integer
column 49. floating-point
column 50. floating-point
column 51. floating-point
column 52. floating-point
column 53. floating-point
column 54. integer
column 55. floating-point
column 56. integer
column 57. floating-point
column 58. integer
column 59. floating-point
column 60. string
column 61. floating-point
column 62. string
column 63. floating-point
column 64. string
column 65. floating-point
column 66. string
column 67. floating-point
column 68. string
column 69. integer
column 70. floating-point
column 71. integer
column 72. floating-point
column 73. integer
column 74. floating-point
column 75. string
column 76. floating-point
column 77. string
column 78. floating-point
column 79. string
column 80. floating-point
column 81. string
column 82. floating-point
column 83. string
b. Variable Codes:
Flag_Daily_Min_Conductivity: I = invalid value (out of range), Q = questionable value
Flag_Daily_Max_Conductivity: I = invalid value (out of range), Q = questionable value
Flag_Daily_Mean_Conductivity: I = invalid value (out of range), Q = questionable value
Flag_Daily_StdDev_Conductivity: I = invalid value (out of range), Q = questionable value
Flag_Daily_SE_Conductivity: I = invalid value (out of range), Q = questionable value
Flag_Daily_Min_Salinity: I = invalid value (out of range), Q = questionable value
Flag_Daily_Max_Salinity: I = invalid value (out of range), Q = questionable value
Flag_Daily_Mean_Salinity: I = invalid value (out of range), Q = questionable value
Flag_Daily_StdDev_Salinity: I = invalid value (out of range), Q = questionable value
Flag_Daily_SE_Salinity: I = invalid value (out of range), Q = questionable value
Flag_Daily_Min_Sigma_t: I = invalid value (out of range), Q = questionable value
Flag_Daily_Max_Sigma_t: I = invalid value (out of range), Q = questionable value
Flag_Daily_Mean_Sigma_t: I = invalid value (out of range), Q = questionable value
Flag_Daily_StdDev_Sigma_t: I = invalid value (out of range), Q = questionable value
Flag_Daily_SE_Sigma_t: I = invalid value (out of range), Q = questionable value
c. Numeric Range:
column 1. 1 to 1
column 2. (none)
column 3. -81.424 to -81.424
column 4. 31.5375 to 31.5375
column 5. (none)
column 6. 2022 to 2022
column 7. 1 to 12
column 8. 1 to 31
column 9. 0 to 0
column 10. 0 to 0
column 11. 0 to 1
column 12. 0 to 2.0408
column 13. 48 to 48
column 14. 3.2066 to 30.7527
column 15. 6.3309 to 34.5213
column 16. 4.965 to 32.0764
column 17. 0.14752 to 1.928
column 18. 0.021292 to 0.27829
column 19. 0 to 48
column 20. 0 to 100
column 21. 0 to 3
column 22. 0 to 7.1429
column 23. 0 to 48
column 24. 0.030586 to 3.8483
column 25. (none)
column 26. 0.1518 to 4.378
column 27. (none)
column 28. 0.064974 to 4.1914
column 29. (none)
column 30. 0.036952 to 1.0196
column 31. (none)
column 32. 0.0053336 to 0.14716
column 33. (none)
column 34. 0 to 0
column 35. 0 to 0
column 36. 0 to 1
column 37. 0 to 2.0408
column 38. 48 to 48
column 39. 0.383 to 0.812
column 40. 0.566 to 0.892
column 41. 0.52135 to 0.84373
column 42. 0.0095505 to 0.090309
column 43. 0.0013785 to 0.013035
column 44. 0 to 0
column 45. 0 to 0
column 46. 0 to 1
column 47. 0 to 2.0408
column 48. 48 to 48
column 49. 0.38035 to 0.80637
column 50. 0.56208 to 0.88582
column 51. 0.51774 to 0.83788
column 52. 0.0094843 to 0.089683
column 53. 0.0013689 to 0.012945
column 54. 0 to 48
column 55. 0 to 100
column 56. 0 to 1
column 57. 0 to 7.1429
column 58. 0 to 48
column 59. 0.17376 to 27.0088
column 60. (none)
column 61. 0.88569 to 29.9954
column 62. (none)
column 63. 0.37126 to 28.7673
column 64. (none)
column 65. 0.21575 to 6.8738
column 66. (none)
column 67. 0.031141 to 0.99215
column 68. (none)
column 69. 0 to 48
column 70. 0 to 100
column 71. 0 to 1
column 72. 0 to 7.1429
column 73. 0 to 48
column 74. -3.3344 to 18.7171
column 75. (none)
column 76. -2.108 to 22.6403
column 77. (none)
column 78. -2.8595 to 21.0789
column 79. (none)
column 80. 0.20404 to 5.2826
column 81. (none)
column 82. 0.02945 to 0.76248
column 83. (none)
d. Missing Value Code:
5. Data Format
a. Column Type:
column 1. numerical
column 2. text
column 3. numerical
column 4. numerical
column 5. text
column 6. numerical
column 7. numerical
column 8. numerical
column 9. numerical
column 10. numerical
column 11. numerical
column 12. numerical
column 13. numerical
column 14. numerical
column 15. numerical
column 16. numerical
column 17. numerical
column 18. numerical
column 19. numerical
column 20. numerical
column 21. numerical
column 22. numerical
column 23. numerical
column 24. numerical
column 25. text
column 26. numerical
column 27. text
column 28. numerical
column 29. text
column 30. numerical
column 31. text
column 32. numerical
column 33. text
column 34. numerical
column 35. numerical
column 36. numerical
column 37. numerical
column 38. numerical
column 39. numerical
column 40. numerical
column 41. numerical
column 42. numerical
column 43. numerical
column 44. numerical
column 45. numerical
column 46. numerical
column 47. numerical
column 48. numerical
column 49. numerical
column 50. numerical
column 51. numerical
column 52. numerical
column 53. numerical
column 54. numerical
column 55. numerical
column 56. numerical
column 57. numerical
column 58. numerical
column 59. numerical
column 60. text
column 61. numerical
column 62. text
column 63. numerical
column 64. text
column 65. numerical
column 66. text
column 67. numerical
column 68. text
column 69. numerical
column 70. numerical
column 71. numerical
column 72. numerical
column 73. numerical
column 74. numerical
column 75. text
column 76. numerical
column 77. text
column 78. numerical
column 79. text
column 80. numerical
column 81. text
column 82. numerical
column 83. text
b. Number of Columns: 83
c. Decimal Places:
column 1. 0
column 2. 0
column 3. 6
column 4. 6
column 5. 0
column 6. 0
column 7. 0
column 8. 0
column 9. 0
column 10. 2
column 11. 0
column 12. 2
column 13. 0
column 14. 3
column 15. 3
column 16. 4
column 17. 4
column 18. 5
column 19. 0
column 20. 2
column 21. 0
column 22. 2
column 23. 0
column 24. 3
column 25. 0
column 26. 3
column 27. 0
column 28. 4
column 29. 0
column 30. 4
column 31. 0
column 32. 5
column 33. 0
column 34. 0
column 35. 2
column 36. 0
column 37. 2
column 38. 0
column 39. 3
column 40. 3
column 41. 4
column 42. 4
column 43. 5
column 44. 0
column 45. 2
column 46. 0
column 47. 2
column 48. 0
column 49. 3
column 50. 3
column 51. 4
column 52. 4
column 53. 5
column 54. 0
column 55. 2
column 56. 0
column 57. 2
column 58. 0
column 59. 3
column 60. 0
column 61. 3
column 62. 0
column 63. 4
column 64. 0
column 65. 4
column 66. 0
column 67. 5
column 68. 0
column 69. 0
column 70. 2
column 71. 0
column 72. 2
column 73. 0
column 74. 3
column 75. 0
column 76. 3
column 77. 0
column 78. 4
column 79. 0
column 80. 4
column 81. 0
column 82. 5
column 83. 0
6. Logical Variable Type:
column 1. nominal (discrete)
column 2. nominal (none)
column 3. geographic coordinate (continuous)
column 4. geographic coordinate (continuous)
column 5. datetime (none)
column 6. datetime (discrete)
column 7. datetime (discrete)
column 8. datetime (discrete)
column 9. calculation (discrete)
column 10. calculation (continuous)
column 11. calculation (discrete)
column 12. calculation (continuous)
column 13. calculation (discrete)
column 14. calculation (continuous)
column 15. calculation (continuous)
column 16. calculation (continuous)
column 17. calculation (continuous)
column 18. calculation (continuous)
column 19. calculation (discrete)
column 20. calculation (continuous)
column 21. calculation (discrete)
column 22. calculation (continuous)
column 23. calculation (discrete)
column 24. calculation (continuous)
column 25. coded value (none)
column 26. calculation (continuous)
column 27. coded value (none)
column 28. calculation (continuous)
column 29. coded value (none)
column 30. calculation (continuous)
column 31. coded value (none)
column 32. calculation (continuous)
column 33. coded value (none)
column 34. calculation (discrete)
column 35. calculation (continuous)
column 36. calculation (discrete)
column 37. calculation (continuous)
column 38. calculation (discrete)
column 39. calculation (continuous)
column 40. calculation (continuous)
column 41. calculation (continuous)
column 42. calculation (continuous)
column 43. calculation (continuous)
column 44. calculation (discrete)
column 45. calculation (continuous)
column 46. calculation (discrete)
column 47. calculation (continuous)
column 48. calculation (discrete)
column 49. calculation (continuous)
column 50. calculation (continuous)
column 51. calculation (continuous)
column 52. calculation (continuous)
column 53. calculation (continuous)
column 54. calculation (discrete)
column 55. calculation (continuous)
column 56. calculation (discrete)
column 57. calculation (continuous)
column 58. calculation (discrete)
column 59. calculation (continuous)
column 60. coded value (none)
column 61. calculation (continuous)
column 62. coded value (none)
column 63. calculation (continuous)
column 64. coded value (none)
column 65. calculation (continuous)
column 66. coded value (none)
column 67. calculation (continuous)
column 68. coded value (none)
column 69. calculation (discrete)
column 70. calculation (continuous)
column 71. calculation (discrete)
column 72. calculation (continuous)
column 73. calculation (discrete)
column 74. calculation (continuous)
column 75. coded value (none)
column 76. calculation (continuous)
column 77. coded value (none)
column 78. calculation (continuous)
column 79. coded value (none)
column 80. calculation (continuous)
column 81. coded value (none)
column 82. calculation (continuous)
column 83. coded value (none)
7. Flagging Criteria:
column 1. none
column 2. none
column 3. none
column 4. none
column 5. none
column 6. none
column 7. none
column 8. none
column 9. none
column 10. none
column 11. none
column 12. none
column 13. none
column 14.
col_Percent_Missing_Temperature>40="I";col_Percent_Missing_Temperature>10="Q";col_Percen
t_Flagged_Temperature>30="Q"
column 15.
col_Percent_Missing_Temperature>40="I";col_Percent_Missing_Temperature>10="Q";col_Percen
t_Flagged_Temperature>30="Q"
column 16.
col_Percent_Missing_Temperature>40="I";col_Percent_Missing_Temperature>10="Q";col_Percen
t_Flagged_Temperature>30="Q"
column 17.
col_Percent_Missing_Temperature>40="I";col_Percent_Missing_Temperature>10="Q";col_Percen
t_Flagged_Temperature>30="Q"
column 18.
col_Percent_Missing_Temperature>40="I";col_Percent_Missing_Temperature>10="Q";col_Percen
t_Flagged_Temperature>30="Q"
column 19. none
column 20. none
column 21. none
column 22. none
column 23. none
column 24.
col_Percent_Missing_Conductivity>40="I";col_Percent_Missing_Conductivity>10="Q";col_Perc
ent_Flagged_Conductivity>30="Q"
column 25. none
column 26.
col_Percent_Missing_Conductivity>40="I";col_Percent_Missing_Conductivity>10="Q";col_Perc
ent_Flagged_Conductivity>30="Q"
column 27. none
column 28.
col_Percent_Missing_Conductivity>40="I";col_Percent_Missing_Conductivity>10="Q";col_Perc
ent_Flagged_Conductivity>30="Q"
column 29. none
column 30.
col_Percent_Missing_Conductivity>40="I";col_Percent_Missing_Conductivity>10="Q";col_Perc
ent_Flagged_Conductivity>30="Q"
column 31. none
column 32.
col_Percent_Missing_Conductivity>40="I";col_Percent_Missing_Conductivity>10="Q";col_Perc
ent_Flagged_Conductivity>30="Q"
column 33. none
column 34. none
column 35. none
column 36. none
column 37. none
column 38. none
column 39.
col_Percent_Missing_Pressure>40="I";col_Percent_Missing_Pressure>10="Q";col_Percent_Flag
ged_Pressure>30="Q"
column 40.
col_Percent_Missing_Pressure>40="I";col_Percent_Missing_Pressure>10="Q";col_Percent_Flag
ged_Pressure>30="Q"
column 41.
col_Percent_Missing_Pressure>40="I";col_Percent_Missing_Pressure>10="Q";col_Percent_Flag
ged_Pressure>30="Q"
column 42.
col_Percent_Missing_Pressure>40="I";col_Percent_Missing_Pressure>10="Q";col_Percent_Flag
ged_Pressure>30="Q"
column 43.
col_Percent_Missing_Pressure>40="I";col_Percent_Missing_Pressure>10="Q";col_Percent_Flag
ged_Pressure>30="Q"
column 44. none
column 45. none
column 46. none
column 47. none
column 48. none
column 49.
col_Percent_Missing_Depth>40="I";col_Percent_Missing_Depth>10="Q";col_Percent_Flagged_De
pth>30="Q"
column 50.
col_Percent_Missing_Depth>40="I";col_Percent_Missing_Depth>10="Q";col_Percent_Flagged_De
pth>30="Q"
column 51.
col_Percent_Missing_Depth>40="I";col_Percent_Missing_Depth>10="Q";col_Percent_Flagged_De
pth>30="Q"
column 52.
col_Percent_Missing_Depth>40="I";col_Percent_Missing_Depth>10="Q";col_Percent_Flagged_De
pth>30="Q"
column 53.
col_Percent_Missing_Depth>40="I";col_Percent_Missing_Depth>10="Q";col_Percent_Flagged_De
pth>30="Q"
column 54. none
column 55. none
column 56. none
column 57. none
column 58. none
column 59.
col_Percent_Missing_Salinity>40="I";col_Percent_Missing_Salinity>10="Q";col_Percent_Flag
ged_Salinity>30="Q"
column 60. none
column 61.
col_Percent_Missing_Salinity>40="I";col_Percent_Missing_Salinity>10="Q";col_Percent_Flag
ged_Salinity>30="Q"
column 62. none
column 63.
col_Percent_Missing_Salinity>40="I";col_Percent_Missing_Salinity>10="Q";col_Percent_Flag
ged_Salinity>30="Q"
column 64. none
column 65.
col_Percent_Missing_Salinity>40="I";col_Percent_Missing_Salinity>10="Q";col_Percent_Flag
ged_Salinity>30="Q"
column 66. none
column 67.
col_Percent_Missing_Salinity>40="I";col_Percent_Missing_Salinity>10="Q";col_Percent_Flag
ged_Salinity>30="Q"
column 68. none
column 69. none
column 70. none
column 71. none
column 72. none
column 73. none
column 74.
col_Percent_Missing_Sigma_t>40="I";col_Percent_Missing_Sigma_t>10="Q";col_Percent_Flagge
d_Sigma_t>30="Q"
column 75. none
column 76.
col_Percent_Missing_Sigma_t>40="I";col_Percent_Missing_Sigma_t>10="Q";col_Percent_Flagge
d_Sigma_t>30="Q"
column 77. none
column 78.
col_Percent_Missing_Sigma_t>40="I";col_Percent_Missing_Sigma_t>10="Q";col_Percent_Flagge
d_Sigma_t>30="Q"
column 79. none
column 80.
col_Percent_Missing_Sigma_t>40="I";col_Percent_Missing_Sigma_t>10="Q";col_Percent_Flagge
d_Sigma_t>30="Q"
column 81. none
column 82.
col_Percent_Missing_Sigma_t>40="I";col_Percent_Missing_Sigma_t>10="Q";col_Percent_Flagge
d_Sigma_t>30="Q"
column 83. none
C. Data Anomalies: Values of 90 records in Daily_Min_Conductivity were flagged as I (invalid
value (out of range)). The value of one record in Daily_Min_Conductivity was flagged as Q
(questionable value). Values of 90 records in Daily_Max_Conductivity were flagged as I
(invalid value (out of range)). The value of one record in Daily_Max_Conductivity was flagged
as Q (questionable value). Values of 90 records in Daily_Mean_Conductivity were flagged as I
(invalid value (out of range)). The value of one record in Daily_Mean_Conductivity was
flagged as Q (questionable value). Values of 90 records in Daily_StdDev_Conductivity were
flagged as I (invalid value (out of range)). The value of one record in
Daily_StdDev_Conductivity was flagged as Q (questionable value). Values of 90 records in
Daily_SE_Conductivity were flagged as I (invalid value (out of range)). The value of one
record in Daily_SE_Conductivity was flagged as Q (questionable value). Values of 90 records
in Daily_Min_Salinity were flagged as I (invalid value (out of range)). The value of one
record in Daily_Min_Salinity was flagged as Q (questionable value). Values of 90 records in
Daily_Max_Salinity were flagged as I (invalid value (out of range)). The value of one record
in Daily_Max_Salinity was flagged as Q (questionable value). Values of 90 records in
Daily_Mean_Salinity were flagged as I (invalid value (out of range)). The value of one record
in Daily_Mean_Salinity was flagged as Q (questionable value). Values of 90 records in
Daily_StdDev_Salinity were flagged as I (invalid value (out of range)). The value of one
record in Daily_StdDev_Salinity was flagged as Q (questionable value). Values of 90 records
in Daily_SE_Salinity were flagged as I (invalid value (out of range)). The value of one
record in Daily_SE_Salinity was flagged as Q (questionable value). Values of 90 records in
Daily_Min_Sigma_t were flagged as I (invalid value (out of range)). The value of one record
in Daily_Min_Sigma_t was flagged as Q (questionable value). Values of 90 records in
Daily_Max_Sigma_t were flagged as I (invalid value (out of range)). The value of one record
in Daily_Max_Sigma_t was flagged as Q (questionable value). Values of 90 records in
Daily_Mean_Sigma_t were flagged as I (invalid value (out of range)). The value of one record
in Daily_Mean_Sigma_t was flagged as Q (questionable value). Values of 90 records in
Daily_StdDev_Sigma_t were flagged as I (invalid value (out of range)). The value of one
record in Daily_StdDev_Sigma_t was flagged as Q (questionable value). Values of 90 records in
Daily_SE_Sigma_t were flagged as I (invalid value (out of range)). The value of one record in
Daily_SE_Sigma_t was flagged as Q (questionable value).
V. Supplemental Descriptors
A. Data Acquisition
1. Data Forms: Copies of CTD cast logs and raw data are maintained at the Georgia Coastal
Ecosystems Information Management Office
2. Form Location: GCE-LTER Information Management Office, Dept. of Marine Sciences,
University of Georgia, Athens, GA 30602
3. Data Entry Validation:
B. Quality Assurance/Quality Control Procedures: QA/QC flags are generated automatically
according to domain criteria specified for each data column, then subsequently reviewed and
revised as appropriate. Coded flag columns are generated for each data column, listing
qualifier flags assigned to the data value on the corresponding row.
C. Supplemental Materials: not applicable
D. Computer Programs: Sea-Bird Electronics Sea-Soft version 4.246, MATLAB version 2013B
E. Archival Practices: Data sets and documentation are stored in structured binary (Matlab 5.x
files) and delimited ASCII text formats, and archived on magnetic tape and CD at the GCE LTER
Information Management Office at the University of Georgia, Athens, Georgia, USA
F. Publications: not specified
G. History of Data Set Usage
1. Data Request History: not specified
2. Data Set Update History: none
3. Review History: none
4. Questions and Comments from Users: none