I. Data Set Descriptors
A. Title: Daniela Di Iorio. 2008. Daily Summary of Continuous salinity, temperature and depth
measurements from moored hydrographic data loggers deployed at GCE8_Hydro (Altamaha River
near Aligator Creek, Georgia) from 01-Jan-2008 through 31-Dec-2008. Georgia Coastal
Ecosystems LTER Data Catalog (data set PHY-GCEM-0901f;
http://gce-lter.marsci.uga.edu/public/app/dataset_details.asp?accession=PHY-GCEM-0901f)
B. Accession Number: PHY-GCEM-0901f
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 GCE8_Hydro (Altamaha River near Aligator Creek,
Georgia) from 01-Jan-2008 through 31-Dec-2008. 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 columns
7. Submission Date: Jan 01, 2008
D. Keywords: conductivity, daily, density, depth, GCE, GCE8, 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 Project II
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: May 01, 2006 to Nov 01, 2012
4. Objectives: To understand the mechanisms by which variation in the quality, source and
amount of both fresh and salt water create temporal and spatial variability in estuarine
habitats and processes, in order to predict directional changes that will occur in
response to long-term shifts in estuarine salinity patterns
5. Abstract: The Georgia Coastal Ecosystems (GCE) LTER program, located on the central
Georgia coast, was established in 2000. The study domain encompasses three adjacent sounds
(Altamaha, Doboy, Sapelo) and includes upland (mainland, barrier islands, marsh hammocks),
intertidal (fresh, brackish and salt marsh) and submerged (river, estuary, continental
shelf) habitats. Patterns and processes in this complex landscape vary spatially within
and between sites, and temporally on multiple scales (tidal, diurnal, seasonal, and
interannual). Overlain on this spatial and temporal variation are long-term trends caused
by climate change, sea level rise, and human alterations of the landscape. These long-term
trends are likely to manifest in many ways, including changes in water quality, river
discharge, runoff and tidal inundation patterns throughout the estuarine landscape. The
overarching goal of the GCE program is to understand the mechanisms by which variation in
the quality, source and amount of both fresh and salt water create temporal and spatial
variability in estuarine habitats and processes, in order to predict directional changes
that will occur in response to long-term shifts in estuarine salinity patterns. The
objectives of the current funding cycle are 1) to continue to document long-term patterns
of environmental forcing to the coastal zone, 2) to link environmental forcing to observed
spatial and temporal patterns of biogeochemical processes, primary production, community
dynamics, decomposition and disturbance, 3) to investigate the underlying mechanisms by
which environmental gradients along the longitudinal (freshwater-saltwater) and 4) lateral
(upland-subtidal) axes of estuaries drive ecosystem change, and 5) to explore the relative
importance of larval transport and the conditions of the adult environment in determining
community and genetic structure across both the longitudinal and vertical gradients of the
estuary. To meet these objectives, we utilize a suite of approaches including long-term
monitoring of abiotic drivers and ecosystem responses; manipulative and natural
experiments designed to enable us to examine the importance of key ecosystem drivers; and
modeling.
6. Funding Source: NSF OCE 0620959
B. Sub-project Description
1. Site Description
a. Geographic Location:
GCE-AL -- Altamaha River, Georgia, USA
GCE8_Hydro -- Alligator Creek hydrographic datalogger deployment
Coordinates:
GCE-AL --
NW: 081 34 56.32 W, 31 24 05.05 N
NE: 081 14 16.57 W, 31 24 05.05 N
SE: 081 14 16.57 W, 31 17 45.72 N
SW: 081 34 56.32 W, 31 17 45.72 N
GCE8_Hydro -- 81 24 36.2 W, 31 18 37.0 N
b. Physiographic Region:
GCE-AL -- Estuary and tidal marsh
GCE8_Hydro -- Estuary and tidal marsh
c. Landform Components:
GCE-AL -- Intertidal marsh bordering sounds, tidal channels and creeks
GCE8_Hydro -- Intertidal marsh bordering sounds, tidal channels and creeks
d. Hydrographic Characteristics:
GCE-AL -- Site encompasses the Altamaha River estuary and nearby tidal creeks, and is
subject to 2-3.4m semi-diurnal tides. High freshwater input from the Altamaha River,
one of the largest rivers in the Southeastern United States.
GCE8_Hydro -- Site encompasses the Altamaha River estuary and nearby tidal creeks, and
is subject to 2-3.4m semi-diurnal tides. High freshwater input from the Altamaha
River, one of the largest rivers in the Southeastern United States.
e. Topographic Attributes:
GCE-AL -- Flat, with elevations ranging from 0-3.4m above mean low tide
GCE8_Hydro -- Flat, with elevations ranging from 0-3.4m above mean low tide
f. Geology, Lithology and Soils:
GCE-AL -- unspecified
GCE8_Hydro -- unspecified
g. Vegetation Communities:
GCE-AL -- unspecified
GCE8_Hydro -- unspecified
h. History of Land Use and Disturbance: 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, 2008
End of Observations: Dec 31, 2008
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).
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 2539, with pump)
Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT)
Last Calibration: Aug 19, 2002
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 1790)
Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT)
Last Calibration: Mar 31, 2006
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 1793)
Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT)
Last Calibration: Feb 24, 2001
Parameter: Conductivity (Accuracy: 0.0003 S/m, Readability: 0.00001 S/m, Range: 0
to 7 S/m)
Protocol: Water passively circulates through an open internal-field conductivity
cell equipped with an external tributyl tin antifoulant dispenser, and
conductivity is measured using an ultra-precision Wien-Bridge oscillator with
frequency counted by a high-stability reference crystal (<2 ppm/year drift
rate).
Parameter: Pressure (water) (Accuracy: 0.2m, Readability: 0.0004m, Range: 0 to
20m)
Protocol: Pressure is measured using a micro-machined silicon diaphragm with
embedded strain elements, and temperature compensation is performed by the SBE
MicroCAT onboard cpu.
Parameter: Temperature (water) (Accuracy: 0.002°C, Readability: 0.0001°C, Range:
-5 to 35°C)
Protocol: Temperature is measured by applying an AC excitation to a
hermetically-sealed VISHAY reference resistor and an ultra-stable aged
thermistor (drift rate typically less than 0.002°C/year).
SBE MicroCAT 37-SM (S/N 1795)
Manufacturer: Sea-Bird Electronics (Model: 37-SM MicroCAT)
Last Calibration: Oct 08, 2004
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: not applicable
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: Jacob Shalack
4: Daniel F. Saucedo
b. Affiliations:
1: University of Georgia, Athens, Georgia
2: University of Georgia, Athens, Georgia
3: University of Georgia Marine Institute, Sapelo Island, Georgia
4: University of Georgia Marine Institute, Sapelo Island, Georgia
III. Data Set Status and Accessibility
A. Status
1. Latest Update: 29-Sep-2016
2. Latest Archive Date: 29-Sep-2016
3. Latest Metadata Update: 29-Sep-2016
4. Data Verification Status: Reviewed by GCE-LTER IM
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.
Address: Dept. of Marine Sciences
University of Georgia
Athens, Georgia 30602-3636
Country: USA
Email: sheldon@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: Dec 31, 2008, Public: Dec 31, 2009
b. Citation: Data provided by the Georgia Coastal Ecosystems Long Term Ecological Research
Project, supported by funds from NSF OCE 0620959 (data set PHY-GCEM-0901f)
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-0901f_Daily_2_0.CSV
2. Size: 366 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.6b (27-Aug-2016)
Data structure version: GCE Data Structure 1.1 (29-Mar-2001)
Original data files processed:
08080595.asc (2342 records)
08080790.asc (3649 records)
08081193.asc (4654 records)
08090239.asc (5371 records)
Data processing history:
14-May-2008: data uploaded from SBE 37-SM MicroCAT using SEATERM software version 1.50
16-May-2008: new GCE Data Structure 1.1 created ('newstruct')
16-May-2008: data imported from processed SBE SM-37 sonde data file '08080595.asc'
(2342 records) ('imp_gcesonde')
16-May-2008: deleted column Second from the structure ('deletecols')
16-May-2008: calculated serial date from individual date component columns, added
'Date' column at position 1 ('add_datecol')
16-May-2008: added column 'Instrument' at position 1 ('addcol')
16-May-2008: added column 'Pump' at position 2 ('addcol')
16-May-2008: Q/C flagging criteria applied for column(s) Pump, 'flags' field updated
('dataflag')
16-May-2008: added column 'Latitude' at position 1 ('addcol')
16-May-2008: Q/C flagging criteria applied for column(s) Latitude, 'flags' field
updated ('dataflag')
16-May-2008: added column 'Longitude' at position 1 ('addcol')
16-May-2008: Q/C flagging criteria applied for column(s) Longitude, 'flags' field
updated ('dataflag')
16-May-2008: added column 'Site' at position 1 ('addcol')
16-May-2008: added column 'Calibration' at position 18 ('addcol')
16-May-2008: Q/C flagging criteria applied for column(s) Calibration, 'flags' field
updated ('dataflag')
16-May-2008: updated 22 metadata fields in the Data, Dataset, Site, Status, Study,
Supplement sections ('addmeta')
16-May-2008: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
16-May-2008: edited structure data ('ui_datagrid'): deleted record(s) 2336, 2337, 2338,
2339, 2340, 2341 and 2342
16-May-2008: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
16-May-2008: Q/C flagging criteria of column Conductivity edited ('ui_editor')
16-May-2008: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field
updated ('dataflag')
26-Sep-2008: 3646 rows added at the bottom of the data set ('datamerge')
26-Sep-2008: updated 14 metadata fields in the Data, Dataset, Status, Study, Supplement
sections ('addmeta')
26-Sep-2008: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
26-Sep-2008: manually edited data set metadata ('ui_editmetadata')
26-Sep-2008: edited data set title in structure and metadata ('ui_editor')
26-Sep-2008: edited structure data ('ui_datagrid'): inserted blank record at position
1, changed 'Site' row 1 from NaN to 8, changed 'Longitude' row 1 from NaN to
-81.409267, changed 'Latitude' row 1 from NaN to 31.310450, changed 'Date' row 1
from NaN to 733408.000000, changed 'Year' row 1 from NaN to 2008, changed 'Month'
row 1 from NaN to 1, changed 'Day' row 1 from NaN to 1, changed 'Hour' row 1 from
NaN to 0, changed 'Minute' row 1 from NaN to 0
26-Sep-2008: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
26-Sep-2008: edited structure data ('ui_datagrid'): deleted record(s) 1, copied
record(s) 1 to position 5982, changed 'Date' row 5982 from 733494.041667 to
733408.000000, changed 'Month' row 5982 from 3 to 1, changed 'Day' row 5982 from 27
to 1, changed 'Hour' row 5982 from 1 to 0, changed 'Temperature' row 5982 from
16.154 to NaN, changed 'Conductivity' row 5982 from 0.011 to NaN, changed 'Pressure'
row 5982 from 1.897 to NaN, changed 'Depth' row 5982 from 1.884 to NaN, changed
'Salinity' row 5982 from 0.062 to NaN, changed 'Sigma_t' row 5982 from -1.032 to
NaN, changed 'Calibration' row 5982 from 0 to NaN
26-Sep-2008: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
26-Sep-2008: sorted by column Date(ascending) ('sortdata')
26-Sep-2008: inserted 4184 new records with date/time values and NaN/null data values
(replicating common values in the non-data columns Site, Longitude, Latitude,
Instrument, Pump and Calibration) to fill in date/time interval gaps in the data
series ('fill_date_gaps')
26-Sep-2008: sorted by column Date(ascending) ('sortdata')
26-Sep-2008: 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')
26-Sep-2008: manually edited data set metadata ('ui_editmetadata')
26-Sep-2008: edited data set title in structure and metadata ('ui_editor')
26-Sep-2008: documented flagged and missing values in columns Instrument, Temperature,
Conductivity, Pressure, Depth, Salinity, Sigma_t and Calibration as data set
anomalies in the metadata ('add_anomalies')
07-Nov-2008: 4649 rows added at the bottom of the data set ('datamerge')
07-Nov-2008: updated 20 metadata fields in the Data, Dataset, Status, Study, Supplement
sections ('addmeta')
07-Nov-2008: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
07-Nov-2008: automatically assigned study date metadata descriptors based on the range
of date values in date/time columns (add_studydates)
07-Nov-2008: manually edited data set metadata ('ui_editmetadata')
07-Nov-2008: edited data set title in structure and metadata ('ui_editor')
07-Nov-2008: inserted 46 new records with date/time values and NaN/null data values
(replicating common values in the non-data columns Site, Longitude, Latitude,
Instrument, Pump and Calibration) to fill in date/time interval gaps in the data
series ('fill_date_gaps')
07-Nov-2008: sorted by column Date(ascending) ('sortdata')
07-Nov-2008: 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')
07-Nov-2008: manually edited data set metadata ('ui_editmetadata')
07-Nov-2008: documented flagged and missing values in columns Temperature,
Conductivity, Pressure, Depth, Salinity and Sigma_t as data set anomalies in the
metadata ('add_anomalies')
27-Feb-2009: 5369 rows added at the bottom of the data set ('datamerge')
27-Feb-2009: updated 18 metadata fields in the Data, Dataset, Status, Study, Supplement
sections ('addmeta')
27-Feb-2009: Q/C flagging criteria applied, 'flags' field updated ('dataflag')
27-Feb-2009: manually edited data set metadata ('ui_editmetadata')
27-Feb-2009: edited data set title in structure and metadata ('ui_editor')
27-Feb-2009: inserted 17 new records with date/time values and NaN/null data values
(replicating common values in the non-data columns Site, Longitude, Latitude,
Instrument, Pump and Calibration) to fill in date/time interval gaps in the data
series ('fill_date_gaps')
27-Feb-2009: sorted by column Date(ascending) ('sortdata')
27-Feb-2009: 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')
27-Feb-2009: manually edited data set metadata ('ui_editmetadata')
27-Feb-2009: documented flagged and missing values in columns Temperature,
Conductivity, Pressure, Depth, Salinity and Sigma_t as data set anomalies in the
metadata ('add_anomalies')
05-Jun-2009: updated 4 metadata fields in the Dataset, Status, Study sections
('addmeta')
09-Dec-2009: 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: query 'Year == 2008' run, returned 17568 of 20247 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 17568 out of 17568 geographic coordinates in columns Latitude and
Longitude to coordinates for registered locations in the file 'geo_locations.mat'
within a distance tolerance of 0.5km (add_locations)
16-Nov-2011: added column 'Station' at position 2 ('addcol')
16-Nov-2011: Q/C flagging criteria applied for column(s) Station, 'flags' field updated
('dataflag')
16-Nov-2011: added geographic metadata based on matching values in column Station to
location and station names registered in 'geo_locations.mat' ('add_sitemetadata')
16-Nov-2011: updated 9 metadata fields in the Site, Status sections ('add_sitemetadata')
03-Jun-2015: query 'Year=2008' run, returned 17568 of 17568 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 values in all columns assigned QA/QC flag(s) I (invalid value
(out of range)) to NaN/empty: 764 records in Conductivity, 764 records in Salinity,
764 records in Sigma_t ('nullflags')
29-Sep-2016: deleted column Date from the structure ('deletecols')
29-Sep-2016: calculated calendar date in MATLAB serial day (base 1/1/0000) format from
individual date component columns Month, Day, Hour, Minute and Temperature, added
'Date' column at position 6 ('add_datecol')
29-Sep-2016: Revised date/time values that differed from the specified interval of 30
minutes by up to 5 minutes ('adjust_time_interval')
29-Sep-2016: 4246 values in 'Date' were updated with new values ('adjust_time_interval')
29-Sep-2016: Q/C flagging criteria applied for column(s) Date, 'flags' field updated
('dataflag')
29-Sep-2016: 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')
29-Sep-2016: query 'Year=2008' run, returned 17568 of 17568 data rows ('querydata')
29-Sep-2016: 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')
29-Sep-2016: imported all documentation metadata from the template 'GCE_Sonde_GCE2',
retaining existing attribute descriptors for all columns ('meta_template')
29-Sep-2016: updated 40 metadata fields in the Data, Dataset, Project, Site, Status,
Study, Supplement sections ('addmeta')
29-Sep-2016: updated title ('newtitle')
29-Sep-2016: added geographic metadata based on matching values in column Station to
location and station names registered in 'geo_locations.mat' ('add_sitemetadata')
29-Sep-2016: updated 8 metadata fields in the Site sections ('addmeta')
29-Sep-2016: updated title ('newtitle')
29-Sep-2016: updated 1 metadata fields in the Dataset sections ('addmeta')
29-Sep-2016: imported Dataset, Project, Site, Study, Status, Supplement metadata
descriptors from the GCE Metabase ('imp_gcemetadata')
29-Sep-2016: updated 57 metadata fields in the Dataset, Project, Site, Status, Study,
Supplement sections ('addmeta')
29-Sep-2016: sorted by column Date(ascending) ('sortdata')
29-Sep-2016: updated 1 metadata fields in the Data sections ('addmeta')
29-Sep-2016: 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
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')
29-Sep-2016: 2 values in 'Temperature' were updated with new values ('update_data'):
changed record 7478 from NaN to 29.157, changed record 13721 from NaN to 24.414
29-Sep-2016: Q/C flagging criteria applied for column(s) Temperature, 'flags' field
updated ('dataflag')
29-Sep-2016: 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
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')
29-Sep-2016: 2 values in 'Conductivity' were updated with new values ('update_data'):
changed record 7478 from NaN to 1.171, changed record 13721 from NaN to 1.496
29-Sep-2016: Q/C flagging criteria applied for column(s) Conductivity, 'flags' field
updated ('dataflag')
29-Sep-2016: 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 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')
29-Sep-2016: 2 values in 'Pressure' were updated with new values ('update_data'):
changed record 7478 from NaN to 1.368, changed record 13721 from NaN to 2.264
29-Sep-2016: Q/C flagging criteria applied for column(s) Pressure, 'flags' field
updated ('dataflag')
29-Sep-2016: 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 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')
29-Sep-2016: 2 values in 'Depth' were updated with new values ('update_data'): changed
record 7478 from NaN to 1.359, changed record 13721 from NaN to 2.249
29-Sep-2016: Q/C flagging criteria applied for column(s) Depth, 'flags' field updated
('dataflag')
29-Sep-2016: 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 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')
29-Sep-2016: 2 values in 'Salinity' were updated with new values ('update_data'):
changed record 7478 from NaN to 6.110, changed record 13721 from NaN to 8.810
29-Sep-2016: Q/C flagging criteria applied for column(s) Salinity, 'flags' field
updated ('dataflag')
29-Sep-2016: 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 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')
29-Sep-2016: 2 values in 'Sigma_t' were updated with new values ('update_data'):
changed record 7478 from NaN to 0.461, changed record 13721 from NaN to 3.820
29-Sep-2016: Q/C flagging criteria applied for column(s) Sigma_t, 'flags' field updated
('dataflag')
29-Sep-2016: performed daily statistical aggregation on data columns Temperature,
Conductivity, Pressure, Depth, Salinity and Sigma_t by grouping on columns Site,
Longitude, Latitude, Year, Month and Day (aggr_datetime)
29-Sep-2016: updated title ('newtitle')
29-Sep-2016: updated 1 metadata fields in the Dataset sections ('addmeta')
29-Sep-2016: calculated calendar date in MATLAB serial day (base 1/1/0000) format from
individual date component columns Year, Month and Day, added 'Date' column at
position 4 ('add_datecol')
29-Sep-2016: documented flagged and missing values in columns Daily_Min_Temperature,
Daily_Max_Temperature, Daily_Mean_Temperature, Daily_StdDev_Temperature,
Daily_SE_Temperature, Daily_Min_Conductivity, Daily_Max_Conductivity,
Daily_Mean_Conductivity, Daily_StdDev_Conductivity, Daily_SE_Conductivity,
Daily_Min_Pressure, Daily_Max_Pressure, Daily_Mean_Pressure, Daily_StdDev_Pressure,
Daily_SE_Pressure, Daily_Min_Depth, Daily_Max_Depth, Daily_Mean_Depth,
Daily_StdDev_Depth, Daily_SE_Depth, 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')
29-Sep-2016: converted values in all columns assigned QA/QC flag(s) I (invalid value
(out of range)) to NaN/empty: Daily_Min_Temperature record(s) 1, 2, 3, 4, 5, 6, 7,
8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28,
29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49,
50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70,
71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 136, 213 and 310,
Daily_Max_Temperature record(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15,
16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36,
37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57,
58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78,
79, 80, 81, 82, 83, 84, 85, 86, 136, 213 and 310, Daily_Mean_Temperature record(s)
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23,
24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44,
45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65,
66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86,
136, 213 and 310, Daily_StdDev_Temperature record(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31,
32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52,
53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73,
74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 136, 213 and 310,
Daily_SE_Temperature record(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15,
16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36,
37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57,
58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78,
79, 80, 81, 82, 83, 84, 85, 86, 136, 213 and 310, 105 records in
Daily_Min_Conductivity, 105 records in Daily_Max_Conductivity, 105 records in
Daily_Mean_Conductivity, 105 records in Daily_StdDev_Conductivity, 105 records in
Daily_SE_Conductivity, Daily_Min_Pressure record(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31,
32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52,
53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73,
74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 136, 213 and 310,
Daily_Max_Pressure record(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16,
17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37,
38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58,
59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79,
80, 81, 82, 83, 84, 85, 86, 136, 213 and 310, Daily_Mean_Pressure record(s) 1, 2, 3,
4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25,
26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46,
47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67,
68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 136, 213
and 310, Daily_StdDev_Pressure record(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13,
14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34,
35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55,
56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76,
77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 136, 213 and 310, Daily_SE_Pressure
record(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21,
22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42,
43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63,
64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84,
85, 86, 136, 213 and 310, Daily_Min_Depth record(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31,
32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52,
53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73,
74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 136, 213 and 310,
Daily_Max_Depth record(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17,
18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38,
39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59,
60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80,
81, 82, 83, 84, 85, 86, 136, 213 and 310, Daily_Mean_Depth record(s) 1, 2, 3, 4, 5,
6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27,
28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48,
49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69,
70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 136, 213 and
310, Daily_StdDev_Depth record(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15,
16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36,
37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57,
58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78,
79, 80, 81, 82, 83, 84, 85, 86, 136, 213 and 310, Daily_SE_Depth record(s) 1, 2, 3,
4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25,
26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46,
47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67,
68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 136, 213
and 310, 105 records in Daily_Min_Salinity, 105 records in Daily_Max_Salinity, 105
records in Daily_Mean_Salinity, 105 records in Daily_StdDev_Salinity, 105 records in
Daily_SE_Salinity, 105 records in Daily_Min_Sigma_t, 105 records in
Daily_Max_Sigma_t, 105 records in Daily_Mean_Sigma_t, 105 records in
Daily_StdDev_Sigma_t, 105 records in Daily_SE_Sigma_t ('nullflags')
29-Sep-2016: updated 1 metadata fields in the Study sections ('addmeta')
29-Sep-2016: converted dates in column(s) Date to format yyyy-mm-dd
29-Sep-2016: flags for columns Daily_Min_Temperature, Daily_Max_Temperature,
Daily_Mean_Temperature, Daily_StdDev_Temperature, Daily_SE_Temperature,
Daily_Min_Conductivity, Daily_Max_Conductivity, Daily_Mean_Conductivity,
Daily_StdDev_Conductivity, Daily_SE_Conductivity, Daily_Min_Pressure,
Daily_Max_Pressure, Daily_Mean_Pressure, Daily_StdDev_Pressure, Daily_SE_Pressure,
Daily_Min_Depth, Daily_Max_Depth, Daily_Mean_Depth, Daily_StdDev_Depth,
Daily_SE_Depth, 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')
29-Sep-2016: updated 6 metadata fields in the Data sections ('addmeta')
29-Sep-2016: updated 15 metadata fields in the Status, Data sections to reflect
attribute metadata ('updatecols')
29-Sep-2016: parsed and formatted metadata ('listmeta')
B. Variable Information
1. Variable Name:
column 1. Site
column 2. Longitude
column 3. Latitude
column 4. Date
column 5. Year
column 6. Month
column 7. Day
column 8. Missing_Temperature
column 9. Percent_Missing_Temperature
column 10. Flagged_Temperature
column 11. Percent_Flagged_Temperature
column 12. Daily_Num_Temperature
column 13. Daily_Min_Temperature
column 14. Flag_Daily_Min_Temperature
column 15. Daily_Max_Temperature
column 16. Flag_Daily_Max_Temperature
column 17. Daily_Mean_Temperature
column 18. Flag_Daily_Mean_Temperature
column 19. Daily_StdDev_Temperature
column 20. Flag_Daily_StdDev_Temperature
column 21. Daily_SE_Temperature
column 22. Flag_Daily_SE_Temperature
column 23. Missing_Conductivity
column 24. Percent_Missing_Conductivity
column 25. Flagged_Conductivity
column 26. Percent_Flagged_Conductivity
column 27. Daily_Num_Conductivity
column 28. Daily_Min_Conductivity
column 29. Flag_Daily_Min_Conductivity
column 30. Daily_Max_Conductivity
column 31. Flag_Daily_Max_Conductivity
column 32. Daily_Mean_Conductivity
column 33. Flag_Daily_Mean_Conductivity
column 34. Daily_StdDev_Conductivity
column 35. Flag_Daily_StdDev_Conductivity
column 36. Daily_SE_Conductivity
column 37. Flag_Daily_SE_Conductivity
column 38. Missing_Pressure
column 39. Percent_Missing_Pressure
column 40. Flagged_Pressure
column 41. Percent_Flagged_Pressure
column 42. Daily_Num_Pressure
column 43. Daily_Min_Pressure
column 44. Flag_Daily_Min_Pressure
column 45. Daily_Max_Pressure
column 46. Flag_Daily_Max_Pressure
column 47. Daily_Mean_Pressure
column 48. Flag_Daily_Mean_Pressure
column 49. Daily_StdDev_Pressure
column 50. Flag_Daily_StdDev_Pressure
column 51. Daily_SE_Pressure
column 52. Flag_Daily_SE_Pressure
column 53. Missing_Depth
column 54. Percent_Missing_Depth
column 55. Flagged_Depth
column 56. Percent_Flagged_Depth
column 57. Daily_Num_Depth
column 58. Daily_Min_Depth
column 59. Flag_Daily_Min_Depth
column 60. Daily_Max_Depth
column 61. Flag_Daily_Max_Depth
column 62. Daily_Mean_Depth
column 63. Flag_Daily_Mean_Depth
column 64. Daily_StdDev_Depth
column 65. Flag_Daily_StdDev_Depth
column 66. Daily_SE_Depth
column 67. Flag_Daily_SE_Depth
column 68. Missing_Salinity
column 69. Percent_Missing_Salinity
column 70. Flagged_Salinity
column 71. Percent_Flagged_Salinity
column 72. Daily_Num_Salinity
column 73. Daily_Min_Salinity
column 74. Flag_Daily_Min_Salinity
column 75. Daily_Max_Salinity
column 76. Flag_Daily_Max_Salinity
column 77. Daily_Mean_Salinity
column 78. Flag_Daily_Mean_Salinity
column 79. Daily_StdDev_Salinity
column 80. Flag_Daily_StdDev_Salinity
column 81. Daily_SE_Salinity
column 82. Flag_Daily_SE_Salinity
column 83. Missing_Sigma_t
column 84. Percent_Missing_Sigma_t
column 85. Flagged_Sigma_t
column 86. Percent_Flagged_Sigma_t
column 87. Daily_Num_Sigma_t
column 88. Daily_Min_Sigma_t
column 89. Flag_Daily_Min_Sigma_t
column 90. Daily_Max_Sigma_t
column 91. Flag_Daily_Max_Sigma_t
column 92. Daily_Mean_Sigma_t
column 93. Flag_Daily_Mean_Sigma_t
column 94. Daily_StdDev_Sigma_t
column 95. Flag_Daily_StdDev_Sigma_t
column 96. Daily_SE_Sigma_t
column 97. Flag_Daily_SE_Sigma_t
2. Variable Definition:
column 1. Nearest nominal GCE-LTER sampling site
column 2. Geographic longitude in decimal degrees
column 3. Geographic latitude in decimal degrees
column 4. Fractional MATLAB serial day (based on 1 = January 1, 0000)
column 5. Calendar year
column 6. Calendar month
column 7. Calendar day
column 8. Number of missing observations of Water temperature
column 9. Percent missing observations of Water temperature
column 10. Number of QC/QA-flagged observations of Water temperature
column 11. Percent QC/QA-flagged observations of Water temperature
column 12. Daily Observations of Water temperature
column 13. Daily Minimum Water temperature
column 14. QA/QC flags for Daily Minimum Water temperature (flagging criteria, where "x"
is Daily_Min_Temperature: Percent_Missing_Temperature>35="I",
Percent_Missing_Temperature>15="Q", Percent_Flagged_Temperature>35="Q")
column 15. Daily Maximum Water temperature
column 16. QA/QC flags for Daily Maximum Water temperature (flagging criteria, where "x"
is Daily_Max_Temperature: Percent_Missing_Temperature>35="I",
Percent_Missing_Temperature>15="Q", Percent_Flagged_Temperature>35="Q")
column 17. Daily Mean Water temperature
column 18. QA/QC flags for Daily Mean Water temperature (flagging criteria, where "x" is
Daily_Mean_Temperature: Percent_Missing_Temperature>35="I",
Percent_Missing_Temperature>15="Q", Percent_Flagged_Temperature>35="Q")
column 19. Daily Sample Standard Deviation of Water temperature
column 20. QA/QC flags for Daily Sample Standard Deviation of Water temperature (flagging
criteria, where "x" is Daily_StdDev_Temperature: Percent_Missing_Temperature>35="I",
Percent_Missing_Temperature>15="Q", Percent_Flagged_Temperature>35="Q")
column 21. Daily Standard Error of Water temperature
column 22. QA/QC flags for Daily Standard Error of Water temperature (flagging criteria,
where "x" is Daily_SE_Temperature: Percent_Missing_Temperature>35="I",
Percent_Missing_Temperature>15="Q", Percent_Flagged_Temperature>35="Q")
column 23. Number of missing observations of Conductivity
column 24. Percent missing observations of Conductivity
column 25. Number of QC/QA-flagged observations of Conductivity
column 26. Percent QC/QA-flagged observations of Conductivity
column 27. Daily Observations of Conductivity
column 28. Daily Minimum Conductivity
column 29. QA/QC flags for Daily Minimum Conductivity (flagging criteria, where "x" is
Daily_Min_Conductivity: Percent_Missing_Conductivity>35="I",
Percent_Missing_Conductivity>15="Q", Percent_Flagged_Conductivity>35="Q")
column 30. Daily Maximum Conductivity
column 31. QA/QC flags for Daily Maximum Conductivity (flagging criteria, where "x" is
Daily_Max_Conductivity: Percent_Missing_Conductivity>35="I",
Percent_Missing_Conductivity>15="Q", Percent_Flagged_Conductivity>35="Q")
column 32. Daily Mean Conductivity
column 33. QA/QC flags for Daily Mean Conductivity (flagging criteria, where "x" is
Daily_Mean_Conductivity: Percent_Missing_Conductivity>35="I",
Percent_Missing_Conductivity>15="Q", Percent_Flagged_Conductivity>35="Q")
column 34. Daily Sample Standard Deviation of Conductivity
column 35. QA/QC flags for Daily Sample Standard Deviation of Conductivity (flagging
criteria, where "x" is Daily_StdDev_Conductivity: Percent_Missing_Conductivity>35="I",
Percent_Missing_Conductivity>15="Q", Percent_Flagged_Conductivity>35="Q")
column 36. Daily Standard Error of Conductivity
column 37. QA/QC flags for Daily Standard Error of Conductivity (flagging criteria, where
"x" is Daily_SE_Conductivity: Percent_Missing_Conductivity>35="I",
Percent_Missing_Conductivity>15="Q", Percent_Flagged_Conductivity>35="Q")
column 38. Number of missing observations of Water pressure at sensor (approximately
equivalent to water depth within 3% error)
column 39. Percent missing observations of Water pressure at sensor (approximately
equivalent to water depth within 3% error)
column 40. Number of QC/QA-flagged observations of Water pressure at sensor (approximately
equivalent to water depth within 3% error)
column 41. Percent QC/QA-flagged observations of Water pressure at sensor (approximately
equivalent to water depth within 3% error)
column 42. Daily Observations of Water pressure at sensor (approximately equivalent to
water depth within 3% error)
column 43. Daily Minimum Water pressure at sensor (approximately equivalent to water depth
within 3% error)
column 44. QA/QC flags for Daily Minimum Water pressure at sensor (approximately
equivalent to water depth within 3% error) (flagging criteria, where "x" is
Daily_Min_Pressure: Percent_Missing_Pressure>35="I", Percent_Missing_Pressure>15="Q",
Percent_Flagged_Pressure>35="Q")
column 45. Daily Maximum Water pressure at sensor (approximately equivalent to water depth
within 3% error)
column 46. QA/QC flags for Daily Maximum Water pressure at sensor (approximately
equivalent to water depth within 3% error) (flagging criteria, where "x" is
Daily_Max_Pressure: Percent_Missing_Pressure>35="I", Percent_Missing_Pressure>15="Q",
Percent_Flagged_Pressure>35="Q")
column 47. Daily Mean Water pressure at sensor (approximately equivalent to water depth
within 3% error)
column 48. QA/QC flags for Daily Mean Water pressure at sensor (approximately equivalent
to water depth within 3% error) (flagging criteria, where "x" is Daily_Mean_Pressure:
Percent_Missing_Pressure>35="I", Percent_Missing_Pressure>15="Q",
Percent_Flagged_Pressure>35="Q")
column 49. Daily Sample Standard Deviation of Water pressure at sensor (approximately
equivalent to water depth within 3% error)
column 50. QA/QC flags for Daily Sample Standard Deviation of Water pressure at sensor
(approximately equivalent to water depth within 3% error) (flagging criteria, where "x"
is Daily_StdDev_Pressure: Percent_Missing_Pressure>35="I",
Percent_Missing_Pressure>15="Q", Percent_Flagged_Pressure>35="Q")
column 51. Daily Standard Error of Water pressure at sensor (approximately equivalent to
water depth within 3% error)
column 52. QA/QC flags for Daily Standard Error of Water pressure at sensor (approximately
equivalent to water depth within 3% error) (flagging criteria, where "x" is
Daily_SE_Pressure: Percent_Missing_Pressure>35="I", Percent_Missing_Pressure>15="Q",
Percent_Flagged_Pressure>35="Q")
column 53. Number of missing observations of Water depth to the pressure sensor of the
moored sonde
column 54. Percent missing observations of Water depth to the pressure sensor of the
moored sonde
column 55. Number of QC/QA-flagged observations of Water depth to the pressure sensor of
the moored sonde
column 56. Percent QC/QA-flagged observations of Water depth to the pressure sensor of the
moored sonde
column 57. Daily Observations of Water depth to the pressure sensor of the moored sonde
column 58. Daily Minimum Water depth to the pressure sensor of the moored sonde
column 59. QA/QC flags for Daily Minimum Water depth to the pressure sensor of the moored
sonde (flagging criteria, where "x" is Daily_Min_Depth: Percent_Missing_Depth>35="I",
Percent_Missing_Depth>15="Q", Percent_Flagged_Depth>35="Q")
column 60. Daily Maximum Water depth to the pressure sensor of the moored sonde
column 61. QA/QC flags for Daily Maximum Water depth to the pressure sensor of the moored
sonde (flagging criteria, where "x" is Daily_Max_Depth: Percent_Missing_Depth>35="I",
Percent_Missing_Depth>15="Q", Percent_Flagged_Depth>35="Q")
column 62. Daily Mean Water depth to the pressure sensor of the moored sonde
column 63. QA/QC flags for Daily Mean Water depth to the pressure sensor of the moored
sonde (flagging criteria, where "x" is Daily_Mean_Depth: Percent_Missing_Depth>35="I",
Percent_Missing_Depth>15="Q", Percent_Flagged_Depth>35="Q")
column 64. Daily Sample Standard Deviation of Water depth to the pressure sensor of the
moored sonde
column 65. QA/QC flags for Daily Sample Standard Deviation of Water depth to the pressure
sensor of the moored sonde (flagging criteria, where "x" is Daily_StdDev_Depth:
Percent_Missing_Depth>35="I", Percent_Missing_Depth>15="Q",
Percent_Flagged_Depth>35="Q")
column 66. Daily Standard Error of Water depth to the pressure sensor of the moored sonde
column 67. QA/QC flags for Daily Standard Error of Water depth to the pressure sensor of
the moored sonde (flagging criteria, where "x" is Daily_SE_Depth:
Percent_Missing_Depth>35="I", Percent_Missing_Depth>15="Q",
Percent_Flagged_Depth>35="Q")
column 68. Number of missing observations of Salinity
column 69. Percent missing observations of Salinity
column 70. Number of QC/QA-flagged observations of Salinity
column 71. Percent QC/QA-flagged observations of Salinity
column 72. Daily Observations of Salinity
column 73. Daily Minimum Salinity
column 74. QA/QC flags for Daily Minimum Salinity (flagging criteria, where "x" is
Daily_Min_Salinity: Percent_Missing_Salinity>35="I", Percent_Missing_Salinity>15="Q",
Percent_Flagged_Salinity>35="Q")
column 75. Daily Maximum Salinity
column 76. QA/QC flags for Daily Maximum Salinity (flagging criteria, where "x" is
Daily_Max_Salinity: Percent_Missing_Salinity>35="I", Percent_Missing_Salinity>15="Q",
Percent_Flagged_Salinity>35="Q")
column 77. Daily Mean Salinity
column 78. QA/QC flags for Daily Mean Salinity (flagging criteria, where "x" is
Daily_Mean_Salinity: Percent_Missing_Salinity>35="I", Percent_Missing_Salinity>15="Q",
Percent_Flagged_Salinity>35="Q")
column 79. Daily Sample Standard Deviation of Salinity
column 80. QA/QC flags for Daily Sample Standard Deviation of Salinity (flagging criteria,
where "x" is Daily_StdDev_Salinity: Percent_Missing_Salinity>35="I",
Percent_Missing_Salinity>15="Q", Percent_Flagged_Salinity>35="Q")
column 81. Daily Standard Error of Salinity
column 82. QA/QC flags for Daily Standard Error of Salinity (flagging criteria, where "x"
is Daily_SE_Salinity: Percent_Missing_Salinity>35="I", Percent_Missing_Salinity>15="Q",
Percent_Flagged_Salinity>35="Q")
column 83. Number of missing observations of Sigma-t (i.e. Density-1)
column 84. Percent missing observations of Sigma-t (i.e. Density-1)
column 85. Number of QC/QA-flagged observations of Sigma-t (i.e. Density-1)
column 86. Percent QC/QA-flagged observations of Sigma-t (i.e. Density-1)
column 87. Daily Observations of Sigma-t (i.e. Density-1)
column 88. Daily Minimum Sigma-t (i.e. Density-1)
column 89. QA/QC flags for Daily Minimum Sigma-t (i.e. Density-1) (flagging criteria,
where "x" is Daily_Min_Sigma_t: Percent_Missing_Sigma_t>35="I",
Percent_Missing_Sigma_t>15="Q", Percent_Flagged_Sigma_t>35="Q")
column 90. Daily Maximum Sigma-t (i.e. Density-1)
column 91. QA/QC flags for Daily Maximum Sigma-t (i.e. Density-1) (flagging criteria,
where "x" is Daily_Max_Sigma_t: Percent_Missing_Sigma_t>35="I",
Percent_Missing_Sigma_t>15="Q", Percent_Flagged_Sigma_t>35="Q")
column 92. Daily Mean Sigma-t (i.e. Density-1)
column 93. QA/QC flags for Daily Mean Sigma-t (i.e. Density-1) (flagging criteria, where
"x" is Daily_Mean_Sigma_t: Percent_Missing_Sigma_t>35="I",
Percent_Missing_Sigma_t>15="Q", Percent_Flagged_Sigma_t>35="Q")
column 94. Daily Sample Standard Deviation of Sigma-t (i.e. Density-1)
column 95. QA/QC flags for Daily Sample Standard Deviation of Sigma-t (i.e. Density-1)
(flagging criteria, where "x" is Daily_StdDev_Sigma_t: Percent_Missing_Sigma_t>35="I",
Percent_Missing_Sigma_t>15="Q", Percent_Flagged_Sigma_t>35="Q")
column 96. Daily Standard Error of Sigma-t (i.e. Density-1)
column 97. QA/QC flags for Daily Standard Error of Sigma-t (i.e. Density-1) (flagging
criteria, where "x" is Daily_SE_Sigma_t: Percent_Missing_Sigma_t>35="I",
Percent_Missing_Sigma_t>15="Q", Percent_Flagged_Sigma_t>35="Q")
3. Units of Measurement:
column 1. none
column 2. degrees
column 3. degrees
column 4. yyyy-mm-dd
column 5. YYYY
column 6. MM
column 7. DD
column 8. count
column 9. %
column 10. count
column 11. %
column 12. count
column 13. °C
column 14. none
column 15. °C
column 16. none
column 17. °C
column 18. none
column 19. °C
column 20. none
column 21. °C
column 22. none
column 23. count
column 24. %
column 25. count
column 26. %
column 27. count
column 28. S/m
column 29. none
column 30. S/m
column 31. none
column 32. S/m
column 33. none
column 34. S/m
column 35. none
column 36. S/m
column 37. none
column 38. count
column 39. %
column 40. count
column 41. %
column 42. count
column 43. dbar
column 44. none
column 45. dbar
column 46. none
column 47. dbar
column 48. none
column 49. dbar
column 50. none
column 51. dbar
column 52. none
column 53. count
column 54. %
column 55. count
column 56. %
column 57. count
column 58. m
column 59. none
column 60. m
column 61. none
column 62. m
column 63. none
column 64. m
column 65. none
column 66. m
column 67. none
column 68. count
column 69. %
column 70. count
column 71. %
column 72. count
column 73. PSU
column 74. none
column 75. PSU
column 76. none
column 77. PSU
column 78. none
column 79. PSU
column 80. none
column 81. PSU
column 82. none
column 83. count
column 84. %
column 85. count
column 86. %
column 87. count
column 88. kg/m^3
column 89. none
column 90. kg/m^3
column 91. none
column 92. kg/m^3
column 93. none
column 94. kg/m^3
column 95. none
column 96. kg/m^3
column 97. none
4. Data Type
a. Storage Type:
column 1. integer
column 2. floating-point
column 3. floating-point
column 4. string
column 5. integer
column 6. integer
column 7. integer
column 8. integer
column 9. floating-point
column 10. integer
column 11. floating-point
column 12. integer
column 13. floating-point
column 14. string
column 15. floating-point
column 16. string
column 17. floating-point
column 18. string
column 19. floating-point
column 20. string
column 21. floating-point
column 22. string
column 23. integer
column 24. floating-point
column 25. integer
column 26. floating-point
column 27. integer
column 28. floating-point
column 29. string
column 30. floating-point
column 31. string
column 32. floating-point
column 33. string
column 34. floating-point
column 35. string
column 36. floating-point
column 37. string
column 38. integer
column 39. floating-point
column 40. integer
column 41. floating-point
column 42. integer
column 43. floating-point
column 44. string
column 45. floating-point
column 46. string
column 47. floating-point
column 48. string
column 49. floating-point
column 50. string
column 51. floating-point
column 52. string
column 53. integer
column 54. floating-point
column 55. integer
column 56. floating-point
column 57. integer
column 58. floating-point
column 59. string
column 60. floating-point
column 61. string
column 62. floating-point
column 63. string
column 64. floating-point
column 65. string
column 66. floating-point
column 67. string
column 68. integer
column 69. floating-point
column 70. integer
column 71. floating-point
column 72. integer
column 73. floating-point
column 74. string
column 75. floating-point
column 76. string
column 77. floating-point
column 78. string
column 79. floating-point
column 80. string
column 81. floating-point
column 82. string
column 83. integer
column 84. floating-point
column 85. integer
column 86. floating-point
column 87. integer
column 88. floating-point
column 89. string
column 90. floating-point
column 91. string
column 92. floating-point
column 93. string
column 94. floating-point
column 95. string
column 96. floating-point
column 97. string
b. Variable Codes:
Flag_Daily_Min_Temperature: Q = questionable value
Flag_Daily_Max_Temperature: Q = questionable value
Flag_Daily_Mean_Temperature: Q = questionable value
Flag_Daily_StdDev_Temperature: Q = questionable value
Flag_Daily_SE_Temperature: Q = questionable value
Flag_Daily_Min_Conductivity: Q = questionable value
Flag_Daily_Max_Conductivity: Q = questionable value
Flag_Daily_Mean_Conductivity: Q = questionable value
Flag_Daily_StdDev_Conductivity: Q = questionable value
Flag_Daily_SE_Conductivity: Q = questionable value
Flag_Daily_Min_Pressure: Q = questionable value
Flag_Daily_Max_Pressure: Q = questionable value
Flag_Daily_Mean_Pressure: Q = questionable value
Flag_Daily_StdDev_Pressure: Q = questionable value
Flag_Daily_SE_Pressure: Q = questionable value
Flag_Daily_Min_Depth: Q = questionable value
Flag_Daily_Max_Depth: Q = questionable value
Flag_Daily_Mean_Depth: Q = questionable value
Flag_Daily_StdDev_Depth: Q = questionable value
Flag_Daily_SE_Depth: Q = questionable value
Flag_Daily_Min_Salinity: Q = questionable value
Flag_Daily_Max_Salinity: Q = questionable value
Flag_Daily_Mean_Salinity: Q = questionable value
Flag_Daily_StdDev_Salinity: Q = questionable value
Flag_Daily_SE_Salinity: Q = questionable value
Flag_Daily_Min_Sigma_t: Q = questionable value
Flag_Daily_Max_Sigma_t: Q = questionable value
Flag_Daily_Mean_Sigma_t: Q = questionable value
Flag_Daily_StdDev_Sigma_t: Q = questionable value
Flag_Daily_SE_Sigma_t: Q = questionable value
c. Numeric Range:
column 1. 8 to 8
column 2. -81.4093 to -81.4093
column 3. 31.3104 to 31.3104
column 4. (none)
column 5. 2008 to 2008
column 6. 1 to 12
column 7. 1 to 31
column 8. 0 to 48
column 9. 0 to 100
column 10. 0 to 1
column 11. 0 to 2.0408
column 12. 0 to 48
column 13. 10.9598 to 30.07
column 14. (none)
column 15. 12.3098 to 31.2894
column 16. (none)
column 17. 11.7939 to 30.6126
column 18. (none)
column 19. 0.059528 to 0.63521
column 20. (none)
column 21. 0.0085921 to 0.091685
column 22. (none)
column 23. 0 to 48
column 24. 0 to 100
column 25. 0 to 19
column 26. 0 to 35.8491
column 27. 0 to 48
column 28. 0.00948 to 2.7317
column 29. (none)
column 30. 0.01816 to 5.0089
column 31. (none)
column 32. 0.011447 to 4.0993
column 33. (none)
column 34. 0.0018774 to 0.96958
column 35. (none)
column 36. 0.00027681 to 0.13995
column 37. (none)
column 38. 0 to 48
column 39. 0 to 100
column 40. 0 to 1
column 41. 0 to 2.0408
column 42. 0 to 48
column 43. 0.51 to 2.131
column 44. (none)
column 45. 2.781 to 3.855
column 46. (none)
column 47. 1.8728 to 3.1153
column 48. (none)
column 49. 0.46555 to 0.89276
column 50. (none)
column 51. 0.067196 to 0.12886
column 52. (none)
column 53. 0 to 48
column 54. 0 to 100
column 55. 0 to 1
column 56. 0 to 2.0408
column 57. 0 to 48
column 58. 0.50647 to 2.1163
column 59. (none)
column 60. 2.7618 to 3.8283
column 61. (none)
column 62. 1.8599 to 3.0937
column 63. (none)
column 64. 0.46233 to 0.88658
column 65. (none)
column 66. 0.066731 to 0.12797
column 67. (none)
column 68. 0 to 48
column 69. 0 to 100
column 70. 0 to 19
column 71. 0 to 35.8491
column 72. 0 to 48
column 73. 0.054773 to 16.269
column 74. (none)
column 75. 0.10361 to 32.0259
column 76. (none)
column 77. 0.066732 to 25.549
column 78. (none)
column 79. 0.010266 to 6.3146
column 80. (none)
column 81. 0.0015136 to 0.91143
column 82. (none)
column 83. 0 to 48
column 84. 0 to 100
column 85. 0 to 19
column 86. 0 to 35.8491
column 87. 0 to 48
column 88. -3.9515 to 8.8652
column 89. (none)
column 90. -1.9321 to 20.7649
column 91. (none)
column 92. -2.0652 to 15.8191
column 93. (none)
column 94. 0.03084 to 4.7185
column 95. (none)
column 96. 0.0044513 to 0.68106
column 97. (none)
d. Missing Value Code:
5. Data Format
a. Column Type:
column 1. numerical
column 2. numerical
column 3. numerical
column 4. text
column 5. numerical
column 6. numerical
column 7. numerical
column 8. numerical
column 9. numerical
column 10. numerical
column 11. numerical
column 12. numerical
column 13. numerical
column 14. text
column 15. numerical
column 16. text
column 17. numerical
column 18. text
column 19. numerical
column 20. text
column 21. numerical
column 22. text
column 23. numerical
column 24. numerical
column 25. numerical
column 26. numerical
column 27. numerical
column 28. numerical
column 29. text
column 30. numerical
column 31. text
column 32. numerical
column 33. text
column 34. numerical
column 35. text
column 36. numerical
column 37. text
column 38. numerical
column 39. numerical
column 40. numerical
column 41. numerical
column 42. numerical
column 43. numerical
column 44. text
column 45. numerical
column 46. text
column 47. numerical
column 48. text
column 49. numerical
column 50. text
column 51. numerical
column 52. text
column 53. numerical
column 54. numerical
column 55. numerical
column 56. numerical
column 57. numerical
column 58. numerical
column 59. text
column 60. numerical
column 61. text
column 62. numerical
column 63. text
column 64. numerical
column 65. text
column 66. numerical
column 67. text
column 68. numerical
column 69. numerical
column 70. numerical
column 71. numerical
column 72. numerical
column 73. numerical
column 74. text
column 75. numerical
column 76. text
column 77. numerical
column 78. text
column 79. numerical
column 80. text
column 81. numerical
column 82. text
column 83. numerical
column 84. numerical
column 85. numerical
column 86. numerical
column 87. numerical
column 88. numerical
column 89. text
column 90. numerical
column 91. text
column 92. numerical
column 93. text
column 94. numerical
column 95. text
column 96. numerical
column 97. text
b. Number of Columns: 97
c. Decimal Places:
column 1. 0
column 2. 6
column 3. 6
column 4. 0
column 5. 0
column 6. 0
column 7. 0
column 8. 0
column 9. 2
column 10. 0
column 11. 2
column 12. 0
column 13. 3
column 14. 0
column 15. 3
column 16. 0
column 17. 4
column 18. 0
column 19. 4
column 20. 0
column 21. 5
column 22. 0
column 23. 0
column 24. 2
column 25. 0
column 26. 2
column 27. 0
column 28. 3
column 29. 0
column 30. 3
column 31. 0
column 32. 4
column 33. 0
column 34. 4
column 35. 0
column 36. 5
column 37. 0
column 38. 0
column 39. 2
column 40. 0
column 41. 2
column 42. 0
column 43. 3
column 44. 0
column 45. 3
column 46. 0
column 47. 4
column 48. 0
column 49. 4
column 50. 0
column 51. 5
column 52. 0
column 53. 0
column 54. 2
column 55. 0
column 56. 2
column 57. 0
column 58. 3
column 59. 0
column 60. 3
column 61. 0
column 62. 4
column 63. 0
column 64. 4
column 65. 0
column 66. 5
column 67. 0
column 68. 0
column 69. 2
column 70. 0
column 71. 2
column 72. 0
column 73. 3
column 74. 0
column 75. 3
column 76. 0
column 77. 4
column 78. 0
column 79. 4
column 80. 0
column 81. 5
column 82. 0
column 83. 0
column 84. 2
column 85. 0
column 86. 2
column 87. 0
column 88. 3
column 89. 0
column 90. 3
column 91. 0
column 92. 4
column 93. 0
column 94. 4
column 95. 0
column 96. 5
column 97. 0
6. Logical Variable Type:
column 1. nominal (discrete)
column 2. geographic coordinate (continuous)
column 3. geographic coordinate (continuous)
column 4. datetime (none)
column 5. datetime (discrete)
column 6. datetime (discrete)
column 7. datetime (discrete)
column 8. calculation (discrete)
column 9. calculation (continuous)
column 10. calculation (discrete)
column 11. calculation (continuous)
column 12. calculation (discrete)
column 13. calculation (continuous)
column 14. coded value (none)
column 15. calculation (continuous)
column 16. coded value (none)
column 17. calculation (continuous)
column 18. coded value (none)
column 19. calculation (continuous)
column 20. coded value (none)
column 21. calculation (continuous)
column 22. coded value (none)
column 23. calculation (discrete)
column 24. calculation (continuous)
column 25. calculation (discrete)
column 26. calculation (continuous)
column 27. calculation (discrete)
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 (continuous)
column 35. coded value (none)
column 36. calculation (continuous)
column 37. coded value (none)
column 38. calculation (discrete)
column 39. calculation (continuous)
column 40. calculation (discrete)
column 41. calculation (continuous)
column 42. calculation (discrete)
column 43. calculation (continuous)
column 44. coded value (none)
column 45. calculation (continuous)
column 46. coded value (none)
column 47. calculation (continuous)
column 48. coded value (none)
column 49. calculation (continuous)
column 50. coded value (none)
column 51. calculation (continuous)
column 52. coded value (none)
column 53. calculation (discrete)
column 54. calculation (continuous)
column 55. calculation (discrete)
column 56. calculation (continuous)
column 57. calculation (discrete)
column 58. calculation (continuous)
column 59. coded value (none)
column 60. calculation (continuous)
column 61. coded value (none)
column 62. calculation (continuous)
column 63. coded value (none)
column 64. calculation (continuous)
column 65. coded value (none)
column 66. calculation (continuous)
column 67. coded value (none)
column 68. calculation (discrete)
column 69. calculation (continuous)
column 70. calculation (discrete)
column 71. calculation (continuous)
column 72. calculation (discrete)
column 73. calculation (continuous)
column 74. coded value (none)
column 75. calculation (continuous)
column 76. coded value (none)
column 77. calculation (continuous)
column 78. coded value (none)
column 79. calculation (continuous)
column 80. coded value (none)
column 81. calculation (continuous)
column 82. coded value (none)
column 83. calculation (discrete)
column 84. calculation (continuous)
column 85. calculation (discrete)
column 86. calculation (continuous)
column 87. calculation (discrete)
column 88. calculation (continuous)
column 89. coded value (none)
column 90. calculation (continuous)
column 91. coded value (none)
column 92. calculation (continuous)
column 93. coded value (none)
column 94. calculation (continuous)
column 95. coded value (none)
column 96. calculation (continuous)
column 97. coded value (none)
7. Flagging Criteria:
column 1. none
column 2. none
column 3. none
column 4. none
column 5. none
column 6. none
column 7. none
column 8. none
column 9. none
column 10. none
column 11. none
column 12. none
column 13.
col_Percent_Missing_Temperature>35="I";col_Percent_Missing_Temperature>15="Q";col_Percen
t_Flagged_Temperature>35="Q"
column 14. none
column 15.
col_Percent_Missing_Temperature>35="I";col_Percent_Missing_Temperature>15="Q";col_Percen
t_Flagged_Temperature>35="Q"
column 16. none
column 17.
col_Percent_Missing_Temperature>35="I";col_Percent_Missing_Temperature>15="Q";col_Percen
t_Flagged_Temperature>35="Q"
column 18. none
column 19.
col_Percent_Missing_Temperature>35="I";col_Percent_Missing_Temperature>15="Q";col_Percen
t_Flagged_Temperature>35="Q"
column 20. none
column 21.
col_Percent_Missing_Temperature>35="I";col_Percent_Missing_Temperature>15="Q";col_Percen
t_Flagged_Temperature>35="Q"
column 22. none
column 23. none
column 24. none
column 25. none
column 26. none
column 27. none
column 28.
col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc
ent_Flagged_Conductivity>35="Q"
column 29. none
column 30.
col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc
ent_Flagged_Conductivity>35="Q"
column 31. none
column 32.
col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc
ent_Flagged_Conductivity>35="Q"
column 33. none
column 34.
col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc
ent_Flagged_Conductivity>35="Q"
column 35. none
column 36.
col_Percent_Missing_Conductivity>35="I";col_Percent_Missing_Conductivity>15="Q";col_Perc
ent_Flagged_Conductivity>35="Q"
column 37. none
column 38. none
column 39. none
column 40. none
column 41. none
column 42. none
column 43.
col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag
ged_Pressure>35="Q"
column 44. none
column 45.
col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag
ged_Pressure>35="Q"
column 46. none
column 47.
col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag
ged_Pressure>35="Q"
column 48. none
column 49.
col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag
ged_Pressure>35="Q"
column 50. none
column 51.
col_Percent_Missing_Pressure>35="I";col_Percent_Missing_Pressure>15="Q";col_Percent_Flag
ged_Pressure>35="Q"
column 52. none
column 53. none
column 54. none
column 55. none
column 56. none
column 57. none
column 58.
col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De
pth>35="Q"
column 59. none
column 60.
col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De
pth>35="Q"
column 61. none
column 62.
col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De
pth>35="Q"
column 63. none
column 64.
col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De
pth>35="Q"
column 65. none
column 66.
col_Percent_Missing_Depth>35="I";col_Percent_Missing_Depth>15="Q";col_Percent_Flagged_De
pth>35="Q"
column 67. none
column 68. none
column 69. none
column 70. none
column 71. none
column 72. none
column 73.
col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag
ged_Salinity>35="Q"
column 74. none
column 75.
col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag
ged_Salinity>35="Q"
column 76. none
column 77.
col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag
ged_Salinity>35="Q"
column 78. none
column 79.
col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag
ged_Salinity>35="Q"
column 80. none
column 81.
col_Percent_Missing_Salinity>35="I";col_Percent_Missing_Salinity>15="Q";col_Percent_Flag
ged_Salinity>35="Q"
column 82. none
column 83. none
column 84. none
column 85. none
column 86. none
column 87. none
column 88.
col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge
d_Sigma_t>35="Q"
column 89. none
column 90.
col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge
d_Sigma_t>35="Q"
column 91. none
column 92.
col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge
d_Sigma_t>35="Q"
column 93. none
column 94.
col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge
d_Sigma_t>35="Q"
column 95. none
column 96.
col_Percent_Missing_Sigma_t>35="I";col_Percent_Missing_Sigma_t>15="Q";col_Percent_Flagge
d_Sigma_t>35="Q"
column 97. none
C. Data Anomalies: Values of 89 records in Daily_Min_Temperature were flagged as I (invalid
value (out of range)). Values of 2 records in Daily_Min_Temperature were flagged as Q
(questionable value). Values of 86 records in Daily_Min_Temperature are missing. Values of 89
records in Daily_Max_Temperature were flagged as I (invalid value (out of range)). Values of
2 records in Daily_Max_Temperature were flagged as Q (questionable value). Values of 86
records in Daily_Max_Temperature are missing. Values of 89 records in Daily_Mean_Temperature
were flagged as I (invalid value (out of range)). Values of 2 records in
Daily_Mean_Temperature were flagged as Q (questionable value). Values of 86 records in
Daily_Mean_Temperature are missing. Values of 89 records in Daily_StdDev_Temperature were
flagged as I (invalid value (out of range)). Values of 2 records in Daily_StdDev_Temperature
were flagged as Q (questionable value). Values of 86 records in Daily_StdDev_Temperature are
missing. Values of 89 records in Daily_SE_Temperature were flagged as I (invalid value (out
of range)). Values of 2 records in Daily_SE_Temperature were flagged as Q (questionable
value). Values of 86 records in Daily_SE_Temperature are missing. Values of 105 records in
Daily_Min_Conductivity were flagged as I (invalid value (out of range)). Values of 3 records
in Daily_Min_Conductivity were flagged as Q (questionable value). Values of 101 records in
Daily_Min_Conductivity are missing. Values of 105 records in Daily_Max_Conductivity were
flagged as I (invalid value (out of range)). Values of 3 records in Daily_Max_Conductivity
were flagged as Q (questionable value). Values of 101 records in Daily_Max_Conductivity are
missing. Values of 105 records in Daily_Mean_Conductivity were flagged as I (invalid value
(out of range)). Values of 3 records in Daily_Mean_Conductivity were flagged as Q
(questionable value). Values of 101 records in Daily_Mean_Conductivity are missing. Values of
105 records in Daily_StdDev_Conductivity were flagged as I (invalid value (out of range)).
Values of 3 records in Daily_StdDev_Conductivity were flagged as Q (questionable value).
Values of 101 records in Daily_StdDev_Conductivity are missing. Values of 105 records in
Daily_SE_Conductivity were flagged as I (invalid value (out of range)). Values of 3 records
in Daily_SE_Conductivity were flagged as Q (questionable value). Values of 101 records in
Daily_SE_Conductivity are missing. Values of 89 records in Daily_Min_Pressure were flagged as
I (invalid value (out of range)). Values of 2 records in Daily_Min_Pressure were flagged as Q
(questionable value). Values of 86 records in Daily_Min_Pressure are missing. Values of 89
records in Daily_Max_Pressure were flagged as I (invalid value (out of range)). Values of 2
records in Daily_Max_Pressure were flagged as Q (questionable value). Values of 86 records in
Daily_Max_Pressure are missing. Values of 89 records in Daily_Mean_Pressure were flagged as I
(invalid value (out of range)). Values of 2 records in Daily_Mean_Pressure were flagged as Q
(questionable value). Values of 86 records in Daily_Mean_Pressure are missing. Values of 89
records in Daily_StdDev_Pressure were flagged as I (invalid value (out of range)). Values of
2 records in Daily_StdDev_Pressure were flagged as Q (questionable value). Values of 86
records in Daily_StdDev_Pressure are missing. Values of 89 records in Daily_SE_Pressure were
flagged as I (invalid value (out of range)). Values of 2 records in Daily_SE_Pressure were
flagged as Q (questionable value). Values of 86 records in Daily_SE_Pressure are missing.
Values of 89 records in Daily_Min_Depth were flagged as I (invalid value (out of range)).
Values of 2 records in Daily_Min_Depth were flagged as Q (questionable value). Values of 86
records in Daily_Min_Depth are missing. Values of 89 records in Daily_Max_Depth were flagged
as I (invalid value (out of range)). Values of 2 records in Daily_Max_Depth were flagged as Q
(questionable value). Values of 86 records in Daily_Max_Depth are missing. Values of 89
records in Daily_Mean_Depth were flagged as I (invalid value (out of range)). Values of 2
records in Daily_Mean_Depth were flagged as Q (questionable value). Values of 86 records in
Daily_Mean_Depth are missing. Values of 89 records in Daily_StdDev_Depth were flagged as I
(invalid value (out of range)). Values of 2 records in Daily_StdDev_Depth were flagged as Q
(questionable value). Values of 86 records in Daily_StdDev_Depth are missing. Values of 89
records in Daily_SE_Depth were flagged as I (invalid value (out of range)). Values of 2
records in Daily_SE_Depth were flagged as Q (questionable value). Values of 86 records in
Daily_SE_Depth are missing. Values of 105 records in Daily_Min_Salinity were flagged as I
(invalid value (out of range)). Values of 3 records in Daily_Min_Salinity were flagged as Q
(questionable value). Values of 101 records in Daily_Min_Salinity are missing. Values of 105
records in Daily_Max_Salinity were flagged as I (invalid value (out of range)). Values of 3
records in Daily_Max_Salinity were flagged as Q (questionable value). Values of 101 records
in Daily_Max_Salinity are missing. Values of 105 records in Daily_Mean_Salinity were flagged
as I (invalid value (out of range)). Values of 3 records in Daily_Mean_Salinity were flagged
as Q (questionable value). Values of 101 records in Daily_Mean_Salinity are missing. Values
of 105 records in Daily_StdDev_Salinity were flagged as I (invalid value (out of range)).
Values of 3 records in Daily_StdDev_Salinity were flagged as Q (questionable value). Values
of 101 records in Daily_StdDev_Salinity are missing. Values of 105 records in
Daily_SE_Salinity were flagged as I (invalid value (out of range)). Values of 3 records in
Daily_SE_Salinity were flagged as Q (questionable value). Values of 101 records in
Daily_SE_Salinity are missing. Values of 105 records in Daily_Min_Sigma_t were flagged as I
(invalid value (out of range)). Values of 3 records in Daily_Min_Sigma_t were flagged as Q
(questionable value). Values of 101 records in Daily_Min_Sigma_t are missing. Values of 105
records in Daily_Max_Sigma_t were flagged as I (invalid value (out of range)). Values of 3
records in Daily_Max_Sigma_t were flagged as Q (questionable value). Values of 101 records in
Daily_Max_Sigma_t are missing. Values of 105 records in Daily_Mean_Sigma_t were flagged as I
(invalid value (out of range)). Values of 3 records in Daily_Mean_Sigma_t were flagged as Q
(questionable value). Values of 101 records in Daily_Mean_Sigma_t are missing. Values of 105
records in Daily_StdDev_Sigma_t were flagged as I (invalid value (out of range)). Values of 3
records in Daily_StdDev_Sigma_t were flagged as Q (questionable value). Values of 101 records
in Daily_StdDev_Sigma_t are missing. Values of 105 records in Daily_SE_Sigma_t were flagged
as I (invalid value (out of range)). Values of 3 records in Daily_SE_Sigma_t were flagged as
Q (questionable value). Values of 101 records in Daily_SE_Sigma_t are missing.
V. Supplemental Descriptors
A. Data Acquisition
1. Data Forms: Copies of CTD cast logs and raw data are maintained at the Georgia Coastal
Ecosystems Information Management Office
2. Form Location: GCE-LTER Information Management Office, Dept. of Marine Sciences,
University of Georgia, Athens, GA 30602
3. Data Entry Validation: 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: 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