Water Survey of Canada Station Registry

Every active and discontinued Canadian hydrometric station with location, drainage area, datum and real-time flag.

Native record

station x registry read

daily publication cadence

Evidence

Reference data

Stable context used to interpret other datasets

Time basis

Point-in-time records

UTC · event_time

Overview

Every active and discontinued Canadian hydrometric station with location, drainage area, datum and real-time flag.

Preserve one canonical row per (station_number) before aggregating.

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

HTTP endpoint

POST /api/v1/datasets/eccc_hydrometric_stations/query

Column

Type

event_timeDateTime64(6, 'UTC')

station_numberLowCardinality(String)

station_nameNullable(String)

prov_terr_state_locNullable(String)

statusNullable(String)

contributorNullable(String)

vertical_datumNullable(String)

real_timeNullable(Bool)

rhbnNullable(Bool)

drainage_area_grossNullable(Float64)

drainage_area_effectNullable(Float64)

latitudeNullable(Float64)

longitudeNullable(Float64)

ingested_atDateTime64(6, 'UTC')

No preview available.

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

Related infrastructure data
Dataset	Description
BPA Anemometer TowersBPA · daily	BPA's anemometer towers with coordinates, elevation and sensor heights, active and retired.
CAISO Interconnection QueueCAISO · monthly snapshot	CAISO's public generation interconnection queue, combining active, completed, and withdrawn projects with the proposed point of interconnection, technology, requested capacity, status, and completion dates. Each posting is a snapshot: current totals must use one latest snapshot, and requested queue MW is not operating capacity, available transmission headroom, or evidence that a project will be built.
CAISO Price LocationsCAISO · slow-moving dimension, refreshed every 6 hours	Every CAISO location that carries a price, as three columns: location_id, name, and kind. 26,632 rows — node (26,048), interface (578), zone (6). This is the dimension the CAISO price, and where applicable constraint, tables join to, and it is the one place a location's type is decided: resolve "which hubs exist", "is this a zone or a node", or "give me the readable name for this id" here rather than inferring a type from a name prefix. For CAISO, name equals location_id (the pnode name). The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.
Columbia River Dam Series RegistryUSACE · daily	The CWMS series collected into usace_nwd.project_timeseries, with project name, coordinates, unit and period of record.