Skip to content

Latest commit

 

History

History
204 lines (171 loc) · 14.7 KB

bottle.rst

File metadata and controls

204 lines (171 loc) · 14.7 KB
Raw

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 <data lines> in an exchange bottle file represents a single bottle closure.

When ctd parameters are encountered within exchange bottle files (e.g. CTDPRS (DBAR)) 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.

  • EXPOCODE
  • STNNBR
  • CASTNO
  • DATE
  • LATITUDE
  • LONGITUDE
  • CTDPRS (DBAR)

At least one or both of the following parameters MUST be present:

  • BTLNBR
  • SAMPNO

Unique Line Identification

Since each data line <data lines> 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:

  • EXPOCODE
  • STNNBR
  • CASTNO
  • BTLNBR

or

  • EXPOCODE
  • STNNBR
  • CASTNO
  • SAMPNO

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).

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.

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

latex

An example bottle exchange file is provided on the next page.

html

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: comment line(s)
  • Lines 3, 4: parameter and unit lines
  • Lines 6-11: data lines.