Dreamflows CSV Info Page
"I can't boat everyday, but I can always Dream"
Home River Flows Bulletin Board Custom Email Reports Alerts Signup Login Help Search

Dreamflows flow reports in CSV format are intended for loading into third-party application software like spreadsheets and databases.  CSV stands for comma-separated values.  The Dreamflows CSV format is simple.  Each field on a data line is separated by a comma.  Text fields (which may include a comma) are surrounded by double quotes.  The first six lines in the CSV file are general information (five lines of text plus one blank line). 

The following (seventh) line holds header information, i.e. it specifies which data field holds what kind of data.  The remaining lines (i.e. line 8 onwards) are flow data, organized as follows:

The Dreamflows river id.  This is the three-digit identifier that Dreamflows uses internally to identify a given flow site, e.g. 075.  See the Dreamflows RiverId file for a list of currently-reported riverId values.

The Dreamflows river name corresponding to RiverId, surrounded by double quotes (e.g. "So. American").

The Dreamflows place name corresponding to RiverId, surrounded by double quotes (e.g. "At Chili Bar").

The date the data was captured, in ISO format (yyyy-mm-dd).  Therefore, 2006-06-05 is June 5, 2006.

A value of davg means the data is a daily average (usually the case if the data was derived in some way from reservoir storage).  Otherwise, this field contains the time the data was captured, in ISO format (HH:MM).  This is a 24-hour format, so 10:15 is 10:15 AM, while 22:15 is 10:15 PM. 

Confidence and Deviation:
An indication of the quality of the data.  Confidence values are:
GageGauge quality (presumed to be accurate).
Numeric valueThe percentage confidence that the actual flow is within Deviation percent of reported.  See Note 1 on the Realtime report.
ResvDerived from reservoir calculations - see Note 2 on the Realtime report.
RateDerived from a rating table - see Note 3 on the Realtime report.
SchdScheduled release - see Note 4 on the Realtime report.
PredUnofficial prediction - see Note 5 on the Realtime report.
UnknConfidence is unknown (treat this estimate with suspicion).

RiverFlow and FlowUnit:
Together these give the river flow, at Date and Time, and the unit of measurement, e.g. 1025 cfs (1,025 cubic feet per second).

The computed instantaneous rate of change of RiverFlow.  A positive value means it's rising, negative means it's falling, while zero means it's holding steady.  An empty field means slope wasn't calculated for this flow site.

RiverGage and GageUnit:
Together these give the gauge height, at Date and Time, and the unit of measurement, e.g. 10.25 ft (10.25 feet) or 19 in (19 inches).

WaterTemp and TempUnit:
Together these give the water temperature, at Date and Time, and the unit of measurement, e.g. 51 F (51 degrees Fahrenheit).

This shows how Dreamflows color-coded this RiverFlow/RiverGage entry on the report:
FlowNaUnknown (color-coded silver).
FlowFzRiver is frozen (color-coded blue).
FlowLoFlow is low (color-coded yellow).
FlowOkFlow is good (color-coded green).
FlowPfFlow is optimum (color-coded green and marked ).
FlowHiFlow is high (color-coded red).

A snippet from a sample CSV format report might look like this:

Title: Dreamflows Realtime Report for California and Nevada.
Generated: 2008-02-19 18:56 PDT.
Data format: see http://www.dreamflows.com/csv.php for details.
See http://www.dreamflows.com/flows.php for disclaimer and other useful information.
See http://www.dreamflows.com/csvConvert.php to load this data into Microsoft Excel etc.

162,"No. Smith","At Gasquet",2008-02-19,16:45,85,15,1368,cfs,6,,,,,FlowPf
163,"Mi. Smith","At Gasquet",2008-02-19,16:45,84,15,752,cfs,3,,,,,FlowOk
164,"So. Smith","Near Hiouchi",2008-02-19,17:45,90,15,1928,cfs,8,,,,,FlowOk
524,"Smith","Steel Pipe At Gasquet",2008-02-19,08:00,,,,,,10.00,ft,42,F,FlowNa
258,"Smith","At Oregon Hole Gorge",2008-02-19,17:45,90,20,2252,cfs,10,,,,,FlowPf
001,"Smith","At Jedediah Smith",2008-02-19,17:45,,,4180,cfs,18,9.15,ft,,,FlowPf

Please contact chris@dreamflows.com if you have questions or comments about this page.

Sponsored by:   Otter Bar Lodge
  DeRiemer Adventure Kayaking
  Northwest Rafting Company
  Mariah Wilderness Expeditions
  Sierra Rescue - Expert Swiftwater Rescue Instruction
  The River Store