Data Package Metadata View Summary

Monthly nitrate concentrations in the Des Moines River above Saylorville Reservoir, 1976 - 2016

General Information

Data Package:
Local Identifier:	edi.451.1
Title:	Monthly nitrate concentrations in the Des Moines River above Saylorville Reservoir, 1976 - 2016
Alternate Identifier:	DOI PLACE HOLDER
Abstract:	Regular water quality sampling occurs along the Des Moines River from upstream of the Saylorville Reservoir to below the dam at Red Rock Reservoir. The data included in this data set are the mean monthly nitrate concentrations and flow from the sampling station upstream of Saylorville Reservoir from 1976-2016. This dataset is to accompany paper in review: "Beyond the trends: The need to understand multi-annual dynamics in aquatic ecosystems" (Limnology and Oceanography Letters)
Publication Date:	2019-12-20

Time Period

Begin:

1976-01-01

End:

2016-12-31

People and Organizations
Contact:	Wilkinson, Grace (Iowa State University) [ email ]
Creator:	Wilkinson, Grace (Iowa State University)
Creator:	Crumpton, William (Iowa State University)
Creator:	Rehmann, Chris (Iowa State University)
Creator:	Noack, Benjamin (Iowa State University)
Creator:	Sandry, Elena (Iowa State University)

Data Entities
Data Table Name:	Wilkinson_DesMoinesRiver_NitrateFlow
Description:	Monthly nitrate concentration and water flow in the Des Moines River near Saylorville Reservior
Other Name:	Wilkinson et al, Des Moines River Analysis code
Description:	Code used to analyze this file

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/451/1/38b4289ab21b71cbea87b8e3400a3670
Name:	Wilkinson_DesMoinesRiver_NitrateFlow
Description:	Monthly nitrate concentration and water flow in the Des Moines River near Saylorville Reservior
Number of Records:	492
Number of Columns:	4

Table Structure

Object Name:

Wilkinson_DesMoinesRiver_NitrateFlow.csv

Size:

9426

Text Format:

Number of Header Lines:

Orientation:

column

Simple Delimited:

Field Delimiter:

Table Column Descriptions

Year

Month

NO3 mg/L (as N)

Flow, cfs

Column Name:

Year

Month

no3_mgL

flow_cfs

Definition:

The year that the sample was taken

The month that the sample was taken

The mean monthly nitrate concentration, as milligrams N per liter (missing data were interpolated)

The mean monthly flow during the sampling events

Storage Type:

string

decimal

Measurement Type:

dateTime

nominal

ratio

Measurement Values Domain:

Format	YYYY
Precision	1.0

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	January
Source

Code Definition

Code	2
Definition	February
Source

Code Definition

Code	3
Definition	March
Source

Code Definition

Code	4
Definition	April
Source

Code Definition

Code	5
Definition	May
Source

Code Definition

Code	6
Definition	June
Source

Code Definition

Code	7
Definition	July
Source

Code Definition

Code	8
Definition	August
Source

Code Definition

Code	9
Definition	September
Source

Code Definition

Code	10
Definition	October
Source

Code Definition

Code	11
Definition	November
Source

Code Definition

Code	12
Definition	December
Source

Unit	milligramPerLiter
Type	real

Unit	footCubedPerSecond
Precision	1.0
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Non-Categorized Data Resource

Name:

Wilkinson et al, Des Moines River Analysis code

Entity Type:

text

Description:

Code used to analyze this file

Physical Structure Description:

Object Name:

allFigsAnalyses_R1.R

Size:

8041

Text Format:

Orientation:

column

Simple Delimited:

Field Delimiter:

comma

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/451/1/7ab692af3ebbc9ce3057b61a9f3222ca

Data Package Usage Rights

This data package is released to the "public domain" under Creative Commons CC0 1.0 "No Rights Reserved" (see: https://creativecommons.org/publicdomain/zero/1.0/). It is considered professional etiquette to provide attribution of the original work if this data package is shared in whole or by individual components. A generic citation is provided for this data package on the website https://portal.edirepository.org (herein "website") in the summary metadata page. Communication (and collaboration) with the creators of this data package is recommended to prevent duplicate research or publication. This data package (and its components) is made available "as is" and with no warranty of accuracy or fitness for use. The creators of this data package and the website shall not be liable for any damages resulting from misinterpretation or misuse of the data package or its components. Periodic updates of this data package may be available from the website. Thank you.

Keywords

By Thesaurus:
(No thesaurus)	Nitrate, flow, water quality, Des Moines River, Iowa, Army Corps of Engineers

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

Methods and protocols used in the collection of this data package

Description:

Water samples are collected from the Des Moines River monthly (November through February) or bi-weekly (March through October) to monitor water quality of the river above and below two major reservoirs constructed by the US Army Corps of Engineers (Saylorville and Red Rock Reservoirs).

The water samples are kept on ice until they are returned to the lab for analysis. For nitrate analysis, the samples are filtered with a glass fiber filter (nominal pore size = 0.45 micrometer), preserved with concentrated sulfuric acid, and analyzed using the cadmium reduction method (EPA 353.2 v2) on a Seal AQ2 Discrete Analyzer.

Duplicate samples are taken at a rate of 10% in the field. In the lab, nitrate sample analysis is duplicated at a rate of 100% and must be within 20% of each other. Sample are spiked at a rate of 10% and the spike recovery range is +/- 20%. Two quality control standards are analyzed every 7-10 samples in the analysis run with an acceptable range of +/-10% the expected concentration.

People and Organizations

Creators:

Individual:

Grace Wilkinson

Organization:

Iowa State University

Email Address:

wilkinso@iastate.edu

Individual:

William Crumpton

Organization:

Iowa State University

Email Address:

crumpton@iastate.edu

Individual:

Chris Rehmann

Organization:

Iowa State University

Email Address:

rehmann@iastate.edu

Individual:

Benjamin Noack

Organization:

Iowa State University

Email Address:

bnoack@iastate.edu

Individual:

Elena Sandry

Organization:

Iowa State University

Email Address:

esandry@iastate.edu

Contacts:

Individual:

Grace Wilkinson

Organization:

Iowa State University

Email Address:

wilkinso@iastate.edu

Temporal, Geographic and Taxonomic Coverage

Temporal, Geographic and/or Taxonomic information that applies to all data in this dataset:

Time Period

Begin:

1976-01-01

End:

2016-12-31

Sampling Site:

Description:

Des Moines River, near Boone Water Plant, County Road E-26 bridge, just above low-head dam, Boone County, 258.8 mi upstream from mouth, upstream of Saylorville Reservoir

Site Coordinates:

Longitude (degree):

-93.937821

Latitude (degree):

42.08066

Project

Parent Project Information:

Title:

Des Moines River Water Quality Monitoring Network

Personnel:

Individual:	Grace Wilkinson
Role:	PI

Abstract:

Funding:

US Army Corps of Engineers

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'unitList'
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'abbreviation' = 'mg/l'
        |     |     |     |  \___attribute 'constantToSI' = '0'
        |     |     |     |  \___attribute 'id' = 'milligramPerLiter'
        |     |     |     |  \___attribute 'multiplierToSI' = '0.001'
        |     |     |     |  \___attribute 'name' = 'milligramPerLiter'
        |     |     |     |  \___attribute 'parentSI' = 'kilogramPerCubicMeter'
        |     |     |     |  \___attribute 'unitType' = 'massDensity'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'milligrams / liter'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'abbreviation' = 'ft³/sec'
        |     |     |     |  \___attribute 'constantToSI' = '0'
        |     |     |     |  \___attribute 'id' = 'footCubedPerSecond'
        |     |     |     |  \___attribute 'multiplierToSI' = '28.3169'
        |     |     |     |  \___attribute 'name' = 'footCubedPerSecond'
        |     |     |     |  \___attribute 'parentSI' = 'litersPerSecond'
        |     |     |     |  \___attribute 'unitType' = 'volumetricRate'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'cubic feet per second'
        |     |     |     |___text '\n        '
        |     |     |___text '\n      '
        |     |___text '\n    '
        |___text '\n  '

Copyright 2024 Environmental Data Initiative. This material is based upon work supported by the National Science Foundation under grants #2223103 and #2223104. Any opinions, findings, conclusions, or recommendations expressed in the material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation. Please contact us with questions, comments, or for technical assistance regarding this web site or the Environmental Data Initiative. Please read our privacy policy to know what information we collect about you and to understand your privacy rights.

EDI is a collaboration between the University of New Mexico and the University of Wisconsin – Madison, Center for Limnology:

Data Package Metadata View Summary

Monthly nitrate concentrations in the Des Moines River above Saylorville Reservoir, 1976 - 2016

Data Entities

Data Table

Non-Categorized Data Resource

Data Package Usage Rights

Keywords

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Parent Project Information:

Additional Metadata

Recently Added

Recently Updated

Data Package Metadata View Summary

Monthly nitrate concentrations in the Des Moines River above Saylorville Reservoir, 1976 - 2016

+/- Data Entities

Data Table

Non-Categorized Data Resource

+/- Data Package Usage Rights

+/- Keywords

+/- Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

+/- People and Organizations

+/- Temporal, Geographic and Taxonomic Coverage

+/- Project

Parent Project Information:

+/- Additional Metadata

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Additional Metadata