cityofnewyork-us/housing-database-project-level-files-uxt4-ugwr
Icon for Socrata external plugin
 
Readme
Updated 5 months ago
Indexed 1 hour 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
ClassAInitclassainitclassainitNumber
CenBlock10cenblock10cenblock10Text
OwnershipownershipownershipText
EnlargemntenlargemntenlargemntText
FloorsPropfloorspropfloorspropNumber
LandmarklandmarklandmarkText
SpeclDst1specldst1specldst1Text
ZoningDst3zoningdst3zoningdst3Text
SchCommntyschcommntyschcommntyText
SchMiddleschmiddleschmiddleText
ZoningDst2zoningdst2zoningdst2Text
ZoningDst1zoningdst1zoningdst1Text
DatecompltdatecompltdatecompltCalendar date
DateLstUpddatelstupddatelstupdCalendar date
FireCmpanyfirecmpanyfirecmpanyText
DateFileddatefileddatefiledCalendar date
Job_Descjob_descjob_descText
Occ_Propocc_propocc_propText
Occ_Initocc_initocc_initText
AddressNumaddressnumaddressnumText
BINbinbinText
UnitsCOunitscounitscoNumber
OtherBPropotherbpropotherbpropText
OtherBInitotherbinitotherbinitText
HotelProphotelprophotelpropText
HotelInithotelinithotelinitText
ClassANetclassanetclassanetNumber
NTA2010nta2010nta2010Text
the_geomthe_geomthe_geomPoint
FireDivsnfiredivsnfiredivsnText
LongitudelongitudelongitudeNumber
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.
LatitudelatitudelatitudeNumber
ResidFlagresidflagresidflagText
PL_PFIRM15pl_pfirm15pl_pfirm15Text
DCPEditeddcpediteddcpeditedText
Job_Statusjob_statusjob_statusText
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.
CompltYearcompltyearcompltyearText
GeomSourcegeomsourcegeomsourceText
SpeclDst2specldst2specldst2Text
BCT2010bct2010bct2010Text
VersionversionversionText
Job_Numberjob_numberjob_numberText
PermitYearpermityearpermityearText
ClassAPropclassapropclassapropNumber
BBLbblbblText
AddressStaddressstaddressstText
DatepermitdatepermitdatepermitCalendar date
FloorsInitfloorsinitfloorsinitNumber
BCTCB2010bctcb2010bctcb2010Text
CouncilDstcouncildstcouncildstText
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
BoroboroboroText
NonresFlagnonresflagnonresflagText
Job_Typejob_typejob_typeText
PL_FIRM07pl_firm07pl_firm07Text
PolicePcntpolicepcntpolicepcntText
FireBattlnfirebattlnfirebattlnText
SchElmntryschelmntryschelmntryText
SchSubDistschsubdistschsubdistText
CommntyDstcommntydstcommntydstText
PUMA2010puma2010puma2010Text
NTAName10ntaname10ntaname10Text
 
Preview
  • housing_database_project_level_files
     
Upstream Metadata