A station csv (sta.csv) is generated for each hydrographic station occupied during a cruise. Bottle data records for each depth are built & populated during sample analysis and data processing.
Column Label | Col # | Width | format | Spreadsheet Cell |
---|---|---|---|---|
Cruise (YYMM) | 1 | 6 | T 4 | A |
Line (CalCOFI Line LL.L) | 2 | 6 | 4.1 | B |
Station (CalCOFI Sta SSS.S) | 3 | 7 | 5.1 | C |
Ord_Occ (order occupied) | 4 | 7 | I 5 | D |
Event (event log #) | 5 | 7 | I 5 | E |
Date_PST (CTD cast date) | 6 | 13 | DD-MMM-YYYY | F |
Time_PST (CTD cast time, at depth) | 7 | 10 | HH:MM:SS | G |
Nis (niskin bottle #) | 8 | 5 | I 3 | H |
Samp (sample #) | 9 | 5 | I 3 | I |
Depth (depth, meters) | 10 | 7 | 6.1 | J |
StdLvl (Standard Level indicator) | 11 | 6 | T 3 | K |
DPTHNT (depth note(s)) | 12 | 6 | T 6 | L |
Press (CTD pressure db) | 13 | 7 | 6.1 | M |
T1degC (1° temperature) | 14 | 8 | 6.3 | N |
T2degC (2° temperature) | 15 | 8 | 6.3 | O |
TDC* (temperature data code) | 16 | 6 | T 6 | P |
TPI* (temperature point-check index) | 17 | 6 | I 6 | Q |
SaltB (bottle salinity) | 18 | 9 | 7.4 | R |
Salt1 (1° CTD salinity) | 19 | 9 | 7.4 | S |
Salt2 (2° CTD salinity) | 20 | 9 | 7.4 | T |
SDC (salinity data code) | 21 | 6 | T 6 | U |
SPI (salinity point-check index) | 22 | 6 | I 6 | V |
OxB (bottle oxygen) | 23 | 7 | 5.3 | W |
Ox1 (1° CTD oxygen) | 24 | 7 | 5.3 | X |
Ox2 (2° CTD oxygen) | 25 | 7 | 5.3 | Y |
ODC (oxygen data code) | 26 | 6 | T 6 | Z |
OPI (oxygen point-check index) | 27 | 6 | I 6 | AA |
PO4 (bottle sample phosphate) | 28 | 6 | 4.2 | AB |
SIL (bottle sample silicate) | 29 | 6 | 5.2 | AC |
NO2 (bottle sample nitrite) | 30 | 6 | 4.2 | AD |
NO3 (bottle sample nitrate) | 31 | 6 | 4.1 | AE |
NDC (nutrient data code) | 32 | 6 | T 6 | AF |
NPI (nutrient point-check index) | 33 | 6 | I 6 | AG |
NH3 (bottle sample ammonia) | 34 | 6 | 4.2 | AH |
NHDC (NH3 data code) | 35 | 6 | T 6 | AI |
NHPI (NH3 point-check index) | 36 | 6 | I 6 | AJ |
N:P (Nitrate:Phosphate Ratio) | 37 | 6 | 5.2 | AK |
Chl-a (bottle chlorophyll) | 38 | 7 | 6.3 | AL |
Phaeo (bottle phaeopigments) | 39 | 7 | 6.3 | AM |
CPDC (chl-a, phaeopigment data code) | 40 | 6 | T 6 | AN |
CPPI (chl-a, phaeopigment point-check index) | 41 | 6 | I 6 | AO |
%Light (prodo %light level) | 42 | 8 | 5.3 | AP |
C14A (C14 assim. light sample a) | 43 | 8 | 6.3 | AQ |
C14B (C14 assim. light sample b) | 44 | 8 | 6.3 | AR |
C14ave (C14 assim., light samples a & b, averaged) | 45 | 8 | 6.3 | AS |
C14D (C14 assim. dark sample) | 46 | 8 | 5.3 | AT |
C14DC (C14 data code) | 47 | 6 | T 6 | AU |
C14PI (C14 point-check index) | 48 | 6 | I 6 | AV |
Uptake (C14.ave.assim/chla) | 49 | 9 | AW | |
SCIN_DPM-A (Scintillation counts) | 50 | 10 | 9.2 | AX |
SCN%EFF-A (Scintillation Efficiency) | 51 | 7 | 5.2 | AY |
SCIN_DPM-B (Scintillation counts) | 52 | 10 | 9.2 | AZ |
SCN%EFF-B (Scintillation Efficiency) | 53 | 7 | 5.2 | BA |
SCIN_DPM-D (Scintillation counts) | 54 | 10 | 9.2 | BB |
SCN%EFF-D (Scintillation Efficiency) | 55 | 7 | 5.2 | BC |
SCIN_BLANK | 56 | 8 | 6.2 | BD |
SPEC_ACTIVITY | 57 | 7 | 5.2 | BE |
S-thetaB (bottle sigma-theta) | 58 | 8 | 7.4 | BF |
S-theta1 (CTD 1° sigma-theta) | 59 | 8 | 7.4 | BG |
S-theta2 (CTD 2° sigma-theta) | 60 | 8 | 7.4 | BH |
StDC (sigma-theta data code) | 61 | 6 | T 6 | BI |
OxSatB (bottle oxygen %saturation) | 62 | 7 | 6.2 | BJ |
OxSat1 (CTD 1° oxygen %saturation) | 63 | 7 | 6.2 | BK |
OxSat2 (CTD 2° oxygen %saturation) | 64 | 7 | 6.2 | BL |
OxSDC (ox saturation data code) | 65 | 6 | T 6 | BM |
PoTB (bottle potential temperture) | 66 | 9 | 7.4 | BN |
PoT1 (CTD 1° potential temp) | 67 | 9 | 7.4 | BO |
PoT2 (CTD 2° potential temp) | 68 | 9 | 7.4 | BP |
PoTDC (potential temp data code) | 69 | 6 | T 6 | BQ |
DynHtB (bottle dynamic height) | 70 | 8 | 6.4 | BR |
DynHt (CTD dynamic meters) | 71 | 8 | 6.4 | BS |
DyHDC (dynamic height data code) | 72 | 6 | T 6 | BT |
SVAB (bottle specific vol anomaly) | 73 | 9 | 7.3 | BU |
SVA (CTD specific volume anomaly) | 74 | 9 | 7.3 | BV |
SVADC (specific volumne data code) | 75 | 6 | T 6 | BW |
RecInd (record indicator) | 76 | 6 | I 1 | BX |
O2Flsk (O2 volumetric flask #) | 77 | 6 | I 4 | BY |
O2DrwT (bottle O2 draw temperature C) | 78 | 6 | 4.1 | BZ |
DIC_Btl# (DIC sample bottle #) | 79 | 10 | I 4 (x2) | CA |
DIC (Dissolved Inorganic Carbon) | 80 | 6 | 6.2 | CB |
TTL_ALK (Total Alkalinity) | 81 | 6 | 6.2 | CC |
OxBuM (bottle oxygen; uM/kg) | 82 |
7 |
5.3 | CD |
Ox1uM (1° CTD oxygen; uM/kg) | 83 | 7 | 5.3 | CE |
Ox2uM (2° CTD oxygen; uM/kg) | 84 | 7 | 5.3 | CF |
OuMDC (oxygen data code) | 85 | 6 | T 6 | CG |
OuMPI (oxygen point-check index) | 86 | 6 | T 6 | CH |
CESL Comments (cast & sampling remarks from sample drawing) | 87 (82,80) | 25+ | Text | CI |
Additional Comments; O2 Datatype (Ox1S or C, Ox2S or C) | 88 (83,81) | 20+ | Variable | CJ |
TO_DO | 89 (84,82) | 10+ | Variable | CK |
Station CSV Data Source Color Code | ||||||||
Station & Bottle information: CESL (CalCOFI Electronic Sample Log) CSV Filesave | ||||||||
Bottle Data: DECODR's data salinity, oxygen, nutrient, chlorophyll, & prodo data processing modules | ||||||||
CTD data: DECODR's [CTD to CSV] module, using 4sec Seasoft Bottle Summary .BTL data initially; final data from [CTD to CSV] using BtlvsCTD (bottle-corrected) CTD .CSV data. | ||||||||
Data Codes are added during data processing, point-checking and examination. They are used to build the final Data Reports, IEH & database files from the best data collected. | ||||||||
*DC = Data Code |