CTD Cast Files
Zipped folders of CTD data by cruise (1990 - present)
Overview
In addition to CalCOFI’s Bottle Database, which contains measurements derived from collected seawater samples, CalCOFI offers CTD sensor data, available by cruise. These data present water column profiles in higher resolution (1 meter instead of ~10 to 100-meter resolution).
These oceanographic data are collected using a CTD-Rosette. In the center of the ‘rosette’ of Niskin bottles, there is an instrument called a CTD (“Conductivity-Temperature-Depth”) that is equipped with sensors to measure various parameters. Available parameters include temperature, conductivity/salinity, dissolved oxygen, fluorescence/chlorophyll-a, nitrate, and many more.
CTD data are available from 1990, when CalCOFI began using a CTD-Rosette, to the present. CalCOFI uses an SBE 911plus CTD surrounded by a rosette of 24 10-liter Niskin bottles. See CTD / Bottle Sampling for more details.
The CTD Cast Files table (below) provides raw and processed & corrected CTD sensor data available for download
CTD Data Descriptions
 | Raw CTD Data |  | Preliminary CTD 1m-Binned |  | Preliminary CTD & Bottle 1m-Binned |  | Final 1m-Binned |  | Prodo Cast |  | Test Cast |
- Raw CTD Data: Data files (.xmlcon, .hex, .bl, .nav, .prn, .mrk, .hdr) directly from SBE Software (Sea-Bird Scientific) with no processing or corrections applied.
- Preliminary CTD 1m-Binned: Raw CTD sensor data that have gone through SBE Data Processing, and obvious bad sensor readings have been flagged during initial QAQC. Bottle data has not yet been merged with the CTD data. CTD Salinity, Oxygen, Fluorescence, and Nitrate profiles have not been corrected to the bottle data. Cruise corrected Nitrate sensor data (EstNO3_CruiseCorr) has been converted from raw voltage using a sensor calibration done before each cruise, but not yet corrected using CTD vs. Bottle regressions.Â
- Preliminary CTD & Bottle 1m-Binned: Preliminary CTD sensor data that have been merged with QAQC’ed bottle data. CTD Salinity, Oxygen, Fluorescence, and Nitrate profiles have been corrected using CTD vs. bottle regressions.Â
- Final 1m-Binned: CTD data that have passed through the CalCOFI quality control process. After standard Seasoft-processing (Sea-Bird Scientific’s data-processing suite) tuned for our SBE 911plus CTD, the .asc files are processed by SIO-CalCOFI in-house software (BtlVsCTD). Averaged (4-sec or 1-meter bin-averaged) CTD sensor data are matched with corresponding bottle data, then cruise-corrected and station-corrected. Zipped file includes: metadata and .asc, .hdr, .btl, and upcast & downcast .csvs (“u” and “d”; by station and concatenated).
- Cruise-corrected CTD data: CTD sensor data that are corrected using regression coefficients derived from 4-sec average sensor data vs bottle data comparisons for the entire cruise, meaning all casts with bottle samples (n=~1400; fliers omitted; column labels ‘_CruiseCorr’).
- Station-corrected CTD data: CTD sensor data that are corrected using regression coefficients generated dynamically for each cast, 1m bin-averaged sensor data vs bottle data (n=~20; fliers omitted; column labels ‘_StaCorr’).
- Since sensor behavior may vary from station to station, station-corrected CTD sensor data for salinity, oxygen, estimated nitrate, and estimated chlorophyll-a are considered the best, particularly for estimated nitrate.
- Test Cast/Prodo Cast: The Seabird 911plus CTD was first tested in Mar 1990 (9003JD) but is still under development. CTD data from Mar 1990 – 1991 were occasional system & feasibility tests (“test casts“). As confidence in data quality improved, the CTD-Rosette began being used for daily primary productivity sample collection casts (“prodo casts“) in 1992 (6 depths from one station per day).
- The first complete CalCOFI cruise using a CTD-Rosette on all stations was in Aug 1993 (9308NH).
- “FinalQC” files include additional quality-control code columns – latest format is 82-columns. These additional columns were added Nov 2015 but older cruises are being reprocessed so look for “finalQC” for the 82-column updated files. Final CTD data values should not change during the conversion from 65 to 82 columns. But data codes may be added to bad or missing sensor data (data code ‘9’) and questionable sensor data (data code ‘8’) in the corresponding “Q” column.
- The Windows-version of Sea-bird’s SBE Data Processing Suite will not work on CTD data collected from 1990 to mid-1998. Those data must be processed by the DOS version of Seasoft, which can be successfully run in DOSBox on Windows 7 & 10.
- Some older cruises may not have final data available since they are being reprocessed using the current data-processing methodology for data-format continuity. All Raw CTD Data data files are available, however, processed data (preliminary or final bottle-corrected) will be posted when they are completed.
Concatenated downcast .csv (filename: 20-1902RL_CTDBTL_001-029D.csv)
82-Column CTD + Bottle CSV Format (color key & data code index at bottom)
Disclaimer: The original data headers have not been modified. Please see the notes below for details on any data adjustments.
Count (Excel Column) | Field | Description | Notes Column |
1 (A) | Project | Cruise; usually CalCOFI | |
2 (B) | Study | YYMMSS (year month ship) Cruise designation | |
3 (C) | Ord_Occ | Order Occupied | |
4 (D) | Event_Num | CTD-at-Depth event number | |
5 (E) | Cast_ID | Study+Order Occupied+up or downcast | |
6 (F) | Date_Time_UTC | Date Time UTC; downcast = start time; upcast=time @ 1st bottle tripped | |
7 (G) | Date_Time_PST | Date Time PST: downcast = start time; upcast=time @ 1st bottle tripped | |
8 (H) | Lat_Dec | GPS Decimal Latitude: downcast = start lat; upcast=lat @ 1st bottle tripped | |
9 (I) | Lon_Dec | GPS Decimal Longitude: downcast = start lon; upcast=lon @ 1st bottle tripped | |
10 (J) | Sta_ID | CalCOFI Line and Station | |
11 (K) | Line | CalCOFI Line | |
12 (L) | Sta | CalCOFI Station | |
13 (M) | Depth | 1 Meter Binavg Depth (meters) | |
14 (N) | Pressure | 1 Meter Binavg Pressure (db) | |
15 (O) | PrQ | Pressure Sensor Data Quality | |
16 (P) | Temp1 | 1° Temperature (deg C) | |
17 (Q) | Temp1Q | 1° Temperature Data Quality Code | |
18 (R) | Temp2 | 2° Temperature (deg C) | |
19 (S) | Temp2Q | 2° Temperature Data Quality Code | |
20 (T) | TempAve | Average Temperature, deg C; (1°+2°)/2 | |
21 (U) | Salt1 | 1° Salinity (PSU) | |
22 (V) | Salt1Q | 1° Salinity Data Quality Code | |
23 (W) | Salt1_Corr | 1° Salinity, Bottle-corrected (PSU) | |
24 (X) | Salt2 | 2° Salinity (PSU) | |
25 (Y) | Salt2Q | 2° Salinity Data Quality Code | |
26 (Z) | Salt2_Corr | 2° Salinity, Bottle-corrected (PSU) | |
27 (AA) | SaltAve_Corr | Average Corrected Salinity; (1°+2°)/2 | |
28 (AB) | Ox1 | 1° Oxygen; ml/L | |
29 (AC) | Ox1Q | 1° Oxygen Data Quality Code | |
30 (AD) | Ox1_CruiseCorr | 1° Oxygen, cruise-corrected; ml/L | |
31 (AE) | Ox1_StaCorr | 1° Oxygen, sta-corrected; ml/L | |
32 (AF) | Ox2 | 2° Oxygen; ml/L | |
33 (AG) | Ox2Q | 2° Oxygen Data Quality Code | |
34 (AH) | Ox2_CruiseCorr | 2° Oxygen, cruise-corrected; ml/L | |
35 (AI) | Ox2_StaCorr | 2° Oxygen, sta-corrected; ml/L | |
36 (AJ) | OxAve_StaCorr | Average Oxygen (ml/L); (1°+2°)/2 | |
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) | |
45 (AS) | FluorQ | Fluorometer Data Quality Code | |
46 (AT) | EstChl_CruiseCorr | Estimated Chlorophyll, cruise-corrected | |
47 (AU) | EstChl_StaCorr | Estimated Chlorophyll, sta-corrected | |
48 (AV) | ISUSV | ISUS Voltage | 2111 SUNA V2 Replaced the ISUS |
49 (AW) | ISUSQ | ISUS Data Quality Code | |
50 (AX) | EstNO3_CruiseCorr | Estimated Nitrate, cruise-corrected | Not cruise corrected, but SBE data corrected for 2507 and beyond |
51 (AY) | EstNO3_StaCorr | Estimated Nitrate, sta-corrected | |
52 (AZ) | SigThetaTS1 | Sigma-theta T1S1 | |
53 (BA) | SigThetaTS1Q | Sigma-theta T1S1 Quality Code | |
54 (BB) | SigThetaTS2 | Sigma-theta T2S2 | |
55 (BC) | SigThetaTS2Q | Sigma-theta T2S2 Quality Code | |
56 (BD) | BAT | Beam Attenuation Coefficient | |
57 (BE) | XMiss | % Light Transmission | |
58 (BF) | TransQ | Transmissometer Quality Code | |
59 (BG) | pH | pH Sensor | |
60 (BH) | pHQ | pH Sensor Quality Code | |
61 (BI) | SPAR | Surface PAR | |
62 (BJ) | SPARQ | Surface PAR Quality Code | |
63 (BK) | PAR | Remote PAR | |
64 (BL) | PARQ | Remote PAR Quality Code | |
65 (BM) | PoT1 | Potential Temperature | |
66 (BN) | PoT2 | Potential Temperature | |
67 (BO) | DynHt | Dynamic Height | |
68 (BP) | SVA | Specific Volume Anomaly | |
69 (BQ) | OxSat1 | Oxygen Saturation | |
70 (BR) | OxSat2 | Oxygen Saturation | |
71 (BS) | BTL_Depth | Bottle Depth (meters) | |
72 (BT) | BTL_Temp | Bottle Temperature (deg C); usually 1° T | |
73 (BU) | SaltB | Bottle Salinity (PSU) | |
74 (BV) | OxB | Bottle Oxygen (ml/L) | |
75 (BW) | OxBuM | Bottle Oxygen (umol/KG) | |
76 (BX) | Chl-a | Bottle Chlorophyll | |
77 (BY) | Phaeo | Bottle Phaeopigments | |
78 (BZ) | NO3 | Bottle Nitrate | |
79 (CA) | NO2 | Bottle Nitrite | |
80 (CB) | NH4 | Bottle Ammonium | |
81 (CC) | PO4 | Bottle Phosphate | |
82 (CD) | SIL | Bottle Silicate |
CTD Cast Files
Legend:
| Raw CTD Data | | Preliminary CTD 1m-Binned | | Preliminary CTD & Bottle 1m-Binned | | Final 1m-Binned | | Prodo Cast | | Test Cast |
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
2026 | 2601RL
| 2604SH | ||||||||||
2025 | 2501RL
| 2502RL
| 2504SH
| 2507SR
| 2511SR
| |||||||
2024 | 2401RL
| 2404SH
| 2408SR
| 2411SR
| ||||||||
2023 | 2301RL
| 2304SH
| 2307SR
| 2311SR
| ||||||||
2022 | 2204SH
| 2208BH
| 2211SR
| |||||||||
2021 | 2101RL
| 2105SH
| 2107SR
| 2111SR
| ||||||||
2020 | 2001RL
| 2007SR
| 2010SR
| |||||||||
2019 |
| 1904RL
|
|
| ||||||||
2018 |
|
| 1806SR
|
| ||||||||
2017 |
|
|
|
| ||||||||
2016 |
|
|
|
| ||||||||
2015 |
|
|
|
| ||||||||
2014 |
|
|
|
| ||||||||
2013 | 1301SH
| 1304SH
| 1307NH
| 1311NH
| ||||||||
2012 | 1202NH
| 1203SH
| 1207OS
| 1210NH
| ||||||||
2011 | 1101NH
| 1104SH
| 1108NH
| 1110NH
| ||||||||
2010 | 1001NH
| 1004MF
| 1008NH
| 1011NH
| ||||||||
Jan | Feb | Mar | Apr | May | June | Jul | Aug | Sep | Oct | Nov | Dec | |
2009 | 0901NH
| 0903JD
| 0907M2
| 0911NH
| ||||||||
2008 | 0801JD
| 0804JD
| 0808NH
| 0810NH
| ||||||||
2007 | 0701JD
| 0704JD
| 0707NH
| 0711NH
| ||||||||
2006 | 0602JD
| 0604JD
| 0607NH
| 0610RR
| ||||||||
2005 | 0501JD
| 0504NH
| 0507NH
| 0511NH
| ||||||||
2004 | 0401JD
| 0404NH
| 0407JD
| 0411RR
| ||||||||
2003 | 0302JD
| 0304RR
| 0307NH
| 0310NH
| ||||||||
2002 | 0201JD
| 0204JD
| 0207NH
| 0211NH
| ||||||||
2001 | 0101JD
| 0104JD
| 0107NH
| 0110NH
| ||||||||
2000 | 0001NH
| 0004JD
| 0007NH
| 0010NH
| ||||||||
Jan | Feb | Mar | Apr | May | June | Jul | Aug | Sep | Oct | Nov | Dec | |
1999 | 9901RR
| 9904JD
| 9908NH
| 9910NH
| ||||||||
1998 | 9802JD
| 9803SP
| 9804JD
| 9805SP
| 9807NH
| 9808SP
| 9809NH
| 9810SP
| 9811SP
| 9812SP
| ||
1997 | 9702JD
| 9704NH
| 9707JD
| 9709NH
| 9712SP
| |||||||
1996 | 9602JD
| 9604JD
| 9608NH
| 9610RR
| ||||||||
1995 | 9501JD
| 9504NH
| 9507JD
| 9510NH
| ||||||||
1994 | 9401JD
| 9403JD
| 9408NH
| 9410NH
| ||||||||
1993 | 9301JD
| 9304JD
| 9308NH
| 9310NH
| ||||||||
1992 | 9202JD
| 9204JD
| 9207NH
| 9210NH
| ||||||||
1991 | 9101JD
| 9103JD
| 9108JD
| 9110NH
| ||||||||
1990 | 9003JD
| 9011NH
| ||||||||||
Jan | Feb | Mar | Apr | May | June | Jul | Aug | Sep | Oct | Nov | Dec |