-- 24N98 Master Datafile Version E -- This file is a chronology of changes and/additions to the master datafile for the 24 North 1998 cruise which took place from late January thru February, 1998. The datafile contains the final data. AOU DATA The apparent oxygen utilization, AOU (umol/kg) is calculated as the solubility for oxygen at the measured salinity and potential temperature minus the observed oxygen concentration. The solubility for oxygen at the measured salinity and potential temperature is determined from the algorithms presented in Weiss (1970). Note that at low temperature, the solubility determined by Weiss is up to 2 umol/kg higher than determined by Benson and Krause (1984) or Garcia and Gordon (1992). Weiss, R.F., The solubility of nitrogen, oxygen and argon in water and seawater, Deep-Sea Research, 17, 721-735, 1970. TALK Data Total alkalinity (TALK) is calculated using spectroscopic pH (25ºC) and coulometric TCO2 using the carbonic acid dissociation constants of Mehrbach et al. (1973) as refit by Dickson and Millero (1987). The value of 1.2 umol/kg has been subtracted from calculated total alkalinity (CTALK) values because calculated values are 1.2 umol/kg higher than measured values. PLEASE NOTE: All data received up to August 12, 2005 have been incorporated into Version D. UNITS FOR THE 24N98 CRUISE Last Field Name Units Modified ==================================================================== 1. STATION Station Number integer May 9, 2000 2. KEYFIELD Concatenation of Station Number and Niskin Bottle Number integer May 9, 2000 3. LATITUDE Decimal Deg Aug 19, 1999 4. LONGITUDE Decimal Deg Aug 19, 1999 5. PRESSURE CTD Pressure Decibar May 9, 2000 6. SALINITY Bottle Salinity PSS-78 May 9, 2000 7. FSALINITY QC Flag for Bottle Salinity integer May 9, 2000 8. TEMP CTD Temperature Deg C May 9, 2000 9. THETA Potential Temperature Deg C May 10, 2000 10. SIGMATHETA Potential Density May 9, 2000 11. O2 Bottle Oxygen umol/kg May 9, 2000 12. FO2 QC Flag for O2 integer May 8, 2001 13. AOU Apparent Oxygen Utilization umol/kg May 10, 2000 14. PO4 Phosphate umol/kg June 26, 2000 15. FPO4 QC Flag for PO4 integer June 26, 2000 16. NO2 Nitrite umol/kg June 26, 2000 17. FNO2 QC Flag for NO2 integer June 26, 2000 18. NO3 Nitrate umol/kg June 26, 2000 19. FNO3 QC Flag for NO3 integer May 8, 2001 20. SIO4 Silicate - SI(OH)4 umol/kg June 26, 2000 21. FSIO4 QC Flag for SIO4 integer May 8, 2001 22. TCO2 Total CO2 umol/kg August 28, 2000 23. FTCO2 QC Flag for TCO2 integer May 8, 2001 24. TALK Total Alkalinity umol/kg Oct 30, 2000 25. CTALK Calculated Alkalinity umol/kg April 12, 2001 26. FTALK QC Flag for TALK integer Oct 30, 2000 27. FCO220C Fugacity of CO2 at 20 C uatm May 9, 2000 28. FCO2INSITU Fugacity of CO2 at Potential uatm May 9, 2000 29. FFCO2 QC Flag for FCO2 data integer May 9, 2000 30. PH Acidity real number April 5, 2000 31. FPH QC Flag for PH integer April 5, 2000 32. CFC11 Chlorofluorocarbon-11 pmol/kg May 11, 2000 33. FCFC11 QC Flag for CFC11 integer May 11, 2000 34. CFC12 Chlorofluorocarbon-12 pmol/kg May 11, 2000 35. FCFC12 QC Flag for CFC12 integer May 11, 2000 36. CFC113 Chlorofluorocarbon-13 pmol/kg Sept. 18, 2000 37. FCFC113 QC Flag for CFC113 integer Sept. 18, 2000 38. CCL4 Carbon Tetrachloride pmol/kg Sept. 18, 2000 39. FCCL4 QC Flag for CCL4 integer Sept. 18, 2000 40. Delta C-14 Delta C-14 0/00 Aug. 15, 2005 41. c14e uncertainty in value 0/00 Aug. 15, 2005 42. FC-14 QC Flag for Delta C-14 integer Aug. 15, 2005 43. Delta C-13 Delta C-13 0/00 Aug. 31, 2005 44. FC-13 Qc Flag for Delta C-13 integer Aug. 31, 2005 45. TOC Total Organic Carbon umol/kg May 8, 2000 46. FTOC QC Flag for TOC integer May 8, 2001 47. TON Total Organic Nitrogen umol/kg May 8, 2000 48. FTON QC Flag for TON integer May 8, 2001 49. CTDSAL CTD Salinity PSS-78 May 9, 2000 50. CTDOXY CTD Oxygen umol/kg May 9, 2000 51. FCTDOXY QC Flag for CTDOXY integer May 9, 2000 52. BOTDEP Bottom Depth integer May 10, 2000 53. MONTH integer Aug 19, 1999 54. DAY integer Aug 19, 1999 55. YEAR integer Aug 19, 1999 56. FBOTTLE Bottle QC Flag integer Aug 19, 1999 The 24N98 dataset includes the following files: 24N98D.CSV, 24N98.QC, and 24N98.DES where the CSV file contains the data in comma- delimited format, the QC file contains the explanation of the WOCE quality control flags and the DES file is a chronological description of all changes/updates to the dataset. ================================================================== May 12, 2001 (Dr. Peng/B. Huss) The following is the file structure for version D of the 24N98 datafile being released today. Structure for datafile: 24N98D.CSV Number of data records: 4381 Date of last update : 5/15/2005 Field Field Name Type Width Dec 1 STATION Numeric 3 2 KEYFIELD Numeric 6 3 LATITUDE Numeric 9 4 4 LONGITUDE Numeric 9 4 5 PRESSURE Numeric 8 1 6 SALINITY Numeric 8 3 7 FSALINITY Integer 1 8 TEMP Numeric 7 3 9 THETA Numeric 7 3 10 SIGMATHETA Numeric 8 3 11 O2 Numeric 9 2 12 FO2 Integer 1 13 AOU Numeric 8 2 14 PO4 Numeric 8 3 15 FPO4 Integer 1 16 NO2 Numeric 8 2 17 FNO2 Integer 1 18 NO3 Numeric 8 2 19 FNO3 Integer 1 20 SIO4 Numeric 8 2 21 FSIO4 Integer 1 22 TCO2 Numeric 8 2 23 FTCO2 Integer 1 24 TALK Numeric 7 2 25 CTALK Numeric 7 2 26 FTALK Integer 1 27 FCO220C Numeric 8 1 28 FCO2INSITU Numeric 8 1 29 FFCO2 Integer 1 30 PH Numeric 8 4 31 FPH Integer 1 32 CFC11 Numeric 8 3 33 FCFC11 Integer 1 34 CFC12 Numeric 8 3 35 FCFC12 Integer 1 36 CFC113 Numeric 8 3 37 FCFC113 Integer 1 38 CCL4 Numeric 8 3 39 FCCL4 Integer 1 40 Delta C-14 Numeric 5 1 41 c14e Numeric 5 1 42 FC-14 Integer 1 43 Delta C-13 Numeric 6 2 43 TOC Numeric 9 2 44 FTOC Integer 1 45 TON Numeric 9 2 46 FTON Integer 1 47 CTDSAL Numeric 8 3 48 CTDOXY Numeric 9 2 49 FCTDOXY Integer 1 50 BOTDEP Numeric 8 51 MONTH Numeric 2 52 DAY Numeric 2 53 YEAR Numeric 4 54 FBOTTLE Integer 1 August 15, 2005 (B. Huss) Merged the c14e and delta C-14 data from Bob Key into the datafile. C14e is the uncertainty (error) in the value. The scientists responsible for collecting and analyzing the data are Bob Key, Ann McNichol, and Paul Quay. May 8, 2001 (B. Huss) Added QC Flags for TOC and TON. Modified FO2 for sample number 4401 modified FTCO2 for sample number 8502, and FNO3, FSIO4 and FTCO2 for sample number 10601. April 13, 2001 (B. Huss) Added a new field called CTALK (Calculated TALK) and merged the calculated TALK data into the datafile. Update received from Kitack Lee. October 30, 2000 (B. Huss) Changed TALK and FTALK for sample numbers 8401, 8402 and 8403 (station 84). September 20, 2000 (Dr. Peng/B. Huss) Version C of the 24N98 datafile was released today. September 18, 2000 (B. Huss) Merged the CFC113 and CCL4 (carbon tetrachloride) update into the datafile. Received data from John Bullister. August 28, 2000 (B. Huss) Merged TCO2 update into the datafile. Received data from Marilyn Roberts. June 26, 2000 (B. Huss) Received nutrient update from Dr. Zhang and merged the data into the datafile. May 13, 2000 (B. Huss) Changed all longitude values to negative (East). May 11, 2000 (B. Huss) Received CFC11 and CFC12 update from John Bullister. Merged the data into the datafile. May 10, 2000 (B. Huss) Recalculated THETA and AOU using the updated CTD data. Merged data into the datafile. May 9, 2000 (B. Huss) Changed TALK QC flags for sample numbers 1301, 9007, 9421, 10221, and 10225 to 3 (questionable). Corrected pH values for sample numbers 12621 and 13006. May 9, 2000 (B. Huss) Received the final fCO2 update from Rik. Merged the data into the datafile. In February 2000, Kitack Lee noticed an offset in the fCO2 data. It was associated with using the wrong tank calibration value. This data was reduced using the right standard (508.35). Thus 547.37 was replaced by 508.38 in the program. Then it was run against all data files again. The quality of the data was checked performing an internal consistency check of DIC, TALK by fCO2. Outliers in fCO2 were labelled a "3". May 9, 2000 (B. Huss) Added station 1. Added TCO2 and fCO2 data for station 1. Modified datafile to include a bottom depth field and entered the bottom depths. May 9, 2000 (B. Huss) Received CTD data. This data was extracted from the file 24nbottle2.dat obtained from Molly Baringer. This is considered the final CTD and O2 data. NOTE: Station 39 trip information was reconstructed from the calibrated CTD data upcast. Values should be considered questionable. Full data file with conductivities and information from both sensors can be obtained from Molly Baringer, baringer@aoml.noaa.gov. May 8, 2000 (B. Huss) Received TON update from Dennis Hansell. Converted TON and TOC from umol/L to umol/kg and merged the data into the datafile. May 3, 2000 (B. Huss) Received the TCO2 update from Marilyn Roberts. Merged into the datafile. May 1, 2000 (B. Huss) Merged the nutrient update (received from Calvin Mordy). April 28, 2000 (B. Huss) Merged the pCO2 update (received from Rik Wanninkhof). April 5, 2000 (B. Huss) Merged the TALK and pH update into the datafile. Received the data from Dr. Millero. January 15, 2000 (Dr. Peng/B. Huss) Release of Version B of the datafile. January 12, 2000 (B. Huss) Merged O2, FO2, CTDSAL, CTDOXY, FBOTTLE (bottle qc flag) update into the datafile. January 5, 2000 (B. Huss) Merged TCO2 into the master datafile. Received the data from Marilyn Roberts. August 19, 1999 (Dr. Peng/B. Huss) Release of Version A of the 24N98 datafile. August 13, 1999 (B. Huss) Calculated THETA, SIGMATHETA, and AOU.