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 |
| p02e_1_hy1.csv | 287.6 kB | 2013-07-24 |
CCHDO-1.0 CF netCDF files converted from bottle exchange file
CCHDO-1.0 CF netCDF files converted from ctd exchange file
There is not enough information to know where this file should go in the timeline.
There is not enough information to know where this file should go in the timeline.
There is not enough information to know where this file should go in the timeline.
There is not enough information to know where this file should go in the timeline.
There is not enough information to know where this file should go in the timeline.
There is not enough information to know where this file should go in the timeline.
There is not enough information to know where this file should go in the timeline.
There is not enough information to know where this file should go in the timeline.
There is not enough information to know where this file should go in the timeline.
There is not enough information to know where this file should go in the timeline.
There is not enough information to know where this file should go in the timeline.
Leg 1 bottle file
The following files are now available online under 'Files as received', unprocessed by the CCHDO.
p02e_1_hy1.csv
I did not receive the carbon-related data from Japan for this cruise. I copied the data files from CCHDO and intend to do QA-QC on these numbers. If I find anything wrong I will contact carbon PI and CCHDO.
Made changes to QUALT1 flags for sta. 156 line p02e2 re Lynne Talley's email. Put corrected file online, made new exchange file.
Made changes to QUALT1 flags for stas. 61 and 78, line p02e1 re Lynne Talley's email. Put corrected file online, made new exhcange file.
some flagging questions for p02e1hy.txt.
1. The phosphates and nitrates for bottles 20,21, 22 on stations 21 are really
bad (phosphates are completely unphysical). The phosphate flag at bottle 22 is
6, but is 3 on the other bottles. Shouldn't it just be 4 on all bottles?
Or at least consistent?
2. Oxygen at bottle 21 on station 78 is a bad outlier. It should at a minimum
be flagged as 3 (should really be a 4).
I think some quality flags need to be changed on these lines (stn 156)
in p02e2hy.txt:
The CTDSAL values here are -9.0000 so shouldn't the quality flags be 9
instead of 4?
New PDF and text docs online.
Replaced p02e2ct.zip with file from Lynne Talley. Station 119 had bad salinity and temperature at the surface, she changed flags to 4.
Hi Masao - just checking on some things on the p2 CTD data - I think some flags need to be changed. This shouldn't replace real data quality control, but I'm not sure that it will ever be done here. So I'd like to go ahead and flag things as bad if necessary.
P02E: station 119 has a very high surface salinity and low temperature. These look suspicious - density is much too high compared with next point underneath. Most stations have -9 values at this surface point. Should the flags here be changed to 4 for both temperature and salinity? Or the data values replaced with -9?
EXPOCODE 492SSY9310_2 WHP-ID P2E DATE 111693
19990414LDTWHPOSIO
STNNBR 119 CASTNO 1 NO.RECORDS= 2489 2
INSTRUMENT NO. S/N1194 SAMPLING RATE 25.00HZ 3
CTDPRS CTDTMP CTDSAL CTDOXY NUMBER QUALT1
DBAR ITS-90 PSS-78 UMOL/KG OBS. *
******* ******* ******* ******* *
0.0 20.8356 36.0708 -9.0 -9 2225
2.0 22.2238 35.3254 -9.0 -9 2225
4.0 22.2201 35.3243 -9.0 -9 2225
6.0 22.2220 35.3240 -9.0 -9 2225
8.0 22.2151 35.3241 -9.0 -9 2225
10.0 22.2202 35.3243 -9.0 -9 2225
12.0 22.2186 35.3173 -9.0 -9 2225
14.0 22.2193 35.3232 -9.0 -9 2225
16.0 22.2208 35.3228 -9.0 -9 2225
Final text and pdf docs online
CTD files updated and slight refomatting was performed for conversion to Exchange format. P02e CTD zip archives now exclude stations from p02c. New ZIP archives of WOCE CTD and Exchange CTD formatted files are now on the website.
I have put all of the new P02e files on-line (with nutrients). I have attached Sarilee's reformatting note (kinda long). Sarilee also reformatted the SUM file and put it out n the website as well.
thanks,
-sd
---->
Merged the nutrients into the .sea files for P02E.
The nutrient file had two sta. 35. When I compared the pressures of the second sta. 35 in the nutrient file with the pressures for sta. 36 in the .sea it was obvious that the station designation in the nutrient file should have been 36.
Ditto above only for sta. 105. Should have been 106 in the nutrient file.
There were numerous levels throughout the file that had 0 as the sample and/or bottle number. These levels had no data and were not in the .sea file and were not merged into the .sea file.
Stas. 36 and 37 had at 5501.1 and 5500.5 respectively a value of 972.51 for SILCAT and 9.73 for PHSPHT. The QUALT1 flag was 9 for each of them. These are impossible values for these parameters so I changed the values to -9.00.
Sta. 40 at 1000.0db had 99 for QUALT1 flags but a value of 113.91 for SILCAT and 9.73 for PHSPHT. Changed PHSPHT value to -9.00, SILCAT value is reasonable. Changed QUALT1 flags to 39.
List of stations where QUALT1 flags were not consistent with the data. I changed them so they agree with the data.
NOTE - most of the QUALT1 flags in the nutrient file were 3, so I used 3 when changing Q1 codes, except in one case where the data were obviously bad.
Leg 1
Sta. Press. Orig. Q1 New Q1
46 797.7 993 933
53 1748.5 399 393
54 698.1 399 393
60 50.9 993 933
66 999.2 399 393
72 1000.1 399 393
75 2250.8 999 939
81 399.5 999 939
81 5001.4 999 939
82 3000.9 999 939
83 2999.7 399 393
84 2500.8 999 939
85 1999.5 999 939
85 2497.6 999 939
86 2501.2 999 939
89 2499.5 999 939
90 1499.5 949 449
91 2500.6 999 939
95 2250.3 999 939
94 2248.5 999 939
96 1999.5 999 939
96 2249.8 399 393
96 3999.2 999 939
Leg 2
Sta. Press. Orig. Q1 New Q1
99 799.0 999 939
101 48.2 999 939
102 4497.2 999 939
103 2495.3 999 939
105 5000.3 999 939
106 100.8 399 393
106 900.5 999 939
106 4500.0 999 939
107 2000.8 999 939
107 2498.2 999 939
107 2999.8 999 939
107 4000.0 999 939
111 1498.2 999 939
112 5000.7 999 939
114 6001.3 999 939
115 2501.8 999 939
117 601.7 399 393
117 998.2 399 393
119 2001.3 999 939
119 4001.6 999 939
120 2499.4 999 939
122 2250.0 999 939
123 4000.9 999 939
126 2497.8 999 939
126 3998.5 999 939
127 4501.6 999 939
128 48.6 999 939
128 4001.8 999 939
129 3501.4 999 939
130 1999.8 999 939
130 2248.2 999 939
130 3997.8 999 939
132 3998.9 999 939
133 2247.8 999 939
133 2503.2 999 939
133 4504.6 999 939
134 3998.5 999 939
135 3496.9 999 939
135 3500.1 999 939
136 3499.7 999 939
138 4000.6 999 939
139 4000.4 999 939
140 4001.1 999 939
141 4000.0 999 939
142 2250.2 999 939
143 3999.6 999 939
144 3999.6 999 939
145 499.1 999 939
145 3999.4 999 939
145 4003.2 999 939
146 2449.9 999 939
146 3499.4 999 939
150 3001.2 999 939
153 3498.0 999 939
158 3498.9 999 939
159 3498.9 999 939
162 203.4 399 393
163 400.3 999 939
163 704.9 999 939
13 April 2001 Sarilee Anderson
BOTTLE converted to exchange format and placed files online.
CTD still non-public?
SUM, Bottle: (silcat, no2 no3, phspht)
I have put all of the new P02e files on-line (with nutrients) at Lynne Talley's request. I have also attached Sarilee's reformatting note (kinda long). Sarilee also reformatted the SUM file and I have put it out on the website as well.
I have merged the nutrients into the .sea file for P02E leg 1 and 2. The files are on whpo in sarilee/FTP/S_ANDERSON/P02E. I reformatted the .sum file while I was at it. There is a notes file explaining, I hope, what I did:
Merged the nutrients into the .sea files for P02E.
The nutrient file had two sta. 35. When I compared the pressures of the second sta. 35 in the nutrient file with the pressures for sta. 36 in the .sea it was obvious that the station designation in the nutrient file should have been 36.
Ditto above only for sta. 105. Should have been 106 in the nutrient file.
There were numerous levels throughout the file that had 0 as the sample and/or bottle number. These levels had no data and were not in the .sea file and were not merged into the .sea file.
Stas. 36 and 37 had at 5501.1 and 5500.5 respectively a value of 972.51 for SILCAT and 9.73 for PHSPHT. The QUALT1 flag was 9 for each of them. These are impossible values for these parameters so I changed the values to -9.00.
Sta. 40 at 1000.0db had 99 for QUALT1 flags but a value of 113.91 for SILCAT and 9.73 for PHSPHT. Changed PHSPHT value to -9.00, SILCAT value is reasonable. Changed QUALT1 flags to 39.
List of stations where QUALT1 flags were not consistent with the data. I changed them so they agree with the data.
NOTE - most of the QUALT1 flags in the nutrient file were 3, so I used 3 when changing Q1 codes, except in one case where the data were obviously bad.
Leg 1
Sta. Press. Orig. Q1 New Q1
46 797.7 993 933
53 1748.5 399 393
54 698.1 399 393
60 50.9 993 933
66 999.2 399 393
72 1000.1 399 393
75 2250.8 999 939
81 399.5 999 939
81 5001.4 999 939
82 3000.9 999 939
83 2999.7 399 393
84 2500.8 999 939
85 1999.5 999 939
85 2497.6 999 939
86 2501.2 999 939
89 2499.5 999 939
90 1499.5 949 449
91 2500.6 999 939
95 2250.3 999 939
94 2248.5 999 939
96 1999.5 999 939
96 2249.8 399 393
96 3999.2 999 939
Leg 2
Sta. Press. Orig. Q1 New Q1
99 799.0 999 939
101 48.2 999 939
102 4497.2 999 939
103 2495.3 999 939
105 5000.3 999 939
106 100.8 399 393
106 900.5 999 939
106 4500.0 999 939
107 2000.8 999 939
107 2498.2 999 939
107 2999.8 999 939
107 4000.0 999 939
111 1498.2 999 939
112 5000.7 999 939
114 6001.3 999 939
115 2501.8 999 939
117 601.7 399 393
117 998.2 399 393
119 2001.3 999 939
119 4001.6 999 939
120 2499.4 999 939
122 2250.0 999 939
123 4000.9 999 939
126 2497.8 999 939
126 3998.5 999 939
127 4501.6 999 939
128 48.6 999 939
128 4001.8 999 939
129 3501.4 999 939
130 1999.8 999 939
130 2248.2 999 939
130 3997.8 999 939
132 3998.9 999 939
133 2247.8 999 939
133 2503.2 999 939
133 4504.6 999 939
134 3998.5 999 939
135 3496.9 999 939
135 3500.1 999 939
136 3499.7 999 939
138 4000.6 999 939
139 4000.4 999 939
140 4001.1 999 939
141 4000.0 999 939
142 2250.2 999 939
143 3999.6 999 939
144 3999.6 999 939
145 499.1 999 939
145 3999.4 999 939
145 4003.2 999 939
146 2449.9 999 939
146 3499.4 999 939
150 3001.2 999 939
153 3498.0 999 939
158 3498.9 999 939
159 3498.9 999 939
162 203.4 399 393
163 400.3 999 939
163 704.9 999 939
I have merged the nutrients into the .sea file for P02E leg 1 and 2. The files are on whpo in sarilee/FTP/S_ANDERSON/P02E. I reformatted the .sum file while I was at it. There is a notes file explaining, I hope, what I did.
Merged the nutrients into the .sea files for P02E.
The nutrient file had two sta. 35. When I compared the pressures of the second sta. 35 in the nutrient file with the pressures for sta. 36 in the .sea it was obvious that the station designation in the nutrient file should have been 36.
Ditto above only for sta. 105. Should have been 106 in the nutrient file.
There were numerous levels throughout the file that had 0 as the sample and/or bottle number. These levels had no data and were not in the .sea file and were not merged into the .sea file.
Stas. 36 and 37 had at 5501.1 and 5500.5 respectively a value of 972.51 for SILCAT and 9.73 for PHSPHT. The QUALT1 flag was 9 for each of them. These are impossible values for these
parameters so I changed the values to -9.00.
Sta. 40 at 1000.0db had 99 for QUALT1 flags but a value of 113.91 for SILCAT and 9.73 for PHSPHT. Changed PHSPHT value to -9.00, SILCAT value is reasonable. Changed QUALT1 flags
to 39.
List of stations where QUALT1 flags were not consistent with the data. I changed them so they agree with the data.
NOTE - most of the QUALT1 flags in the nutrient file were 3, so I used 3 when changing Q1 codes, except in one case where the data were obviously bad.
Today I heard that Dr. Saito, the PI for nutrient data of P2, sent an email to someone concerned in SIO (Lynne Talley? ) to make the data public. I hope things go well in this regard.
I heard from Yoritaka-san that P2E nutrient data have not yet public, then I would agree with these data will be public.
I have unencrypted the bottle file for both legs of this cruise, however the nutrients still reside in the original directory and are not yet merged into the bottle file.
Sarilee, Could you possibly merge these nutrients into the on-line bottle file? They're in the 'original' directory for P02E.
I would like to consent to open Bottle_S/O2 and CTD data on P2E and P2W to the public as PI. Then, would you please change some information on the summarized table of WHP one time cruises on web as follows;
P02E;
CS: Bando/JODC -> Bando/(HD)MSA
Ship: SYOYO -> SHOYO
I received P02C/E nutrients as well from Saito, and just reformatted them and placed them in the original directories for each line. I'll have Stacy merge them in.
As for P2C and E, nutrients data were collected and Dr. Saito, who is the PI, reported me that data was submitted to WHOI. PI of CFCs is Dr. Watanabe although CFC data were note collected on neither P2C nor P2E.
With regard to the hydrographic data collected by Japanese groups, I found that the present status of availability of the data for P02E and P02W appeared as 'NP' in the listings of WHPO web site. I believe they should be ready to be made public. Have you had any contact to or from Mr Yoritaka, the present contact person for both lines? I will be pleased to ask him to confirm that the data are to be public, if necessary.
I've replaced all of the p02.sum files (p02w, p02e, p02c) and updated the table to reflect this. In the case of p02c and p02e the sum file changes (via Lynne)were correcting the occurrances of the old line number designation with the new line number designation, and (by me)replacing the slashes in the expocode to underscores. (See Lynne's emails below)
In the case of p02w the .sum file changes made (by Lynne) were converting decimal degrees into degrees and minutes in the lats and lons; the time was converted to GMT; station no. now has place holding zeros; cast type was changed from CTD to ROS; and height above bottom, wire out, and no. of bottles columns were also added. This conversion has shifted columns, however I ran sumchk on it with no errors. Slashes in the expocode were also replaced by underscores.
I have also replaced the corrupted P2E119.WCT file with Lynne's updated version, and updated the table to reflect this. The table was also corrected to reflect the *bottle* data file being encrypted, NOT the .sum file (previously the table indicated the .sum file was Non-public and the bottle file was public).
station 119 on p2e was corrupted. It was sent in a 1 dbar series, unlike all of the other stations. I decimated it to 2 dbar, changed the number of records in the header to match the 2 dbar series, and ftped it to the whpo site.
Steve - I placed corrected versions of p02csu.txt and p02esu.txt in my ftp area at whpo. Please replace the online versions with these (and acknowledge). (What did I change - replaced P02C in the P02E file with P02E, replaced P02W in the P02C file with P02C). Lynne