ERDDAP > tabledap > Data Access Form

Dataset Title:	Coastal Environmental Baseline Data Program (Maritimes), Port of Saint John region: Conductivity, Temperature, Turbidity and Depth Data (2019-2021) | Programme sur les données environnementales côtières de référence (Maritimes), région du port de Saint John : données de conductivité, température, turbidité et profondeur (2019-2021)
Institution:	DFO-MPO   (Dataset ID: mpoMaritimeStJohnCTD)
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
record_id	!= =~ <= >= = < >		!= =~ <= >= = < >		"MAR-BASE-PHYS-001"	"MAR-BASE-PHYS-060"
site_name	!= =~ <= >= = < >		!= =~ <= >= = < >		"CB_intertidal" "CourtneyBay_intertidal" "HC_HazenEast" "HC_HazenWest" "KR_MathersIsland" "MC_Causeway" "MC_Highway" "MC_Strescon" "ME_EastHeadlands" "ME_FiveFathomHole" "ME_WestHeadlands" "MQ_EastHeadlands" "MQ_Highway" "MW_SaintsRest" "SJR_Evandale" "SJR_HardingsPT" "SJR_Narrows" "SJR_Westfield"
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		45.14568	45.61012
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-66.31979	-66.00832
depth (Site Depth, m)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.5 1.0 2.0 5.0 7.0 10.0 20.0 25.0 30.0 50.0
time (UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		2019-07-24T14:36Z	2021-06-09T15:30Z
sea_water_electrical_conductivity (siemens per meter)	!= =~ <= >= = < >		!= =~ <= >= = < >		-1.648654E-4	4.457286
sea_water_temperature (degree_C)	!= =~ <= >= = < >		!= =~ <= >= = < >		-6.162872	30.41644
sea_water_pressure (dbar)	!= =~ <= >= = < >		!= =~ <= >= = < >		9.505809	63.81448
sea_water_pressure_scaled (dbar)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.6266909	53.68198
sea_floor_depth_below_sea_surface (meters)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.6215804	53.35213
sea_water_practical_salinity (PSU)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.004140562	38.48785
speed_of_sound_in_sea_water (meters per second)	!= =~ <= >= = < >		!= =~ <= >= = < >		-2.64E34	1530.355
sea_water_specific_electrical_conductivity (siemens per meter)	!= =~ <= >= = < >		!= =~ <= >= = < >		-3.453733E-4	5.785261
density_anomaly (kilograms per cubic meter)	!= =~ <= >= = < >		!= =~ <= >= = < >		-3.020234	29.11046
CTD_num	!= =~ <= >= = < >		!= =~ <= >= = < >		201066	205318
sea_water_turbidity (NTU)	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.7496151	2020.839
turbidity_num	!= =~ <= >= = < >		!= =~ <= >= = < >		204045	204064

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" record_id site_name latitude longitude depth time sea_water_electrical_conductivity sea_water_temperature sea_water_pressure sea_water_pressure_scaled sea_floor_depth_below_sea_surface sea_water_practical_salinity speed_of_sound_in_sea_water sea_water_specific_electrical_conductivity density_anomaly CTD_num sea_water_turbidity turbidity_num record_id site_name latitude longitude depth time sea_water_electrical_conductivity sea_water_temperature sea_water_pressure sea_water_pressure_scaled sea_floor_depth_below_sea_surface sea_water_practical_salinity speed_of_sound_in_sea_water sea_water_specific_electrical_conductivity density_anomaly CTD_num sea_water_turbidity turbidity_num record_id site_name latitude longitude depth time sea_water_electrical_conductivity sea_water_temperature sea_water_pressure sea_water_pressure_scaled sea_floor_depth_below_sea_surface sea_water_practical_salinity speed_of_sound_in_sea_water sea_water_specific_electrical_conductivity density_anomaly CTD_num sea_water_turbidity turbidity_num record_id site_name latitude longitude depth time sea_water_electrical_conductivity sea_water_temperature sea_water_pressure sea_water_pressure_scaled sea_floor_depth_below_sea_surface sea_water_practical_salinity speed_of_sound_in_sea_water sea_water_specific_electrical_conductivity density_anomaly CTD_num sea_water_turbidity turbidity_num record_id site_name latitude longitude depth time sea_water_electrical_conductivity sea_water_temperature sea_water_pressure sea_water_pressure_scaled sea_floor_depth_below_sea_surface sea_water_practical_salinity speed_of_sound_in_sea_water sea_water_specific_electrical_conductivity density_anomaly CTD_num sea_water_turbidity turbidity_num ")

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 {
  record_id {
    String long_name "Record Id";
  }
  site_name {
    String cf_role "timeseries_id";
    String long_name "Site Name";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float32 actual_range 45.14568, 45.61012;
    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 actual_range -66.31979, -66.00832;
    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 0.5, 50.0;
    String axis "Z";
    Float64 colorBarMaximum 8000.0;
    Float64 colorBarMinimum -8000.0;
    String colorBarPalette "TopographyDepth";
    String description "Depth of the instrument manually entered.";
    String ioos_category "Location";
    String long_name "Site Depth";
    String positive "down";
    String standard_name "depth";
    String units "m";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.56397896e+9, 1.6232526e+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 time_precision "1970-01-01T00:00Z";
    String units "seconds since 1970-01-01T00:00:00Z";
  }
  sea_water_electrical_conductivity {
    Float32 actual_range -1.648654e-4, 4.457286;
    Float64 colorBarMaximum 40.0;
    Float64 colorBarMinimum 30.0;
    String long_name "Sea Water Electrical Conductivity";
    String standard_name "sea_water_electrical_conductivity";
    String units "siemens per meter";
  }
  sea_water_temperature {
    Float32 actual_range -6.162872, 30.41644;
    Float64 colorBarMaximum 32.0;
    Float64 colorBarMinimum 0.0;
    String long_name "Sea Water Temperature";
    String standard_name "sea_water_temperature";
    String units "degree_C";
  }
  sea_water_pressure {
    Float32 actual_range 9.505809, 63.81448;
    Float64 colorBarMaximum 5000.0;
    Float64 colorBarMinimum 0.0;
    String long_name "Sea Water Pressure";
    String standard_name "sea_water_pressure";
    String units "dbar";
  }
  sea_water_pressure_scaled {
    Float32 actual_range -0.6266909, 53.68198;
    String long_name "Sea Water Pressure Scaled";
    String units "dbar";
  }
  sea_floor_depth_below_sea_surface {
    Float32 actual_range -0.6215804, 53.35213;
    Float64 colorBarMaximum 8000.0;
    Float64 colorBarMinimum -8000.0;
    String colorBarPalette "TopographyDepth";
    String long_name "Sea Floor Depth Below Sea Surface";
    String standard_name "sea_floor_depth_below_sea_surface";
    String units "meters";
  }
  sea_water_practical_salinity {
    Float32 actual_range -0.004140562, 38.48785;
    Float64 colorBarMaximum 37.0;
    Float64 colorBarMinimum 32.0;
    String long_name "Sea Water Practical Salinity";
    String standard_name "sea_water_practical_salinity";
    String units "PSU";
  }
  speed_of_sound_in_sea_water {
    Float32 actual_range -2.64e+34, 1530.355;
    String long_name "Speed Of Sound In Sea Water";
    String standard_name "speed_of_sound_in_sea_water";
    String units "meters per second";
  }
  sea_water_specific_electrical_conductivity {
    Float32 actual_range -3.453733e-4, 5.785261;
    Float64 colorBarMaximum 40.0;
    Float64 colorBarMinimum 30.0;
    String long_name "Sea Water Electrical Conductivity";
    String standard_name "sea_water_electrical_conductivity";
    String units "siemens per meter";
  }
  density_anomaly {
    Float32 _FillValue NaN;
    Float32 actual_range -3.020234, 29.11046;
    Float64 colorBarMaximum 10.0;
    Float64 colorBarMinimum -10.0;
    String long_name "Density Anomaly";
    String units "kilograms per cubic meter";
  }
  CTD_num {
    Int32 _FillValue 2147483647;
    Int32 actual_range 201066, 205318;
    String long_name "CTD Num";
  }
  sea_water_turbidity {
    Float32 _FillValue NaN;
    Float32 actual_range -0.7496151, 2020.839;
    String long_name "Sea Water Turbidity";
    String units "NTU";
  }
  turbidity_num {
    Int32 _FillValue 2147483647;
    Int32 actual_range 204045, 204064;
    String long_name "Turbidity Num";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "TimeSeries";
    String cdm_timeseries_variables "site_name,latitude,longitude";
    String contributor_name "Casey O'Laughlin,DFO-MPO";
    String contributor_role "custodian,owner";
    String Conventions "COARDS, CF-1.6, ACDD-1.3, NCCSV-1.1";
    String creator_name "Fisheries and Oceans Canada";
    String creator_type "institution";
    String date_created "2019-07-24/2020-07-24";
    String defaultDataQuery "&orderBy(\"time\")";
    String DOI "https://doi.org/10.26071/ogsl-2aa37551-6054";
    Float64 Easternmost_Easting -66.00832;
    String featureType "TimeSeries";
    Float64 geospatial_lat_max 45.61012;
    Float64 geospatial_lat_min 45.14568;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -66.00832;
    Float64 geospatial_lon_min -66.31979;
    String geospatial_lon_units "degrees_east";
    Float64 geospatial_vertical_max 50.0;
    Float64 geospatial_vertical_min 0.5;
    String geospatial_vertical_positive "down";
    String geospatial_vertical_units "m";
    String history 
"2024-04-24T14:55:31Z (local files)
2024-04-24T14:55:31Z https://erddap.ogsl.ca/erddap/tabledap/mpoMaritimeStJohnCTD.html";
    String infoUrl "https://catalogue.ogsl.ca/en/dataset/ca-cioos_2aa37551-6054-439e-8685-06e4f3c20c00";
    String institution "DFO-MPO";
    String instrument "RBR Concerto3";
    String keywords "coastal characterization, coastal zone, natural environments of interest, pressure, Saint John river, salinity, seaSurfaceSalinity, seaSurfaceTemperature, speedOfSound, subSurfaceSalinity, subSurfaceTemperature, water temperature";
    String keywords_vocabulary "GCMD Science Keywords";
    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 45.61012;
    String platform "float";
    String platform_vocabulary "https://vocab.nerc.ac.uk/collection/L06/current/";
    String publisher_email "info at ogsl.ca";
    String publisher_name "St. Lawrence Global Observatory | Observatoire global du Saint-Laurent";
    String publisherId "https://ror.org/03wfagk22";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 45.14568;
    String standard_name_vocabulary "CF Standard Name Table v55";
    String subsetVariables "site_name, depth";
    String summary 
"The Coastal Environmental Baseline Program is a multi-year Fisheries and Oceans Canada initiative designed to work with Indigenous and local communities and other key parties to collect coastal environmental data at six pilot sites across Canada (Port of Vancouver, Port of Prince Rupert, Lower St. Lawrence Estuary, Port of Saint John, Placentia Bay, and Iqaluit). The goal of the Program is to gather local information in these areas in effort to build a better understanding of marine ecological conditions. The Maritimes region has developed a physical oceanography program to align with the oceanographic interests and data needs of local communities and stakeholders, with the goal of sharing this information via open data. 
            Starting in 2019, oceanographic parameters including temperature, salinity, depth, turbidity and currents have been continuously monitored at a series of locations covering a broad range of environments in the Port of Saint John and approaches vicinity, including the lower Saint John and Kennebecasis rivers, coastal fringe marshes and embayments, as well as the Musquash estuary Marine Protected Area (MPA). This dataset includes CTD data from August 2019 to July 2020 and CTD and turbidity data from August 2020 to June 2021. 
            Data collection methods range from bottom-mounted instruments in water depths of 10-50 meters, buoyant surface moorings, and hard-mounted instruments in intertidal zones. Intertidal data is interrupted during some low tide events, where the water level drops below the sensor, resulting in loss of functionality for periods up to 1-2 hours. Overall this dataset captures a dynamic balance between salt and fresh water on the highly tidal lower Saint John river, coastal seasonal dynamics in near-shore marine environments in the Musquash MPA, and the constant fluctuations of intertidal creeks and marshes. 
            Le Programme de référence sur l'environnement côtier est une initiative pluriannuelle de Pêches et Océans Canada conçue pour travailler avec les communautés autochtones et locales et d'autres parties clés pour recueillir des données environnementales côtières sur six sites pilotes à travers le Canada (port de Vancouver, port de Prince Rupert, Lower St Saint-Laurent, port de Saint John, baie Placentia et Iqaluit). L'objectif du programme est de recueillir des informations locales dans ces zones afin de mieux comprendre les conditions écologiques marines. La région des Maritimes a élaboré un programme d'océanographie physique pour s'aligner sur les intérêts océanographiques et les besoins en données des communautés locales et des intervenants, dans le but de partager ces informations via des données ouvertes.  
            À partir de 2019, les paramètres océanographiques, y compris la température, la salinité, la profondeur, la turbidité et les courants, ont fait l'objet d'une surveillance continue dans une série d'endroits couvrant un large éventail d'environnements dans le port de Saint John et aux abords des environs, y compris le cours inférieur des rivières Saint John et Kennebecasis, les marais et les bassins côtiers, ainsi que la zone de protection marine (ZPM) de l'estuaire de la Musquash. Ce jeu de données comprend des données CTD d'août 2019 à juillet 2020 et des données CTD et de turbidité d'août 2020 à juin 2021. 
            Les méthodes de collecte des données vont des instruments montés sur le fond dans des profondeurs d'eau de 10 à 50 mètres, des mouillages flottants en surface et des instruments montés en dur dans les zones intertidales. Les données intertidales sont interrompues lors de certains événements de marée basse, lorsque le niveau de l'eau chute sous le capteur, ce qui entraîne une perte de fonctionnalité pendant des périodes allant de 1 à 2 heures. Dans l'ensemble, ces données capture un équilibre dynamique entre l'eau salée et l'eau douce dans le cours inférieur du fleuve Saint-Jean à forte marée, la dynamique saisonnière côtière dans les environnements marins près du rivage dans la ZPM de Musquash et les fluctuations constantes des ruisseaux et des marais intertidaux.";
    String time_coverage_end "2021-06-09T15:30Z";
    String time_coverage_start "2019-07-24T14:36Z";
    String title "Coastal Environmental Baseline Data Program (Maritimes), Port of Saint John region: Conductivity, Temperature, Turbidity and Depth Data (2019-2021) | Programme sur les données environnementales côtières de référence (Maritimes), région du port de Saint John : données de conductivité, température, turbidité et profondeur (2019-2021)";
    Float64 Westernmost_Easting -66.31979;
  }
}

 

---

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