ERDDAP > tabledap > Data Access Form

Dataset Title:	AFBI Compass Strangford Lough North Mooring
Institution:	Agri-Food Biosciences Institute   (Dataset ID: afbi_sl03_sc)
Information:	Summary | License | FGDC | ISO 19115 | Metadata | Background | Subset | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum    or a List of Values	Maximum
time (Timestamp, UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		2017-09-22T00:00:00Z	2020-01-06T23:40:00Z
year	!= =~ <= >= = < >		!= =~ <= >= = < >		2017.0 2018.0 2019.0 2020.0
unixtimestamp	!= =~ <= >= = < >		!= =~ <= >= = < >		1.5060384E9	1.578354E9
a_date (Date)	!= =~ <= >= = < >		!= =~ <= >= = < >		"2017-09-22"	"2020-01-06"
a_time (Time)	!= =~ <= >= = < >		!= =~ <= >= = < >		"00:00:00"	"23:40:00"
temp_c	!= =~ <= >= = < >		!= =~ <= >= = < >		-99.99	20.84
spcond_ms_cm	!= =~ <= >= = < >		!= =~ <= >= = < >		-99.99	52.16
cond_ms_cm	!= =~ <= >= = < >		!= =~ <= >= = < >		-99.99	47.04
sal_psu	!= =~ <= >= = < >		!= =~ <= >= = < >		-99.99	34.4
depth_meters (Depth)	!= =~ <= >= = < >		!= =~ <= >= = < >		-99.99	1.18
turbidity_ntu	!= =~ <= >= = < >		!= =~ <= >= = < >		-99.99	5601.54
chlorophyll_ug_l	!= =~ <= >= = < >		!= =~ <= >= = < >		-99.99	568.19
fluorecence_pct_fs	!= =~ <= >= = < >		!= =~ <= >= = < >		-99.99	140.13
pctplus_pct	!= =~ <= >= = < >		!= =~ <= >= = < >		-99.99	138.42
concplus_mg_l	!= =~ <= >= = < >		!= =~ <= >= = < >		-99.99	14.55
systembattery	!= =~ <= >= = < >		!= =~ <= >= = < >		5.41	14.25
bgape_rfu	!= =~ <= >= = < >		!= =~ <= >= = < >		0.02	1.66
bgape_ug_l	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.03	4.87
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		54.525	54.525
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-5.635	-5.635

 

Server-side Functions

distinct()

orderBy orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean (" time year unixtimestamp a_date a_time temp_c spcond_ms_cm cond_ms_cm sal_psu depth_meters turbidity_ntu chlorophyll_ug_l fluorecence_pct_fs pctplus_pct concplus_mg_l systembattery bgape_rfu bgape_ug_l latitude longitude time year unixtimestamp a_date a_time temp_c spcond_ms_cm cond_ms_cm sal_psu depth_meters turbidity_ntu chlorophyll_ug_l fluorecence_pct_fs pctplus_pct concplus_mg_l systembattery bgape_rfu bgape_ug_l latitude longitude time year unixtimestamp a_date a_time temp_c spcond_ms_cm cond_ms_cm sal_psu depth_meters turbidity_ntu chlorophyll_ug_l fluorecence_pct_fs pctplus_pct concplus_mg_l systembattery bgape_rfu bgape_ug_l latitude longitude time year unixtimestamp a_date a_time temp_c spcond_ms_cm cond_ms_cm sal_psu depth_meters turbidity_ntu chlorophyll_ug_l fluorecence_pct_fs pctplus_pct concplus_mg_l systembattery bgape_rfu bgape_ug_l latitude longitude time year unixtimestamp a_date a_time temp_c spcond_ms_cm cond_ms_cm sal_psu depth_meters turbidity_ntu chlorophyll_ug_l fluorecence_pct_fs pctplus_pct concplus_mg_l systembattery bgape_rfu bgape_ug_l latitude longitude ")

File type: (more info) .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.5060384e+9, 1.578354e+9;
    String axis "T";
    String ioos_category "Time";
    String long_name "Timestamp";
    String source_name "timestamp";
    String standard_name "time";
    String time_origin "01-JAN-1970 00:00:00";
    String units "seconds since 1970-01-01T00:00:00Z";
  }
  year {
    Float64 actual_range 2017.0, 2020.0;
    String ioos_category "Time";
    String long_name "Year";
  }
  unixtimestamp {
    Float64 actual_range 1.5060384e+9, 1.578354e+9;
    String ioos_category "Time";
    String long_name "Unix Timestamp";
  }
  a_date {
    String ioos_category "Time";
    String long_name "Date";
  }
  a_time {
    String ioos_category "Time";
    String long_name "Time";
  }
  temp_c {
    Float64 actual_range -99.99, 20.84;
    String ioos_category "Temperature";
    String long_name "Temp C";
  }
  spcond_ms_cm {
    Float64 actual_range -99.99, 52.16;
    String ioos_category "Unknown";
    String long_name "Sp Cond M S Cm";
  }
  cond_ms_cm {
    Float64 actual_range -99.99, 47.04;
    String ioos_category "Unknown";
    String long_name "Cond M S Cm";
  }
  sal_psu {
    Float64 actual_range -99.99, 34.4;
    String ioos_category "Salinity";
    String long_name "Sal Psu";
    Float64 missing_value NaN;
  }
  depth_meters {
    Float64 actual_range -99.99, 1.18;
    Float64 colorBarMaximum 8000.0;
    Float64 colorBarMinimum -8000.0;
    String colorBarPalette "TopographyDepth";
    String ioos_category "Location";
    String long_name "Depth";
    Float64 missing_value NaN;
    String standard_name "depth";
  }
  turbidity_ntu {
    Float64 actual_range -99.99, 5601.54;
    String ioos_category "Unknown";
    String long_name "Turbidity NTU";
    Float64 missing_value NaN;
  }
  chlorophyll_ug_l {
    Float64 actual_range -99.99, 568.19;
    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";
    Float64 missing_value NaN;
    String standard_name "concentration_of_chlorophyll_in_sea_water";
  }
  fluorecence_pct_fs {
    Float64 actual_range -99.99, 140.13;
    String ioos_category "Optical Properties";
    String long_name "Fluorecence Pct FS";
    Float64 missing_value NaN;
  }
  pctplus_pct {
    Float64 actual_range -99.99, 138.42;
    String ioos_category "Unknown";
    String long_name "Pctplus Pct";
    Float64 missing_value NaN;
  }
  concplus_mg_l {
    Float64 actual_range -99.99, 14.55;
    String ioos_category "Unknown";
    String long_name "Concplus Mg L";
    Float64 missing_value NaN;
  }
  systembattery {
    Float64 actual_range 5.41, 14.25;
    String ioos_category "Unknown";
    String long_name "System Battery";
  }
  bgape_rfu {
    Float64 actual_range 0.02, 1.66;
    String ioos_category "Unknown";
    String long_name "BGAPE RFU";
  }
  bgape_ug_l {
    Float64 actual_range -0.03, 4.87;
    String ioos_category "Unknown";
    String long_name "BGAPE Ug L";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 actual_range 54.525, 54.525;
    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";
    Float64 actual_range -5.635, -5.635;
    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";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "Point";
    String Conventions "COARDS, CF-1.6, ACDD-1.3";
    String creator_name "Agri-Food Biosciences Institute";
    String creator_url "https://compass-oceanscience.eu/";
    Float64 Easternmost_Easting -5.635;
    String featureType "Point";
    Float64 geospatial_lat_max 54.525;
    Float64 geospatial_lat_min 54.525;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -5.635;
    Float64 geospatial_lon_min -5.635;
    String geospatial_lon_units "degrees_east";
    String history 
"2021-08-31T15:07:45Z (source database)
2021-08-31T15:07:45Z http://10.11.1.82/erddap/tabledap/afbi_sl03_sc.nc?time%2Cyear%2Cunixtimestamp%2Ca_date%2Ca_time%2Ctemp_c%2Cspcond_ms_cm%2Ccond_ms_cm%2Csal_psu%2Cdepth_meters%2Cturbidity_ntu%2Cchlorophyll_ug_l%2Cfluorecence_pct_fs%2Cpctplus_pct%2Cconcplus_mg_l%2Csystembattery%2Cbgape_rfu%2Cbgape_ug_l%2Clatitude%2Clongitude
2024-11-23T23:11:39Z (local files)
2024-11-23T23:11:39Z http://erddap.digitalocean.ie/erddap/tabledap/afbi_sl03_sc.html";
    String id "afbi_sl03_sc";
    String infoUrl "https://compass-oceanscience.eu/";
    String institution "Agri-Food Biosciences Institute";
    String keywords "a_date, a_time, afbi, agri, agri-food, altimetry, battery, bgape, bgape_rfu, bgape_ug_l, biosciences, chemistry, chlorophyll, chlorophyll_ug_l, color, compass, concentration, concentration_of_chlorophyll_in_sea_water, concplus, concplus_mg_l, cond, cond_ms_cm, data, date, depth, depth_meters, earth, Earth Science > Oceans > Ocean Chemistry > Chlorophyll, fluorecence, fluorecence_pct_fs, food, institute, laboratory, latitude, longitude, lough, mooring, nephelometric, north, ntu, ocean, ocean color, oceans, optical, optical properties, pct, pctplus, pctplus_pct, practical, properties, psu, rfu, row, sal, sal_psu, salinity, satellite, science, sea, seawater, spcond_ms_cm, strangford, system, systembattery, temp_c, temperature, time, timestamp, turbidity, turbidity_ntu, unit, units, unix, unixtimestamp, water, year";
    String keywords_vocabulary "GCMD Science Keywords";
    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.";
    Float64 Northernmost_Northing 54.525;
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 54.525;
    String standard_name_vocabulary "CF Standard Name Table v55";
    String subsetVariables "year";
    String summary "2017 - 2020 Data from Strangford Lough North Mooring";
    String time_coverage_end "2020-01-06T23:40:00Z";
    String time_coverage_start "2017-09-22T00:00:00Z";
    String title "AFBI Compass Strangford Lough North Mooring";
    Float64 Westernmost_Easting -5.635;
  }
}

 

---

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