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

ERDDAP > tabledap > Data Access Form ?

Dataset Title:  Bottle data (including temperature, salinity, density, O2) from CTD rosettes
from R/V Atlantis and R/V F.G. Walton Smith cruises AT18-02 and WS1010 in the
Gulf of Mexico Macondo wellhead area in 2010 (DWH_Deep_Microbes project)
Subscribe RSS
Institution:  BCO-DMO   (Dataset ID: bcodmo_dataset_3727)
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 ?
 
 cruiseid (text) ?          "AT18-02"    "WS1010"
 cast (unitless) ?          1    91
 event (unitless) ?          "01.01"    "79.01"
 month_utc (mm (01 to 12)) ?          "05"    "12"
 day_utc (dd (01 to 31)) ?          "01"    "31"
 year_utc (unitless) ?      
   - +  ?
 latitude (degrees_north) ?          28.65    28.8525
  < slider >
 longitude (degrees_east) ?          -88.8133    -88.3097
  < slider >
 bottle (unitless) ?          1    23
 time_utc (HHMM) ?          "0024.13"    "2341.60"
 lat (Latitude, decimal degrees) ?          28.6494    28.8523
 lon (Longitude, decimal degrees) ?          -88.8162    -88.30976
 press (decibars) ?          10.81    1699.448
 depth (m) ?          10.738    1681.214
  < slider >
 temp (Temperature, degrees Celsius) ?          4.2569    26.1005
 temp2 (degrees Celsius) ?          4.2567    26.1036
 sal (PSU) ?          34.8998    36.5636
 sal2 (PSU) ?          34.897    36.5774
 density (kg/m^3) ?          1023.718    1035.5029
 sigma_0 (kg/m^3) ?          23.6723    27.7571
 sigma_t (kg/m^3) ?          23.6715    27.742
 O2_mg_L (mg/L) ?          3.5495    6.78799
 O2_sat_pcnt (%) ?          38.96773    99.95167
 O2_umol_kg (umol/kg) ?          107.991    207.116
 beam_c (1/m) ?          -0.0018    1.1617
 trans (%) ?          74.7941    100.0432
 fluor (unknown) ?          6.0E-4    0.0241
 CDOM (unknown) ?          0.5957    1.7912
 fluor_ug_L (micrograms per liter (ug/L)) ?          0.1033    0.1318
 fluor_scufa (unknown) ?          0.1632    0.7689
 turbidity (unknown) ?          0.0468    0.0566
 
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 {
  cruiseid {
    String bcodmo_name "cruiseid";
    String description "Unique identifier for the cruise.";
    String long_name "Cruiseid";
    String units "text";
  }
  cast {
    Byte _FillValue 127;
    Byte actual_range 1, 91;
    String bcodmo_name "cast";
    String description "Consecutive CTD cast number.";
    String long_name "Cast";
    String units "unitless";
  }
  event {
    String bcodmo_name "event";
    String description "Unique event number. First two digits are the station number. The two digits after the decimal are the cast number at that station.";
    String long_name "Event";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/EVTAGFL/";
    String units "unitless";
  }
  month_utc {
    String bcodmo_name "month_utc";
    String description "2-digit (mm) month of year; UTC.";
    String long_name "Month Utc";
    String units "mm (01 to 12)";
  }
  day_utc {
    String bcodmo_name "day_utc";
    String description "2-digit (dd) day of month; UTC.";
    String long_name "Day Utc";
    String units "dd (01 to 31)";
  }
  year_utc {
    Int16 _FillValue 32767;
    Int16 actual_range 2010, 2010;
    String bcodmo_name "year";
    String description "4-digit year; UTC in�YYYY format.";
    String long_name "Year Utc";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/YEARXXXX/";
    String units "unitless";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 _FillValue NaN;
    Float64 actual_range 28.65, 28.8525;
    String axis "Y";
    String bcodmo_name "lat_start";
    Float64 colorBarMaximum 90.0;
    Float64 colorBarMinimum -90.0;
    String description "Latitude at start of cast; postive values = North.";
    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 -88.8133, -88.3097;
    String axis "X";
    String bcodmo_name "lon_start";
    Float64 colorBarMaximum 180.0;
    Float64 colorBarMinimum -180.0;
    String description "Longitude at start of cast; negative values = West.";
    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";
  }
  bottle {
    Byte _FillValue 127;
    Byte actual_range 1, 23;
    String bcodmo_name "bottle";
    String description "Consecutive bottle number.";
    String long_name "Bottle";
    String units "unitless";
  }
  time_utc {
    String bcodmo_name "time_utc";
    String description "Time when the bottle was fired; 24-hour clock; UTC.";
    String long_name "Time Utc";
    String units "HHMM";
  }
  lat {
    Float32 _FillValue NaN;
    Float32 actual_range 28.6494, 28.8523;
    String bcodmo_name "latitude";
    Float64 colorBarMaximum 90.0;
    Float64 colorBarMinimum -90.0;
    String description "Latitude; positive values = North.";
    String long_name "Latitude";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P09/current/LATX/";
    String standard_name "latitude";
    String units "decimal degrees";
  }
  lon {
    Float32 _FillValue NaN;
    Float32 actual_range -88.8162, -88.30976;
    String bcodmo_name "longitude";
    Float64 colorBarMaximum 180.0;
    Float64 colorBarMinimum -180.0;
    String description "Longitude; negative values = West.";
    String long_name "Longitude";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P09/current/LONX/";
    String standard_name "longitude";
    String units "decimal degrees";
  }
  press {
    Float32 _FillValue NaN;
    Float32 actual_range 10.81, 1699.448;
    String bcodmo_name "pressure";
    String description "Pressure. Originally named 'PrDM'.";
    String long_name "Press";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/PRESPR01/";
    String units "decibars";
  }
  depth {
    String _CoordinateAxisType "Height";
    String _CoordinateZisPositive "down";
    Float64 _FillValue NaN;
    Float64 actual_range 10.738, 1681.214;
    String axis "Z";
    String bcodmo_name "depth";
    Float64 colorBarMaximum 8000.0;
    Float64 colorBarMinimum -8000.0;
    String colorBarPalette "TopographyDepth";
    String description "Depth. Originally named 'DepSM'.";
    String ioos_category "Location";
    String long_name "Depth";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P09/current/DEPH/";
    String positive "down";
    String standard_name "depth";
    String units "m";
  }
  temp {
    Float32 _FillValue NaN;
    Float32 actual_range 4.2569, 26.1005;
    String bcodmo_name "temperature";
    String description "Primary temperature measurement. Originally named 'T090C'.";
    String long_name "Temperature";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/TEMPP901/";
    String units "degrees Celsius";
  }
  temp2 {
    Float32 _FillValue NaN;
    Float32 actual_range 4.2567, 26.1036;
    String bcodmo_name "temp2";
    String description "Secondary tempearture measurement. Originally named 'T190C'.";
    String long_name "Temp2";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/TEMPS601/";
    String units "degrees Celsius";
  }
  sal {
    Float32 _FillValue NaN;
    Float32 actual_range 34.8998, 36.5636;
    String bcodmo_name "sal";
    String description "Primary salinity measurement. Originally named 'Sal00'.";
    String long_name "Sal";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/PSALST01/";
    String units "PSU";
  }
  sal2 {
    Float32 _FillValue NaN;
    Float32 actual_range 34.897, 36.5774;
    String bcodmo_name "sal2";
    String description "Secondary salinity measurement. Originally named 'Sal11'.";
    String long_name "Sal2";
    String units "PSU";
  }
  density {
    Float64 _FillValue NaN;
    Float64 actual_range 1023.718, 1035.5029;
    String bcodmo_name "density";
    String description "Density in kilograms per cubic meter.";
    String long_name "Density";
    String units "kg/m^3";
  }
  sigma_0 {
    Float32 _FillValue NaN;
    Float32 actual_range 23.6723, 27.7571;
    String bcodmo_name "sigma_0";
    String description "Sigma theta density. Orignally named 'Sigma-e00'.";
    String long_name "Sigma 0";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/SIGTPR01/";
    String units "kg/m^3";
  }
  sigma_t {
    Float32 _FillValue NaN;
    Float32 actual_range 23.6715, 27.742;
    String bcodmo_name "sigma-t";
    String description "Sigma-t density. Originally named 'Sigma-t00'.";
    String long_name "Sigma T";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/SIGTEQST/";
    String units "kg/m^3";
  }
  O2_mg_L {
    Float32 _FillValue NaN;
    Float32 actual_range 3.5495, 6.78799;
    String bcodmo_name "Dissolved_Oxygen";
    String description "Oxygen in milligrams per liter. Originally named 'Sbeox0Mg/L'.";
    String long_name "O2 Mg L";
    String units "mg/L";
  }
  O2_sat_pcnt {
    Float32 _FillValue NaN;
    Float32 actual_range 38.96773, 99.95167;
    String bcodmo_name "O2_sat_pcnt";
    String description "Percent oxygen saturation. Originally named 'Sbeox0PS'.";
    String long_name "O2 Sat Pcnt";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/OXYSZZ01/";
    String units "%";
  }
  O2_umol_kg {
    Float32 _FillValue NaN;
    Float32 actual_range 107.991, 207.116;
    String bcodmo_name "O2_umol_kg";
    String description "Oxygen in micromoles per kilogram. Originally named 'Sbeox0Mm/Kg'.";
    String long_name "O2 Umol Kg";
    String units "umol/kg";
  }
  beam_c {
    Float32 _FillValue NaN;
    Float32 actual_range -0.0018, 1.1617;
    String bcodmo_name "beam_c";
    String description "Beam attenuation. Originally named 'Bat'.";
    String long_name "Beam C";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/ATTNZZ01/";
    String units "1/m";
  }
  trans {
    Float32 _FillValue NaN;
    Float32 actual_range 74.7941, 100.0432;
    String bcodmo_name "transmission";
    String description "Beam transmission. Originally named 'Xmiss'.";
    String long_name "Trans";
    String units "%";
  }
  fluor {
    Float32 _FillValue NaN;
    Float32 actual_range 6.0e-4, 0.0241;
    String bcodmo_name "fluorescence";
    String description "Fluorescence measured by�FlECO-AFL";
    String long_name "Fluor";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/CPHLPM01/";
    String units "unknown";
  }
  CDOM {
    Float32 _FillValue NaN;
    Float32 actual_range 0.5957, 1.7912;
    String bcodmo_name "CDOM";
    String description "CDOM measured by�WetCDOM";
    String long_name "Chromophoric Dissolved Organic Material";
    String units "unknown";
  }
  fluor_ug_L {
    Float32 _FillValue NaN;
    Float32 actual_range 0.1033, 0.1318;
    String bcodmo_name "fluorescence";
    String description "Fluoroscence measured by�FlCUVA";
    String long_name "Fluor Ug L";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/CPHLPM01/";
    String units "micrograms per liter (ug/L)";
  }
  fluor_scufa {
    Float32 _FillValue NaN;
    Float32 actual_range 0.1632, 0.7689;
    String bcodmo_name "fluorescence";
    String description "FlScufa";
    String long_name "Fluor Scufa";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/CPHLPM01/";
    String units "unknown";
  }
  turbidity {
    Float32 _FillValue NaN;
    Float32 actual_range 0.0468, 0.0566;
    String bcodmo_name "turbidity";
    String description "Turbidity measured by TurbWETntu0";
    String long_name "Turbidity";
    String units "unknown";
  }
 }
  NC_GLOBAL {
    String access_formats ".htmlTable,.csv,.json,.mat,.nc,.tsv,.esriCsv,.geoJson";
    String acquisition_description 
"CTD casts in the vicinity of the Macondo Wellhead were complicated by the
presence of oil on the sea surface. A saltwater hose was used to spray the sea
surface, parting the oil to create a clean area for the CTD to be dropped
through; a similar procedure was used for deployment and recovery.";
    String awards_0_award_nid "55015";
    String awards_0_award_number "OCE-1043225";
    String awards_0_data_url "http://www.nsf.gov/awardsearch/showAward.do?AwardNumber=1043225";
    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 
"Bottle Data from CTD Rosettes 
 Project: RAPID Deepwater Horizon Oil Spill: Deep pelagic and 
  benthic impacts of the oil spill 
 PI: Samantha Joye (University of Georgia) 
 Version: 24 Sept 2012 
 NOTE: Starting dates, lat, and lon are from bottle data headers  
       (may differ from event log).";
    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 "2012-09-24T17:27:50Z";
    String date_modified "2019-08-01T17:51:45Z";
    String defaultDataQuery "&amp;time&lt;now";
    String doi "10.1575/1912/bco-dmo.3727.1";
    Float64 Easternmost_Easting -88.3097;
    Float64 geospatial_lat_max 28.8525;
    Float64 geospatial_lat_min 28.65;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -88.3097;
    Float64 geospatial_lon_min -88.8133;
    String geospatial_lon_units "degrees_east";
    Float64 geospatial_vertical_max 1681.214;
    Float64 geospatial_vertical_min 10.738;
    String geospatial_vertical_positive "down";
    String geospatial_vertical_units "m";
    String history 
"2020-07-08T05:00:58Z (local files)
2020-07-08T05:00:58Z https://erddap.bco-dmo.org/erddap/tabledap/bcodmo_dataset_3727.html";
    String infoUrl "https://www.bco-dmo.org/dataset/3727";
    String institution "BCO-DMO";
    String instruments_0_acronym "Niskin bottle";
    String instruments_0_dataset_instrument_nid "5784";
    String instruments_0_description "A Niskin bottle (a next generation water sampler based on the Nansen bottle) is a cylindrical, non-metallic water collection device with stoppers at both ends.  The bottles can be attached individually on a hydrowire or deployed in 12, 24 or 36 bottle Rosette systems mounted on a frame and combined with a CTD.  Niskin bottles are used to collect discrete water samples for a range of measurements including pigments, nutrients, plankton, etc.";
    String instruments_0_instrument_external_identifier "https://vocab.nerc.ac.uk/collection/L22/current/TOOL0412/";
    String instruments_0_instrument_name "Niskin bottle";
    String instruments_0_instrument_nid "413";
    String instruments_0_supplied_name "Niskin bottle";
    String instruments_1_acronym "CTD SBE 9";
    String instruments_1_dataset_instrument_nid "5785";
    String instruments_1_description "The Sea-Bird SBE 9 is a type of CTD instrument package.  The SBE 9 is the Underwater Unit and is most often combined with the SBE 11 Deck Unit (for real-time readout using conductive wire) when deployed from a research vessel. The combination of the SBE 9 and SBE 11 is called a SBE 911.  The SBE 9 uses Sea-Bird's standard modular temperature and conductivity sensors (SBE 3 and SBE 4). The SBE 9 CTD can be configured with auxiliary sensors to measure other parameters including dissolved oxygen, pH, turbidity, fluorometer, altimeter, etc.). Note that in most cases, it is more accurate to specify SBE 911 than SBE 9 since it is likely a SBE 11 deck unit was used.  more information from Sea-Bird Electronics";
    String instruments_1_instrument_external_identifier "https://vocab.nerc.ac.uk/collection/L05/current/130/";
    String instruments_1_instrument_name "CTD Sea-Bird 9";
    String instruments_1_instrument_nid "488";
    String instruments_1_supplied_name "CTD Sea-Bird 9";
    String keywords "altimetry, bco, bco-dmo, beam, beam_c, biological, bottle, cast, CDOM, chemical, chromophoric, colored, cruiseid, data, dataset, day, day_utc, density, depth, dissolved, dmo, erddap, event, fluor, fluor_scufa, fluor_ug_L, laboratory, lat_start, latitude, lon_start, longitude, management, material, matter, month, month_utc, O2, O2_mg_L, O2_sat_pcnt, O2_umol_kg, oceanography, office, organic, oxygen, pcnt, preliminary, press, sal, sal2, sat, satellite, scufa, sigma, sigma_0, sigma_t, temp2, temperature, time, time_utc, trans, turbidity, umol, year, year_utc";
    String license "https://www.bco-dmo.org/dataset/3727/license";
    String metadata_source "https://www.bco-dmo.org/api/dataset/3727";
    Float64 Northernmost_Northing 28.8525;
    String param_mapping "{'3727': {'depth': 'flag - depth', 'lon_start': 'flag - longitude', 'lat_start': 'flag - latitude'}}";
    String parameter_source "https://www.bco-dmo.org/mapserver/dataset/3727/parameters";
    String people_0_affiliation "University of Georgia";
    String people_0_affiliation_acronym "UGA";
    String people_0_person_name "Samantha B. Joye";
    String people_0_person_nid "51421";
    String people_0_role "Principal Investigator";
    String people_0_role_type "originator";
    String people_1_affiliation "Woods Hole Oceanographic Institution";
    String people_1_affiliation_acronym "WHOI BCO-DMO";
    String people_1_person_name "Shannon Rauch";
    String people_1_person_nid "51498";
    String people_1_role "BCO-DMO Data Manager";
    String people_1_role_type "related";
    String project "DWH_Deep_Microbes";
    String projects_0_acronym "DWH_Deep_Microbes";
    String projects_0_description 
"During late spring and summer of 2010, the Northern Gulf of Mexico (GoM) was exposed to an oil spill different in magnitude and scope from any previous spill. The Deepwater Horizon, an ultra-deep, offshore drilling platform, began working GoM oil fields in 2001. While working a well in Mississippi Canyon on April 20, 2010, a bolus of methane gas ascended the drill pipe and exploded at the surface. Two days later the platform sank and since then, substantial quantities of oil and gas have leaked from the damaged wellhead. This work addressed the offshore oceanic impacts of the BP spill.
Sediment microbial mediated processes are capable of oxidizing oil and methane in the environment. The PI's examined the impacts of the Deepwater Horizon Oil Spill on microbially mediated processes in the deep waters and sediments in the vicinity of the spill site. The work complemented several funded or planned geochemical and microbiological sampling programs focused on the oil spill response. PI's evaluated rates of water column methane oxidation and sediment sulfate reduction and methanogenesis at multiple sites around the spill site. Additional experiments quantified the impact of nutrients, oxygen and substrate concentrations on these important microbially mediated processes.
The Joye group participated in six research cruises during 2010 and received samples from another six cruises from the study area. On all cruises, water samples were collected using a CTD rosette and Niskin or Go-Flo bottles. Sediment samples were obtained by box coring, multi-coring, or using the manned submersible ALVIN.
The PI's extended the monitoring/assessment program that was initiated through  the NOAA National Institute of Undersea Science and Technology (NIUST)  funded cruise and further leveraged by NOAA/NIUST (cruises in July 2010,  October 2010) by conducting three major expeditions in 2010. This RAPID  project directly supported the PI's efforts for cruises in May/June 2010  (NSF Joye chief scientist); August 2010 (NSF Montoya, chief scientist);  November/December 2010 (NSF Joye chief scientist); and July 2011 (NSF  Montoya, chief scientist)";
    String projects_0_end_date "2012-05";
    String projects_0_geolocation "Gulf of Mexico; 26.9N, 90.7W";
    String projects_0_name "RAPID Deepwater Horizon Oil Spill: Deep pelagic and benthic impacts of the oil spill";
    String projects_0_project_nid "2234";
    String projects_0_start_date "2010-06";
    String publisher_name "Biological and Chemical Oceanographic Data Management Office (BCO-DMO)";
    String publisher_type "institution";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 28.65;
    String standard_name_vocabulary "CF Standard Name Table v55";
    String subsetVariables "year_utc";
    String summary "Bottle data (including temperature, salinity, density, O2) from CTD rosettes from R/V Atlantis and R/V F.G. Walton Smith cruises AT18-02 and WS1010 in the Gulf of Mexico Macondo wellhead area in 2010.";
    String title "Bottle data (including temperature, salinity, density, O2) from CTD rosettes from R/V Atlantis and R/V F.G. Walton Smith cruises AT18-02 and WS1010 in the Gulf of Mexico Macondo wellhead area in 2010 (DWH_Deep_Microbes project)";
    String version "1";
    Float64 Westernmost_Easting -88.8133;
    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