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

ERDDAP > tabledap > Data Access Form ?

Dataset Title:  [Sandusky Bay Surveys 2019] - Data from Sandusky Bay, Lake Erie from surveys
conducted via Ohio Dept of Natural Resources watercraft from June to September
2019 (Lake Erie Center for Fresh Waters and Human Health)
Subscribe RSS
Institution:  BCO-DMO   (Dataset ID: bcodmo_dataset_814593)
Information:  Summary ? | License ? | FGDC | ISO 19115 | Metadata | Background (external link) | Files | Make a graph
 
Variable ?   Optional
Constraint #1 ?
Optional
Constraint #2 ?
   Minimum ?
 
   Maximum ?
 
 Deployment (unitless) ?          "SB-2019-01"    "SB-2019-07"
 Station (unitless) ?          "ODNR 1"    "ODNR 6"
 time2 (Time, unitless) ?          "09:45:00"    "14:30:00"
 time (ISO Date Time UTC, UTC) ?          2019-06-10T10:25Z    2019-09-23T13:18Z
  < slider >
 latitude (degrees_north) ?          41.453333    41.479817
  < slider >
 longitude (degrees_east) ?          -82.960767    -82.739783
  < slider >
 Max_Depth (meters (m)) ?          1.1    3.05
 depth (Sample Depth, m) ?          1.0    1.0
  < slider >
 Air_Temp (degrees Celsius) ?          18.9    28.9
 Water_Temp (degrees Celsius) ?          17.72    27.47
 Sample_DO (milligrams per liter (mg L-1)) ?          6.42    12.46
 Cond (milli siemens per centimeter (mS cm-1)) ?          0.314    0.471
 pH (unitless (pH scale)) ?          8.82    10.13
 chlorophyll_a (micrograms per liter (ug L-1)) ?          6.21    129.0
 microcystin (micrograms per liter (ug L-1)) ?          "0.328"    "<0.300"
 Ammonium (micromoles per liter (umol L-1)) ?          -0.162    28.265
 NO3_NO2 (micromoles per liter (umol L-1)) ?          0.0    388.3
 NO2 (micromoles per liter (umol L-1)) ?          0.028    9.442
 DRP (micromoles per liter (umol L-1)) ?          0.035    4.253
 Silicate (micromoles per liter (umol L-1)) ?          3.191    127.436
 Nitrate (micromoles per liter (umol L-1)) ?          -0.096    379.574
 TP (micromoles per liter (umol L-1)) ?          2.334    8.857
 TKN (micromoles per liter (umol L-1)) ?          54.499    176.282
 TN (micromoles per liter (umol L-1)) ?          54.9    514.253
 TN_TP_ratio (molar ratio) ?          14.846    58.062
 
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 {
  Deployment {
    String bcodmo_name "cruise_id";
    String description "Deployment identifier";
    String long_name "Deployment";
    String units "unitless";
  }
  Station {
    String bcodmo_name "station";
    String description "Station name";
    String long_name "Station";
    String units "unitless";
  }
  time2 {
    String bcodmo_name "time";
    String description "Time of survey (UTC); format: hh:mm:ss";
    String long_name "Time";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/AHMSAA01/";
    String units "unitless";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.5601623e+9, 1.56924468e+9;
    String axis "T";
    String bcodmo_name "ISO_DateTime_UTC";
    String description "Date and time of survey (UTC) formatted to ISO8601 standard: YYYY-MM-DDThh:mmZ";
    String ioos_category "Time";
    String long_name "ISO Date Time UTC";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/DTUT8601/";
    String source_name "ISO_DateTime_UTC";
    String standard_name "time";
    String time_origin "01-JAN-1970 00:00:00";
    String time_precision "1970-01-01T00:00Z";
    String units "seconds since 1970-01-01T00:00:00Z";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 _FillValue NaN;
    Float64 actual_range 41.453333, 41.479817;
    String axis "Y";
    String bcodmo_name "latitude";
    Float64 colorBarMaximum 90.0;
    Float64 colorBarMinimum -90.0;
    String description "Latitude; positive 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 -82.960767, -82.739783;
    String axis "X";
    String bcodmo_name "longitude";
    Float64 colorBarMaximum 180.0;
    Float64 colorBarMinimum -180.0;
    String description "Longitude; positive values = East";
    String ioos_category "Location";
    String long_name "Longitude";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P09/current/LONX/";
    String source_name "long";
    String standard_name "longitude";
    String units "degrees_east";
  }
  Max_Depth {
    Float32 _FillValue NaN;
    Float32 actual_range 1.1, 3.05;
    String bcodmo_name "depth_w";
    String description "Max. depth";
    String long_name "Max Depth";
    String units "meters (m)";
  }
  depth {
    String _CoordinateAxisType "Height";
    String _CoordinateZisPositive "down";
    Float64 _FillValue NaN;
    Float64 actual_range 1.0, 1.0;
    String axis "Z";
    String bcodmo_name "depth";
    String description "Sample depth";
    String ioos_category "Location";
    String long_name "Sample Depth";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P09/current/DEPH/";
    String positive "down";
    String standard_name "depth";
    String units "m";
  }
  Air_Temp {
    Float32 _FillValue NaN;
    Float32 actual_range 18.9, 28.9;
    String bcodmo_name "temperature";
    String description "Air temperature";
    String long_name "Air Temp";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/TEMPP901/";
    String units "degrees Celsius";
  }
  Water_Temp {
    Float32 _FillValue NaN;
    Float32 actual_range 17.72, 27.47;
    String bcodmo_name "temperature";
    String description "Water temperature";
    String long_name "Water Temp";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/TEMPP901/";
    String units "degrees Celsius";
  }
  Sample_DO {
    Float32 _FillValue NaN;
    Float32 actual_range 6.42, 12.46;
    String bcodmo_name "dissolved Oxygen";
    String description "Dissolved oxygen";
    String long_name "Sample DO";
    String units "milligrams per liter (mg L-1)";
  }
  Cond {
    Float32 _FillValue NaN;
    Float32 actual_range 0.314, 0.471;
    String bcodmo_name "conductivity";
    String description "Conductivity";
    String long_name "Cond";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P02/current/CNDC/";
    String units "milli siemens per centimeter (mS cm-1)";
  }
  pH {
    Float32 _FillValue NaN;
    Float32 actual_range 8.82, 10.13;
    String bcodmo_name "pH";
    Float64 colorBarMaximum 9.0;
    Float64 colorBarMinimum 7.0;
    String description "pH";
    String long_name "Sea Water Ph Reported On Total Scale";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/PHXXZZXX/";
    String units "unitless (pH scale)";
  }
  chlorophyll_a {
    Float32 _FillValue NaN;
    Float32 actual_range 6.21, 129.0;
    String bcodmo_name "chlorophyll a";
    Float64 colorBarMaximum 30.0;
    Float64 colorBarMinimum 0.03;
    String colorBarScale "Log";
    String description "Chlorophyll a";
    String long_name "Concentration Of Chlorophyll In Sea Water";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/CPHLHPP1/";
    String units "micrograms per liter (ug L-1)";
  }
  microcystin {
    String bcodmo_name "unknown";
    String description "Microcystins";
    String long_name "Microcystin";
    String units "micrograms per liter (ug L-1)";
  }
  Ammonium {
    Float32 _FillValue NaN;
    Float32 actual_range -0.162, 28.265;
    String bcodmo_name "Ammonium";
    Float64 colorBarMaximum 5.0;
    Float64 colorBarMinimum 0.0;
    String description "Ammonium";
    String long_name "Mole Concentration Of Ammonium In Sea Water";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/AMONAAZX/";
    String units "micromoles per liter (umol L-1)";
  }
  NO3_NO2 {
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 388.3;
    String bcodmo_name "NO3_NO2";
    Float64 colorBarMaximum 50.0;
    Float64 colorBarMinimum 0.0;
    String description "NO3 + NO2";
    String long_name "Mole Concentration Of Nitrate In Sea Water";
    String units "micromoles per liter (umol L-1)";
  }
  NO2 {
    Float32 _FillValue NaN;
    Float32 actual_range 0.028, 9.442;
    String bcodmo_name "NO2";
    Float64 colorBarMaximum 1.0;
    Float64 colorBarMinimum 0.0;
    String description "NO2";
    String long_name "Mole Concentration Of Nitrite In Sea Water";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/NTRIAAZX/";
    String units "micromoles per liter (umol L-1)";
  }
  DRP {
    Float32 _FillValue NaN;
    Float32 actual_range 0.035, 4.253;
    String bcodmo_name "P";
    String description "Dissolved reactive phosphorus";
    String long_name "DRP";
    String units "micromoles per liter (umol L-1)";
  }
  Silicate {
    Float32 _FillValue NaN;
    Float32 actual_range 3.191, 127.436;
    String bcodmo_name "SiOH_4";
    String description "Silicate";
    String long_name "Mass Concentration Of Silicate In Sea Water";
    String units "micromoles per liter (umol L-1)";
  }
  Nitrate {
    Float32 _FillValue NaN;
    Float32 actual_range -0.096, 379.574;
    String bcodmo_name "NO3";
    Float64 colorBarMaximum 50.0;
    Float64 colorBarMinimum 0.0;
    String description "Nitrate";
    String long_name "Mole Concentration Of Nitrate In Sea Water";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/NTRAIGGS/";
    String units "micromoles per liter (umol L-1)";
  }
  TP {
    Float32 _FillValue NaN;
    Float32 actual_range 2.334, 8.857;
    String bcodmo_name "P";
    String description "Total Phosphorus";
    String long_name "TP";
    String units "micromoles per liter (umol L-1)";
  }
  TKN {
    Float32 _FillValue NaN;
    Float32 actual_range 54.499, 176.282;
    String bcodmo_name "N";
    String description "Total Kjeldahl Nitrogen";
    String long_name "TKN";
    String units "micromoles per liter (umol L-1)";
  }
  TN {
    Float32 _FillValue NaN;
    Float32 actual_range 54.9, 514.253;
    String bcodmo_name "N";
    String description "Total Nitrogen";
    String long_name "TN";
    String units "micromoles per liter (umol L-1)";
  }
  TN_TP_ratio {
    Float32 _FillValue NaN;
    Float32 actual_range 14.846, 58.062;
    String bcodmo_name "unknown";
    String description "TN:TP ratio";
    String long_name "TN TP Ratio";
    String units "molar ratio";
  }
 }
  NC_GLOBAL {
    String access_formats ".htmlTable,.csv,.json,.mat,.nc,.tsv,.esriCsv,.geoJson,.odvTxt";
    String acquisition_description 
"Sampling and sample processing followed Salk et al., (2018).
 
Briefly, at each sampling location, water column physical and chemical
parameters (pH, conductivity, temperature, dissolved oxygen) were measured
using a YSI 600QS sonde (YSI Inc., Yellow Springs, OH, USA). Water samples
were collected by Van Dorn bottle at 1m depth for the analysis of NO3, NH4,
phosphate, TKN, TP, chl a concentrations, total microcystins and cell
identification/biovolume enumeration. Samples for dissolved nutrient analysis
were filtered immediately upon collection (0.2 um), kept on ice, and frozen
upon return to the lab. Unfiltered sample water was collected for TKN and TP
analysis and also frozen. Total and dissolved (<0.2 um) nutrient
concentrations were determined following analysis of samples at the Ohio State
University Stone Laboratory (Gibralter Island, OH, USA). Samples for chl a
analysis were concentrated on GFC filters whereas raw water samples for
microcystins were frozen in new polycarbonate bottles with subsequent analysis
of both parameters by Ohio EPA.";
    String awards_0_award_nid "751268";
    String awards_0_award_number "OCE-1840715";
    String awards_0_data_url "http://www.nsf.gov/awardsearch/showAward.do?AwardNumber=1840715";
    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 "Henrietta N Edmonds";
    String awards_0_program_manager_nid "51517";
    String cdm_data_type "Other";
    String comment 
"Survey data from Sandusky Bay, Lake Erie 2019 
  PI: George Bullerjahn (Bowling Green State University) 
  Co-PI: Robert Michael McKay (Bowling Green State University) 
  Version date: 09 June 2020";
    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 dataset_current_state "Final and no updates";
    String date_created "2020-06-09T16:33:31Z";
    String date_modified "2020-06-16T20:14:29Z";
    String defaultDataQuery "&amp;time&lt;now";
    String doi "10.26008/1912/bco-dmo.814593.1";
    Float64 Easternmost_Easting -82.739783;
    Float64 geospatial_lat_max 41.479817;
    Float64 geospatial_lat_min 41.453333;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -82.739783;
    Float64 geospatial_lon_min -82.960767;
    String geospatial_lon_units "degrees_east";
    Float64 geospatial_vertical_max 1.0;
    Float64 geospatial_vertical_min 1.0;
    String geospatial_vertical_positive "down";
    String geospatial_vertical_units "m";
    String history 
"2024-11-23T17:03:36Z (local files)
2024-11-23T17:03:36Z https://erddap.bco-dmo.org/erddap/tabledap/bcodmo_dataset_814593.html";
    String infoUrl "https://www.bco-dmo.org/dataset/814593";
    String institution "BCO-DMO";
    String instruments_0_acronym "YSI Sonde 6-Series";
    String instruments_0_dataset_instrument_description "YSI 600QS sonde (YSI Inc., Yellow Springs, OH, USA) – factory calibrated April 2018";
    String instruments_0_dataset_instrument_nid "814599";
    String instruments_0_description "YSI 6-Series water quality sondes and sensors are instruments for environmental monitoring and long-term deployments. YSI datasondes accept multiple water quality sensors (i.e., they are multiparameter sondes). Sondes can measure temperature, conductivity, dissolved oxygen, depth, turbidity, and other water quality parameters. The 6-Series includes several models. More from YSI.";
    String instruments_0_instrument_external_identifier "https://vocab.nerc.ac.uk/collection/L22/current/TOOL0737/";
    String instruments_0_instrument_name "YSI Sonde 6-Series";
    String instruments_0_instrument_nid "663";
    String instruments_0_supplied_name "YSI 600QS sonde";
    String instruments_1_dataset_instrument_nid "814600";
    String instruments_1_description "A free-flushing water sample bottle comprising a cylinder (polycarbonate, acrylic or PVC) with a stopper at each end. The bottle is closed by means of a messenger from the surface releasing the tension on a latex band and thus pulling the two stoppers firmly into place. A thermometer can be mounted inside the bottle. One or more bottles can be lowered on a line to allow sampling at a single or multiple depth levels. Van Dorn samplers are suitable for for physical (temperature), chemical and biological sampling in shallow to very deep water. Bottles are typically lowered vertically through the water column although a horizontal version is available for sampling near the seabed or at thermoclines or chemoclines. Because of the lack of metal parts the bottles are suitable for trace metal sampling, although the blue polyurethane seal used in the Alpha version may leach mercury. The Beta version uses white ASA plastic seals that do not leach mercury but are less durable.";
    String instruments_1_instrument_name "Van Dorn water sampler";
    String instruments_1_instrument_nid "755357";
    String instruments_1_supplied_name "Van Dorn bottle";
    String keywords "air, Air_Temp, ammonia, ammonium, bco, bco-dmo, biological, chemical, chemistry, chlorophyll, chlorophyll_a, concentration, concentration_of_chlorophyll_in_sea_water, cond, data, dataset, date, deployment, depth, dmo, drp, earth, Earth Science > Oceans > Ocean Chemistry > Ammonia, Earth Science > Oceans > Ocean Chemistry > Chlorophyll, Earth Science > Oceans > Ocean Chemistry > Nitrate, Earth Science > Oceans > Ocean Chemistry > pH, Earth Science > Oceans > Ocean Chemistry > Silicate, erddap, iso, latitude, longitude, management, mass, mass_concentration_of_silicate_in_sea_water, max, Max_Depth, microcystin, mole, mole_concentration_of_ammonium_in_sea_water, mole_concentration_of_nitrate_in_sea_water, mole_concentration_of_nitrite_in_sea_water, n02, nh4, nitrate, nitrite, NO2, no3, NO3_NO2, ocean, oceanography, oceans, office, preliminary, ratio, reported, sample, Sample_Depth, Sample_DO, scale, science, sea, sea_water_ph_reported_on_total_scale, seawater, silicate, station, temperature, time, time2, tkn, TN_TP_ratio, total, water, Water_Temp";
    String keywords_vocabulary "GCMD Science Keywords";
    String license "https://www.bco-dmo.org/dataset/814593/license";
    String metadata_source "https://www.bco-dmo.org/api/dataset/814593";
    Float64 Northernmost_Northing 41.479817;
    String param_mapping "{'814593': {'Lat': 'flag - latitude', 'Sample_Depth': 'flag - depth', 'long': 'flag - longitude', 'ISO_DateTime_UTC': 'flag - time'}}";
    String parameter_source "https://www.bco-dmo.org/mapserver/dataset/814593/parameters";
    String people_0_affiliation "Bowling Green State University";
    String people_0_affiliation_acronym "BGSU";
    String people_0_person_name "George S. Bullerjahn";
    String people_0_person_nid "51464";
    String people_0_role "Principal Investigator";
    String people_0_role_type "originator";
    String people_1_affiliation "Bowling Green State University";
    String people_1_affiliation_acronym "BGSU";
    String people_1_person_name "Robert Michael McKay";
    String people_1_person_nid "51463";
    String people_1_role "Co-Principal Investigator";
    String people_1_role_type "originator";
    String people_2_affiliation "Woods Hole Oceanographic Institution";
    String people_2_affiliation_acronym "WHOI BCO-DMO";
    String people_2_person_name "Shannon Rauch";
    String people_2_person_nid "51498";
    String people_2_role "BCO-DMO Data Manager";
    String people_2_role_type "related";
    String project "Great Lakes Center";
    String projects_0_acronym "Great Lakes Center";
    String projects_0_description 
"NSF Award Abstract:
The Lake Erie Center for Fresh Waters and Human Health is a five-year, multi-institutional effort aimed at understanding the environmental factors and ongoing changes that influence the growth and toxicity of cyanobacterial harmful algal blooms (cHABs) in Lake Erie. The Center will support three research projects. Specifically these projects address the following aims: first, how environmental cues promote or constrain the proliferation of cHAB species in mixed populations; second, how environmental cues influence toxin production by cHAB species; third, how other member of the microbial assemblage influence cHAB growth and toxicity. The Center will provide a Community Engagement Core to lead outreach activities that will inform the general public on the effects of cHABs by efforts that include: (1) a community engaged scholarship training for scientists associated with the Center, (2) community-engaged scholarship training for practitioners or community members associated with the Center, and (3) a stakeholder needs assessment for Great Lakes and environmental health literacy to inform general outreach information needs. A citizen science engagement with charter boat captains will further develop a near real-time database on cHAB severity in Lake Erie, and the Facilities Core will provide metadata that not only serve the three stated research projects, but also yield a database available to all Great Lakes scientists. The outcomes are to involve community stakeholders and researchers in the Great Lakes on issues regarding human health, climate change and awareness of threats to our fresh water resources.
The Center is jointly supported by NSF and by the National Institute for Environmental Health Sciences (NIEHS).
This award reflects NSF's statutory mission and has been deemed worthy of support through evaluation using the Foundation's intellectual merit and broader impacts review criteria.";
    String projects_0_end_date "2023-09";
    String projects_0_geolocation "Laurentian Great Lakes";
    String projects_0_name "Lake Erie Center for Fresh Waters and Human Health";
    String projects_0_project_nid "751269";
    String projects_0_project_website "https://www.bgsu.edu/great-lakes-center.html";
    String projects_0_start_date "2018-10";
    String publisher_name "Biological and Chemical Oceanographic Data Management Office (BCO-DMO)";
    String publisher_type "institution";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 41.453333;
    String standard_name_vocabulary "CF Standard Name Table v55";
    String summary "Data from Sandusky Bay, Lake Erie from surveys conducted via Ohio Dept of Natural Resources watercraft from June to September 2019.";
    String time_coverage_end "2019-09-23T13:18Z";
    String time_coverage_start "2019-06-10T10:25Z";
    String title "[Sandusky Bay Surveys 2019] - Data from Sandusky Bay, Lake Erie from surveys conducted via Ohio Dept of Natural Resources watercraft from June to September 2019 (Lake Erie Center for Fresh Waters and Human Health)";
    String version "1";
    Float64 Westernmost_Easting -82.960767;
    String xml_source "osprey2erddap.update_xml() v1.5";
  }
}

 

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