ERDDAP > tabledap > Data Access Form

Dataset Title:	Seawater Carbon Dioxide (CO2) Content from the Burke-o-Lator pCO2/TCO2 analyzer located at the PEARL Lab, Bamfield Marine Sciences Centre, BC, Canada (Research)
Institution:	Hakai Institute   (Dataset ID: HakaiPearlBoLResearch)
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
station_id (Station)	!= =~ <= >= = < >		!= =~ <= >= = < >		"\"PearlBoL\""
Yearday	!= =~ <= >= = < >		!= =~ <= >= = < >		218.84	349.9
Year	!= =~ <= >= = < >		!= =~ <= >= = < >		2025	2025
time (Date Time, UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		2025-08-06T20:11:20Z	2025-12-15T21:36:01Z
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		48.8359	48.8359
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-125.1361	-125.1361
TSG_T (Sea Water Temperature, degC)	!= =~ <= >= = < >		!= =~ <= >= = < >		9.72	20.0
TSG_S (1E-3)	!= =~ <= >= = < >		!= =~ <= >= = < >		14.99	31.97
corrected_xCO2 (ppm)	!= =~ <= >= = < >		!= =~ <= >= = < >		89.77	5113.75
equilibrator_pressure (atm)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.9758	1.0159
SWpCO2_TSG_T (SWpCO2 at TSG Temperature, uatm)	!= =~ <= >= = < >		!= =~ <= >= = < >		192.69	982.41
SWfCO2_TSG_T (SWfCO2 at TSG Temperature, uatm)	!= =~ <= >= = < >		!= =~ <= >= = < >		192.01	978.72
TA (Total Alkalinity, umol/kg)	!= =~ <= >= = < >		!= =~ <= >= = < >		1175.03	2189.47
TCO2 (umol/kg)	!= =~ <= >= = < >		!= =~ <= >= = < >		1149.27	2143.43
pH_T (pH on Total Scale, 1)	!= =~ <= >= = < >		!= =~ <= >= = < >		7.67	8.29
Omega_arag (Aragonite Saturation State)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.45	3.52
Omega_calc (Calcite Saturation State)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.78	5.48

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" station_id Yearday Year time latitude longitude TSG_T TSG_S corrected_xCO2 equilibrator_pressure SWpCO2_TSG_T SWfCO2_TSG_T TA TCO2 pH_T Omega_arag Omega_calc station_id Yearday Year time latitude longitude TSG_T TSG_S corrected_xCO2 equilibrator_pressure SWpCO2_TSG_T SWfCO2_TSG_T TA TCO2 pH_T Omega_arag Omega_calc station_id Yearday Year time latitude longitude TSG_T TSG_S corrected_xCO2 equilibrator_pressure SWpCO2_TSG_T SWfCO2_TSG_T TA TCO2 pH_T Omega_arag Omega_calc station_id Yearday Year time latitude longitude TSG_T TSG_S corrected_xCO2 equilibrator_pressure SWpCO2_TSG_T SWfCO2_TSG_T TA TCO2 pH_T Omega_arag Omega_calc station_id Yearday Year time latitude longitude TSG_T TSG_S corrected_xCO2 equilibrator_pressure SWpCO2_TSG_T SWfCO2_TSG_T TA TCO2 pH_T Omega_arag Omega_calc ")

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). .parquet - Download as a parquet file. Metadata contains column names ("column_names") and units ("column_units"). .parquetWMeta - Download as a parquet file with detailed metadata. .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 {
  station_id {
    String actual_range 
"PearlBoL
PearlBoL";
    String cf_role "timeseries_id";
    String long_name "Station";
  }
  Yearday {
    Float32 actual_range 218.84, 349.9;
    String long_name "Yearday";
  }
  Year {
    Int16 _FillValue 32767;
    Int16 actual_range 2025, 2025;
    String long_name "Year";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.75451108e+9, 1.765834561e+9;
    String axis "T";
    String ioos_category "Time";
    String long_name "Date Time";
    String source_name "date_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";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float32 actual_range 48.8359, 48.8359;
    String axis "Y";
    Float64 colorBarMaximum 90.0;
    Float64 colorBarMinimum -90.0;
    String ioos_category "Location";
    String long_name "Latitude";
    String source_name "Latitude (deg N)";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float32 actual_range -125.1361, -125.1361;
    String axis "X";
    Float64 colorBarMaximum 180.0;
    Float64 colorBarMinimum -180.0;
    String ioos_category "Location";
    String long_name "Longitude";
    String source_name "Longitude (deg E)";
    String standard_name "longitude";
    String units "degrees_east";
  }
  TSG_T {
    Float32 _FillValue NaN;
    Float32 actual_range 9.72, 20.0;
    String long_name "Sea Water Temperature";
    String scale "ITS-90";
    String sensor_description "Seabird SBE45";
    String sensor_type "CTD";
    String standard_name "sea_surface_temperature";
    String units "degC";
  }
  TSG_S {
    Float32 _FillValue NaN;
    Float32 actual_range 14.99, 31.97;
    String long_name "Sea Water Practical Salinity";
    String sensor_description "Seabird SBE45";
    String sensor_type "CTD";
    String standard_name "sea_water_practical_salinity";
    String units "1E-3";
  }
  corrected_xCO2 {
    Float32 _FillValue NaN;
    Float32 actual_range 89.77, 5113.75;
    String long_name "Corrected xCO2";
    String units "ppm";
  }
  equilibrator_pressure {
    Float32 _FillValue NaN;
    Float32 actual_range 0.9758, 1.0159;
    String long_name "Equilibrator Pressure";
    String units "atm";
  }
  SWpCO2_TSG_T {
    Float32 _FillValue NaN;
    Float32 actual_range 192.69, 982.41;
    String long_name "SWpCO2 at TSG Temperature";
    String units "uatm";
  }
  SWfCO2_TSG_T {
    Float32 _FillValue NaN;
    Float32 actual_range 192.01, 978.72;
    String long_name "SWfCO2 at TSG Temperature";
    String units "uatm";
  }
  TA {
    Float32 _FillValue NaN;
    Float32 actual_range 1175.03, 2189.47;
    String description "From Evans et al., 2019 relationship";
    String long_name "Total Alkalinity";
    String units "umol/kg";
  }
  TCO2 {
    Float32 _FillValue NaN;
    Float32 actual_range 1149.27, 2143.43;
    String description "Waters et al constants";
    String long_name "Total Dissolved Inorganic Carbon";
    String units "umol/kg";
  }
  pH_T {
    Float32 _FillValue NaN;
    Float32 actual_range 7.67, 8.29;
    String description "Waters et al constants";
    String long_name "pH on Total Scale";
    String standard_name "sea_water_ph_reported_on_total_scale";
    String units "1";
  }
  Omega_arag {
    Float32 _FillValue NaN;
    Float32 actual_range 0.45, 3.52;
    String description "Waters et al constants";
    String long_name "Aragonite Saturation State";
  }
  Omega_calc {
    Float32 _FillValue NaN;
    Float32 actual_range 0.78, 5.48;
    String description "Waters et al constants";
    String long_name "Calcite Saturation State";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "TimeSeries";
    String cdm_timeseries_variables "station_id, latitude, longitude";
    String comment 
"##Limitations:
None";
    String contributor_email "wiley.evans at hakai.org";
    String contributor_name "Wiley Evans";
    String contributor_role "pointOfContact";
    String Conventions "COARDS, CF-1.6, ACDD-1.3";
    String creator_address "1713 Hyacinthe Bay Road";
    String creator_city "Campbell River";
    String creator_country "Canada";
    String creator_email "wiley.evans@hakai.org";
    String creator_institution "Hakai Institute";
    String creator_name "Evans, Wiley";
    String creator_orcid "https://orcid.org/0000-0002-5450-0903";
    String creator_ror "https://ror.org/02pry0c91";
    String creator_type "person";
    String creator_url "https://www.hakai.org/";
    String date_created "2026-01-29";
    String date_modified "2026-01-29T08:02:31.815Z";
    Float64 Easternmost_Easting -125.1361;
    String featureType "TimeSeries";
    Float64 geospatial_lat_max 48.8359;
    Float64 geospatial_lat_min 48.8359;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -125.1361;
    Float64 geospatial_lon_min -125.1361;
    String geospatial_lon_units "degrees_east";
    String geospatial_vertical_max "1.0";
    String history 
"2026-01-31T10:17:03Z (local files)
2026-01-31T10:17:03Z https://catalogue.hakai.org/erddap/tabledap/HakaiPearlBoLResearch.html";
    String id "TODO_UUID";
    String infoUrl "https://catalogue.hakai.org/dataset/ca-cioos_TODO_UUID";
    String institution "Hakai Institute";
    String instrument "SBE 45,Burke-o-Lator pCO2/TCO2 analyzer";
    String keywords "Bamfield, British Columbia coast, CIOOS:inorganicCarbon, CIOOS:seaSurfaceSalinity, CIOOS:seaSurfaceTemperature, CO2, Continuous measurement, Discrete measurement, North Pacific Ocean, Ocean Acidification, Practical Salinity, Sea Surface Practical Salinity, Sea Surface Temperature, Surface measurement";
    String keywords_vocabulary "CIOOS: CIOOS Essential Ocean Variables Vocabulary";
    String license "https://creativecommons.org/licenses/by/4.0";
    String metadata_form "https://hakaiinstitute.github.io/hakai-metadata-entry-form#/en/hakai/tV5qE0aUgaOjSVmgPgiZ6MyHuSy1/-TODO";
    String metadata_link "https://catalogue.hakai.org/dataset/ca-cioos_TODO_UUID";
    String naming_authority "ca.cioos";
    Float64 Northernmost_Northing 48.8359;
    String platform "coastal structure";
    String platform_vocabulary "https://vocab.nerc.ac.uk/collection/L06/current/";
    String progress "onGoing";
    String project "Oceanography";
    String publisher_city "Campbell River";
    String publisher_country "Canada";
    String publisher_institution "Hakai Institute";
    String publisher_name "Hakai Institute";
    String publisher_ror "https://ror.org/02pry0c91";
    String publisher_type "institution";
    String publisher_url "https://www.hakai.org/";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 48.8359;
    String standard_name_vocabulary "CF Standard Name Table v79";
    String subsetVariables "station_id";
    String summary "This dataset includes continuous sea surface measurements of partial pressure of carbon dioxide (pCO2), sea surface temperature and salinity collected from the PEARL lab at Bamfield Marine Sciences Centre in British Columbia, Canada. Measurements of in situ temperature, salinity, and CO2 partial pressure are made near-continuously on seawater drawn from a sample line. The effort to collect these data are part of the Hakai Institute's directive to advance the understanding of carbon cycling in northeast Pacific coastal settings with specific emphasis on ocean acidification.";
    String time_coverage_end "2025-12-15T21:36:01Z";
    String time_coverage_start "2025-08-06T20:11:20Z";
    String title "Seawater Carbon Dioxide (CO2) Content from the Burke-o-Lator pCO2/TCO2 analyzer located at the PEARL Lab, Bamfield Marine Sciences Centre, BC, Canada (Research)";
    Float64 Westernmost_Easting -125.1361;
  }
}

 

---

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