Bottle Specific¶
Exchange Bottle files follow all the common format specifications for their strucutre.
The File Identification Stamp of an exchange bottle file starts with BOTTLE
.
Each data line in an exchange bottle file represents a single bottle closure.
When ctd parameters are encountered within exchange bottle files (e.g. CTDPRS) they represent the corrected values being read by the CTD at the time of bottle closure, usually averaged over some interval.
In bottle files, specific parameters are REQUIRED to be present and have non fill values.
Required Bottle Parameters¶
The following parameters are REQUIRED to be present in exchange bottle files where the parameter name occurs witin the Parameter and Unit Lines and their values be present in the Data Lines.
At least one or both of the following parameters MUST be present:
Unique Line Identification¶
Since each data line of an exchange bottle file represents a single bottle closure, enough information must be present on each line to uniquiely identify closure event. This is to allow the integration of all the measurements of samples taken from that bottle at a later time. The identification is done by requireing a combination of values from specific parameters to be unique throughout the file.
The following combination of parameters must have unique values:
or
Unique Line Identification Examples¶
In these examples, the long parameter, unit, and data lines truncated by [...]
.
The following example exchange bottle data is all from the same cruise
indicated by the expocode: 33RO20131223
, the same station: 1
, the same cast 2
, but the bottle number and sample numbers
differ (24
and 23
).
1 2 3 4 5 6 7 8 | BOTTLE,20150327CCHSIORJL
# From submitted file a16s_2013_final_discrete_o2.csv:
# Merged parameters: OXYGEN_FLAG_W
EXPOCODE,STNNBR,CASTNO,SAMPNO,BTLNBR[...]
,,,,[...]
33RO20131223, 1, 2, 24, 24[...]
33RO20131223, 1, 2, 23, 23[...]
END_DATA
|
The following example shows an example of duplicated unique identification parameter values. More than one line contains the exact same values for EXPOCODE, STNNBR, CASTNO, BTLNBR, and SAMPNO.
1 2 3 4 5 6 7 8 | BOTTLE,20150327CCHSIORJL
# From submitted file a16s_2013_final_discrete_o2.csv:
# Merged parameters: OXYGEN_FLAG_W
EXPOCODE,STNNBR,CASTNO,SAMPNO,BTLNBR[...]
,,,,[...]
33RO20131223, 1, 2, 24, 24[...]
33RO20131223, 1, 2, 24, 24[...]
END_DATA
|
Example Bottle Data¶
1 2 3 4 5 6 7 8 9 10 11 | BOTTLE,20150327CCHSIORJL
# From submitted file a16s_2013_final_discrete_o2.csv:
# Merged parameters: OXYGEN_FLAG_W
EXPOCODE,SECT_ID,STNNBR,CASTNO,SAMPNO,BTLNBR,BTLNBR_FLAG_W,DATE,TIME,LATITUDE,LONGITUDE,DEPTH,CTDPRS,CTDTMP,CTDSAL,CTDSAL_FLAG_W,SALNTY,SALNTY_FLAG_W,CTDOXY,CTDOXY_FLAG_W,OXYGEN,OXYGEN_FLAG_W
,,,,,,,,,,,METERS,DBAR,ITS-90,PSS-78,,PSS-78,,UMOL/KG,,UMOL/KG,
33RO20131223, A16S, 1, 2, 24, 24,2,20131226, 0706, -6.0016, -24.9998, 5809, 3.9, 26.2239, 36.3097,2, 36.3082,2, 199.1,2, 201.2,2
33RO20131223, A16S, 1, 2, 23, 23,2,20131226, 0704, -6.0016, -24.9998, 5809, 22.5, 26.2331, 36.3090,2, 36.3171,2, 199.4,2, 201.3,2
33RO20131223, A16S, 1, 2, 22, 22,2,20131226, 0702, -6.0016, -24.9998, 5809, 47.4, 26.2335, 36.3078,2, 36.3080,2, 200,2, 201.9,2
33RO20131223, A16S, 1, 2, 21, 21,2,20131226, 0700, -6.0016, -24.9998, 5809, 72.1, 26.2112, 36.3044,2, 36.3055,2, 200.6,2, 201,2
33RO20131223, A16S, 1, 2, 20, 20,2,20131226, 0658, -6.0016, -24.9998, 5809, 97.5, 24.2160, 36.1165,2, 36.1258,2, 193.2,2, 190.1,2
END_DATA
|
The basic strucutre is:
- Line 1: File Identification Stamp starting with
BOTTLE
- Line 2, 3: Optional Comment Lines
- Lines 3, 4: Parameter and Unit Lines
- Lines 6-11: Data Lines.