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

ERDDAP > tabledap > Data Access Form ?

Dataset Title:  Sonde water quality measurements - Effects of Hurricane Harvey on Estuarine
Water Quality in the Guadalupe Estuary between August 2017 and December 2017.
Subscribe RSS
Institution:  BCO-DMO   (Dataset ID: bcodmo_dataset_787319)
Information:  Summary ? | License ? | ISO 19115 | Metadata | Background (external link) | Subset | Files | Make a graph
Variable ?   Optional
Constraint #1 ?
Constraint #2 ?
   Minimum ?
   or a List of Values ?
   Maximum ?
 Date (unitless) ?          "2017-08-01"    "2017-12-05"
 time2 (Time, unitless) ?          "0:00:00"    "9:45:00"
 latitude (degrees_north) ?      
   - +  ?
  < slider >
 longitude (degrees_east) ?      
   - +  ?
  < slider >
 Cond (micro siemens per cm (uS/cm)) ?          212    49004
 Sal (unitless) ?          0.1    32.09
 DOPct (percent (%)) ?          0.0    217.1
 DO (milligram per liter (mg/L)) ?          0.0    18.2
 pH (pH units) ?          6.91    9.05
 Temp (degrees Celsius (°C)) ?          13.65    32.35
 Sonde_WaterColumn_Location (unitless) ?          "bottom"    "surface"
 time (ISO Date Time UTC, UTC) ?          2017-08-01T05:00:00Z    2017-12-05T16:15:00Z
  < slider >
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 {
  Date {
    String bcodmo_name "date";
    String description "Sample Date (yyyy-mm-dd) in Central Standard Time (CST)";
    String long_name "Date";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/ADATAA01/";
    String time_precision "1970-01-01";
    String units "unitless";
  time2 {
    String bcodmo_name "time";
    String description "Time (HH:MM:SS) in Central Standard Time (CST)";
    String long_name "Time";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/AHMSAA01/";
    String units "unitless";
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 _FillValue NaN;
    Float64 actual_range 28.39352, 28.39352;
    String axis "Y";
    String bcodmo_name "latitude";
    Float64 colorBarMaximum 90.0;
    Float64 colorBarMinimum -90.0;
    String description "Latitude, south is negative";
    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 -96.7724, -96.7724;
    String axis "X";
    String bcodmo_name "longitude";
    Float64 colorBarMaximum 180.0;
    Float64 colorBarMinimum -180.0;
    String description "Longitude, west is negative";
    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";
  Cond {
    Int32 _FillValue 2147483647;
    Int32 actual_range 212, 49004;
    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 "micro siemens per cm (uS/cm)";
  Sal {
    Float32 _FillValue NaN;
    Float32 actual_range 0.1, 32.09;
    String bcodmo_name "sal";
    String description "Salinity";
    String long_name "Sal";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/PSALST01/";
    String units "unitless";
  DOPct {
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 217.1;
    String bcodmo_name "dissolved Oxygen";
    String description "Dissolved Oxygen saturation";
    String long_name "DOPct";
    String units "percent (%)";
  DO {
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 18.2;
    String bcodmo_name "dissolved Oxygen";
    String description "Dissolved Oxygen concentration";
    String long_name "DO";
    String units "milligram per liter (mg/L)";
  pH {
    Float32 _FillValue NaN;
    Float32 actual_range 6.91, 9.05;
    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 "pH units";
  Temp {
    Float32 _FillValue NaN;
    Float32 actual_range 13.65, 32.35;
    String bcodmo_name "temperature";
    String description "Water temperature";
    String long_name "Temperature";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/TEMPP901/";
    String units "degrees Celsius (°C)";
  Sonde_WaterColumn_Location {
    String bcodmo_name "site";
    String description "Location of the sonde in the water column: surface or bottom";
    String long_name "Sonde Water Column Location";
    String units "unitless";
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.5015636e+9, 1.5124905e+9;
    String axis "T";
    String bcodmo_name "ISO_DateTime_UTC";
    String description "Date/Time (UTC) in ISO format (YYYY-mm-ddTHH:MM:SSZ (UTC time))";
    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:00:00Z";
    String units "seconds since 1970-01-01T00:00:00Z";
    String access_formats ".htmlTable,.csv,.json,.mat,.nc,.tsv,.esriCsv,.geoJson,.odvTxt";
    String acquisition_description 
"Water quality sondes (Hydrolab DS5X sondes) were deployed continuously on the
surface and bottom of one site in the Guadalupe Estuary, Texas (Lat: 28.39352
, Lon: -96.7724).\\u00a0 Sondes recorded water quality data noted above at
15-minute intervals.\\u00a0 Datasondes were calibrated prior to deployment and
traded out every 5-14 days depending on biofouling and weather conditions. A
YSI ProPlus sonde recorded a water profile during each sonde deployment to
compare grab sample data with sonde readings.
Sampling trips were conducted from one of five small (\\u226425\\u2019) outboard
engine equipped boats: Guardian, Mango, Stinger, Gator, or Guppy. Each cruise
was less than 12 hrs in duration.
    String awards_0_award_nid "783255";
    String awards_0_award_number "OCE-1760006";
    String awards_0_data_url "http://www.nsf.gov/awardsearch/showAward.do?AwardNumber=1760006";
    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 
"Sonde surface bottom combined 
  PI: Michael Wetz  
  Data Version sonde_surface_bottom_combined.csv: 2020-01-23";
    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 "2020-01-14T18:58:39Z";
    String date_modified "2020-03-03T19:41:06Z";
    String defaultDataQuery "&amp;time&lt;now";
    String doi "10.1575/1912/bco-dmo.787319.1";
    Float64 Easternmost_Easting -96.7724;
    Float64 geospatial_lat_max 28.39352;
    Float64 geospatial_lat_min 28.39352;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -96.7724;
    Float64 geospatial_lon_min -96.7724;
    String geospatial_lon_units "degrees_east";
    String history 
"2022-08-09T14:11:21Z (local files)
2022-08-09T14:11:21Z https://erddap.bco-dmo.org/erddap/tabledap/bcodmo_dataset_787319.html";
    String infoUrl "https://www.bco-dmo.org/dataset/787319";
    String institution "BCO-DMO";
    String instruments_0_acronym "HydroLab DS5";
    String instruments_0_dataset_instrument_description "Hydrolab DS5X sondes";
    String instruments_0_dataset_instrument_nid "788188";
    String instruments_0_description "Multi-parameter probes that can measure from 12 (MS5) to 16 (DS5 and DS5X) parameters simultaneously. Measurements include temperature, depth, conductivity, salinity, specific conductance, TDS, pH, ORP, dissolved oxygen, turbidity, chlorophyll a, blue-green algae, Rhodamine WT, ammonium, nitrate, chloride, PAR and total dissolved gases. These probes can be deployed at depths up to 200 m and can be used in continuous monitoring programs.";
    String instruments_0_instrument_name "Hydrolab Series 5 probes";
    String instruments_0_instrument_nid "768060";
    String instruments_0_supplied_name "Hydrolab DS5X sondes";
    String keywords "altimetry, bco, bco-dmo, biological, chemical, chemistry, column, cond, data, dataset, date, dmo, dopct, earth, Earth Science > Oceans > Ocean Chemistry > pH, erddap, iso, laboratory, latitude, longitude, management, ocean, oceanography, oceans, office, preliminary, reported, sal, satellite, scale, science, sea, sea_water_ph_reported_on_total_scale, seawater, sonde, Sonde_WaterColumn_Location, Temp, temperature, time, time2, total, water";
    String keywords_vocabulary "GCMD Science Keywords";
    String license "https://www.bco-dmo.org/dataset/787319/license";
    String metadata_source "https://www.bco-dmo.org/api/dataset/787319";
    Float64 Northernmost_Northing 28.39352;
    String param_mapping "{'787319': {'Latitude': 'flag - latitude', 'Longitude': 'flag - longitude', 'ISO_DateTime_UTC': 'flag - time'}}";
    String parameter_source "https://www.bco-dmo.org/mapserver/dataset/787319/parameters";
    String people_0_affiliation "Texas A&M, Corpus Christi";
    String people_0_affiliation_acronym "TAMU-CC";
    String people_0_person_name "Michael Wetz";
    String people_0_person_nid "553945";
    String people_0_role "Principal Investigator";
    String people_0_role_type "originator";
    String people_1_affiliation "Texas A&M, Corpus Christi";
    String people_1_affiliation_acronym "TAMU-CC";
    String people_1_person_name "Michael Wetz";
    String people_1_person_nid "553945";
    String people_1_role "Contact";
    String people_1_role_type "related";
    String people_2_affiliation "Woods Hole Oceanographic Institution";
    String people_2_affiliation_acronym "WHOI BCO-DMO";
    String people_2_person_name "Karen Soenen";
    String people_2_person_nid "748773";
    String people_2_role "BCO-DMO Data Manager";
    String people_2_role_type "related";
    String project "Hurricane Harvey Texas Lagoons";
    String projects_0_acronym "Hurricane Harvey Texas Lagoons";
    String projects_0_description 
"NSF Award Abstract:
Hurricane Harvey made landfall Friday 25 August 2017 about 30 miles northeast of Corpus Christi, Texas as a Category 4 hurricane with winds up to 130 mph. This is the strongest hurricane to hit the middle Texas coast since Carla in 1961. After the wind storm and storm surge, coastal flooding occurred due to the storm lingering over Texas for four more days, dumping as much as 50 inches of rain near Houston. This will produce one of the largest floods ever to hit the Texas coast, and it is estimated that the flood will be a one in a thousand year event. The Texas coast is characterized by lagoons behind barrier islands, and their ecology and biogeochemistry are strongly influenced by coastal hydrology. Because this coastline is dominated by open water systems and productivity is driven by the amount of freshwater inflow, Hurricane Harvey represents a massive inflow event that will likely cause tremendous changes to the coastal environments. Therefore, questions arise regarding how biogeochemical cycles of carbon, nutrients, and oxygen will be altered, whether massive phytoplankton blooms will occur, whether estuarine species will die when these systems turn into lakes, and how long recovery will take? The investigators are uniquely situated to mount this study not only because of their location, just south of the path of the storm, but most importantly because the lead investigator has conducted sampling of these bays regularly for the past thirty years, providing a tremendous context in which to interpret the new data gathered. The knowledge gained from this study will provide a broader understanding of the effects of similar high intensity rainfall events, which are expected to increase in frequency and/or intensity in the future.
The primary research hypothesis is that: Increased inflows to estuaries will cause increased loads of inorganic and organic matter, which will in turn drive primary production and biological responses, and at the same time significantly enhance respiration of coastal blue carbon. A secondary hypothesis is that: The large change in salinity and dissolved oxygen deficits will kill or stress many estuarine and marine organisms. To test these hypotheses it is necessary to measure the temporal change in key indicators of biogeochemical processes, and biodiversity shifts. Thus, changes to the carbon, nitrogen and oxygen cycles, and the diversity of benthic organisms will be measured and compared to existing baselines. The PIs propose to sample the Lavaca-Colorado, Guadalupe, Nueces, and Laguna Madre estuaries as follows: 1) continuous sampling (via autonomous instruments) of salinity, temperature, pH, dissolved oxygen, and depth (i.e. tidal elevation); 2) bi-weekly to monthly sampling for dissolved and total organic carbon and organic nitrogen, carbonate system parameters, nutrients, and phytoplankton community composition; 3) quarterly measurements of sediment characteristics and benthic infauna. The project will support two graduate students. The PIs will communicate results to the public and to state agencies through existing collaborations.";
    String projects_0_end_date "2019-08";
    String projects_0_geolocation "Northwest Gulf of Mexico estuaries on Texas Coast";
    String projects_0_name "RAPID: Capturing the Signature of Hurricane Harvey on Texas Coastal Lagoons";
    String projects_0_project_nid "783256";
    String projects_0_start_date "2017-10";
    String publisher_name "Biological and Chemical Oceanographic Data Management Office (BCO-DMO)";
    String publisher_type "institution";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 28.39352;
    String standard_name_vocabulary "CF Standard Name Table v55";
    String subsetVariables "latitude,longitude";
    String summary "Bottom and surface water quality sonde data of the Guadalupe Estuary site (Texas) between August 2017 and December 2017.";
    String time_coverage_end "2017-12-05T16:15:00Z";
    String time_coverage_start "2017-08-01T05:00:00Z";
    String title "Sonde water quality measurements - Effects of Hurricane Harvey on Estuarine Water Quality in the Guadalupe Estuary between August 2017 and December 2017.";
    String version "1";
    Float64 Westernmost_Easting -96.7724;
    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
For example,
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