Bottle silicate
The registry carries no authored label for this measurement, so the name above is the canonical series' own description in metadata/measurement_type.csv (variable.csv holds the authored labels, five today).
- 143,087
- values
- 8,345
- sampling events
- 1993–2025
- years
- 1
- dataset
- 1–3,510 m
- depth
- Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov
- seasons
Heads-up The btl_silicate series from CTD Cast Files carries no flag at this grain, so its values cannot be screened this way.
Measured in
-
series
btl_silicate· source columnsilno flag at this grain
One row per series, one cell per year, darker with more values — the same strip the front door draws per dataset and a species page draws per taxon. Each row is one dataset's own measurement_type; the label is written once, in the title above.
By depth
Values per depth band at the release grain, one thin bar per series. The bands are the record's own (0-10 … 2000+ m).
By month
Values per calendar month, one row per series: CalCOFI's quarterly cruises show as peaks in the months the ships sail.
Range & quality
- bounds
- The registry declares
0 … 300 µmol/Lforbtl_silicate; a value outside it is dropped at the ingest (drop_out_of_bounds()). - observed
- CTD Cast Files
btl_silicate0 · median 16.11 · 174.5 µmol/L (5th–95th percentile 1.38–73.64) - flags
- CTD Cast Files
btl_silicatecarries no quality code at the release grain; qual_ok keeps all 143,087. - baseline
- A monthly climatology exists for this measurement (the release's climatology table: 1993–2013, dataset × grid cell × calendar month × 10 m bin), so the Explorer can draw anomalies against it rather than values.
Related measurements
- Silicate concentration silicate · Hydrographic Bottle · 1959–2021 · 381,685 values · P01 SLCAZZXX the same quantity from the CTD files' own bottle samples — plausibly the same physical bottles, so merging them would count the bottle dataset twice
The same quantity from another platform or another kind of sample, each its own page and never merged into this one: a dataset's own bottle samples would count that dataset twice, an underway intake is not a cast, and a replicate is not a mean. The reason is the record's (related[].why).
Ways in
-
Explorermaps, sections and time series of this measurement — opens prefilledhttps://calcofi.io/explore/?var=btl_silicate
-
Explorer · a depth section vs normalthe newest cruise's section against the climatology baselinehttps://calcofi.io/explore/?lens=section&var=btl_silicate&anom=1
-
db-querySQL in your browser — the shell opens with this queryhttps://calcofi.io/db-query/?sql=SELECT+%2A+FROM+__TBL%3Aobs_env__+WHERE+measurement_type+%3D+%27btl_silicate%27+LIMIT+100%3B
-
ERDDAP · CTD Cast FilesCalCOFI's own server, the CTD Cast Files table constrained to this serieshttps://erddap.calcofi.io/erddap/tabledap/calcofi_ctd-cast.html?&measurement_type=%22btl_silicate%22
-
Parquetobs_env is partitioned by measurement_type in the content-addressed store — resolved through the release catalog, never a path built by hand
SELECT * FROM read_json('…/v2026.09.10/catalog.json') -- objects[] WHERE table = 'obs_env' -- AND partition_value = 'btl_silicate' -
R
library(calcofi4r) con <- cc_get_db() # the promoted release tbl(con, "obs_env") |> filter(measurement_type %in% c("btl_silicate")) -
Python
import calcofi4py as cc con = cc.cc_get_db() con.sql("SELECT * FROM obs_env WHERE measurement_type IN ('btl_silicate')").df()
This page as data
-
JSONthis measurement's entry of the release record, verbatimhttps://calcofi.io/measurements/btl_silicate.json
Read from measurements.json of release v2026.09.10, written at release by calcofi4db::build_measurements_catalog() beside taxa.json. The catalog's index is /measurements/; the JSON-LD on this page is a schema.org/DefinedTerm in the NERC P01 term set with a PropertyValue per series.
Cite
Cite the release; each dataset's own citation, licence and DOI are on its page — CTD Cast Files. The Explorer's Share → Cite writes it for the view you make.