In erhla/cmfproperty: Property Tax Analysis

knitr::opts_chunk$set(
  collapse = TRUE,
  message = FALSE,
  warning = FALSE,
  comment = "#>"
)

Introduction

Property tax analysis and sale ratios studies are highly standardized processes ripe for automation. This package implements the IAAO standards and generates a sale ratios study in seconds from user-provided data.

This tool has been critical for the work of the Center for Municipal Finance as we produce thousands of sale ratios studies annually. This open-source tool incorporates what we have learned in this work and is designed to enable Assessors and members of the public to analyze their own data.

How does this work?

There are four steps to utilize this report:

Install R & R Studio
Install devtools and cmfproperty
Preprocess your data
Use cmfproperty to create ratios and run make_report

Package Installation (Steps 1 and 2)

cmfproperty uses the R programming language. R is an open-source language which can be easily installed on any computer. We recommend that you install RStudio and R.

Installing cmfproperty requires the devtools package which can be installed as follows:

install.packages("devtools")

Once devtools is installed, our package can be installed from our github repository as follows:

devtools::install_github("cmf-uchicago/cmfproperty")

Data Preprocessing (Step 3)

To use this package we need to create a data frame where each row is the sale of individual property matched to its assessment at the time of sale. This process is highly dependent on how your data is structured. Examples can be found in Data Preprocessing.

Your final data set must have the following columns:

Sale Price
Assessed Value
Sale Year

We highly recommend that you also include a column with a unique identifier such as parcel number or pin number.

Running the Report (Step 4)

After gathering data in this form, we have to identify the three required columns (sales, assessments, and sale year) for the package using cmfproperty::reformat_data.

ratios <-
  cmfproperty::reformat_data(
    data = cmfproperty::example_data,
    sale_col = "SALE_PRICE",
    assessment_col = "ASSESSED_VALUE",
    sale_year_col = "SALE_YEAR",
  )
head(as.data.frame(ratios))

We denote data processed by cmfproperty::reformat_data as ratios throughout the documentation. ratios includes the additional calculated fields needed to complete the study.

There's one more step to get the automated report:

cmfproperty::make_report(ratios, 
                         jurisdiction_name = "Cook County, Illinois")

The report will be saved in your working directory or a specific directory can be provided.

cmfproperty::make_report(ratios, 
                         jurisdiction_name = "Cook County, Illinois",
                         output_dir = "~/Desktop/")

Check out an example report here.