Data QA/QC‎ > ‎QA/QC workshop‎ > ‎

Units and metadata requirements for data reporting and exchange

The following discussion and recommendations were made during the workshop on QA/QC of chemical oceanographic data in February 2010. Official guidelines for specific chemical compounds e.g. ocean acidification data and nutrient data have been published since (see links in Data reporting and exchange sections) and the guidelines they contain should be read in conjunction with our recommendations. Comments are invited via the "Comment" box below.

1     Can we recommend an existing best practice document for data reporting and exchange?

While informal recommendations and guidelines for submitting data do exist in a number of data centers, the group was not aware of the existence of a best practice document dealing specifically with oceanographic chemical data reporting and exchange.

Proposal: the meeting agreed that there is no existing document and that one should be developed.

Meanwhile, it is recommended that at a minimum, the following information be provided in data report prepared by data originators when the data are submitted to the data centers:

  • sample preservation/handling/transport protocol (after sampling but before analysis);
  • analytical method specification with reference (e.g. published, citable reference used or deviations from reference cited), specifying procedure, equipment, precision, accuracy, method detection limit, significant figures as determined by the measurement precision;
  • sampling and sample preparation including filtration,  preservation and analysis;
  • Certified Reference Material (CRM), or standard availability and use;
  • estimation of measurement uncertainty;
  • inter-laboratory comparison study availability;
  • laboratory analysis duplicate limits (repeatability of analysis);
  • use of internal QC with specified precision limits.

If the laboratory is accredited then this should be specified.

2     Can we agree on a common reporting terminology and unit for each variable?

Data submitted to data centres use non standard and sometimes inaccurate or ambiguous terminology to label chemical parameters and units.

With regards to parameter names:

Proposal: the meeting recommended the following terminology for dissolved inorganic nutrients and dissolved oxygen in seawater:

  • Recommended term: SILICATE [Silicic acid is the dominant form of reactive silicate in seawater (e.g., Gordon et al., 1993; Isshiki et al., 1991)]
  • Recommended term: NITRATE+NITRITE should be reported if this is what was measured.
  • Recommended term: NITRATE (specify whether it was measured directly or if reported as subtracted from measurements of NITRATE+NITRITE minus NITRITE; if the latter then NITRITE should also be reported)
  • Recommended term: NITRITE
  • Recommended term: PHOSPHATE
  • Recommended term: OXYGEN
  • Recommended term: AMMONIUM

For accuracy, abbreviations of measured variables and concentration units should be spelled out completely as part of the metadata.

The issue of units usage and conversion was then discussed in depth. Units should follow the international standards and be as close to the measurement unit as possible.

Proposal: it was recommended to use units of micromole per liter (μmol / l)  which complies with the SI recommendation (NIST Special Publication 330, 2008) for both dissolved nutrients and dissolved oxygen.

However while the group agreed that concentrations should be reported on a mole per volume basis, it was recognized that a large part of the oceanographic community required concentration of substance in sea water to be reported in units of moles per kilogram.

It is therefore recommended that data producers provide sufficient information to enable values to be converted to/from per volume/per mass for both nutrient and oxygen data. The meeting recognized the difficulty in the conversion between per volume and per mass units, for the reason that the exact temperature and salinity which were used (for the conversion) are not always reported. In order to do an accurate conversion from units of moles per mass to units of moles per volume, the originator of the data needs to provide at a minimum the seawater density conversion factor and the equation of state used in the conversion. In order to convert units of moles per volume into units of moles per mass the originator needs to provide the appropriate temperature, which is, for nutrients, laboratory temperature at the time the sample was analyzed, and for oxygen, water temperature at the sample was drawn.

As a conclusion the group recommended that:

  • if submitting data in units per mass, originators supply sufficient information to enable future conversion from per mass to per volume units (and vice versa) to be done accurately. At a minimum this requires the density conversion factor, the equation of state and the temperature used in the calculation of the density;
  • if submitting data in units per volume, originators should also supply the temperature of oxygen sample fixation if measured or, for nutrients, the temperature of the analysed sample (i.e. laboratory temperature), and in situ salinity if not already held at the data center. 
Č
Ċ
ď
Gwenaelle Moncoiffe,
13 Jan 2010 05:17
Ċ
ď
Gwenaelle Moncoiffe,
1 Feb 2010 05:41
ĉ
ď
Gwenaelle Moncoiffe,
15 Jan 2010 07:16
Ċ
ď
Gwenaelle Moncoiffe,
7 Feb 2010 02:41
Ċ
ď
Gwenaelle Moncoiffe,
13 Jan 2010 05:55
Ċ
ď
Gwenaelle Moncoiffe,
5 Feb 2010 07:31

Comments

Hernan Garcia - 12 Jan 2010 10:34

Recommended use of Certified Reference materials for Nutrients: INSS(International Nutrients Scale System) The International Nutrients Scale System (INSS) is an international collaborative programme with the aim of establishing global comparability and traceability of nutrient data in the world ocean (see http://www.mri-jma.go.jp/Dep/ge/INSSindex/index.html)

Hernan Garcia - 13 Jan 2010 05:20

The document "EOS_Vol90_50_Dec2009_data_publication.pdf" is an article by Roy Lowry (BODC), Ed Urban (SCOR), and Peter Pissierssens (IODE)on data publication in ocean sciences

Hernan Garcia - 13 Jan 2010 05:57

Document "WODOriginator_units.pdf " is a list of originator data units available at the NODC World Ocean Database. A set of unit conversion units have been developed to convert when needed from these units to our standard reporting data units (see appendix 3 in Johnson, D.R., T.P. Boyer, H.E. Garcia, R.A. Locarnini, O.K. Baranova, and M.M. Zweng, 2009. World Ocean Database 2009 Documentation. Edited by Sydney Levitus. NODC Internal Report 20, NOAA Printing Office, Silver Spring, MD, 175 pp. Document available at http://www.nodc.noaa.gov/OC5/WOD09/pr_wod09.html).

Laure.Devine@dfo-mpo.gc.ca - 15 Jan 2010 07:20

"Unit-conversions_en.doc" describes the variables held in IML's data archive, the units they are reported in, and unit conversions.

Hernan Garcia - 1 Feb 2010 05:43

File "ISO17025AssuringQualityofresults.pdf" describes some of the ISO 17025 requirements. The 1 pager contains the relevant items from the standard as well as some additional information on what specific steps should be taken to assure the quality of the laboratory produced results (Information supplied by Andrew Pascall, Laboratory Manager, CSIR, Natural resources and the Environment)

Sergey Konovalov - 5 Feb 2010 08:03

Initial analytical concentrations MUST be saved in data bases. If so, concentrations are in X(ml, mg, µM) per liter and the salinity issue is actual for only silicates. This provides the possibility to always come back to the initial point, when various questions are raised on the quality of data. This is the reason that oxygen probe data are archived in µA, for example. If calibration is changed after some expert's work, it is possible to recalculate data. We have to simplify the problem and to limit "chemical" problems to analytical and sampling issues. Where it comes to oxygen generated with Winkler's titration method, mg/l would be the best unit, as no assumptions on ideal/real gas properties, temperature influence, etc. are incorporated.

Tools have to be provided and incorporated in data bases making possible to calculate and recalculate concentration units and derivatives (AOU, for example). If temperature, salinity, etc. are corrected/changed, derivatives are changed accordingly, BUT initial analytical data remain safe.

When some products (atlases, GIS's, etc.) are produced, information on units conversion and used derivatives are included in the product. EXAMPLE: WOD09 practical approach. WOD9 is an extremely good product. Yet, it is one of the products based on initial data bases. We may do some decent assumptions (about a common conversion factor 1025 kg/m3 for historical data for example) constructing products, but we must include information on these assumption in the product. When it comes to data bases, any assumptions are not good. They could be recognized as not good in a while and they may lead to some artifacts (historical trends, for example).

Sergey Konovalov - 7 Feb 2010 02:36

In Unit-conversions_en#comments.pdf I added comments to the original text. The idea to generate the list of units and their conversion is extremely good. Yet, it looks better to me to add some explanations because chemists are not always involved in data management and a formal application of units may lead to artifacts.