Data Repository : MCR LTER: Coral Reef: Water Column: Nearshore Water Profiles, CTD, Primary Production, and Chemistry

Data Object Description

Identifier:

knb-lter-mcr.10.29

Name:

MCR_LTER_timeseries_bottledata

Description:

Nutrients, pigments, particulates, cell abundance and other measures from Niskin bottles. CTD measurements (pressure bin, temperature, salinity, density anomaly, fluorescence, and turbidity) from depth bins corresponding to bottle depths are included. File format is acceptable input for Ocean Data View.

Additional Info:

This data table was designed to be loaded into the Ocean Data View program (ODV). The program is avaliable from the publisher at http://odv.awi.de/.

Physical Structure Description:

Object Name:

MCR_LTER_timeseries_bottledata_20111221.csv

Size:

63 Kb

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Attribute Orientation:

column

Simple Delimited:

Field Delimeter:	,
Quote Character:	"

Case Sensitive?

Number Of Records:

275

Online Distribution Info:
	http://mcr.lternet.edu/data/db/script/database/dbrequest.php?docid=knb-lter-mcr.10&entityindex=2

Coverage Description:

Time Period:

Begin:

2005-08-06

End:

2011-07-24

Constraint:

Primary Key:

Name:	bottle_data_pk
Key:	Sample_Number

Attribute(s) Info:

Name

Column Label

Definition

Type of Value

Measurement Type

Measurement Domain

Missing Value Code

Accuracy Report

Accuracy Assessment

Coverage

Method

Cruise

Cruise type identifier. Required by ODV.

string

nominal

Domain Info

Cruise_code

Cruise code

Cruise code groups multiple cruise days into one nominal month-year code as MonYY.

string

nominal

Def

MonYY as text

Location

Name of the location. Equivalent to ODV's Station Label and is required.

string

nominal

Domain Info

Type

Equivalent to ODV's Station Type and is required.

string

nominal

Domain Info

Date

Date of measurement. Required by ODV.

string

dateTime

Time

Time of measurement, Moorea local time. Required by ODV, in the format hh:mm, 24 hour.

string

dateTime

Code	99999
Expl	no measurement collected at this point, or not available

Latitude

Latitude Nominal (degN)

Nominal Latitude at the Location. North is positive. Required by ODV.

float

ratio

Unit	degree
Precision	0.00001
Type	real
Min	-90
Max	90

Longitude

Longitude Nominal (degE)

Nominal Longitude at the Location. East is positive. Required by ODV.

float

ratio

Unit	degree
Precision	0.00001
Type	real
Min	-180
Max	180

Bottom_Depth

Bottom Depth

Bottom Depth or Instrument Depth. Positive is down. Required by ODV.

float

ratio

Unit	meter
Precision	1
Type	real
Min	0
Max

Code	99999
Expl	no measurement collected at this point, or not available

Sample_Depth

Sample Depth

Depth the Niskin bottle was closed. Positive is down.

float

ratio

Unit	meter
Precision	1
Type	real
Min	0
Max	1000

Sample_Number

Sample Number

Number assigned to all samples taken from this Niskin bottle for various analyses.

string

ordinal

Def

integer as text

Pressure_bins

Pressure bins [db]

Center of the pressure averaging interval. Taken from CTD file.

float

ratio

Unit	decibar
Precision	0.1
Type	real
Min	0
Max	1000

Code	99999
Expl	no measurement collected at this point, or not available

Temperature

ITS-90, based on International Temperature Scale of 1990. Taken from CTD column T00.

float

interval

Unit	celsius
Precision	0.001
Type	real
Min	0
Max	100

Code	99999
Expl	no measurement collected at this point, or not available

Salinity

Salinity [PSU]

Salinity calculated according to the "Practical Salinity Scale of 1978" [PSU]. Taken from CTD file.

float

interval

Unit	dimensionless
Precision	0.0001
Type	real

Code	99999
Expl	no measurement collected at this point, or not available

Sigma_theta

Density Anomaly

Sigma-theta. Density anomaly calculated with in situ salinity, potential temperature and pressure=0. sigmatheta = density[kg/m3] - 1000kg/m3. (International Equation of State, Joint Panel on Oceanographic Tables and Standards, 1981). Taken from CTD file.

float

interval

Unit	kilogramPerCubicMeter
Precision	0.001
Type	real

Code	99999
Expl	no measurement collected at this point, or not available

Fluorescence

Estimated chl contentration from in-situ fluorometer. Taken from CTD file.

float

ratio

Unit	volt
Precision	0.001
Type	real

Code	99999
Expl	no measurement collected at this point

Turbidity

User supplied polynomial (used for turbidity in this case). upoly Taken from CTD file.

float

ratio

Unit	volt
Precision	0.001
Type	real

Code	99999
Expl	no measurement collected at this point

Phosphate

Concentration of reactive phosphate PO4.

float

ratio

Unit	micromolesPerLiter
Precision	0.01
Type	real

Code	99999
Expl	no measurement collected at this point

Silicate

Concentration of reactive silicate, H3SIO4, or Silicic Acid.

float

ratio

Unit	micromolesPerLiter
Precision	0.01
Type	real

Code	99999
Expl	no measurement collected at this point

Nitrite

Concentration of Nitrite, NO2

float

ratio

Unit	micromolesPerLiter
Precision	0.01
Type	real

Code	99999
Expl	no measurement collected at this point

Nitrite_and_Nitrate

Nitrite+Nitrate

Concentration of the sum of Nitrite and Nitrate, NO2+NO3

float

ratio

Unit	micromolesPerLiter
Precision	0.01
Type	real

Code	99999
Expl	no measurement collected at this point

POC

Particulate Organic Carbon

Concentration of Particulate Organic Carbon POC from CHN analysis.

float

ratio

Unit	micromolesPerLiter
Precision	0.01
Type	real

Code	99999
Expl	no measurement collected at this point

PON

Particulate Organic Nitrogen

Concentration of Particulate Organic Nitrogen PON from CHN analysis.

float

ratio

Unit	micromolesPerLiter
Precision	0.01
Type	real

Code	99999
Expl	no measurement collected at this point

TOC

Total Organic Carbon

Concentration of Total Organic Carbon.

float

ratio

Unit	micromolesPerLiter
Precision	0.01
Type	real

Code	99999
Expl	no measurement collected at this point
Code	NA
Expl	sample collected but not analyzed yet

TOC_SD

TOC standard deviation

Standard deviation of concentration of Total Organic Carbon.

float

ratio

Unit	micromolesPerLiter
Precision	0.01
Type	real

Code	99999
Expl	no measurement collected at this point
Code	NA
Expl	sample collected but not analyzed yet

Alkalinity

Total Alkalinity

Number of moles of hydrogen ion equivalent to the excess of proton acceptors in one kilogram of sea water.

float

ratio

Unit	micromolesPerKilogram
Precision	0.1
Type	real

Code	99999
Expl	no measurement collected at this point
Code	NA
Expl	sample collected but not analyzed yet

DIC

Dissolved Inorganic Carbon

Concentration of Dissolved Inorganic Carbon.

float

ratio

Unit	micromolesPerKilogram
Precision	0.1
Type	real

Code	99999
Expl	no measurement collected at this point
Code	NA
Expl	sample collected but not analyzed yet

Chlorophyll_a

Chlorophyll a

Concentration of Chlorophyll-a.

float

ratio

Unit	microgramsPerLiter
Precision	0.001
Type	real

Code	99999
Expl	no measurement collected at this point

Phaeopigments

Concentration of Phaeopigments.

float

ratio

Unit	microgramsPerLiter
Precision	0.001
Type	real

Code	99999
Expl	no measurement collected at this point

Primary_Production

Water Column Primary Production

Water Column Primary Production.

float

ratio

Unit	milligramsPerCubicMeterPerDay
Precision	0.01
Type	real

Code	99999
Expl	no measurement collected at this point

Bacteria_Abundance

Bacteria Abundance

Mean Bacterial Abundance as measured by DAPI fluorescent stain on slides. Discontinued after 2007.

float

ratio

Unit	numberPerMilliliter
Precision	1000
Type	real
Min	0
Max

Code	99999
Expl	no measurement collected at this point

Stained_Cell_Abundance

Stained Cell Abundance

Stained Cell Abundance as measured with Flow Cytometry

float

ratio

Unit	numberPerMilliliter
Precision	1000
Type	real
Min	0
Max

Code	99999
Expl	no measurement collected at this point

Autofluorescent_Cell_Abundance

Autofluorescent Cell Abundance

Autofluorescent Cell Abundance as measured with Flow Cytometry

float

ratio

Unit	numberPerMilliliter
Precision	10
Type	real
Min	0
Max

Code	99999
Expl	no measurement collected at this point
Code	NA
Expl	sample collected but not analyzed yet

Comments

Notes about these measurements.

string

nominal

Def

any text

Code	NA
Expl	no comment