CalCOFI.io

From ship to screen

Since 1949, CalCOFI cruises have sampled the California Current โ€” one of the longest-running ocean observing programs anywhere. CalCOFI.io turns those observations into an open data ecosystem: reproducible workflows load each dataset into a versioned integrated database, which powers interactive apps, a browser SQL playground, an API and an R package โ€” for scientists, resource managers, students and the curious.

ship โ†’ workflows โ†’ database โ†’ apps ยท API ยท R

๐Ÿ”ญ Explore 7

Interactive apps and stories to visualize ocean conditions and marine life โ€” no coding required.

๐Ÿ“Š Access Data 8

Query, browse, download or programmatically access the versioned integrated database โ€” for analysts in SQL, R, Python or the browser.

Screenshot of Query

Query

Run SQL on the CalCOFI database right in your browser โ€” DuckDB-WASM reads the released Parquet files directly; no server, no credentials.

SQLDuckDB-WASM
Screenshot of ERDDAP

ERDDAP

CalCOFI datasets served through NOAA's ERDDAP โ€” subset and download in CSV, NetCDF, JSON and more, or connect from analysis tools.

๐Ÿ›  Build 6

The open-source plumbing โ€” reproducible workflows, packages and servers behind everything above.

Screenshot of Workflows

Workflows

Reproducible Quarto notebooks that ingest each dataset into the versioned database โ€” the pipeline behind every release.

RQuartoDuckDBParquet
Screenshot of H3 Tile Server

H3 Tile Server

Streams H3 hexagon tiles from DuckDB SQL to MapLibre maps โ€” the engine behind the Integrated App's dynamic layers (h3t.calcofi.io).

PythonFastAPIDuckDBH3
Screenshot of Server

Server

Docker Compose stack running calcofi.io services โ€” Shiny, API, PostGIS, tile server, ERDDAP and Caddy.

DockerCaddy

๐ŸŽ“ Student Contributions 5

Capstone and fellowship projects by university students partnering with CalCOFI.

Screenshot of Station Data Portal

Station Data Portal

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

Screenshot of CA Ocean Monitoring Map

CA Ocean Monitoring Map

Statewide inventory of California ocean and coastal monitoring programs โ€” hex-grid coverage, survey transects, discharger stations and bathymetry.

UCLA Capstone ยท 2026 ยท Betty Huang

Screenshot of Capstone App

Capstone Apparchived

Spatial and temporal visualization of the CalCOFI bottle dataset โ€” the first student capstone built on the database.

UCSB CCDSP Fellowship ยท 2022