ERDDAP > tabledap > Data Access Form

Dataset Title:	Provisional Real-Time Hakai Seafloor Observatory in Hyacinthe Bay, Quadra Island, British Columbia, Canada
Institution:	Hakai Institute   (Dataset ID: HakaiQuadraLimpet5min)
Information:	Summary | License | FGDC | Metadata | Background | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum	Maximum
time (UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		50.11736	50.11736
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-125.22003	-125.22003
station	!= =~ <= >= = < >		!= =~ <= >= = < >		Quadra Limpet	Quadra Limpet
WaterTemp_Avg (degree_Celsius)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterTemp_Std (degree_Celsius)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterTemp_UQL	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterTemp_flags	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterEC_Avg (S/m)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterEC_Std (S/m)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterEC_UQL	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterEC_flags	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterPressure_Avg (decibar)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterPressure_Std (Sea Water Pressure STD, decibar)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterPressure_UQL	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterPressure_flags	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterDepth_Avg (Depth Mean, m)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterDepth_UQL (Depth QARTOD Quality Flags)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterDepth_flags (Depth Quality Flags)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterOxygen_Avg (ml/L)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterOxygen_Std (ml/L)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterOxygen_UQL	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterOxygen_flags (Water Oxygen Quality Flags)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterSalinity_Avg (Salinity Mean)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterSalinity_UQL (Salinity QARTOD Quality Flags)	!= =~ <= >= = < >		!= =~ <= >= = < >
WaterSalinity_flags (Water Salinity Quality Flags)	!= =~ <= >= = < >		!= =~ <= >= = < >
Chlorophyll_Avg (Chlorophyll Mean, μg/l)	!= =~ <= >= = < >		!= =~ <= >= = < >
Chlorophyll_UQL	!= =~ <= >= = < >		!= =~ <= >= = < >
Chlorophyll_flags (Chlorophyll Quality Flags)	!= =~ <= >= = < >		!= =~ <= >= = < >

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" time latitude longitude station WaterTemp_Avg WaterTemp_Std WaterTemp_UQL WaterTemp_flags WaterEC_Avg WaterEC_Std WaterEC_UQL WaterEC_flags WaterPressure_Avg WaterPressure_Std WaterPressure_UQL WaterPressure_flags WaterDepth_Avg WaterDepth_UQL WaterDepth_flags WaterOxygen_Avg WaterOxygen_Std WaterOxygen_UQL WaterOxygen_flags WaterSalinity_Avg WaterSalinity_UQL WaterSalinity_flags Chlorophyll_Avg Chlorophyll_UQL Chlorophyll_flags time latitude longitude station WaterTemp_Avg WaterTemp_Std WaterTemp_UQL WaterTemp_flags WaterEC_Avg WaterEC_Std WaterEC_UQL WaterEC_flags WaterPressure_Avg WaterPressure_Std WaterPressure_UQL WaterPressure_flags WaterDepth_Avg WaterDepth_UQL WaterDepth_flags WaterOxygen_Avg WaterOxygen_Std WaterOxygen_UQL WaterOxygen_flags WaterSalinity_Avg WaterSalinity_UQL WaterSalinity_flags Chlorophyll_Avg Chlorophyll_UQL Chlorophyll_flags time latitude longitude station WaterTemp_Avg WaterTemp_Std WaterTemp_UQL WaterTemp_flags WaterEC_Avg WaterEC_Std WaterEC_UQL WaterEC_flags WaterPressure_Avg WaterPressure_Std WaterPressure_UQL WaterPressure_flags WaterDepth_Avg WaterDepth_UQL WaterDepth_flags WaterOxygen_Avg WaterOxygen_Std WaterOxygen_UQL WaterOxygen_flags WaterSalinity_Avg WaterSalinity_UQL WaterSalinity_flags Chlorophyll_Avg Chlorophyll_UQL Chlorophyll_flags time latitude longitude station WaterTemp_Avg WaterTemp_Std WaterTemp_UQL WaterTemp_flags WaterEC_Avg WaterEC_Std WaterEC_UQL WaterEC_flags WaterPressure_Avg WaterPressure_Std WaterPressure_UQL WaterPressure_flags WaterDepth_Avg WaterDepth_UQL WaterDepth_flags WaterOxygen_Avg WaterOxygen_Std WaterOxygen_UQL WaterOxygen_flags WaterSalinity_Avg WaterSalinity_UQL WaterSalinity_flags Chlorophyll_Avg Chlorophyll_UQL Chlorophyll_flags time latitude longitude station WaterTemp_Avg WaterTemp_Std WaterTemp_UQL WaterTemp_flags WaterEC_Avg WaterEC_Std WaterEC_UQL WaterEC_flags WaterPressure_Avg WaterPressure_Std WaterPressure_UQL WaterPressure_flags WaterDepth_Avg WaterDepth_UQL WaterDepth_flags WaterOxygen_Avg WaterOxygen_Std WaterOxygen_UQL WaterOxygen_flags WaterSalinity_Avg WaterSalinity_UQL WaterSalinity_flags Chlorophyll_Avg Chlorophyll_UQL Chlorophyll_flags ")

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 cell_methods "time: point (interval: 5.0 minutes comment: time correspond to the end of the interval)";
    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";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 actual_range 50.11736, 50.11736;
    String axis "Y";
    String description "Fixed latitude of the site";
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float64 actual_range -125.22003, -125.22003;
    String axis "X";
    String description "Fixed longitude of the site";
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  station {
    String actual_range 
"Quadra Limpet
Quadra Limpet";
    String cf_role "timeseries_id";
    String ioos_category "Location";
  }
  WaterTemp_Avg {
    String ancillary_variables "WaterTemp_flags WaterTemp_UQL";
    String cell_methods "time: mean (interval: 5.0 minutes)";
    String long_name "Sea Water Temperature Mean";
    String sensor_description "SBE 37-SMP-ODO MicroCAT C-T-ODO (P) Recorder";
    String sensor_type "SBE 37-SMP-ODO";
    String standard_name "sea_water_temperature";
    String units "degree_Celsius";
  }
  WaterTemp_Std {
    String ancillary_variables "WaterTemp_flags WaterTemp_UQL";
    String cell_methods "time: standard_deviation (interval: 5.0 minutes)";
    String long_name "Sea Water Temperature STD";
    String sensor_description "SBE 37-SMP-ODO MicroCAT C-T-ODO (P) Recorder";
    String sensor_type "SBE 37-SMP-ODO";
    String standard_name "sea_water_temperature";
    String units "degree_Celsius";
  }
  WaterTemp_UQL {
    String _Unsigned "false";
    String flag_meaning "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String long_name "Water Temperature QARTOD Quality flags";
    Byte missing_value 2;
    String standard_name "aggregate_quality_flag";
  }
  WaterTemp_flags {
    String long_name "Sea Water Temperature Quality Flags";
  }
  WaterEC_Avg {
    String ancillary_variables "WaterEC_flags WaterEC_UQL";
    String cell_methods "time: mean (interval: 5.0 minutes)";
    String long_name "Sea Water Electrical Conductivity Mean";
    String sensor_description "SBE 37-SMP-ODO MicroCAT C-T-ODO (P) Recorder";
    String sensor_type "SBE 37-SMP-ODO";
    String standard_name "sea_water_electrical_conductivity";
    String units "S/m";
  }
  WaterEC_Std {
    String ancillary_variables "WaterEC_flags WaterEC_UQL";
    String cell_methods "time: standard_deviation (interval: 5.0 minutes)";
    String long_name "Sea Water Electrical Conductivity STD";
    String sensor_description "SBE 37-SMP-ODO MicroCAT C-T-ODO (P) Recorder";
    String sensor_type "SBE 37-SMP-ODO";
    String standard_name "sea_water_electrical_conductivity";
    String units "S/m";
  }
  WaterEC_UQL {
    String _Unsigned "false";
    String flag_meaning "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String long_name "Sea Water Electrical Conductivity QARTOD Quality Flags";
    Byte missing_value 2;
    String standard_name "aggregate_quality_flag";
  }
  WaterEC_flags {
    String long_name "Sea Water Electrical Conductivity Quality Flags";
  }
  WaterPressure_Avg {
    String ancillary_variables "WaterPressure_flags WaterPressure_UQL";
    String cell_methods "time: mean (interval: 5.0 minutes)";
    String long_name "Sea Water Pressure Mean";
    String sensor_description "SBE 37-SMP-ODO MicroCAT C-T-ODO (P) Recorder";
    String sensor_type "SBE 37-SMP-ODO";
    String standard_name "sea_water_pressure";
    String units "decibar";
  }
  WaterPressure_Std {
    String ancillary_variables "WaterPressure_flags WaterPressure_UQL";
    String cell_methods "time: standard_deviation (interval: 5.0 minutes)";
    String long_name "Sea Water Pressure STD";
    String sensor_description "SBE 37-SMP-ODO MicroCAT C-T-ODO (P) Recorder";
    String sensor_type "SBE 37-SMP-ODO";
    String standard_name "sea_water_pressure";
    String units "decibar";
  }
  WaterPressure_UQL {
    String _Unsigned "false";
    String flag_meaning "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String long_name "Sea Water Pressure QARTOD Quality Flags";
    Byte missing_value 2;
    String standard_name "aggregate_quality_flag";
  }
  WaterPressure_flags {
    String long_name "Sea Water Pressure Quality Flags";
  }
  WaterDepth_Avg {
    String ancillary_variables "WaterDepth_flags WaterDepth_UQL";
    String cell_methods "time: mean (interval: 5.0 minutes)";
    String long_name "Depth Mean";
    String sensor_description "SBE 37-SMP-ODO MicroCAT C-T-ODO (P) Recorder";
    String sensor_type "SBE 37-SMP-ODO";
    String standard_name "depth";
    String units "m";
  }
  WaterDepth_UQL {
    String _Unsigned "false";
    String flag_meaning "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String long_name "Depth QARTOD Quality Flags";
    Byte missing_value 2;
    String standard_name "aggregate_quality_flag";
  }
  WaterDepth_flags {
    String long_name "Depth Quality Flags";
  }
  WaterOxygen_Avg {
    String ancillary_variables "WaterOxygen_flags WaterOxygen_UQL";
    String cell_methods "time: mean (interval: 5.0 minutes)";
    String long_name "Dissolved Oxygen Concentration Mean";
    String sensor_description "SBE 37-SMP-ODO MicroCAT C-T-ODO (P) Recorder";
    String sensor_type "SBE 37-SMP-ODO";
    String standard_name "volume_fraction_of_oxygen_in_sea_water";
    String units "ml/L";
  }
  WaterOxygen_Std {
    String ancillary_variables "WaterOxygen_flags";
    String cell_methods "time: standard_deviation (interval: 5.0 minutes)";
    String long_name "Dissolved Oxygen Concentration STD";
    String sensor_description "SBE 37-SMP-ODO MicroCAT C-T-ODO (P) Recorder";
    String sensor_type "SBE 37-SMP-ODO";
    String standard_name "volume_fraction_of_oxygen_in_sea_water";
    String units "ml/L";
  }
  WaterOxygen_UQL {
    String _Unsigned "false";
    String flag_meaning "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String long_name "Water Oxygen QARTOD Quality Flags";
    Byte missing_value 2;
    String standard_name "aggregate_quality_flag";
  }
  WaterOxygen_flags {
    String long_name "Water Oxygen Quality Flags";
  }
  WaterSalinity_Avg {
    String ancillary_variables "WaterSalinity_flags WaterSalinity_UQL";
    String cell_methods "time: mean (interval: 5.0 minutes)";
    String long_name "Salinity Mean";
    String sensor_description "SBE 37-SMP-ODO MicroCAT C-T-ODO (P) Recorder";
    String sensor_type "SBE 37-SMP-ODO";
    String standard_name "sea_water_practical_salinity";
  }
  WaterSalinity_UQL {
    String _Unsigned "false";
    String flag_meaning "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String long_name "Salinity QARTOD Quality Flags";
    Byte missing_value 2;
    String standard_name "aggregate_quality_flag";
  }
  WaterSalinity_flags {
    String long_name "Water Salinity Quality Flags";
  }
  Chlorophyll_Avg {
    String ancillary_variables "Chlorophyll_flags Chlorophyll_UQL";
    String cell_methods "time: mean (interval: 5.0 minutes)";
    String long_name "Chlorophyll Mean";
    String sensor_description "Wet Labs Fluorometer (WetStar)";
    String sensor_type "Fluorometer";
    String units "μg/l";
  }
  Chlorophyll_UQL {
    String _Unsigned "false";
    String flag_meaning "PASS NOT_EVALUATED SUSPECT FAIL MISSING";
    Byte flag_values 1, 2, 3, 4, 9;
    String long_name "Chlorophyll QARTOD Quality Flags";
    Byte missing_value 2;
    String standard_name "aggregate_quality_flag";
  }
  Chlorophyll_flags {
    String long_name "Chlorophyll Quality Flags";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "TimeSeries";
    String cdm_timeseries_variables "station";
    String creator_url "https://www.hakai.org/";
    Float64 Easternmost_Easting -125.22003;
    String elevation "-20";
    String featureType "TimeSeries";
    Float64 geospatial_lat_max 50.11736;
    Float64 geospatial_lat_min 50.11736;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -125.22003;
    Float64 geospatial_lon_min -125.22003;
    String geospatial_lon_units "degrees_east";
    String geospatial_vertical_max "20";
    String geospatial_vertical_min "20";
    String history 
"2024-04-20T06:51:11Z (source database)
2024-04-20T06:51:11Z https://catalogue.hakai.org/erddap/tabledap/HakaiQuadraLimpet5min.html";
    String id "HakaiQuadraLimpet5min";
    String infoUrl "https://www.hakai.org";
    String institution "Hakai Institute";
    String keywords "oxygen, subSurfaceSalinity, subSurfaceTemperature";
    String keywords_fra "oxygène, salinité sous la surface, température sous la surface";
    String language "eng";
    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, ERD, 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 measurement_interval "5 minute";
    Float64 Northernmost_Northing 50.11736;
    String platform "fixed benthic node";
    String platform_vocabulary "https://vocab.nerc.ac.uk/collection/L06/current/";
    String publisher_email "data@hakai.org";
    String publisher_name "Hakai Institute";
    String publisher_url "https://www.hakai.org/";
    String site_id "Quadra Limpet";
    String sourceUrl "(source database)";
    Float64 Southernmost_Northing 50.11736;
    String standard_name_vocabulary "CF Standard Name Table v79";
    String summary "The limpet provides real-time data on ocean temperature, conductivity, and dissolved oxygen for the waters off Quadra Island.";
    String summary_fra "La limpet fournit des données en temps réel sur la température de l'océan, la conductivité et l'oxygène dissous pour les eaux au large de l'île Quadra.";
    String title "Provisional Real-Time Hakai Seafloor Observatory in Hyacinthe Bay, Quadra Island, British Columbia, Canada";
    String title_fra "Données en temp réelle et provisoire de l'ibservatoire du fond marin de l'Institut Hakai dans la baie Hyacinthe, île Quadra, Colombie-Britannique, Canada";
    Float64 Westernmost_Easting -125.22003;
  }
}

 

---

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