Files in the Dataset have been checked for format consistency, and merged into a single, integrated, downloadable file.
Download Entire Dataset Submit Data For This Cruise How to Cite DatasetFiles listed here are the most recent version submitted by the cruise scientists, but have not yet been checked for consistency and merged into the main Dataset. They are provided "as is". If you are unsure of which files to use, stick to the Dataset files above.
These files are not yet in the Dataset.
| Filename (Download) | Size | Date Submitted |
| Woosley et al 2014 Density data.xlsx | 227.6 kB | 2024-05-20 |
Generated from 33RO20071215_bottle.nc (42923)
Generated from 33RO20071215_bottle.nc (42923)
Generated from 33RO20071215_bottle.nc (42923)
File created in the CCHDO system
33RO20071215 processing - BTL
2025-03-25
Andrew Barna
Changes
* Removed quote characters in comment lines
* Updated citation information
33RO20071215_bottle.nc opened in ODV with no apparent problems.
Conversions
file converted from software
---------------------- -------------------- --------------------
33RO20071215_bottle.nc 33RO20071215_hy1.csv cchdo.hydro 1.0.2.12
Updated Files Manifest
file stamp
---------------------- -----------------
33RO20071215_bottle.nc 20230128CCHSIOAMB
From Ryan: The data is published in Woosley et al. (2014) DOI: 10.1016/j.dsr.2014.07.009 and as a table in my dissertation. I’m attaching the table, which also includes data from other CLIVAR/GO-SHIP cruises. I’m sure it needs some explanation and reformatting for CCHDO archiving. I’m happy to discuss with whom ever to make that happen.
CCHDO-1.0 CF netCDF files converted from bottle exchange file
CCHDO-1.0 CF netCDF files converted from ctd exchange file
33RO20071215 processing - BTL
2022-08-18
A Barna
Submissions
id submit date submitted by file name
----- ------------- -------------- --------------------
22001 33RO20071215_hy1.csv
Changes
* Add expected units /MILLE to DELSI30 (no data, flag 1s)
* Documented CDOM3C and CDOM2C in params DB
* Change O18-O2 to D18O_NO3 as per cruise report
* Change N15-N2 to N15N_NO3 as per cruise report
* Change units of N2 to expected UMOL/KG (no data, flag1s)
33RO20071215_hy1.csv and 33RO20071215_nc_hyd.zip opened in JOA with no apparent problems.
Conversions
note: converted and put online by C Berys
file converted from software
----------------------- -------------------- -----------------------
33RO20071215_nc_hyd.zip 33RO20071215_hy1.csv hydro 0.8.2-61-g3353cfe
33RO20071215hy.txt 33RO20071215_hy1.csv hydro 0.8.2-61-g3353cfe
Updated Files Manifest
file stamp
----------------------- -----------------
33RO20071215_hy1.csv 20220818CCHSIOAMB
33RO20071215_nc_hyd.zip 20220818CCHSIOAMB
33RO20071215hy.txt 20220818CCHSIOAMB
P18 2007 33RO20071215 processing - BTL/merge - tritium
2021-09-15
C Berys
Submissions
id date submit by file name
----- ---------- ------------- --------------------------
4740 2015-04-13 Robert Newton LDEO_NGL_CliVarTritium4CCHDO_P18S.xlsx
12083 2016-02-03 Bill Jenkins P18_2007_Tritiums.xlsx
12086 2016-02-03 Robert M. Key 33RO20071215.exc.csv
12116 existing file 33RO20071215_hy1.csv
Changes
* PH_SWS flag from 3 to 5 for fill values
* PH_SWS flag from 4 to 5 for fill values
note: PH_SWS has unresolved flag 9 for data values
Merges
note: this is a correction of merge from 2016-02-16. Duplicate identifiers were introduced and are corrected here.
* 33RO20071215.exc.csv (12086) merged into 33RO20071215_hy1.csv (12116) using hydro 0.8.2-61-g3353cfe
- Merged parameters: TRITUM TRITUM_FLAG_W TRITER
33RO20071215_hy1.csv, 33RO20071215_nc_hyd.zip opened in JOA with no apparent problems.
Conversions
file converted from software
----------------------- -------------------- -----------------------
33RO20071215_nc_hyd.zip 33RO20071215_hy1.csv hydro 0.8.2-61-g3353cfe
33RO20071215hy.txt 33RO20071215_hy1.csv hydro 0.8.2-61-g3353cfe
Updated Files Manifest
file stamp
----------------------- -----------------
33RO20071215_hy1.csv 20210915CCHSIOCBG
33RO20071215_nc_hyd.zip 20210915CCHSIOCBG
33RO20071215hy.txt
File created in the CCHDO system
File created in the CCHDO system
P18 2007,2008 33RO20071215 processing - CTD merge CTDBEAMCP into existing Exchange file
2017-11-27
CCHDO
Submission
filename submitted by date id
------------ ------------ ---------- -----
2007P181.TXT Wilf Gardner 2017-06-12 13492
2007P182.TXT Wilf Gardner 2017-06-01 12760
2007P181.TXT Wilf Gardner 2017-06-01 12758
Changes
-------
2007P181.TXT, ID 12758. Previous version of CTDBEAMCP data. Not used, labeled as merged
33RO20071215ct.zip
- moved to Data History because it is no longer up-to-date with the Exchange formatted file.
p18_33RO20071215_ct1.zip
- changed file names, including zip file, to conform to Exchange specifications
- merged CTDBEAMCP data from Wilf Gardner
- removed TRANS: no longer needed since CTDBEAMCP is available
- changed parameter name from FLUORM to CTDCDOMFRAW
- left CTDCDOMFRAW units as "V" - range is 0-0.59, so may not be 0-5VDC
- 58 Stations do not have CTDBEAMCP data to merge, so used fill values.
- added header and unit comments
- added cruise comments
- removed trailing comma from parameter and unit lines
- removed trailing comma from each data line
- changed header name SECT to SECT_ID
Conversion
----------
file converted from software
----------------------- -------------------- -----------------
33RO20071215_nc_ctd.zip 33RO20071215_ct1.zip 0.8.2-48-g594e1cb
Updated Files Manifest
----------------------
file stamp
--------------------- ----------------
33RO20071215_ct1.zip 20171127CCHSIO
33RO20071215_nc_ctd.zip 20171127CCHSIO
:Removed parameters: TRANS
:Merged parameters: CTDBEAMCP, CTDBEAMCP_FLAG_W
:Changed parameters: FLUOR renamed CTDCDOMFRAW
opened in JOA with no apparent problems:
33RO20071215_ct1.zip
33RO20071215_nc_ctd.zip
opened in ODV with no apparent problems:
33RO20071215_ct1.zip
Replaces previous submission of same name. W. Gardner CTDBEAMCP data
Wilf Gardner's CTDBEAMCP final data to be merged. Stations 98-2 to 153 (leg2)
Wilf Gardner's CTDBEAMCP final data to be merged. Stations 1-98, (leg1)
P18 2007 33RO20071215 processing - BTL/merge - Tritium
2016-02-16
C Berys
Submission
filename submitted by date id
---------------------------------------------------------------------
LDEO_NGL_CliVarTritium4CCHDO_P18S.xlsx Robert Newton 2015-04-13 4740
P18_2007_Tritiums.xlsx Bill Jenkins 2016-02-03 12083
33RO20071215.exc.csv Bob Key 2016-02-03 12086
Merge
LDEO_NGL_CliVarTritium4CCHDO_P18S.xlsx and P18_2007_Tritiums.xlsx merged into 33RO20071215.exc.csv by Bob Key, renamed to 33RO20071215_hy1.csv.
:Updated parameters: TRITIUM, TRITER, TRITIUM_FLAG_W
33RO20071215_hy1.csv opened in JOA with no apparent problems.
note: some unresolved flags for PH_SWS, HELIUM, DELHE3
Conversion
----------
file converted from software
--------------------------------------------------------------------
33RO20071215_nc_hyd.zip 33RO20071215_hy1.zip hydro 0.8.2-40-g569f4c2
33RO20071215hy.txt 33RO20071215_hy1.csv hydro 0.8.2-40-g569f4c2
Updated Files Manifest
----------------------
file stamp
-------------------------------------------
33RO20071215_hy1.csv 20160203PRINUNIVRMK
33RO20071215_nc_hyd.zip 20160203PRINUNIVRMK
33RO20071215hy.txt
This file contains the H3 data corrected for bottle cap contamination. Copies sent to Jenkins and CDIAC
33RO20071215.exc.csv available as received, submitted 2015-12-18 by Robert M. Key
notes: file contains Jenkins revised H3 data. 4 H3 flags changed (2 Jenkins, 2 Schlosser), so recommend entire column swap for H3, H3e and H3f. Flag changes cleared with PI
WHOI P18_2007 Tritium Resubmission.xlsx available as received, submitted 2015-11-30 by William Jenkins
Submission note: This is a resubmission of tritium data from the WHOI lab. The previously submitted data are in error due to a software bug.
File was created on or before this date
File was created on or before this date
File was created on or before this date
File was created on or before this date
File was created on or before this date
File was created on or before this date
File was created on or before this date
The following data are now available As Received, unprocessed by the CCHDO.
http://cchdo.ucsd.edu/cruise/33RO20071215
33RO20071215.exc.csv
Expocode: 33RO20071215 Ship: None Woce Line: P18S Note: Tritium measurements from the P18S repeat hydro cruise.
The following data are now available As Received, unprocessed by the CCHDO.
http://cchdo.ucsd.edu/cruise/33RO20071215
LDEO_NGL_CliVarTritium4CCHDO_P18S.xlsx
===================================================================
P18 2007 33RO20071215 processing - BTL/merge - HELIUM, DELHE3, NEON
===================================================================
2015-03-06
C Berys
.. contents:: :depth: 2
Submission
==========
====================== ============= =================== =============== ====
filename submitted by date data type id
====================== ============= =================== =============== ====
P18_LDEO_HeNed3He.xlsx Robert Newton 2014-11-10 00:00:00 data_suggestion 5653
====================== ============= =================== =============== ====
Parameters
----------
P18_LDEO_HeNed3He.xlsx
~~~~~~~~~~~~~~~~~~~~~~
- HELIUM [1]_ [4]_
- DELHE3 [1]_ [4]_
- NEON [1]_ [3]_ [4]_
- NEONER [3]_ [4]_
- HELIER [4]_
- DELHER [4]_
.. [1] parameter has quality flag column
.. [2] parameter only has fill values/no reported measured data
.. [3] not in WOCE bottle file
.. [4] merged, see merge_
Process
=======
Changes
-------
P18_LDEO_HeNed3He.xlsx
~~~~~~~~~~~~~~~~~~~~~~
- decimal places: HELIUM to 4, DELHE3 to 2, NEON to 3
- at station, cast, sample:
- 109, 1, 12
- 114, 1, 31
- 145, 1, 31
- 157, 1, 3
- 157, 1, 23
- HELIUM, HELIER data value to -999
- DELHE3, DELHE3 data value to -999, DELHE3_FLAG_W flag to 5
- NEON, NEONER to -999, NEON_FLAG_W to 5
- at station, cast, sample:
- 119, 1, 4
- 124, 1, 12
- 163, 1, 9
- HELIUM, HELIER data value to -999
- DELHE3, DELHE3 data value to -999
- NEON, NEONER to -999, NEON_FLAG_W to 5
.. _merge:
Merge
-----
P18_LDEO_HeNed3He.xlsx
~~~~~~~~~~~~~~~~~~~~~~
Merged P18_LDEO_HeNed3He.xlsx into 33RO20071215_hy1.csv using hydro 0.8.2-40-g569f4c2.
:Updated parameters: HELIUM, HELIER, HELIUM_FLAG_W, DELHE3, DELHER, DELHE3_FLAG_W, NEON, NEONER NEON_FLAG_W
All comment lines from original file copied back in following merge. 33RO20071215_hy1.csv opened in JOA with no apparent problems.
Conversion
----------
======================= ==================== =======================
file converted from software
======================= ==================== =======================
33RO20071215_nc_hyd.zip 33RO20071215_hy1.zip hydro 0.8.2-40-g569f4c2
33RO20071215hy.txt 33RO20071215_hy1.csv hydro 0.8.2-40-g569f4c2
======================= ==================== =======================
All converted files opened in JOA with no apparent problems.
Updated Files Manifest
======================
======================= =================
file stamp
======================= =================
33RO20071215_hy1.csv 20150305CCHSIOCBG
33RO20071215_nc_hyd.zip 20150305CCHSIOCBG
33RO20071215hy.txt
======================= =================
The following files are now available online under 'Files as received', unprocessed by the CCHDO.
P18_LDEO_HeNed3He.xlsx
Expocode: 33RO20071215 Ship: Brown Woce Line: P18 Note: Units of gas concentration and errors are nanomols per kilogram. Helium isotope ratios are reported in anomaly unites: d13He, which is percent difference from the air ratio.
Units of gas concentration and errors are nanomols per kilogram.
Helium isotope ratios are reported in anomaly unites: d13He, which is percent difference from the air ratio.
HELIUM/NEON
HE
===========================================================================
P18 2007 33RO20071215 processing - BTL/merge - TRITUM, HELIUM, DELHE3, NEON
===========================================================================
2014-02-07
C Berys
.. contents:: :depth: 2
Submission
==========
==================== ============= ========== =========== ====
filename submitted by date data type id
==================== ============= ========== =========== ====
33RO20071215.exc.csv Robert M. Key 2014-01-09 HELIUM/NEON 1121
==================== ============= ========== =========== ====
Parameters
----------
33RO20071215.exc.csv
~~~~~~~~~~~~~~~~~~~~
- CTDPRS
- CTDTMP
- CTDSAL
- SALNTY [1]_
- CTDOXY [1]_
- OXYGEN [1]_
- SILCAT [1]_
- NITRAT [1]_
- NITRIT [1]_
- PHSPHT [1]_
- CFC-11 [1]_
- CFC-12 [1]_
- SF6 [1]_
- TCARBN [1]_
- ALKALI [1]_
- PCO2 [1]_
- PCO2TMP
- PH_SWS [1]_
- PH_TMP
- TRITUM [1]_ [4]_
- TRITER [4]_
- HELIUM [1]_ [4]_
- DELHE3 [1]_ [4]_
- DELC13 [1]_
- NEON [1]_ [3]_ [4]_
- NEONER [3]_ [4]_
- CCL4 [1]_
- DOC [1]_
- TDN [1]_ [3]_
- CTDRAW [3]_
- CHLORA [1]_
- HELIER
- DELHER
- CDOM325 [1]_ [3]_
- CDOM340 [1]_ [3]_
- CDOM380 [1]_ [3]_
- CDOM412 [1]_ [3]_
- CDOM443 [1]_ [3]_
- CDOM490 [1]_ [3]_
- CDOM555 [1]_ [3]_
- CDOMSL [1]_ [3]_
- CDOMSN [1]_ [3]_
- THETA [3]_
.. [1] parameter has quality flag column
.. [2] parameter only has fill values/no reported measured data
.. [3] not in WOCE bottle file
.. [4] merged, see merge_
Process
=======
Changes
-------
p18_33RO20071215_hy1.csv
~~~~~~~~~~~~~~~~~~~~~~~~
- Citation for tritium and helium changed to William Jenkins, added neon
.. _merge:
Merge
-----
33RO20071215.exc.csv
~~~~~~~~~~~~~~~~~~~~
Merged 33RO20071215.exc.csv into p18_33RO20071215_hy1.csv using hydro 0.8.0-96-g8497d06.
:New parameters: HELIUM, HELIUM_FLAG_W, DELHE3, DELHE3_FLAG_W, DELHER, NEON, NEON_FLAG_W, NEONER
:Updated parameters: TRITUM, TRITUM_FLAG_W, TRITER
All comment lines from original file copied back in following merge. p18_33RO20071215_hy1.csv opened in JOA with no apparent problems.
Conversion
----------
=========================== ======================== =======================
file converted from software
=========================== ======================== =======================
p18_33RO20071215_nc_hyd.zip p18_33RO20071215_hy1.csv hydro 0.8.0-96-g8497d06
p18_33RO20071215hy.txt p18_33RO20071215_hy1.csv hydro 0.8.0-96-g8497d06
=========================== ======================== =======================
All converted files opened in JOA with no apparent problems.
Directories
===========
:working directory:
/data/co2clivar/pacific/p18/p18_33RO20071215/original/2014.02.07_TRITUM-HELIUM-NEON_CBG
:cruise directory:
/data/co2clivar/pacific/p18/p18_33RO20071215
Updated Files Manifest
======================
=========================== =================
file stamp
=========================== =================
p18_33RO20071215_nc_hyd.zip 20140107CCHSIOCBG
p18_33RO20071215hy.txt
p18_33RO20071215_hy1.csv 20140107CCHSIOCBG
=========================== =================
The following files are now available online under 'Files as received', unprocessed by the CCHDO.
33RO20071215.exc.csv
=============================
33RO20071215 processing - BTL
=============================
2014-01-11
R Lee
.. contents:: :depth: 2
Process
=======
Changes
-------
- Added instructions for citation use
Conversion
----------
=========================== ======================== =======================
file converted from software
=========================== ======================== =======================
p18_33RO20071215_nc_hyd.zip p18_33RO20071215_hy1.csv hydro 0.8.0-81-gc0a14ea
=========================== ======================== =======================
All converted files opened in JOA with no apparent problems.
Directories
===========
:working directory:
/data/co2clivar/pacific/p18/p18_33RO20071215/original/2014.01.12_Citation_RJL
:cruise directory:
/data/co2clivar/pacific/p18/p18_33RO20071215
Updated Files Manifest
======================
- p18_33RO20071215_nc_hyd.zip
- p18_33RO20071215_hy1.csv
Jenkins' H3, He, He3, Neon data
Expocode: 33RO20071215 Ship: Ron Brown Woce Line: P18 Note: Attn. Carolina, This file has Jenkins' H3, He, He3, Neon data merged. Prior to merge I corrected the duplicate mentioned in earlier e-mail (after hearing from Bill). I have not updated my copy from you since Jan. 13, so it would be best to strip Jenkins data from this file and then do a 1:1 row match with your current bottle file. Also, in the original file Bill submitted, the header "bottle" should be "sample". I used flags he supplied without alteration.
This file has Jenkins' H3, He, He3, Neon data merged. Prior to merge I corrected the duplicate mentioned in earlier e-mail (after hearing from Bill). I have not updated my copy from you since Jan. 13, so it would be best to strip Jenkins data from this file and then do a 1:1 row match with your current bottle file. Also, in the original file Bill submitted, the header "bottle" should be "sample". I used flags he supplied without alteration.
Tritium Data
============================================
33RO20071215 processing - BTL/merge - TRITUM
============================================
2014-01-06
C Berys
.. contents:: :depth: 2
Submission
==========
======================= ================= ========== ============ ===
filename submitted by date data type id
======================= ================= ========== ============ ===
Tritium Submission.xlsx William J Jenkins 2013-01-14 Tritium Data 947
======================= ================= ========== ============ ===
Parameters
----------
Tritium Submission.xlsx
~~~~~~~~~~~~~~~~~~~~~~~
- CTDPRS
- TRITUM [1]_ [4]_
- TRITER [4]_
p18_33RO20071215_hy1.csv
~~~~~~~~~~~~~~~~~~~~~~~~
- CTDPRS
- CTDTMP
- CTDSAL [1]_
- SALNTY [1]_
- CTDOXY [1]_
- OXYGEN [1]_
- SILCAT [1]_
- NITRAT [1]_
- NITRIT [1]_
- PHSPHT [1]_
- CFC-11 [1]_
- CFC-12 [1]_
- SF6 [1]_
- TCARBN [1]_
- ALKALI [1]_
- FCO2 [1]_
- FCO2TMP
- PH_SWS [1]_
- PH_TMP
- TRITUM [1]_ [4]_
- TRITER [4]_
- HELIUM [1]_ [2]_
- DELHE3 [1]_ [2]_
- DELC13 [1]_
- DELC14 [1]_ [2]_
- CCL4 [1]_
- POC [1]_ [2]_
- DOC [1]_
- TDN [1]_
- DON [1]_ [2]_
- CHLORA [1]_
- ARGON [1]_ [2]_
- CDOM325 [1]_
- CDOM340 [1]_
- CDOM380 [1]_
- CDOM412 [1]_
- CDOM443 [1]_
- CDOM490 [1]_
- CDOM555 [1]_
- CDOMSL [1]_
- CDOMSN [1]_
- THETA
- O18-O2 [1]_ [2]_
- CDOM2C [1]_ [2]_
- CDOM3C [1]_ [2]_
- LAB_DEN [1]_ [2]_
- DELSI30 [1]_ [2]_
- N2 [1]_ [2]_
- N15-N2 [1]_ [2]_
.. [1] parameter has quality flag column
.. [2] parameter only has fill values/no reported measured data
.. [3] not in WOCE bottle file
.. [4] merged, see merge_
Process
=======
Changes
-------
p18_33RO20071215_hy1.csv
~~~~~~~~~~~~~~~~~~~~~~~~
- NOTE: some PH data flagged 9
.. _merge:
Merge
-----
Tritium Submission.xlsx
~~~~~~~~~~~~~~~~~~~~~~~
Merged Tritium Submission.xlsx into p18_33RO20071215_hy1.csv using hydro 0.8.0-78-g3e6ecac.
:New parameters: TRITUM, TRITER, TRITUM_FLAG_W
:Updated parameters:
All comment lines from original file copied back in following merge. p18_33RO20071215_hy1.csv opened in JOA with no apparent problems.
Conversion
----------
=========================== ======================== =======================
file converted from software
=========================== ======================== =======================
p18_33RO20071215_nc_hyd.zip p18_33RO20071215_hy1.csv hydro 0.8.0-81-gc0a14ea
p18_33RO20071215hy.txt p18_33RO20071215_hy1.csv hydro 0.8.0-81-gc0a14ea
=========================== ======================== =======================
All converted files opened in JOA with no apparent problems.
Directories
===========
:working directory:
/data/co2clivar/pacific/p18/p18_33RO20071215/original/2014.01.06_TRITUM_CBG
:cruise directory:
/data/co2clivar/pacific/p18/p18_33RO20071215
Updated Files Manifest
======================
- p18_33RO20071215_nc_hyd.zip
- p18_33RO20071215hy.txt
- p18_33RO20071215_hy1.csv
The following files are now available online under 'Files as received', unprocessed by the CCHDO.
WHOI P18 Helium Submission.xlsx
The following files are now available online under 'Files as received', unprocessed by the CCHDO.
RH6 Heliums.xlsx
13C
===========================================================
33RO20071215 processing - BTL/merge - DELC13, DELC13_FLAG_W
===========================================================
2013-12-03
C Berys
.. contents:: :depth: 2
Submission
==========
======================================== ============ ========== ========= ===
filename submitted by date data type id
======================================== ============ ========== ========= ===
p18_33RO20071215_20120621_DelC13.hy1.csv Alex Kozyr 2012-06-21 13C 838
======================================== ============ ========== ========= ===
Parameters
----------
p18_33RO20071215_hy1.csv
~~~~~~~~~~~~~~~~~~~~~~~~
- CTDPRS
- CTDTMP
- CTDSAL [1]_
- SALNTY [1]_
- CTDOXY [1]_
- OXYGEN [1]_
- SILCAT [1]_
- NITRAT [1]_
- NITRIT [1]_
- PHSPHT [1]_
- CFC-11 [1]_
- CFC-12 [1]_
- SF6 [1]_
- TCARBN [1]_
- ALKALI [1]_
- FCO2 [1]_
- FCO2TMP
- PH_SWS [1]_
- PH_TMP
- TRITUM [1]_ [2]_
- HELIUM [1]_ [2]_
- DELHE3 [1]_ [2]_
- DELC13 [1]_ [4]_
- DELC14 [1]_ [2]_
- CCL4 [1]_
- POC [1]_ [2]_
- DOC [1]_
- TDN [1]_
- DON [1]_ [2]_
- CHLORA [1]_
- ARGON [1]_ [2]_
- CDOM325 [1]_
- CDOM340 [1]_
- CDOM380 [1]_
- CDOM412 [1]_
- CDOM443 [1]_
- CDOM490 [1]_
- CDOM555 [1]_
- CDOMSL [1]_
- CDOMSN [1]_
- THETA
- O18-O2 [1]_ [2]_
- CDOM2C [1]_ [2]_
- CDOM3C [1]_ [2]_
- LAB_DEN [1]_ [2]_
- DELSI30 [1]_ [2]_
- N2 [1]_ [2]_
- N15-N2 [1]_ [2]_
.. [1] parameter has quality flag column
.. [2] parameter only has fill values/no reported measured data
.. [3] not in WOCE bottle file
.. [4] merged, see merge_
Process
=======
Changes
-------
p18_33RO20071215_hy1.csv
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
* DOC flag from 9 to 2 at:
- station 7, cast 1, sample 20, bottle 11020 value 53.54
- station 40, cast 1, sample 27, bottle 12026 value 45.09
- station 146, cast 1, sample 2, bottle 12007 value 39.49
.. _merge:
Merge
-----
p18_33RO20071215_20120621_DelC13.hy1.csv
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Merged p18_33RO20071215_20120621_DelC13.hy1.csv into p18_33RO20071215_hy1.csv using hydro 0.8.0-68-gcae40dc.
:New parameters:
:Updated parameters: DELC13, DELC13_FLAG_W
All comment lines from original file copied back in following merge. p18_33RO20071215_hy1.csv opened in JOA with no apparent problems.
Conversion
----------
=========================== ======================== =======================
file converted from software
=========================== ======================== =======================
p18_33RO20071215_nc_hyd.zip p18_33RO20071215_hy1.csv hydro 0.8.0-68-gcae40dc
p18_33RO20071215hy.txt p18_33RO20071215_hy1.csv hydro 0.8.0-68-gcae40dc
=========================== ======================== =======================
All converted files opened in JOA with no apparent problems.
Directories
===========
:working directory:
/data/co2clivar/pacific/p18/p18_33RO20071215/original/2013.12.03_DELC13_CBG
:cruise directory:
/data/co2clivar/pacific/p18/p18_33RO20071215
Updated Files Manifest
======================
- p18_33RO20071215_nc_hyd.zip
- p18_33RO20071215hy.txt
- p18_33RO20071215_hy1.csv
Helium
Expocode: 33RO20071215 Ship: Ron Brown Woce Line: P18 Note: Please ignore most recent submission (the wrong file was sent in error). Please use this one. (Sorry, Bill)
Your submitted file:
RH6 Heliums.xlsx
will be public.
The following actions were specified:
Place Online, Merge Data
Further information collected with your submission:
Id: 1083
Institute: Woods Hole Oceanographic Institution
Country: U.S.A.
ExpoCode: 33RO20071215 Line: P18
Date: 2007-12-15
Tritium data, uncertainty, and flags are final and public
Expocode: 33RO20071215 Ship: Brown Woce Line: P18 2007 Note: Tritium data, uncertainty, and flags are final and public
Tritium data, uncertainty, and flags are final and public
The following files are now available online under 'Files as received', unprocessed by the CCHDO.
Tritium Submission.xlsx
The following files are now available online under 'Files as received', unprocessed by the CCHDO.
p18_CFC_cruise_report_to_CCHDO_2Mayl2011.doc
The following files are now available online under 'Files as received', unprocessed by the CCHDO.
p18_33RO20071215_20120621_DelC13.hy1.csv
The final and public Del C13 data from Paul Quay, received on June 14, 2012
Expocode: 33RO20071215 Ship: R/V Ronald H. Brown Woce Line: P18_2007 Note: The final and public Del C13 data from Paul Quay, received on June 14, 2012. The data were merged in CDIAC file.
The final and public Del C13 data from Paul Quay, received on June 14, 2012. The data were merged in CDIAC file.
P18 was a cruise that was not funded for 13C or 14C measurements, so we did the 13C measurements when ever we had time.
I've attached an Excel spreadsheet with the del13C data reported in per mille (o/oo) versus PDB, with the standard WOCE QC codes in the adjacent column. There are no 14C measurements on these samples.
2011-12-15
P18 2008 ExpoCode 33RO20071215 merge notes - SILCAT
C Berys
SUBMISSION
p18_nutrients_111214.csv submitted by Eric Wisegarver on 2011-12-15 containing SILCAT data merged into online file using merge_exchange_bot.rb (J Fields)
This replaced previous submission from 2011-12-12. Previous submission was in the wrong units (umol / liter) and has been resubmitted with correct units (umol / kg)
The following parameters were added (* with flag):
SILCAT*
The following changes were made to the submission file:
added first header row and END_DATA as last row
removed blank lines
removed blank column
ORIGINAL
The following changes were made to the original Exchange Bottle file:
none
MERGED FILE
All comment lines from original files 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
NOTE: NetCDF does not include POC
Working directory:
/data/co2clivar/pacific/p18/p18_33RO20071215/original/2011.12.15_nuts_cberys
Previous file submitted had silica values in umol/l not umol/kg.
NUTS
SUBMISSION
p18_nutrients.csv submitted by Eric Wisegarver on 2011-12-12
containing SILCAT data merged into online file using
merge_exchange_bot.rb (J Fields)
The following parameters were added (* with flag):
SILCAT*
The following changes were made to the submission file:
added first header row and END_DATA as last row
ORIGINAL
The following changes were made to the original Exchange Bottle file:
none
MERGED FILE
All comment lines from original files copied back in following merge
NetCDF bottle file created using exbot_to_netcdf.pl (S Diggs)
WOCE bottle file not created without accompanying SUM file
Exchange and NetCDF files opened in JOA with no apparent problems
NOTE: NetCDF does not include POC
Working directory:
/data/co2clivar/pacific/p18/p18_33RO20071215/original/2011.12.14_nuts_cberys
Nutrients
Expocode: 33RO20071215 Ship: Ronald H. Brown Woce Line: P18 Note: None
File p18_nutrients.csv containing nutrients data, submitted
by Eric Wisegarver on 2011-12-12, available under 'Files as received',
unprocessed by CCHDO.
"Notes on p18_2007 bottle file modifications. EXPOCODE 33RO20071215 201111130/dm
1. Removed CTDRAW, PCO2, both PCO2_FLAG_Ws & PCO2TMP.
2. Changed parameter name DENSITY to LAB_DEN per R. Key suggestion.
3. Changed missing value flags:
Station 7, Cast 1 Sample 5 ALKALI flag from 2 to 9
Station 7, Cast 1 Sample 21 DOC flag from 2 to 9
Station 67, Cast 1 Sample 17 HELIUM flag from 2 to 9
Station 141, Cast 1 Sample 3 PH_SWS flag from 2 to 9
Station 149, Cast 1 Sample 10 PH_SWS flag from 2 to 9
Flag "1"s for missing values left as is for now.
4. Exchange file FCO2 is read by Java OceanAtlas 5.0.2 as FCO2TMP and does not give the FCO2TMP value.
This should be corrected in the next update of Java OceanAtlas."
NetCDF file FCO2 looks okay in JOA 5.0.2.
In the p18_33RO20071215_hy1.csv file, 'DENSITY' indicates seawater samples collected in 125 cc polyethylene bottles for Frank Millero (at RSMAS)
(see section 3.18 of the data report).
My understanding is that these samples were to be shipped to RSMAS for experiments in Millero's lab to study the effects of the variation in the composition of seawater on seawater density.
To avoid confusing this with sigma0, maybe the name should be changed from 'density' to something like 'lab_density' of 'lab_den'
The file p18_33RO20071215_hy1.csv uses -999.0 for the null value but the file p18_33RO20071215_hy.txt uses two values for null (-999.0 and -9.0)
Other files at the website also use two different values (-999.0 and -9.0) for null in the same file, eg:
a13.5_33RO20100308_hy1.csv
a13.5_33RO20100308hy.txt
p06_318M20091121_hy1.csv
p06_318M20091121hy.txt
p06_318M20100105_hy1.csv
p06_318M20100105hy.txt
Ideally, there should be a single null value used consistently for all parameters in all files at the website.
In any case, no file should have multiple values for null in the same file- this creates problems when uploading data into ODV etc.
pH
Submission from Alex Kozyr p18_2007_PH_20101116_25C.csv made on
2010-11-17 containing pH values and flags merged into online file
using merge_exchange_bot.rb (J Fields)
The following changes were made:
FCO2_TMP changed to FCO2TMP in the original file
PH_TEMP changed to PH_TMP in the submission file
PH_FLAG changed to PH_SWS_FLAG_W in the submission file
The following parameters were merged:
PH_SWS
PH_TMP
PH_SWS_FLAG_W
All comment lines from original file copied back into new file following merge
NetCDF bottle file created using exbot_to_netcdf.pl (S Diggs), files zipped
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/pacific/p18/p18_33RO20071215/original/20110513_p18_ph_cberys
CrsRpt
Bullister's CFC report of 2011-05-02 has been merged into the text and pdf versions of the online cruise reports.
Updates to CFC section in the Cruise documentation
Expocode: 33RO20071215 Ship: Ronald H. Brown Woce Line: P18 Note: I noticed that the CFC section (3.3) of the cruise report at the website has not been updated. Please replace it with the attached file. Thanks
I noticed that the CFC section (3.3) of the cruise report at the website has not been updated.
Please replace it with the attached file.
File p18_2007_PH_20101116_25C.csv containing pH data, submitted
by Alex Kozyr on 2010-11-17, available under 'Files as received',
unprocessed by CCHDO.
revised pH_SWS, PH_TEMP, and PH_FLAG_W data sent by Frank Millero at RSMAS
Expocode: 33RO20071215 Ship: Ronald Brown Woce Line: p18_2007 Note: revised pH_SWS, PH_TEMP, and PH_FLAG_W data sent by Frank Millero at RSMAS
Action: Place Online, Updated Parameters
Notes: revised pH_SWS, PH_TEMP, and PH_FLAG_W data sent by Frank Millero at RSMA
File: p18_33RO20071215_hy1.csv datestamp: 20100913CCHDOSIOCBG
original moved to: original/p18_33RO20071215_rplcd_20100913_hy1.csv
Citations added by A. Barna
Formatted using copy_exchange_bot.rb (J. Fields)
working directory: original/2010.09.13_P18_citation_CBG/
FC02 was submitted by Alex Kozyr by email on
July 14. I merged the FCO2, FCO2_TMP, and FCO2_FLAG_W
columns into the current file without issue. After merging
I created a netcdf bottle file as well. The new exchange
bottle file and netcdf bottle file are now online.
Action: Merge Data
Notes: Alex Kozyr submitted these FCO2 updates by email. From his email: here is attached the final and
public FCO2 data we received from Rik Wanninkhof (AOML) for cruise
33RO20071215 P18_2007. Please, merge the data and let me know when merging is
done. Please, note that the header for this parameter it FCO2, not PCO2 as it
is now in the .hy file online (per Rik) with FCO2_TMP and FCO2_FLAG_W
columns.
? Changed PI for C13/C14 to Paul Quay
? Updated Data Processing Notes
The seawater samples that John collected on P18 for 13C and 14C analyses are in my lab. Since I don't have funding for the 13C (or 14C) analyses on this cruise, the sample processing has a lower priority and will happen slowly. Thus, there are no 13C or 14C data to report at this time.
Notes on P18_2007 merge Mar-May,2009/dm (EXPOCODE 33RO20071215):
WOCE format (20080925CCHDODM) and EXCHANGE format (20080925dm) bottle
files have been modified.
1) Carbon data merged from file p18_2007_DIC_TALK_PH_DOC_TDN_2008
received from Alex Kozyr, ORNL, on Nov 18, 2008
[TCARBN, ALKALI,PH_SWS,DOC,TDN] (TDN is new parameter)
2) CFC data merged from file
CLIVAR_P18_CFCS_SF6_sentto_CCHDO_12Nov2008.txt received from John
Bullister, PMEL, on Nov 11, 2008
CFC-11, CFC-12, CCL4 & SF6 all reported to 4 decimal places in
data file.
CCHDO precision for CFCs & CCL4 is 3 places so data were merged to
3 places.
CCHDO precision for SF6 not specified so SF6 data merged to 4
places. Previous cruises had SF6 data to 2 places. Left as is for now.
3) Nutrient data merged from file P18_Nutrients_umol-kg.txt received
from Calvin Mordy, PMEL, on Nov 21, 2008
PHSPHT, SILCAT, NITRAT, NITRIT]
4) CDOM data merged from file ucsb_cdom_p18_s7a_20090130.txt received
from Norman Nelson, UCSB, on Feb 2, 2009
[CDOM325, CDOM340, CDOM380, CDOM412, CDOM443, CDOM490, CDOM555,
CDOMSL, CDOMSN]
(CDOM2C & CDOM3c were in original bottle file with all missing
data; no new data received.)
- About 50 sampling levels had CDOMs in shipboard data set but
not in the Feb 2, 2009, file.
- I replaced the ones I could find with -9s and Quality Flags 5
per Norm Nelson message April 8,2009.
5) The Exchange format file, p18_33RO20071215_hy1.csv, was checked
with Java Ocean Atlas.
The WOCE format file, p18_33RO20071215hy.txt, was checked with the
new WOCE to Exchange format program.
6) No data have been received yet for the following parameters:
TRITUM, HELIUM, DELHE3, DELC14, DELC13, O18-O2, ARGON, DON,
CDOM2C, CDOM3C, POC, DENSITY, DELSI30, N2 and N15-N2
Expect no data for DON since it is derived from TDN, NITRAT and
NITRIT per Craig Carlson, UCSB, msg of April 8, 2009.
7) Expect updated PCO2 soon from AOML.
Expocode: 33RO20071215 Ship: R/V Ronald H. Brown Woce Line: P18, S4P Note: None
Name: Mordy, Calvin
Institute: NOAA/PMEL
Country: USA
Expo: 33RO20071215 Line: P18
Date: 2007-12-15
Action: Merge Data, Place Online, Updated Parameters
Action: Merge Data, Place Online
Notes: Here are the final and public TCO2, TALK, pH, DOC, and TDN data. Please, discard a previous submission of these parameters. I will receive the discrete pCO2 measurements soon from Rik Wanninkhof and will send you the numbers separately. Please, let me know when you done with merging these parameters.
I just uploaded a file of the CLIVAR P18 final CFC-11, CFC-12, carbon tetrachloride and sulfur hexafluoride data to the CCHDO website.
Name: Kozyr, Alex
Institute: CDIAC/ORNL
Country: USA
Expo: 33RO20071215 Line: P18_2007
Date: 2007-12-15
Action: Merge Data, Place Online
Notes: here are the final DIC (TCO2), TALK, DOC, and TDN data for the merge into the hydro file.
Parameters reported:
CDOM325 [1/M] Absorption coefficient of CDOM at 325 nm
CDOM340 [1/M] Absorption coefficient of CDOM at 340 nm
CDOM380 [1/M] Absorption coefficient of CDOM at 380 nm
CDOM412 [1/M] Absorption coefficient of CDOM at 412 nm
SLOG [1/NM] Log spectral slope of absorption spectrum (320-400 nm) computed by linear regression of log-transformed data
SNLF [1/NM] Log spectral slope of absorption spectrum (320-400 nm) computed by non-linear curve fit
These spectroscopic data have been recalibrated based on the UCSB Ultrapath calibration 7a, 2008. They supersede data reported at-sea on the P18 expedition.
Data citation comments added to P18_2007 Exchange bottle file.
Notes on p18_2007 CTD trip data merge Sept 8, 2008/dm
ORIGINAL data files:
woce format bottle data file "p18.sea" from /data/co2clivar/pacific/p18/p18_33RO20071215/original/20080819_Johnson-Mary_update
woce format summary file from "p18.sum" from /data/co2clivar/pacific/p18/p18_33RO20071215/original/20080819_Johnson-Mary_update
(This summary file has EXPOCODE on stations from Jan 21, 2008, to end of cruise changed from 33RO20080121 to 33RO20071215)
NEW data file:
CTD trip data file "p18_cchdo.sea" from Kristy McTaggart, NOAA,August 14, 2008, email
1) Deleted from odf woce format file p18.sea:
STNNBR CASTNO SAMPNO all data
46 1 -9 -9
52 1 -9 -9
55 1 -9 -9
71 1 -9 -9
167 1 -9 -9
2) PH parameter mnemonic changed to PH_SWS
PH_SCALE deleted
PH_TMP changed to PH_TEMP
per Jim Swift August 22, 2008 email re "Revised Guidelines for pH"
3) CDOM changed to CDOM325
CDMSLOG changed to CDOMSL because CDMSLOG not on hyd_to_exchange.pl parameter list.
CDMSNLF changed to CDOMSN " CDMSNLF "
Following CDOM values significantly higher than adjacent values but with Q flags = "2"s.
Sta 46 Ca 1 Smp 32 ctdp 60.2db All CDOM values
82 1 30 132.3db CDOM325, CDOM340, CDOM380 & CDOM412 only.
4) SF6 Sta 149 Ca 1 Sample 30 11.5 high. Quality flag 6. Left as is for now
Sta 173 Ca 1 Sample 15 -194.378 changed to -9.000. Quality flag 3 changed to 5
Added John Bullister as SF6 P.I. per Bullister email Aug 20, 2008. Email also says further SF6 updates are expected.
5) Following parameters are included but are not described in CCHDO parameter list.
All have missing value indicators and quality flags 9 or 1:
CDOM2C
CDOM3C
DELSI30
DELSITY
N15-N2
N2 (AZOTE?)
O18-O2 (O18O16)
This week Kristy has given Steve Diggs at CCHDO the final CTD data and CTD values of pr, te, sa, & ox at bottle stops, so they should merge those instead of the revised ones we provided at the end of the cruise.
Attached is our short version of the final P18 .sea file with final calibrations applied to CTD temperature, salinity, and oxygen. It includes only STNNBR, CASTNO, SAMPNO, BTLNBR*, CTDRAW, CTDPRS, CTDTMP, CTDSAL*, CTDOXY*, THETA, SALNTY*, and QUALT1(1-4*). Basically, the header followed by the first 11 columns and then an abbreviated flag string.
? Created text doc
? Added Data Processing Notes to pdf and txt docs
? Added links to tables and figures in pdf doc
? Added CCHDO station track to pdf doc
I updated the one last TALK code for station 43-127, and re-created the 3 data files for P18. CFC redundancies resolved as analyst resubmitted the data to me with only one value reported per bottle.
the values for CTDPRS, CTDTMP, CTDSAL, and CTDOXY from the attached file, p18_allo.sea, should be substituted into Mary's bottle file.
The SUMfile from ODF (M. Johnson) as well as the PDF documenation file are now online. New cruise track maps are also available online, made from SUMfile. Preliminary cruise tracks removed.
The sum and sea files that Mary made during the cruise are attached. You may make the data public on the website. Again, the CTD/O2 values in the sea file attached should be replaced with those in the sea file that I sent you a few days ago.
Near the end of the 2007/2008 reoccupation of WOCE Section P18, with
some helpful input from Mary Johnson and Alex Orsi, Kristy McTaggart and
I decided to adjust some station groupings for preliminary CTD/O2
conductivity calibrations using bottle salts. We finished this work too
late to get them integrated into the shipboard preliminary data package
that Mary distributed on the ship and is bringing back to SIO, but not
too late to send them to you before leaving Punta Arenas.
I am attaching these new preliminary CTD/O2 profiles and CTD/O2 values
at bottle stops (all the CTD/O2 stations and a bottle file with CTD/O2
and some other values in WOCE format) as a gzipped tar file. I think
this version of the calibration is enough of an improvement over the
values we gave Mary that the CTD/O2 profiles in this file, along with
the CTD/O2 values at bottle stops, should be what are posted on the web
for preliminary distribution. I hope this does not cause too much
inconvenience. If you have any questions, please let me know. Kristy
is on vacation for a few weeks, but I should be back in the office this
Thursday, if all goes well.
According to Mary's first message, your departure time is 0215
Saturday December 15, 2007 GMT. Based on this information....
New expocode for P18 2007: 33RO20071215.
Attached are the CLIVAR P18 cruise instructions and chartlet of the cruise track.