HDB Online Data Query Tool

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.

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 via e-mail at bor-sha-lcb-wmis@usbr.gov to report bugs or for questions and information regarding this service.