enzh-CNfrdeeliwitjakorues

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.

Station CSV File Format (since 16-Mar-2015; color key at the bottom)
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.

 

Go to top
Our website is protected by DMC Firewall!