BCO-DMO ERDDAP
Accessing BCO-DMO data
log in    
Brought to you by BCO-DMO    

ERDDAP > tabledap > Data Access Form ?

Dataset Title:  Potential denitrification and N2 fixation from slurry assays from Little
Lagoon, Alabama collected from 2012-2013
Subscribe RSS
Institution:  BCO-DMO   (Dataset ID: bcodmo_dataset_723957)
Information:  Summary ? | License ? | ISO 19115 | Metadata | Background (external link) | Subset | Files | Make a graph
 
Variable ?   Optional
Constraint #1 ?
Optional
Constraint #2 ?
   Minimum ?
   or a List of Values ?
   Maximum ?
 
 Year (unitless) ?      
   - +  ?
 Date (unitless) ?          "11-Jun"    "11-Sep"
 Value_Description (unitless) ?          "Potential_denitrif..."    "Total_N2_fixation"
 Mouth (nanomol of nitrogen per gram per hour) ?          1.19    13.8
 Mouth_SE (nanomol of nitrogen per gram per hour) ?          0.05    1.59
 West (nanomol of nitrogen per gram per hour) ?          0.98    14.72
 West_SE (nanomol of nitrogen per gram per hour) ?          0.02    0.74
 East (nanomol of nitrogen per gram per hour) ?          0.58    14.56
 East_SE (nanomol of nitrogen per gram per hour) ?          0.02    2.94
 
Server-side Functions ?
 distinct() ?
? ("Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.")

File type: (more info)

(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;
    Byte actual_range 1, 1;
    String bcodmo_name "unknown";
    String description "Year ID that samples were taken";
    String long_name "Year";
    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";
  }
  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";
  }
  Mouth {
    Float32 _FillValue NaN;
    Float32 actual_range 1.19, 13.8;
    String bcodmo_name "N";
    String description "Denitrification and Nitrogen fixation values collected at the site Mouth; location of site is 30.243683, -87.738407";
    String long_name "Mouth";
    String units "nanomol of nitrogen per gram per hour";
  }
  Mouth_SE {
    Float32 _FillValue NaN;
    Float32 actual_range 0.05, 1.59;
    String bcodmo_name "N";
    String description "Standard error of the values collected at the site Mouth";
    String long_name "Mouth SE";
    String units "nanomol of nitrogen per gram per hour";
  }
  West {
    Float32 _FillValue NaN;
    Float32 actual_range 0.98, 14.72;
    String bcodmo_name "N";
    String description "Denitrification and Nitrogen fixation values collected at the site West; location of site is 30.247181, -87.767856";
    String long_name "West";
    String units "nanomol of nitrogen per gram per hour";
  }
  West_SE {
    Float32 _FillValue NaN;
    Float32 actual_range 0.02, 0.74;
    String bcodmo_name "N";
    String description "Standard error of the values collected at the site West";
    String long_name "West SE";
    String units "nanomol of nitrogen per gram per hour";
  }
  East {
    Float32 _FillValue NaN;
    Float32 actual_range 0.58, 14.56;
    String bcodmo_name "N";
    String description "Denitrification and Nitrogen fixation values collected at the site East; location of site is 30.253347, -87.724729";
    String long_name "East";
    String units "nanomol of nitrogen per gram per hour";
  }
  East_SE {
    Float32 _FillValue NaN;
    Float32 actual_range 0.02, 2.94;
    String bcodmo_name "N";
    String description "Standard error of the values collected at the site East";
    String long_name "East SE";
    String units "nanomol of nitrogen per gram per hour";
  }
 }
  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.
 
Potential denitrification and N2 fixation from slurry assays
 
The top 50 mm of sediment at each site were collected in duplicate with a
large core (95 mm ID) and homogenized. Potential denitrification rates were
measured following the acetylene inhibition technique (S\\u00f8rensen 1978) but
may underestimate denitrification supported by coupled nitrification-
denitrification, as this method inhibits nitrification. To triplicate serum
vials, approximately 20 g of sediments and filtered (0.7 micron) site water
were added at various treatments (control and N addition (100 \\u03bcM and 500
\\u03bcM KNO3 -). Samples were sealed with a butyl rubber stopper, capped and
flushed with N2 gas for 10 minutes. After the addition of C2H2 (10% v/v) and a
1-hour incubation, headspace gas samples were injected into evacuated 12 ml
Exetainer vials and N2O production was quantified with a Shimadzu GC-2014 with
an electron capture detector (GC-ECD) within 24 hours.
 
Potential N2 fixation rates were measured as ethylene (C2H4) production from
acetylene (C2H2) reduction (Welsh et al. 1996) in triplicate from slurry
assays containing 20 g of homogenized sediment and filtered (0.7 micron) site
water. Rates of N2 fixation by sulfate reducing bacteria (SRB) were determined
after the addition of sodium molybdate as a specific inhibitor of the sulfate
reduction process (Hardy et al. 1973, Capone 1993). After C2H4 analysis on a
Shimadzu gas chromatograph (GC-2014) with flame ionization detection (GC-FID),
production rates of C2H4 were converted to potential N2 fixation rates using a
C2H2:N2 reduction ratio of 3:1 (Capone 1993).
 
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 
"DNF and N2 Data 
  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:11:20Z";
    String date_modified "2019-03-15T18:09:49Z";
    String defaultDataQuery "&time<now";
    String doi "10.1575/1912/bco-dmo.723957.1";
    String history 
"2024-03-29T15:02:59Z (local files)
2024-03-29T15:02:59Z https://erddap.bco-dmo.org/erddap/tabledap/bcodmo_dataset_723957.html";
    String infoUrl "https://www.bco-dmo.org/dataset/723957";
    String institution "BCO-DMO";
    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/723957/license";
    String metadata_source "https://www.bco-dmo.org/api/dataset/723957";
    String param_mapping "{'723957': {}}";
    String parameter_source "https://www.bco-dmo.org/mapserver/dataset/723957/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 subsetVariables "Year";
    String summary "Potential denitrification and N2 fixation from slurry assays from Little Lagoon, Alabama collected from 2012-2013";
    String title "Potential denitrification and N2 fixation from slurry assays from Little Lagoon, Alabama collected from 2012-2013";
    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.

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.


 
ERDDAP, Version 2.02
Disclaimers | Privacy Policy | Contact