Ask the Grid
Open live grid

ECCC Daily Mean Hydrometric (Columbia)

HYDAT daily mean level and discharge for Canadian Columbia basin gauges and reservoirs, back to 1903.

ECCCHydrology dataBPA market
Query with the agent
Native record
station x time
daily publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

HYDAT daily mean level and discharge for Canadian Columbia basin gauges and reservoirs, back to 1903.

Query contract

Preserve one canonical row per (station_number, event_time) before aggregating.

Analysis rules

  • Level (m) and discharge (m3/s) are separate columns; lake gauges report level only.

Interpretation

  • Attribution to ECCC and the contributing agency is required.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

BPA MCP API reference
HTTP endpoint
POST /api/v1/datasets/eccc_hydrometric_daily_mean/query

Schema8

Column
Type
event_timeDateTime64(6, 'UTC')
station_numberLowCardinality(String)
dateDate32
levelNullable(Float64)
level_symbolNullable(String)
dischargeNullable(Float64)
discharge_symbolNullable(String)
ingested_atDateTime64(6, 'UTC')

Sample data

No preview available.

Coverage

No time-indexed data — coverage isn’t applicable to this dataset.