KPDB Schema

Field	Long form Name	Definition
project_id	Project ID	ID the groups records together into a single project
source	Source	The name of the dataset the project came from
record_id	Record ID	The ID of the project from the source dataset
record_name	Record name	The name of the project as provided by the source
borough	Borough	The borough the project is located within
status	Status	The current phase of the project
type	Type	The type of project. For DOB jobs this would be NB, Alt, etc.
units_gross	Units gross	The proposed number of units associated with the project as reported in the source data
units_net	Units net	The number of future units that should be counted as part of the project after removing completed DOB units and deduplication
prop_within_5_years	Proportion built within 5 years	Proportion of units that should be completed within the next 5 years
prop_5_to_10_years	Proportion built within 5-10 years	Proportion of units that should be completed within the next 10 years
prop_after_10_years	Proportion built after 10 years	Proportion of units that should be completed sometime after 10 years from this year
within_5_years	Units built within 5 years	The number of units that should be completed within the next 5 years
from_5_to_10_years	Units built within 5-10 years	The number of units that should be completed within the next 10 years
after_10_years	Units built after 10 years	The number of units that should be completed sometime after 10 years from this year
phasing_rationale	Phasing assumption rational	The planner’s rationale for the timeline of a project
phasing_known	Phasing: Assumed or Known	Boolean. True if the phasing assumptions are known
nycha	NYCHA	Boolean. True if this is at least partially a NYCHA project
classb	Group Quarters	Boolean. True if this is a project with Class B units (can be partial)
senior_housing	Senior Housing	Boolean. True if this is at least partially a Senior Housing project
inactive	Inactive	Flag to indicate if the project is inactive or not. If we do not include DOB inactive jobs we will exclude this field
geom	geometry	geometry(Geometry,4326)