CalCOFI collects seawater samples using 24-10L bottles mounted on a CTD-Rosette. The seawater samples are analyzed at-sea then undergo a series of additional data-processing, calibration, & data-quality steps on shore. Once final, good bottle data are merged with 1m-binaveraged CTD sensor data from the same cast, same depths. The bottle salinities from >350m are used to correct CTD salinities (from all depths) by applying (separate) offsets to both primary and secondary CTD salinities.
The oxygen bottle samples are regressed against the corresponding CTD primary and secondary oxygen sensor data. Four cruise-average correction regression plots, using all the bottle samples, are plotted and coefficients applied, resulting in Ox1_CruiseCorr ml/L and umol/Kg and Ox2_CruiseCorr ml/L and umol/Kg data columns.
Both station and cruise-average correction regression plots, using all the chlorophyll bottle samples, are plotted versus the CTD fluorometer voltage. The coefficients are applied to the 1m binavg fluorometer voltages from 0-200 meters - EstChl_StaCorr & EstChl_CruiseCorr. Lastly, two regression plots, station & cruise-average correction, using all the nitrate bottle samples, are plotted versus the CTD ISUS sensor voltages. Coefficients are applied to the 1m binavg ISUS voltage to calculate two estimated nitrate profiles - cruise-corrected using coefficients from all the bottle data & sta-corrected using coefficients from the cast's ~20 bottle samples.

In addition to cruise-corrected data, there are station-corrected data. These data are regression-corrected CTD data that use the bottle data from only that station, ~20 samples. These data are considered the best data, better than cruise-corrected data, since it adjusts for station-to-station variablilty in the sensor behavior such as sensor drift.

Please note that additional data quality code columns were added in 2015. CTD data files with the 82-column format are labeled "FinalQC". CTD data from cruises prior to 1511 are being reprocessed to add the data-quality columns and codes. 
QCodes: blank or 0 code = good data; "8" = questionable data; "9" = bad data

83-Column CTD + Bottle CSV Format (color key & data code index at bottom)
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, 9 char
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; D.DDD
14 (N) Pressure 1 Meter Binavg Pressure (db) R7.3; P.PPP
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
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:

  • 0 or blank = Good Data
  • 1 = use Primary sensor data (dual sensors)
  • 2 = use Secondary sensor data (dual sensors)
  • 8 = data questionable
  • 9 = bad or missing data


Go to top
Our website is protected by DMC Firewall!