ERDDAP > tabledap > Data Access Form

Dataset Title:	Oceanographic Campaigns in the Gaspé Current (1991-1993) - ADCP | Campagnes océanographiques dans le Courant de Gaspé (1991-1993) - ADCP
Institution:	Fisheries and Oceans Canada | Pêches et Océans Canada   (Dataset ID: mpoCourantGaspeAdcp)
Information:	Summary | License | FGDC | ISO 19115 | Metadata | Background | Files | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum	Maximum
id (profile id, unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		"020892-045617-1"	"310792-164041-208"
time (UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		1991-09-21T18:36:45Z	1993-06-11T16:12:45Z
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		49.05263	49.42423
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-66.97703	-65.54583
depth (m)	!= =~ <= >= = < >		!= =~ <= >= = < >		9.2	111.0
roll (degree)	!= =~ <= >= = < >		!= =~ <= >= = < >		-19.84	20.0
pitch (degree)	!= =~ <= >= = < >		!= =~ <= >= = < >		-19.92	10.15
heading (degree)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.02	359.9
temperature (degree_C)	!= =~ <= >= = < >		!= =~ <= >= = < >		3.62	12.24
nb_bins (dimensionless)	!= =~ <= >= = < >		!= =~ <= >= = < >		4	17
x_vel_seafloor (mm s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-2392.0	2516.0
y_vel_seafloor (mm s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-3869.0	3935.0
seafloor_depth (m)	!= =~ <= >= = < >		!= =~ <= >= = < >		6.0	365.0
bin_nb (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		1.0	50.0
x_vel (mm s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-2990	4686
y_vel (mm s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-5066	4965
z_vel (mm s-1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-1464	1202
avg_amp (dimensionless)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	254.0
AVG_SPW (AVG-SPW, dimensionless)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	255.0
PG_GOOD (PG-GOOD, dimensionless)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	100.0
PG_3BS (PG-3 BS, dimensionless)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	100.0
SDEV_1 (SDEV-1, dimensionless)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	3474.0
SDEV_2 (SDEV-2, dimensionless)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	4191.0
SDEV_3 (SDEV-3, dimensionless)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	1171.0

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" id time latitude longitude depth roll pitch heading temperature nb_bins x_vel_seafloor y_vel_seafloor seafloor_depth bin_nb x_vel y_vel z_vel avg_amp AVG_SPW PG_GOOD PG_3BS SDEV_1 SDEV_2 SDEV_3 id time latitude longitude depth roll pitch heading temperature nb_bins x_vel_seafloor y_vel_seafloor seafloor_depth bin_nb x_vel y_vel z_vel avg_amp AVG_SPW PG_GOOD PG_3BS SDEV_1 SDEV_2 SDEV_3 id time latitude longitude depth roll pitch heading temperature nb_bins x_vel_seafloor y_vel_seafloor seafloor_depth bin_nb x_vel y_vel z_vel avg_amp AVG_SPW PG_GOOD PG_3BS SDEV_1 SDEV_2 SDEV_3 id time latitude longitude depth roll pitch heading temperature nb_bins x_vel_seafloor y_vel_seafloor seafloor_depth bin_nb x_vel y_vel z_vel avg_amp AVG_SPW PG_GOOD PG_3BS SDEV_1 SDEV_2 SDEV_3 id time latitude longitude depth roll pitch heading temperature nb_bins x_vel_seafloor y_vel_seafloor seafloor_depth bin_nb x_vel y_vel z_vel avg_amp AVG_SPW PG_GOOD PG_3BS SDEV_1 SDEV_2 SDEV_3 ")

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 {
  id {
    String cf_role "profile_id";
    String long_name "profile id";
    String units "unitless";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 6.85478205e+8, 7.39815165e+8;
    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 _FillValue 30000.0;
    Float32 actual_range 49.05263, 49.42423;
    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 _FillValue 30000.0;
    Float32 actual_range -66.97703, -65.54583;
    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";
  }
  depth {
    String _CoordinateAxisType "Height";
    String _CoordinateZisPositive "down";
    Float32 actual_range 9.2, 111.0;
    String axis "Z";
    String ioos_category "Location";
    String long_name "Depth";
    String positive "down";
    String standard_name "depth";
    String units "m";
  }
  roll {
    Float32 actual_range -19.84, 20.0;
    String long_name "Roll";
    String standard_name "platform_roll";
    String units "degree";
  }
  pitch {
    Float32 actual_range -19.92, 10.15;
    String long_name "Pitch";
    String standard_name "platform_pitch";
    String units "degree";
  }
  heading {
    Float32 actual_range 0.02, 359.9;
    String long_name "Heading";
    String standard_name "platform_orientation";
    String units "degree";
  }
  temperature {
    Float32 actual_range 3.62, 12.24;
    String long_name "Temperature";
    String units "degree_C";
  }
  nb_bins {
    Int32 actual_range 4, 17;
    String long_name "Nb Bins";
    String units "dimensionless";
  }
  x_vel_seafloor {
    Float32 actual_range -2392.0, 2516.0;
    String long_name "X Vel Seafloor";
    String units "mm s-1";
  }
  y_vel_seafloor {
    Float32 actual_range -3869.0, 3935.0;
    String long_name "Y Vel Seafloor";
    String units "mm s-1";
  }
  seafloor_depth {
    Float32 actual_range 6.0, 365.0;
    String long_name "Seafloor Depth";
    String standard_name "sea_floor_depth_below_sea_surface";
    String units "m";
  }
  bin_nb {
    Float32 actual_range 1.0, 50.0;
    String long_name "Bin Nb";
    String units "unitless";
  }
  x_vel {
    Int32 actual_range -2990, 4686;
    String long_name "X Vel";
    String standard_name "eastward_sea_water_velocity";
    String units "mm s-1";
  }
  y_vel {
    Int32 actual_range -5066, 4965;
    String long_name "Y Vel";
    String standard_name "northward_sea_water_velocity";
    String units "mm s-1";
  }
  z_vel {
    Int32 actual_range -1464, 1202;
    String long_name "Z Vel";
    String standard_name "upward_sea_water_velocity";
    String units "mm s-1";
  }
  avg_amp {
    Float32 actual_range 0.0, 254.0;
    String long_name "Avg Amp";
    String units "dimensionless";
  }
  AVG_SPW {
    Float32 actual_range 0.0, 255.0;
    String long_name "AVG-SPW";
    String units "dimensionless";
  }
  PG_GOOD {
    Float32 actual_range 0.0, 100.0;
    String long_name "PG-GOOD";
    String units "dimensionless";
  }
  PG_3BS {
    Float32 actual_range 0.0, 100.0;
    String long_name "PG-3 BS";
    String units "dimensionless";
  }
  SDEV_1 {
    Float32 actual_range 0.0, 3474.0;
    String long_name "SDEV-1";
    String units "dimensionless";
  }
  SDEV_2 {
    Float32 actual_range 0.0, 4191.0;
    String long_name "SDEV-2";
    String units "dimensionless";
  }
  SDEV_3 {
    Float32 actual_range 0.0, 1171.0;
    String long_name "SDEV-3";
    String units "dimensionless";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "Profile";
    String cdm_profile_variables "id, time, longitude, latitude";
    String contributor_institution "Fisheries and Oceans Canada, Institut des Sciences de la Mer de Rimouski UQAR-ISMER, Institut des Sciences de la Mer de Rimouski UQAR-ISMER";
    String contributor_name "Pierre Larouche, Théau Leclercq, Cédric Chavanne";
    String contributor_role "owner, metadata custodian, distributor";
    String Conventions "CF-1.10, COARDS, ACDD-1.3";
    String creator_name "Department of Fisheries and oceans Canada, Institut Maurice-Lamontagne | Pêches et Océans Canada, Institut Maurice-Lamontagne";
    String creator_type "institution";
    String defaultDataQuery "&orderBy(\"time\")";
    String defaultGraphQuery "longitude,latitude,temperature&.marker=11|5";
    String description "ADCP Gaspé currents | ADCP courants de Gaspé";
    String DOI "https://doi.org/10.26071/ogsl-9acdc006-20cb";
    Float64 Easternmost_Easting -65.54583;
    String featureType "Profile";
    Float64 geospatial_lat_max 49.42423;
    Float64 geospatial_lat_min 49.05263;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -65.54583;
    Float64 geospatial_lon_min -66.97703;
    String geospatial_lon_units "degrees_east";
    Float64 geospatial_vertical_max 111.0;
    Float64 geospatial_vertical_min 9.2;
    String geospatial_vertical_positive "down";
    String geospatial_vertical_units "m";
    String history 
"2024-05-04T05:36:54Z (local files)
2024-05-04T05:36:54Z https://erddap.ogsl.ca/erddap/tabledap/mpoCourantGaspeAdcp.html";
    String infoUrl "https://catalogue.ogsl.ca/dataset/ca-cioos_9acdc006-20cb-4c7e-8aae-ca1007cf9b63";
    String institution "Fisheries and Oceans Canada | Pêches et Océans Canada";
    String instrument_type "ADCP";
    String keywords "ADCP, currents, temperature, velocity";
    String keywords_fr "ADCP, température, vitesse, courants";
    String license "Open Government Licence - Canada | Licence du gouvernement ouvert - Canada";
    String licenseUrl "https://open.canada.ca/en/open-government-licence-canada";
    Float64 Northernmost_Northing 49.42423;
    String platform "research vessel";
    String platform_vocabulary "https://vocab.nerc.ac.uk/collection/L06/current/";
    String publisher_email "\"info@ogsl.ca\"";
    String publisher_name "St. Lawrence Global Observatory | Observatoire global du Saint-Laurent";
    String publisherID "https://ror.org/03wfagk22";
    String related_datasets 
"https://erddap.preprod.ogsl.ca/erddap/tabledap/mpoCourantsGaspeCtd.html
        https://erddap.preprod.ogsl.ca/erddap/tabledap/mpoVfinGaspe.html";
    String related_identifiers "https://doi.org/10.1016/j.rsma.2023.103325";
    String related_identifiers_type "Journal article";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 49.05263;
    String standard_name_vocabulary "CF Standard Name Table v70";
    String summary "ADCP data from oceanographic campaigns conducted between 1991 and 1993 (September 1991, May and August 1992, and June 1993). The current data obtained by ADCP (150 kHz transducers for the first expedition, and 600 kHz for the other 3) come from the zone where the speed of the Gaspé current is maximum, and where instabilities are developed (between Les Méchins and Gros-Morne).";
    String summary_fr "Données ADCP des différentes campagnes océanographiques réalisées entre 1991 et 1993 (Septembre 1991, Mai et Août 1992, et Juin 1993). Les données de courants obtenues par ADCP (transducteurs de 150 kHz pour la première expédition, et 600 kHz pour les 3 autres) proviennent de la zone où la vitesse du courant de Gaspé est maximale, et où les instabilités se développent (entre Les Méchins et Gros-Morne).";
    String time_coverage_end "1993-06-11T16:12:45Z";
    String time_coverage_start "1991-09-21T18:36:45Z";
    String title "Oceanographic Campaigns in the Gaspé Current (1991-1993) - ADCP | Campagnes océanographiques dans le Courant de Gaspé (1991-1993) - ADCP";
    Float64 Westernmost_Easting -66.97703;
  }
}

 

---

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