-- CGC96 Master Database Version C-- This file is a chronology of changes and/additions to the master database for the CGC96 (Climate and Global Change '96) cruise. The database contains data from WOCE lines P14S (150 E) and P15S (170 W). This multi-legged cruise, conducted aboard the NOAA Ship DISCOVERER, was part of the U.S. JGOFS Program in the Southern Ocean and the U.S. WOCE Hydrographic Program (WHP), supported jointly by NOAA, NSF, and DOE. 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 September, 2000 have been incorporated in Version C: UNITS FOR THE CGC96 CRUISE Last Field Name Units Modified ==================================================================== 1. STATION Station Number integer June 1997 2. KEYFIELD Concatenation of Station Number and Sample Number integer June 1997 3. LATITUDE Decimal Deg June 1997 4. LONGITUDE Decimal Deg June 1997 5. PRESSURE CTD Pressure Decibar Sept 2000 6. SALINITY Bottle Salinity PSS-78 Sept 2000 7. FSALINITY QC Flag for Bottle Salinity character Sept 2000 8. TEMP CTD Temperature Deg C Sept 2000 9. THETA Potential Temperature Deg C Sept 2000 10. SIGMATHETA Potential Density Sept 2000 11. O2 Bottle Oxygen umol/kg Sept 2000 12. FO2 QC Flag for O2 character Sept 2000 13. AOU Apparent Oxygen Utilization umol/kg Sept 2000 14. PO4 Phosphate umol/kg April 2000 15. FPO4 QC Flag for PO4 character April 2000 16. NO2 Nitrite umol/kg April 2000 17. FNO2 QC Flag for NO2 character April 2000 18. NO3 Nitrate umol/kg April 2000 19. FNO3 QC Flag for NO3 character April 2000 20. SIO4 Silicate - SI(OH)4 umol/kg April 2000 21. FSIO4 QC Flag for SIO4 character April 2000 22. TCO2 Total CO2 umol/kg May 2000 23. FTCO2 QC Flag for TCO2 character May 2000 24. TALK Total Alkalinity umol/kg June 2000 25. FTALK QC Flag for TALK character June 2000 26. FCO220C Fugacity of CO2 at 20 C uatm May 2000 27. FCO2INSITU Fugacity of CO2 at Potential Temp uatm May 2000 28. FFCO2 QC Flag for FCO2 data character May 2000 29. PH Acidity real number June 2000 30. FPH QC Flag for PH character June 2000 31. CFC11 Chlorofluorocarbon-11 pmol/kg Sept 2000 32. FCFC11 QC Flag for CFC11 character Sept 2000 33. CFC12 Chlorofluorocarbon-12 pmol/kg Sept 2000 34. FCFC12 QC Flag for CFC12 character Sept 2000 35. CFC113 Chlorofluorocarbon-13 pmol/kg Sept 2000 36. FCFC113 QC Flag for CFC13 character Sept 2000 37. CCL4 Carbon Tetrachloride pmol/kg Sept 2000 38. FCCL4 QC Flag for CCL4 character Sept 2000 39. TOC Total Organic Carbon umol/kg Sept 2000 40. FTOC QC Flag for TOC character Sept 2000 41. TON Total Organic Nitrogen umol/kg Sept 2000 42. FTON QC Flag for TON character Sept 2000 43. CTDOXY CTD Oxygen umol/kg Sept 2000 44. FCTDOXY QC Flag for CTDOXY character Sept 2000 45. CTDSAL CTD Salinity PSS-78 Sept 2000 46. FCTDSAL QC Flag for CTD Salinity character Sept 2000 47. BOTDEP Bottom Depth of Station Meters June 1997 48. MONTH integer June 1997 49. DAY integer June 1997 50. YEAR integer June 1997 51. SAMPNO Sample Number integer June 1997 52. FBOTTLE Niskin Bottle QC Flag character April 2000 The CGC96 dataset includes the following files: CGC96C.DBF, CGC96C.CSV, CGC96.DES and CGC96.QC where the DBF file contains the data in dBase format and the CSV file contains the data in comma-delimited format. The QC file contains the explanation of the quality control flags and the DES file is a chronological description of all changes/updates to the dataset. ================================================================== September 20, 2000 (Dr. Peng/B. Huss) The following is the file structure for Version C of the CGC96 database being released today. Structure for database: CGC96C.DBF Number of data records: 6089 Date of last update : 09/18/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 7 3 N 7 FSALINITY Numeric 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 Numeric 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 1 N 23 FTCO2 Character 1 N 24 TALK Numeric 7 1 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 Numeric 1 N 33 CFC12 Numeric 8 3 N 34 FCFC12 Numeric 1 N 35 CFC113 Numeric 8 3 N 36 FCFC113 Numeric 1 N 37 CCL4 Numeric 8 3 N 38 FCCL4 Numeric 1 N 39 TOC Numeric 9 2 N 40 FTOC Numeric 1 N 41 TON Numeric 7 2 N 42 FTON Numeric 1 N 43 CTDOXY Numeric 9 2 N 44 FCTDOXY Numeric 1 N 45 CTDSAL Numeric 7 3 N 46 FCTDSAL Numeric 1 N 47 BOTDEP Numeric 8 N 48 MONTH Numeric 2 N 49 DAY Numeric 2 N 50 YEAR Numeric 4 N 51 SAMPNO Numeric 3 N 52 FBOTTLE Character 1 N ** Total ** 255 September 18, 2000 (B. Huss) Modified database to include CCL4 and FCCL4. Merged CCL4 and FCCL4 from Extdat.out18 into the database. September 1, 2000 (B. Huss) Updated PRESSURE, SALINITY, FSALINITY, TEMP, THETA, SIGMATHETA, O2, FO2, AOU, CFC11, FCFC11, CFC12, FCFC12, CFC113, FCFC113, TOC, FTOC, TON, FTON, CTDOXY, AND CTDSAL from Extdat.out18 (John Bullister). Converted TOC and TON from umol/l to umol/kg. June 25, 2000 (B. Huss) Changed FFCO2 to "3" for keyfield 143134. June 15, 2000 (B. Huss) TALK update received from Xuewi Lui (Dr. Millero). Merged into the database. June 15, 2000 (B. Huss) PH update received from Wensheng Yao. Merged into the database. May 10, 2000 (B. Huss) TCO2 update received from Marilyn Roberts. Merged into the database. May 5, 2000 (B. Huss) Removed CHLORA and PHAEO from database (there wasn't CTD bottle data for these fields). May 3, 2000 (B. Huss) TCO2 update received from Marilyn Roberts. Merged into the database. May 1, 2000 (B. Huss) For this updated version of fco2(20) and fco2(situ) only the QC flags were changed. All pco2 values remain unchanged from the previous version (11/98). Additional QC was performed by the following procedure: Dana Greeley performed internal consistency calculations using the Lewis program and calculated TA(TC,fCO2) and TA(TC,pH) and {(TA(meas) - TA(TC,fCO2)} and {TA(meas) - TA(TC,pH)}. Esa Peltola imported the data into Ocean Data View and made plots of fCO2, TC, TA, and {TA(meas) - TA(TC,fCO2)} versus depth. Four consecutive stations were plotted on one graph. Rik Wanninkhof flagged the outliers. See notes from 11/98 for previous QC performed. April 25, 2000 (B. Huss) Extracted the bottle QC flag from Extdat.out14; updated FBOTTLE using this data. April 22, 2000 (B. Huss) Merged the nutrient update (received from Calvin Mordy 4/18/2000) April 20, 2000 (B. Huss) Merged the pH update (received from Wensheng Yao 4/18/2000). April 17, 2000 (B. Huss) Merged TCO2 update (received update from Marilyn Roberts). May 30, 1999 (Dr. Peng/B. Huss) RELEASE - VERSION B of the database released today. May 20, 1999 (B. Huss) Converted TON from umol/l to umol/kg. May 15, 1999 (B. Huss) Restructured record structure. Converted TOC from umol/l to umol/kg. April 1, 1999 (B. Huss) Added CFC113 and FCFC113 to the database. January 14, 1999 (B. Huss) Updated TON and FTON (QC flag). November 1, 1998 (B. Huss) Updated CFC11, FCFC11, CFC12, and FCFC12. November 15, 1998 (B. Huss) Updated FCO220C and FCO2INSITU (calculated using Dickson and Millero constants) and QC flag. QC flags were assigned the following procedure: (1) Enter QC flag at the time of measurement. (2) Correct QC flags when reducing data by using DIC, potential temperature, salinity and nutrients data. (3) Correct QC flags by plotting fCO2 against Depth. (4) Correct QC flags by plotting fCO2 against DIC. (5) Correct QC flags by plotting fCO2 against pH. (6) Correct QC flag based on internal consistency check based on pCO2(TC,TA), pCO2(TC,pH), and pCO2(TA,TC). TC, TA, and pH were the values in version A. The relative error of fCO2 measurement by GC in this cruise is 0.65% based on 33 set duplication samplings from the same niskin. The confidence level is 68.3%. August 19, 1998 (B. Huss) Merged Dr. Millero's TALK data into the database. Data received from Kitack Lee. September 17, 1997 (B. Huss) Extracted the nutrient data from Extdat.out5 and merged this update into the master database. August 26, 1997 (B. Huss) Extracted CTDPRES, CTDTEMP, THETA, CTDSAL, FCTDSAL, SALINITY, FSALINITY, CTDOXY, FCTDOXY, O2, FO2 AND SIGMATHETA from Extall.out4. Remerged this data into the database. Recalculated AOU and DEPTH using this update and merged this data into the database. Added a QC flag for AOU and FAOU is initialized to the value of FO2. If theta, sigma0, or salinity is -9.0 then FAOU is initialized to 9. August 20, 1997 (B. Huss) Merged final CTD/bottle data into database (CTDPRES, CTDTEMP, THETA, CTDSAL, FCTDSAL, SALINITY, FSALINITY, CTDOXY, FCTDOXY, O2, FO2, and SIGMATHETA). Recalculated AOU from the updated CTD data. July 25, 1997 (B. Huss) Calculated depth from pressure and merged depths into the database. Calculated AOU and merged AOU into the database.