USACE Feed: Flood Control Requirements for California Reservoirs

[narlesky]

Data Source

USACE-SPK daily report on "Flood Control Requirements for California Reservoirs"
https://www.spk-wc.usace.army.mil/fcgi-bin/midnight.py?days=0&report=FCR

Use Case

Extract the Oroville wetness parameter for initializing model simulations. Extract the Folsom forecast volumes for validation against CNRFC forecast summary calcs.

Task

• Develop method to construct the URL given a particular date.
• Download raw text data
• Develop methods for parsing each hydrologic area (prioritize Sacramento Valley)
• Develop method to extract metadata from report page
• Next phase: develop method to collect this report over a range of days and return timeseries in pandas.DataFrame format

Testing Goals

Develop test functions for current day, and fixed date in past (will need to calc day count to get back to a fixed date, so we can validate the values in the report against a fixed set of test values).

Breaking Changes

None expected