db-pluto
db-pluto copied to clipboard
Add QAQC tables for Condo Checks
Addresses issue #414.
Changes
- Add
dcp_housing
as in input data source to compare the Certificate of Occupancy # of units residential (most accurate units residential number) in the Housing DB to PLUTO data - Creates new QAQC logic in two separate scripts to generate two separate QAQC tables to be displayed in the app to catch condos with extremely high unit counts
- output. NOTE: the qaqc_housing_units table failed to generate because of a datatype error but latest commit implements a fix, a new output will take a few hours to produce. I suggest looking at the qaqc_pts_condo output first until both tables are generated. This action was built off of a minor release of PLUTO.
- Add new dataset to
source_data_version.csv
- AD developed the logic for both QAQC scripts. Implementation is based off other QAQC processes that have already been established in PLUTO
thoughts so far from looking at qaqc_pts_condo.csv
:
- since there are only 24 rows with an
old_value
, does that mean only 24 were de - 12,312 total rows, so appears to have a row for all condos?
- a description of what each final column represents would be helpful. maybe at the top of the sql file? or maybe more descriptive column names?
@AmandaDoyle @damonmcc let's check in on this pr this afternoon?