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

ERDDAP > tabledap > Data Access Form ?

Dataset Title:  Discrete hydrographic measurements - Effects of Hurricane Harvey on Estuarine
Water Quality in the Lavaca-Colorado, Guadalupe and Nueces Estuaries between
August 2017 and January 2018.
Subscribe RSS
Institution:  BCO-DMO   (Dataset ID: bcodmo_dataset_787316)
Information:  Summary ? | License ? | ISO 19115 | Metadata | Background (external link) | Files | Make a graph
 
Variable ?   Optional
Constraint #1 ?
Optional
Constraint #2 ?
   Minimum ?
 
   Maximum ?
 
 Date (unitless) ?          "2017-08-16"    "2018-01-23"
 latitude (degrees_north) ?          27.7128    28.68096
  < slider >
 longitude (degrees_east) ?          -97.47358    -96.01878
  < slider >
 Times (unitless) ?          "10:00"    "NaN"
 Site (unitless) ?          "15"    "FD"
 Replicate (unitless) ?          "A"    "NaN"
 depth (m) ?          0.4    4.5
  < slider >
 Chlorophyll (migrograms per liter (ug/L)) ?          0.95    82.52
 Conductivity (mircosiemens per centimeter (µS/cm)) ?          0.4    56.03
 Salinity (unitless) ?          0.19    37.21
 DO (milligram per liter (mg/L)) ?          0.9    18.4
 DOPct (percentage (%)) ?          11.4    189.9
 pH (pH units) ?          7.44    8.93
 Temp (degrees celcius (°C)) ?          7.8    32.5
 Secchi (meter (m)) ?          0.1    2.0
 DOC (Micromoles per Liter (umol/L)) ?          115.5    1068.9
 TDN (Micromoles per Liter (umol/L)) ?          8.7    111.9
 TOC (Micromoles per Liter (umol/L)) ?          201.9    1162.3
 TN (Micromoles per Liter (umol/L)) ?          17.5    162.7
 Ammonium (Micromoles per Liter (umol/L)) ?          0.12    40.45
 N_N (Micromoles per Liter (umol/L)) ?          0.07    83.42
 Nitrite (Micromoles per Liter (umol/L)) ?          0.0    2.89
 ortho_P (Micromoles per Liter (umol/L)) ?          0.0    14.0
 Silicate (Micromoles per Liter (umol/L)) ?          "0.11"    "NaN"
 Estuary (unitless) ?          "Guadalupe"    "Nueces"
 time (ISO Date Time UTC, UTC) ?          2017-08-16T15:43: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 (mm/dd/YYYY) in Central Standard Time (CST)";
    String long_name "Date";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/ADATAA01/";
    String source_name "Date";
    String time_precision "1970-01-01";
    String units "unitless";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 _FillValue NaN;
    Float64 actual_range 27.7128, 28.68096;
    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 -97.47358, -96.01878;
    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";
  }
  Times {
    String bcodmo_name "time";
    String description "Time (HH:MM) in Central Standard Time (CST)";
    String long_name "Times";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/AHMSAA01/";
    String units "unitless";
  }
  Site {
    String bcodmo_name "site";
    String description "Site";
    String long_name "Site";
    String units "unitless";
  }
  Replicate {
    String bcodmo_name "replicate";
    String description "Replicate A or B";
    String long_name "Replicate";
    String units "unitless";
  }
  depth {
    String _CoordinateAxisType "Height";
    String _CoordinateZisPositive "down";
    Float64 _FillValue NaN;
    Float64 actual_range 0.4, 4.5;
    String axis "Z";
    String bcodmo_name "depth";
    String description "Depth";
    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";
  }
  Chlorophyll {
    Float32 _FillValue NaN;
    Float32 actual_range 0.95, 82.52;
    String bcodmo_name "unknown";
    Float64 colorBarMaximum 30.0;
    Float64 colorBarMinimum 0.03;
    String colorBarScale "Log";
    String description "Chlorophyll [detection limit = 0.03]";
    String long_name "Concentration Of Chlorophyll In Sea Water";
    String units "migrograms per liter (ug/L)";
  }
  Conductivity {
    Float32 _FillValue NaN;
    Float32 actual_range 0.4, 56.03;
    String bcodmo_name "conductivity";
    Float64 colorBarMaximum 40.0;
    Float64 colorBarMinimum 30.0;
    String description "Conductivity [detection limit = 10]";
    String long_name "Sea Water Electrical Conductivity";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P02/current/CNDC/";
    String units "mircosiemens per centimeter (µS/cm)";
  }
  Salinity {
    Float32 _FillValue NaN;
    Float32 actual_range 0.19, 37.21;
    String bcodmo_name "sal_ctd";
    Float64 colorBarMaximum 37.0;
    Float64 colorBarMinimum 32.0;
    String description "Salinity [detection limit = 0.01]";
    String long_name "Sea Water Practical Salinity";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/PSALST01/";
    String units "unitless";
  }
  DO {
    Float32 _FillValue NaN;
    Float32 actual_range 0.9, 18.4;
    String bcodmo_name "dissolved Oxygen";
    String description "Dissolved Oxygen concentration [detection limit = 0.2]";
    String long_name "DO";
    String units "milligram per liter (mg/L)";
  }
  DOPct {
    Float32 _FillValue NaN;
    Float32 actual_range 11.4, 189.9;
    String bcodmo_name "dissolved Oxygen";
    String description "Dissolved Oxygen saturation [detection limit = 2.0]";
    String long_name "DOPct";
    String units "percentage (%)";
  }
  pH {
    Float32 _FillValue NaN;
    Float32 actual_range 7.44, 8.93;
    String bcodmo_name "pH";
    Float64 colorBarMaximum 9.0;
    Float64 colorBarMinimum 7.0;
    String description "pH [detection limit = 0.01]";
    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 7.8, 32.5;
    String bcodmo_name "temperature";
    String description "Water temperature [detection limit = 0.2]";
    String long_name "Temperature";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/TEMPP901/";
    String units "degrees celcius  (°C)";
  }
  Secchi {
    Float32 _FillValue NaN;
    Float32 actual_range 0.1, 2.0;
    String bcodmo_name "depth_secchi";
    String description "Secchi depth";
    String long_name "Secchi";
    String units "meter (m)";
  }
  DOC {
    Float32 _FillValue NaN;
    Float32 actual_range 115.5, 1068.9;
    String bcodmo_name "DOC";
    String description "Dissolved organic carbon [detection limit = 13.3]";
    String long_name "DOC";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/CORGZZZX/";
    String units "Micromoles per Liter (umol/L)";
  }
  TDN {
    Float32 _FillValue NaN;
    Float32 actual_range 8.7, 111.9;
    String bcodmo_name "Total Dissolved Nitrogren";
    String description "Total dissolved nitrogen [detection limit = 3.8]";
    String long_name "TDN";
    String units "Micromoles per Liter (umol/L)";
  }
  TOC {
    Float32 _FillValue NaN;
    Float32 actual_range 201.9, 1162.3;
    String bcodmo_name "C_org";
    String description "Total organic carbon [detection limit = 13.3]";
    String long_name "TOC";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/CORGCOZX/";
    String units "Micromoles per Liter (umol/L)";
  }
  TN {
    Float32 _FillValue NaN;
    Float32 actual_range 17.5, 162.7;
    String bcodmo_name "N";
    String description "Total nitrogen [detection limit = 3.8]";
    String long_name "TN";
    String units "Micromoles per Liter (umol/L)";
  }
  Ammonium {
    Float32 _FillValue NaN;
    Float32 actual_range 0.12, 40.45;
    String bcodmo_name "Ammonium";
    Float64 colorBarMaximum 5.0;
    Float64 colorBarMinimum 0.0;
    String description "Ammonium [detection limit = 0.03]";
    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)";
  }
  N_N {
    Float32 _FillValue NaN;
    Float32 actual_range 0.07, 83.42;
    String bcodmo_name "NO3_NO2";
    String description "Nitrate plus nitrite [detection limit = 0.02]";
    String long_name "N N";
    String units "Micromoles per Liter (umol/L)";
  }
  Nitrite {
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 2.89;
    String bcodmo_name "NO2";
    Float64 colorBarMaximum 1.0;
    Float64 colorBarMinimum 0.0;
    String description "Nitrite [detection limit = 0.02]";
    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)";
  }
  ortho_P {
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 14.0;
    String bcodmo_name "PO4";
    String description "Orthophosphate [detection limit = 0.01]";
    String long_name "Ortho P";
    String units "Micromoles per Liter (umol/L)";
  }
  Silicate {
    String bcodmo_name "SiOH_4";
    String description "Silicate [detection limit = 0.01]";
    String long_name "Silicate";
    String units "Micromoles per Liter (umol/L)";
  }
  Estuary {
    String bcodmo_name "station";
    String description "Sampling station: Lavaca-Colorado, Guadalupe or Nueces Estuaries";
    String long_name "Estuary";
    String units "unitless";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.50289818e+9, NaN;
    String axis "T";
    String bcodmo_name "ISO_DateTime_UTC";
    String description "ISO format (YYYY-mm-ddTHH:MMZ) of Date/Time in Coordinated Universal Time (UTC)";
    String ioos_category "Time";
    String long_name "ISO Date Time UTC";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/DTUT8601/";
    String standard_name "time";
    String time_origin "01-JAN-1970 00:00:00";
    String units "seconds since 1970-01-01T00:00:00Z";
  }
 }
  NC_GLOBAL {
    String access_formats ".htmlTable,.csv,.json,.mat,.nc,.tsv,.esriCsv,.geoJson,.odvTxt";
    String acquisition_description 
"Multiple hydrographic measurements were made at the stations Lavaca-Colorado
(LC), Guadalupe (GE) and Nueces Estuaries (NE) on the Texas coast, using a YSI
Proplus multi-parameter instrument (The parameters were read from the digital
display unit). Vertical profiles of Sal, Cond, DO, DOPct, pH and Temp were
taken at 0.5 m intervals.\\u00a0 Discrete samples were collected at 10 cm below
the surface and for some variables at 10 cm above the bottom.\\u00a0 Secchi
disc was lowered until it could no longer be viewed.
 
Sampling trips/deployments 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.
 
Additional methodological details can be found in Wetz et al. 2016.";
    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 
"Discrete combined 
  PI: Michael Wetz   
  Data Version discrete_combined.csv: 2020-01-14";
    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:53:13Z";
    String date_modified "2020-03-03T18:11:10Z";
    String defaultDataQuery "&amp;time&lt;now";
    String doi "10.1575/1912/bco-dmo.787316.1";
    Float64 Easternmost_Easting -96.01878;
    Float64 geospatial_lat_max 28.68096;
    Float64 geospatial_lat_min 27.7128;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -96.01878;
    Float64 geospatial_lon_min -97.47358;
    String geospatial_lon_units "degrees_east";
    Float64 geospatial_vertical_max 4.5;
    Float64 geospatial_vertical_min 0.4;
    String geospatial_vertical_positive "down";
    String geospatial_vertical_units "m";
    String history 
"2024-04-20T11:33:28Z (local files)
2024-04-20T11:33:28Z https://erddap.bco-dmo.org/erddap/tabledap/bcodmo_dataset_787316.html";
    String infoUrl "https://www.bco-dmo.org/dataset/787316";
    String institution "BCO-DMO";
    String instruments_0_acronym "YSI ProPlus";
    String instruments_0_dataset_instrument_description "Hydrographic measurements were made at each station with a YSI Proplus multi parameter instrument.  The parameters were read from the digital display unit.";
    String instruments_0_dataset_instrument_nid "788191";
    String instruments_0_description "The YSI Professional Plus handheld multiparameter meter provides for the measurement of a variety of combinations for dissolved oxygen, conductivity, specific conductance, salinity, resistivity, total dissolved solids (TDS), pH, ORP, pH/ORP combination, ammonium (ammonia), nitrate, chloride and temperature. More information from the manufacturer.";
    String instruments_0_instrument_name "YSI Professional Plus Multi-Parameter Probe";
    String instruments_0_instrument_nid "666";
    String instruments_0_supplied_name "YSI Proplus multi parameter";
    String keywords "ammonia, ammonium, bco, bco-dmo, biological, chemical, chemistry, chlorophyll, commerce, concentration, concentration_of_chlorophyll_in_sea_water, conductivity, data, dataset, date, density, department, depth, depth2, dmo, doc, dopct, earth, Earth Science > Oceans > Ocean Chemistry > Ammonia, Earth Science > Oceans > Ocean Chemistry > Chlorophyll, Earth Science > Oceans > Ocean Chemistry > pH, Earth Science > Oceans > Salinity/Density > Conductivity, Earth Science > Oceans > Salinity/Density > Salinity, electrical, erddap, estuary, iso, ISO_DateTime_UTC, latitude, longitude, management, mole, mole_concentration_of_ammonium_in_sea_water, mole_concentration_of_nitrite_in_sea_water, N_N, nh4, nitrite, ocean, oceanography, oceans, office, ortho, ortho_P, practical, preliminary, replicate, reported, salinity, scale, science, sea, sea_water_electrical_conductivity, sea_water_ph_reported_on_total_scale, sea_water_practical_salinity, seawater, secchi, silicate, site, tdn, Temp, temperature, time, times, toc, total, water";
    String keywords_vocabulary "GCMD Science Keywords";
    String license "https://www.bco-dmo.org/dataset/787316/license";
    String metadata_source "https://www.bco-dmo.org/api/dataset/787316";
    Float64 Northernmost_Northing 28.68096;
    String param_mapping "{'787316': {'Latitude': 'flag - latitude', 'Depth': 'flag - depth', 'Longitude': 'flag - longitude', 'ISO_DateTime_UTC': 'flag - time'}}";
    String parameter_source "https://www.bco-dmo.org/mapserver/dataset/787316/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 27.7128;
    String standard_name_vocabulary "CF Standard Name Table v55";
    String summary "Discrete hydrographic measurements of Lavaca-Colorado, Guadalupe and Nueces Estuaries on the Texas coast between August 2017 and January 2018.";
    String time_coverage_start "2017-08-16T15:43:00Z";
    String title "Discrete hydrographic measurements - Effects of Hurricane Harvey on Estuarine Water Quality in the Lavaca-Colorado, Guadalupe and Nueces Estuaries between August 2017 and January 2018.";
    String version "1";
    Float64 Westernmost_Easting -97.47358;
    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