USGS Gauge Registry

USGS surface-water gauge registry: coordinates, HUC, drainage area and datum, one snapshot row per fetch and site.

USGSInfrastructure 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: snapshot x site; Weekly 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 (event_time, location_id) before aggregating.
Analysis rules: Read the latest snapshot: pin event_time to max(event_time).

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/usgs_water_monitoring_locations/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

30 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`location_id`	`LowCardinality(String)`
`agency_code`	`Nullable(String)`
`agency_name`	`Nullable(String)`
`monitoring_location_number`	`Nullable(String)`
`monitoring_location_name`	`Nullable(String)`
`site_type_code`	`Nullable(String)`
`site_type`	`Nullable(String)`
`district_code`	`Nullable(String)`
`country_code`	`Nullable(String)`
`state_code`	`Nullable(String)`
`state_name`	`Nullable(String)`
`county_code`	`Nullable(String)`
`county_name`	`Nullable(String)`
`hydrologic_unit_code`	`Nullable(String)`
`basin_code`	`Nullable(String)`
`altitude`	`Nullable(Float64)`
`altitude_accuracy`	`Nullable(Float64)`
`vertical_datum`	`Nullable(String)`
`horizontal_positional_accuracy`	`Nullable(String)`
`original_horizontal_datum`	`Nullable(String)`
`drainage_area`	`Nullable(Float64)`
`contributing_drainage_area`	`Nullable(Float64)`
`time_zone_abbreviation`	`Nullable(String)`
`uses_daylight_savings`	`Nullable(String)`
`construction_date`	`Nullable(String)`
`latitude`	`Nullable(Float64)`
`longitude`	`Nullable(Float64)`
`source_time`	`DateTime64(6, 'UTC')`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	location_id	agency_code	agency_name	monitoring_location_number	monitoring_location_name	site_type_code	site_type	district_code	country_code	state_code	state_name	county_code	county_name	hydrologic_unit_code	basin_code	altitude	altitude_accuracy	vertical_datum	horizontal_positional_accuracy	original_horizontal_datum	drainage_area	contributing_drainage_area	time_zone_abbreviation	uses_daylight_savings	construction_date	latitude	longitude	source_time	ingested_at
2026-11-02 07:06:10.726029	USGS-88160007	USGS	U.S. Geological Survey	88160007	IWSC Cell Test Site	ST	Stream	16	US	16	Idaho	001	Ada County	170501140403	∅	2736	4.3	NAVD88	Accurate to + or - .1 sec (Differentially-Corrected GPS).	NAD83	∅	∅	MST	Y	∅	43.6165888888889	-116.188330555556	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-88160006	USGS	U.S. Geological Survey	88160006	PF Cell Test Site	ST	Stream	16	US	16	Idaho	001	Ada County	170501140403	∅	2737	4.3	NAVD88	Accurate to + or - .1 sec (Differentially-Corrected GPS).	NAD83	∅	∅	MST	Y	∅	43.6167527777778	-116.188130555556	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-88160005	USGS	U.S. Geological Survey	88160005	IF Cell Test Site	ST	Stream	16	US	16	Idaho	001	Ada County	170501140403	∅	2736	4.3	NAVD88	Accurate to + or - .1 sec (Differentially-Corrected GPS).	NAD83	∅	∅	MST	Y	∅	43.616425	-116.187938888889	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-88160004	USGS	U.S. Geological Survey	88160004	Boise Cell Test Site	ST	Stream	16	US	16	Idaho	001	Ada County	170501140403	∅	2737	4.3	NAVD88	Accurate to + or - .1 sec (Differentially-Corrected GPS).	NAD83	∅	∅	MST	Y	∅	43.6165777777778	-116.188061111111	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-88160003	USGS	U.S. Geological Survey	88160003	PFO DCP TEST SITE	ST	Stream	16	US	16	Idaho	055	Kootenai County	170103050304	∅	2114	4.3	NAVD88	Accurate to + or - .5 sec (PLGR/PPS GPS).	NAD83	∅	∅	PST	Y	∅	47.7000305555556	-117.008008333333	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-88160002	USGS	U.S. Geological Survey	88160002	IF TEST DCP ID	ST	Stream	16	US	16	Idaho	001	Ada County	170501140403	∅	∅	∅	∅	Accurate to + or - 1 sec.	NAD83	∅	∅	MST	Y	∅	43.6166666666667	-116.186944444444	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-88160001	USGS	U.S. Geological Survey	88160001	IDWSC Standalone Calibrations	ST	Stream	16	US	16	Idaho	001	Ada County	170501140403	∅	∅	∅	∅	Accurate to + or - 5 sec.	NAD27	∅	∅	MST	Y	∅	43.6176671561121	-116.184283214437	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-490025114584501	USGS	U.S. Geological Survey	490025114584501	Blacktail near Roosville MT	ST	Stream	30	US	30	Montana	053	Lincoln County	17010101	∅	∅	∅	∅	Accurate to + or - 1 sec.	NAD27	∅	∅	MST	Y	∅	46.0076943124515	-114.980112196213	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-490002122171601	USGS	U.S. Geological Survey	490002122171601	UNNAMED SPRING IN SENE S33 T41N R04E	SP	Spring	53	US	53	Washington	073	Whatcom County	171100010401	∅	46	20	NGVD29	Accurate to + or - 5 sec.	NAD27	∅	∅	PST	Y	∅	49.0006766912647	-122.288765156906	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-489249122111490	USGS	U.S. Geological Survey	489249122111490	EBEY SLOUGH BELOW I5 NEAR MARYSVILLE, WA	ES	Estuary	53	US	53	Washington	061	Snohomish County	171100110203	∅	0	3	NAVD88	Accurate to + or - 1 sec.	NAD83	∅	∅	PST	Y	∅	48.04697222222222	-122.18747222222223	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485956117375100	USGS	U.S. Geological Survey	485956117375100	COLUMBIA R NEAR INTERNAT BNDRY LB	ST	Stream	53	US	53	Washington	065	Stevens County	170200011202	∅	∅	∅	∅	Accurate to + or - 1 sec.	NAD27	∅	∅	PST	Y	∅	48.9988050007383	-117.631920703454	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485955121042501	USGS	U.S. Geological Survey	485955121042501	ROSS LAKE - NEAR CANADIAN BORDER	LK	Lake, Reservoir, Impoundment	53	US	53	Washington	073	Whatcom County	171100050602	∅	1595	1.6	NAVD88	Accurate to + or - 5 sec.	NAD83	∅	∅	PST	Y	∅	48.9986222222222	-121.0736	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485952117380500	USGS	U.S. Geological Survey	485952117380500	COLUMBIA RIVER AT INTNTL BNDRY RB	ST	Stream	53	US	53	Washington	065	Stevens County	170200011202	∅	∅	∅	∅	Accurate to + or - 1 sec.	NAD27	∅	∅	PST	Y	∅	48.9976937472314	-117.635809780879	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485944115095701	USGS	U.S. Geological Survey	485944115095701	Lake Koocanusa nr Gateway CG, nr Rexford, MT	LK	Lake, Reservoir, Impoundment	30	US	30	Montana	053	Lincoln County	170101010606	∅	2463	10	NAVD88	Accurate to + or - 1 sec.	NAD83	∅	∅	MST	Y	∅	48.99547777777778	-115.16571944444445	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485936122214401	USGS	U.S. Geological Survey	485936122214401	UNNAMED SPRING IN NENW S01 T40N R03E	SP	Spring	53	US	53	Washington	073	Whatcom County	171100010401	∅	147	10	NGVD29	Accurate to + or - 5 sec.	NAD27	∅	∅	PST	Y	∅	48.993174688918	-122.363490955222	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485936115095401	USGS	∅	485936115095401	Lake Koocanusa, upper bench nr 12300110	LK	Lake, Reservoir, Impoundment	30	US	30	Montana	053	Lincoln County	170101010606	∅	2463	10	NAVD88	Accurate to + or - .5 sec (PLGR/PPS GPS).	NAD83	∅	∅	MST	Y	∅	48.9932	-115.165	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485931115101601	USGS	∅	485931115101601	Lake Koocanusa, lower bench nr 12300110	LK	Lake, Reservoir, Impoundment	30	US	30	Montana	053	Lincoln County	170101010606	∅	2463	10	NAVD88	Accurate to + or - .5 sec (PLGR/PPS GPS).	NAD83	∅	∅	MST	Y	∅	48.9919	-115.171	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485927115103401	USGS	∅	485927115103401	Lake Koocanusa, left thalweg nr 12300110	LK	Lake, Reservoir, Impoundment	30	US	30	Montana	053	Lincoln County	170101010606	∅	2463	10	NAVD88	Accurate to + or - .5 sec (PLGR/PPS GPS).	NAD83	∅	∅	MST	Y	∅	48.9908	-115.176	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485921115105901	USGS	∅	485921115105901	Lake Koocanusa, right thalweg nr 12300110	LK	Lake, Reservoir, Impoundment	30	US	30	Montana	053	Lincoln County	170101010606	∅	2463	10	NAVD88	Accurate to + or - .5 sec (PLGR/PPS GPS).	NAD83	∅	∅	MST	Y	∅	48.989200000000004	-115.183	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485918119352600	USGS	U.S. Geological Survey	485918119352600	SIMILKAMEEN R-10	ST	Stream	53	US	53	Washington	047	Okanogan County	170200072009	∅	∅	∅	∅	Accurate to + or - 1 sec.	NAD27	∅	∅	PST	Y	∅	48.9882124516793	-119.591742462768	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485917119343500	USGS	U.S. Geological Survey	485917119343500	SIMILKAMEEN R-11	ST	Stream	53	US	53	Washington	047	Okanogan County	170200072009	∅	∅	∅	∅	Accurate to + or - 1 sec.	NAD27	∅	∅	PST	Y	∅	48.9879347437193	-119.577575387	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485916119355800	USGS	U.S. Geological Survey	485916119355800	SIMILKAMEEN R-9	ST	Stream	53	US	53	Washington	047	Okanogan County	170200072009	∅	∅	∅	∅	Accurate to + or - 1 sec.	NAD27	∅	∅	PST	Y	∅	48.9876568313277	-119.60063158709	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485910119363900	USGS	U.S. Geological Survey	485910119363900	SIMILKAMEEN R-7	ST	Stream	53	US	53	Washington	047	Okanogan County	170200072009	∅	∅	∅	∅	Accurate to + or - 1 sec.	NAD27	∅	∅	PST	Y	∅	48.9859900534408	-119.612020751298	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485910119335300	USGS	U.S. Geological Survey	485910119335300	SIMILKAMEEN R-12	ST	Stream	53	US	53	Washington	047	Okanogan County	170200072009	∅	∅	∅	∅	Accurate to + or - 1 sec.	NAD27	∅	∅	PST	Y	∅	48.9859903087906	-119.565908330737	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804
2026-11-02 07:06:10.726029	USGS-485908119361600	USGS	U.S. Geological Survey	485908119361600	SIMILKAMEEN R-8	ST	Stream	53	US	53	Washington	047	Okanogan County	170200072009	∅	∅	∅	∅	Accurate to + or - 1 sec.	NAD27	∅	∅	PST	Y	∅	48.985434517147	-119.60563166508	2026-11-02 07:06:10.726029	2026-11-02 07:06:18.017804

Coverage

Complete: 12.2%
Gap days: 65
Days with data: 9

Show coverage history

Coverage: 12.2%Days with data: 9Gaps: 65

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.