Institutionalize municipal reporting on Open Data

[wrridgeway]

After the conclusion of each assessment stage countywide, the CCAO publishes municipal reporting. We've finally landed on a standard format; let's institutionalize it on Athena and Open Data.

There will be two tables or views: one that summarizes the assessment roll per municipality, and the other that reports on the Top 5 PINs in that municipality.

Below are the columns I've used for Tableau reporting, but they may require some changes for Open Data.

Municipal Assessment Roll: unique per major class, per municipality, per stage, per tax year. Columns:

• Municipality
• Tax Year
• Stage
• Tax Year & Stage (concatenated)
• Major Class
• Class Group (if Major Class = 2, then Residential; else, Non-Residential)
• Stage
• Number of Parcels
• Total AV
• Delta pct AV
• Phase total AV
• Phase AV Share

Municipal Top 5: top 5 PINs per municipality, per tax year. Columns:

• Municipality
• Tax Year
• PIN (pretty format)
• Class
• Major Class
• Taxpayer Name
• Situs Address
• Prior BOR AV (i.e., from the previous Tax Year, BOR final stage)
• CCAO AV (i.e., in Tax Year, CCAO final stage)
• BOR AV (i.e., in Tax Year, BOR final stage)
• BOR Change ($)

Please clean:

• "Mc Cook" to "McCook"
• "Forestview" to "Forest View"