3 Pull requests merged by 3 people

• Add new features to ratio stats

  #740 merged Mar 7, 2025

• Simplify Socrata API script and allow multiple assets to be updated

  #745 merged Mar 4, 2025

• Move permit date_issued not-null test to data integrity test

  #749 merged Mar 4, 2025

3 Pull requests opened by 3 people

• Automate socata api updates

  #755 opened Mar 5, 2025

• Fix character encoding problems in `ccao.commercial_minor_subclass` seed

  #757 opened Mar 7, 2025

• Initial push of geocoding test doc

  #758 opened Mar 7, 2025

5 Issues closed by 2 people

• Add new columns to ratio stats table

  #737 closed Mar 7, 2025

• Fill spatial attributes based on nearest neighbors for parcels missing location data

  #753 closed Mar 5, 2025

• Add db prefixes to athena tables with generic names

  #559 closed Mar 4, 2025

• Replicate additional Inquire-based QC checks

  #250 closed Mar 4, 2025

• Investigate parcels in `iasworld.pardat` missing shapes in `spatial.parcel`

  #729 closed Mar 4, 2025

4 Issues opened by 2 people

• Prepare for 2025 Norwood Park residential reporting

  #756 opened Mar 6, 2025

• Update Commercial Valuations Open Data

  #754 opened Mar 5, 2025

• Geocode parcels missing coordinates (no shapes in the County parcel DB)

  #752 opened Mar 4, 2025

• Fill spatial features for parcels missing shapes in the County parcel DB

  #751 opened Mar 4, 2025

27 Unresolved conversations

Sometimes conversations happen on old items that aren’t yet closed. Here is a list of all the Issues and Pull Requests with unresolved conversations.

• Define dbt tests for commercial and mixed-use parcels

  #329 commented on Mar 4, 2025 • 0 new comments

• Define a dbt test to check prorated PIN tiebacks

  #322 commented on Mar 4, 2025 • 0 new comments

• Investigate and document `external_propct` fields

  #392 commented on Mar 4, 2025 • 0 new comments

• Add test to ensure omitted classes have `tot57` values for the same tax year

  #363 commented on Mar 4, 2025 • 0 new comments

• Refactor a few ingest scripts from R to dbt Python models

  #394 commented on Mar 4, 2025 • 0 new comments

• Clean out DVC cache

  #273 commented on Mar 4, 2025 • 0 new comments

• Define a dbt test to validate CALP models

  #319 commented on Mar 4, 2025 • 0 new comments

• Update docs deployment pipeline to use `--static` CLI Flag

  #358 commented on Mar 4, 2025 • 0 new comments

• Look into adding assessor notes fields to test workbook

  #359 commented on Mar 4, 2025 • 0 new comments

• Update data onboarding ticket

  #5 commented on Mar 4, 2025 • 0 new comments

• Add check for 299 switching to vacant land PIN

  #13 commented on Mar 4, 2025 • 0 new comments

• Add automated test with notifications for `dweldat.spot`

  #572 commented on Mar 4, 2025 • 0 new comments

• Add dbt tests to all `default` views

  #248 commented on Mar 4, 2025 • 0 new comments

• Move townhome complex ID creation to AWS, add to Open Data

  #271 commented on Mar 4, 2025 • 0 new comments

• Add more complex dbt tests to `qc` database

  #249 commented on Mar 4, 2025 • 0 new comments

• Build out a service catalog / status page

  #383 commented on Mar 4, 2025 • 0 new comments

• Create issue template for new dbt tests

  #385 commented on Mar 4, 2025 • 0 new comments

• Factor out more dbt YAML selectors

  #446 commented on Mar 4, 2025 • 0 new comments

• Convert `aws-s3/scripts-ccao-data-warehouse-us-east-1` to dbt DAG components

  #99 commented on Mar 4, 2025 • 0 new comments

• Replace `geoarrow` functions in ingest scripts

  #492 commented on Mar 4, 2025 • 0 new comments

• Spike using local Dagster for EL and orchestration

  #518 commented on Mar 4, 2025 • 0 new comments

• Consolidate code shared in dbt tests `expression_is_true` and `expression_is_false`

  #465 commented on Mar 4, 2025 • 0 new comments

• `--rebuild` arg to export scripts should rebuild parents

  #613 commented on Mar 4, 2025 • 0 new comments

• Improve design of `export` module interface

  #637 commented on Mar 4, 2025 • 0 new comments

• Investigate existing data integrity issues

  #62 commented on Mar 4, 2025 • 0 new comments

• Move sales val export script from `model-sales-val` to this repo

  #364 commented on Mar 4, 2025 • 0 new comments

• Update QC town close report workbook headers to reference current years

  #750 commented on Mar 5, 2025 • 0 new comments