search

ccao-data / data-architecture

Codebase for CCAO data infrastructure construction and management
https://ccao-data.github.io/data-architecture/
5 stars 3 forks source link

Reporting views for municipalities #413

Closed wrridgeway closed 2 months ago

wrridgeway commented 2 months ago

In reporting, we currently have vw_assessment_roll and vw_top_5 for townships. I'd like to create two similar separate views for municipalities.

Use case

  • This is frequently requested data for Assessor Leadership; let's institutionalize it.

  • I also want to have an auto-updating version of a municipal dashboard.

Complication: Assessment cycles

the assessment system works on a township cycle, not a municipal cycle, so some municipalities might have some PINs in one assessment stage and other PINs in a different stage.

Possible solution

I think the best way around this is to add an additional column on the assessment_roll version indicating, for each municipality, for the year & stage, the percentage of its PINs that have passed through that year & stage.

The ideal behavior of this "percent complete" column would be if the percent indicator had "memory." For example:

  • if a multi-township muni like Chicago had fully passed through the 2023 certified stage but only 50% of its PINs had reached the 2023 bor stage, then the percentage indicator would say 100% when year = 2023 and stage = assessor certified, and 50% when year = 2023 and stage = bor.

  • and, because in this scenario 2022 is complete, then for all 3 stages, the percent complete would be 100%.