knitr::opts_chunk$set( collapse = TRUE, comment = "#>", fig.path = "tools/README-" )
An R Package to query discharge, elevation and temperature data from an SQLite database for the West Kootenay region of British Columbia.
The SQLite database which houses the actual data is not provided with the package and must be requested from data@poissonconsulting.ca.
kootqlt
is available from GitHub
# install.packages("devtools") devtools::install_github("poissonconsulting/kootqlt")
or the Poisson R Archive Network (PoisRAN)
# install.packages("drat") drat::addRepo("poissonconsulting") install.packages("kootqlt")
After installing the kootqlt
R package, make sure the SQLite database
kootqlt.sqlite
is in dir
(by default the working directory), select the stations (the tbl data frame kootqlt::station
has information on all the possible stations) and date range of interest and then use kootqlt::qlt_download_data()
to get the data you need.
The DateTimeReading
column in the returned data is the date and time of the reading with time zone Etc/GMT+8
(which corresponds to Pacific Standard Time without daylight savings).
To convert to a Date use as.Date(tz = "Etc/GMT+8")
or better yet lubridate::date()
.
Please report any issues.
Pull requests are always welcome.
Please note that this project is released with a Contributor Code of Conduct. By participating in this project you agree to abide by its terms.
cat(kootqlt::qlt_disclaimer())
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.