ERDDAP > tabledap > Data Access Form

Dataset Title:	CalCOFI Phytoplankton (Venrick)
Institution:	CalCOFI   (Dataset ID: calcofi_phytoplankton)
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
time (UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		1970-01-01T02:41:49Z	1970-01-01T05:21:37Z
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		32.29686733333333	33.914212
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-121.57722533333333	-118.570115
region_key	!= =~ <= >= = < >		!= =~ <= >= = < >		"Alley"	"SE"
cruise_key	!= =~ <= >= = < >		!= =~ <= >= = < >		"" "1996-10-33RR" "1997-02-31JD" "1997-04-32NM" "1997-07-31JD" "1997-09-32NM" "1998-02-31JD" "1998-04-31JD" "1998-07-32NM" "1998-09-32NM" "1999-01-33RR" "1999-04-31JD" "1999-08-32NM" "2000-01-32NM" "2000-04-31JD" "2000-07-32NM" "2001-01-31JD" "2001-04-31JD" "2001-07-32NM" "2002-01-31JD" "2002-07-32NM" "2002-11-32NM" "2005-11-32NM" "2006-02-31JD" "2006-07-32NM" "2007-04-31JD" "2007-07-32NM" "2007-11-32NM" "2008-01-31JD" "2008-08-32NM" "2008-10-32NM" "2009-01-32NM" "2009-03-31JD" "2009-07-33MH" "2009-11-32NM" "2010-01-32NM" "2010-08-32NM" "2010-11-32NM" "2011-01-32NM" "2011-08-32NM" "2011-10-32NM" "2012-02-32NM" "2012-03-3322" "2012-10-32NM" "2013-01-3322" "2013-11-32NM" "2014-02-3322" "2014-11-32NM" "2015-01-32NM" "2015-11-32OC" "2016-01-33UD" "2017-01-33UD" "2017-08-33P4" "2018-02-3322" "2018-04-3322" "2018-06-33P4" "2019-02-33UD" "2019-04-33UD" "2019-07-" "2020-01-33UD" "2021-05-3322" "2022-04-3322"
season	!= =~ <= >= = < >		!= =~ <= >= = < >		"fall"	"winter"
year	!= =~ <= >= = < >		!= =~ <= >= = < >		1996	2022
month	!= =~ <= >= = < >		!= =~ <= >= = < >		1	11
species_code	!= =~ <= >= = < >		!= =~ <= >= = < >		"10"	"98"
taxa	!= =~ <= >= = < >		!= =~ <= >= = < >		"coccolithophore"	"undefined (code no..."
species	!= =~ <= >= = < >		!= =~ <= >= = < >		"Acanthoica quattro..."	"slim Pseudo-nitzsc..."
scientific_name_accepted	!= =~ <= >= = < >		!= =~ <= >= = < >		"Acanthoica quattro..."	"Zygoceros rhombus"
aphia_id	!= =~ <= >= = < >		!= =~ <= >= = < >		109462	1778370
abundance_cells_per_l	!= =~ <= >= = < >		!= =~ <= >= = < >		-13.0	107258.7

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" time latitude longitude region_key cruise_key season year month species_code taxa species scientific_name_accepted aphia_id abundance_cells_per_l time latitude longitude region_key cruise_key season year month species_code taxa species scientific_name_accepted aphia_id abundance_cells_per_l time latitude longitude region_key cruise_key season year month species_code taxa species scientific_name_accepted aphia_id abundance_cells_per_l time latitude longitude region_key cruise_key season year month species_code taxa species scientific_name_accepted aphia_id abundance_cells_per_l time latitude longitude region_key cruise_key season year month species_code taxa species scientific_name_accepted aphia_id abundance_cells_per_l ")

File type: (more information) .asc - View OPeNDAP-style ISO-8859-1 comma-separated text. .croissant - Download the dataset croissant schema. .csv - Download a ISO-8859-1 comma-separated text table (line 1: names; line 2: units; ISO 8601 times). .csv0 - Download a ISO-8859-1 .csv file without column names or units. Times are ISO 8601 strings. .csvp - Download a ISO-8859-1 .csv file with line 1: name (units). Times are ISO 8601 strings. .das - View the dataset's metadata via an ISO-8859-1 OPeNDAP Dataset Attribute Structure (DAS). .dataTable - A JSON file formatted for use with the Google Visualization client library (Google Charts). .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. .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/19139 UTF-8 .xml metadata using the version default for this server. .iso19115_2 - View the dataset's ISO 19115-2/19139 UTF-8 .xml metadata. .iso19115_3_2016 - View the dataset's ISO 19115-3:2016 UTF-8 .xml metadata. .iso19139_2007 - View the dataset's ISO 19139:2007 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). .jsonlCSV - View a UTF-8 JSON Lines CSV file without column names (mv = '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). .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. .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. .ncHeader - View the UTF-8 header (the metadata) for the NetCDF-3 .nc 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. .tsv - Download a ISO-8859-1 tab-separated text table (line 1: names; line 2: units; ISO 8601 times). .tsv0 - Download a ISO-8859-1 .tsv file without column names or units. Times are ISO 8601 strings. .tsvp - Download a ISO-8859-1 .tsv file with line 1: name (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. .largePdf - View a large .pdf image file with a graph or map. .largePng - View a large .png image file with a graph or map. .pdf - View a standard, medium-sized .pdf image file with a graph or map. .png - View a standard, medium-sized .png image file with a graph or map. .smallPdf - View a small .pdf image file with a graph or map. .smallPng - View a small .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 9709.0, 19297.0;
    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 units "seconds since 1970-01-01T00:00:00Z";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 actual_range 32.29686733333333, 33.914212;
    String axis "Y";
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float64 actual_range -121.57722533333333, -118.570115;
    String axis "X";
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
  }
  region_key {
    String ioos_category "Identifier";
    String long_name "Region key";
  }
  cruise_key {
    String ioos_category "Identifier";
    String long_name "Cruise key";
  }
  season {
    String ioos_category "Time";
    String long_name "Season";
  }
  year {
    Int32 actual_range 1996, 2022;
    String ioos_category "Time";
    String long_name "Year";
  }
  month {
    Int32 actual_range 1, 11;
    String ioos_category "Time";
    String long_name "Month";
  }
  species_code {
    String ioos_category "Identifier";
    String long_name "Species code";
  }
  taxa {
    String ioos_category "Other";
    String long_name "Taxa";
  }
  species {
    String ioos_category "Other";
    String long_name "Species";
  }
  scientific_name_accepted {
    String ioos_category "Other";
    String long_name "Scientific name accepted";
  }
  aphia_id {
    Int32 actual_range 109462, 1778370;
    String ioos_category "Identifier";
    String long_name "Aphia id";
  }
  abundance_cells_per_l {
    Float64 actual_range -13.0, 107258.7;
    String ioos_category "Other";
    String long_name "Abundance cells per l";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "Point";
    String Conventions "COARDS, CF-1.10, ACDD-1.3";
    String creator_name "CalCOFI";
    String creator_url "https://calcofi.org";
    Float64 Easternmost_Easting -118.570115;
    String featureType "Point";
    Float64 geospatial_lat_max 33.914212;
    Float64 geospatial_lat_min 32.29686733333333;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -118.570115;
    Float64 geospatial_lon_min -121.57722533333333;
    String geospatial_lon_units "degrees_east";
    String history 
"2026-06-15T16:44:18Z (local files)
2026-06-15T16:44:18Z http://localhost:8090/erddap/tabledap/calcofi_phytoplankton.html";
    String infoUrl "https://calcofi.org";
    String institution "CalCOFI";
    String license "CC-BY 4.0";
    Float64 Northernmost_Northing 33.914212;
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 32.29686733333333;
    String standard_name_vocabulary "CF Standard Name Table v79";
    String subsetVariables "cruise_key";
    String summary "Phytoplankton abundance (cells/L) by taxon, 1996-2022 (Venrick, EDI knb-lter-cce.254). Region-pooled: latitude/longitude are provisional region centroids.";
    String time_coverage_end "1970-01-01T05:21:37Z";
    String time_coverage_start "1970-01-01T02:41:49Z";
    String title "CalCOFI Phytoplankton (Venrick)";
    Float64 Westernmost_Easting -121.57722533333333;
  }
}

 

---

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