===============================================================================
I05 2009 33RR20090320 processing - BTL/merge - PH
===============================================================================

2012-12-06

C Berys

.. contents:: :depth: 2

Submission
==========

================================== ============== ========== ============= ===================
filename                           submitted by   date       data type     id
================================== ============== ========== ============= ===================
i05_33RR20090320_final_pH.hy1.csv  Alex Kozyr     2012-09-24 PH            887
================================== ============== ========== ============= ===================

Parameters
----------

i05_33RR20090320_final_pH.hy1.csv
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

- PH_TOT [1]_

.. [1] parameter has quality flag column.

Process
=======

Changes
-------

i05_33RR20090320_final_pH.hy1.csv
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

- none

i05_33RR20090320_hy1.csv
~~~~~~~~~~~~~~~~~~~~~~~~

- 2400 changed to 0000 for TIME

Merge
-----

i05_33RR20090320_final_pH.hy1.csv
~~~~~~~~~~~~~~~~~~
Merged i05_33RR20090320_final_pH.hy1.csv into i05_33RR20090320_hy1.csv
using merge_exchange_bot.rb (J Fields).

:Updated parameters: PH_TOT, PH_TOT_FLAG_W

All comment lines from original file copied back in following merge.
i05_33RR20090320_hy1.csv opened in JOA with no apparent problems.

Conversion
----------

============================ ==================================== =================================
file                         converted from                       software
============================ ==================================== =================================
i05_33RR20090320_nc_hyd.zip  i05_33RR20090320_hy1.csv             hydro 0.7.1
i05_33RR20090320hy.txt       i05_33RR20090320_hy1.csv
exchange_to_wocebot.rb (J Fields)
============================ ==================================== =================================

Exchange and NetCDF files opened in JOA with no apparent problems.

Directories
===========
:working directory:
  /data/co2clivar/indian/i05/i05_33RR20090320/original/2012.12.05_ph_cberys
:cruise directory:
  /data/co2clivar/indian/i05/i05_33RR20090320/

Updated Files Manifest
======================
- i05_33RR20090320_hy1.csv
- i05_33RR20090320_nc_hyd.zip
- i05_33RR20090320hy.txt

The final pH values were sent to CDIAC by Andrew Dickson on 09/14/2012. Please, merge the data and add the information on pH in the header of this file as follows: 
pH: Who - B.Carter;A Dickson; Status - final  
	Notes: Total H+ scale at 20C
	pH values are estimated using the constants of Liu et al. (2011) with an adjustment for the use of unpurified dye.
	See Liu et al. and Carter et al.

2012-03-08
I05 2009 ExpoCode 33RR20090320 merge notes - CFC
C Berys

SUBMISSION

33RR20090320_i05_2009_cfc_sent_to_CCHDO_5_march_2012.txt submitted by
John Bullister on 2012-03-05 containing CFC data update merged into
online file using merge_exchange_bot.rb (J Fields)

The following parameters were added (* with flag):
 CFC-11*
 CFC-12*
 SF6*

The following changes were made to the submission file:
  file changed into csv
  parameters and units changed to match parameter table
  -9.000 changed to -999.000

ORIGINAL
The following changes were made to the original Exchange Bottle file:
 none

MERGED FILE
All comment lines from original file copied back in following merge
NetCDF bottle file created using exbot_to_netcdf.pl (S Diggs)
WOCE bottle file created using exchange_to_wocebot.rb (J Fields)
Exchange and NetCDF files opened in JOA with no apparent problems

working directory
  /data/co2clivar/indian/i05/i05_33RR20090320/original/20112.03.08_cfc_cberys

SUBMISSION

TALK_final_33RR20090320_CLIVAR_I05.csv submitted by Alex Kozyr on
2011-12-08 containing ALKALI data merged into online file using
merge_exchange_bot.rb (J Fields)

The following parameters were added (* with flag):
  ALKALI*

The following changes were made to the submission file:
  added CASTNO in accordance with sum file
  station 93, cast 1, bottle 36:
      PH_TOT_FLAG_W changed to 4 (bad bottle)
      DOC_FLAG_W changed to 4 (bad bottle)
  station 109, cast 1, bottle 18:
      PH_TOT_FLAG_W changed to 4 (bad bottle)
      DOC_FLAG_W changed to 4 (bad bottle)
      TDN_FLAG_W changed to 4 (bad bottle)

ORIGINAL
The following changes were made to the original Exchange Bottle file:
  CFC-11 empty data changed from -9 to -999
  CFC-12 empty data changed from -9 to -999
  SF6 empty data changed from -9 to -999

MERGED FILE
All comment lines from original file copied back in following merge
NetCDF bottle file created using exbot_to_netcdf.pl (S Diggs)
WOCE bottle file created using exchange_to_wocebot.rb (J Fields)
Exchange and NetCDF files opened in JOA with no apparent problems

Working directory:
/data/co2clivar/indian/i05/i05_33RR20090320/original/2011.12.08_alkali_cberys

Name: Kozyr, Alex
Institute: CDIAC/ORNL
Country: USA
Expo: 33RR20090320 Line: I05_2009
Date: 2009-03-20 
Action: Merge Data, Place Online, Updated Parameters
Notes: Here are the TCARBN final and public data and QC flags we received from Chris Sabine and Richard Feely/ PMEL. Please, let me know when the data will be merged.

New cruise reports, pdf and txt, are now online.  They have updated CFC reports and expanded Data Processing Notes.

Please replace all shipboard CFC-11, CFC-12 and SF6 data values and flags with these data

Updates made to the following bottle data: 
O2, Thio normality smoothing applied to stations 166-195.

Additional evaluations applied to the following nutrient sample stations.

Comments in third column.

4401  1   ??? Sta 45 instead
6901  2   "new pump tubes, sw-dw low, correct end po4 baseline for jump at end of run"
7001  1   "sw-dw low, adjust baselines down and recalc"
7102      "adjust N+N, po4 end baselines for jumps after reagents added, adjust po4 baselines for low sw-dw"
7201  1   ??? Not seen sta 07102?
7401  2   "std-sw values possibly low, reprocess with avg factors from the previous run"
7701  2   reprocess ignoring last dw
7801  1   end std-dw high use beginning factor for begin and end
7901  1   reprocess ignoring 3rd std at end
8001  2   std-sw low use avg factor from 08102
10001 1   std-sw possibly too high/new pump tubes reprocess using avg factor from 10101
10501 2   reprocessed ignore last dw
13701 1   end std-sw high use beginning factor
14502 2   std-sw low use avg factor from 14401
14601 2   beginning std-sw low use end factor
15101 1   use beginning factor
15901 1   std-sw high use avg factor from 15801
16601 2   ignore 2nd sw at end of run
16801 1   ignore 2nd std at end of run

This file should replace existing hy1 file with missing depths and alkalinity data.

Action: Place Online
Notes: Previous submissions from J.Swift did not have the complete bottle data set which included end of cruise data set.

Looking at the version of the I5 bottle data that is online at the WHPO, there are no nutrient data for stations 193, 194, 195.  Based on the sum file, this is accurate for 195, but the sum file indicates that there should be nutrient data for 193 and 194, also CFC, carbon, etc etc.  It looks like only salts and oxygens were merged for those stations.

Both the PDF and text versions of the complete cruise report are now online.

Action: new PDF documentation file from J. Kappa

Changes will be 
forthcoming:  (1) the WHP-Exchange bottle data file will soon be 
updated to include the PI contact and data citation information, and 
(2) the preliminary documentation file is currently being modified to 
more closely fit the CCHDO standard.

The CTDO, salinity, oxygen, and nutrient data are very close to final 
form and are likely suitable as is for research purposes.

As is always the case, the shipboard ocean carbon parameter data 
(TCARBN, TALK, pH) now on line must be considered strictly 
preliminary.  These data will be examined by Alex Kozyr at CDIAC, and 
he and the carbon PIs will later (6-12 months from now?) provide an 
updated file to the CCHDO to replace the present ocean carbon 
parameter data.  It is very strongly urged that any research use of 
the shipboard ocean carbon parameters include close collaboration 
with the data originators (Feely, Wanninkhof, and Dickson).

The present CFC (F-11 and F-12) and SF6 data are preliminary and 
subject to update (within a year?), and should be used for research 
purposes only in close collaboration with the data originators 
(Bullister and Warner).