Hydrologic time-series summary tool

Data upload and analysis options


Overview

You can explore 2 sample datasets and upload your own comma-seperated (.csv) file of daily time-series data. The file should contain dates in column one (format can be specified below) and flow data in column two. A third column can also be included to indicate time periods to be analysed seperately (e.g. "pre-dam","post-dam". Data from multiple gauges or runoff scenarios can also be stacked, with the third column used to indicate the name of the gauge or scenario.


Once the data (including dates) are visible in the Data sample tab (only the head and tail of the file are shown) click on the Summary tab in the main panel.

The help panel includes a detailed description of the options and information that is returned.


Data source



Manual date sequence

Excel can cause issues with dates, particularly those earlier than 1904. If you have issues a starting date can be manually defined by checking the box below and selecting the start date of the sequence from the calendar. This assumes your data contains contiguous dates


Units

Note you may need to reload the page to generate a summary for new files.



Monthly means plot


Low spell analysis details:

The threshold value for examining low flow spells can be set as a percentile or a specific discharge using the options below


High spell analysis details:

The threshold value for examining high flow spells can be set as a percentile or a specific discharge using the options below


Partial series analysis details:

Seasonal analysis

High flows can be analysed seperately for different seasons. The options are:

- None: analysis is done.

- Wet/dry: the cumulative driest and wettest 6-month periods are anlaysed seperately

- Custom: a vector of labels seperated by commas is used to assign each month to a particular season (e.g. 1,1,1,2,2,2,3,3,3,4,4,4 or sum,sum,sum,sum,wetting,wet,wet,wet, wet,wet,drying,sum).




Download Plots

The buttons below allow downloading of files to your local hard drive. Simply right click and select 'Download Linked file' to avoid a new web page from opening.

Download time-series plot Download monthly plot Download Spell Frequency plot Download Annual FDC plot Download Seasonal FDC plot

Developer notes

This Shiny app was developed by Nick Bond, Griffith University. See the hydrostats R Package (http://cran.r-project.org/web/ packages/hydrostats/index.html) for more details about the underlying statistics that are returned, and contact Nick Bond at n.bond@griffith.edu.au for more information or bug reporting.


Background

This tool provides a rapid means of summarising hydrologic time series data based on a suite of graphical and statistical summaries that are widely used in hydrology. Details of the summary metrics and various options are provided on the help page (last tab) and in the options panel to the left of the page.


Several example datasets are provided, and these can be selected and viewed on the second tab to see how data should be formatted.The Barham River dataset includes a 'factor' variable demonstrating how to split the dataset into multiple time periods, each of which is analysed seperately.


Data from multiple gauges or runoff scenarios can also be analysed simultaneously by stacking the time series in long-format in Excel or similar, with a third column used to indicate the name of the gauge (or scenario).


The tables and plots will update dynamically as a different sample dataset is selected, new data are uploaded, or different options are selected.


Running an analysis

The mains steps are:


1. Select whether to examine one of the sample datasets or upload your own data in the left panel

2. Select a sample dataset or file to upload. Note that the tool can deal with missing data but some form of infilling is recommended

3. Check the data in the Data Sample tab, adjusting the date format until Dates are visible.

4. Switch to the Data Summary tab

5. Select appropriate options for your analysis using options in the left panel

6. Each plot can be downloaded using the buttons at the bottom of the left panel. Tables can also be copied and pasted directly into word processing software.


Developer details:

The tool was developed by Nick Bond (n.bond@griffith.edu.au) using R and packages Shiny, hydrostats and ggplot


File Name



File Name


Time-series plot


Summary statistics


Monthly means


Monthly baseflow means


Monthly means plot


Cease-to-flow spells


Low spell statistics


Annual low spell statistics


High spell statistics


Annual high spell statistics


Partial series


High spell frequency vs duration


Annual flow duration curve (FDC)


Seasonal Periods


Seasonal High spell statistics


Seasonal flow duration curve


File Name

The name of the file that was uploaded


Time-series plot

Plot of the time-series


Summary statistics

Basic summary information, including start and end dates, min, mean, median and maximum flows.


Monthly means

Table of mean monthly flows


Monthly means plot

Plot of mean monthly flows. By ticking the 'include baseflow panel' in the sidebar, the plot includes a second panel showing mean flow on days that are dominated by baseflow (defined as days on which the baseflow index (calculated using the Lynne-Hollick (LH) Filter (a=0.975) is >0.9. This can be useful in understanding streamflow patterns in highly flashy systems


Cease-to-flow spells

Cease to flow statistics:

p.CTF Fraction time cease to flows occur

avg.CTF Average cease-to-flow spell duration

med.CTF Median cease-to-flow spell duration

min.CTF Minimum cease-to-flow spell duration

max.CTF Maximum cease-to-flow spell duration


Low spell statistics

ls.threshold The low spell threshold applied in the analysis

min.ls.duration Minimum duration of spell events

avg.ls.duration Average duration of spell events

med.ls.duration Median duration of spell events

max.ls.duration Maximum duration of spell events

ls.freq The frequency of spell events (no. per year)


Annual low flow statistics

avg.min.ann The average annual minimum flow

cv.min.ann The coefficient of variation of annual minimum flows

ann.min.timing The average day of the year (0-366) on which the minimum flow(s) occur

ann.min.timing.sd circular standard deviation of the average timing of annual minimum flows


High spell statistics

hs.threshold The high spell threshold applied in the analysis

n.events The number of events in the series greater than or equal to the high.spell.threshold

spell.freq The frequency of spell events (no. per year)

ari Average Recurrence Interval of events in years (1/spell.freq)

min.hs.duration Average duration of spell events

avg.hs.duration Average duration of spell events

med.hs.duration Median duration of spell events

max.hs.duration Maximum duration of spell events

avg.spell.peak Average spell peak

sd.spell.peak Standard deviation of spell speaks

avg.rise Average absolute rate of daily rise during spell events

avg.fall Average absolute rate of daily fall during spell events


Annual high spell statistics

avg.max.ann The average annual maximum flow

cv.max.ann The coefficient of variation of annual maximum flows

flood.skewness The average annual maximum / mean daily flow

ann.max.timing The average day of the year (0-366) on which maximum flows occur

ann.max.timing.sd circular standard deviation of the average timing of annual maximum flows

avg.ann.duration The average duration of the annual maximum spells

cv.ann.duration The coefficient of variation of the duration of annual maximum spells


Partial series statstics

n.years The number of years in the partial series

n.events The number of events in the partial series

flow.threshold The peak volume of the smallest event in the partial series

avg.duration The average duration of events in the series

max.duration The maximum duration of events in the series


Spell frequency vs duration

A plot showing the frequency vs duration of events above a user defined threshold (percentile or magnitude)


Flow duration curve

Flow duration curve


Seasonal Periods

A table indicating the allocation of individual months to intra-annual periods defined for seasonal analyses (NULL if not defined).


Seasonal High spell statistics

As for the high spell statistics, but defined seperately for individual seasons


Seasonal flow duration curve

Seasonal flow duration curve