Name: Housing_Database_Inactive_Included

Display Field: NTAName20

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The NYC Department of City Planning’s (DCP) Housing Database 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 Housing 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.

Copyright Text: Department of Buildings (DOB) Job Application Filings, DOB Certificate of Occupancy, DOB Permit Issuance, Department of City Planning (DCP)

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 32000

Supported query Formats: JSON

Use Standardized Queries: True

Extent:

XMin: 913283.043169007
YMin: 121054.875722513
XMax: 1067103.65744318
YMax: 272494.472777084
Spatial Reference: 102718 (2263)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,60,143,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Job_Number (type: esriFieldTypeString, alias: Job_Number, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Job_Type (type: esriFieldTypeString, alias: Job_Type, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ResidFlag (type: esriFieldTypeString, alias: ResidFlag, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• NonresFlag (type: esriFieldTypeString, alias: NonresFlag, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Job_Status (type: esriFieldTypeString, alias: Job_Status, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• CompltYear (type: esriFieldTypeString, alias: CompltYear, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• PermitYear (type: esriFieldTypeString, alias: PermitYear, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ClassAInit (type: esriFieldTypeDouble, alias: ClassAInit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClassAProp (type: esriFieldTypeDouble, alias: ClassAProp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClassANet (type: esriFieldTypeDouble, alias: ClassANet, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HotelInit (type: esriFieldTypeInteger, alias: HotelInit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HotelProp (type: esriFieldTypeInteger, alias: HotelProp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OtherBInit (type: esriFieldTypeInteger, alias: OtherBInit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OtherBProp (type: esriFieldTypeInteger, alias: OtherBProp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Units_CO (type: esriFieldTypeDouble, alias: Units_CO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Boro (type: esriFieldTypeString, alias: Boro, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• BIN (type: esriFieldTypeString, alias: BIN, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• BBL (type: esriFieldTypeString, alias: BBL, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• AddressNum (type: esriFieldTypeString, alias: AddressNum, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• AddressSt (type: esriFieldTypeString, alias: AddressSt, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Occ_Init (type: esriFieldTypeString, alias: Occ_Init, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Occ_Prop (type: esriFieldTypeString, alias: Occ_Prop, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Bldg_Class (type: esriFieldTypeString, alias: Bldg_Class, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Job_Desc (type: esriFieldTypeString, alias: Job_Desc, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• DateFiled (type: esriFieldTypeString, alias: DateFiled, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• DatePermit (type: esriFieldTypeDate, alias: DatePermit, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateLstUpd (type: esriFieldTypeString, alias: DateLstUpd, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• DateComplt (type: esriFieldTypeDate, alias: DateComplt, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ZoningDst1 (type: esriFieldTypeString, alias: ZoningDst1, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ZoningDst2 (type: esriFieldTypeString, alias: ZoningDst2, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ZoningDst3 (type: esriFieldTypeString, alias: ZoningDst3, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• SpeclDst1 (type: esriFieldTypeString, alias: SpeclDst1, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• SpeclDst2 (type: esriFieldTypeString, alias: SpeclDst2, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Landmark (type: esriFieldTypeString, alias: Landmark, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• FloorsInit (type: esriFieldTypeDouble, alias: FloorsInit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FloorsProp (type: esriFieldTypeDouble, alias: FloorsProp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Enlargemnt (type: esriFieldTypeString, alias: Enlargemnt, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• CenBlock20 (type: esriFieldTypeString, alias: CenBlock20, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• CenTract20 (type: esriFieldTypeString, alias: CenTract20, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• BCTCB2020 (type: esriFieldTypeString, alias: BCTCB2020, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• BCT2020 (type: esriFieldTypeString, alias: BCT2020, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• NTA2020 (type: esriFieldTypeString, alias: NTA2020, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• NTAName20 (type: esriFieldTypeString, alias: NTAName20, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• CDTA2020 (type: esriFieldTypeString, alias: CDTA2020, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• CDTAName20 (type: esriFieldTypeString, alias: CDTAName20, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• CommntyDst (type: esriFieldTypeString, alias: CommntyDst, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• CouncilDst (type: esriFieldTypeString, alias: CouncilDst, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• SchSubDist (type: esriFieldTypeString, alias: SchSubDist, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• SchCommnty (type: esriFieldTypeString, alias: SchCommnty, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• SchElmntry (type: esriFieldTypeString, alias: SchElmntry, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• SchMiddle (type: esriFieldTypeString, alias: SchMiddle, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• FireCmpany (type: esriFieldTypeString, alias: FireCmpany, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• FireBattln (type: esriFieldTypeString, alias: FireBattln, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• FireDivsn (type: esriFieldTypeString, alias: FireDivsn, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• PolicePcnt (type: esriFieldTypeString, alias: PolicePcnt, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• PL_FIRM07 (type: esriFieldTypeString, alias: PL_FIRM07, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• PL_PFIRM15 (type: esriFieldTypeString, alias: PL_PFIRM15, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GeomSource (type: esriFieldTypeString, alias: GeomSource, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• DCPEdited (type: esriFieldTypeString, alias: DCPEdited, SQL Type: sqlTypeOther, length: 91, nullable: true, editable: true)
• Version (type: esriFieldTypeString, alias: Version, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)

Templates:

Name: Housing_Database_Inactive_Included
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/28/2023 3:43:04 PM

Schema Last Edit Date: 11/28/2023 3:43:04 PM

Data Last Edit Date: 11/28/2023 3:43:04 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates