ORSANCO Database

The database for the ORSANCO Project will be called ORSANCO. It will contain 3 tables. They are called CrossSections and RiverFlows

CrossSections

index datatype:(text)- This is the Partition Key it is a combination of River, Reach, and Station.\ River datatype:(text)- This is the name of the river.\ Reach datatype:(text)- This is the Reach of the River.\ X datatype:(double)- this is the X-Coordinate from the GIS file.\ Y datatype:(double)- this is the Y-Coordinate from the GIS file.\

The projection for the X and Y coordinates are Albers Equal Area, NGVD88 and NAD 83 it is in feet.

RiverFlows

UnixTime datatype:(bigint) - Unix timestamp.\ id datatype:(text)- This is a combination of River, Reach, and Station.\ Flow datatype:(double) - This is the flow value.\ Velocity datatype:(double) - This is the velocity value.\

DailyRiverFlows

UnixTime datatype:(bigint) - Unix timestamp.\ id datatype:(text)- This is a combination of River, Reach, and Station.\ Flow datatype:(double) - This is the flow value.\ Velocity datatype:(double) - This is the velocity value.\

This is the same as River Flows only instead of every timestep we average all timestamps over the day.