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 |