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.

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

update columns in KPDB aggregation tables #665

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

update columns in KPDB aggregation tables #665

damonmcc opened this issue Mar 8, 2024 · 0 comments
Assignees

Comments

@damonmcc
Copy link
Member

damonmcc commented Mar 8, 2024

Make changes to KPDB align with Schema Doc from GIS. That doc lists the fields used in an in-development ESRI app to show past and future housing development.

That app expects KPDB data aggregated by NTA and CDTA with the following columns for each aggregation type:

(Due to data quality concerns, senior_housing, nycha, and classb are a lower priority than the others)

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 changed the title update the columns in the NTA and CDTA aggregation tables update columns in KPDB aggregation tables Mar 8, 2024
@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
Labels
None yet
Projects
Status: 🏗 In progress
Development

No branches or pull requests

1 participant