# Chapter 12 Flood Frequency Analysis and Creating Functions

## 12.1 Template Repository

The following activity is available as a template github repository at the following link: https://github.com/VT-Hydroinformatics/11-Flood-Frequency-and-Functions

## 12.2 Introduction

This methods for this chapter are adapted from the following activity: https://serc.carleton.edu/hydromodules/steps/166250.html

After working with Flow Duration Curves (FDCs) and performing a low flow analysis, we now understand all the concepts necessary to perform a flood frequency analysis. In this chapter we will perform a flood frequency analysis using a Gumbel extreme value distribution and then write our own function that will return the return interval of magnitude flow we want! At the end of the chapter you will be challenged to write a function that performs a flood frequency analysis for any USGS gage.

First we will load the tidyverse and dataRetrieval packages and the set the theme for our plots.

library(tidyverse)
library(dataRetrieval)

theme_set(theme_classic())

Next, download the yearly peakflow data from USGS dataRetrieval using the readNWISpeak() function. We don’t have to create our own yearly values like we did in the low flow analysis. This function just returns the highest flow for each year.

Then make a plot of the peak flow for each year.

radford <- "03171000"

ggplot(peakflows, aes(peak_dt, peak_va))+
geom_point() ## 12.4 Compute ranks for peak flows

As with the couple previous chapters, the next step is to create a column that contains the ranks of each flow in the record. Create a column that has the rank of each flow, with the highest flow ranked #1. Use select() to trim your dataset to just the peak data, peak values, and ranks columns.

Make the plot from the last code chunk again but color the points by rank to check that this worked. Also, look at the data through the environment tab in rstudio or using head() to double check.

#create rank column (minus flips the ranking)
#then clean it up, pull out only peak value, date, rank
peakflows <- peakflows %>% mutate(ranks = rank(-peak_va)) %>%
select(peak_dt, peak_va, ranks)

#look at it
ggplot(peakflows, aes(peak_dt, peak_va, color = ranks))+
geom_point() head(peakflows)
##      peak_dt peak_va ranks
## 1 1945-09-18   62700  14.0
## 2 1946-01-08   44400  34.0
## 3 1947-01-20   34500  48.5
## 4 1948-02-14   34500  48.5
## 5 1949-08-29   40800  38.0
## 6 1949-11-02   15200  73.0

## 12.5 Calculate exceedance probability and return period

Now we need to calculate the exceedance probability and return interval for each value in our data. For flood frequency analysis, it is common to use the Gringorten plotting position formula: Plotting Position Formula

qi = Exceedance probability

N = Number of observations in your record

i = Rank of specific observation, i = 1 is the largest, i = N is the smallest.

a = constant for estimation = 0.44

$$Non-exceedence probability = pi = 1 - qi$$

Return period

$$Tp = 1/(1-p)$$

In the chunk below, create a column in your dataset and calculate each: exceedance probability, non-exceedane probabily, and return period.

Then make a plot with peak flow on the Y axis and Return Period on the X.

N <- length(peakflows$peak_dt) a <- 0.44 #calculate exceedence/non-exceedence with gringorten and return period peakflows <- peakflows %>% mutate(qi = (ranks - a) / (N + 1 - (2*a))) %>% mutate(pi = 1 - qi) %>% mutate(TpEst = 1 / (1-pi)) #Plot peak flows on y and est return period on the x peakflows %>% ggplot(aes(x = TpEst, y = peak_va)) + geom_point() ## 12.6 Calculate Gumbel distribution parameters Now we need to fit these data to a distribution in order to make a relationship we can use to predict the discharge of specific return intervals. There are many distributions that can be used in this situation, but a common one for flood frequency analyses is the Gumbel extreme value distribution: Gumbel Distribution x is observed discharge data, u and alpha are parameters that shape the distribution. We can calculate u and alpha in order to create a distribution that best fits our data with the following equations. Notice x bar is mean and sx2 is variance. We will need to find sx, which is the square root of the variance, also known as the standard deviation. Gumbel parameters In the chunk below, calculate u and alpha by first calculating xbar (mean) and sx (standard deviation) and then using them in the above equations for u and x. xbar <- mean(peakflows$peak_va)

sx <- sd(peakflows\$peak_va)

alpha <- (sqrt(6)*sx) / pi

u <- xbar - (0.5772 * alpha)

## 12.7 Calculate return interval for peak flows according to Gumbel distribution

Now that we have the parameters that best represent our data as a Gumbel Distribution, we can use the formula to create the theoretical values for the return interval according to that distribution. Gumbel Distribution

In the chunk below:

First calculate p theoretical with the equation above.

Then calculate Tp theoretical (the return period) as T was calculated above Tp = 1 / (1-p)

Finally create a plot of return period on the x axis and peak values on the y. Include return periods calculated from your data and those calculated from the Gumbel distribution on your plot as points of different colors.

peakflows <- peakflows %>% mutate(pTheoretical =
exp(-exp(-((peak_va - u) / alpha)))) %>%
mutate(TpTheoretical = (1 / (1-pTheoretical)))

peakflows %>% ggplot(aes(x = TpEst, y = peak_va, color = "Estimated")) +
geom_point()+
geom_point(aes(x = TpTheoretical, y = peak_va, color = "Theoretical"))+
ylab("Annual Peak Flows")+
xlab("Return Period")+
theme_classic() ## 12.8 Plot Gumbel distribution fit with peak flow data

Let’s look at these data a slightly different way to make it easier to see what is going on and how we can pull of flows for different return periods.

Make the same plot as abote but show the theoretical values (from the distribution) as a line, with the estimated values as points, and log the x axis with limits set to 1 - 100.

With this plot you could look up the return period for any flood or the discharge level for any return period.

peakflows %>% ggplot(aes(x = TpEst, y = peak_va, color = "Estimated")) +
geom_point()+
geom_line(aes(x = TpTheoretical, y = peak_va, color = "Theoretical"))+
ylab("Annual Peak Flows")+
xlab("Return Period")+
scale_x_log10(limits = c(1,100))+
theme_classic()
## Warning: Removed 1 rows containing missing values (geom_point). ## 12.9 Calculate magnitude of 1 in 100 chance flood

This plot is showing a representation of the fitted distribution by calculating the return period for each point in our dataset. But we can also use it to calculated the specific flow that corresponds to any return period by using the established relationship.

In the chunk below, calculate the magnitude of a 1 in 100 chance, or 100 year flood using the following two formulas where p = exceedance probability and Tp = return period. These are just the equations used to calculate return period rearranged to calculate peak flow.

$$p = Tp / (Tp - 1)$$

$$peakflow = u - (alpha * log(log(p)))$$

According to this analysis, what is the 1 in 100 chance flood at this location? Do you see any issues with reporting this as the 1 in 100 chance flood? What are they?

Tp = 100

p = Tp / (Tp - 1)

peak_va = u - (alpha * log(log(p)))

## 12.10 How to create your own functions

This is a good opportunity to illustrate the usefulness of writing your own functions. When you install packages in R, you get a bunch of functions you can use. But you can also create these on your own to simplify your analyses!

You do this with the following syntax

MyNewFunction <- function(param1, param2){

code

}

Whatever the last line of the “code” portion of the function spits out, gets returned from the function. So if you said X <- mynewfunction(param1, parm2) X would now have in it whatever your function returned. See a simple example below: a function that adds 1 to any number we pass to it.

add1 <- function(number){
number + 1
}

add1(4)
##  5

## 12.11 Create a return period function

Let’s create a function that returns the return period for a flood of any magnitude for the gage we are investigating. Creating functions is a great way to streamline your workflow. You can write a function that performs an operation you need to perform a bunch of times, then just use the function rather than re-writing/copying the code.

Our function will be called “ReturnPeriod” and we will pass it the flow we want the return period for, and the u and alpha of the distribution.

We will test the function by having it calculate the return period for the 100 year flood we calculated earlier (120027). If it works, it should spit out 100.

ReturnPeriod <- function(flow, u, alpha){

pTheoretical = exp(-exp(-((flow - u) / alpha)))
TpTheoretical = (1 / (1 - pTheoretical))

TpTheoretical
}

ReturnPeriod(120027, u, alpha)
##  99.99898

## 12.12 Challenge: Create a function to compute the 1 in 100 chance flood for any USGS gage

Create a function that returns the magnitude of the 100 year flood when given a USGS gage id, startdate, and enddate for the period you want to investigate.