-- 24N98 Master Database -- This file is a chronology of changes and/additions to the master database for the 24 North 1998 cruise which took place from late January thru February, 1998. The database contains preliminary data. AOU DATA The apparent oxygen utilization, AOU (micromol/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 micromol/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. PLEASE NOTE the following updates have been received but not incorporated in the current version. The most recent version with these updates can be obtained from Betty Huss (huss@aoml.noaa.gov). None - all data received up to June 26, 2000 have been incorporated in Version C. 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 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 character 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 character May 9, 2000 13. AOU Apparent Oxygen Utilization umol/kg May 10, 2000 14. PO4 Phosphate umol/kg June 26, 2000 15. FPO4 QC Flag for PO4 character June 26, 2000 16. NO2 Nitrite umol/kg June 26, 2000 17. FNO2 QC Flag for NO2 character June 26, 2000 18. NO3 Nitrate umol/kg June 26, 2000 19. FNO3 QC Flag for NO3 character June 26, 2000 20. SIO4 Silicate - SI(OH)4 umol/kg June 26, 2000 21. FSIO4 QC Flag for SIO4 character June 26, 2000 22. TCO2 Total CO2 umol/kg May 3, 2000 23. FTCO2 QC Flag for TCO2 character May 3, 2000 24. TALK Total Alkalinity umol/kg April 5, 2000 25. FTALK QC Flag for TALK character April 5, 2000 26. FCO220C Fugacity of CO2 at 20 C uatm May 9, 2000 27. FCO2INSITU Fugacity of CO2 at Potential Temp uatm May 9, 2000 28. FFCO2 QC Flag for FCO2 data character May 9, 2000 29. PH Acidity real number April 5, 2000 30. FPH QC Flag for PH character April 5, 2000 31. CFC11 Chlorofluorocarbon-11 pmol/kg May 11, 2000 32. FCFC11 QC Flag for CFC11 character May 11, 2000 33. CFC12 Chlorofluorocarbon-12 pmol/kg May 11, 2000 34. FCFC12 QC Flag for CFC12 character May 11, 2000 35. CFC13 Chlorofluorocarbon-13 pmol/kg Aug 19, 1999 36. FCFC13 QC Flag for CFC13 character Aug 19, 1999 37. CC14 Aug 19, 1999 38. FCC14 QC Flag for CC14 character Aug 19, 1999 39. TOC Total Organic Carbon umol/kg May 8, 2000 40. TON Total Organic Nitrogen umol/kg May 8, 2000 41. CTDSAL CTD Salinity PSS-78 May 9, 2000 42. CTDOXY CTD Oxygen umol/kg May 9, 2000 43. FCTDOXY QC Flag for CTDOXY character May 9, 2000 44. BOTDEP Bottom Depth integer May 10, 2000 45. MONTH integer Aug 19, 1999 46. DAY integer Aug 19, 1999 47. YEAR integer Aug 19, 1999 48. FBOTTLE Bottle QC Flag character Aug 19, 1999 The data file accompanying this file has the basic structure of 24N98X.DBF, where the X represents the most recent change in an alphabetical format. This file you are now reading should always accompany the master datafile. Other accompanying files should be a .QC (for quality control flags) file and a .CSV (comma-delimited) file. The most recent changes are described immediately following this sentence. ================================================================== May 12, 2000 (Dr. Peng/B. Huss) The following is the file structure for version C of the 24N98 database being released today. Structure for database: 24N98.DBF Number of data records: 4381 Date of last update : 06/26/00 Field Field Name Type Width Dec Index 1 STATION Numeric 3 N 2 KEYFIELD Numeric 6 N 3 LATITUDE Numeric 9 4 N 4 LONGITUDE Numeric 9 4 N 5 PRESSURE Numeric 8 1 N 6 SALINITY Numeric 8 3 N 7 FSALINITY Character 1 N 8 TEMP Numeric 7 3 N 9 THETA Numeric 7 3 N 10 SIGMATHETA Numeric 8 3 N 11 O2 Numeric 9 2 N 12 FO2 Character 1 N 13 AOU Numeric 8 2 N 14 PO4 Numeric 8 3 N 15 FPO4 Character 1 N 16 NO2 Numeric 8 2 N 17 FNO2 Character 1 N 18 NO3 Numeric 8 2 N 19 FNO3 Character 1 N 20 SIO4 Numeric 8 2 N 21 FSIO4 Character 1 N 22 TCO2 Numeric 8 2 N 23 FTCO2 Character 1 N 24 TALK Numeric 7 2 N 25 FTALK Character 1 N 26 FCO220C Numeric 8 1 N 27 FCO2INSITU Numeric 8 1 N 28 FFCO2 Character 1 N 29 PH Numeric 8 4 N 30 FPH Character 1 N 31 CFC11 Numeric 8 3 N 32 FCFC11 Character 1 N 33 CFC12 Numeric 8 3 N 34 FCFC12 Character 1 N 35 CFC13 Numeric 8 3 N 36 FCFC13 Character 1 N 37 CC14 Numeric 8 3 N 38 FCC14 Character 1 N 39 TOC Numeric 9 2 N 40 TON Numeric 9 2 N 41 CTDSAL Numeric 8 3 N 42 CTDOXY Numeric 9 2 N 43 FCTDOXY Character 1 N 44 BOTDEP Numeric 8 N 45 MONTH Numeric 2 N 46 DAY Numeric 2 N 47 YEAR Numeric 4 N 48 FBOTTLE Character 1 N ** Total ** 253 June 26, 2000 (B. Huss) Received nutrient update from Dr. Zhang and merged the data into the database. 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 database. May 10, 2000 (B. Huss) Recalculated THETA and AOU using the updated CTD data. Merged data into the database. 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 database. 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 database 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 database. May 3, 2000 (B. Huss) Received the TCO2 update from Marilyn Roberts. Merged into the database. 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 database. Received the data from Dr. Millero. January 15, 2000 (Dr. Peng/B. Huss) Release of Version B of the database. January 12, 2000 (B. Huss) Merged O2, FO2, CTDSAL, CTDOXY, FBOTTLE (bottle qc flag) update into the database. January 5, 2000 (B. Huss) Merged TCO2 into the master database. Received the data from Marilyn Roberts. August 19, 1999 (Dr. Peng/B. Huss) Release of Version A of the 24N98 database. August 13, 1999 (B. Huss) Calculated THETA, SIGMATHETA, and AOU.