issues
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
issues
Newest
Newest
Most commented
Recently updated
Oldest
Least commented
Least recently updated
Add selector for `test-dbt-models` workflow and set its indirect selection to "cautious"
#373
jeancochrane
closed
2 months ago
0
Add Chicago cbd boundary to `default.vw_pin_universe`
#372
Damonamajor
closed
2 months ago
4
Small edits to dbt tests based on feedback
#371
jeancochrane
closed
2 months ago
0
Update `test_dbt_models` workflow to format and upload run results to S3
#370
jeancochrane
closed
2 months ago
1
Add class checks and other data validation prior to final db export
#369
Damonamajor
closed
3 months ago
1
Add Chicago CBD boundary to PIN universe
#368
dfsnow
closed
2 months ago
1
Decompose reporting views/ctas and implement dbt tests
#367
wrridgeway
closed
2 months ago
7
Decompose reporting views/ctas and implement dbt tests
#366
wrridgeway
closed
2 months ago
1
Add `final_model` CSV seed
#365
dfsnow
closed
2 months ago
0
Move sales val export script from `model-sales-val` to this repo
#364
jeancochrane
opened
3 months ago
0
Add test to ensure omitted classes have `tot57` values for the same tax year
#363
jeancochrane
opened
3 months ago
6
Update `ccao.class_dict` table
#362
dfsnow
closed
2 months ago
1
Add iasWorld webapp column descriptions to dbt
#361
wrridgeway
closed
3 months ago
1
Refactor `row_values_match_after_join` and `res_class_matches_pardat` for join flexibility
#360
jeancochrane
closed
3 months ago
0
Look into adding assessor notes fields to test workbook
#359
jeancochrane
opened
3 months ago
0
Update docs deployment pipeline to use `--static` CLI Flag
#358
jeancochrane
opened
3 months ago
0
Add new test to make sure tieback PINs don't contain hyphens
#357
jeancochrane
closed
2 months ago
0
Upgrade `dbt-athena-community` to `1.7.1`
#356
jeancochrane
closed
3 months ago
1
Add iasWorld colnames to descriptions of tests in `qc` and `dweldat`
#355
jeancochrane
closed
3 months ago
1
Update test descriptions to use iasWorld column names
#354
jeancochrane
closed
3 months ago
0
Update class code cleaning to allow new omitted assessment class codes
#353
wrridgeway
closed
2 months ago
5
Consider using `iasworld.legdat.xcoord`/`ycoord` for parcel centroid location
#352
wrridgeway
closed
2 months ago
4
Add descriptions and selected columns for all non failing tests
#351
jeancochrane
closed
3 months ago
0
Change `geography_id` type to string in `ratio_stats.py`
#350
wrridgeway
closed
3 months ago
1
Change `geography_id` type to string in `ratio_stats.py`
#349
wrridgeway
closed
3 months ago
0
Update `cleanup_dbt_resources` for seeds and fix `location.neighborhood_group.nbhd` type
#348
jeancochrane
closed
3 months ago
1
Add dbt tests for sales view legacy filters
#347
wrridgeway
closed
2 months ago
0
Scope test for val override fields
#346
jeancochrane
opened
3 months ago
0
Design a better notification system for failing dbt tests
#345
jeancochrane
closed
2 months ago
1
Add descriptions and selected columns for all non-failing tests
#344
jeancochrane
closed
3 months ago
0
Add `location.neighborhood_group` table via seed
#343
jeancochrane
closed
3 months ago
0
Remove dummy PINs from `vw_pin_universe`
#342
wrridgeway
closed
3 months ago
3
Update class code cleaning to allow new omitted assessment class codes
#341
wrridgeway
closed
2 months ago
0
Remove dummy PINs from `vw_pin_universe`
#340
dfsnow
closed
3 months ago
0
Refactor `additional_select_columns` dbt test params to support more configurable naming and aggregation
#339
jeancochrane
closed
3 months ago
1
Add stage-level classes to `default.vw_pin_history`
#338
wrridgeway
closed
3 months ago
4
Add stage-level classes to `default.vw_pin_history`
#337
wrridgeway
closed
3 months ago
0
Address `NULL` values for `iasworld.sales.nopar` in construction of `default.vw_pin_sale.is_multisale`
#336
wrridgeway
closed
3 months ago
2
Address `NULL` values for `iasworld.sales.nopar` in construction of `default.vw_pin_sale.is_multisale`
#335
wrridgeway
closed
3 months ago
0
Correctly join calculated number of parcels per sale to sales view
#334
wrridgeway
closed
3 months ago
2
Correctly join calculated number of parcels per sale to sales view
#333
wrridgeway
closed
3 months ago
0
Overwrite parking space indicators if they disagree with provided condo characteristics
#332
wrridgeway
closed
3 months ago
1
Overwrite parking space indicators if they disagree with provided condo characteristics
#331
wrridgeway
closed
3 months ago
0
Refactor `additional_select_columns` to support more configurable naming and aggregation
#330
jeancochrane
closed
3 months ago
0
Define dbt tests for commercial and mixed-use parcels
#329
jeancochrane
opened
4 months ago
0
Define a dbt test to ensure that exempt `pardat` parcels are also exempt in all related tables
#328
jeancochrane
closed
2 months ago
1
Add `is_active_exe_homeowner`, `n_years_exe_homeowner`, `airport_dnl_total` to dbt
#327
wrridgeway
closed
4 months ago
0
Add ccao_is_active_exe_homeowner, ccao_n_years_exe_homeowner, prox_airport_dnl_total to dbt
#326
wrridgeway
closed
4 months ago
0
Add distance to university and vacant land to modeling view docs
#325
wrridgeway
closed
4 months ago
0
Update dbt docs for model.vw_card_res_input
#324
wrridgeway
closed
4 months ago
0
Previous
Next