Data Access Form

Dataset Title:	[Benthic flux data] - Sediment oxygen demand and ammonium, nitrate plus nitrate, and phosphate flux data from Little Lagoon, Alabama (Groundwater Discharge, Benthic Coupling and Microalgal Community Structure in a Shallow Coastal Lagoon)
Institution:	BCO-DMO (Dataset ID: bcodmo_dataset_723984)
Information:	Summary \| License \| ISO 19115 \| Metadata \| Background \| Files \| Make a graph

To work correctly, this web page requires that JavaScript be enabled in your browser. Please:
1) Enable JavaScript in your browser:
      • Chrome: "Settings : Advanced : Privacy and security : Site Settings : JavaScript"
      • Firefox: (it should be always on!)"
      • Opera: "Settings : Websites : JavaScript"
      • Safari: "Safari : Preferences : Security : Enable JavaScript"
2) Reload this web page.

Variable	Minimum	Maximum
Year (unitless)	1	2
Value_Description (unitless)	"Ammonium_flux umol..."	"Sediment_oxygen_de..."
Date (unitless)	"12-Apr"	"Sep-11"
East (umol m-2 hr-1; umol m-2 d-1)	-8369.1	16171.0
East_SE (umol m-2 hr-1; umol m-2 d-1)	0.02	2587.7
Mouth (umol m-2 hr-1; umol m-2 d-1)	-7083.4	12198.9
Mouth_SE (umol m-2 hr-1; umol m-2 d-1)	0.03	1680.1
West (umol m-2 hr-1; umol m-2 d-1)	-9539.0	22500.5
West_SE (umol m-2 hr-1; umol m-2 d-1)	0.03	5017.6

Server-side Functions

distinct()

Hover here to see a list of options. Click on an option to select it.

File type: (more information)

(Documentation / Bypass this form )

(Please be patient. It may take a while to get the data.)

The Dataset Attribute Structure (.das) for this Dataset

Attributes {
 s {
  Year {
    Byte _FillValue 127;
    String _Unsigned "false";
    Byte actual_range 1, 2;
    String bcodmo_name "unknown";
    String description "Year ID that samples were taken";
    String long_name "Year";
    String units "unitless";
  }
  Value_Description {
    String bcodmo_name "unknown";
    String description "Description of the measurment taken; description includes relevant units for each sample taken.";
    String long_name "Value Description";
    String units "unitless";
  }
  Date {
    String bcodmo_name "date";
    String description "Month and day that samples were taken; MMM-DD";
    String long_name "Date";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/ADATAA01/";
    String units "unitless";
  }
  East {
    Float32 _FillValue NaN;
    Float32 actual_range -8369.1, 16171.0;
    String bcodmo_name "unknown";
    String description "Benthic flux values from the East site; location of site is 30.253347, -87.724729";
    String long_name "East";
    String units "umol m-2 hr-1; umol m-2 d-1";
  }
  East_SE {
    Float32 _FillValue NaN;
    Float32 actual_range 0.02, 2587.7;
    String bcodmo_name "unknown";
    String description "Standard error of the benthic flux values from the East site";
    String long_name "East SE";
    String units "umol m-2 hr-1; umol m-2 d-1";
  }
  Mouth {
    Float32 _FillValue NaN;
    Float32 actual_range -7083.4, 12198.9;
    String bcodmo_name "unknown";
    String description "Benthic flux values from the Mouth site; location of site is 30.243683, -87.738407";
    String long_name "Mouth";
    String units "umol m-2 hr-1; umol m-2 d-1";
  }
  Mouth_SE {
    Float32 _FillValue NaN;
    Float32 actual_range 0.03, 1680.1;
    String bcodmo_name "unknown";
    String description "Standard error of the benthic flux values from the Mouth site";
    String long_name "Mouth SE";
    String units "umol m-2 hr-1; umol m-2 d-1";
  }
  West {
    Float32 _FillValue NaN;
    Float32 actual_range -9539.0, 22500.5;
    String bcodmo_name "unknown";
    String description "Benthic flux values from the West site; location of site is 30.247181, -87.767856";
    String long_name "West";
    String units "umol m-2 hr-1; umol m-2 d-1";
  }
  West_SE {
    Float32 _FillValue NaN;
    Float32 actual_range 0.03, 5017.6;
    String bcodmo_name "unknown";
    String description "Standard error of the benthic flux values from the West site";
    String long_name "West SE";
    String units "umol m-2 hr-1; umol m-2 d-1";
  }
 }
  NC_GLOBAL {
    String access_formats ".htmlTable,.csv,.json,.mat,.nc,.tsv";
    String acquisition_description 
"Little Lagoon is a shallow coastal lagoon that is tidally connected to the
Gulf of Mexico but has no riverine inputs. The water in the lagoon is
replenished solely from precipitation and groundwater inputs primarily on the
East end (Su et al. 2012). Because of the rapid development in Baldwin County,
a large amount of NO3- enters the Little Lagoon system through SGD (Murgulet &
Tick 2008). In this region, there can be rapid changes in the depth to
groundwater (Fig. 4.1 inset) and episodic SGD inputs to the lagoon (Su et
al.2013). Within the lagoon, three sites were selected (East, Mouth, and West)
to represent the gradient that exists across the lagoon from the input of
groundwater. Sites were sampled on a near-monthly basis from February 2012 to
February 2013.
 
Benthic fluxes from intact sediment cores
 
At each site triplicate intact sediment cores (270 mm x 95 mm ID; 190 mm
sediment, 50 mm water column) were collected and setup in a flow-through
system (Lavrentyev et al. 2000) in a darkened environmental chamber set to the
average site temperature within 8 hours of collection. The flow-through system
consisted of a multichannel proportioning pump that sent 0.7 micron filtered
and ~100 \\u03bcM Na15NO3 - (99 atom %) enriched site water
(\\u201cinflow\\u201d) at a continuous flow rate (1.2 mL min-1) to the overlying
water above the sediment surface. The positive displacement of the overlying
water exited the core through an outflow tube (\\u201coutflow\\u201d) and
collected in a reservoir. The volume of water overlying each sediment core was
exchanged five times during a 24-hour incubation period to equilibrate the
cores (Eyre et al. 2002). After the initial 24 hours, triplicate inflow and
outflow samples were collected at 36 hours for dissolved gas and nutrient
analysis. Dissolved gas analysis followed the modified Isotope pairing
technique (IPT) (Nielsen 1992, Risgaard-Petersen et al. 2003). In this
approach, rates of 29N2 and 30N2 production from 15NO3 - are quantified and
used to calculate rates of 14N2 production (p14) (equation 1, below); when
combined with 15N tracer slurry incubations (below), rates of anammox, and the
relative contribution of anammox and denitrification to p14 can be determined
(equations 2-4, below).
 
Water samples were collected in 12 mL Exetainers, allowing the vial to
overflow two times the tube volume prior to preservation with 250 \\u03bcL of
50% (w/v) ZnCl2 before being capped. Samples were stored under water in the
environmental chamber until dissolved gas analysis on a membrane inlet mass
spectrometer (MIMS) equipped with a copper reduction column set at 600oC to
remove oxygen (O2) (Kana et al. 1998, Eyre et al. 2002). Benthic nutrient flux
samples were filtered (0.7 micron) and immediately frozen until DIN (NO2 -,
NO3 -, NH4 +) and PO4 3- analyses as described above.
 
Sediment oxygen demand (SOD) was measured from oxygen concentrations in inflow
and outflow water analyzed with a calibrated microelectrode and a Unisense
\\u00ae multimeter analyzer. Denitrification and benthic flux calculations
(\\u03bcmol m-2 hr-1) determined flux into or out of the sediment using the
influent and effluent concentrations, flow rate (1.2 ml min-1), and the
surface area of the sediment (0.00708 m-2). All rates and fluxes pertaining to
N species are expressed on a N atom basis. A positive flux indicates release
from the sediments to the water column and a negative flux indicates uptake by
the sediment.
 
Additional methodology can be found in:
 
Bernard, Rebecca & Mortazavi, Behzad & A. Kleinhuizen, Alice. (2015).
Dissimilatory nitrate reduction to ammonium (DNRA) seasonally dominates
NO3\\u2212 reduction pathways in an anthropogenically impacted sub-tropical
coastal lagoon. Biogeochemistry. 125.
47-64.\\u00a0[10.1007/s10533-015-0111-6](\\\\\"https://link.springer.com/article/10.1007%2Fs10533-015-0111-6\\\\\").\\u00a0";
    String awards_0_award_nid "497637";
    String awards_0_award_number "OCE-0962008";
    String awards_0_data_url "http://nsf.gov/awardsearch/showAward?AWD_ID=0962008";
    String awards_0_funder_name "NSF Division of Ocean Sciences";
    String awards_0_funding_acronym "NSF OCE";
    String awards_0_funding_source_nid "355";
    String awards_0_program_manager "David L. Garrison";
    String awards_0_program_manager_nid "50534";
    String cdm_data_type "Other";
    String comment 
"Benthic Flux 
  B. Mortazavi and W. Burnett, PIs 
  Version 16 January 2018";
    String Conventions "COARDS, CF-1.6, ACDD-1.3";
    String creator_email "info@bco-dmo.org";
    String creator_name "BCO-DMO";
    String creator_type "institution";
    String creator_url "https://www.bco-dmo.org/";
    String data_source "extract_data_as_tsv version 2.3  19 Dec 2019";
    String date_created "2018-01-17T20:12:09Z";
    String date_modified "2019-03-15T14:17:51Z";
    String defaultDataQuery "&amp;time&lt;now";
    String doi "10.1575/1912/bco-dmo.723984.1";
    String history 
"2024-11-08T06:04:48Z (local files)
2024-11-08T06:04:48Z https://erddap.bco-dmo.org/erddap/tabledap/bcodmo_dataset_723984.html";
    String infoUrl "https://www.bco-dmo.org/dataset/723984";
    String institution "BCO-DMO";
    String instruments_0_acronym "Gas Analyzer";
    String instruments_0_dataset_instrument_description "Used to analyze sediment oxygen demand";
    String instruments_0_dataset_instrument_nid "724404";
    String instruments_0_description "Gas Analyzers - Instruments for determining the qualitative and quantitative composition of gas mixtures.";
    String instruments_0_instrument_name "Gas Analyzer";
    String instruments_0_instrument_nid "720";
    String instruments_0_supplied_name "Unisense multimeter analyzer";
    String instruments_1_dataset_instrument_description "Used to filter sediment cores";
    String instruments_1_dataset_instrument_nid "724402";
    String instruments_1_description "A pump is a device that moves fluids (liquids or gases), or sometimes slurries, by mechanical action. Pumps can be classified into three major groups according to the method they use to move the fluid: direct lift, displacement, and gravity pumps";
    String instruments_1_instrument_name "Pump";
    String instruments_1_instrument_nid "726";
    String instruments_1_supplied_name "Multichannel proportioning pump";
    String instruments_2_acronym "MIMS";
    String instruments_2_dataset_instrument_description "Used for dissolved gas analysis";
    String instruments_2_dataset_instrument_nid "724403";
    String instruments_2_description "Membrane-introduction mass spectrometry (MIMS) is a method of introducing analytes into the mass spectrometer's vacuum chamber via a semipermeable membrane.";
    String instruments_2_instrument_name "Membrane Inlet Mass Spectrometer";
    String instruments_2_instrument_nid "661606";
    String instruments_2_supplied_name "MIMS";
    String keywords "bco, bco-dmo, biological, chemical, data, dataset, date, description, dmo, east, East_SE, erddap, management, mouth, Mouth_SE, oceanography, office, preliminary, value, Value_Description, west, West_SE, year";
    String license "https://www.bco-dmo.org/dataset/723984/license";
    String metadata_source "https://www.bco-dmo.org/api/dataset/723984";
    String param_mapping "{'723984': {}}";
    String parameter_source "https://www.bco-dmo.org/mapserver/dataset/723984/parameters";
    String people_0_affiliation "National Science Foundation";
    String people_0_affiliation_acronym "NSF-DEB";
    String people_0_person_name "Dr Behzad Mortazavi";
    String people_0_person_nid "491316";
    String people_0_role "Principal Investigator";
    String people_0_role_type "originator";
    String people_1_affiliation "Florida State University";
    String people_1_affiliation_acronym "FSU - EOAS";
    String people_1_person_name "Dr William C. Burnett";
    String people_1_person_nid "491315";
    String people_1_role "Co-Principal Investigator";
    String people_1_role_type "originator";
    String people_2_affiliation "National Science Foundation";
    String people_2_affiliation_acronym "NSF-DEB";
    String people_2_person_name "Dr Behzad Mortazavi";
    String people_2_person_nid "491316";
    String people_2_role "Contact";
    String people_2_role_type "related";
    String people_3_affiliation "Woods Hole Oceanographic Institution";
    String people_3_affiliation_acronym "WHOI BCO-DMO";
    String people_3_person_name "Hannah Ake";
    String people_3_person_nid "650173";
    String people_3_role "BCO-DMO Data Manager";
    String people_3_role_type "related";
    String project "LittleLagoonGroundwater";
    String projects_0_acronym "LittleLagoonGroundwater";
    String projects_0_description "This project investigated the link between submarine groundwater discharge (SGD) and microalgal dynamics in Little Lagoon, Alabama.  In contrast to most near-shore environments, it is fully accessible; has no riverine inputs; and is large enough to display ecological diversity (c. 14x 0.75 km) yet small enough to be comprehensively sampled on appropriate temporal and spatial scales. The PIs have previously demonstrated that the lagoon is a hot-spot for toxic blooms of the diatom Pseudo-nitzchia spp. that are correlated with discharge from the surficial aquifer. This project assessed variability in SGD, the dependence of benthic nutrient fluxes on microphytobenthos (MPB) abundance and productivity, and the response of the phytoplankton to nutrient enrichment and dilution. The work integrated multiple temporal and spatial scales and demonstrated both the relative importance of SGD vs. benthic recycling as a source of nutrients, and the role of SGD in structuring the microalgal community. (paraphrased from Award abstract)";
    String projects_0_end_date "2014-08";
    String projects_0_geolocation "southern Alabama, east of Mobile";
    String projects_0_name "Groundwater Discharge, Benthic Coupling and Microalgal Community Structure in a Shallow Coastal Lagoon";
    String projects_0_project_nid "491318";
    String projects_0_start_date "2010-03";
    String publisher_name "Biological and Chemical Oceanographic Data Management Office (BCO-DMO)";
    String publisher_type "institution";
    String sourceUrl "(local files)";
    String standard_name_vocabulary "CF Standard Name Table v55";
    String summary "Sediment oxygen demand and ammonium, nitrate plus nitrate, and phosphate flux data from Little Lagoon, Alabama from 2010-2013";
    String title "[Benthic flux data] - Sediment oxygen demand and ammonium, nitrate plus nitrate, and phosphate flux data from Little Lagoon, Alabama (Groundwater Discharge, Benthic Coupling and Microalgal Community Structure in a Shallow Coastal Lagoon)";
    String version "1";
    String xml_source "osprey2erddap.update_xml() v1.3";
  }
}

Using tabledap to Request Data and Graphs from Tabular Datasets

tabledap lets you request a data subset, a graph, or a map from a tabular dataset (for example, buoy data), via a specially formed URL. tabledap uses the OPeNDAP (external link)

Data Access Protocol (DAP) (external link)

and its selection constraints (external link)

The URL specifies what you want: the dataset, a description of the graph or the subset of the data, and the file type for the response.

(easy) You can get data by using the dataset's Data Access Form or Subset form. They make the URL for you.
(easy) You can make a graph or map by using the dataset's Make A Graph form. It makes the URL for you.
(not hard) You can bypass the forms and get the data or make a graph or map by generating the URL by hand or with a computer program or script.

Tabledap request URLs must be in the form
https://coastwatch.pfeg.noaa.gov/erddap/tabledap/datasetID.fileType{?query}
For example,
https://coastwatch.pfeg.noaa.gov/erddap/tabledap/pmelTaoDySst.htmlTable?longitude,latitude,time,station,wmo_platform_code,T_25&time>=2015-05-23T12:00:00Z&time<=2015-05-31T12:00:00Z
Thus, the query is often a comma-separated list of desired variable names, followed by a collection of constraints (e.g., variable<value), each preceded by '&' (which is interpreted as "AND").

For details, see the tabledap Documentation.