BIOMAD Bacterioplankton database format
Gulf of Bothnia
.
Sampling Site, Methods and Analytical Result Record.
File name: BPUMSC_YY-YY.dbf

#

Field name

Format

Field description, units, valid values

1

MYEAR

NUM

Sampling year. 

2

SHIPC

CHAR

Ship code, see ICES (optional).

3

SERNO

NUM

Ship serial number (optional).

4

SDATE 

CHAR

Sampling date (YYYY/MM/DD).

5

STATN

CHAR

Code/abbreviated name of the sampling station.

6
SMPNO NUM Sample number.

7

SMDEP

NUM

Sampling depth (m).

8

STIME

NUM

Sampling time (hhmm).

9

LATIT 

NUM

Latitude, see ICES.

10

LONGI 

NUM

Longitude, see ICES.

11

WADEP

NUM

Water depth at sampling site (m).

12

WLTYP

CHAR

Station type, see ICES.

13

METFP

CHAR

Method of preservation, see ICES.

14

BDMET

CHAR

Biological data sampling method, see ICES.

15

BCTPR

NUM

Bacterial production (cells/L*day).

16

PRFLG

CHAR

Flag for bacterial production [0=missing, 1=OK, 7=below detection limit].

17

BCTCNT

NUM

Number of bacteria (cells/L).

18

CNTFLG

CHAR

Flag for bacterial count [0=missing, 1=OK, 7=below detection limit].

19

COMNT

CHAR

Bacterioplankton record comment.

20

ALABO

CHAR

Analytical laboratory code, see ICES.

21

SLABO

CHAR

Sampling laboratory code, see ICES.