MBARI Shipboard CTD samples from the Biological Ocean Group(BOG)

This document briefly describes the fields in the BOG database for CTD samples.  The data in these tables are primary productivity, physical, and chemical ocean data.  There are two tables: BCTD bottle data and PCTD profiling data.  The bottle samples are taken at 11 discrete depths, usually 0, 5, 10, 20, 30, 40, 60, 80, 100, 150, and 200m.  Profiling data are averaged into 1 meter depth bins.  For additional details see Methods and Materials. Data are processed using Seabird software.  Data in these data tables are primarily from Monterey Bay, CA cruises.  Also see BOG Projects.

 
BCTD Table

CTD bottle data (up cast), productivity, physical, and chemical data. One record for each CTD rosette bottle

Owner: Francisco Chavez (P.I.), Tim Pennington (Project Manager), Reiko Michisaki 

Keys: project, platform, expd, seq, depth, bottle

Note: * Sparsely populated field.  **Unpopulated field

Field

Field Name

Type

Description

1

ctd_bottle_id

Integer

Database record number

2

Cruise

Text

Cruise name, i.e S197, SU93-1, 00798

3

Expd

Integer

Expedition ID, JJJYY i.e. 15896 JJJ=Day of Year, YY= year

4

Seq

Integer

Station number

5

Depth

Integer

Nominal depth at which sample was taken

6

Bottle

Integer

Bottle number

7

Project

Text

Project Code, i.e. PTLO, SECRET, AOSNII etc.

8

ctrb_id

Text

MBARI Station Name

9

Platform

Text

Platform off of which the data were was collected

10

Rjday

Integer

Running day of year from 01/011988

11

date_time

Date

CTD cast begins sample collection GMT

12

Jtime

Float

Time stamp GMT

13

year_date

Integer

YYYYJJJ Year and Day of Year 

14

dec_lat

Float

Decimal Latitude

15

dec_long

Float

Decimal Longitude

16

site_id

Text

Site Name

17

Pressure

Float

Pressure at which sample was taken (db)

18

chl gff

Float

Chlorophyll filtered with GFF (mg m-3)

19

Phaeo gff

Float

Phaeopigment filtered with GFF (mg m-3)

20

fofa gff

Float

Ratio of FO to FA, GFF

21

vf gff

Float

Volume filtered with GFF ml

22

ve gff

Float

Volume extracted ml

23

sens gff

Float

Fluorometer sensitivity

24

fo gff

Float

Before acid added

25

fa gff

Float

After acid

26

fluor_rto

Float

fluor ratio

27

chl_1u

Float

Chlorophyll filtered with 1µ filter (mg m-3)

28

Phaeo_1u

Float

Phaeopigment filtered with 1µ (mg m-3)

29

fofa_1u

Float

Ratio of FO to FA, 1µ filter

30

vf_1u

Float

Volume filtered with 1µ filter ml

31

ve_1u

Float

Volume extracted ml

32

fo_1u

Float

Before acid added

33

fa_1u

Float

After acid

34

sens_1u

Float

Fluorometer sensitivity

35

chl_5u

Float

Chlorophyll filtered with 5µ filter (mg/m3)

36

Phaeo_5u

Float

Phaeopigment filtered with 5µ (mg/m3)

37

fofa_5u

Float

Ratio of FO to FA, 5µ filter

38

vf_5u

Float

Volume filtered with 5µ filter ml

39

ve_5u

Float

Volume extracted ml

40

sens_5u

Float

Fluorometer sensitivity

41

fo_5u

Float

Before acid added

42

fa_5u

Float

After acid

43

Tmp

Float

Temperature (°C) ITS-90

44

Sal

Float

Salinity (psu)

45

Conduct

Float

Conductivity (siemens/m)

46

Sig_T

Float

Sigma T (kg/m3)

47

Parcos

Float

PAR cosine (µE/m2/s)

48

par4pi

Float

PAR (µE/m2/s)

49

Transmiss

Float

Transmissivity (volts)

50

Chla

Float

Chla  (mg/m3)

51

Fluor

Float

Fluorescence  (mg/m3)

52

nh4*

Float

Ammonium (µM)

53

no2

Float

Nitrite (µM)

54

no3

Float

Nitrate  (µM)

55

sio4

Float

Silicate (µM)

56

po4

Float

Phosphate (µM)

57

tco2**

Float

Total CO2

58

o2**

Float

Oxygen (water sample)

59

oxy_ml

Float

Oxygen Saturation (sensor) ml

60

oxy_ps

Float

Oxygen Percent Saturation (sensor)

61

irrd_490**

Float

Satlantic irradiance channel 490 nm

62

irrd_520**

Float

Satlantic irradiance channel 520 nm

63

irrd_555**

Float

Satlantic irradiance channel 555 nm

64

Altimeter**

Float

Sonic Depth (m)

 

PCTD Table

Samples from the Profiling CTD (down cast), productivity and physical parameters (sensor data). One record for each meter in depth.

Owner: Francisco Chavez (P.I.), Tim Pennington (Project Manager), Reiko Michisaki

Keys: project, platform, expd, seq, depth

Note: * Sparsely populated field.  **Unpopulated field

Field

Field Name

Type

Description

1

Pctd_id

Integer

Database record ID

2

Cruise

Text

Cruise name, i.e. S197, SU93-1, 00798

3

Expd

Integer

Expedition ID, JJJYY i.e. 15896 JJJ=Day of Year, YY= year

4

Seq

Integer

Station  number

5

Depth

Integer

Target depth at which sample was taken (m)

6

Project

Text

Project Code, i.e. MUSE, PP, SU

7

ctrb_id

Text

MBARI Station Name

8

Platform

Text

Platform off of which the data were collected

9

Rjday

Integer

Running day of year from 01/01/1988

10

date_time

Date

CTD cast begins sample collection (GMT)

11

Jtime

Float

Time stamp (GMT)

12

year_date

Integer

YYYYJJJ Year and Day of Year

13

dec_lat

Float

Decimal Latitude

14

dec_long

Float

Decimal Longitude

15

site_id

Text

Site Name

16

ctd_id**

Text

CTD ID Number

17

Pressure

Float

Pressure at which sample was taken (db)

18

Tmp

Float

Temperature (°C) ITS-90

19

Sal

Float

Salinity (psu)

20

Conduct

Float

Conductivity (siemens/s)

21

Pot_temp

Float

Potential temperature (°C) ITS-90

22

Sigma_theta

Float

Sigma Theta (kg/m3)

23

Parcos

Float

PAR cosine sensor (µE/m2/s)

24

par4pi

Float

PAR 4pi sensor (µE/m2/s)

25

Chla

Float

Calculated Chla (mg/m3)

26

Fluor

Float

Fluorescence (volts)

27

trans_volts

Float

Transmissivity (volts)

28

trans_pct

Float

Transmissivity (%)

29

trans_beam**

Float

Transmissivity (?)

30

oxy_ml

Float

Oxygen (ml)

31

oxy_ps

Float

Oxygen (%)

32

OxyC**

Float

Oxygen current

33

OxyT**

Float

Oxygen temperature

34

Altimeter**

Float

Sonic Depth (m)

35

IR443**

Float

wavelength 443nm

36

IR490**

Float

wavelength 490 nm

37

IR555**

Float

wavelength 555 nm

Monterey Bay Aquarium Research Institute (MBARI)
7700 Sandholdt Road
Moss Landing, CA 95039
831-775-1739
http://www.mbari.org/bog