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

ERDDAP > tabledap > Data Access Form ?

Dataset Title:  [Oyster density and size distribution] - Oyster density and size distribution
from the coast of North Carolina in 2010 (Microbial Regulation of Greenhouse
Gas N2O Emission from Intertidal Oyster Reefs)
Subscribe RSS
Institution:  BCO-DMO   (Dataset ID: bcodmo_dataset_704333)
Information:  Summary ? | License ? | FGDC | ISO 19115 | Metadata | Background (external link) | Files | Make a graph
 
Variable ?   Optional
Constraint #1 ?
Optional
Constraint #2 ?
   Minimum ?
 
   Maximum ?
 
 reef_ID (unitless) ?          "MF 1 00"    "SMSG 47"
 habitat (unitless) ?          "Flat"    "Seagrass"
 location (unitless) ?          1    3
 latitude (degrees_north) ?          34.68235    34.6939667
  < slider >
 longitude (degrees_east) ?          -76.6226    -76.6107833
  < slider >
 bucket (unitless) ?          3    22
 weight_ttl (kilograms) ?          1.5    9.1
 weight_liveOyster (kilograms) ?          0.1    7.3
 weight_shell (kilograms) ?          1.1    2.6
 count (count) ?          8    206
 density (count per meter) ?          128    3296
 length_avg (centimeters) ?          35.12    70.12
 length_stDev (unitless) ?          7.16    28.91
 length_median (centimeters) ?          34.5    65.0
 
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 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 {
  reef_ID {
    String bcodmo_name "site";
    String description "PI issued site ID";
    String long_name "Reef ID";
    String units "unitless";
  }
  habitat {
    String bcodmo_name "site";
    String description "Type of substrate where oysters were measured";
    String long_name "Habitat";
    String units "unitless";
  }
  location {
    Byte _FillValue 127;
    String _Unsigned "false";
    Byte actual_range 1, 3;
    String bcodmo_name "site";
    String description "PI issued location IDs that correspond to specific coordinates and experimental treatments";
    String long_name "Location";
    String units "unitless";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 _FillValue NaN;
    Float64 actual_range 34.68235, 34.6939667;
    String axis "Y";
    String bcodmo_name "latitude";
    Float64 colorBarMaximum 90.0;
    Float64 colorBarMinimum -90.0;
    String description "Latitude";
    String ioos_category "Location";
    String long_name "Latitude";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P09/current/LATX/";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float64 _FillValue NaN;
    Float64 actual_range -76.6226, -76.6107833;
    String axis "X";
    String bcodmo_name "longitude";
    Float64 colorBarMaximum 180.0;
    Float64 colorBarMinimum -180.0;
    String description "Longitude";
    String ioos_category "Location";
    String long_name "Longitude";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P09/current/LONX/";
    String standard_name "longitude";
    String units "degrees_east";
  }
  bucket {
    Byte _FillValue 127;
    String _Unsigned "false";
    Byte actual_range 3, 22;
    String bcodmo_name "sample";
    String description "PI issued ID of oyster collection measured";
    String long_name "Bucket";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P02/current/ACYC/";
    String units "unitless";
  }
  weight_ttl {
    Float32 _FillValue NaN;
    Float32 actual_range 1.5, 9.1;
    String bcodmo_name "weight";
    String description "Total weight of oysters";
    String long_name "Weight Ttl";
    String units "kilograms";
  }
  weight_liveOyster {
    Float32 _FillValue NaN;
    Float32 actual_range 0.1, 7.3;
    String bcodmo_name "weight";
    String description "Weight of live oysters";
    String long_name "Weight Live Oyster";
    String units "kilograms";
  }
  weight_shell {
    Float32 _FillValue NaN;
    Float32 actual_range 1.1, 2.6;
    String bcodmo_name "weight";
    String description "Weight of oyster shells";
    String long_name "Weight Shell";
    String units "kilograms";
  }
  count {
    Int16 _FillValue 32767;
    Int16 actual_range 8, 206;
    String bcodmo_name "count";
    Float64 colorBarMaximum 100.0;
    Float64 colorBarMinimum 0.0;
    String description "Oyster count in each bucket sample";
    String long_name "Count";
    String units "count";
  }
  density {
    Int16 _FillValue 32767;
    Int16 actual_range 128, 3296;
    String bcodmo_name "density";
    String description "Density of oysters in each sample";
    String long_name "Density";
    String units "count per meter";
  }
  length_avg {
    Float32 _FillValue NaN;
    Float32 actual_range 35.12, 70.12;
    String bcodmo_name "length";
    String description "Average length of each oyster in the sample";
    String long_name "Length Avg";
    String units "centimeters";
  }
  length_stDev {
    Float32 _FillValue NaN;
    Float32 actual_range 7.16, 28.91;
    String bcodmo_name "length";
    String description "Standard deviation from the mean of oyster lengths";
    String long_name "Length St Dev";
    String units "unitless";
  }
  length_median {
    Float32 _FillValue NaN;
    Float32 actual_range 34.5, 65.0;
    String bcodmo_name "length";
    String description "Median oyster length from the sample";
    String long_name "Length Median";
    String units "centimeters";
  }
 }
  NC_GLOBAL {
    String access_formats ".htmlTable,.csv,.json,.mat,.nc,.tsv,.esriCsv,.geoJson";
    String acquisition_description 
"Methodology from\\u00a0Smyth, A. R., Piehler, M. F. and Grabowski, J. H.
(2015), Habitat context influences nitrogen removal by restored oyster reefs.
J Appl Ecol, 52: 716\\u2013725.
doi:[10.1111/1365-2664.12435](\\\\\"https://onlinelibrary.wiley.com/doi/10.1111/1365-2664.12435/abstract\\\\\")
 
Sediment cores (contained in 6\\u00b74-cm-diameter by 17-cm-long polycarbonate
tubes, 10\\u00a0cm depth) were collected adjacent to each reef habitat
(n\\u00a0=\\u00a03) and control habitat (without reefs,\\u00a0n\\u00a0=\\u00a03) in
each context at low tide on 28 June 2010. Cores collected from oyster reefs
did not contain live oysters. Additionally, ~100\\u00a0L of water was collected
for use in the laboratory incubations. Following collection, sediment cores
and water were transported to an environmental chamber (Bally, Inc., Morehead
City, NC, USA) at The University of North Carolina Institute of Marine
Sciences in Morehead City, NC. Surface water measurements of dissolved O2,
salinity and water temperature (YSI 600 Series Sonde and Model 650 data
logger; Yellow Springs Instruments, Yellow Springs, OH, USA) were also
collected. Oyster density in the reef was determined by placing a
0\\u00b725-m2\\u00a0quadrat\\u00a0on each reef (one\\u00a0quadrat\\u00a0per reef)
and counting all the oysters present with a shell length >25\\u00a0mm
(Powers\\u00a0et\\u00a0al.\\u00a02009).";
    String awards_0_award_nid "568863";
    String awards_0_award_number "OCE-1233372";
    String awards_0_data_url "http://www.nsf.gov/awardsearch/showAward.do?AwardNumber=1233372";
    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 
"Oyster Density and Size Distribution 
  M. Piehler, B.K. Song, C. Tobias, and M. Brush, PIs 
  Version 6 June 2017";
    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 "2017-06-07T00:01:53Z";
    String date_modified "2019-03-28T18:07:50Z";
    String defaultDataQuery "&amp;time&lt;now";
    String doi "10.1575/1912/bco-dmo.704333.1";
    Float64 Easternmost_Easting -76.6107833;
    Float64 geospatial_lat_max 34.6939667;
    Float64 geospatial_lat_min 34.68235;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -76.6107833;
    Float64 geospatial_lon_min -76.6226;
    String geospatial_lon_units "degrees_east";
    String history 
"2024-12-30T17:03:25Z (local files)
2024-12-30T17:03:25Z https://erddap.bco-dmo.org/erddap/tabledap/bcodmo_dataset_704333.html";
    String infoUrl "https://www.bco-dmo.org/dataset/704333";
    String institution "BCO-DMO";
    String instruments_0_acronym "Multi Corer";
    String instruments_0_dataset_instrument_description "Used to collect core samples";
    String instruments_0_dataset_instrument_nid "704344";
    String instruments_0_description "The Multi Corer is a benthic coring device used to collect multiple, simultaneous, undisturbed sediment/water samples from the seafloor.  Multiple coring tubes with varying sampling capacity depending on tube dimensions are mounted in a frame designed to sample the deep ocean seafloor. For more information, see Barnett et al. (1984) in Oceanologica Acta, 7, pp. 399-408.";
    String instruments_0_instrument_external_identifier "https://vocab.nerc.ac.uk/collection/L05/current/51/";
    String instruments_0_instrument_name "Multi Corer";
    String instruments_0_instrument_nid "532";
    String instruments_0_supplied_name "Core";
    String keywords "average, bco, bco-dmo, biological, bucket, chemical, count, data, dataset, density, dev, dmo, erddap, habitat, latitude, length, length_avg, length_median, length_stDev, live, longitude, management, median, oceanography, office, oyster, preliminary, reef, reef_ID, shell, ttl, weight, weight_liveOyster, weight_shell, weight_ttl";
    String license "https://www.bco-dmo.org/dataset/704333/license";
    String metadata_source "https://www.bco-dmo.org/api/dataset/704333";
    Float64 Northernmost_Northing 34.6939667;
    String param_mapping "{'704333': {'lat': 'master - latitude', 'lon': 'master - longitude'}}";
    String parameter_source "https://www.bco-dmo.org/mapserver/dataset/704333/parameters";
    String people_0_affiliation "University of North Carolina at Chapel Hill";
    String people_0_affiliation_acronym "UNC-Chapel Hill";
    String people_0_person_name "Michael F. Piehler";
    String people_0_person_nid "522931";
    String people_0_role "Principal Investigator";
    String people_0_role_type "originator";
    String people_1_affiliation "Virginia Institute of Marine Science";
    String people_1_affiliation_acronym "VIMS";
    String people_1_person_name "Mark J. Brush";
    String people_1_person_nid "568861";
    String people_1_role "Co-Principal Investigator";
    String people_1_role_type "originator";
    String people_2_affiliation "Virginia Institute of Marine Science";
    String people_2_affiliation_acronym "VIMS";
    String people_2_person_name "Bongkeun Song";
    String people_2_person_nid "51729";
    String people_2_role "Co-Principal Investigator";
    String people_2_role_type "originator";
    String people_3_affiliation "University of Connecticut";
    String people_3_affiliation_acronym "UConn - Avery Point";
    String people_3_person_name "Craig Tobias";
    String people_3_person_nid "51731";
    String people_3_role "Co-Principal Investigator";
    String people_3_role_type "originator";
    String people_4_affiliation "University of North Carolina at Chapel Hill";
    String people_4_affiliation_acronym "UNC-Chapel Hill";
    String people_4_person_name "Michael F. Piehler";
    String people_4_person_nid "522931";
    String people_4_role "Contact";
    String people_4_role_type "related";
    String people_5_affiliation "Woods Hole Oceanographic Institution";
    String people_5_affiliation_acronym "WHOI BCO-DMO";
    String people_5_person_name "Hannah Ake";
    String people_5_person_nid "650173";
    String people_5_role "BCO-DMO Data Manager";
    String people_5_role_type "related";
    String project "Oyster Reef N2O Emission";
    String projects_0_acronym "Oyster Reef N2O Emission";
    String projects_0_description 
"Extracted from the NSF award abstract:
Oyster reefs are biogeochemical hot spots and prominent estuarine habitats that provide disproportionate ecological function. Suspension-feeding eastern oysters, Crassostrea virginica, are capable of improving water quality and diminishing eutrophication by filtering nutrients and particles from the water and depositing them in the sediments. Remineralization of these deposits may enhance sedimentary denitrification that facilitates nitrogen removal in tidal estuaries. However, the scientific underpinning of oyster reef function has been challenged in various studies. In addition, recent studies of filter feeding invertebrates reported the production of nitrous oxide (N2O), a greenhouse gas, as an end product of incomplete denitrification by gut microbes. C. virginica could be another source of N2O flux from intertidal habitats. Preliminary work indicated substantial N2O production from individual oysters. The estimated N2O production from high density oyster reefs may exceed the N2O flux measured from some estuaries. With the new discovery of N2O emission and uncertainty regarding eutrophication control, the ecological value of oyster reef restoration may become equivocal.
This project will quantify N2O fluxes to understand the factors controlling N2O emission from oyster reefs. Sedimentary N processes will be examined to develop an oyster reef N model to estimate N2O emission from tidal creek estuaries relative to other N cycling processes. The PIs hypothesize that intertidal oyster reefs are a substantial source of N2O emission from estuarine ecosystems and the magnitude of emission may be linked to water quality. If substantial N2O flux from oyster reefs is validated, ecological benefits of oyster reef restoration should be reevaluated. This interdisciplinary research team includes a microbial ecologist, a biogeochemist, an ecologist and an ecosystem modeler. They will utilize stable isotope and molecular microbiological techniques to quantify oyster N2O production, elucidate microbial sources of N2O emission from oysters and sediments, and estimate seasonal variation of N2O fluxes from oyster reefs. Measurements from this study will be integrated into a coupled oyster bioenergetics-sediment biogeochemistry model to compare system level rates of N cycling on oyster reefs as a function of oyster density and water quality. Modeling results will be used to assess the relative trade-­offs of oyster restoration associated with N cycling. They expect to deliver the following end products:1) estimation of annual N2O flux from oyster reefs as an additional source of greenhouse gases from estuaries, 2) a better understanding of the environmental and microbial factors influencing N2O and N2 fluxes in tidal estuaries, 3) transformative knowledge for the effect of oyster restoration on water quality enhancement and ecosystem function, 4) direct guidance for oyster restoration projects whose goals include water quality enhancement, and 5) a modeling tool for use in research and restoration planning.";
    String projects_0_end_date "2015-08";
    String projects_0_name "Microbial Regulation of Greenhouse Gas N2O Emission from Intertidal Oyster Reefs";
    String projects_0_project_nid "527289";
    String projects_0_start_date "2012-12";
    String publisher_name "Biological and Chemical Oceanographic Data Management Office (BCO-DMO)";
    String publisher_type "institution";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 34.68235;
    String standard_name_vocabulary "CF Standard Name Table v55";
    String summary "Oyster density and size distribution from the coast of North Carolina in 2010";
    String title "[Oyster density and size distribution] - Oyster density and size distribution from the coast of North Carolina in 2010 (Microbial Regulation of Greenhouse Gas N2O Emission from Intertidal Oyster Reefs)";
    String version "1";
    Float64 Westernmost_Easting -76.6226;
    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.22
Disclaimers | Privacy Policy | Contact