In UBC-MDS/taxyvr: Data from The city of Vancouver's Open Data Portal on Vancouver property tax assessment

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "man/figures/README-",
  out.width = "100%"
)
library(taxyvr)

taxyvr

The goal of taxyvr is to provide an easy way to access the Vancouver housing assessment data. This is semi-tidied data obtained from the City of Vancouver's Open Data Portal.

Installation

You can install the development version from GitHub with:

install.packages("devtools")
devtools::install_github("UBC-MDS/taxyvr")

Vignette

You may also access this information through our vignette. First use this command for installation:

install.packages("devtools")
devtools::install_github("UBC-MDS/taxyvr", build_vignettes = TRUE)

And to read the vignette use:

library(taxyvr)
browseVignettes("taxyvr")

This data was acquired courtesy of The city of Vancouver's Open Data Portal.

This Package contains (currently) 7 main dataframes all with 29 columns :

• tax_2020: This dataset is currently still being updated by the city as it's still the current year. It currently has r nrow(tax_2020) rows for properties in 2020
• tax_2019: This contains data regarding the properties in vancouver for the year 2019. The values in this dataset are static and it has r nrow(tax_2019) rows.
• tax_2018: This contains data regarding the properties in vancouver for the year 2018. The values in this dataset are also static and it has r nrow(tax_2018) rows.
• tax_2017: This contains data regarding the properties in vancouver for the year 2017. The values in this dataset are also static and it has 206480 rows.
• tax_2016: This contains data regarding the properties in vancouver for the year 2016. The values in this dataset are also static and it has 203658 rows.
• tax_2015: This contains data regarding the properties in vancouver for the year 2015. The values in this dataset are also static and it has 203494 rows.
• tax_2014: This contains data regarding the properties in vancouver for the year 2014. The values in this dataset are also static and it has 200925 rows.

The 29 variables included in the dataset are the following, (Vancouver Open Data Portal documentation page):

| Variable | Meaning | Type | Sample | |:--------------------|:----------------------------------------------------|:-------|:-------| | pid | Property identifier | chr | 014-193-205 | | legal_type | Values are 'STRATA', indicating property is part of a Strata Plan, 'LAND' indicating property has a non-strata plan number, or 'OTHER' for properties with no plan number | chr | STRATA | folio | A 12-digit identifier for purposes of assessment | dbl | 151843410011 | | land_coordinate | First 8 digits of BC Assessment's folio number | dbl | 15184341 | | zone_name | Name of zoning district | chr | M-2 | | zone_category | Name of zoning category | chr | Industrial | | block | Component of legal description | chr | 155 | | plan | Component of legal description | chr | VAS2438 | | district_lot | Component of legal description | chr | 319 | | lot | Component of legal description | chr | 11 | | from_civic_number | This is the house number, it may be the first number in a range | chr | 3594 | | to_civic_number | Blank unless it is the last house number in a range | chr | 9141 | | street_name |The name of the street where the property is located | chr | SHAUGHNESSY ST | | property_postal_code|A series of letters and/or digits that is attached to a property address | chr | V6P 6R9 | | narrative_legal_line3|Describes a property for registration purposes | chr | SHARE IN COM PROP THEREIN | | narrative_legal_line2|Describes a property for registration purposes | chr | 319 NEW WESTMINSTER UNDIV 74/1341 | | narrative_legal_line1|Describes a property for registration purposes | chr | DIV 376/127 LOT 220 PLAN LMS1863 | | narrative_legal_line4|Describes a property for registration purposes | chr | WESTMINSTER LAND DIST | | narrative_legal_line5|Describes a property for registration purposes | chr | BLOCK 17, PLAN VAP5928 /nobr> | | current_land_value | The market value of the fee simple interest in land and improvements | dbl | 397000 | | current_improvement_value | The market value of the fee simple interest in land and improvements | dbl | 107000 | | tax_assessment_year |Year in effect for Current_Land_Value, Current_Improvement_Value and Tax_Levy | dbl | 2018 | | previous_improvement_value |Year in effect for Current_Land_Value, Current_Improvement_Value and Tax_Levy| dbl | 112000 | | previous_land_value | This value is for the previous assessment year | dbl | 262000 | | year_built |Year that the property was built | dbl | 1989 | | big_improvement_year |Year of major improvement to the property | dbl | 1989 | | tax_levy |This is the total taxes printed on the most recent tax notice. It includes the City's general levy, levies for all taxing authorities, utilities, local improvements and miscellaneous charges.| dbl | 5361.97 | | tax_levy |This is the total taxes printed on the most recent tax notice. It includes the City's general levy, levies for all taxing authorities, utilities, local improvements and miscellaneous charges.| dbl | 5361.97 | | neighbourhood_code |This is a 3-digit number assigned by BCA which identifies the neighbourhood for the folio| chr | 018 | | report_year | The report year | dbl | 2018 |

Example

This is a basic example which shows you how to solve a common problem:

library(dplyr)
library(taxyvr)


tax_2018 %>% filter(legal_type == "LAND") %>% 
  arrange(desc(current_land_value))

or find out the summary statistics of the data:

summary(tax_2018)

License

taxyvr's data is released under the Open Government Licence - Vancouver license. See their terms of use.

Citation

Run this command to get info on how to cite this package.

citation("taxyvr")

On the topic of citations, we have one to cite:

This project was made using R package ggmap:

D. Kahle and H. Wickham. ggmap: Spatial Visualization with ggplot2. The R Journal, 5(1), 144-161. URL http://journal.r-project.org/archive/2013-1/kahle-wickham.pdf

UBC-MDS/taxyvr documentation built on Nov. 10, 2020, 8:11 p.m.