ERDDAP > tabledap > Data Access Form

Dataset Title:	[Weekly Surface Water Samples] - Weekly surface water samples from Newport Pier, CA collected between 11 January 2012 and 3 November 2023 (Biological Controls on the Ocean C:N:P ratios)
Institution:	BCO-DMO   (Dataset ID: bcodmo_dataset_564351_v3)
Information:	Summary | License | Metadata | Background | Files | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum	Maximum
Date (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		"2012-01-11"	"2023-11-03"
NO3_1 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.527	14.688
NO3_2 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		-3.091	20.026
NO3_3 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.361	20.836
NO3_4 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.152	19.289
NO3_5 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.027	19.344
NO3_6 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.085	20.099
NO3_Avg (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.215	19.919
SRP_1 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.052	2.882
SRP_2 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.036	0.821
SRP_3 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.017	1.175
SRP_4 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.145	2.57
SRP_5 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.11	1.98
SRP_6 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.145	2.375
SRP_Avg (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.1	2.445
POP_1 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.001	1.21833702E9
POP_2 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.001	2.173
POP_3 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.008	1.69
POP_4 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.045	1.383
POP_5 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.026	1.207
POP_6 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.033	1.038
POP_Avg (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.056	2.03056192E8
PON_1 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.117	48.424
PON_2 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.134	67.315
PON_3 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.134	26.442
PON_4 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.122	30.161
PON_5 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.053	22.758
PON_6 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	24.933
PON_Avg (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.678	31.755
POC_1 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		3.033	267.584
POC_2 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		3.778	263.728
POC_3 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		2.459	195.279
POC_4 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		2.459	190.317
POC_5 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.278	186.024
POC_6 (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		2.459186	259.3793
POC_Avg (micromolar (uM))	!= =~ <= >= = < >		!= =~ <= >= = < >		9.899	197.74
Temp (Degrees Celsius (deg C))	!= =~ <= >= = < >		!= =~ <= >= = < >		10.968	38.825
Chlorophyll (Practical Salinity Units (PSU))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.058	87.058
Salinity (micrograms per liter (ug/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		8.467	34.19
picoeuk_ml (cells per milliliter (cells/ml))	!= =~ <= >= = < >		!= =~ <= >= = < >		442.07	154233.8
PNEconc_ml (cells per milliliter (cells/ml))	!= =~ <= >= = < >		!= =~ <= >= = < >		1035.86	159796.4
Proconc_ml (cells per milliliter (cells/ml))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	103402.2
Synconc_ml (cells per milliliter (cells/ml))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	211603.4
JGI_DOI (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		"10.46936/10.25585/..."	"10.46936/10.25585/..."
JGI_Project_Name (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		"Newport_SRmetag_12..."	"Newport_SRmetag_20..."
JGI_Sequencing_Project_ID (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		1308779	1309331
JGI_Library_Name (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		"HNZWB"	"HXUWS"
JGI_Project_ID (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		1308614	1309264
NCBI_BioSample (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		"SAMN41925147"	"SAMN41925177"

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" Date NO3_1 NO3_2 NO3_3 NO3_4 NO3_5 NO3_6 NO3_Avg SRP_1 SRP_2 SRP_3 SRP_4 SRP_5 SRP_6 SRP_Avg POP_1 POP_2 POP_3 POP_4 POP_5 POP_6 POP_Avg PON_1 PON_2 PON_3 PON_4 PON_5 PON_6 PON_Avg POC_1 POC_2 POC_3 POC_4 POC_5 POC_6 POC_Avg Temp Chlorophyll Salinity picoeuk_ml PNEconc_ml Proconc_ml Synconc_ml JGI_DOI JGI_Project_Name JGI_Sequencing_Project_ID JGI_Library_Name JGI_Project_ID NCBI_BioSample Date NO3_1 NO3_2 NO3_3 NO3_4 NO3_5 NO3_6 NO3_Avg SRP_1 SRP_2 SRP_3 SRP_4 SRP_5 SRP_6 SRP_Avg POP_1 POP_2 POP_3 POP_4 POP_5 POP_6 POP_Avg PON_1 PON_2 PON_3 PON_4 PON_5 PON_6 PON_Avg POC_1 POC_2 POC_3 POC_4 POC_5 POC_6 POC_Avg Temp Chlorophyll Salinity picoeuk_ml PNEconc_ml Proconc_ml Synconc_ml JGI_DOI JGI_Project_Name JGI_Sequencing_Project_ID JGI_Library_Name JGI_Project_ID NCBI_BioSample Date NO3_1 NO3_2 NO3_3 NO3_4 NO3_5 NO3_6 NO3_Avg SRP_1 SRP_2 SRP_3 SRP_4 SRP_5 SRP_6 SRP_Avg POP_1 POP_2 POP_3 POP_4 POP_5 POP_6 POP_Avg PON_1 PON_2 PON_3 PON_4 PON_5 PON_6 PON_Avg POC_1 POC_2 POC_3 POC_4 POC_5 POC_6 POC_Avg Temp Chlorophyll Salinity picoeuk_ml PNEconc_ml Proconc_ml Synconc_ml JGI_DOI JGI_Project_Name JGI_Sequencing_Project_ID JGI_Library_Name JGI_Project_ID NCBI_BioSample Date NO3_1 NO3_2 NO3_3 NO3_4 NO3_5 NO3_6 NO3_Avg SRP_1 SRP_2 SRP_3 SRP_4 SRP_5 SRP_6 SRP_Avg POP_1 POP_2 POP_3 POP_4 POP_5 POP_6 POP_Avg PON_1 PON_2 PON_3 PON_4 PON_5 PON_6 PON_Avg POC_1 POC_2 POC_3 POC_4 POC_5 POC_6 POC_Avg Temp Chlorophyll Salinity picoeuk_ml PNEconc_ml Proconc_ml Synconc_ml JGI_DOI JGI_Project_Name JGI_Sequencing_Project_ID JGI_Library_Name JGI_Project_ID NCBI_BioSample Date NO3_1 NO3_2 NO3_3 NO3_4 NO3_5 NO3_6 NO3_Avg SRP_1 SRP_2 SRP_3 SRP_4 SRP_5 SRP_6 SRP_Avg POP_1 POP_2 POP_3 POP_4 POP_5 POP_6 POP_Avg PON_1 PON_2 PON_3 PON_4 PON_5 PON_6 PON_Avg POC_1 POC_2 POC_3 POC_4 POC_5 POC_6 POC_Avg Temp Chlorophyll Salinity picoeuk_ml PNEconc_ml Proconc_ml Synconc_ml JGI_DOI JGI_Project_Name JGI_Sequencing_Project_ID JGI_Library_Name JGI_Project_ID NCBI_BioSample ")

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 {
  Date {
    String long_name "Date";
    String units "unitless";
  }
  NO3_1 {
    Float32 actual_range -0.527, 14.688;
    String long_name "No3_1";
    String units "micromolar (uM)";
  }
  NO3_2 {
    Float32 actual_range -3.091, 20.026;
    String long_name "No3_2";
    String units "micromolar (uM)";
  }
  NO3_3 {
    Float32 actual_range -0.361, 20.836;
    String long_name "No3_3";
    String units "micromolar (uM)";
  }
  NO3_4 {
    Float32 actual_range -0.152, 19.289;
    String long_name "No3_4";
    String units "micromolar (uM)";
  }
  NO3_5 {
    Float32 actual_range -0.027, 19.344;
    String long_name "No3_5";
    String units "micromolar (uM)";
  }
  NO3_6 {
    Float32 actual_range 0.085, 20.099;
    String long_name "No3_6";
    String units "micromolar (uM)";
  }
  NO3_Avg {
    Float32 actual_range -0.215, 19.919;
    String long_name "No3_avg";
    String units "micromolar (uM)";
  }
  SRP_1 {
    Float32 actual_range 0.052, 2.882;
    String long_name "Srp_1";
    String units "micromolar (uM)";
  }
  SRP_2 {
    Float32 actual_range 0.036, 0.821;
    String long_name "Srp_2";
    String units "micromolar (uM)";
  }
  SRP_3 {
    Float32 actual_range -0.017, 1.175;
    String long_name "Srp_3";
    String units "micromolar (uM)";
  }
  SRP_4 {
    Float32 actual_range 0.145, 2.57;
    String long_name "Srp_4";
    String units "micromolar (uM)";
  }
  SRP_5 {
    Float32 actual_range 0.11, 1.98;
    String long_name "Srp_5";
    String units "micromolar (uM)";
  }
  SRP_6 {
    Float32 actual_range 0.145, 2.375;
    String long_name "Srp_6";
    String units "micromolar (uM)";
  }
  SRP_Avg {
    Float32 actual_range 0.1, 2.445;
    String long_name "Srp_avg";
    String units "micromolar (uM)";
  }
  POP_1 {
    Float32 actual_range 0.001, 1.21833702e+9;
    String long_name "Pop_1";
    String units "micromolar (uM)";
  }
  POP_2 {
    Float32 actual_range 0.001, 2.173;
    String long_name "Pop_2";
    String units "micromolar (uM)";
  }
  POP_3 {
    Float32 actual_range 0.008, 1.69;
    String long_name "Pop_3";
    String units "micromolar (uM)";
  }
  POP_4 {
    Float32 actual_range 0.045, 1.383;
    String long_name "Pop_4";
    String units "micromolar (uM)";
  }
  POP_5 {
    Float32 actual_range 0.026, 1.207;
    String long_name "Pop_5";
    String units "micromolar (uM)";
  }
  POP_6 {
    Float32 actual_range 0.033, 1.038;
    String long_name "Pop_6";
    String units "micromolar (uM)";
  }
  POP_Avg {
    Float32 actual_range 0.056, 2.03056192e+8;
    String long_name "Pop_avg";
    String units "micromolar (uM)";
  }
  PON_1 {
    Float32 actual_range 0.117, 48.424;
    String long_name "Pon_1";
    String units "micromolar (uM)";
  }
  PON_2 {
    Float32 actual_range 0.134, 67.315;
    String long_name "Pon_2";
    String units "micromolar (uM)";
  }
  PON_3 {
    Float32 actual_range 0.134, 26.442;
    String long_name "Pon_3";
    String units "micromolar (uM)";
  }
  PON_4 {
    Float32 actual_range 0.122, 30.161;
    String long_name "Pon_4";
    String units "micromolar (uM)";
  }
  PON_5 {
    Float32 actual_range 0.053, 22.758;
    String long_name "Pon_5";
    String units "micromolar (uM)";
  }
  PON_6 {
    Float32 actual_range 0.0, 24.933;
    String long_name "Pon_6";
    String units "micromolar (uM)";
  }
  PON_Avg {
    Float32 actual_range 0.678, 31.755;
    String long_name "Pon_avg";
    String units "micromolar (uM)";
  }
  POC_1 {
    Float32 actual_range 3.033, 267.584;
    String long_name "Poc_1";
    String units "micromolar (uM)";
  }
  POC_2 {
    Float32 actual_range 3.778, 263.728;
    String long_name "Poc_2";
    String units "micromolar (uM)";
  }
  POC_3 {
    Float32 actual_range 2.459, 195.279;
    String long_name "Poc_3";
    String units "micromolar (uM)";
  }
  POC_4 {
    Float32 actual_range 2.459, 190.317;
    String long_name "Poc_4";
    String units "micromolar (uM)";
  }
  POC_5 {
    Float32 actual_range 0.278, 186.024;
    String long_name "Poc_5";
    String units "micromolar (uM)";
  }
  POC_6 {
    Float32 actual_range 2.459186, 259.3793;
    String long_name "Poc_6";
    String units "micromolar (uM)";
  }
  POC_Avg {
    Float32 actual_range 9.899, 197.74;
    String long_name "Poc_avg";
    String units "micromolar (uM)";
  }
  Temp {
    Float32 actual_range 10.968, 38.825;
    String long_name "Temp";
    String units "Degrees Celsius (deg C)";
  }
  Chlorophyll {
    Float32 actual_range 0.058, 87.058;
    String long_name "Chlorophyll";
    String units "Practical Salinity Units (PSU)";
  }
  Salinity {
    Float32 actual_range 8.467, 34.19;
    String long_name "Salinity";
    String units "micrograms per liter (ug/L)";
  }
  picoeuk_ml {
    Float32 actual_range 442.07, 154233.8;
    String long_name "Picoeuk_ml";
    String units "cells per milliliter (cells/ml)";
  }
  PNEconc_ml {
    Float32 actual_range 1035.86, 159796.4;
    String long_name "Pneconc_ml";
    String units "cells per milliliter (cells/ml)";
  }
  Proconc_ml {
    Float32 actual_range 0.0, 103402.2;
    String long_name "Proconc_ml";
    String units "cells per milliliter (cells/ml)";
  }
  Synconc_ml {
    Float32 actual_range 0.0, 211603.4;
    String long_name "Synconc_ml";
    String units "cells per milliliter (cells/ml)";
  }
  JGI_DOI {
    String long_name "Jgi_doi";
    String units "unitless";
  }
  JGI_Project_Name {
    String long_name "Jgi_project_name";
    String units "unitless";
  }
  JGI_Sequencing_Project_ID {
    Int32 actual_range 1308779, 1309331;
    String long_name "Jgi_sequencing_project_id";
    String units "unitless";
  }
  JGI_Library_Name {
    String long_name "Jgi_library_name";
    String units "unitless";
  }
  JGI_Project_ID {
    Int32 actual_range 1308614, 1309264;
    String long_name "Jgi_project_id";
    String units "unitless";
  }
  NCBI_BioSample {
    String long_name "Ncbi_biosample";
    String units "unitless";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "Other";
    String Conventions "COARDS, CF-1.6, ACDD-1.3";
    String creator_email "info@bco-dmo.org";
    String creator_name "BCO-DMO";
    String creator_url "https://www.bco-dmo.org/";
    String doi "10.26008/1912/bco-dmo.564351.3";
    String history 
"2025-03-14T06:27:26Z (local files)
2025-03-14T06:27:26Z https://erddap.bco-dmo.org/erddap/tabledap/bcodmo_dataset_564351_v3.html";
    String infoUrl "https://www.bco-dmo.org/dataset/564351";
    String institution "BCO-DMO";
    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.";
    String sourceUrl "(local files)";
    String summary 
"Weekly surface water samples from Newport Pier, CA, were collected between 11 January 2012 and 3 November 2023.

This project is a continuation of a time series with weekly surface water sampling from the Microbes in the Coastal Region of Orange County (MICRO) time series station at Newport Pier (33°36.37'N, 117°55.87'W). We measured dissolved nitrate and phosphate in the water, as well as particulate organic carbon, nitrogen and phosphorus.

These data were published in Fagan et al. (2019), Larkin et al. (2020), and a pending publication, Larkin et al. (in press).";
    String title "[Weekly Surface Water Samples] - Weekly surface water samples from Newport Pier, CA collected between 11 January 2012 and 3 November 2023 (Biological Controls on the Ocean C:N:P ratios)";
  }
}

 

---

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