db-pluto icon indicating copy to clipboard operation
db-pluto copied to clipboard

Add QAQC tables for Condo Checks

Open mbh329 opened this issue 2 years ago • 2 comments

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

mbh329 avatar Feb 09 '23 20:02 mbh329

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?

damonmcc avatar Feb 10 '23 15:02 damonmcc

@AmandaDoyle @damonmcc let's check in on this pr this afternoon?

fvankrieken avatar Jun 05 '23 13:06 fvankrieken