Year-End Res Reporting Dashboards
At the end of the year, the CCAO will present information about its assessments to the Public and the Cook County Board. This materials should answer the following basic questions:
- On average, were properties in a specified geography assessed at 10% of their fair market value? (Accuracy)
- On average, were homes with similar fair market values assessed similarly? (Uniformity)
- On average, were homes with different fair market values assessed similarly? (Vertical Equity)
- What was the overall impact of appeals and desktop reviews on assessments? Was there sales chasing? (Ethics)
I think that the best way to present the Residential valuations process is through a combination of a dashboard and a written narrative. This issue ticket tracks the production of the dashboards.
Coding tasks
@tayuny has already prepared the PINGEO and PROPLOCS tables to include the various geographies and other information pertaining to this task #115 (closed) . Thanks!
- Examine the main_reporting script. Please identify chunks of code that can be moved to 99_utility_2. I can think of at least two: directory definitions and the list of packages can be put into the check.packages function. I will create an issue ticket and branch for this task in Utility.
- Create a Markdown file that produces a Shiny Dashboard using parameter inputs.
- Modify 0_ingest_reporting where necessary. Think about what parameters Markdown will need to pass to your ingest functions. Certainly aggregation unit. Perhaps others.
- Modify 1_reporting_analysis where necessary to produce required statistics
- Modify 2_visualize_reporting to produce the appropriate graphs etc.
Outputs
We want to aggregate our data into useful units. Our end goal will be a dashboard for each of the following aggregation units. These are listed in the order of completion. The level of complexity should be somewhere between the Township Diagnostic Report and the Residential Narrative. @ccaojardine will be supervising the graphical outputs of this project.
Required
-
Cook County -
Triennial Reassessment Area -
Township
Optional
-
Cook County Commissioner District -
Chicago Municipal Ward -
State Senator District & State Representative District
For the first iteration, let's show:
Existing plots
-
sale_plot -
current_ratios_hist -
current_ratios_cdf -
vol_rate from appeal_charts
New plots
-
A leaflet map of the geography, with a popup showing geography identifiers. -
Binned scatter with line median ratio vs. HH Income by census tract -
Binned scatter with line median ratio vs. by % non-(white, non-hispanic)
FYI @ssmithassessor @sgresnick @dmeyer828 @RGottner @rramire