ccao-data / data-architecture

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

Investigate new `asmt_all.tot30` field #307

Closed jeancochrane closed 3 months ago

jeancochrane commented 7 months ago

We are not sure what this field represents, but it's new this year and seems to be related to homeowner improvement exemptions. It may be the improvement value as calculated from a cost table, but we're not sure. Let's do some exploratory data analysis to figure out what it looks like and document it in dbt.

Damonamajor commented 5 months ago

For taxyr 2023, there's a max of 7,500 image

Damonamajor commented 5 months ago

Step 1: does dweldat change when tot30 > 0. Step 2: Is there a valuation change reflected in assessment all.