Hydrologic Database (HDB) Data Query

The Bureau of Reclamation makes efforts to maintain the accuracy of data found in the HDB system databases but the data is largely unverified and should be considered preliminary and subject to change. Data and services are provided with the express understanding that the United States Government makes no warranties, expressed or implied, concerning the accuracy, completeness, usability, or suitability for any particular purpose of the information or data obtained by access to this computer system. The United States shall be under no liability whatsoever to any individual or group entity by reason of any use made thereof. Please contact the developer if you have any questions regarding this service.

1. Select your desired HDB:
Lower Colorado Regional Office
Upper Colorado Regional Office
Eastern Colorado Area Office
Yuma Area Office
Lahontan Basin Area Office
Klamath Basin Area Office
Pacific Northwest Regional Office
Great Plains Regional Office
2. Input your desired Site-Datatype ID (SDI) number(s), start typing to filter the list of available SDIs, or select from the drop-down list:
Separate multiple ID numbers with commas and no spaces. (Ex: 1234,5678,...)
3. Select your desired data frequency:
Instantaneous   Hourly   Daily   Monthly  
4. Select your desired date range (YYYY-MM-DD hh:mm):
From To
5. Select your desired data type:
Observed   Modeled, Model Run ID =
6. Select your desired output format:
WebPage   CSV   HTML Table   JSON   Interactive Graph

Web Service Information

SAMPLE REQUEST
https://www.usbr.gov/pn-bin/hdb/hdb.pl?svr=lchdb&sdi=1863&tstp=DY&t1=2018-05-26T00:00&t2=2018-06-25T00:00&table=R&mrid=0&format=table
REQUIRED ARGUMENTS
svr - either lchdb, uchdb2, yaohdb, ecohdb, lbohdb, kbohdb, pnhyd, or gphyd for the Lower Colorado Regional Office, Upper Colorado Regional Office, Yuma Area Office, Eastern Colorado Area Office, Lahontan Basin Area Office, Klamath Basin Area Office HDBs, or the Pacific Northwest Regional Office or Great Plains Regional Office Hydromets respectively
sdi - separate multiple Site Datatype IDs (sdi) with a comma
tstp - IN, HR, DY, MN to query instantaneous, hourly, daily, or monthly data
t1 & t2 - start and end date in MM-DD-YYYY (01-01-1980) or YYYY-MM-DDTHH:mm (1980-01-01T13:00) format. You may alternatively set these to integers to get data using a timestep offset from today (Ex: If querying daily data and t1=-7 and t2=0, this will query the last 7-day's worth of data)
format - csv, table, json, or graph
OPTIONAL ARGUMENTS
table - either R or M to specify whether to query observed or modeled data (defaults to R if not specified)
mrid - required integer Model Run ID (mrid) if table=M

Please contact Jon Rocha via e-mail at jrocha@usbr.gov to report bugs or for questions and information regarding this service.