82-Column CTD + Bottle CSV Format (color key & data code index at bottom)
Count (Excel Column) Field Description Format
1 (A) Project Cruise; usually CalCOFI or CalCOFI sampling area 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:

   
  • 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