PacIOOS ERDDAP
Easier access to scientific data

ERDDAP > tabledap > Data Access Form ?

Dataset Title:  Hawaii Clean Water Branch (CWB) Beach Water Quality Data Subscribe RSS
Institution:  State of Hawaii Clean Water Branch (CWB)   (Dataset ID: cwb_water_quality)
Information:  Summary ? | License ? | FGDC | ISO 19115 | Metadata | Background (external link) | Subset | Make a graph
 
Variable ?   Optional
Constraint #1 ?
Optional
Constraint #2 ?
   Minimum ?
   or a List of Values ?
   Maximum ?
 
 time (UTC) ?          1973-06-04T21:00:00Z    
  < slider >
 longitude (degrees_east) ?          -159.77742    -154.81667
  < slider >
 latitude (degrees_north) ?          18.914389    22.225416
  < slider >
 location_id ?      
   - +  ?
 location_name ?      
   - +  ?
 enterococcus (Enterococcus CFU, 1/(100-mL)) ?              
 clostridium (1/(100-mL)) ?              
 water_temperature (Celsius) ?              
 salinity (salinity PSU, 1) ?              
 turbidity (turbidity NTU, 1) ?              
 ph (1) ?              
 oxygen (dissolved oxygen, mg/L) ?              
 oxygen_saturation (dissolved oxygen saturation, %) ?              
 
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 {
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.080756e+8, NaN;
    String axis "T";
    String ioos_category "Time";
    String long_name "Time";
    String standard_name "time";
    String time_origin "01-JAN-1970 00:00:00";
    String units "seconds since 1970-01-01T00:00:00Z";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float32 actual_range -159.77742, -154.81667;
    String axis "X";
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float32 actual_range 18.914389, 22.225416;
    String axis "Y";
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  location_id {
    Int32 actual_range 152, 1253;
    String ioos_category "Identifier";
    String long_name "CWB identifier for this sampling location";
  }
  location_name {
    String ioos_category "Location";
    String long_name "location name";
  }
  enterococcus {
    Float64 colorBarMaximum 100.0;
    Float64 colorBarMinimum 0.0;
    String comment "Colony Forming Units (CFU)";
    String ioos_category "Pathogens";
    String long_name "Enterococcus CFU";
    String standard_name "number_concentration_of_enterococcus_in_sea_water";
    String units "1/(100-mL)";
  }
  clostridium {
    Float64 colorBarMaximum 15.0;
    Float64 colorBarMinimum 0.0;
    String comment "Colony Forming Units (CFU)";
    String ioos_category "Pathogens";
    String long_name "Clostridium perfringens CFU";
    String standard_name "number_concentration_of_clostridium_perfringens_in_sea_water";
    String units "1/(100-mL)";
  }
  water_temperature {
    Float64 colorBarMaximum 31.0;
    Float64 colorBarMinimum 11.0;
    String ioos_category "Temperature";
    String long_name "water temperature";
    String standard_name "sea_water_temperature";
    String units "Celsius";
  }
  salinity {
    Float64 colorBarMaximum 40.0;
    Float64 colorBarMinimum 10.0;
    String comment "Practical Salinity Units (PSU)";
    String ioos_category "Salinity";
    String long_name "salinity PSU";
    String standard_name "sea_water_practical_salinity";
    String units "1";
  }
  turbidity {
    Float64 colorBarMaximum 10.0;
    Float64 colorBarMinimum 0.0;
    String comment "Nephelometric Turbidity Units (NTU)";
    String ioos_category "Optical Properties";
    String long_name "turbidity NTU";
    String standard_name "sea_water_turbidity";
    String units "1";
  }
  ph {
    Float64 colorBarMaximum 9.0;
    Float64 colorBarMinimum 7.0;
    String ioos_category "Other";
    String long_name "pH";
    String standard_name "sea_water_ph_reported_on_total_scale";
    String units "1";
  }
  oxygen {
    Float64 colorBarMaximum 10.0;
    Float64 colorBarMinimum 0.0;
    String ioos_category "Dissolved O2";
    String long_name "dissolved oxygen";
    String standard_name "mass_concentration_of_oxygen_in_sea_water";
    String units "mg/L";
  }
  oxygen_saturation {
    Float64 colorBarMaximum 100.0;
    Float64 colorBarMinimum 0.0;
    String ioos_category "Dissolved O2";
    String long_name "dissolved oxygen saturation";
    String standard_name "fractional_saturation_of_oxygen_in_sea_water";
    String units "%";
  }
 }
  NC_GLOBAL {
    String acknowledgement "The Pacific Islands Ocean Observing System (PacIOOS) is funded through the National Oceanic and Atmospheric Administration (NOAA) as a Regional Association within the U.S. Integrated Ocean Observing System (IOOS). PacIOOS is coordinated by the University of Hawaii School of Ocean and Earth Science and Technology (SOEST).";
    String cdm_data_type "Point";
    String comment "Some sampling sites have been discontinued and therefore do not contain recent measurements in this dataset.";
    String Conventions "CF-1.6, ACDD-1.3";
    String creator_email "cleanwaterbranch@doh.hawaii.gov";
    String creator_institution "State of Hawaii Clean Water Branch (CWB)";
    String creator_name "State of Hawaii Clean Water Branch (CWB)";
    String creator_type "institution";
    String creator_url "https://health.hawaii.gov/cwb/";
    String date_created "2013-03-28";
    String date_issued "2013-03-28";
    String date_metadata_modified "2021-04-01";
    String date_modified "2013-03-28";
    String defaultDataQuery "&time>=now-3months";
    String defaultGraphQuery "longitude,latitude,enterococcus&time>=now-3months&.draw=markers";
    Float64 Easternmost_Easting -154.8167;
    String featureType "Point";
    String geospatial_bounds "POLYGON ((18.914389 -159.777417, 22.225417 -159.777417, 22.225417 -154.816667, 18.914389 -154.816667, 18.914389 -159.777417))";
    String geospatial_bounds_crs "EPSG:4326";
    Float64 geospatial_lat_max 22.22542;
    Float64 geospatial_lat_min 18.91439;
    Float64 geospatial_lat_resolution 0.0;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -154.8167;
    Float64 geospatial_lon_min -159.7774;
    Float64 geospatial_lon_resolution 0.0;
    String geospatial_lon_units "degrees_east";
    Float64 geospatial_vertical_max -0.3;
    Float64 geospatial_vertical_min -0.3;
    String geospatial_vertical_positive "up";
    Float64 geospatial_vertical_resolution 0.0;
    String geospatial_vertical_units "meters";
    String history 
"2013-03-29T00:00:00Z PacIOOS begins ingest from U.S. Water Quality Portal (WQP) and Hawaii Clean Water Branch (CWB) into PacIOOS ERDDAP data server.
2024-03-29T14:54:44Z (source database)
2024-03-29T14:54:44Z https://pae-paha.pacioos.hawaii.edu/erddap/tabledap/cwb_water_quality.html";
    String infoUrl "http://www.beachapedia.org/State_of_the_Beach/State_Reports/HI/Water_Quality";
    String institution "State of Hawaii Clean Water Branch (CWB)";
    String instrument "In Situ/Laboratory Instruments > Chemical Meters/Analyzers > > > Autoanalyzer, In Situ/Laboratory Instruments > Chemical Meters/Analyzers > > > pH Meters, In Situ/Laboratory Instruments > Conductivity Sensors, In Situ/Laboratory Instruments > Photon/Optical Detectors > > > Turbidity Meters, In Situ/Laboratory Instruments > Samplers > Bottles/Flasks/Jars, In Situ/Laboratory Instruments > Temperature/Humidity Sensors > > > Temperature Sensors";
    String instrument_vocabulary "GCMD Instrument Keywords";
    String ISO_Topic_Categories "climatologyMeteorologyAtmosphere, environment, health, oceans";
    String keywords "Earth Science > Oceans > Ocean Chemistry > Oxygen, Earth Science > Oceans > Ocean Chemistry > pH, Earth Science > Oceans > Ocean Optics > Turbidity, Earth Science > Oceans > Ocean Temperature > Water Temperature, Earth Science > Oceans > Salinity/Density > Salinity, Earth Science > Oceans > Water Quality > Ocean Contaminants";
    String keywords_vocabulary "GCMD Science Keywords";
    String license "The data may be used and redistributed for free but is not intended for legal use, since it may contain inaccuracies. Neither the data Contributor, University of Hawaii, PacIOOS, NOAA, State of Hawaii nor the United States Government, nor any of their employees or contractors, makes any warranty, express or implied, including warranties of merchantability and fitness for a particular purpose, or assumes any legal liability for the accuracy, completeness, or usefulness, of this information.";
    String locations "Continent > North America > United States Of America > Hawaii, Ocean > Pacific Ocean > Central Pacific Ocean > Hawaiian Islands";
    String locations_vocabulary "GCMD Location Keywords";
    String metadata_link "https://www.pacioos.hawaii.edu/metadata/cwb_water_quality.html";
    String naming_authority "org.pacioos";
    Float64 Northernmost_Northing 22.22542;
    String platform "In Situ Land-based Platforms > Ocean Platform/Ocean Stations > Coastal Stations";
    String platform_vocabulary "GCMD Platform Keywords";
    String processing_level "Quality control measures described in the State of Hawaii Beach Monitoring Quality Assurance Project Plan (CWBMONQAPP002).";
    String program "State of Hawaii Clean Water Branch (CWB)";
    String project "State of Hawaii Beach Monitoring Quality Assurance";
    String publisher_email "info@pacioos.org";
    String publisher_institution "Pacific Islands Ocean Observing System (PacIOOS)";
    String publisher_name "Pacific Islands Ocean Observing System (PacIOOS)";
    String publisher_type "institution";
    String publisher_url "http://www.pacioos.hawaii.edu";
    String references "https://www.pacioos.hawaii.edu/wp-content/uploads/2016/08/Beach_Monitoring_QAPP_CWBMONQAPP002_120507.pdf; https://health.hawaii.gov/cwb/files/2017/05/Hawaii-Beach-Monitoring-Program-170508.pdf";
    String source "in situ measurements and water samples";
    String sourceUrl "(source database)";
    Float64 Southernmost_Northing 18.91439;
    String standard_name_vocabulary "CF Standard Name Table v39";
    String subsetVariables "location_id, location_name";
    String summary 
"Exposure to sewage contaminated recreational waters may cause gastrointestinal illnesses in swimmers. The State of Hawaii Department of Health (HIDOH) Clean Water Branch (CWB) monitors the waters of Hawaii's beaches for concentrations of Enterococcus, which acts as an indicator of pathogens. The CWB also uses Clostridium perfringens as a secondary tracer of sewage contamination. Results of this monitoring are evaluated using a decision rule to determine whether a beach is safe (\"Compliant\") or not safe (on \"Alert\") for swimming and other water contact activities. If a beach is found to be on \"Alert\" due to elevated indicator bacteria levels, the CWB issues public warnings and alerts and determines whether resampling of the area is necessary.

Under the U.S. BEACH Act, the State of Hawaii receives an annual grant to implement its beach monitoring program. This requires the State to conduct a monitoring and notification program that is consistent with performance criteria published by the U.S. Environmental Protection Agency (EPA) in 2002. In March 2010, the EPA approved amendments to the Hawaii Administrative Rules (HAR), Chapter 11-54, Water Quality Standards (CWB QAPrgP, HIDOH 2011, Appendix D), which revised the previous State Enterococcus criteria of a geometric mean (GM) of 7 colony-forming units (CFU) per 100 mL and a single sample maximum (SSM) of 100 CFU/100 mL to meet current EPA guidelines. The State of Hawaii now uses the EPA recommended Enterococcus GM and SSM for recreational waters consistent in the 1986 Ambient Water Quality Criteria for Bacteria. The criterion lists the GM and SSM for marine waters as 35 CFU/100 mL and 104 CFU/100 mL, respectively.

The CWB utilizes Clostridium perfringens as a secondary tracer in addition to the Enterococcus indicator to help distinguish between sewage and non-sewage sources of elevated Enterococcus levels in marine coastal waters. The reliability of Enterococcus as an indicator organism in tropical environments has been questioned. This issue was formally documented in the report, Tropical Water Quality Indicator Workshop (Fujioka and Byappanahalli, 2003).

One of the limitations of all available and EPA-approved test methods is that the sample must be incubated for about 24 hours. As a result, the public finds out today when they shouldn't have gone in the water yesterday. As a result, warning signs on the beach may or may not be reflective of actual water quality because they are based on tests performed one or more days ago.";
    String time_coverage_start "1973-06-04T21:00:00Z";
    String title "Hawaii Clean Water Branch (CWB) Beach Water Quality Data";
    Float64 Westernmost_Easting -159.7774;
  }
}

 

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.23
Disclaimers | Privacy Policy | Contact