Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

update columns in KPDB aggregation tables #665

Open
Tracked by #233
damonmcc opened this issue Mar 8, 2024 · 0 comments · May be fixed by #666
Open
Tracked by #233

update columns in KPDB aggregation tables #665

damonmcc opened this issue Mar 8, 2024 · 0 comments · May be fixed by #666
Assignees
@damonmcc

Comments

@damonmcc
Copy link
Member

damonmcc commented Mar 8, 2024 •
edited

Make changes to align with Schema Doc from GIS

column details from Schema Doc

column name description
within_5_years # of units that should be completed within the next 5 years
from_5_to_10_years # of units that should be completed within the next 5-10 years
after_10_years # of units that should be completed sometime after 10 years from this year
future_phased_units_total Total units included in three kpdb phasing buckets; Aggregate of within_5_years, from_5_to_10_years, after_10_years
future_units_without_phasing Uncompleted units without phasing
kpdb_completed_units Units that are likely included in HousingDB--but are definitely not future units. Perhaps pending Cert of Occ?
units_net The number of future units that should be counted as part of the project after removing completed DOB units and deduplication
units_gross The proposed number of units associated with a project in geography as reported in the source data
records_in_cdta How many projects not necessarly in app
senior_housing Count of projects in geography where project is at least partially senior housing
nycha Count of projects in geography where project is at least partially a NYCHA project
classb Count of projects in geography where project is at least partially class b
@damonmcc damonmcc mentioned this issue Mar 8, 2024
Open
5 tasks
@damonmcc damonmcc changed the title update the columns in the NTA and CDTA aggregation tables update columns in KPDB aggregation tables Mar 8, 2024
@damonmcc damonmcc linked a pull request Mar 9, 2024 that will close this issue
Draft
@damonmcc damonmcc self-assigned this Mar 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@damonmcc damonmcc

Labels
None yet
Projects
Data Engineering
Status: Backlog
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

revise KPDB aggregations NYCPlanning/data-engineering
1 participant
@damonmcc