ERDDAP > tabledap > Data Access Form

Dataset Title:	[HOT pTMs, 2020-2023] - Water column particulate metals from Hawaii Ocean Timeseries (HOT) R/V Kilo Moana cruises at station ALOHA, North Pacific Subtropical Gyre, from December 2020 to November 2023 (Quantifying Iron Turnover in the Upper Ocean via Time-series Measurements at Station ALOHA)
Institution:	BCO-DMO   (Dataset ID: bcodmo_dataset_962966_v1)
Information:	Summary | License | FGDC | ISO 19115 | Metadata | Background | Files | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum	Maximum
Cruise (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		"HOT-325"	"HOT-346"
ISO_DateTime_Local (Time, unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		"2020-12-18T09:00:00"	"2023-11-05T09:00:00"
time (Time_utc, UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		2020-12-18T19:00:00Z	2023-11-05T19:00:00Z
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-158	-158
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		22.75	22.75
depth (m)	!= =~ <= >= = < >		!= =~ <= >= = < >		15	900
pAl_labile (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.094	8.426
pAl_labile_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pTi_labile (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.013
pTi_labile_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pMn_labile (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.196
pMn_labile_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pFe_labile (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.02	1.937
pFe_labile_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pCo_labile (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		-3.0E-5	0.00322
pCo_labile_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pNi_labile (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.079
pNi_labile_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pCu_labile (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		-0.002	0.067
pCu_labile_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pCd_labile (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		-1.0E-5	0.00441
pCd_labile_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pAl_recal (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	5.142
pAl_recal_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pTi_recal (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.208
pTi_recal_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pMn_recal (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.005
pMn_recal_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pFe_recal (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.969
pFe_recal_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pCo_recal (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.00167
pCo_recal_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pNi_recal (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.024
pNi_recal_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pCu_recal (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.281
pCu_recal_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9
pCd_recal (nanomoles per liter (nmol/L))	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	0.00249
pCd_recal_qc (unitless)	!= =~ <= >= = < >		!= =~ <= >= = < >		2	9

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" Cruise ISO_DateTime_Local time longitude latitude depth pAl_labile pAl_labile_qc pTi_labile pTi_labile_qc pMn_labile pMn_labile_qc pFe_labile pFe_labile_qc pCo_labile pCo_labile_qc pNi_labile pNi_labile_qc pCu_labile pCu_labile_qc pCd_labile pCd_labile_qc pAl_recal pAl_recal_qc pTi_recal pTi_recal_qc pMn_recal pMn_recal_qc pFe_recal pFe_recal_qc pCo_recal pCo_recal_qc pNi_recal pNi_recal_qc pCu_recal pCu_recal_qc pCd_recal pCd_recal_qc Cruise ISO_DateTime_Local time longitude latitude depth pAl_labile pAl_labile_qc pTi_labile pTi_labile_qc pMn_labile pMn_labile_qc pFe_labile pFe_labile_qc pCo_labile pCo_labile_qc pNi_labile pNi_labile_qc pCu_labile pCu_labile_qc pCd_labile pCd_labile_qc pAl_recal pAl_recal_qc pTi_recal pTi_recal_qc pMn_recal pMn_recal_qc pFe_recal pFe_recal_qc pCo_recal pCo_recal_qc pNi_recal pNi_recal_qc pCu_recal pCu_recal_qc pCd_recal pCd_recal_qc Cruise ISO_DateTime_Local time longitude latitude depth pAl_labile pAl_labile_qc pTi_labile pTi_labile_qc pMn_labile pMn_labile_qc pFe_labile pFe_labile_qc pCo_labile pCo_labile_qc pNi_labile pNi_labile_qc pCu_labile pCu_labile_qc pCd_labile pCd_labile_qc pAl_recal pAl_recal_qc pTi_recal pTi_recal_qc pMn_recal pMn_recal_qc pFe_recal pFe_recal_qc pCo_recal pCo_recal_qc pNi_recal pNi_recal_qc pCu_recal pCu_recal_qc pCd_recal pCd_recal_qc Cruise ISO_DateTime_Local time longitude latitude depth pAl_labile pAl_labile_qc pTi_labile pTi_labile_qc pMn_labile pMn_labile_qc pFe_labile pFe_labile_qc pCo_labile pCo_labile_qc pNi_labile pNi_labile_qc pCu_labile pCu_labile_qc pCd_labile pCd_labile_qc pAl_recal pAl_recal_qc pTi_recal pTi_recal_qc pMn_recal pMn_recal_qc pFe_recal pFe_recal_qc pCo_recal pCo_recal_qc pNi_recal pNi_recal_qc pCu_recal pCu_recal_qc pCd_recal pCd_recal_qc Cruise ISO_DateTime_Local time longitude latitude depth pAl_labile pAl_labile_qc pTi_labile pTi_labile_qc pMn_labile pMn_labile_qc pFe_labile pFe_labile_qc pCo_labile pCo_labile_qc pNi_labile pNi_labile_qc pCu_labile pCu_labile_qc pCd_labile pCd_labile_qc pAl_recal pAl_recal_qc pTi_recal pTi_recal_qc pMn_recal pMn_recal_qc pFe_recal pFe_recal_qc pCo_recal pCo_recal_qc pNi_recal pNi_recal_qc pCu_recal pCu_recal_qc pCd_recal pCd_recal_qc ")

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 {
  Cruise {
    String long_name "Cruise";
    String units "unitless";
  }
  ISO_DateTime_Local {
    String long_name "Time";
    String units "unitless";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.608318e+9, 1.6992108e+9;
    String axis "T";
    String ioos_category "Time";
    String long_name "Time_utc";
    String standard_name "time";
    String time_origin "01-JAN-1970 00:00:00";
    String units "seconds since 1970-01-01T00:00:00Z";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Int32 actual_range -158, -158;
    String axis "X";
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float32 actual_range 22.75, 22.75;
    String axis "Y";
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  depth {
    String _CoordinateAxisType "Height";
    String _CoordinateZisPositive "down";
    Int32 actual_range 15, 900;
    String axis "Z";
    String ioos_category "Location";
    String long_name "Depth";
    String positive "down";
    String standard_name "depth";
    String units "m";
  }
  pAl_labile {
    Float32 actual_range -0.094, 8.426;
    String long_name "Pal_labile";
    String units "nanomoles per liter (nmol/L)";
  }
  pAl_labile_qc {
    Int32 actual_range 2, 9;
    String long_name "Pal_labile_qc";
    String units "unitless";
  }
  pTi_labile {
    Float32 actual_range 0.0, 0.013;
    String long_name "Pti_labile";
    String units "nanomoles per liter (nmol/L)";
  }
  pTi_labile_qc {
    Int32 actual_range 2, 9;
    String long_name "Pti_labile_qc";
    String units "unitless";
  }
  pMn_labile {
    Float32 actual_range 0.0, 0.196;
    String long_name "Pmn_labile";
    String units "nanomoles per liter (nmol/L)";
  }
  pMn_labile_qc {
    Int32 actual_range 2, 9;
    String long_name "Pmn_labile_qc";
    String units "unitless";
  }
  pFe_labile {
    Float32 actual_range -0.02, 1.937;
    String long_name "Pfe_labile";
    String units "nanomoles per liter (nmol/L)";
  }
  pFe_labile_qc {
    Int32 actual_range 2, 9;
    String long_name "Pfe_labile_qc";
    String units "unitless";
  }
  pCo_labile {
    Float32 actual_range -3.0e-5, 0.00322;
    String long_name "Pco_labile";
    String units "nanomoles per liter (nmol/L)";
  }
  pCo_labile_qc {
    Int32 actual_range 2, 9;
    String long_name "Pco_labile_qc";
    String units "unitless";
  }
  pNi_labile {
    Float32 actual_range 0.0, 0.079;
    String long_name "Pni_labile";
    String units "nanomoles per liter (nmol/L)";
  }
  pNi_labile_qc {
    Int32 actual_range 2, 9;
    String long_name "Pni_labile_qc";
    String units "unitless";
  }
  pCu_labile {
    Float32 actual_range -0.002, 0.067;
    String long_name "Pcu_labile";
    String units "nanomoles per liter (nmol/L)";
  }
  pCu_labile_qc {
    Int32 actual_range 2, 9;
    String long_name "Pcu_labile_qc";
    String units "unitless";
  }
  pCd_labile {
    Float32 actual_range -1.0e-5, 0.00441;
    String long_name "Pcd_labile";
    String units "nanomoles per liter (nmol/L)";
  }
  pCd_labile_qc {
    Int32 actual_range 2, 9;
    String long_name "Pcd_labile_qc";
    String units "unitless";
  }
  pAl_recal {
    Float32 actual_range 0.0, 5.142;
    String long_name "Pal_recal";
    String units "nanomoles per liter (nmol/L)";
  }
  pAl_recal_qc {
    Int32 actual_range 2, 9;
    String long_name "Pal_recal_qc";
    String units "unitless";
  }
  pTi_recal {
    Float32 actual_range 0.0, 0.208;
    String long_name "Pti_recal";
    String units "nanomoles per liter (nmol/L)";
  }
  pTi_recal_qc {
    Int32 actual_range 2, 9;
    String long_name "Pti_recal_qc";
    String units "unitless";
  }
  pMn_recal {
    Float32 actual_range 0.0, 0.005;
    String long_name "Pmn_recal";
    String units "nanomoles per liter (nmol/L)";
  }
  pMn_recal_qc {
    Int32 actual_range 2, 9;
    String long_name "Pmn_recal_qc";
    String units "unitless";
  }
  pFe_recal {
    Float32 actual_range 0.0, 0.969;
    String long_name "Pfe_recal";
    String units "nanomoles per liter (nmol/L)";
  }
  pFe_recal_qc {
    Int32 actual_range 2, 9;
    String long_name "Pfe_recal_qc";
    String units "unitless";
  }
  pCo_recal {
    Float32 actual_range 0.0, 0.00167;
    String long_name "Pco_recal";
    String units "nanomoles per liter (nmol/L)";
  }
  pCo_recal_qc {
    Int32 actual_range 2, 9;
    String long_name "Pco_recal_qc";
    String units "unitless";
  }
  pNi_recal {
    Float32 actual_range 0.0, 0.024;
    String long_name "Pni_recal";
    String units "nanomoles per liter (nmol/L)";
  }
  pNi_recal_qc {
    Int32 actual_range 2, 9;
    String long_name "Pni_recal_qc";
    String units "unitless";
  }
  pCu_recal {
    Float32 actual_range 0.0, 0.281;
    String long_name "Pcu_recal";
    String units "nanomoles per liter (nmol/L)";
  }
  pCu_recal_qc {
    Int32 actual_range 2, 9;
    String long_name "Pcu_recal_qc";
    String units "unitless";
  }
  pCd_recal {
    Float32 actual_range 0.0, 0.00249;
    String long_name "Pcd_recal";
    String units "nanomoles per liter (nmol/L)";
  }
  pCd_recal_qc {
    Int32 actual_range 2, 9;
    String long_name "Pcd_recal_qc";
    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 defaultDataQuery "&time<now";
    String doi "10.26008/1912/bco-dmo.962966.1";
    Float64 Easternmost_Easting -158.0;
    Float64 geospatial_lat_max 22.75;
    Float64 geospatial_lat_min 22.75;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -158.0;
    Float64 geospatial_lon_min -158.0;
    String geospatial_lon_units "degrees_east";
    Float64 geospatial_vertical_max 900.0;
    Float64 geospatial_vertical_min 15.0;
    String geospatial_vertical_positive "down";
    String geospatial_vertical_units "m";
    String history 
"2025-09-09T17:14:51Z (local files)
2025-09-09T17:14:51Z https://erddap.bco-dmo.org/erddap/tabledap/bcodmo_dataset_962966_v1.html";
    String infoUrl "https://osprey.bco-dmo.org/dataset/962966";
    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.";
    Float64 Northernmost_Northing 22.75;
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 22.75;
    String summary 
"We collected water column particulate metal samples onboard Hawaii Ocean Time-series (HOT) cruises between December 2020 and November 2023. All samples were collected at Station ALOHA. Samples were collected using a trace metal rosette and filtered onto 0.2 micron polyethersulfone (PES) filters (approx. 4L per sample). Approx. 11 depth samples were collected for each cruise within the upper 300 m of the water column.

Filters were subject to a 2-stage digestion: 1) a \"Berger\" leach consisting of hydoxylamine and acetic acid, to dissolve labile trace metals, and 2) a digestion with nitric acid and hydrofluoric acid to dissolve recalcitrant metals. Dissolved metals for each leach were analyzed by inductively coupled plasma mass spectrometry at the University of Hawaii at Manoa using a Thermo Scientific iCAP-TQ mass spectrometer. 

This dataset is part of a larger study focused on the cycling of trace metals in the North Pacific Subtropical Gyre, and is embedded within the HOT program.";
    String time_coverage_end "2023-11-05T19:00:00Z";
    String time_coverage_start "2020-12-18T19:00:00Z";
    String title "[HOT pTMs, 2020-2023] - Water column particulate metals from Hawaii Ocean Timeseries (HOT)  R/V Kilo Moana cruises at station ALOHA, North Pacific Subtropical Gyre, from December 2020 to November 2023 (Quantifying Iron Turnover in the Upper Ocean via Time-series Measurements at Station ALOHA)";
    Float64 Westernmost_Easting -158.0;
  }
}

 

---

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