search

NYCPlanning / db-developments

🏠 🏘️ 🏗️ Developments Database
https://nycplanning.github.io/db-developments
8 stars 2 forks source link

QAQC: Field Distribution Reports #514

Closed abrieff closed 2 years ago

abrieff commented 2 years ago

For Job Status, Job Type, create a new report that shows the # of new records of each possible type created since the previous version, to be able to map over versions anomalies in the assigning of statuses or types

Oysters1874 commented 2 years ago

Just to make sure which table to look at, can we just fetch job status/type information from the table status_devdb?

abrieff commented 2 years ago

I would suspect that you want to just do it at the end from final_devdb but curious what others think

Oysters1874 commented 2 years ago

I would suspect that you want to just do it at the end from final_devdb but curious what others think

yea, after I ask this question, I feel like final_devdb would be better, and we may want to use date_filed to capture the newly added changes instead of date_permittd.

Oysters1874 commented 2 years ago

But I am not really sure about which date to use in order to do this measurement. Anyway, I will open a pr and address my question there.