Ask the Grid
Open live grid

USGS Gauge Registry

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

USGSInfrastructure dataERCOT marketCAISO marketNYISO marketPJM marketSPP marketMISO marketISO-NE market
Query with the agent
Native record
snapshot x site
weekly publication cadence
Evidence
Reference data
Stable context used to interpret other datasets
Time basis
Point-in-time records
UTC · event_time

Overview

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

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

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.

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

Schema30

Column
Type
event_timeDateTime64(6, 'UTC')
location_idLowCardinality(String)
agency_codeNullable(String)
agency_nameNullable(String)
monitoring_location_numberNullable(String)
monitoring_location_nameNullable(String)
site_type_codeNullable(String)
site_typeNullable(String)
district_codeNullable(String)
country_codeNullable(String)
state_codeNullable(String)
state_nameNullable(String)
county_codeNullable(String)
county_nameNullable(String)
hydrologic_unit_codeNullable(String)
basin_codeNullable(String)
altitudeNullable(Float64)
altitude_accuracyNullable(Float64)
vertical_datumNullable(String)
horizontal_positional_accuracyNullable(String)
original_horizontal_datumNullable(String)
drainage_areaNullable(Float64)
contributing_drainage_areaNullable(Float64)
time_zone_abbreviationNullable(String)
uses_daylight_savingsNullable(String)
construction_dateNullable(String)
latitudeNullable(Float64)
longitudeNullable(Float64)
source_timeDateTime64(6, 'UTC')
ingested_atDateTime64(6, 'UTC')

Sample data

event_timelocation_idagency_codeagency_namemonitoring_location_numbermonitoring_location_namesite_type_codesite_typedistrict_codecountry_codestate_codestate_namecounty_codecounty_namehydrologic_unit_codebasin_codealtitudealtitude_accuracyvertical_datumhorizontal_positional_accuracyoriginal_horizontal_datumdrainage_areacontributing_drainage_areatime_zone_abbreviationuses_daylight_savingsconstruction_datelatitudelongitudesource_timeingested_at
2026-09-14 07:00:05.563561USGS-05487880USGSU.S. Geological Survey05487880White Breast Creek near Lacona, IASTStream19US19Iowa117Lucas County071000081402∅∅∅∅Unknown or unspecified.NAD27∅∅CSTY∅41.1605527450004-93.35159932927382026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487825USGSU.S. Geological Survey05487825Little White Breast Creek Trib near Chariton, IASTStream19US19Iowa117Lucas County071000081305∅∅∅∅Accurate to + or - 5 sec.NAD270.05∅CSTY∅41.0599989888056-93.30437603076882026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487810USGSU.S. Geological Survey05487810White Breast Creek near Lucas, IASTStream19US19Iowa117Lucas County071000081306∅∅∅∅Unknown or unspecified.NAD27∅∅CSTY∅41.0572209561271-93.41160057658122026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487800USGSU.S. Geological Survey05487800White Breast Creek at Lucas, IASTStream19US19Iowa117Lucas County071000081304∅∅∅∅Unknown or unspecified.NAD27128∅CSTY∅41.0233324903393-93.46576838093812026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487770USGSU.S. Geological Survey05487770Brush Creek near Lucas, IASTStream19US19Iowa117Lucas County071000081303∅∅∅∅Accurate to + or - .5 sec (PLGR/PPS GPS).NAD83∅∅CSTY∅41.0186111111111-93.50611111111112026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487700USGSU.S. Geological Survey05487700White Breast Creek near Woodburn, IASTStream19US19Iowa039Clarke County071000081304∅∅∅∅Unknown or unspecified.NAD2782.9∅CSTY∅40.9766658636856-93.5874379972712026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487695USGSU.S. Geological Survey05487695White Breast Creek UPS RM S WBC near Woodburn, IASTStream19US19Iowa039Clarke County071000081302∅∅∅∅Unknown or unspecified.NAD27∅∅CSTY∅40.9755545078848-93.6146608540952026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487600USGSU.S. Geological Survey05487600South White Breast Creek near Osceola, IASTStream19US19Iowa039Clarke County071000081301∅∅∅∅Unknown or unspecified.NAD2728∅CSTY∅40.9599984973969-93.69132942477572026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487550USGSU.S. Geological Survey05487550Walnut Creek near Vandalia, IASTStream19US19Iowa099Jasper County07100008150509785.150.01NGVD29Accurate to + or - .1 sec (Differentially-Corrected GPS).NAD8320.3∅CSTY∅41.5370277777778-93.25897222222222026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487540USGSU.S. Geological Survey05487540Walnut Creek near Prairie City, IASTStream19US19Iowa099Jasper County071000081505∅826.330.01NGVD29Accurate to + or - 1 sec.NAD276.78∅CSTY∅41.6008505249778-93.29598503849392026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487520USGSU.S. Geological Survey05487520Des Moines River near Swan, IASTStream19US19Iowa125Marion County07100008150709698.990.26NAVD88Accurate to + or - 5 sec.NAD8311700∅CSTY∅41.4893888888889-93.27822222222222026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487500USGSU.S. Geological Survey05487500Des Moines River near Runnells, IASTStream19US19Iowa153Polk County071000081507∅7000.01NGVD29Accurate to + or - 5 sec.NAD2711655∅CSTY∅41.4886016385637-93.33826471842632026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487470USGSU.S. Geological Survey05487470South River near Ackworth, IASTStream19US19Iowa181Warren County071000081201∅769.840.13NAVD88Accurate to + or - 5 sec.NAD83460∅CSTY∅41.3378888888889-93.48641666666672026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487450USGSU.S. Geological Survey05487450Otter Creek near Milo, IASTStream19US19Iowa181Warren County071000081004∅∅∅∅Unknown or unspecified.NAD27155∅CSTY∅41.2838834405993-93.4860468382592026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487400USGSU.S. Geological Survey05487400Otter Creek near Norwood, IASTStream19US19Iowa117Lucas County071000081003∅∅∅∅Unknown or unspecified.NAD27102∅CSTY∅41.1499966401444-93.53354786746662026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487350USGSU.S. Geological Survey05487350South Otter Creek Tributary near Woodburn, IASTStream19US19Iowa039Clarke County071000081001∅∅∅∅Unknown or unspecified.NAD270.71∅CSTY∅41.0466645404738-93.59077127047132026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487300USGSU.S. Geological Survey05487300South Otter Creek near Woodburn, IASTStream19US19Iowa039Clarke County071000081001∅∅∅∅Unknown or unspecified.NAD272.26∅CSTY∅41.0333308969593-93.65021707241362026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487200USGSU.S. Geological Survey05487200South River near Indianola, IASTStream19US19Iowa181Warren County071000081201∅∅∅∅Unknown or unspecified.NAD27278∅CSTY∅41.3333264385186-93.58354943123132026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487100USGSU.S. Geological Survey05487100West Creek near Indianola, IASTStream19US19Iowa181Warren County071000080804∅∅∅∅Unknown or unspecified.NAD27134∅CSTY∅41.299993615-93.60021647785242026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05487000USGSU.S. Geological Survey05487000Lake Ahquabi near Indianola, IALKLake, Reservoir, Impoundment19US19Iowa181Warren County071000080804∅∅∅∅Unknown or unspecified.NAD274.93∅CSTY∅41.2936048781561-93.59354962136082026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05486900USGSU.S. Geological Survey05486900West Creek near Jamison, IASTStream19US19Iowa039Clarke County071000080803∅∅∅∅Unknown or unspecified.NAD2760.8∅CSTY∅41.1333286597321-93.73355267176922026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05486700USGSU.S. Geological Survey05486700South River near New Virginia, IASTStream19US19Iowa181Warren County071000080902∅∅∅∅Unknown or unspecified.NAD2765.4∅CSTY∅41.2166607444606-93.73355294271172026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05486490USGSU.S. Geological Survey05486490Middle River near Indianola, IASTStream19US19Iowa181Warren County071000080701∅775.940.13NAVD88Accurate to + or - 5 sec.NAD83489.4∅CSTY∅41.4243611111111-93.58730555555552026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05486400USGSU.S. Geological Survey05486400Middle River at Martensdale, IASTStream19US19Iowa181Warren County071000080701∅∅∅∅Unknown or unspecified.NAD27451∅CSTY∅41.3666585661854-93.73355372476932026-09-14 07:00:05.5635612026-09-14 07:00:50.223856
2026-09-14 07:00:05.563561USGS-05486350USGSU.S. Geological Survey05486350Clanton Creek near Martensdale, IASTStream19US19Iowa181Warren County071000080505∅∅∅∅Unknown or unspecified.NAD27159∅CSTY∅41.3499920656113-93.75022075816662026-09-14 07:00:05.5635612026-09-14 07:00:50.223856

Coverage

8.0% complete23 gap days2 days with data
Show coverage history
Coverage: 8.0%Days with data: 2Gaps: 23
2026
gaplessmore