NYCPlanning / db-developments

🏠 🏘️ 🏗️ Developments Database

https://nycplanning.github.io/db-developments

8 stars 2 forks source link

20Q2 - Enhancements Master Issue #4

Closed SPTKL closed 4 years ago

SPTKL commented 4 years ago

New Fields

[ ] Add fields from DHCR rent stabilization data #47
[ ] Add Complete_Qrtr and Permit_Qrtr fields #51
[ ] Add fields from Furman Center Core #48
[ ] Add ClassB and Hotel units init and prop fields #28
[ ] Create commercial (and other use types?) flags #49

Logic

[ ] update inactive logic for Demolitions #41
[ ] Change logic for marking demos as complete and associated date logic #40
[ ] investigate why withdrawn records have a value in date_complete #37
[ ] Improve logic for classifying jobs as mixed use #36
[ ] Do not classify complete jobs as inactive #35

Formatting

[ ] make date formatting consistent across date fields #53
[ ] Recode flag values so they're consistent #50
[ ] Null out job descriptions that are just special characters #46
[ ] Clean up address_number values #45
[ ] Create owner_name #44
[ ] Update occupancy codes #42
[ ] Combine Vertical and Horizontal Enlargement fields into a single Enlargement field #54

Output

[ ] Create six aggregate tables #34
[ ] Rename "housing input research" table to "Manual Corrections Table." #43
[ ] Output DevDB in new schema #52

QAQC

[ ] QAQC - create DevDB QAQC page #33
[ ] QAQC - output jobs where occ_category = Other and units_init/prop <> 0 for research #26

github-actions[bot] commented 4 years ago

Stale issue message