Historical observation data format instructions
Please provide observation data in a columnar format with one column for the date, or date and time if applicable, and one or more columns for flow. If the data is at a sub-daily frequency, both the date and time should be in the same column.
Please provide all the observations for a single site in one file. Please do not, for example, provide each month of data in a different file. If there are multiple sites, there can be one file per site, or one file for multiple sites. If there is more than one file, please make sure the formatting for all of the files is consistent.
Formatting the data in this way will allow us to set your dashboard and forecasts up and running quickly. Thank you!
Example 1: Daily data, one basin.
| date | Basin 1 (cms)* |
| 2010-01-01 | 20 |
| 2010-01-02 | 22 |
| 2010-01-03 | 23 |
| 2010-01-04 | 23 |
| … | … |
Units can be provided in the file, or you can provide them to us separately.
Example 2: Hourly data, two basins, one file.
| datetime | Basin 1 (cfs) | Basin 2 (cfs) |
| 2010-01-01T00:00:00 | 20 | 50 |
| 2010-01-01T01:00:00 | 22 | 56 |
| 2010-01-01T02:00:00 | 23 | 57 |
| 2010-01-01T03:00:00 | 23 | 54 |
| … | … | … |
Example 3: Hourly data, two basins, two files.
| datetime | Basin 1 |
| 2010-01-01T00:00:00 | 20 |
| 2010-01-01T01:00:00 | 22 |
| 2010-01-01T02:00:00 | 23 |
| 2010-01-01T03:00:00 | 23 |
| … | … |
| datetime | Basin 2 |
| 2010-01-01T00:00:00 | 50 |
| 2010-01-01T01:00:00 | 56 |
| 2010-01-01T02:00:00 | 57 |
| 2010-01-01T03:00:00 | 54 |
| … | … |