CalCOFI's Seabird 911+ CTD includes dual Temperature, Conductivity, and Oxygen sensor arrays (dual O2s since Jul 2009) that are separately plumbed & pumped. Data from these sensors are labeled Temp1, Salt1, Ox1, & Temp2, Salt2, Ox2 respectively (refer to the index below for units). The "FinalQC" version of the CTD csvs also include oxygens in umol/kg (Ox1uM, Ox2uM) and data-quality code columns. Data codes (flags) are used to identify bad (datacode "9") or questionable (datacode "8") data.
CalCOFI collects seawater samples using 24-10L metal-free bottles mounted on an epoxy-coated rosette. The seawater samples are analyzed & processed at-sea then undergo a series of additional post-cruise calibration, data-processing & data-quality steps on shore. Initial merging & comparison of CTD & bottle data generates the "prelim" CTD csvs used for point-checking. Once bottle data have been gone through CalCOFI's data quality control protocols, the final bottle data are merged with 1m-binavg CTD sensor data from the same cast and depths. CTD salinities deeper than 350m are subtracted from matching bottle (depth) salinities. These differences are averaged into offsets for both primary and secondary CTD salinities and applied to all CTD salinities. Bottle-corrected CTD salinities are reported as Salt1_Corr (primary), Salt2_Corr (secondary), and SaltAve_Corr (ave of both).
Oxygen bottle samples are plotted versus the corresponding CTD primary (Ox1) and secondary (Ox2) oxygen sensor data. Regression coefficients to correct CTD oxygens are derived for both sensors in ml/L and µM/kg - 4 plots total. The bottle-corrected CTD sensor data are reported in the Ox1_CruiseCorr (ml/L) and Ox1µM_CruiseCorr (µM/Kg) and Ox2_CruiseCorr and Ox2_µM_CruiseCorr data columns.
One-meter binavg CTD fluorometer voltages are plotted versus the corresponding depth chlorophyll bottle samples to derive regression coefficients. These are applied to the 1m binavg fluorometer voltages from 0-200 meters, estimating chlorophyll-a & reported as EstChl_CruiseCorr.
A plot of 1m binavg ISUS voltages versus nitrate (NO3) using all the nitrate bottle samples generates regression coefficients. These are applied to the 1m binavg ISUS voltage to derive estimated nitrate data, reported as EstNO3_CruiseCorr
Note: when bottle data are plotted versus CTD sensor data, bottle data "fliers" are excluded so they do not influence the bottle data sensor correction coefficients.
In addition to cruise-corrected CTD data, there are station-corrected data. These data are bottle-corrected CTD data that use the bottle data from only the matching station. These data are generated using CalCOFI-developed software that dynamically calculates the correction coefficients and applies them automatically to CTD sensor data. These data are usually the best data since this method adjusts for station-to-station variablilty in the sensor behavior such as sensor drift. These data are reported as "StaCorr": Ox1_StaCorr, Ox2_StaCorr, EstChl_StaCorr, EstNO2_StaCorr. The coefficients applied dynamically for each station may be different and are tabulated in each cruises CTD metadata file "DBcoeff.csv".
Please note that the FinalQC format with additional data quality code columns was adopted in 2015. CTD data files with the 82-column format are labeled "FinalQC". Cruise files labeled "Final" are being reprocessed to add the data-quality columns, data codes, & O2s in uM/Kg. When updated, they will be relabled "FinalQC". Note that most data values, particularly T & S, should remain unchanged - only the format is changing and data-flags added.
QCodes: blank or "0" code = good data; "8" = questionable data; "9" = bad data
Count (Excel Column) | Field | Description | Format |
1 (A) | Project | Cruise; usually CalCOFI | Text, variable |
2 (B) | Study | YYMMSS (year month ship) Cruise designation | Text, 6 char |
3 (C) | Ord_Occ | Order Occupied | Integer |
4 (D) | Event_Num | CTD-at-Depth event number | Integer |
5 (E) | Cast_ID | Study+Order Occupied+up or downcast | Text, YYMM_###D or U |
6 (F) | Date_Time_UTC | Date Time UTC; downcast = start time; upcast=time @ 1st bottle tripped | DD-MMM-YYYY HH:M:SS |
7 (G) | Date_Time_PST | Date Time PST: downcast = start time; upcast=time @ 1st bottle tripped | DD-MMM-YYYY HH:MM:SS |
8 (H) | Lat_Dec | GPS Decimal Latitude: downcast = start lat; upcast=lat @ 1st bottle tripped | R7.5; ##.##### |
9 (I) | Lon_Dec | GPS Decimal Longitude: downcast = start lon; upcast=lon @ 1st bottle tripped | R8.5; -###.##### |
10 (J) | Sta_ID | CalCOFI Line and Station | Text; LLL.L SSS.S |
11 (K) | Line | CalCOFI Line | R4.1; LLL.L |
12 (L) | Sta | CalCOFI Station | R4.1; SSS.S |
13 (M) | Depth | 1 Meter Binavg Depth (meters) | R7.3; #.### |
14 (N) | Pressure | 1 Meter Binavg Pressure (db) | R7.3; #.### |
15 (O) | PrQ | Pressure Sensor Data Quality | I1 |
16 (P) | Temp1 | 1° Temperature (deg C) | R6.4; ##.#### |
17 (Q) | Temp1Q | 1° Temperature Data Quality Code | I1; see key below |
18 (R) | Temp2 | 2° Temperature (deg C) | R6.4; ##.#### |
19 (S) | Temp2Q | 2° Temperature Data Quality Code | I1 |
20 (T) | TempAve | Average Temperature, deg C; (1°+2°)/2 | R6.4;# #.#### |
21 (U) | Salt1 | 1° Salinity (PSU) | R6.4; ##.#### |
22 (V) | Salt1Q | 1° Salinity Data Quality Code | I1 |
23 (W) | Salt1_Corr | 1° Salinity, Bottle-corrected (PSU) | R6.4 |
24 (X) | Salt2 | 2° Salinity (PSU) | R6.4 |
25 (Y) | Salt2Q | 2° Salinity Data Quality Code | I1 |
26 (Z) | Salt2_Corr | 2° Salinity, Bottle-corrected (PSU) | R6.4 |
27 (AA) | SaltAve_Corr | Average Corrected Salinity; (1°+2°)/2 | R6.4 |
28 (AB) | Ox1 | 1° Oxygen; ml/L | R6.5 |
29 (AC) | Ox1Q | 1° Oxygen Data Quality Code | I1 |
30 (AD) | Ox1_CruiseCorr | 1° Oxygen, cruise-corrected; ml/L | R6.5; see key |
31 (AE) | Ox1_StaCorr | 1° Oxygen, sta-corrected; ml/L | R6.5; see key |
32 (AF) | Ox2 | 2° Oxygen; ml/L | R6.5 |
33 (AG) | Ox2Q | 2° Oxygen Data Quality Code | I1 |
34 (AH) | Ox2_CruiseCorr | 2° Oxygen, cruise-corrected; ml/L | R6.5 |
35 (AI) | Ox2_StaCorr | 2° Oxygen, sta-corrected; ml/L | R6.5 |
36 (AJ) | OxAve_StaCorr | Average Oxygen (ml/L); (1°+2°)/2 | R6.5 |
37 (AK) | Ox1uM | 1° Oxygen; uM/Kg | |
38 (AL) | Ox1uM_CruiseCorr | 1° Oxygen;cruise-corrected;uM/Kg | |
39 (AM) | Ox1uM_StaCorr | 1° Oxygen;sta-corrected; uM/Kg | |
40 (AN) | Ox2uM | 2° Oxygen; uM/Kg | |
41 (AO) | Ox2uM_CruiseCorr | 2° Oxygen;cruise-corrected;uM/Kg | |
42 (AP) | Ox2uM_StaCorr | 2° Oxygen;sta-corrected; uM/Kg | |
43 (AQ) | OxAveuM_StaCorr | Average Oxygen (ml/L); (1°+2°)/2 | |
44 (AR) | FluorV | Fluorometer Voltage (V) | R5.4 |
45 (AS) | FluorQ | Fluorometer Data Quality Code | I1 |
46 (AT) | EstChl_CruiseCorr | Estimated Chlorophyll, cruise-corrected | R6.4 |
47 (AU) | EstChl_StaCorr | Estimated Chlorophyll, sta-corrected | R6.4 |
48 (AV) | ISUSV | ISUS Voltage | R5.4 |
49 (AW) | ISUSQ | ISUS Data Quality Code | I1 |
50 (AX) | EstNO3_CruiseCorr | Estimated Nitrate, cruise-corrected | R5.4 |
51 (AY) | EstNO3_StaCorr | Estimated Nitrate, sta-corrected | R5.4 |
52 (AZ) | SigThetaTS1 | Sigma-theta T1S1 | R6.4 |
53 (BA) | SigThetaTS1Q | Sigma-theta T1S1 Quality Code | I1 |
54 (BB) | SigThetaTS2 | Sigma-theta T2S2 | R6.4 |
55 (BC) | SigThetaTS2Q | Sigma-theta T2S2 Quality Code | I1 |
56 (BD) | BAT | Beam Attenuation Coefficient | R5.4 |
57 (BE) | XMiss | % Light Transmission | R6.4 |
58 (BF) | TransQ | Transmissometer Quality Code | I1 |
59 (BG) | pH | pH Sensor | R6.4 |
60 (BH) | pHQ | pH Sensor Quality Code | I1 |
61 (BI) | SPAR | Surface PAR | #.##E+## |
62 (BJ) | SPARQ | Surface PAR Quality Code | I1 |
63 (BK) | PAR | Remote PAR | #.##E+## |
64 (BL) | PARQ | Remote PAR Quality Code | I1 |
65 (BM) | PoT1 | Potential Temperature | R6.4 |
66 (BN) | PoT2 | Potential Temperature | R6.4 |
67 (BO) | DynHt | Dynamic Height | R5.4 |
68 (BP) | SVA | Specific Volume Anomaly | R6.3 |
69 (BQ) | OxSat1 | Oxygen Saturation | R5.4 |
70 (BR) | OxSat2 | Oxygen Saturation | R5.4 |
71 (BS) | BTL_Depth | Bottle Depth (meters) | I4 |
72 (BT) | BTL_Temp | Bottle Temperature (deg C); usually 1°T | R5.3 |
73 (BU) | SaltB | Bottle Salinity (PSU) | R6.4 |
74 (BV) | OxB | Bottle Oxygen (ml/L) | R4.3 |
75 (BW) | OxBuM | Bottle Oxygen (umol/KG) | R6.2 |
76 (BX) | Chl-a | Bottle Chlorophyll | R4.3 |
77 (BY) | Phaeo | Bottle Phaeopigments | R4.3 |
78 (BZ) | NO3 | Bottle Nitrate | R3.1 |
79 (CA) | NO2 | Bottle Nitrite | R3.2 |
80 (CB) | NH4 | Bottle Ammonium | R3.2 |
81 (CC) | PO4 | Bottle Phosphate | R4.2 |
82 (CD) | SIL | Bottle Silicate | R5.2 |
Color Codes for this table (background color indicates data source) | |||
Color | Data Type | Source | |
White | CTD Cast Information | CTD "At Depth" Metadata | |
Green | CTD Data | 1m binavg CTD Data, Seasave processed | |
Yellow | Bottle-corrected CTD Data | 1m CTD Data, Seasave processed, bottle corrected | |
Blue | Bottle Data | Final, processed bottle data | |
Purple | Data Quality |
Data Quality Codes and Comments: |
|
|