A station csv (sta.csv) is generated for each CTD cast performed during a cruise. Built from the CTD mrk file, the seawater samples collected from each depth are tabulated. Data columns related to each depth are then populated during sample analysis and data processing. CTD 1-meter bin-averaged data are imported into many columns and used for data quality control, data cross-checks & point-checking. Once populated with final bottle and bottle-corrected CTD data, the sta.csvs are used to generate the CalCOFI data products.
This 2015 revision adds individual datacodes to each nutrient PO4, SIL, NO2, NO3. Previous versions (2014 or older) used either one datacode for PO4, SIL, NO2, & NO3 or individual datacodes merged in the NDC column (P#,S#,T#,O#). NH3 has always had its own datacode. All columns greater than #28 (PO4) in the csv have shifted one to three columns.
Please ignore the DECODR Array column used by our sta.csv data processing program. Its inclusion is for developmental purposes, to facilitate the migration from column-specific programming to dynamic column programming in DECODR.
Column Label | Col # | Width | format | Excel Cell | DECODR Array |
---|---|---|---|---|---|
Cruise (YYMM | )1 | 6 | T 4 | A | CstCols%(1) |
Line (CalCOFI Line LL.L) | 2 | 6 | 4.1 | B | CstCols%(2) |
Station (CalCOFI Sta SSS.S) | 3 | 7 | 5.1 | C | CstCols%(3) |
Ord_Occ (order occupied) | 4 | 7 | I 5 | D | CstCols%(4) |
Event (event log #) | 5 | 7 | I 5 | E | CstCols%(5) |
Date_PST (CTD cast date) | 6 | 13 | DD-MMM-YYYY | F | CstCols%(6) |
Time_PST (CTD cast time, at depth) | 7 | 10 | HH:MM:SS | G | CstCols%(7) |
Nis (niskin bottle #) | 8 | 5 | I 3 | H | BtlCols%(1) |
Samp (sample #) | 9 | 5 | I 3 | I | BtlCols%(2) |
Depth (depth, meters) | 10 | 7 | 6.1 | J | BtlCols%(3) |
StdLvl (Standard Level indicator) | 11 | 6 | T 3 | K | BtlCols%(4) |
DPTHNT (depth note(s)) | 12 | 6 | T 6 | L | BtlCols%(5) |
Press (CTD pressure db) | 13 | 7 | 6.1 | M | BtlCols%(6) |
T1degC (1° temperature) | 14 | 8 | 6.3 | N | TCols%(1) |
T2degC (2° temperature) | 15 | 8 | 6.3 | O | TCols%(2) |
TDC* (temperature data code) | 16 | 6 | T 6 | P | TCols%(3) |
TPI* (temperature point-check index) | 17 | 6 | I 6 | Q | TCols%(4) |
SaltB (bottle salinity) | 18 | 9 | 7.4 | R | SCols%(1) |
Salt1 (1° CTD salinity) | 19 | 9 | 7.4 | S | SCols%(2) |
Salt2 (2° CTD salinity) | 20 | 9 | 7.4 | T | SCols%(3) |
SDC (salinity data code) | 21 | 6 | T 6 | U | SCols%(4) |
SPI (salinity point-check index) | 22 | 6 | I 6 | V | SCols%(5) |
OxB (bottle oxygen) | 23 | 7 | 5.3 | W | OCols%(1) |
Ox1 (1° CTD oxygen) | 24 | 7 | 5.3 | X | OCols%(2) |
Ox2 (2° CTD oxygen) | 25 | 7 | 5.3 | Y | OCols%(3) |
ODC (oxygen data code) | 26 | 6 | T 6 | Z | OCols%(4) |
OPI (oxygen point-check index) | 27 | 6 | I 6 | AA | OCols%(5) |
PO4 (bottle sample phosphate) | 28 | 6 | 4.2 | AB | NutCols%(1) |
P4DC (phosphate data code) | 29 | 6 | I 6 | AC | NutCols%(2) |
SIL (bottle sample silicate) | 30 | 6 | 5.2 | AD | NutCols%(3) |
SIDC (silicate data code) | 31 | 6 | I 6 | AE | NutCols%(4) |
NO2 (bottle sample nitrite) | 32 | 6 | 4.2 | AF | NutCols%(5) |
N2DC (nitrite data code) | 33 | 6 | I 6 | AG | NutCols%(6) |
NO3 (bottle sample nitrate) | 34 | 6 | 4.1 | AH | NutCols%(7) |
N3DC (nitrate data code) | 35 | 6 | I 6 | AI | NutCols%(8) |
NPI (nutrient point-check index) | 36 | 6 | I 6 | AJ | NutCols%(9) |
NH3 (bottle sample ammonia) | 37 | 6 | 4.2 | AK | NutCols%(10) |
NHDC (NH3 data code) | 38 | 6 | T 6 | AL | NutCols%(11) |
NHPI (NH3 point-check index) | 39 | 6 | I 6 | AM | NutCols%(12) |
N:P (Nitrate:Phosphate Ratio) | 40 | 6 | 5.2 | AN | NutCols%(13) |
Chl-a (bottle chlorophyll) | 41 | 7 | 6.3 | AO | ChlCols%(1) |
Phaeo (bottle phaeopigments) | 42 | 7 | 6.3 | AP | ChlCols%(2) |
CPDC (chl-a, phaeopigment data code) | 43 | 6 | T 6 | AQ | ChlCols%(3) |
CPPI (chl-a, phaeopigment point-check index) | 44 | 6 | I 6 | AR | ChlCols%(4) |
%Light (prodo %light level) | 45 | 8 | 5.3 | AS | PrdCols%(1) |
C14A (C14 assim. light sample a) | 46 | 8 | 6.3 | AT | PrdCols%(2) |
C14B (C14 assim. light sample b) | 47 | 8 | 6.3 | AU | PrdCols%(3) |
C14ave (C14 assim ave of light samples a & b) | 48 | 8 | 6.3 | AV | PrdCols%(4) |
C14D (C14 assim. dark sample) | 49 | 8 | 5.3 | AW | PrdCols%(5) |
C14DC (C14 data code) | 50 | 6 | T 6 | AX | PrdCols%(6) |
C14PI (C14 point-check index) | 51 | 6 | I 6 | AY | PrdCols%(7) |
Uptake (C14.ave.assim/chla) | 52 | 9 | AZ | PrdCols%(8) | |
SCIN_DPM-A (Scintillation counts) | 53 | 10 | 9.2 | BA | PrdCols%(9) |
SCN%EFF-A (Scintillation Efficiency) | 54 | 7 | 5.2 | BB | PrdCols%(10) |
SCIN_DPM-B (Scintillation counts) | 55 | 10 | 9.2 | BC | PrdCols%(11) |
SCN%EFF-B (Scintillation Efficiency) | 56 | 7 | 5.2 | BD | PrdCols%(12) |
SCIN_DPM-D (Scintillation counts) | 57 | 10 | 9.2 | BE | PrdCols%(13) |
SCN%EFF-D (Scintillation Efficiency) | 58 | 7 | 5.2 | BF | PrdCols%(14) |
SCIN_BLANK | 59 | 8 | 6.2 | BG | PrdCols%(15) |
SPEC_ACTIVITY | 60 | 7 | 5.2 | BH | PrdCols%(16) |
S-thetaB (bottle sigma-theta) | 61 | 8 | 7.4 | BI | STCols%(1) |
S-theta1 (CTD 1° sigma-theta) | 62 | 8 | 7.4 | BJ | STCols%(2) |
S-theta2 (CTD 2° sigma-theta) | 63 | 8 | 7.4 | BK | STCols%(3) |
StDC (sigma-theta data code) | 64 | 6 | T 6 | BL | STCols%(4) |
OxSatB (bottle oxygen %saturation) | 65 | 7 | 6.2 | BM | OCols%(6) |
OxSat1 (CTD 1° oxygen %saturation) | 66 | 7 | 6.2 | BN | OCols%(7) |
OxSat2 (CTD 2° oxygen %saturation) | 67 | 7 | 6.2 | BO | OCols%(8) |
OxSDC (ox saturation data code) | 68 | 6 | T 6 | BP | OCols%(9) |
PoTB (bottle potential temperture) | 69 | 9 | 7.4 | BQ | TCols%(5) |
PoT1 (CTD 1° potential temp) | 70 | 9 | 7.4 | BR | TCols%(6) |
PoT2 (CTD 2° potential temp) | 71 | 9 | 7.4 | BS | TCols%(7) |
PoTDC (potential temp data code) | 72 | 6 | T 6 | BT | TCols%(8) |
DynHtB (bottle dynamic height) | 73 | 8 | 6.4 | BU | DySVACols%(1) |
DynHt (CTD dynamic meters) | 74 | 8 | 6.4 | BV | DySVACols%(2) |
DyHDC (dynamic height data code) | 75 | 6 | T 6 | BW | DySVACols%(3) |
SVAB (bottle specific vol anomaly) | 76 | 9 | 7.3 | BX | DySVACols%(4) |
SVA (CTD specific volume anomaly) | 77 | 9 | 7.3 | BY | DySVACols%(5) |
SVADC (specific volumne data code) | 78 | 6 | T 6 | BZ | DySVACols%(6) |
RecInd (record indicator) | 79 | 6 | I 1 | CA | BtlCols%(7) |
O2Flsk (O2 volumetric flask #) | 80 | 6 | I 4 | CB | OCols%(15) |
O2DrwT (bottle O2 draw temperature C) | 81 | 6 | 4.1 | CC | OCols%(16) |
DIC_Btl# (DIC sample bottle #) | 82 | 10 | I 4 (x2) | CD | BtlCols%(8) |
DIC (Dissolved Inorganic Carbon) | 83 | 6 | 6.2 | CE | BtlCols%(9) |
TTL_ALK (Total Alkalinity) | 84 | 6 | 6.2 | CF | BtlCols%(10) |
OxBuM (bottle oxygen; uM/kg) | 85 |
7 |
5.3 | CG | OCols%(10) |
Ox1uM (1° CTD oxygen; uM/kg) | 86 | 7 | 5.3 | CH | OCols%(11) |
Ox2uM (2° CTD oxygen; uM/kg) | 87 | 7 | 5.3 | CI | OCols%(12) |
OuMDC (oxygen data code) | 88 | 6 | T 6 | CJ | OCols%(13) |
OuMPI (oxygen point-check index) | 89 | 6 | T 6 | CK | OCols%(14) |
CESL Comments (cast & sampling remarks from sample drawing) | 90 | 25+ | Text | CL | BtlCols%(11) |
Additional Comments; O2 Datatype (Ox1S or C, Ox2S or C) | 91 | 20+ | Variable | CM | BtlCols%(12) |
TO_DO | 92 | 10+ | Variable | CN | BtlCols%(13) |
Station CSV Data Source Color Code | ||||||||
Station & Bottle information: originates from CESL (CalCOFI Electronic Sample Log), csv filesave routine | ||||||||
Bottle Data: originates & updated by DECODR's data salinity, oxygen, nutrient, chlorophyll, & prodo data processing modules | ||||||||
Bottle Salinity Data: generates & updated by DECODR's salinity data processing modules | ||||||||
Bottle Oxygen Data: originates & updated by DECODR's oxygen data processing module | ||||||||
Bottle Nutrient Data: originates & updated by DECODR's nutrient data processing module | ||||||||
Bottle Chlorophyll/Phaeopigment Data: originates & updated by DECODR's chlorophyll data processing module | ||||||||
Bottle Productivity Data: originates & updated by DECODR's primary productivity data processing module | ||||||||
Bottle Derived Data: calculated bottle data generated by DECODR | ||||||||
CTD data: 4-second-prior-to-bottle-closure-average Seasoft Bottle Summary .BTL data, populated by DECODR's [CTD to CSV] module. | ||||||||
CTD data: 1m binavg Seasave processed upcast CTD data; preliminary used for point-checking then updated with final bottle-corrected CTD data for online publication; populated by DECODR's [CTD to CSV] module using BtlvsCTD created CTD.csvs. | ||||||||
Data Codes (*DC) & Point-checking Index: added during sample drawing by CESL or data processing, point-checking and examination. Data Codes are used to build the final Data Reports, IEH & database files from the best data collected. Point-checking indexes are used to flag certain data conditions when point-checking. |