ERDDAP > tabledap > Data Access Form

Dataset Title:	CTD - Saguenay Fjord and Estuary of St. Lawrence - NSERC-Hypoxia | CTD - Fjord du Saguenay et estuaire du St-Laurent - CRSNG-Hypoxie
Institution:	Institut des sciences de la mer de Rimouski   (Dataset ID: uqarIsmerCtdHypoxie)
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
time (UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		2021-08-25T11:47:51Z	2021-08-30T18:50:17Z
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		47.9167	49.6191
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-70.8598	-65.9967
stationID (Station Identifier, unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		"ES1" "ES2" "ES3" "OXY21-010" "SAG05" "SAG09" "SAG15" "SAG20" "SAG30" "SAG36" "SAG46" "SAG48" "St-Ful" "ST20" "St20B" "ST20N" "ST21" "ST21B" "ST21C" "ST22" "ST23" "ST23N1" "ST23N2" "ST23S1" "ST23S2" "ST24" "ST25"
PRES (pressure, dbar)	!= =~ <= >= = < >		!= =~ <= >= = < >		2.0	334.0
TE90 (temperature, degree_C)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.849	19.293
PSAL (practical salinity, PSU)	!= =~ <= >= = < >		!= =~ <= >= = < >		6.5	34.83
OXYM (dissolved oxygen, µM)	!= =~ <= >= = < >		!= =~ <= >= = < >		34.146	339.279
SVEL (Sound Velocity, m s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		1449.632	1501.78
SIGM (density, kg m-3)	!= =~ <= >= = < >		!= =~ <= >= = < >		3.31	28.861
SPVA (Specific Volume Anomaly, m3/kg)	!= =~ <= >= = < >		!= =~ <= >= = < >		77.764	2404.778
VAIS (Brunt-Vaisala Frequency N2, s-2)	!= =~ <= >= = < >		!= =~ <= >= = < >		-2.11E-4	0.0346
SIGT (sigma-T, kg m-3)	!= =~ <= >= = < >		!= =~ <= >= = < >		3.301	27.336
POTM (potential temperature, degree_C)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.848	19.297
SIGP (Sigma-Theta, kg m-3)	!= =~ <= >= = < >		!= =~ <= >= = < >		3.301	27.34
FRET (freezing temperature, degree_C)	!= =~ <= >= = < >		!= =~ <= >= = < >		-2.16	-0.36
ASAL (absolute salinity, g kg-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		6.531	34.996
CONT (degree_C)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.862	20.117
D_CT (kg m-3)	!= =~ <= >= = < >		!= =~ <= >= = < >		3.313	28.863
D0CT (kg m-3)	!= =~ <= >= = < >		!= =~ <= >= = < >		3.304	27.342
recordID (Original filename, unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		"2116_001"	"2116_029"

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" time latitude longitude stationID PRES TE90 PSAL OXYM SVEL SIGM SPVA VAIS SIGT POTM SIGP FRET ASAL CONT D_CT D0CT recordID time latitude longitude stationID PRES TE90 PSAL OXYM SVEL SIGM SPVA VAIS SIGT POTM SIGP FRET ASAL CONT D_CT D0CT recordID time latitude longitude stationID PRES TE90 PSAL OXYM SVEL SIGM SPVA VAIS SIGT POTM SIGP FRET ASAL CONT D_CT D0CT recordID time latitude longitude stationID PRES TE90 PSAL OXYM SVEL SIGM SPVA VAIS SIGT POTM SIGP FRET ASAL CONT D_CT D0CT recordID time latitude longitude stationID PRES TE90 PSAL OXYM SVEL SIGM SPVA VAIS SIGT POTM SIGP FRET ASAL CONT D_CT D0CT recordID ")

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";
    Float64 actual_range 1.629892071e+9, 1.630349417e+9;
    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";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float32 actual_range 47.9167, 49.6191;
    String axis "Y";
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float32 actual_range -70.8598, -65.9967;
    String axis "X";
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  stationID {
    String long_name "Station Identifier";
    String units "unitless";
  }
  PRES {
    String _CoordinateAxisType "Height";
    Float32 actual_range 2.0, 334.0;
    String axis "Z";
    String long_name "pressure";
    String standard_name "sea_water_pressure";
    String units "dbar";
  }
  TE90 {
    Float32 _FillValue NaN;
    Float32 actual_range 0.849, 19.293;
    String long_name "temperature";
    String standard_name "sea_water_temperature";
    String units "degree_C";
  }
  PSAL {
    Float32 _FillValue NaN;
    Float32 actual_range 6.5, 34.83;
    String long_name "practical salinity";
    String standard_name "sea_water_practical_salinity";
    String units "PSU";
  }
  OXYM {
    Float32 _FillValue NaN;
    Float32 actual_range 34.146, 339.279;
    String long_name "dissolved oxygen";
    String standard_name "mole_concentration_of_dissolved_molecular_oxygen_in_sea_water";
    String units "µM";
  }
  SVEL {
    Float32 _FillValue NaN;
    Float32 actual_range 1449.632, 1501.78;
    String long_name "Sound Velocity";
    String standard_name "speed_of_sound_in_sea_water";
    String units "m s-1";
  }
  SIGM {
    Float32 _FillValue NaN;
    Float32 actual_range 3.31, 28.861;
    String long_name "density";
    String standard_name "sea_water_density";
    String units "kg m-3";
  }
  SPVA {
    Float32 _FillValue NaN;
    Float32 actual_range 77.764, 2404.778;
    String long_name "Specific Volume Anomaly";
    String units "m3/kg";
  }
  VAIS {
    Float32 _FillValue NaN;
    Float32 actual_range -2.11e-4, 0.0346;
    String long_name "Brunt-Vaisala Frequency N2";
    String units "s-2";
  }
  SIGT {
    Float32 _FillValue NaN;
    Float32 actual_range 3.301, 27.336;
    String long_name "sigma-T";
    String standard_name "sea_water_sigma_t";
    String units "kg m-3";
  }
  POTM {
    Float32 _FillValue NaN;
    Float32 actual_range 0.848, 19.297;
    String long_name "potential temperature";
    String standard_name "sea_water_potential_temperature";
    String units "degree_C";
  }
  SIGP {
    Float32 _FillValue NaN;
    Float32 actual_range 3.301, 27.34;
    String long_name "Sigma-Theta";
    String standard_name "sea_water_sigma_theta";
    String units "kg m-3";
  }
  FRET {
    Float32 _FillValue NaN;
    Float32 actual_range -2.16, -0.36;
    String long_name "freezing temperature";
    String standard_name "freezing_temperature_of_sea_water";
    String units "degree_C";
  }
  ASAL {
    Float32 _FillValue NaN;
    Float32 actual_range 6.531, 34.996;
    String long_name "absolute salinity";
    String standard_name "sea_water_absolute_salinity";
    String units "g kg-1";
  }
  CONT {
    Float32 _FillValue NaN;
    Float32 actual_range 0.862, 20.117;
    String long_name "conservative temperature";
    String standard_name "sea_water_conservative_temperature";
    String units "degree_C";
  }
  D_CT {
    Float32 _FillValue NaN;
    Float32 actual_range 3.313, 28.863;
    String long_name "TEOS-10 (s, t, p) density";
    String units "kg m-3";
  }
  D0CT {
    Float32 _FillValue NaN;
    Float32 actual_range 3.304, 27.342;
    String long_name "TEOS-10 (s, t, 0) density";
    String units "kg m-3";
  }
  recordID {
    String cf_role "profile_id";
    String long_name "Original filename";
    String units "unitless";
  }
 }
  NC_GLOBAL {
    String Cast_Number "029";
    String cdm_altitude_proxy "PRES";
    String cdm_data_type "Profile";
    String cdm_profile_variables "recordID, longitude, latitude, stationID";
    String contributor_name "Gwénaëlle Chaillou, Pascal Ludovic, Olivier Hérard, Alfonso Mucci, Yves Gélinas";
    String contributor_role "principal investigator, coauthor, coauthor, coauthor, coauthor";
    String Conventions "CF-1.10, COARDS, ACDD-1.3";
    String creator_name "UQAR-ISMER";
    String creator_type "institution";
    String Cruise_Name "2116_HYPOXIE_ST_Laurent";
    String Cruise_Number "2021016";
    String description "CTD data from the Saguenay Fjord and the St. Lawrence Estuary during the NSERC-Hypoxia2021 cruise";
    String DOI "https://doi.org/10.26071/ogsl-77037b6e-c1b8";
    Float64 Easternmost_Easting -65.9967;
    String featureType "Profile";
    Float64 geospatial_lat_max 49.6191;
    Float64 geospatial_lat_min 47.9167;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -65.9967;
    Float64 geospatial_lon_min -70.8598;
    String geospatial_lon_units "degrees_east";
    String history 
"2024-12-20T22:22:04Z (local files)
2024-12-20T22:22:04Z https://erddap.ogsl.ca/erddap/tabledap/uqarIsmerCtdHypoxie.html";
    String infoUrl "https://www.ismer.ca/";
    String institution "Institut des sciences de la mer de Rimouski";
    String keywords "conductivity, CTD, density, depth, fluorescence, oxygen, pressure, salinity, temperature";
    String keywords_fr "CTD, conductivité, densité, fluorescence, oxygène, pression, profondeur, salinité, température";
    String keywords_vocabulary "GCMD Science Keywords";
    String license "Creative Commons Attribution 4.0 International license CC-BY 4.0. Allows for open sharing and adaptation of the data provided that the original creator is attributed";
    String licenseUrl "https://creativecommons.org/licenses/by/4.0/";
    String Max_Depth_m "329.92";
    String Min_Depth_m "2.18";
    Float64 Northernmost_Northing 49.6191;
    String Original_Filename "CTD_2021016_029_1_DN.ODF";
    String platform "research vessel";
    String platform_vocabulary "https://vocab.nerc.ac.uk/collection/L06/current/";
    String publisher_identifier "https://ror.org/03wfagk22";
    String publisher_name "St. Lawrence Global Observatory";
    String publisher_name_fr "Observatoire global du Saint-Laurent";
    String Sounding_m "338.75";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 47.9167;
    String standard_name_vocabulary "CF Standard Name Table v70";
    String subsetVariables "stationID";
    String summary "Données CTD du Fjord du Saguenay et de l'Estuaire du St-Laurent lors de la mission CRSNG-Hypoxie 2021";
    String time_coverage_end "2021-08-30T18:50:17Z";
    String time_coverage_start "2021-08-25T11:47:51Z";
    String title "CTD - Saguenay Fjord and Estuary of St. Lawrence - NSERC-Hypoxia | CTD - Fjord du Saguenay et estuaire du St-Laurent - CRSNG-Hypoxie";
    Float64 Westernmost_Easting -70.8598;
  }
}

 

---

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