19Q4 Data Dictionary

19Q2 Field Name	19Q4 Field Name	19Q4 Field name alias	Data type	Source	PLUTO/DOB source field name, if applicable	Explanation (final)
job_number	job_number	DOB Job Number	Integer	Open Data: DOB Job Application Filings	Job #	The DOB job application number assigned when the applicant begins the application. This is the unique identifier for the application submitted to the Department of Buildings (DOB). It may contain several work types, and more work types may be added as the application review and the work continues. It is a 9-digit number where the first digit indicates the borough where the building is located.
job_type	job_type	DOB Job Type	String	Open Data: DOB Job Application Filings	Job Type	DOB's type category for the job application. The following types are included in this database: New Building (NB): an application to build a new structure. �NB� cannot be selected if any existing building elements are to remain�for example a part of an old foundation, a portion of a fa�ade that will be incorporated into the construction, etc. Alteration Type I (A1): a major alteration that will change the use, egress, or occupancy of the building. Demolition (DM): an application to fully or partially demolish an existing building. Note that many demolition permits are only for partial demolitions and for garages (these are also captured). For more information see https://www1.nyc.gov/site/buildings/homeowner/permits.page.
status	job_status	DOB Job Status	String	DCP Recode	Job Status	DCP recode of DOB's status label. More details on each DOB status is at https://www1.nyc.gov/assets/buildings/pdf/bisjobstatus.pdf. Jobs typically move through status A through X over time as they reach certain approval milestones. Filed: job application is at status A - G at the time of publication. Application submitted by review is not yet in progress. In Progress: application at status H - P, except J. Plan examination is in progress but not yet approved. In Progress (last plan disapproved): application at status J Permit Issued: application at status Q and R Complete: application at status U and X, or CO issued for NB or A1 job type Complete (demolition): application at status Q for DM job type. Withdrawn: application at status 3 *** DCP has decided to mark demolitions as complete when they receive a permit (status Q) because this is likely when the building must be vacated, and it appears that many buildings are physically demolished some time before receiving sign off (status X).
x_inactive	job_inactive	Job Inactive	String	DCP Logic		Flag for job applications that are likely inactive. These records should be excluded in most analyses of incomplete jobs. Note that this definition is probability based and therefore can not capture all permits that may eventually become inactive. Jobs are flagged "inactive" by DCP in the following cases: 1. If status is "filed" or "in progress" and the application's status hasn�t changed in 3 years 2. If status is "In progress (last plan disapproved)" and the application's status hasn�t changed in 2 years
occ_category	occ_category	Occupancy Category	String	DCP Logic		This field should be treated as a residential flag. A value of "residential" indicates that the job affects residential units in some way through new construction, alteration, or demolition. The only occupancy category included in the housing database is "residential." Mixed-use buildings containing residential units may have been filed as residential or under another occupancy type. Those filed under another occupancy type are not necessarily captured in this database. Note that certain records have been reclassified by DCP. For instance, if DCP had knowledge of a residential permit application actually being a hotel permit application, the occupancy category was changed. There may however still be misclassified records. If initial occupancy or proposed occupancy from DOB is residential, occ_category is coded as "residential." Manual research was conducted at DCP to identify jobs where neither the initial or proposed occupancy was listed by DOB as residential, but the job description indicates the presence of residential uses.
NEW IN 19Q4	complete_year	Completed Year	Integer	DCP Logic		Year the job was completed. For new buildings and alterations, this is defined as the year of the first certificate of occupancy issuance. For demolitions, this is the year that the demolition was permitted (reached status Q).
NEW IN 19Q4	permit_year	Permitted Year	Integer	DCP Logic
units_init	units_initial	Units Initial	Integer	Open Data: DOB Job Application Filings	Existing Dwelling Units	Number of units that initially existed in building at time of job application, as reported by the applicant.
units_prop	units_prop	Units Proposed	Integer	Open Data: DOB Job Application Filings	Proposed Dwelling Units	Number of final units proposed in job application after the proposed work has been completed, as reported by the applicant.
units_net	units_net	Units Net Change	Integer	DCP Logic		Net change in unit count between the number of units existing at the time of application and the number of units proposed Note that this value could only be calculated for jobs that contain units_init and units_prop.
units_complete	units_complet	Units Completed	Integer	DCP Logic		Cumulative number of proposed units that have been completed at the time of publication, based on number of units having received temporary or final certificates of occupancy.
units_incomplete	units_incompl	Units Incomplete	Integer	DCP Logic		Number of proposed units that have not yet been completed at the time of publication.
affordable_units	units_hnyaff	Units Affordable in Housing NY	Integer	Open Data: Housing New York Units by Building	All Counted Units	The total number of affordable units, counted towards the Housing New York plan, that are in the building.
boro	boro	Borough	String	Open Data: DOB Job Application Filings	Borough	The NYC borough where the proposed work will take place.
bbl	bbl	BBL	Integer	Open Data: DOB Job Application Filings	Block and Lot	Borough-Block-Lot tax ID number. This field consists of the borough code followed by the tax block followed by the tax lot. The borough code is one numeric digit (Manhattan=1, Bronx=2, Brooklyn=3, Queens=4, Staten Island=5). The tax block is one to five numeric digits, preceded with leading zeros when the block is less than five digits. The tax lot is one to four digits and is preceded with leading zeros when the lot is less than four digits. Each unit in a building that is a condominium is defined by the Department of Finance as a separate tax lot. To make condominium information more compatible with parcel information, the Department of City Planning aggregated condominium unit tax lot information so that each condominium complex within a tax block is represented by only one tax lot record. A condominium complex is defined as one or more structures or properties under the auspices of the same condominium association. The Department of City Planning then assigned the condominium billing tax lot number to the condominium complex tax lot record. If the Department of Finance had not yet assigned a billing tax lot number to the condominium complex then the lowest tax lot number within the condominium complex was used.
bin	bin		Integer	Open Data: DOB Job Application Filings	Bin #	Building Identification Number found on the job application.
address_house	address_numbr	Street Number	String	Open Data: DOB Job Application Filings	House #	The house number for the building where the proposed work will take place.
address_street	address_st	Street Name	String	Open Data: DOB Job Application Filings	Street Name	The street name for the building where the proposed work will take place.
address	address	Address	String	DCP Recode		Concatenated street number and street name for the building where the proposed work will take place.
status_a	date_filed	Date Filed (Status A)	Date	Open Data: DOB Job Application Filings	Pre- Filing Date	Date of job status A (pre-filing application). This is the first step in the process for all job applications. The job application # is assigned at this status. This occurs when the applicant submits any part of the application (even a single form), in person or electronically.
status_d	date_statusd	Status D	Date	Open Data: DOB Job Application Filings	Fully Paid	Date of job status D (completed application on file). This is when all data entry is complete and payments have been made.
status_p	date_statusp	Status P	Date	Open Data: DOB Job Application Filings	Approved	Date of job status P (plan examination approval). This is when the entire job has been approved by the plan examiner. The applicant can now apply for a permit.
status_q	date_permittd	Date Permitted (Status Q)	Date	Open Data: DOB Permit Issuance		Date of job status Q (first partial permit issuance). This is when construction work may begin. This field should be used for identifying the number of permits approved in a given year.
status_r	date_statusr	Status R	Date	Open Data: DOB Job Application Filings	Fully Permitted	Date of job status R (full permit issuance). This is when all necessary permits have been approved for a job.
status_x	date_statusx	Status X	Date	Open Data: DOB Job Application Filings		Date of job status X (job completion). For new buildings and alterations, date of earliest certificate of occupancy issuance (date_complete) is more reliable in determining completion date.
status_date	date_lastupdt	Date Last Status	Date	??	Latest Action Date	The date of the last update to the DOB record for the job filing.
co_earliest_effectivedate	date_complete	Date Completed	Date	Open Data: DOB Certificate Of Occupancy, DOB Permit Issuance		DCP's best estimate of completion date, for all jobs. For new buildings and alterations, date complete is equal to the date of the earliest certificate of occupancy. For demolitions, date complete is equal to status Q (permit issued), since demolitions do not receive certificates of occupancy. Blank indicates no certificate of occupancy has been issued. Typically, a building can be considered complete at this stage. Large buildings with many units may have units receiving certificates of occupancy over a longer period of time.
occ_init	occ_initial	Occupancy Initial	String	Open Data: DOB Job Application Filings	Existing Occupancy	DCP categorization of existing occupancy type at time of job application. This indicates what a site was used for before the proposed job. It is a simplified recode of DOB's initial occupancy type of the building. See page 21 of DOB's PW-1 User Guide for a complete list of building occupancy classifications: http://www1.nyc.gov/assets/buildings/pdf/pw1_userguide.pdf
occ_prop	occ_proposed	Occupancy Proposed	String	Open Data: DOB Job Application Filings	Proposed Occupancy	DCP categorization of proposed occupancy type at time of job application. This indicates what the site will be used for after the proposed job is complete. See page 21 of DOB's PW-1 User Guide for a complete list of building occupancy classifications: http://www1.nyc.gov/assets/buildings/pdf/pw1_userguide.pdf
NEW IN 19Q4	zoningdist1	Zoning District 1	String	Open Data: DOB Job Application Filings	Zoning Dist1	The primary zoning district of the tax lot per the applicant at time of application. For more information see http://www1.nyc.gov/site/planning/zoning/about-zoning.page.
NEW IN 19Q4	zoningdist2	Zoning District 2	String	Open Data: DOB Job Application Filings	Zoning Dist2	The secondary zoning district of the tax lot per the applicant at time of application.
NEW IN 19Q4	zoningdist3	Zoning District 3	String	Open Data: DOB Job Application Filings	Zoning Dist3	The teritary zoning district of the tax lot per the applicant at time of application.
NEW IN 19Q4	specialdist1	Special District 1	String	Open Data: DOB Job Application Filings	Special District 1	The primary special zoning district of the tax lot per the applicant at time of application. Other zoning designations may appear in this field, such as industrial buziness zones (IBZ), mandatory inclusionary housing (MIH) areas, or other zoning designations. This is field is provided by the applicant, it is likely inconsistent. The City Planning Commission designates special zoning districts to achieve specific planning and urban design objectives in defined areas with unique characteristics. Special districts respond to specific conditions; each special district designated by the Commission stipulates zoning requirements and/or zoning incentives tailored to distinctive qualities that may not lend themselves to generalized zoning and standard development. For more information see http://www1.nyc.gov/site/planning/zoning/districts-tools/special-purpose-districts.page.
NEW IN 19Q4	specialdist2	Special District 2	String	Open Data: DOB Job Application Filings	Special District 2	The secondary special zoning district of the tax lot per the applicant at time of application. Other zoning designations may appear in this field, such as industrial buziness zones (IBZ), mandatory inclusionary housing (MIH) areas, or other zoning designations. This is field is provided by the applicant, it is likely inconsistent.
NEW IN 19Q4	landmark	Landmark	String	Open Data: DOB Job Application Filings	Landmarked	Indicates that the building has been designated as a landmark building by the Landmarks Preservation Commission. Y = yes, it's a landmark building. Blank = no, it's not a landmark building.
NEW IN 19Q4	cityowned	City Owned	String	Open Data: DOB Job Application Filings	City Owned	Indicates whether or not the building is owned by New York City. Y = yes Blank = no
NEW IN 19Q4	owner_type	Owner Type	String	Open Data: DOB Job Application Filings	Owner Type	The Owner Type selected by the applicant on the PW-1 form.
NEW IN 19Q4	owner_nonprof	Owner Non-Profit	String	Open Data: DOB Job Application Filings	Non-Profit	The applicant has indicated that the owner is a non-profit organization. Y = yes Blank = no
NEW IN 19Q4	owner_firstnm	Owner First Name	String	Open Data: DOB Job Application Filings	Owner's First Name	The first name of the building owner.
NEW IN 19Q4	owner_lastnm	Owner Last Name	String	Open Data: DOB Job Application Filings	Owner's Last Name	The last name of the building owner.
NEW IN 19Q4	owner_biznm	Owner Business Name	String	Open Data: DOB Job Application Filings	Owner's Business Name	The business name of the building owner.
NEW IN 19Q4	owner_address	Owner Address	String	Open Data: DOB Job Application Filings	Owner's House Number & Owner's Street Name	The house number and street for the building owner's address.
NEW IN 19Q4	owner_zipcode	Owner Zip Code	String	Open Data: DOB Job Application Filings	Zip	The zip code for the building owner's address.
NEW IN 19Q4	owner_phone	Owner Phone Number	String	Open Data: DOB Job Application Filings	Owner'sPhone #	The phone number for the building owner.
stories_init	stories_init	Stories Initial	Integer	Open Data: DOB Job Application Filings	ExistingNo. of Stories	The existing number of floors in the building, as reported by the applicant.
stories_prop	stories_prop	Stories Proposed	Integer	Open Data: DOB Job Application Filings	Proposed No. of Stories	The number of stories/floors in the building after the work is done, as reported by the applicant.
NEW IN 19Q4	height_init	Height Initial	Integer	Open Data: DOB Job Application Filings	Existing Height	The height of the existing building in feet, as reported by the applicant.
NEW IN 19Q4	height_prop	Height Proposed	Integer	Open Data: DOB Job Application Filings	Proposed Height	The proposed height of the building in feet after the proposed work has been completed, as reported by the applicant.
zoningsft_init	zoningsf_init	Zoning SqFt Initial	Integer	Open Data: DOB Job Application Filings	Existing Zoning Sqft	The total zoning floor area for the existing building, if any. This is only required for new buildings and alterations.
zoningsft_prop	zoningsf_prop	Zoning SqFt Proposed	Integer	Open Data: DOB Job Application Filings	Proposed Zoning Sqft	The total zoning floor area for the building after the proposed work is completed. This is only required for new buildings and alterations.
NEW IN 19Q4	constructnsf	Total Construction SqFt	Integer	Open Data: DOB Job Application Filings	TOTAL_CONSTRUCTION_FLOOR_AREA	The square footage of the floor area of the construction.
NEW IN 19Q4	enlrg_horiz	Enlargement Horizontal	String	Open Data: DOB Job Application Filings	Horizontal Enlrgmt	This indicates if the work to be done under the application will result in a larger footprint for the building. Y = yes Blank = no
NEW IN 19Q4	enlrg_vert	Enlargement Vertical	String	Open Data: DOB Job Application Filings	Vertical Enlrgmt	This indicates if the work to be done under the application will result in a taller building. Y = yes Blank = no
NEW IN 19Q4	enlargementsf	Enlargement SqFt	Integer	Open Data: DOB Job Application Filings	Enlargement SQ Footage	The additional square footage added by the construction enlargement, if any.
NEW IN 19Q4	costestimate	Cost Estimate	Integer	Open Data: DOB Job Application Filings	Initial Cost	Dollar amount that indicates the applicant's estimate for how much the job will cost.
x_mixeduse	mixedusebldg	Mixed-Use Building	String	DCP logic		Job application appears to be for a building that contains both residential and hotel uses according to the job description and other DCP research.
NEW IN 19Q4	loftboardcert	Loft Board Certification	String	Open Data: DOB Job Application Filings	Loft Board	Indicates that the job application involves a interim multiple dwelling (IMD) building. A loft board certificate is required for alteration of a registered IMD building. Check the Loft Board website for a list of IMD buildings or the BIS property Profile for LOFT designation. Y = yes Blank = no
NEW IN 19Q4	edesignation	e-Designation	String	Open Data: DOB Job Application Filings	Little e	Indicates whether or not the lot is designated with an �E� on the Zoning Maps of the City of New York for potential hazardous material contamination, air and/or noise quality impacts. Little �E� or RD Site: Anytime there is an environmental cleanup in the City of New York, the location is identified as �E� on DCP zoning maps. The Department of Environmental Protection must approve proposed work to ensure that the work satisfies environmental requirements. Y = yes Blank = no
NEW IN 19Q4	curbcut	Curb Cut	String	Open Data: DOB Job Application Filings	Curb Cut	Indicates that the job application includes curb cut work. An angled drop cut to the curb in the roadway, street, public right of way, or similar, which provides access to the zoning or tax lot. X = Yes Blank = no
NEW IN 19Q4	tracthomes	Tract Homes	String	Open Data: DOB Job Application Filings	Cluster	This indicates that a job filing is part of a housing development where all of the buildings will be built exactly the same way. There is a main job folder with all of the paperwork and plans. This was a common practice when there was a development boom, but is not common anymore. Expected values are D, N, P, Y
hny_id	hny_id	Housing New York ID	String	DCP Logic
hny_to_job_relat	hny_jobrelate	Housing NY to Job Join Relationship	String	DCP Logic
job_description	job_desc	DOB Job Description	String	Open Data: DOB Job Application Filings	Job Description	The general description of the work being applied for. This field is free text, and is filled out by the applicant.
NEW IN 19Q4	pluto_unitres	PLUTO Units Residential	Integer	MapPLUTO 20v1	UnitsRes	The sum of residential units in all buildings on the tax lot. If there are no residential units in the tax lot the field is zero. Hotels/motels, nursing homes and SROs do not have residential units, but boarding houses do. Basement units for building superintendents are counted as a residential unit. Update of residential units triggered when a DOB permit is issued. Field Name:TOTALUNITS(UnitsT
NEW IN 19Q4	pluto_bldgsf	PLUTO Building SqFt	Integer	MapPLUTO 20v1	BldgArea	The total gross area in square feet, except for condominium measurements, which come from the Condo Declaration and are net square footage not gross.
NEW IN 19Q4	pluto_comsf	PLUTO Commercial SqFt	Integer	MapPLUTO 20v1	ComArea	An estimate of the exterior dimensions of the portion of the structure(s) allocated for commercial use.
NEW IN 19Q4	pluto_offcsf	PLUTO Office SqFt	Integer	MapPLUTO 20v1	OfficeArea	An estimate of the exterior dimensions of the portion of the structure(s) allocated for office use.
NEW IN 19Q4	pluto_retlsf	PLUTO Retail SqFt	Integer	MapPLUTO 20v1	RetailArea	An estimate of the exterior dimensions of the portion of the structure(s) allocated for retail use.
NEW IN 19Q4	pluto_ressf	PLUTO Residential SqFt	Integer	MapPLUTO 20v1	ResArea	An estimate of the exterior dimensions of the portion of the structure(s) allocated for residential use.
NEW IN 19Q4	pluto_yrbuilt	PLUTO Year Built	Integer	MapPLUTO 20v1	YearBuilt	The year construction of the building was completed. Note the DCP HED has found this to be untrue.
NEW IN 19Q4	pluto_yralt1	PLUTO Most Recent Alteration Year	Integer	MapPLUTO 20v1	YearAlter1	If a building has only been altered once, YEAR ALTERED 1 is the date that alteration began. If a building has been altered more than once, YEAR ALTERED 1 is the year of the second most recent alteration. The Department of Finance defines alterations as modifications to the structure that, according to the assessor, change the value of the real property.
NEW IN 19Q4	pluto_yralt2	PLUTO Second Most Recent Alteration Year	Integer	MapPLUTO 20v1	YearAlter2	If a building has only been altered once, this field is blank. If a building has been altered more than once, YEAR ALTERED 2 is the year that the most recent alteration began.
NEW IN 19Q4	pluto_bldgcls	PLUTO Building Class	String	MapPLUTO 20v1	BldgClass	A code describing the major use of structures on the tax lot.
NEW IN 19Q4	pluto_landuse	PLUTO Land Use	Integer	MapPLUTO 20v1	LandUse	A code for the tax lot's land use category. The Department of City Planning has created 11 land use categories and assigns each BUILDING CLASS to the most appropriate land use category.
NEW IN 19Q4	pluto_owner	PLUTO Owner Name	String	MapPLUTO 20v1	OwnerName	The name of the tax lot owner.
NEW IN 19Q4	pluto_owntype	PLUTO Ownership Type	String	MapPLUTO 20v1	OwnerType	A code indicating type of ownership for the tax lot.
NEW IN 19Q4	pluto_condo	PLUTO Condominium Number	Integer	MapPLUTO 20v1	CondoNo	The condominium number assigned to the complex. Condominium numbers are unique within a borough (see BOROUGH).
NEW IN 19Q4	pluto_bldgs	PLUTO Number of Buildings	Integer	MapPLUTO 20v1	NumBldgs	The number of buildings on the tax lot. Extensions are not counted as separate buildings.
NEW IN 19Q4	pluto_floors	PLUTO Number of Floors	Integer	MapPLUTO 20v1	NumFloors	The number of full and partial stories starting from the ground floor, for the tallest building on the tax lot. Above ground basements, and roofs used for parking, farming, playgrounds, etc are not included in the NUMBER OF FLOORS.
NEW IN 19Q4	pluto_version	Version of PLUTO	String	MapPLUTO 20v1	Version	The version number for this release of PLUTO
NEW IN 19Q4	bctcb2010	BCTCB 2010	Integer	Geosupport
NEW IN 19Q4	bct2010	BCT 2010	Integer	Geosupport
NEW IN 19Q4	nta2010	NTA 2010	String	Geosupport
NEW IN 19Q4	comunitydist	Community District	Integer	Geosupport
NEW IN 19Q4	councildist	Council District	Integer	Geosupport
NEW IN 19Q4	schoolsubdist	School Subdistrict	Integer	Geosupport
NEW IN 19Q4	policeprecnct	Police Precinct	Integer	Geosupport
NEW IN 19Q4	pluto_firm07	PLUTO FIRM 2007	Boolean	MapPLUTO 20v1	FIRM07_Flag	A value of 1 means that some portion of the tax lot falls within the 1% annual chance floodplainas determined by FEMA�s 2007 Flood Insurance Rate Map.Note that buildings on the tax lot may or may not be in the portion of the tax lot that is within the 1% annual chance floodplain
NEW IN 19Q4	pluto_pfirm15	PLUTO PFIRM 2015	Boolean	MapPLUTO 20v1	PFIRM15_Flag	A value of 1 means that some portion of the tax lot falls within the 1% annual chance floodplainas determined by FEMA�s 2015 Preliminary Flood Insurance Rate Map.Note that buildings on thetax lot may or may not be in the portion of the tax lot that is within the 1% annual chance floodplain.
latitude	latitude	Latitude	Float	Geosupport		Latitude in WGS84 / SRID:4326
longitude	longitude	Longitude	Float	Geosupport		Longitude in WGS84 / SRID:4326
	geom
x_geomsource	geomsource	Geography Source	String	DCP Logic		Source of the geographic coordinates for the record. Key: GBAT A: x/y coordinates relate to centroid of BBL GEOCLIENT: x/y coordinates relate to the segment of the street center line associated with the Block and Lot GEOCLIENT - BBL CENTROID: x/y coordinates relate to centroid of BBL GEOCLIENT - BIN CENTROID: x/y coordinates relate to centroid of building PLUTO: x/y coordinates relate to centroid of BBL PLUTO-APP: x/y coordinates relate to centroid of BBL MANUAL [name of DCP staffer]: x/y coordinates relate to BBL
x_dcpedited	dcpedited	DCP Edit	String	DCP Logic		Flagged as TRUE if DCP overwrote value (see x_reason for why), and blank if application data is unchanged
NEW IN 19Q4	version	Version	String	DCP Logic