ERDDAP > tabledap > Data Access Form

Dataset Title:	FORCE Acoustic Doppler Current Profiler (ADCP): Currents
Institution:	FORCE   (Dataset ID: FORCE_Mar2018_ADCP_Currents)
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)	!= =~ <= >= = < >		!= =~ <= >= = < >		2018-03-30T20:02:33Z	2018-05-24T16:02:30Z
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		45.3631	45.3631
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-64.4275	-64.4275
cell_range (m)	!= =~ <= >= = < >		!= =~ <= >= = < >		1.5	50.5
eastward_sea_water_velocity (m/s)	!= =~ <= >= = < >		!= =~ <= >= = < >		-3.567832	4.482457
northward_sea_water_velocity (m/s)	!= =~ <= >= = < >		!= =~ <= >= = < >		-2.754401	1.846157
upward_sea_water_velocity (m/s)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.1332984	0.4035641
speed_of_sound_in_sea_water (m/s)	!= =~ <= >= = < >		!= =~ <= >= = < >		1459.423	1521.361
cell_size (m)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	1.0
cell_count	!= =~ <= >= = < >		!= =~ <= >= = < >		50.0
sea_water_temperature (degree_Celsius)	!= =~ <= >= = < >		!= =~ <= >= = < >		2.19	19.96
sea_water_pressure (dbar)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.5540216929812838	44.52283878138794

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" time latitude longitude cell_range eastward_sea_water_velocity northward_sea_water_velocity upward_sea_water_velocity speed_of_sound_in_sea_water cell_size cell_count sea_water_temperature sea_water_pressure time latitude longitude cell_range eastward_sea_water_velocity northward_sea_water_velocity upward_sea_water_velocity speed_of_sound_in_sea_water cell_size cell_count sea_water_temperature sea_water_pressure time latitude longitude cell_range eastward_sea_water_velocity northward_sea_water_velocity upward_sea_water_velocity speed_of_sound_in_sea_water cell_size cell_count sea_water_temperature sea_water_pressure time latitude longitude cell_range eastward_sea_water_velocity northward_sea_water_velocity upward_sea_water_velocity speed_of_sound_in_sea_water cell_size cell_count sea_water_temperature sea_water_pressure time latitude longitude cell_range eastward_sea_water_velocity northward_sea_water_velocity upward_sea_water_velocity speed_of_sound_in_sea_water cell_size cell_count sea_water_temperature sea_water_pressure ")

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.5224401530010314e+9, 1.5271777500010772e+9;
    String axis "T";
    String calendar "gregorian";
    String description "Time of measurement";
    String force_name "time";
    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 45.3631, 45.3631;
    String axis "Y";
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float64 actual_range -64.4275, -64.4275;
    String axis "X";
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  cell_range {
    Float64 actual_range 1.5, 50.5;
    String force_name "BurstVelocityENU_Range";
    String ioos_category "Unknown";
    String long_name "cell range";
    String units "m";
  }
  eastward_sea_water_velocity {
    Float32 actual_range -3.567832, 4.482457;
    Float64 colorBarMaximum 0.5;
    Float64 colorBarMinimum -0.5;
    String force_name "Vel_East";
    String ioos_category "Currents";
    String long_name "Eastward Sea Water Velocity";
    String standard_name "eastward_sea_water_velocity";
    String units "m/s";
  }
  northward_sea_water_velocity {
    Float32 actual_range -2.754401, 1.846157;
    Float64 colorBarMaximum 0.5;
    Float64 colorBarMinimum -0.5;
    String force_name "Vel_North";
    String ioos_category "Currents";
    String long_name "Northward Sea Water Velocity";
    String standard_name "northward_sea_water_velocity";
    String units "m/s";
  }
  upward_sea_water_velocity {
    Float32 actual_range -0.1332984, 0.4035641;
    Float64 colorBarMaximum 0.5;
    Float64 colorBarMinimum -0.5;
    String force_name "Vel_Up1";
    String ioos_category "Currents";
    String long_name "Upward Sea Water Velocity";
    String standard_name "upward_sea_water_velocity";
    String units "m/s";
  }
  speed_of_sound_in_sea_water {
    Float32 actual_range 1459.423, 1521.361;
    String force_name "SpeedOfSound";
    String ioos_category "Currents";
    String long_name "Speed Of Sound In Sea Water";
    String standard_name "speed_of_sound_in_sea_water";
    String units "m/s";
  }
  cell_size {
    Float32 actual_range 0.0, 1.0;
    String description "Cell Size";
    String force_name "CellSize";
    String ioos_category "Unknown";
    String long_name "cell size";
    String units "m";
  }
  cell_count {
    Float32 actual_range 50.0, 50.0;
    Float64 colorBarMaximum 100.0;
    Float64 colorBarMinimum 0.0;
    String description "Number of cells";
    String force_name "NumberofCells";
    String ioos_category "Statistics";
    String long_name "cell count";
  }
  sea_water_temperature {
    Float32 actual_range 2.19, 19.96;
    Float64 colorBarMaximum 32.0;
    Float64 colorBarMinimum 0.0;
    String force_name "WaterTemperature";
    String ioos_category "Temperature";
    String long_name "Sea Water Temperature";
    String standard_name "sea_water_temperature";
    String units "degree_Celsius";
  }
  sea_water_pressure {
    Float64 actual_range 0.5540216929812838, 44.52283878138794;
    Float64 colorBarMaximum 5000.0;
    Float64 colorBarMinimum 0.0;
    String force_name "Pressure";
    String ioos_category "Pressure";
    String long_name "Sea Water Pressure";
    String standard_name "sea_water_pressure";
    String units "dbar";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "Other";
    String contributor_name "Dr. Joel Culina";
    String contributor_role "custodian";
    String Conventions "CF-1.6, COARDS, ACDD-1.3";
    String creator_email "joel.culina@fundyforce.ca";
    String creator_name "Dr. Joel Culina";
    String creator_type "person";
    String creator_url "https://fundyforce.ca";
    String date_created "2018-03-30";
    Float64 Easternmost_Easting -64.4275;
    Float64 geospatial_lat_max 45.3631;
    Float64 geospatial_lat_min 45.3631;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -64.4275;
    Float64 geospatial_lon_min -64.4275;
    String geospatial_lon_units "degrees_east";
    String history 
"From CIOOS Atlantic atlantic-data-transform repository, ran /opt/provisioning/data-transform/atlantic-data-transform/force/adcp/convert_force_nc.py on 2022-01-13
2024-12-22T03:12:40Z (local files)
2024-12-22T03:12:40Z https://cioosatlantic.ca/erddap/tabledap/FORCE_Mar2018_ADCP_Currents.html";
    String infoUrl "https://fundyforce.ca";
    String institution "FORCE";
    String instrument "100258";
    String keywords "3d velocity profile, acoustic, acoustics, adcp, cell, cell_count, cell_range, cell_size, center, circulation, count, current, currents, data, doppler, earth, Earth Science > Oceans > Ocean Acoustics > Acoustic Velocity, Earth Science > Oceans > Ocean Circulation > Ocean Currents, Earth Science > Oceans > Ocean Pressure > Water Pressure, Earth Science > Oceans > Ocean Temperature > Water Temperature, eastward, eastward_sea_water_velocity, energy, force, fundy, northward, northward_sea_water_velocity, ocean, oceans, oceansound, pressure, profiler, range, research, science, sea, sea_water_pressure, sea_water_temperature, seasurfaceheight, seawater, size, sound, speed, speed of sound, speed_of_sound_in_sea_water, statistics, subsurfacecurrents, subsurfacetemperature, surface wave statistics, temperature, tide height, time, upward, upward_sea_water_velocity, velocity, water";
    String keywords_vocabulary "GCMD Science Keywords";
    String license "https://creativecommons.org/licenses/by/4.0/";
    Float64 Northernmost_Northing 45.3631;
    String publisher_email "joel.culina@fundyforce.ca";
    String publisher_institution "Fundy Ocean Research Center for Energy (FORCE)";
    String publisher_name "Dr. Joel Culina";
    String publisher_type "person";
    String publisher_url "https://fundyforce.ca/";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 45.3631;
    String standard_name_vocabulary "CF Standard Name Table v70";
    String subsetVariables "cell_count";
    String summary "This seabed-mounted Acoustic Doppler Current Profiler (ADCP), deployed for two months in spring 2018, collected 3-D velocity profiles and surface wave statistics at a location within the FORCE Crown Lease Area. Data are provided in raw (*ad2cp) form, and as processed currents and waves. These data were collected as part of a project on evaluating fish sensor capabilities at high flow sites (cf. Viehman et al 2019 in the metadata attachment).";
    String time_coverage_end "2018-05-24T16:02:30Z";
    String time_coverage_start "2018-03-30T20:02:33Z";
    String title "FORCE Acoustic Doppler Current Profiler (ADCP): Currents";
    Float64 Westernmost_Easting -64.4275;
  }
}

 

---

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