Bottle Specific

Exchange Bottle files follow all the common format specifications for their structure. The File Format Indicator 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 within the Parameter and Unit Lines and their values be present in the Data Lines.

Changed in version 1.3: Removed BTLNBR as being one of two options for required columns.

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 uniquely 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 requiring a combination of values from specific parameters to be unique throughout the file.

The following combination of parameters must have unique values:

Changed in version 1.3: Removed BTLNBR as a being a valid identifier for samples.

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, 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,         23[...]
  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: