ERDDAP > tabledap > Data Access Form

Dataset Title:	Oceanographic data collected onboard SV Oceanolog during the Sail for Science - 2023 expedition in the Gulf of St. Lawrence
Institution:	Sail for Science   (Dataset ID: sail_for_science_ctd)
Information:	Summary | License | FGDC | ISO 19115 | Metadata | Background | Subset | Files | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum    or a List of Values	Maximum
Label	!= =~ <= >= = < >		!= =~ <= >= = < >		"QC, Riviere du Loup, marina" "QC, Trois Pistoles"
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		47.8475 48.1335
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-69.56934 -69.1887
Instrument_Serial	!= =~ <= >= = < >		!= =~ <= >= = < >		210470
Instrument_Model	!= =~ <= >= = < >		!= =~ <= >= = < >		"RBRconcerto³"
Sensor_Serial	!= =~ <= >= = < >		!= =~ <= >= = < >		"918TI0471"
Sensor_Channel (Channel)	!= =~ <= >= = < >		!= =~ <= >= = < >		1
time (UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >
Conductivity (mS/cm)	!= =~ <= >= = < >		!= =~ <= >= = < >		24.3631	25.2024
Temperature (degree Celsius)	!= =~ <= >= = < >		!= =~ <= >= = < >		12.3449	18.8262
DO_Concentration (µmol/L)	!= =~ <= >= = < >		!= =~ <= >= = < >		246.55	283.23
Backscatter (m⁻¹sr⁻¹)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.00346	0.29629
Chlorophyll_a	!= =~ <= >= = < >		!= =~ <= >= = < >		0.692	37.819
FDOM	!= =~ <= >= = < >		!= =~ <= >= = < >		11.678	18.478
Sea_pressure	!= =~ <= >= = < >		!= =~ <= >= = < >		0.497	8.995
depth (m)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.493	8.922
Salinity (PSU)	!= =~ <= >= = < >		!= =~ <= >= = < >		17.042	20.802
DO_saturation	!= =~ <= >= = < >		!= =~ <= >= = < >		90.29	97.28
Density_anomaly	!= =~ <= >= = < >		!= =~ <= >= = < >		11.4003	15.5742
QC_flag	!= =~ <= >= = < >		!= =~ <= >= = < >		1

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" Label latitude longitude Instrument_Serial Instrument_Model Sensor_Serial Sensor_Channel time Conductivity Temperature DO_Concentration Backscatter Chlorophyll_a FDOM Sea_pressure depth Salinity DO_saturation Density_anomaly QC_flag Label latitude longitude Instrument_Serial Instrument_Model Sensor_Serial Sensor_Channel time Conductivity Temperature DO_Concentration Backscatter Chlorophyll_a FDOM Sea_pressure depth Salinity DO_saturation Density_anomaly QC_flag Label latitude longitude Instrument_Serial Instrument_Model Sensor_Serial Sensor_Channel time Conductivity Temperature DO_Concentration Backscatter Chlorophyll_a FDOM Sea_pressure depth Salinity DO_saturation Density_anomaly QC_flag Label latitude longitude Instrument_Serial Instrument_Model Sensor_Serial Sensor_Channel time Conductivity Temperature DO_Concentration Backscatter Chlorophyll_a FDOM Sea_pressure depth Salinity DO_saturation Density_anomaly QC_flag Label latitude longitude Instrument_Serial Instrument_Model Sensor_Serial Sensor_Channel time Conductivity Temperature DO_Concentration Backscatter Chlorophyll_a FDOM Sea_pressure depth Salinity DO_saturation Density_anomaly QC_flag ")

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 {
  Label {
    String ioos_category "Unknown";
    String long_name "Label";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float32 actual_range 47.8475, 48.1335;
    String axis "Y";
    Float64 colorBarMaximum 90.0;
    Float64 colorBarMinimum -90.0;
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float32 actual_range -69.56934, -69.1887;
    String axis "X";
    Float64 colorBarMaximum 180.0;
    Float64 colorBarMinimum -180.0;
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  Instrument_Serial {
    Int32 _FillValue 2147483647;
    Int32 actual_range 210470, 210470;
    String ioos_category "Unknown";
    String long_name "Instrument Serial";
  }
  Instrument_Model {
    String ioos_category "Unknown";
    String long_name "Instrument Model";
  }
  Sensor_Serial {
    String ioos_category "Unknown";
    String long_name "Sensor Serial";
  }
  Sensor_Channel {
    Byte _FillValue 127;
    String _Unsigned "false";
    Byte actual_range 1, 1;
    String ioos_category "Unknown";
    String long_name "Channel";
  }
  time {
    String _CoordinateAxisType "Time";
    String axis "T";
    String ioos_category "Time";
    String long_name "Time";
    String source_name "Time";
    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";
  }
  Conductivity {
    Float32 actual_range 24.3631, 25.2024;
    Float64 colorBarMaximum 40.0;
    Float64 colorBarMinimum 30.0;
    String ioos_category "Salinity";
    String long_name "Sea Water Electrical Conductivity";
    String standard_name "sea_water_electrical_conductivity";
    String units "mS/cm";
  }
  Temperature {
    Float32 actual_range 12.3449, 18.8262;
    String ioos_category "Temperature";
    String long_name "Temperature";
    String standard_name "sea_water_temperature";
    String units "degree Celsius";
  }
  DO_Concentration {
    Float32 actual_range 246.55, 283.23;
    String ioos_category "Dissolved O2";
    String long_name "Dissolved Oxygen Concentration";
    String standard_name "mole_concentration_of_dissolved_molecular_oxygen_in_sea_water";
    String units "µmol/L";
  }
  Backscatter {
    Float32 actual_range 0.00346, 0.29629;
    String ioos_category "Unknown";
    String long_name "Backscatter";
    String units "m⁻¹sr⁻¹";
  }
  Chlorophyll_a {
    Float32 actual_range 0.692, 37.819;
    Float64 colorBarMaximum 30.0;
    Float64 colorBarMinimum 0.03;
    String colorBarScale "Log";
    String ioos_category "Ocean Color";
    String long_name "Concentration Of Chlorophyll In Sea Water";
    String standard_name "concentration_of_chlorophyll_in_sea_water";
  }
  FDOM {
    Float32 actual_range 11.678, 18.478;
    String ioos_category "Unknown";
    String long_name "FDOM";
  }
  Sea_pressure {
    Float32 actual_range 0.497, 8.995;
    String ioos_category "Pressure";
    String long_name "Sea Pressure";
  }
  depth {
    String _CoordinateAxisType "Height";
    String _CoordinateZisPositive "down";
    Float32 actual_range 0.493, 8.922;
    String axis "Z";
    Float64 colorBarMaximum 8000.0;
    Float64 colorBarMinimum -8000.0;
    String colorBarPalette "TopographyDepth";
    String ioos_category "Location";
    String long_name "Depth";
    String positive "down";
    String standard_name "depth";
    String units "m";
  }
  Salinity {
    Float32 actual_range 17.042, 20.802;
    Float64 colorBarMaximum 37.0;
    Float64 colorBarMinimum 32.0;
    String ioos_category "Salinity";
    String long_name "Sea Water Practical Salinity";
    String standard_name "sea_water_practical_salinity";
    String units "PSU";
  }
  DO_saturation {
    Float32 actual_range 90.29, 97.28;
    String ioos_category "Unknown";
    String long_name "DO Saturation";
  }
  Density_anomaly {
    Float32 actual_range 11.4003, 15.5742;
    Float64 colorBarMaximum 10.0;
    Float64 colorBarMinimum -10.0;
    String ioos_category "Physical Oceanography";
    String long_name "Density Anomaly";
  }
  QC_flag {
    Byte _FillValue 127;
    String _Unsigned "false";
    Byte actual_range 1, 1;
    Float64 colorBarMaximum 150.0;
    Float64 colorBarMinimum 0.0;
    String ioos_category "Quality";
    String long_name "QC Flag";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "Point";
    String comment "##Limitations: No limitations";
    String contributor_name "Shkvorets, Igor;Troshyna, Iryna";
    String contributor_role "owner,custodian,principalInvestigator,distributor;coAuthor,editor";
    String Conventions "COARDS, CF-1.10, ACDD-1.3";
    String creator_address "1 Harrogate Pl.";
    String creator_city "Ottawa";
    String creator_country "Canada";
    String creator_email "ishkvorets@gmail.com";
    String creator_institution "Sail for Science";
    String creator_name "Shkvorets, Igor";
    String creator_orcid "https://orcid.org/0009-0009-9728-1331";
    String creator_type "person";
    String creator_url "www.sailforscience.com";
    String date_modified "2026-01-08T21:11:31.892Z";
    Float64 Easternmost_Easting -69.1887;
    String featureType "Point";
    Float64 geospatial_lat_max 48.1335;
    Float64 geospatial_lat_min 47.8475;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -69.1887;
    Float64 geospatial_lon_min -69.56934;
    String geospatial_lon_units "degrees_east";
    Float64 geospatial_vertical_max 8.922;
    Float64 geospatial_vertical_min 0.493;
    String geospatial_vertical_positive "down";
    String geospatial_vertical_units "m";
    String history 
"2026-03-11T13:44:23Z (local files)
2026-03-11T13:44:23Z https://dev.cioosatlantic.ca/erddap/tabledap/sail_for_science_ctd.html";
    String id "55a55292-716b-426a-8bce-a0a079a1074b";
    String infoUrl "www.sailforscience.com";
    String institution "Sail for Science";
    String keywords "chlorophyll a, CIOOS:dissolvedOrganicCarbon, CIOOS:other, CIOOS:oxygen, CIOOS:particulateMatter, CIOOS:seaSurfaceSalinity, CIOOS:seaSurfaceTemperature, CIOOS:subSurfaceSalinity, CIOOS:subSurfaceTemperature, conductivity, dissolved oxygen, fDOM, salinity, transmittance, water temperature";
    String keywords_vocabulary "CIOOS: CIOOS Essential Ocean Variables Vocabulary";
    String license "https://creativecommons.org/licenses/by-sa/4.0/";
    String metadata_form "https://cioos-siooc.github.io/metadata-entry-form#/en/atlantic/Ax18d8AulhTzQPzB9J3X5JG2Son2/-Od48XG-0i3iqxVT7VGm";
    String naming_authority "ca.cioos";
    Float64 Northernmost_Northing 48.1335;
    String product_version "1.1";
    String progress "completed";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 47.8475;
    String standard_name_vocabulary "CF Standard Name Table v70";
    String subsetVariables "Label, latitude, longitude, Instrument_Serial, Instrument_Model, Sensor_Serial, Sensor_Channel, QC_flag";
    String summary "Presented collected with RBRconcertoCTD a set of oceanographic data, including variables: conductivity, temperature, practical salinity, specific density, dissolved oxygen, transmittance, chlorophyll-a, fDOM at sampling rate 8Hz in the Gulf of St. Lawrence at the moorings of SV Oceanolog on the route: Rivière-du-Loup - Gaspe - Magdalen Is. - Cape North. This is a pilot stage's set of high-accuracy and resolution oceanographic data collected during the citizen science project Sail for Science underway to the Caribbean: www.sailforscience.com";
    String title "Oceanographic data collected onboard SV Oceanolog during the Sail for Science - 2023 expedition in the Gulf of St. Lawrence";
    Float64 Westernmost_Easting -69.56934;
  }
}

 

---

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