Annual Banding Report

updated 3/26/2019 by Lindsay Carlson lgcarlson@aggiemail.usu.edu

Instructions: You will need to install the packages above for this document to work. This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.

When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. To run one code chunk at a time, press the green arrow on the right hand side. Chunks must be run in order. To run everything above the current chunk, press the down arrow with the green bar underneath.

If you save this markdown file in the same folder as the dataset, it will automatically read in the data without setting a working directory.

All-time banding data

Important: This file should be fully reproducible each year, so long as the column names are not changed. You can update the file “osbornelab_bandrecords_through2019.csv”, save it in the same folder, then change the call name in read csv (i.e.,read.csv(osbornelab_bandrecords_through2020.csv)).

tbands<-read.csv("osbornelab_bandrecords_through2019.csv",header=T)
#head(tbands)
#str(tbands)
tbands<-as.data.frame(tbands)

Create a new column called “propowner” which will be used as a filter variable later on.

Summary Statistics

These summary statistics will be useful for creating annual reports of banding totals. When package ‘gt’ is released, it might be useful to automate these tables, but for now you’ll have to export them to a csv and copy/paste or enter into word by hand.

All time total for number of bands by banding location.

## # A tibble: 15 x 2
##    location     n
##    <fct>    <int>
##  1 WODW      3212
##  2 NGLORY    2928
##  3 CARMICAL  2664
##  4 SIL_CAMP  1513
##  5 MAX_BB    1072
##  6 LACOTTS    480
##  7 CSTONE     453
##  8 LOSTISLE   248
##  9 PWINGS     232
## 10 7DEVILS    202
## 11 LeadFork   182
## 12 DDF        143
## 13 FISHPOND    71
## 14 FairOaks    13
## 15 LAKE         9

Number of bands by species. Number of bands by sex.

## # A tibble: 15 x 2
##    species     n
##    <fct>   <int>
##  1 ABDU        5
##  2 AGWT      765
##  3 AMCO      132
##  4 AMWI       21
##  5 BWTE       16
##  6 GADW      230
##  7 HOME        6
##  8 HYBR        5
##  9 LESC        9
## 10 MALL    10968
## 11 MBDH        3
## 12 NOPI       93
## 13 NSHO       28
## 14 RNDU       34
## 15 WODU     1107
## # A tibble: 4 x 2
##   sex       n
##   <fct> <int>
## 1 ""        2
## 2 F      3582
## 3 M      9704
## 4 U       134

Number of bands by year: Table and Histogram.

## # A tibble: 6 x 2
##   band_year     n
##       <int> <int>
## 1      2014   130
## 2      2015   835
## 3      2016  1526
## 4      2017  3392
## 5      2018  4830
## 6      2019  2709

Most recent year only

To calculate the most recent year’s totals, just change the year in question in the subset command.

## # A tibble: 10 x 2
##    location     n
##    <fct>    <int>
##  1 WODW       521
##  2 LACOTTS    480
##  3 CSTONE     453
##  4 CARMICAL   431
##  5 LOSTISLE   248
##  6 PWINGS     232
##  7 LeadFork   182
##  8 SIL_CAMP   118
##  9 NGLORY      31
## 10 FairOaks    13
## # A tibble: 12 x 2
##    species     n
##    <fct>   <int>
##  1 MALL     1870
##  2 AGWT      341
##  3 WODU      250
##  4 GADW      120
##  5 NOPI       69
##  6 NSHO       18
##  7 BWTE       16
##  8 AMWI       15
##  9 ABDU        3
## 10 AMCO        3
## 11 RNDU        3
## 12 HOME        1

Summary By Landowner

Maxwell

Properties belonging to Maxwell include 7DEVILS, MAX_BB, and NGLORY.

## # A tibble: 12 x 2
##    species     n
##    <fct>   <int>
##  1 ABDU        1
##  2 AGWT        4
##  3 AMCO      129
##  4 AMWI       15
##  5 GADW       19
##  6 HOME        3
##  7 HYBR        1
##  8 MALL     3845
##  9 MBDH        1
## 10 NOPI        5
## 11 NSHO        9
## 12 WODU      170
## # A tibble: 6 x 2
##   band_year     n
##       <int> <int>
## 1      2014   130
## 2      2015   826
## 3      2016   605
## 4      2017  1541
## 5      2018  1069
## 6      2019    31

Carmical

Properties belonging to Carmical include CARMICAL (homestead), LACOTTS, and PWINGS. Other properties may be referred to as “Price” and “Firehunt” but those are all lumped with CARMICAL. LACOTTS and PWINGS are new for 2019.

## # A tibble: 10 x 2
##    species     n
##    <fct>   <int>
##  1 ABDU        2
##  2 AGWT      239
##  3 AMWI        4
##  4 BWTE        3
##  5 GADW      122
##  6 MALL     2902
##  7 NOPI       70
##  8 NSHO       19
##  9 RNDU        6
## 10 WODU        9
## # A tibble: 4 x 2
##   band_year     n
##       <int> <int>
## 1      2016   583
## 2      2017  1367
## 3      2018   283
## 4      2019  1143

Silvacraft

All Silvacraft properties are coded SIL_CAMP.

## # A tibble: 8 x 2
##   species     n
##   <fct>   <int>
## 1 AGWT      155
## 2 GADW       48
## 3 HOME        3
## 4 HYBR        2
## 5 MALL     1009
## 6 MBDH        2
## 7 RNDU        5
## 8 WODU      289
## # A tibble: 5 x 2
##   band_year     n
##       <int> <int>
## 1      2015     9
## 2      2016   329
## 3      2017   270
## 4      2018   787
## 5      2019   118

White Oaks

All White oaks locations are coded WODW. This property was new in 2018.

## # A tibble: 7 x 2
##   species     n
##   <fct>   <int>
## 1 AGWT       87
## 2 AMCO        3
## 3 GADW        1
## 4 HYBR        2
## 5 MALL     2489
## 6 NOPI       11
## 7 WODU      619
## # A tibble: 2 x 2
##   band_year     n
##       <int> <int>
## 1      2018  2691
## 2      2019   521