Data processing was carried out using Thermo Scientific software and also Microsoft Excel.
BCO-DMO Data Manager Processing Notes:
* added a conventional header with dataset name, PI name, version date
* modified parameter names to conform with BCO-DMO naming conventions
* blank values replaced with no data value 'nd'
* removed data column "Cruise" containing value "USGT_EPZT" for all cells
* added SECT_ID "EPZT" and cruise_id "TN303"
* changed parameter names with _std to _SD to be consistent with other GEOTRACES datasets
* joined dataset as described below to add :
CASTNO,GEOTRC_EVENTNO,BTL_ISO_DATETIME_UTC,BTLNBR,BTLNBR_FLAG_W,ISO_DATETIME_UTC_START_EVENT,EVENT_LAT,EVENT_LON,STNNBR,CTDDEPTH,CTDPRS
* changed depth variable to PI_depth to distinguish between the master epzt depth and the rounded depth originally in the dataset.
* new data version posted (2017-03-21) which replaces version 2016-12-28. The only change is 5 replacements of "nd " to "nd" with space removed.
Additional GEOTRACES Processing:
As was done for the GEOTRACES-NAT data, BCO-DMO added standard US GEOTRACES information, such as the US GEOTRACES event number, to each submitted dataset lacking this information. To accomplish this, BCO-DMO compiled a 'master' dataset composed of the following parameters:
cruise_id, EXPOCODE,SECT_ID, STNNBR, CASTNO, GEOTRC_EVENTNO, GEOTRC_SAMPNO, GEOTRC_INSTR, SAMPNO, GF_NO, BTLNBR, BTLNBR_FLAG_W, DATE_START_EVENT, TIME_START_EVENT, ISO_DATETIME_UTC_START_EVENT, EVENT_LAT, EVENT_LON, DEPTH_MIN, DEPTH_MAX, BTL_DATE, BTL_TIME, BTL_ISO_DATETIME_UTC, BTL_LAT, BTL_LON, ODF_CTDPRS, SMDEPTH, FMDEPTH, BTMDEPTH, CTDPRS, CTDDEPTH.
This added information will facilitate subsequent analysis and inter comparison of the datasets.
Bottle parameters in the master file were taken from the GT-C_Bottle and ODF_Bottle datasets. Non-bottle parameters, including those from GeoFish tows, Aerosol sampling, and McLane Pumps, were taken from the TN303 Event Log (version 30 Oct 2014). Where applicable, pump information was taken from the PUMP_Nuts_Sals dataset.
A standardized BCO-DMO method (called "join") was then used to merge the missing parameters to each US GEOTRACES dataset, most often by matching on sample_GEOTRC or on some unique combination of other parameters.
If the master parameters were included in the original data file and the values did not differ from the master file, the original data columns were retained and the names of the parameters were changed from the PI-submitted names to the standardized master names. If there were differences between the PI-supplied parameter values and those in the master file, both columns were retained. If the original data submission included all of the master parameters, no additional columns were added, but parameter names were modified to match the naming conventions of the master file.