Column |
Name |
Units |
Type |
Description |
1 |
Site |
none |
integer |
Nearest nominal GCE-LTER sampling site |
2 |
Station |
none |
string |
Station determined by geographic database lookup of coordinates in columns Latitude and Longitude using a distance tolerance of 0.5km from registered station location |
3 |
Longitude |
degrees |
floating-point |
Geographic longitude in decimal degrees |
4 |
Latitude |
degrees |
floating-point |
Geographic latitude in decimal degrees |
5 |
Instrument |
none |
integer |
Serial number of the SBE 37-SM MicroCAT instrument used for the observations |
6 |
Date |
yyyy-mm-dd HH:MM:SS - GMT |
string |
Fractional MATLAB serial day (based on 1 = January 1, 0000) |
7 |
Year |
YYYY |
integer |
Calendar year |
8 |
Month |
MM |
integer |
Calendar month |
9 |
Day |
DD |
integer |
Calendar day |
10 |
Hour |
hr |
integer |
Hours - GMT |
11 |
Minute |
min |
integer |
Minutes |
12 |
Temperature |
°C |
floating-point |
Water temperature |
13 |
Flag_Temperature |
none |
string |
QA/QC flags for Water temperature (flagging criteria, where "x" is Temperature: x<0="Q", x>35="Q", Depth<=0="I", Depth<0.15="Q", flag_valuechange(x, 2, 2, 1, 3)="Q", manual) |
14 |
Conductivity |
S/m |
floating-point |
Conductivity |
15 |
Flag_Conductivity |
none |
string |
QA/QC flags for Conductivity (flagging criteria, where "x" is Conductivity: x<0="I", Depth<=0="I", Depth<0.15="Q", flag_valuechange(x, 0.75, 0.75, 1, 3)="Q", manual) |
16 |
Pressure |
dbar |
floating-point |
Water pressure at sensor (approximately equivalent to water depth within 3% error) |
17 |
Flag_Pressure |
none |
string |
QA/QC flags for Water pressure at sensor (approximately equivalent to water depth within 3% error) (flagging criteria, where "x" is Pressure: x<0="I", x<0.05="X", x>10="Q", manual) |
18 |
Depth |
m |
floating-point |
Water depth to the pressure sensor of the moored sonde |
19 |
Flag_Depth |
none |
string |
QA/QC flags for Water depth to the pressure sensor of the moored sonde (flagging criteria, where "x" is Depth: x<0="I", x<0.05="X", x>10="Q", manual) |
20 |
Salinity |
PSU |
floating-point |
Salinity |
21 |
Flag_Salinity |
none |
string |
QA/QC flags for Salinity (flagging criteria, where "x" is Salinity: x<0="I", Depth<=0="I", x>38="Q", Depth<0.15="Q", flag_valuechange(x, 6, 6, 1, 3)="Q", manual) |
22 |
Sigma_t |
kg/m^3 |
floating-point |
Sigma-t (i.e. Density-1) |
23 |
Flag_Sigma_t |
none |
string |
QA/QC flags for Sigma-t (i.e. Density-1) (flagging criteria, where "x" is Sigma_t: Depth<=0="I", Depth<0.15="Q", flag_valuechange(x, 5, 5, 1, 3)="Q", x<-5="Q", x>28="Q", manual) |
24 |
Calibration |
none |
integer |
Boolean value indicating whether data represents a calibration check (0 = false, 1 = true) |
25 |
Pump |
none |
integer |
Boolean value indicating whether conductivity was measured using a pumped cell (1=true/0=false) |
Column |
Name |
Units |
Type |
Description |
1 |
Site |
none |
integer |
Nearest nominal GCE-LTER sampling site |
2 |
Station |
none |
string |
Station determined by geographic database lookup of coordinates in columns Latitude and Longitude using a distance tolerance of 0.5km from registered station location |
3 |
Longitude |
degrees |
floating-point |
Geographic longitude in decimal degrees |
4 |
Latitude |
degrees |
floating-point |
Geographic latitude in decimal degrees |
5 |
Date |
yyyy-mm-dd HH:MM:SS |
string |
Fractional MATLAB serial day (based on 1 = January 1, 0000) |
6 |
Year |
YYYY |
integer |
Calendar year |
7 |
Month |
MM |
integer |
Calendar month |
8 |
Day |
DD |
integer |
Calendar day |
9 |
Missing_Temperature |
count |
integer |
Number of missing observations of Water temperature |
10 |
Percent_Missing_Temperature |
% |
floating-point |
Percent missing observations of Water temperature |
11 |
Flagged_Temperature |
count |
integer |
Number of QC/QA-flagged observations of Water temperature |
12 |
Percent_Flagged_Temperature |
% |
floating-point |
Percent QC/QA-flagged observations of Water temperature |
13 |
Daily_Num_Temperature |
count |
integer |
Daily Observations of Water temperature |
14 |
Daily_Min_Temperature |
°C |
floating-point |
Daily Minimum Water temperature |
15 |
Flag_Daily_Min_Temperature |
none |
string |
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") |
16 |
Daily_Max_Temperature |
°C |
floating-point |
Daily Maximum Water temperature |
17 |
Flag_Daily_Max_Temperature |
none |
string |
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") |
18 |
Daily_Mean_Temperature |
°C |
floating-point |
Daily Mean Water temperature |
19 |
Flag_Daily_Mean_Temperature |
none |
string |
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") |
20 |
Daily_StdDev_Temperature |
°C |
floating-point |
Daily Sample Standard Deviation of Water temperature |
21 |
Flag_Daily_StdDev_Temperature |
none |
string |
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") |
22 |
Daily_SE_Temperature |
°C |
floating-point |
Daily Standard Error of Water temperature |
23 |
Flag_Daily_SE_Temperature |
none |
string |
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") |
24 |
Missing_Conductivity |
count |
integer |
Number of missing observations of Conductivity |
25 |
Percent_Missing_Conductivity |
% |
floating-point |
Percent missing observations of Conductivity |
26 |
Flagged_Conductivity |
count |
integer |
Number of QC/QA-flagged observations of Conductivity |
27 |
Percent_Flagged_Conductivity |
% |
floating-point |
Percent QC/QA-flagged observations of Conductivity |
28 |
Daily_Num_Conductivity |
count |
integer |
Daily Observations of Conductivity |
29 |
Daily_Min_Conductivity |
S/m |
floating-point |
Daily Minimum Conductivity |
30 |
Flag_Daily_Min_Conductivity |
none |
string |
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") |
31 |
Daily_Max_Conductivity |
S/m |
floating-point |
Daily Maximum Conductivity |
32 |
Flag_Daily_Max_Conductivity |
none |
string |
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") |
33 |
Daily_Mean_Conductivity |
S/m |
floating-point |
Daily Mean Conductivity |
34 |
Flag_Daily_Mean_Conductivity |
none |
string |
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") |
35 |
Daily_StdDev_Conductivity |
S/m |
floating-point |
Daily Sample Standard Deviation of Conductivity |
36 |
Flag_Daily_StdDev_Conductivity |
none |
string |
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") |
37 |
Daily_SE_Conductivity |
S/m |
floating-point |
Daily Standard Error of Conductivity |
38 |
Flag_Daily_SE_Conductivity |
none |
string |
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") |
39 |
Missing_Pressure |
count |
integer |
Number of missing observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) |
40 |
Percent_Missing_Pressure |
% |
floating-point |
Percent missing observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) |
41 |
Flagged_Pressure |
count |
integer |
Number of QC/QA-flagged observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) |
42 |
Percent_Flagged_Pressure |
% |
floating-point |
Percent QC/QA-flagged observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) |
43 |
Daily_Num_Pressure |
count |
integer |
Daily Observations of Water pressure at sensor (approximately equivalent to water depth within 3% error) |
44 |
Daily_Min_Pressure |
dbar |
floating-point |
Daily Minimum Water pressure at sensor (approximately equivalent to water depth within 3% error) |
45 |
Flag_Daily_Min_Pressure |
none |
string |
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") |
46 |
Daily_Max_Pressure |
dbar |
floating-point |
Daily Maximum Water pressure at sensor (approximately equivalent to water depth within 3% error) |
47 |
Flag_Daily_Max_Pressure |
none |
string |
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") |
48 |
Daily_Mean_Pressure |
dbar |
floating-point |
Daily Mean Water pressure at sensor (approximately equivalent to water depth within 3% error) |
49 |
Flag_Daily_Mean_Pressure |
none |
string |
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") |
50 |
Daily_StdDev_Pressure |
dbar |
floating-point |
Daily Sample Standard Deviation of Water pressure at sensor (approximately equivalent to water depth within 3% error) |
51 |
Flag_Daily_StdDev_Pressure |
none |
string |
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") |
52 |
Daily_SE_Pressure |
dbar |
floating-point |
Daily Standard Error of Water pressure at sensor (approximately equivalent to water depth within 3% error) |
53 |
Flag_Daily_SE_Pressure |
none |
string |
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") |
54 |
Missing_Depth |
count |
integer |
Number of missing observations of Water depth to the pressure sensor of the moored sonde |
55 |
Percent_Missing_Depth |
% |
floating-point |
Percent missing observations of Water depth to the pressure sensor of the moored sonde |
56 |
Flagged_Depth |
count |
integer |
Number of QC/QA-flagged observations of Water depth to the pressure sensor of the moored sonde |
57 |
Percent_Flagged_Depth |
% |
floating-point |
Percent QC/QA-flagged observations of Water depth to the pressure sensor of the moored sonde |
58 |
Daily_Num_Depth |
count |
integer |
Daily Observations of Water depth to the pressure sensor of the moored sonde |
59 |
Daily_Min_Depth |
m |
floating-point |
Daily Minimum Water depth to the pressure sensor of the moored sonde |
60 |
Flag_Daily_Min_Depth |
none |
string |
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") |
61 |
Daily_Max_Depth |
m |
floating-point |
Daily Maximum Water depth to the pressure sensor of the moored sonde |
62 |
Flag_Daily_Max_Depth |
none |
string |
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") |
63 |
Daily_Mean_Depth |
m |
floating-point |
Daily Mean Water depth to the pressure sensor of the moored sonde |
64 |
Flag_Daily_Mean_Depth |
none |
string |
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") |
65 |
Daily_StdDev_Depth |
m |
floating-point |
Daily Sample Standard Deviation of Water depth to the pressure sensor of the moored sonde |
66 |
Flag_Daily_StdDev_Depth |
none |
string |
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") |
67 |
Daily_SE_Depth |
m |
floating-point |
Daily Standard Error of Water depth to the pressure sensor of the moored sonde |
68 |
Flag_Daily_SE_Depth |
none |
string |
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") |
69 |
Missing_Salinity |
count |
integer |
Number of missing observations of Salinity |
70 |
Percent_Missing_Salinity |
% |
floating-point |
Percent missing observations of Salinity |
71 |
Flagged_Salinity |
count |
integer |
Number of QC/QA-flagged observations of Salinity |
72 |
Percent_Flagged_Salinity |
% |
floating-point |
Percent QC/QA-flagged observations of Salinity |
73 |
Daily_Num_Salinity |
count |
integer |
Daily Observations of Salinity |
74 |
Daily_Min_Salinity |
PSU |
floating-point |
Daily Minimum Salinity |
75 |
Flag_Daily_Min_Salinity |
none |
string |
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") |
76 |
Daily_Max_Salinity |
PSU |
floating-point |
Daily Maximum Salinity |
77 |
Flag_Daily_Max_Salinity |
none |
string |
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") |
78 |
Daily_Mean_Salinity |
PSU |
floating-point |
Daily Mean Salinity |
79 |
Flag_Daily_Mean_Salinity |
none |
string |
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") |
80 |
Daily_StdDev_Salinity |
PSU |
floating-point |
Daily Sample Standard Deviation of Salinity |
81 |
Flag_Daily_StdDev_Salinity |
none |
string |
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") |
82 |
Daily_SE_Salinity |
PSU |
floating-point |
Daily Standard Error of Salinity |
83 |
Flag_Daily_SE_Salinity |
none |
string |
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") |
84 |
Missing_Sigma_t |
count |
integer |
Number of missing observations of Sigma-t (i.e. Density-1) |
85 |
Percent_Missing_Sigma_t |
% |
floating-point |
Percent missing observations of Sigma-t (i.e. Density-1) |
86 |
Flagged_Sigma_t |
count |
integer |
Number of QC/QA-flagged observations of Sigma-t (i.e. Density-1) |
87 |
Percent_Flagged_Sigma_t |
% |
floating-point |
Percent QC/QA-flagged observations of Sigma-t (i.e. Density-1) |
88 |
Daily_Num_Sigma_t |
count |
integer |
Daily Observations of Sigma-t (i.e. Density-1) |
89 |
Daily_Min_Sigma_t |
kg/m^3 |
floating-point |
Daily Minimum Sigma-t (i.e. Density-1) |
90 |
Flag_Daily_Min_Sigma_t |
none |
string |
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") |
91 |
Daily_Max_Sigma_t |
kg/m^3 |
floating-point |
Daily Maximum Sigma-t (i.e. Density-1) |
92 |
Flag_Daily_Max_Sigma_t |
none |
string |
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") |
93 |
Daily_Mean_Sigma_t |
kg/m^3 |
floating-point |
Daily Mean Sigma-t (i.e. Density-1) |
94 |
Flag_Daily_Mean_Sigma_t |
none |
string |
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") |
95 |
Daily_StdDev_Sigma_t |
kg/m^3 |
floating-point |
Daily Sample Standard Deviation of Sigma-t (i.e. Density-1) |
96 |
Flag_Daily_StdDev_Sigma_t |
none |
string |
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") |
97 |
Daily_SE_Sigma_t |
kg/m^3 |
floating-point |
Daily Standard Error of Sigma-t (i.e. Density-1) |
98 |
Flag_Daily_SE_Sigma_t |
none |
string |
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") |