Integrated App
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.
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 decades of fish larvae and oceanographic bottle data together โ filter by taxa, depth and season over dynamic hexagon maps, time series and depth profiles.
Visualize CTD casts โ temperature, salinity, oxygen and more โ by cruise, station and depth, from individual profiles to whole-grid maps.
Interactive apps and stories to visualize ocean conditions and marine life โ no coding required.
Visualize and download CalCOFI oceanographic data in map, time-series and depth-profile views.
Satellite-derived sea-surface conditions from the Copernicus Marine Service, mapped over the CalCOFI sampling region.
Map pollutants in the Southern California Bight from the Regional Monitoring Program via SCCWRP.
A scrollable story of hypoxia in the California Current Ecosystem and its changing oxygen levels over the past 71 years.
Larval abundance analysis and visualization for Channel Islands National Marine Sanctuary species.
Gallery of visualizations used in products โ manuscripts, reports and applications โ across partners.
Initial mockup of a condition dashboard โ survey map, time series and indicator scores.
Query, browse, download or programmatically access the versioned integrated database โ for analysts in SQL, R, Python or the browser.
Run SQL on the CalCOFI database right in your browser โ DuckDB-WASM reads the released Parquet files directly; no server, no credentials.
Browse tables, columns, datasets and entity-relationship diagrams of each versioned database release.
Cross-dataset observation explorer โ compare coverage across cruises, datasets and depths, with shareable deep-link URLs.
CalCOFI datasets served through NOAA's ERDDAP โ subset and download in CSV, NetCDF, JSON and more, or connect from analysis tools.
REST API to generate summary tables and figures from the database, usable from any programming language.
R package of helper functions to read, analyze and visualize CalCOFI data โ connects directly to versioned database releases.
Technical documentation of the data ecosystem โ data access, database, API, apps, maps and reports.
The open-source plumbing โ reproducible workflows, packages and servers behind everything above.
Reproducible Quarto notebooks that ingest each dataset into the versioned database โ the pipeline behind every release.
R package of database tools for ingest workflows โ cloud storage, Parquet conversion, DuckDB management and frozen releases.
Streams H3 hexagon tiles from DuckDB SQL to MapLibre maps โ the engine behind the Integrated App's dynamic layers (h3t.calcofi.io).
Vector tile server (pg_tileserv) for quickly rendering dense geometries โ points, lines and polygons โ on slippy maps.
Live uptime and response-time monitoring of every CalCOFI.io app and service, with incident history.
Capstone and fellowship projects by university students partnering with CalCOFI.
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
Statewide inventory of California ocean and coastal monitoring programs โ hex-grid coverage, survey transects, discharger stations and bathymetry.
UCLA Capstone ยท 2026 ยท Betty Huang
Personalized fish-consumption advisories for Southern California anglers โ DDT levels predicted by species and catch location.
UCSB Bren MEDS Capstone ยท 2024
Marine mammal eDNA detections and visual sightings visualized against oceanographic conditions on the CalCOFI grid.
UCSB Data Science Capstone ยท 2025
Spatial and temporal visualization of the CalCOFI bottle dataset โ the first student capstone built on the database.
UCSB CCDSP Fellowship ยท 2022