ERDDAP > tabledap > Data Access Form

Dataset Title:	Avon Pump Station:water quality station
Institution:	Avon Lake Regional Water   (Dataset ID: obs_18)
Information:	Summary | License | FGDC | ISO 19115 | Metadata | Background | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum	Maximum
time (UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >
chlorophyll_fluorescence (RFU)	!= =~ <= >= = < >		!= =~ <= >= = < >
fluorescent_dissolved_organic_matter (RFU)	!= =~ <= >= = < >		!= =~ <= >= = < >
fractional_saturation_of_oxygen_in_sea_water (1)	!= =~ <= >= = < >		!= =~ <= >= = < >
mass_concentration_of_blue_green_algae_in_sea_water_rfu (RFU)	!= =~ <= >= = < >		!= =~ <= >= = < >
mass_concentration_of_blue_green_algae_in_sea_water_rfu_fixed_depth (m)	!= =~ <= >= = < >		!= =~ <= >= = < >
mass_concentration_of_oxygen_in_sea_water (kg m-3)	!= =~ <= >= = < >		!= =~ <= >= = < >
phycocyanin_fluorescence (RFU)	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_surface_temperature (K)	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_surface_temperature_gross_range_test	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_surface_temperature_spike_test	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_surface_temperature_rate_of_change_test	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_surface_temperature_flat_line_test	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_surface_temperature_aggregate	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_water_electrical_conductivity (S m-1)	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_water_ph_reported_on_total_scale (1)	!= =~ <= >= = < >		!= =~ <= >= = < >
sea_water_turbidity (1)	!= =~ <= >= = < >		!= =~ <= >= = < >
platform	!= =~ <= >= = < >		!= =~ <= >= = < >

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" time longitude latitude chlorophyll_fluorescence fluorescent_dissolved_organic_matter fractional_saturation_of_oxygen_in_sea_water mass_concentration_of_blue_green_algae_in_sea_water_rfu mass_concentration_of_blue_green_algae_in_sea_water_rfu_fixed_depth mass_concentration_of_oxygen_in_sea_water phycocyanin_fluorescence sea_surface_temperature sea_surface_temperature_gross_range_test sea_surface_temperature_spike_test sea_surface_temperature_rate_of_change_test sea_surface_temperature_flat_line_test sea_surface_temperature_aggregate sea_water_electrical_conductivity sea_water_ph_reported_on_total_scale sea_water_turbidity platform time longitude latitude chlorophyll_fluorescence fluorescent_dissolved_organic_matter fractional_saturation_of_oxygen_in_sea_water mass_concentration_of_blue_green_algae_in_sea_water_rfu mass_concentration_of_blue_green_algae_in_sea_water_rfu_fixed_depth mass_concentration_of_oxygen_in_sea_water phycocyanin_fluorescence sea_surface_temperature sea_surface_temperature_gross_range_test sea_surface_temperature_spike_test sea_surface_temperature_rate_of_change_test sea_surface_temperature_flat_line_test sea_surface_temperature_aggregate sea_water_electrical_conductivity sea_water_ph_reported_on_total_scale sea_water_turbidity platform time longitude latitude chlorophyll_fluorescence fluorescent_dissolved_organic_matter fractional_saturation_of_oxygen_in_sea_water mass_concentration_of_blue_green_algae_in_sea_water_rfu mass_concentration_of_blue_green_algae_in_sea_water_rfu_fixed_depth mass_concentration_of_oxygen_in_sea_water phycocyanin_fluorescence sea_surface_temperature sea_surface_temperature_gross_range_test sea_surface_temperature_spike_test sea_surface_temperature_rate_of_change_test sea_surface_temperature_flat_line_test sea_surface_temperature_aggregate sea_water_electrical_conductivity sea_water_ph_reported_on_total_scale sea_water_turbidity platform time longitude latitude chlorophyll_fluorescence fluorescent_dissolved_organic_matter fractional_saturation_of_oxygen_in_sea_water mass_concentration_of_blue_green_algae_in_sea_water_rfu mass_concentration_of_blue_green_algae_in_sea_water_rfu_fixed_depth mass_concentration_of_oxygen_in_sea_water phycocyanin_fluorescence sea_surface_temperature sea_surface_temperature_gross_range_test sea_surface_temperature_spike_test sea_surface_temperature_rate_of_change_test sea_surface_temperature_flat_line_test sea_surface_temperature_aggregate sea_water_electrical_conductivity sea_water_ph_reported_on_total_scale sea_water_turbidity platform time longitude latitude chlorophyll_fluorescence fluorescent_dissolved_organic_matter fractional_saturation_of_oxygen_in_sea_water mass_concentration_of_blue_green_algae_in_sea_water_rfu mass_concentration_of_blue_green_algae_in_sea_water_rfu_fixed_depth mass_concentration_of_oxygen_in_sea_water phycocyanin_fluorescence sea_surface_temperature sea_surface_temperature_gross_range_test sea_surface_temperature_spike_test sea_surface_temperature_rate_of_change_test sea_surface_temperature_flat_line_test sea_surface_temperature_aggregate sea_water_electrical_conductivity sea_water_ph_reported_on_total_scale sea_water_turbidity platform ")

File type: (more information) .asc - View OPeNDAP-style ISO-8859-1 comma-separated text. .csv - Download a ISO-8859-1 comma-separated text table (line 1: names; line 2: units; ISO 8601 times). .csvp - Download a ISO-8859-1 .csv file with line 1: name (units). Times are ISO 8601 strings. .csv0 - Download a ISO-8859-1 .csv file without column names or units. Times are ISO 8601 strings. .dataTable - A JSON file formatted for use with the Google Visualization client library (Google Charts). .das - View the dataset's metadata via an ISO-8859-1 OPeNDAP Dataset Attribute Structure (DAS). .dds - View the dataset's structure via an ISO-8859-1 OPeNDAP Dataset Descriptor Structure (DDS). .dods - OPeNDAP clients use this to download the data in the DODS binary format. .esriCsv - Download a ISO_8859_1 .csv file for ESRI's ArcGIS 9.x and below (separate date and time columns). .fgdc - View the dataset's UTF-8 FGDC .xml metadata. .geoJson - Download longitude,latitude,otherColumns data as a UTF-8 GeoJSON .json file. .graph - View a Make A Graph web page. .help - View a web page with a description of tabledap. .html - View an OPeNDAP-style HTML Data Access Form. .htmlTable - View a UTF-8 .html web page with the data in a table. Times are ISO 8601 strings. .iso19115 - View the dataset's ISO 19115-2/19139 UTF-8 .xml metadata. .itx - Download an ISO-8859-1 Igor Text File. Each response column becomes a wave. .json - View a table-like UTF-8 JSON file (missing value = 'null'; times are ISO 8601 strings). .jsonlCSV1 - View a UTF-8 JSON Lines CSV file with column names on line 1 (mv = 'null'; times are ISO 8601 strings). .jsonlCSV - View a UTF-8 JSON Lines CSV file without column names (mv = 'null'; times are ISO 8601 strings). .jsonlKVP - View a UTF-8 JSON Lines file with Key:Value pairs (missing value = 'null'; times are ISO 8601 strings). .mat - Download a MATLAB binary file. .nc - Download a flat, table-like, NetCDF-3 binary file with COARDS/CF/ACDD metadata. .ncHeader - View the UTF-8 header (the metadata) for the NetCDF-3 .nc file. .ncCF - Download a NetCDF-3 CF Discrete Sampling Geometries file (Contiguous Ragged Array). .ncCFHeader - View the UTF-8 header (the metadata) for the .ncCF file. .ncCFMA - Download a NetCDF-3 CF Discrete Sampling Geometries file (Multidimensional Array). .ncCFMAHeader - View the UTF-8 header (the metadata) for the .ncCFMA file. .nccsv - Download a NetCDF-3-like 7-bit ASCII NCCSV .csv file with COARDS/CF/ACDD metadata. .nccsvMetadata - View the dataset's metadata as the top half of a 7-bit ASCII NCCSV .csv file. .ncoJson - Download a UTF-8 NCO lvl=2 JSON file with COARDS/CF/ACDD metadata. .odvTxt - Download longitude,latitude,time,otherColumns as an ISO-8859-1 ODV Generic Spreadsheet File (.txt). .subset - View an HTML form which uses faceted search to simplify picking subsets of the data. .tsv - Download a ISO-8859-1 tab-separated text table (line 1: names; line 2: units; ISO 8601 times). .tsvp - Download a ISO-8859-1 .tsv file with line 1: name (units). Times are ISO 8601 strings. .tsv0 - Download a ISO-8859-1 .tsv file without column names or units. Times are ISO 8601 strings. .wav - Download a .wav audio file. All columns must be numeric and of the same type. .xhtml - View a UTF-8 XHTML (XML) file with the data in a table. Times are ISO 8601 strings. .kml - View a .kml file, suitable for Google Earth. .smallPdf - View a small .pdf image file with a graph or map. .pdf - View a standard, medium-sized .pdf image file with a graph or map. .largePdf - View a large .pdf image file with a graph or map. .smallPng - View a small .png image file with a graph or map. .png - View a standard, medium-sized .png image file with a graph or map. .largePng - View a large .png image file with a graph or map. .transparentPng - View a .png image file (just the data, without axes, landmask, or legend).

(Documentation / Bypass this form )
 
Submit (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";
    String axis "T";
    String calendar "gregorian";
    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";
    String axis "X";
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    String axis "Y";
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  chlorophyll_fluorescence {
    String ioos_category "Unknown";
    String long_name "chlorophyll_fluorescence";
    String platform "platform";
    String units "RFU";
  }
  fluorescent_dissolved_organic_matter {
    String ioos_category "Unknown";
    String long_name "fluorescent_dissolved_organic_matter";
    String platform "platform";
    String units "RFU";
  }
  fractional_saturation_of_oxygen_in_sea_water {
    String ioos_category "Dissolved O2";
    String platform "platform";
    String standard_name "fractional_saturation_of_oxygen_in_sea_water";
    String units "1";
  }
  mass_concentration_of_blue_green_algae_in_sea_water_rfu {
    String ancillary_variables "mass_concentration_of_blue_green_algae_in_sea_water_rfu_fixed_depth";
    String ioos_category "Unknown";
    String long_name "phycocyanin_fluorescence";
    String platform "platform";
    String units "RFU";
  }
  mass_concentration_of_blue_green_algae_in_sea_water_rfu_fixed_depth {
    String ioos_category "Location";
    String platform "platform";
    String standard_name "depth";
    String units "m";
  }
  mass_concentration_of_oxygen_in_sea_water {
    String ioos_category "Dissolved O2";
    String platform "platform";
    String standard_name "mass_concentration_of_oxygen_in_sea_water";
    String units "kg m-3";
  }
  phycocyanin_fluorescence {
    String ioos_category "Unknown";
    String long_name "phycocyanin_fluorescence";
    String platform "platform";
    String units "RFU";
  }
  sea_surface_temperature {
    String ancillary_variables "sea_surface_temperature_gross_range_test sea_surface_temperature_spike_test sea_surface_temperature_rate_of_change_test sea_surface_temperature_flat_line_test sea_surface_temperature_aggregate";
    String ioos_category "Temperature";
    String platform "platform";
    String standard_name "sea_water_temperature";
    String units "K";
  }
  sea_surface_temperature_gross_range_test {
    String _Unsigned "false";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String ioos_category "Quality";
    String standard_name "gross_range_test_quality_flag";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  sea_surface_temperature_spike_test {
    String _Unsigned "false";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String ioos_category "Quality";
    String standard_name "spike_test_quality_flag";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  sea_surface_temperature_rate_of_change_test {
    String _Unsigned "false";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String ioos_category "Quality";
    String standard_name "rate_of_change_test_quality_flag";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  sea_surface_temperature_flat_line_test {
    String _Unsigned "false";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String ioos_category "Quality";
    String standard_name "flat_line_test_quality_flag";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  sea_surface_temperature_aggregate {
    String _Unsigned "false";
    String flag_meanings "GOOD NOT_EVALUATED SUSPECT BAD MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String ioos_category "Quality";
    String standard_name "aggregate_quality_flag";
    Byte valid_max 9;
    Byte valid_min 1;
  }
  sea_water_electrical_conductivity {
    String ioos_category "Salinity";
    String platform "platform";
    String standard_name "sea_water_electrical_conductivity";
    String units "S m-1";
  }
  sea_water_ph_reported_on_total_scale {
    String ioos_category "Unknown";
    String platform "platform";
    String standard_name "sea_water_ph_reported_on_total_scale";
    String units "1";
  }
  sea_water_turbidity {
    String ioos_category "Total Suspended Matter";
    String platform "platform";
    String standard_name "sea_water_turbidity";
    String units "1";
  }
  platform {
    String _Unsigned "false";
    String cf_role "timeseries_id";
    String ioos_category "Unknown";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "TimeSeries";
    String cdm_timeseries_variables "platform,longitude,latitude";
    String Conventions "COARDS,CF-1.7,IOOS-1.2,ACDD-1.3";
    String creator_country "USA";
    String creator_email "gyuronich@avonlakewater.org";
    String creator_institution "Avon Lake Regional Water";
    String creator_name "Avon Lake Regional Water";
    String creator_sector "gov_municipal";
    String creator_type "institution";
    String creator_url "https://avonlakewater.org/";
    String featureType "TimeSeries";
    String geospatial_lat_units "degrees_north";
    String geospatial_lon_units "degrees_east";
    String gts_ingest "false";
    String history 
"2024-12-22T09:27:39Z (source database)
2024-12-22T09:27:39Z https://seagull-erddap.glos.org/erddap/tabledap/obs_18.html";
    String id "obs_18";
    String infoUrl "http://habs.glos.us/about/";
    String institution "Avon Lake Regional Water";
    String keywords "(fdom), at, Chlorophyll, chlorophyll, concentration, Conductivity, conductivity, depth, Dissolved, dissolved, electrical, fluorescence, Fluorescent, fluorescent, fractional, in, mass, matter, of, on, organic, oxygen, pH, ph, Phycocyanin, phycocyanin, reported, saturation, scale, sea, temp, temperature, total, Turbidity, turbidity, Water, water";
    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, GLOS, NOAA, 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 naming_authority "org.glos";
    String platform "fixed";
    String platform_name "Avon Pump Station";
    String platform_vocabulary "http://mmisw.org/ont/ioos/platform";
    String publisher_country "United States";
    String publisher_email "info@glos.org";
    String publisher_institution "GLOS";
    String publisher_url "https://glos.org";
    String sourceUrl "(source database)";
    String standard_name_vocabulary "CF Standard Name Table v77";
    String summary "Monitoring lake conditions at water treatment plants, remote pump stations, and intakes are an effective Harmful Algae Blooms (“HABs “) early warning system. Between 2014 and 2018, LimnoTech and GLOS worked with the water treatment plant system at Avon Lake to bring online the first version of the Lake Erie HABs monitoring network (the “Lake Erie HABs EWS”). In 2017, GLOS, together with Cleveland Water Alliance, LimnoTech, NOAA GLERL and Ohio State University, embarked on a 3-year project funded by the NOAA Ocean Technology Transition project to transition the Lake Erie HABs EWS into a sustainable, operational system.This allows water managers and researchers in the Lake Erie region to have timely and easy access to critical monitoring data during future blooms to help them make informed decisions about activities and resources affected by HABs presence and toxicity.";
    String title "Avon Pump Station:water quality station";
  }
}

 

---

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 Data Access Protocol (DAP) and its selection constraints.

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.

• (easy) You can get data by using the dataset's Data Access Form or Subset form. They make the URL for you.
• (easy) You can make a graph or map by using the dataset's Make A Graph form. It makes the URL for you.
• (not hard) You can bypass the forms and get the data or make a graph or map by generating the URL by hand or with a computer program or script.

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