Select the datasets you'd like to download, then click Download.
The bundle is organized into data/original/, data/summarized/ and
data/integrated/, each paired with the exact, portable SQL in a
query/ folder (manifest.json, per-file *.sql, REPRODUCE.md) so
the integrated bio↔env match can be re-run anywhere against the
public CalCOFI release parquet.
The default thresholds of 2 km and 6 hours to match CTD casts and net tows for larval fish have been selected to represent approximate spatial and temporal scales within a single tidal cycle and over which water masses are expected to remain broadly similar (although this assumption may vary depending on proximity to coastal fronts or distance from shore). The 2 km threshold also falls within the typical range of potential station drift and/or delay between CTD casts and net tows during sampling operations. Additionally, all stations are spaced farther apart than 2km.
The CalCOFI Integrated Application is using the integrated database constructed from the following datasets:
This app is open-source with code found here:
The following key technologies enable this app:
- R: programming language for statistical computing
- Shiny: web application framework for R
- DuckDB: in-process SQL OLAP database management system
- H3: hexagonal hierarchical geospatial indexing system
- mapgl: R interface to MapLibre GL JS for interactive maps
This app was developed by:
- Ivy Li: CalCOFI intern from UCSB (BS in Physics and Statistics & Data Science)
- Ben Best: CalCOFI contractor, marine data scientist at EcoQuants LLC
- Erin Satterthwaite: CalCOFI Program Coordinator