Water Survey of Canada Station Registry

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

ECCCInfrastructure data ERCOT market NYISO market CAISO market PJM market MISO market ISO-NE market SPP market

Open in Data Ask the agent

One row per: station x registry read; Daily cadence
Evidence: Reference data; Stable context used to interpret other datasets
Time basis: Point-in-time records; UTC · event_time

Overview

Query contract: Preserve one canonical row per (station_number) before aggregating.
Analysis rules: Group only after preserving the declared grain: station_number.

Access

Download: Query it in SQL, download it, or read it with an API key. Download data
MCP: Connect an MCP client and load the contract with describe_data before calling query_data.ERCOT MCP CAISO MCP NYISO MCP PJM MCP SPP MCP MISO MCP ISO-NE MCP BPA MCP API reference
HTTP endpoint: POST /api/v1/datasets/eccc_hydrometric_stations/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

14 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`station_number`	`LowCardinality(String)`
`station_name`	`Nullable(String)`
`prov_terr_state_loc`	`Nullable(String)`
`status`	`Nullable(String)`
`contributor`	`Nullable(String)`
`vertical_datum`	`Nullable(String)`
`real_time`	`Nullable(Bool)`
`rhbn`	`Nullable(Bool)`
`drainage_area_gross`	`Nullable(Float64)`
`drainage_area_effect`	`Nullable(Float64)`
`latitude`	`Nullable(Float64)`
`longitude`	`Nullable(Float64)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	station_number	station_name	prov_terr_state_loc	status	contributor	vertical_datum	real_time	rhbn	drainage_area_gross	drainage_area_effect	latitude	longitude	ingested_at
2026-11-03 06:46:57.008003	08FC004	DEAN RIVER ABOVE TOWDYSTAN LAKE	BC	Discontinued	∅	ASSUMED DATUM	false	false	292.3999938964844	∅	52.26028060913086	-125.084716796875	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FC003	DEAN RIVER BELOW TANSWANKET CREEK	BC	Active	B.C. MINISTRY OF ENVIRONMENT	ASSUMED DATUM	true	false	3748	∅	52.88946914672852	-125.77117156982422	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FC002	NASCALL RIVER NEAR OCEAN FALLS	BC	Discontinued	∅	ASSUMED DATUM	false	false	374.1000061035156	∅	52.49721908569336	-127.28333282470705	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FC001	DEAN RIVER NEAR OCEAN FALLS	BC	Discontinued	∅	ASSUMED DATUM	false	false	7798	∅	52.81888961791992	-126.94416809082033	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FB011	BELLA COOLA RIVER ABOVE HAMMER CREEK	BC	Active	WATER SURVEY OF CANADA (DOE) (CANADA)	ASSUMED DATUM	true	false	4071	∅	52.4392204284668	-126.3524398803711	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FB010	GIBBS BROOK NEAR HAGENSBORG	BC	Discontinued	∅	ASSUMED DATUM	false	false	∅	∅	52.38972091674805	-126.46778106689452	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FB009	CLAYTON FALLS CREEK NEAR THE MOUTH	BC	Discontinued	∅	ASSUMED DATUM	false	false	92.48999786376952	∅	52.36444091796875	-126.8080596923828	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08EG011	ZYMAGOTITZ RIVER NEAR TERRACE	BC	Discontinued	∅	ASSUMED DATUM	false	false	372.5	∅	54.51860809326172	-128.727783203125	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FB007	BELLA COOLA RIVER ABOVE BURNT BRIDGE CREEK	BC	Discontinued	WATER SURVEY OF CANADA (DOE) (CANADA)	ASSUMED DATUM	false	false	3634	∅	52.42221832275391	-126.1580581665039	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FB006	ATNARKO RIVER NEAR THE MOUTH	BC	Active	WATER SURVEY OF CANADA (DOE) (CANADA)	ASSUMED DATUM	true	true	2531	∅	52.36008071899414	-126.005859375	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FB005	NUSATSUM RIVER NEAR HAGENSBORG	BC	Discontinued	∅	ASSUMED DATUM	false	false	271.5	∅	52.38943862915039	-126.46028137207033	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FB004	SALLOOMT RIVER NEAR HAGENSBORG	BC	Active	B.C. MINISTRY OF ENVIRONMENT	ASSUMED DATUM	true	false	156.10000610351562	∅	52.424560546875	-126.52108001708984	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FB003	TASTSQUAN CREEK AT BELLA COOLA	BC	Discontinued	∅	ASSUMED DATUM	false	false	27.979999542236328	∅	52.3650016784668	-126.75666809082033	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FB002	BELLA COOLA RIVER NEAR HAGENSBORG	BC	Discontinued	∅	ASSUMED DATUM	false	false	4063	∅	52.44221878051758	-126.33222198486328	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FB001	BELLA COOLA RIVER AT BELLA COOLA	BC	Discontinued	∅	ASSUMED DATUM	false	false	5059	∅	52.37749862670898	-126.75499725341795	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FA009	GENESEE CREEK AT THE MOUTH	BC	Discontinued	OCEAN SCIENCE AND SURVEYS (DFO) (CANADA)	ASSUMED DATUM	false	false	21.8700008392334	∅	51.658329010009766	-126.67916870117188	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FB008	BELLA COOLA RIVER AT HAGENSBORG	BC	Discontinued	∅	ASSUMED DATUM	false	false	4751	∅	52.39167022705078	-126.5500030517578	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FA008	WASHWASH RIVER AT THE MOUTH	BC	Discontinued	OCEAN SCIENCE AND SURVEYS (DFO) (CANADA)	ASSUMED DATUM	false	false	128.3000030517578	∅	51.85417175292969	-126.6500015258789	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08EG017	DEEP CREEK ABOVE RESERVOIR	BC	Discontinued	B.C. MINISTRY OF ENVIRONMENT	ASSUMED DATUM	false	false	13.5	∅	54.5886116027832	-128.57083129882812	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08EG016	KLOIYA RIVER NEAR PRINCE RUPERT	BC	Discontinued	WATER SURVEY OF CANADA (DOE) (CANADA)	ASSUMED DATUM	false	false	104.6999969482422	∅	54.24705123901367	-130.1729736328125	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08EG015	DIANA CREEK NEAR PRINCE RUPERT	BC	Discontinued	∅	ASSUMED DATUM	false	false	∅	∅	54.22943878173828	-130.16139221191406	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08FA007	OWIKENO LAKE AT RIVERS INLET	BC	Active	WATER SURVEY OF CANADA (DOE) (CANADA)	ASSUMED DATUM	true	false	3917	∅	51.69218063354492	-127.16738891601562	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08EG013	BONEYARD CREEK AT OUTLET OF RAINBOW LAKE	BC	Discontinued	∅	ASSUMED DATUM	false	false	33.20000076293945	∅	54.1986083984375	-130.08056640625	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08EG012	EXCHAMSIKS RIVER NEAR TERRACE	BC	Active	WATER SURVEY OF CANADA (DOE) (CANADA)	ASSUMED DATUM	true	true	369.5	∅	54.36219024658203	-129.31283569335938	2026-11-03 06:46:59.786945
2026-11-03 06:46:57.008003	08EG014	RAINBOW LAKE NEAR PRINCE RUPERT	BC	Discontinued	∅	ASSUMED DATUM	false	false	∅	∅	54.19889068603516	-130.08056640625	2026-11-03 06:46:59.786945

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 1

Show coverage history

Coverage: 100.0%Days with data: 1Gaps: 0

2026

gaplessmore

Related data

Related infrastructure data
Dataset	Description
Advanced MetersEIA · annual (report year)	EIA-861 advanced metering: AMR, AMI and other meter counts, AMI energy served and customer access, by utility and customer class. Advanced_Meters, one row per utility, state, balancing authority and customer class. customer_class is residential, commercial, industrial, transportation (direct_connected in the distributed generation tables) or EIA's own total, so summing classes without excluding total counts everything twice. event_time is 1 January of the report year. release is final or early_release: EIA posts an early release of a year in August and replaces it with the final file in the autumn, and the mirror keeps the newest row per key. A key cell EIA leaves blank is '' or 0, and duplicate_index numbers rows that still share a key, in workbook order.
AESO Asset ListAESO · daily snapshot	AESO's registry of market assets: asset code, name, pool participant, operating status and asset type (source, sink and others), including retired assets.
Alberta (AESO) Price LocationsAESO · slow-moving dimension, refreshed every 6 hours	Every Alberta (AESO) location that carries a price, as three columns: location_id, name, and kind. 1 rows — system (1). This is the dimension the Alberta (AESO) 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 Alberta, the one location_id is SYSTEM: the pool price (aeso.pool_price) and system marginal price (aeso.system_marginal_price) are system-wide and carry no location column. Alberta has no nodal, zonal or hub prices; do not look for one. Generating assets are identified by AESO asset code in aeso.unit_status and aeso.asset_list, not here. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.
Baja California (CENACE) Price LocationsBCA · slow-moving dimension, refreshed every 6 hours	Every Baja California (CENACE) location that carries a price, as three columns: location_id, name, and kind. 4 rows — zone (4). This is the dimension the Baja California (CENACE) 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 Baja California, location_id is CENACE's load zone (TIJUANA, MEXICALI, ENSENADA, SANLUIS) and joins cenace.zonal_prices.load_zone; name is the city it is named for. CENACE prices Baja California by load zone only; there are no nodes or hubs in this dimension. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.