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 DatasetCCHDO-1.0 CF netCDF files converted from bottle exchange file
CCHDO-1.0 CF netCDF files converted from ctd exchange file
File created in the CCHDO system
File created in the CCHDO system
File created in the CCHDO system
31DSCG96_1 processing - BTL
2022-08-11
A Barna
Submissions
id submit date submitted by file name
---- ------------- -------------- ------------
1530 p14s_hy1.csv
Changes
* Set underway system sample pressures from -999 to 0 at the following locations:
* STN 26, cast 1, sample 140
* STN 37, cast 1, sample 140
* STN 41, cast 1, sample 140
* STN 43, cast 1, sample 140
* STN 45, cast 1, sample 140
* STN 63, cast 1, sample 140
* STN 71, cast 1, sample 140
* STN 73, cast 1, sample 140
* STN 95, cast 1, sample 140
* Removed the following completely empty rows:
* STN 100, cast 1, sample 132
* STN 100, cast 1, sample 131
* Changed missing CTDSAL value flag from 4 to 5 on station 78 cast 1
31DSCG96_1_hy1.csv and 31DSCG96_1_nc_hyd.zip opened in JOA with no apparent problems.
Conversions
note: converted and put online by E Aitoro
file converted from software
--------------------- ------------------ -----------------------
31DSCG96_1_nc_hyd.zip 31DSCG96_1_hy1.csv hydro 0.8.2-62-gb1f9390
31DSCG96_1hy.txt 31DSCG96_1_hy1.csv hydro 0.8.2-62-gb1f9390
Updated Files Manifest
file stamp
--------------------- -----------------
31DSCG96_1_hy1.csv 20220811CCHSIOAMB
31DSCG96_1_nc_hyd.zip 20220811CCHSIOAMB
31DSCG96_1hy.txt 20220811CCHSIOAMB
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
File was created on or before this date
There are about 10 DOC values that are set to -9.99. These should all be changed to -999 and be flagged 9
Calvin (Mordy) thinks the no2 peak is real, so it was correctly subtracted from the NO3+NO2 value to get NO3. So the NO3 should not be changed.
Lynne, Here are the three bulls eye data points you wanted for p15. sharon
p15nb, EXPOCODE 18DD9403_2,
stnnbr castno sampno btlnbr ctdprs nitrit flag
094 3 2119 12 1247.6 1.44 2
p15na EXPOCODE 18DD9403_1 btlnbr ctdprs nitrit flag
stnnbr castno sampno
050 3 1087 18 400.3 0.24 2
p14s/p15s expcodes 31DSCG96_1 and 31DSCG96_2
stnnbr castno sampno btlnbr ctdprs nitrit flag
52 1 125 1233 372.2 0.18 2
Frank, Howard, and WHPO: looks like there are some nitrite bullseyes on P15 that we're just catching now, since we hadn't made full depth sections before. (The atlas will have sections only to 1000 meters.) These most likely need to be flagged 4.
- Deleted CTD DQE Report by Bob Millard.
[Report belonged with P15N Leg 1 CTD data]
- Added figures for McTaggart & Johnson's response to the CTD DQE
- Added bookmarks to PDF version
- Added table of contents to text version
- Added introduction to CTD report by K.E. McTaggart and G.C. Johnson
- Expanded these Data Processing Notes
- Updated OnLine Data History
I have fixed the code that produces the Exchange files and subsequent NetCDF files. PH is now an F9.4 number. Danie, Jim and I are working on a strategy to re-do all of the files online in the near future.
One more thing I forgot to ask you. Andrew Dickson of SIO recently send me a message that for WOCE P14N and P14S sections pH was reported to 2 decimal points in exchange formatted files, but to 3 and 4 decimal points in old WHP formatted files. I did not check other files where pH is reported but I think that it is probably a mistake in that pearl code that converts the data. Could you please check this out. It is very important to have pH reported to 3 or 4 decimal points and many users now copy the data in exchange format.
Merged the DELC14 and C14ERR from file 20040302.100353_KEY_P14S15S_
p14s15s.c14.WHP submitted by Bob Key into online file20030305SIOWHPODM.
The file Key sent had station, cast, and bottle number. The bottle number did not agree with the bottle number in the online bottle file. They did agree with the sample no in the online file if you added the cast number, ie 24 in Key's file was 124 in the online file if it was cast 1 (or 224 if cast 2, 324 if cast 3, etc).
Key's file had quite a few stations with sample numbers that were not in the online file, but since there were no DELC14 values for these I ignored them.
The online file had -9.0 for all DELC14 values so the QUALT1 and QUALT2 flags were all 9. Key's file had only one Q flag. When I merged the data I used Key's Q flag for both Q1 and Q2. Also, Key's file had a Q flag of 2 for all the -999.0 values, I changed those to 9.
Had to add P14S under WOCE SECT for stas. 1-3 in the .sum files in order to get the exchange file made.
I just finished uploading the c14 data for p14s15s (the noaa cruise). As usual, my software hasn't truncated to the correct number of decimal places, it does, on the other hand drop trailing zeroes.
These analyses were funded by a special NSF grant obtained to measure some of the samples which were collected, but without c14 analysis money.
The C14 PI for these data is Paul Quay. Paul also measured the C13 values which are currently in the WHP files. NOSAMS reran the C13, but the NOSAMS c13 values will not replace Paul's values.
I did the QC on the C14 and have already sent copies (merged) back to NSOAMS and to Quay.
I have not written a final report for this cruise, and probably won't.
As noted on the submission form, the data from this cruise (especially the lower station numbers) are noiser than normal for WOCE, but the number of "fliers" is not too bad. Cause is probably extra storage and handling, but that's just a guess.
Given the geographic location, these certainly need to be included in any updated versions of the WHP files - that is, they fill a giant data hole.
New PDF and text docs online.
CTD DQE report by R. Millard added
Data Processing Notes Expanded
After checking P15S and P14N I am guessing that whatever code were are using to convert 'original WOCE' format to 'WHP Exchange' format is truncating pH to two decimal places. Steve will have to fix the code, and then the staff will have to update every Exchange data file with pH data. '90-1' clearly shows that there is a 4-decimal place specification for pH.
Merged DELC13 decimal-2-data into current web file.
Notes on P14S/P15S Mar, 5, 2003 D. Muus
1. Merged DELC13 with 2-decimal-place DELC13 from:
/usr/export/html-public/data/onetime/pacific/p15/p15s/original/
2000.07.05_P15S_MCNICHOL/p15submt2_reformat.csv
into p14shy.txt (20010927WHPOSIODM)
2. No DELC13 in P14S part of cruise (Stations 1-32).
3. Both QUALT1 and QUALT2 set to QC value given in original data file.
4. C13ERR column was in web bottle with all missing value indicators.
No C13ERR data in C13 data file.
5. 6 samples in data file have 2 delc13 values. First was used in merge.
Second values follow:
STNNBR CASTNO SAMPNO DELC13 QC
53 1 124 1.03 2
62 2 224 1.41 2
67 2 228 2.12 2*
84 1 105 1.13 2
101 2 202 0.43 2
112 1 132 1.3 2
*First value for 67/2/228 is 1.32, QC=6. Second value looks high.
6. Made new exchange file for Bottle data.
7. Checked new bottle file with Java Ocean Atlas.
New txt & pdf docs online
New sections include a CTD cast summary and CTD oxygen algorithm
parameters tables, HYD DQE report, CTD DQE report, PI response to
CTD DQE report, CFC DQE report, Report on CO2fugacity Measurements,
and WHPO data processing notes.
PDF Cruise Report includes all the above, plus figures and internal
links between figures and table of contents and relevant text.
CTD has been converted to exchange using the new code and put online. Files for station 21 and 77 has a mismatch in the cast number in the sumfile. The sumfile contained data for a cast 1 but the CTD files said cast 2 so the CTD files were modified for the purpose of the conversion.
Merged July 2001 CFCs into bottle file, modified SUM file WOCE SECT column to allow conversion to exchange format, made new exchange file and place all on web.
Notes on P14S CFC merging Sept 26, 2001. D. Muus
1. New CFC-11 and CFC-12 from:
/usr/export/html-public/data/onetime/pacific/p14/p14s/original/20010709_CFC_UPDT_WISEGARVER_P14SP15S/20010709.173406_WISEGARVER_P14SP15S/20010709.173406_WISEGARVER_P14SP15S_p14s_CFC_DQE.dat
merged into SEA file taken from web Sept 26, 2001 (20000616SIOWHPODMB)
Most "1"s in QUALT1 changed to "9"s and QUALT2 replaced by new QUALT1
prior to merging.
CTDOXY has values for Stations 1 through 3 but QUALT1 code is "1". Bottle oxygens taken on Station 1 and from Station 4 on. No bottle oxygens on Stations 2 and 3. QUALT1 code for CTDOXY is "2" from Station 4 on.
Left "1"s as quality codes for Station 1 - 3 CTDOXY as caution to users.
2. Conversion from woce bottle format to exchange format failed using the web SUMMARY file (20000616SIOWHPODMB).
Modified SUM file by replacing blanks in WOCE SECT columns for Stations 1 - 3 with "x"s. Moved WOCE SECT header so column is left justified.
Conversion to exchange file worked after these modifications made.
3. Exchange file checked using Java Ocean Atlas.
CTD and Bottle files in exchange format have been put online.
Got word from Eric this A.M. that he will fund NOSAMS at the rate of 1000/year
to analyze previously collected, but unfunded C14 samples. Highest priority will be to fill in Pacific "holes" starting with P14S15S (NOAA), P15N (Wong) and P1 (Japan). Policy decision supported by WOCE SSC. Eric would, if possible, like these data to be included in the atlas. In reality I don't know if this is possible/practical, but I will do everything possible to expedite. Scheduling at NOSAMS will be complicated, but order listed above is the "scientific" priority as of now.
2000.11.21 KJU
File contained here is CRUISE SUMMARIES and NOT sumfiles. Files listed below should be considered WHP DOC files. Documention is online.
2000.10.11 KJU
Files were found in incoming directory under whp_reports. This directory was zipped, files were separated and placed under proper cruise. All of them are sumfiles.
Received 1997 August 15th.
All the Pacific data (most of which I still need to send you) is public. I should be sending you a pile of data next month.
Also, if the future, if you have a question that you need answered immediately, the best person to get in contact with besides me is Dana Stuart. Her contact info is dstuart@whoi.edu
I have just uploaded three files p15sbmt2.csv, p15submt.des, and p13submt.des to your ftp site. The csv file contains the following fields in a comma-delimited file:
LabID, Trackline, Station, cast, niskin, del13C, QC
The LabID is to distinguish between the two laboratories where the majority of the measurements were made--University of Washington and NOSAMS, WHOI.
The files labelled des describe the samples flagged with a "6" in greater detail. Can you accept these as well?
Paul Quay and I would like to append a statement *somewhere* indicating the status of our laboratory data comparisons. Do you have an appropriate place for this?
I just received a revised pCO2 data file for the P14SP15S cruise, along with a short description of the analytical methods used, all from the PI (Rik Wanninkhof; wanninkhof@aoml.noaa.gov)
I just put 2 files at the WHPO INCOMING ftp site:
p14sp15spco2.dat
p14sp15spco2.txt
Could you please merge the pco2 data into the p14sp15shy.txt file at your site, and include the text of p14sp15spco2.txt in the cruise documentation file?
I have replaced the summary, bottle* and added an additional documentation file. All entries and references to this line have been updated. Columns for DELC14/13 and C14ER/C13ER PCO2TMP and PHTMP are filled with missing data values. Bullister has been notified via email that the above changes have been made.
*Bottle: (ctdraw, ctdprs, ctdtmp, ctdsal, ctdoxy, theta, salnty, oxygen, silcat, nitrat, nitrit, phspht, cfc-11, cfc-12, delc14, delc13, tcarbn, alkali, pco2, ph, c14err, c13err, qualt1), DOC
I have updated the current sumfile and doc file for this cruise as well as the bottle file.
The new bottle file contains:
CTDRAW CTDPRS CTDTMP CTDSAL CTDOXY THETA SALNTY OXYGEN SILCAT NITRAT NITRIT PHSPHT CFC-11 CFC-12 DELC14 DELC13 C14ERR C13ERR TCARBN ALKALI PCO2 PCO2TMP PH PHTEMP
There is no data in the columns for DELC14, DELC13 C14ERR, C13ERR, PCO2TMP and PHTEMP
SUM:
ran sumchk, several errors produced.
Re-aligned column headings and date, lat/lon columns.
Changed expocode backslashes to underscores.
Changed expocode from 31DICG96_ to 31DSCG96_
Added time/name stamp.
ran sumck a second time with no errors. New file named p14sp15s.sum.edt
BOT:
ran wocecvt, warnings on pressure and depth sequencing problems.
Inverted all samples to be in increasing pressure order.
Changed expocode backslashes to underscores.
Changed expocode from 31DICG96_ to 31DSCG96_
Added time/name stamp.
ran wocecvt a second time with only duplicate depth warnings. New file
named p14sp15s.sea.edt
DOC:
new doc file will replace current online version.
I just re-sent p14sp15s .sea, .sum and .doc files to the WHPO ftp site.
The file names are:
p14sp15s.doc.senttoWHPO12jun2000
p14sp15s.sea.senttoWHPO12jun2000
p14sp15s.sum.senttoWHPO12jun2000
These files have a number of updates compared to the 'p14s' files now posted at the WHPO web site. Please note that the data in these files (and in the old 'p14s' posted at the WHPO web site) are for both p14s AND p15s- both sections were done on the same expedition.
The .sea file now ncludes tcarbn, alkali and pH data; the CFC data are reported on the SI093 calibration scale.
We have incorporated most of the changes recommended in A. Mantyla's DQE recommendations. Details of these changes are included at the end of the p14sp15s.doc.senttoWHPO12jun2000 file.
I'd appreciate any comments.
John Bullister
PS: Please note that the formatting instructions given for delc13 in the WHPO 90-1 manual posted at the WHPO web site still ask for F8.1. This should be F8.2. A lot of the value of the delc13 data is lost if they are only reported to 1 decimal precision.
P14S15S is problematic. Paul did collect samples which could have been used for C-13 and C-14. I'm pretty sure that many of the C-13 samples have been analyzed. Unfortunately, in his proposal, Paul did not request funding for C-14 analysis. Paul saved an aliquot of the extracted CO2 gas which can be analyzed for C-14 if we can get the funds. We plan on submitting a proposal which, if funded, will cover C-14 anlaysis costs on a few cruises including:
P14S15S
EqPac (Fall and Spring; NOAA)
P1 (Japanese E-W transect)
Unnamed German cruise in the upwelling region west of S. Am.
P14S15S Changed to indicate no samples collected. However I'd like to clarify this with you, because the DOC file that we have indicates that some 900 or so samples were taken for both C14 and C113, did they not get processed? (There are columns in the data file for both of these parameters that will need to be edited out.) When I first started working for Lynne on the atlas I emailed Paul Quay about this but never got a reply.
Sarilee re-formatted the SUM and HYD files for P14S. They are out on the website, and all tables have been updated.
Reformatted to conform with the WHPO standard .sum format.
Mostly adding and/or deleting spaces.
p14shy.txt
 Reordered pressures that were not in descending order.
 Changed station 21 cast 1 to cast 2 to conform with the .sum file.
 Changed station 77 cast 1 to cast 2 to conform with the .sum file.
 Ran over wocecvt and sumchk without any errors.
Contrary to the statement in your recent letter, we did receive the DQE reports for the CTD data from both P18 and P14S/P15S fairly shortly after they were completed by Mark Rosenberg (in Oct/Nov 1998). Kristy McTaggart and I have been working on and off as time allowed (of course we no longer have funding to do any of this) to respond to the comments and we have just about finished up. Kristy will be mailing you our responses to both reports (and submitting some revised data) shortly. Please don't make any changes to the CTD data for these cruises until you have our replies in hand.
* S/O, NUTs, CFCs, CTD all public. c14 collected and sent to AMS/WHOI. Checking w/ Quay re c14 data status
Reformatted .sum file:
Changed EXPOCODE from 31DICG96/1 to 31DSCG96_1
and 31DICG96/2 to 31DSCG96_2.
Ran over sumchk, no problems.
.sea file ok except for first header.
Changed EXPCODE to EXPOCODE.
Changed 31DICG96/1 to 31DSCG96_1
and 31DSCG96_2 to 31DSCG96_2.
Reordered pressures so they are shallowest to deepest.
For stas. 21 and 77 .sum file had only cast 2, .sea file
had only cast 1. I don't know which is correct so I did
not change.
Ran over wocecvt, only problem above mentioned cast number
discrepancies.
CTD - ctd data was ok except for EXPOCODE. Changed from
31DICG96/1 and 31DICG96/2 to
31DSCG96_1 and 31DSCG96_2.
Dates in .sum and .wct files for sta/cast 13/1, 16/1, 29/2,
32/1, 39/1, 43/1, 52/1, 74/2, 89/2, 110/2, 121/2, 128/2,
135/2, 167/2, 173/2, and 175/2 do not agree.
In all cases the BE time is before midnight and the BO time is
after midnight so the day is different. The originator used
the BE dates for the ctd's. I did not change the .wct files.
P14s/p15s has been updated with a new SUMfile, SEA-HYDfile and additional documentation from John Bullister.