CalCOFI.io CalCOFI.io Storage

ducklake/releases/v2026.11.09 / RELEASE_NOTES.md · raw markdown ↗

CalCOFI integrated database release v2026.11.09

RELEASE_NOTES.md on gs://calcofi-db/ducklake/releases/v2026.11.09

Release date: 2026-11-09 · promoted (latest.txt)

Fall cruise 2611 grows from 11 to 36 casts: lines 93.3, 90 and 86.7, with 83.3 begun

The ship re-issued 20-2611_CTDCast.zip on 2026-11-08 (Ben Gire, CalCOFI technicians) with casts 1–36, 31 October to 7 November, covering lines 93.3, 90 and 86.7 and the first station of 83.3, against the 11 casts of v2026.11.05. Cruise 2026-11-33P4 goes from 24,986 to 80,945 headline observations (obs_env, now 37 measurement types) and from 347,634 to 1,133,895 in obs_ctd_full; calcofi_ctd-derived gains the same casts' sigma_theta_ave, spiciness0 and buoyancy_n2 (2,016,414 to 2,021,751 rows). The tier is still preliminary_with_bottle, with no nutrients yet. No other cruise changed: every other cruise × measurement type of calcofi_ctd-cast and calcofi_ctd-derived has the same row count, sum and flags as v2026.11.05.

The re-issue also revises casts 1–11, as the corrections are refitted over more bottles: corrected salinity moves by at most 0.0009, the averaged station-corrected oxygen by at most 0.02 mL/L, and the cruise-corrected chlorophyll estimate by up to 0.23 µg/L. dynamic_height and specific_volume_anomaly arrive for casts 1–11, which had shipped without them. On cast 7's upcast the ship has flagged the primary temperature, salinity and oxygen sensors 9 from 1–24 m, so the averaged oxygen there rests on the secondary sensor alone and rises by up to 64 µmol/kg.

Two gaps come from the source and are left as they are: dynamic height and its flag are blank on every upcast in this file (the technicians will address the cause later), so dynamic_height is downcast only for this cruise; and cast 36 (83.3 51) has bottle salts only, so it carries no station-corrected oxygen or chlorophyll.

Two held datasets reach their private previews: CCE-LTER size-fractionated chlorophyll and NOAA's CTD casts

No public table changes. cce-lter_chl-size-fractionated (workflows#155) and swfsc_ctd-noaa (workflows#154) are staged and held (in_release: false) until their providers decide from a private preview, so this section describes what the preview candidates carry and what the public release gains in validation. The depth-vs-seafloor ratchet (DEPTH_SEAFLOOR_OVER_HELD) now carries a baseline for each: 13 of the 422 chlorophyll casts are 0–100 m integrations at three stations whose GEBCO 2025 floor is 56–84 m (CCE-LTER question Q05, the provider's call on whether the integration stopped at the bottom bottle), and eight of the 886 NOAA CTD casts have a deepest standard depth 12–250 m below the GEBCO floor (SWFSC question Q06, Ed Weber: position or filled depths). A public release that carried either dataset with more such casts than its baseline would stop at depth_coverage; neither count can grow silently.

Consumers: nothing changes for a consumer of the public release; both datasets stay absent from catalog.json until consent is recorded.

sio_cetacean-sightings (held): the second preview candidate carries sample_track and the Farallon cut

No public table changes. The second private preview of the Scripps Whale Acoustics Lab's visual sightings (root ducklake-preview-sightings) is cut from the sightings shard rendered on 2026-11-06 and from a Farallon shard rendered with the marine-mammal cut, passed to scripts/preview_candidate.sh through CALCOFI_CAND_OVERRIDE, so the lab sees the two surveys as they would stand together once theirs is released: the effort segments and the ship-to-animal sight lines as sample_track paths, every placed sighting at the animal's position, the four sighting attributes, the lab's source files beside the notebook, and no Farallon marine mammal on a cruise the survey covered. Both rules are described under v2026.11.05 below (the entries were written before that release was cut and were promoted with it, though neither reached its tables): the public release still has no sample_track table and still carries every Farallon marine mammal, and will until the lab's consent is recorded and the dataset is un-held. The Explorer gained an Effort layer (effort=on, CalCOFI/explore#45) that draws the segments and sight lines of a release that has sample_track, and stays disabled on one that does not.

Consumers: nothing changes for a consumer of the public release.

Contents (generated)

table rows
climatology 1,921,596 partitioned
cruise 869
dataset 20
dataset_taxon 1,940
fish 10,796
grid 225
grid_crosswalk 673
ichthyo_net 77,888
lookup 26
measurement_type 298
obs 36,096,173 deprecated → obs_bio, obs_env (objects removed in next)
obs_attribute 455,300
obs_bio 1,586,795
obs_env 34,509,378 partitioned
region 4
sample 1,467,430
sample_measurement 715,139
sample_spatial 2,296,225
ship 49
spatial 3,395
spatial_attribute 37,968
taxon 2,606
taxon_group 438
obs_ctd_full 287,281,956 supplemental
obs_mets_full 19,926,523 supplemental
sample_root 419,489 supplemental

26 tables, 386,813,199 rows, 3.09 GB.

Datasets (20): calcofi_2022-edna, calcofi_bottle, calcofi_bottle-derived, calcofi_ctd-cast, calcofi_ctd-derived, calcofi_dic, calcofi_mets, calcofi_phyllosoma, calcofi_phytoplankton, cce-lter_euphausiids, cce-lter_iron, cce-lter_picoplankton-bacteria, cce-lter_zoodb, cce-lter_zooscan, cdfw_dungeness-crab, farallon_bird-mammal, sio_mesopelagic-fish, sio_pic-zooplankton, swfsc_cufes, swfsc_ichthyo

Validation: 106 pass / 0 fail / 4 skip (consumer-contract suite, 2026-11-09T12:53:21Z).

Software: calcofi4db 4.35.1, calcofi4r 1.31.0.

How to cite

CalCOFI (2026). CalCOFI Integrated Database, release v2026.11.09 [Data set]. Scripps Institution of Oceanography, NOAA Fisheries, and California Department of Fish and Wildlife. https://doi.org/10.5281/zenodo.24083894

Cite the source datasets you use alongside the release:

Access

con <- calcofi4r::cc_get_db(version = "v2026.11.09")
con = calcofi4py.cc_get_db("v2026.11.09")

Parquet: https://storage.googleapis.com/calcofi-db/ducklake/releases/v2026.11.09/parquet/{table}.parquet; full history: RELEASES.md.