Name: Housing_Database_by_Census_Block

Display Field: bctcb2020

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: The NYC Department of City Planning’s (DCP) Housing Database Aggregate Tables provide the 2010 census count of housing units, the net change in Class A housing units since the census, and the count of units pending completion for commonly used political and statistical boundaries. These tables are aggregated from the DCP Housing Database, which is derived from Department of Buildings (DOB)-approved housing construction and demolition jobs filed or completed in NYC since January 1, 2010. Net housing unit change is calculated as the sum of 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.

Copyright Text: DOB Job Application Filings Open Data, DOB Certificate of Occupancy Open Data, DOB Permit Issuance Open Data, NYC DCP

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 4000

Supported query Formats: JSON

Use Standardized Queries: True

Extent:

XMin: 913175.108673587
YMin: 120128.370029584
XMax: 1067382.50826342
YMax: 272844.293927833
Spatial Reference: 102718 (2263)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[201,235,242,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

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)
• bctcb2020 (type: esriFieldTypeString, alias: bctcb2020, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• cenblock20 (type: esriFieldTypeString, alias: cenblock20, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• comp2020ap (type: esriFieldTypeDouble, alias: comp2020ap, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2010 (type: esriFieldTypeDouble, alias: comp2010, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2011 (type: esriFieldTypeDouble, alias: comp2011, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2012 (type: esriFieldTypeDouble, alias: comp2012, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2013 (type: esriFieldTypeDouble, alias: comp2013, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2014 (type: esriFieldTypeDouble, alias: comp2014, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2015 (type: esriFieldTypeDouble, alias: comp2015, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2016 (type: esriFieldTypeDouble, alias: comp2016, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2017 (type: esriFieldTypeDouble, alias: comp2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2018 (type: esriFieldTypeDouble, alias: comp2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2019 (type: esriFieldTypeDouble, alias: comp2019, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2020 (type: esriFieldTypeDouble, alias: comp2020, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2021 (type: esriFieldTypeDouble, alias: comp2021, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2022 (type: esriFieldTypeDouble, alias: comp2022, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp2023 (type: esriFieldTypeDouble, alias: comp2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cenunits20 (type: esriFieldTypeInteger, alias: cenunits20, SQL Type: sqlTypeOther, nullable: true, editable: true)
• filed (type: esriFieldTypeDouble, alias: filed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• approved (type: esriFieldTypeDouble, alias: approved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• permitted (type: esriFieldTypeDouble, alias: permitted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• withdrawn (type: esriFieldTypeDouble, alias: withdrawn, SQL Type: sqlTypeOther, nullable: true, editable: true)
• inactive (type: esriFieldTypeDouble, alias: inactive, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape_Leng (type: esriFieldTypeDouble, alias: Shape_Leng, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Housing_Database_by_Census_Block
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/16/2024 4:29:02 PM

Schema Last Edit Date: 4/16/2024 4:29:02 PM

Data Last Edit Date: 4/16/2024 4:29:02 PM

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