cityofnewyork-us/housing-database-project-level-files-uxt4-ugwr
 
Readme
Updated 10 months ago
Indexed 16 hours ago

Housing Database Project Level Files

The NYC Department of City Planning’s (DCP) <a href="https://www1.nyc.gov/site/planning/data-maps/open-data/dwn-housing-database.page#housingdevelopmentproject">Housing Database</a> contains all NYC Department of Buildings (DOB) approved housing construction and demolition jobs filed or completed in NYC since January 1, 2010. It includes all three construction job types that add or remove residential units: new buildings, major alterations, and demolitions, and can be used to determine the change in legal housing units across time and space. Records in the Database are geocoded to the greatest level of precision possible, subject to numerous quality assurance and control checks, recoded for usability, and joined to other housing data sources relevant to city planners and analysts.

All previously released versions of this data are available at a <a href="https://www1.nyc.gov/site/planning/data-maps/open-data/bytes-archive.page?sorts[year]=0">BYTES of the BIG APPLE- Archive</a>

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
NTAName10ntaname10ntaname10Text
ClassAPropclassapropclassapropNumber
ClassANetclassanetclassanetNumber
HotelInithotelinithotelinitText
HotelProphotelprophotelpropText
OtherBInitotherbinitotherbinitText
OtherBPropotherbpropotherbpropText
UnitsCOunitscounitscoNumber
BINbinbinText
BBLbblbblText
AddressNumaddressnumaddressnumText
AddressStaddressstaddressstText
the_geomthe_geomthe_geomPoint
Job_Typejob_typejob_typeText
NonresFlagnonresflagnonresflagText
BoroboroboroText
Job_Descjob_descjob_descText
ZoningDst2zoningdst2zoningdst2Text
LandmarklandmarklandmarkText
CommntyDstcommntydstcommntydstText
FireDivsnfiredivsnfiredivsnText
PL_FIRM07pl_firm07pl_firm07Text
PL_PFIRM15pl_pfirm15pl_pfirm15Text
Occ_Initocc_initocc_initText
Occ_Propocc_propocc_propText
DateFileddatefileddatefiledCalendar date
DatepermitdatepermitdatepermitCalendar date
DateLstUpddatelstupddatelstupdCalendar date
GeomSourcegeomsourcegeomsourceText
DatecompltdatecompltdatecompltCalendar date
ZoningDst1zoningdst1zoningdst1Text
ZoningDst3zoningdst3zoningdst3Text
ClassAInitclassainitclassainitNumber
PermitYearpermityearpermityearText
CompltYearcompltyearcompltyearText
Job_Statusjob_statusjob_statusText
ResidFlagresidflagresidflagText
Job_Numberjob_numberjob_numberText
Police Precincts:@computed_region_sbqj_enih:@computed_region_sbqj_enihNumberThis column was automatically created in order to record in what polygon from the dataset 'Police Precincts' (sbqj-enih) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
City Council Districts:@computed_region_92fq_4b7q:@computed_region_92fq_4b7qNumberThis column was automatically created in order to record in what polygon from the dataset 'City Council Districts' (92fq-4b7q) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Borough Boundaries:@computed_region_yeji_bk3q:@computed_region_yeji_bk3qNumberThis column was automatically created in order to record in what polygon from the dataset 'Borough Boundaries' (yeji-bk3q) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Community Districts:@computed_region_f5dn_yrer:@computed_region_f5dn_yrerNumberThis column was automatically created in order to record in what polygon from the dataset 'Community Districts' (f5dn-yrer) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Zip Codes:@computed_region_efsh_h5xi:@computed_region_efsh_h5xiNumberThis column was automatically created in order to record in what polygon from the dataset 'Zip Codes' (efsh-h5xi) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
LocationlocationlocationPoint
VersionversionversionText
SpeclDst1specldst1specldst1Text
SpeclDst2specldst2specldst2Text
FloorsInitfloorsinitfloorsinitNumber
FloorsPropfloorspropfloorspropNumber
EnlargemntenlargemntenlargemntText
OwnershipownershipownershipText
DCPEditeddcpediteddcpeditedText
LongitudelongitudelongitudeNumber
LatitudelatitudelatitudeNumber
PolicePcntpolicepcntpolicepcntText
FireBattlnfirebattlnfirebattlnText
FireCmpanyfirecmpanyfirecmpanyText
SchMiddleschmiddleschmiddleText
SchElmntryschelmntryschelmntryText
SchCommntyschcommntyschcommntyText
SchSubDistschsubdistschsubdistText
CouncilDstcouncildstcouncildstText
PUMA2010puma2010puma2010Text
CenBlock10cenblock10cenblock10Text
BCTCB2010bctcb2010bctcb2010Text
BCT2010bct2010bct2010Text
NTA2010nta2010nta2010Text
Upstream Metadata