a16s_2005a_hy1_all_Carbon_Final_20110824.csv submitted by Alex Kozyr
on 2011-08-24 containing carbon data merged into online file using
merge_exchange_bot.rb (J Fields)

The following changes were made to the original file:
none

The following changes were made to the submission file:
following instructions from Alex Kozyr:
PCO2 units changed from 'UATM@20' to 'UATM'
added PCO2TMP column with units 'DEG C' and value 20
PH changed to PH_SWS and units from 'SWS@25C' to ''
added PH_TMP column with units 'DEG C' and value 25

The following parameters were merged:
PCO2
PCO2_FLAG_W
PCO2TMP
PH_SWS
PH_SWS_FLAG_W
PH_TMP
ALKALI
ALKALI_FLAG_W
TCARBN
TCARBN_FLAG_W
DOC
DOC_FLAG_W

Merge results
Station 1, Cast 1, BTLNBR 24 DOC_FLAG_W changed from 2 to 9
Station 11, Cast 1, BTLNBR 1 DOC changed from 40.11 to  -999.00
Station 11, Cast 1, BTLNBR 1 DOC_FLAG_W changed from 2 to 9
Station 11, Cast 1, BTLNBR 2 DOC changed from -999.00 to    40.11
Station 11, Cast 1, BTLNBR 2 DOC_FLAG_W changed from 9 to 2
Station 13, Cast 1, BTLNBR 9 DOC changed from 47.40 to  -999.00
Station 13, Cast 1, BTLNBR 9 DOC_FLAG_W changed from 2 to 9
Station 13, Cast 1, BTLNBR 35 DOC changed from -999.00 to    47.40
Station 13, Cast 1, BTLNBR 35 DOC_FLAG_W changed from 9 to 2
Station 37, Cast 1, BTLNBR 25 DOC changed from 45.60 to  -999.00
Station 37, Cast 1, BTLNBR 25 DOC_FLAG_W changed from 2 to 9
Station 37, Cast 1, BTLNBR 26 DOC changed from -999.00 to    45.60
Station 37, Cast 1, BTLNBR 26 DOC_FLAG_W changed from 9 to 2
Station 105, Cast 1, BTLNBR 21 DOC changed from 39.70 to  -999.00
Station 105, Cast 1, BTLNBR 21 DOC_FLAG_W changed from 2 to 9
Station 105, Cast 1, BTLNBR 22 DOC changed from -999.00 to    39.70
Station 105, Cast 1, BTLNBR 22 DOC_FLAG_W changed from 9 to 2
Station 121, Cast 1, BTLNBR 20 DOC changed from 42.52 to  -999.00
Station 121, Cast 1, BTLNBR 20 DOC_FLAG_W changed from 2 to 9
Station 121, Cast 1, BTLNBR 21 DOC changed from -999.00 to    42.52
Station 121, Cast 1, BTLNBR 21 DOC_FLAG_W changed from 9 to 2

All comment lines from original file copied back into new file following merge

NetCDF bottle file created using exbot_to_netcdf.pl (S Diggs)

WOCE bottle file created using exchange_to_wocebot.rb (J Fields),
added cruise information and datestamp to header

NetCDF and Exchange files opened in JOA with no apparent problems

Working directory:
/data/co2clivar/atlantic/a16/a16s_2005a/original/2011.08.25_carbon_cberys

This submission from Alex came in via email, I submitted it and put it
in the queue for A16S (33RO200501). It has different DOC flag values
as well as unit and header changes to PH and PCO2, and needs to be
checked for other possible discrepancies.

The latest version of the A16s 2005 bottle file contains the
following updates:
  1. DOC data submitted by Alex Kozyr 20060313.  These data were
  in a whitespace seperated format, I changed this to csv for merging
  purposes.  These data merged without issue.
  2. C13 and C14 data submitted by Bob Key 20081203.  The DELC13
  data was submitted with 3 decimal places. These values were rounded
  to 2 decimals according to the CCHDO parameter description.
  3.  CDOM data submitted by Norm Nelson 20080618.  Stations 5 and 52
  were incorrectly labeled as cast 1.  After an email exchange with
  Dr. Nelson these two stations were changed to cast 2.

Shari *did* submit HCFCs and other halocarbons as well.
They were submitted on 08.07.14

Here are the latest update on the Carbon Data status at CCHDO and CDIAC.

A16S_2005:
TCO2 - OK;
TALK - OK;
pCO2 - OK;
pH - OK;
DOC - data not merged in CCHDO files (data sent to CCHDO on 3/16/2006).

Made a text version of the cruise report to go on the CCHDO website
Added CCHDO Data Processing Notes to text and PDF versions of the cruise report.

On March 15 this year I submitted the final DOC data for repeat sections P02_2004 and A16S_2005 I received from Dennis Hansell of RSMAS. I don't see these data have been merged in the hydrographic file at CCHDO for each above cruise yet. Could you please tell me the DOC data merging status at CCHDO and let me know as soon as these data will be merged.

In the following message (just to Steve and Alex), I'm sending the final carbon system parameters: DIC, TAlk, pCO2 discrete, and pH bottle data from the repeat hydrography cruise A16S.
This includes the DIC and pCO2 data from AOML(Wanninkhof), and TAlk and pH data from RSMAS (Millero).  The data has been extensively quality controlled and, in my view, is the best 4-parameter C-system dataset ever produced at sea.

We'll submit the underway pCO2 data to Alex next week.

I have attached a summary of status of final data submission. Several groups have their final bottle data ready but have not submitted it yet. I'll send an inspirational message to all PI's next week to do so.

All but the netCDF CTD files are now up and linked to the web for the a16s 2005 cruise.  PDF cruise doc is up as well and it looks like Sarilee was able to put the newly merged bottle file(s) online.

Most of our data can be found on [our website].  The part that is missing is the underway data that I will post/link shortly.

The data on the website is the data that everyone provided Frank before they left the ship.  Its needs to undergo final QC and inclusion of metadata.  A comprehensive cruise report which will serve as the source of metadata for much of the measurements was, coincidentally, sent to all participants and PIs this morning.  It will be placed on the website  in the third week of August.

As you know, the QC of bottle data is an iterative procedure that works best when done in an appropriate sequence with frequent updates.  On the ship we discussed the possibility that this could be done through the database that Frank Delahoyde created and maintained.  I have not followed up on with Frank and Jim [Swift] how this would be done and who would do it this but will do so shortly.

We will not be able to provide the final bottle data by the end of August but feel confident that it will be done by early winter.