CalCOFI.io open data ecosystem
Temperature to whales, surface to the deep, since 1949 — open and integrated.
218 grid cells · 67 standard · 37 extended · 114 historical · occupied 1949 – 2026
Open the Station Explorer →
Read the frozen release directly — from R, Python, a browser, ERDDAP or any DuckDB. No server, no credentials.
library(calcofi4r)
con <- cc_get_db() # latest release
tbl(con, "obs_env") |>
filter(measurement_type == "temperature",
depth_m <= 10)
import calcofi4py as cc
con = cc.cc_get_db() # latest release
con.sql("""SELECT * FROM obs_env
WHERE measurement_type = 'temperature'
AND depth_m <= 10""").df()
-- db-query: DuckDB in your browser, no server SELECT cruise_key, avg(value) AS temperature FROM obs_env WHERE measurement_type = 'temperature' GROUP BY cruise_key
# any dataset as CSV, JSON, netCDF … https://erddap.calcofi.io/erddap/tabledap/
-- DuckDB, anywhere: the release's catalog
-- lists every parquet object it holds
SELECT * FROM read_json('https://storage.googleapis.com/calcofi-db/ducklake/releases/v2026.09.06/catalog.json')
Every organism in the release resolved to one accepted WoRMS id (ITIS for birds), so a name means the same thing in every dataset.
From diatoms to whales →Find what has been collected. One record per dataset — coverage, every endpoint it can be reached through, its licence and how to cite it — by category, with the holdings CalCOFI has but has not ingested yet. All datasets data.json
Euphausiid species and stages from bongo tows
Ichthyoplankton — fish eggs and larvae from oblique and vertical tows and the continuous underway egg sampler
Metabarcoding and environmental DNA — ASV tables, eDNA-derived abundance and density
Midwater trawl catches of mesopelagic fishes
Phytoplankton counts by taxon or functional group, and imaging flow cytometry (IFCB)
Picoplankton and bacterioplankton abundances by flow cytometry
Strip-transect counts of seabirds and marine mammals along the cruise track
Net-tow zooplankton: displacement volume, imaged and identified taxa, decapod larvae
Dissolved inorganic carbon, alkalinity, pH and pCO2
Wind, air temperature, pressure, cloud, visibility, sea state and water colour from the underway METS and ship observations
Nitrate, nitrite, phosphate, silicate and ammonium from bottle samples; particulate and total organic carbon and nitrogen, nitrate isotopes, and trace metals (iron)
Temperature, salinity, density, oxygen, pressure and dynamic height from bottles and CTD casts
Chlorophyll a, phaeopigments, primary production (C14) and light (PAR)
No dataset matches those filters.
Explore CalCOFI data in the browser — across every ingested dataset, or deep on one.
StationsHexagonsCruisesRegionsSectionsContoursstudent contribution
The Explorer brings the spatial grains together as lenses in one app; the others each go deep on one grain — station, hexagon, cruise, or contour.
One app, six lenses — stations, hexagons, contours, cruises, regions and sections — for one organism or one ocean variable at a time over the frozen release. The queries run in your browser (no server), every view is a URL you can share, every download carries its SQL, and feedback comes with an annotated screenshot.
Discover what's measured at each CalCOFI station — station × dataset coverage (time, depth, observations, surveys) built from the integrated release database, with variable search and dataset crosswalk. Continues the 2026 UCSB student capstone.
Explore decades of fish larvae and oceanographic bottle data together — filter by taxa, depth and season over dynamic hexagon maps, time series and depth profiles. Superseded by the Explorer's hexagons lens (Ben, 2026-09-08); kept serving.
Cross-dataset observation explorer — compare coverage across cruises, datasets and depths, with shareable deep-link URLs. Superseded by the Explorer's cruises lens (Ben, 2026-09-08); kept serving.
Visualize and download CalCOFI oceanographic data in map, time-series and depth-profile views.
Apps focused on a single dataset or data source.
Cross-shelf temperature, salinity, oxygen, density and fluorescence sections along every CalCOFI line, for every cruise since 1993 — drawn nearshore to offshore with no station picking, and mapped so you can see where each transect is. Opens on the anomaly against each station's day-of-year climatology (warmer or colder than usual, and by how much), with the measured value one click away. Flags each cruise's processing stage, and shows the uncorrected sensor series on cruises whose bottle merge has not run.
Visualize CTD casts — temperature, salinity, oxygen and more — by cruise, station and depth, from individual profiles to whole-grid maps.
Map pollutants in the Southern California Bight from the Regional Monitoring Program via SCCWRP.
The ways to get the data: standards-based services, public cloud storage, browser SQL, and the R and Python packages that read a release directly.
Python package mirroring calcofi4r — query the versioned database releases with DuckDB and the CTD team's PostgreSQL working database, credentials-free via .pgpass.
The pipeline behind every release and the documentation tying it together — the ingest workflows, the database tooling, the schema browser and the technical docs. Read the docs
R package of database tools for ingest workflows — cloud storage, Parquet conversion, DuckDB management and frozen releases.
Capstone and fellowship projects by university students partnering with CalCOFI.
Statewide inventory of California ocean and coastal monitoring programs within 12 nmi of the coast — hex-grid coverage at 1/3/5 km, survey transects, discharger stations, bathymetry, monitoring gaps, wind energy areas, and marine protected areas.
UCLA Capstone · 2026 · Betty Huang
Explore CalCOFI fish-larvae (ichthyoplankton) abundance over time and space — filter by species or habitat across seasons and decades, with trend, correlation, stability and spatial views plus CSV/PDF export.
UCSB Data Science Capstone · 2026 · Joy Chang, Abhijit Brahme, A. Senthil, Chengcheng Fang, Kaeya Mehta, Shenyi Jiang
Map-based discovery of what is measured at each of 115 CalCOFI stations, with live variable search and auto-generated ERDDAP, Euphausiid and ZooDB queries.
UCSB Data Science Capstone · 2026 · Nicole Xu, Aashish Krishnan, Qiongwen (Lucy) Cao
Marine mammal eDNA detections and visual sightings visualized against oceanographic conditions on the CalCOFI grid.
UCSB Data Science Capstone · 2025
An interactive TimelineJS journey through 75 years of CalCOFI milestones — from the 1949 founding after the sardine collapse to the NORPAC expedition, the 1957–58 El Niño, CTD sampling, and the first all-female research cruise.
CalCOFI–CA Sea Grant Data Storytelling Internship · 2024 · Anneliese (Annie) Adams
A scrollable story of hypoxia in the California Current Ecosystem and its changing oxygen levels over the past 71 years.
CalCOFI–CA Sea Grant Data Storytelling Internship · 2024 · Mallika Gupta, Anneliese (Annie) Adams
An interactive map for planning ocean monitoring around California's floating offshore wind areas — toggle Essential Ocean Variables and long-term monitoring programs to reveal gaps in baseline datasets.
SIO Masters Capstone · 2024 · Eliza Thomas
Personalized fish-consumption advisories for Southern California anglers — DDT levels predicted by species and catch location.
UCSB Bren MEDS Capstone · 2024
Spatial and temporal visualization of the CalCOFI bottle dataset — the first student capstone built on the database.
UCSB CCDSP Fellowship · 2022