VancouvR is an R wrapper around the City of Vancouver Open Data API. It allows transparent and reproducible access to the Vancouver Open Data Portal to facilitate data analysis and sharing of code.
The package caches downloaded data for the duration of the current session, so re-running code blocks will not result in repeated downloads. This speeds up the code, cuts down on unnecessary network traffic and reduces strain on the City of Vancouver Open Data infrastructure.
VancouverOpenData package reference
To install the latest release version of VancouvR from CRAN use
install.packages("VancouvR")The development version of VancouvR is available from GitHub via
remotes::install_github("mountainmath/VancouvR")Smaller datasets can be accessed without an API key, but for larger datasets an API key is required. API keys are available after registering at the City of Vancouver Open Data Portal.
Setting the API key in the .Rprofile file via
options(VancouverOpenDataApiKey=<your api key>)
will ensure that it is automatically loaded and not exposed when you share your code.
Get a list of datasets relating to properties
library(VancouvR)
search_cov_datasets("properties")Get the first 10 records of the property tax report for 2019 tax year.
get_cov_data(dataset_id = "property-tax-report",where="tax_assessment_year='2021'",rows=10)Get metadata for the street trees dataset.
get_cov_metadata("street-trees")Count the number of cherry trees by neighbourhood.
aggregate_cov_data("street-trees",where = "common_name LIKE 'CHERRY'", group_by = "neighbourhood_name")If you wish to cite VancouvR:
von Bergmann, J. VancouvR: ccess the 'City of Vancouver' Open Data API. v0.1.8.
A BibTeX entry for LaTeX users is
@Manual{VancouvR,
author = {Jens {von Bergmann}},
title = {VancouvR: Access the 'City of Vancouver' Open Data API,
year = {2024},
note = {R package version 0.1.8},
url = {https://mountainmath.github.io/VancouvR/},
}