Name: Condensed_Housing_Data_Region

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• id (type: esriFieldTypeString, alias: id, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• id2 (type: esriFieldTypeString, alias: id2, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Geography (type: esriFieldTypeString, alias: Geography, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Total_Housing_Units_in_2000 (type: esriFieldTypeInteger, alias: Total Housing Units in 2000, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Housing_Units_in_2010 (type: esriFieldTypeInteger, alias: Total Housing Units in 2010, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Housing_Units_in_2012 (type: esriFieldTypeInteger, alias: Total Housing Units in 2012, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Housing_Units_in_2017 (type: esriFieldTypeInteger, alias: Total Housing Units in 2017, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Housing_Units_in_2018 (type: esriFieldTypeInteger, alias: Total Housing Units in 2018, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Housing_Units_in_2019 (type: esriFieldTypeInteger, alias: Total Housing Units in 2019, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2017_Vacant_Housing_Units_Tota (type: esriFieldTypeInteger, alias: 2017 Vacant Housing Units Total, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2017_Occupied_Housing_Units_To (type: esriFieldTypeInteger, alias: 2017 Occupied Housing Units Total, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2017_Owner_Occupied_Housing_Un (type: esriFieldTypeInteger, alias: 2017 Owner Occupied Housing Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2017_Renter_Occupied_Housing_U (type: esriFieldTypeInteger, alias: 2017 Renter Occupied Housing Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2012_Vacant_Housing_Units (type: esriFieldTypeInteger, alias: 2012 Vacant Housing Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2012_Occupied_Housing_Units_To (type: esriFieldTypeInteger, alias: 2012 Occupied Housing Units Total, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2012_Owner_Occupied_Housing_Un (type: esriFieldTypeInteger, alias: 2012 Owner Occupied Housing Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2012_Renter_Occupied_Housing_U (type: esriFieldTypeInteger, alias: 2012 Renter Occupied Housing Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2010_Vacant_Housing_Units (type: esriFieldTypeInteger, alias: 2010 Vacant Housing Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2010_Occupied_Housing_Units_To (type: esriFieldTypeInteger, alias: 2010 Occupied Housing Units Total, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2010_Owner_Occupied_Housing_Un (type: esriFieldTypeInteger, alias: 2010 Owner Occupied Housing Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2010_Renter_Occupied_Housing_U (type: esriFieldTypeInteger, alias: 2010 Renter Occupied Housing Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2000_Vacant_Housing_Units (type: esriFieldTypeInteger, alias: 2000 Vacant Housing Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2000_Occupied_Housing_Units_To (type: esriFieldTypeInteger, alias: 2000 Occupied Housing Units Total, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2000_Owner_Occupied_Housing_Un (type: esriFieldTypeInteger, alias: 2000 Owner Occupied Housing Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2000_Renter_Occupied_Housing_U (type: esriFieldTypeInteger, alias: 2000 Renter Occupied Housing Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Percent_change_in_housing_price (type: esriFieldTypeString, alias: Percent change in housing price index by county - purchase only, 1990 to first quarter 2018, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Percent_change_in_housing_pri_1 (type: esriFieldTypeString, alias: Percent change in housing price index by county - purchase only, 2000 to first quarter 2018, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Average_Annual_Growth_Rate__199 (type: esriFieldTypeString, alias: Average Annual Growth Rate, 1990 to first quarter 2018, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Average_Annual_Growth_Rate__200 (type: esriFieldTypeDouble, alias: Average Annual Growth Rate, 2000 to first quarter 2018, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• F2017_Households__Estimate__Med (type: esriFieldTypeInteger, alias: 2017 Households; Estimate; Median income (dollars), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2017_Estimate__Median_value__d (type: esriFieldTypeInteger, alias: 2017 Estimate; Median value (dollars), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2017_Estimate__Median_gross_re (type: esriFieldTypeInteger, alias: 2017 Estimate; Median gross rent, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F2017_Number__Estimate__All_hou (type: esriFieldTypeInteger, alias: 2017 Number; Estimate; All households, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/27/2020 2:50:06 PM

Schema Last Edit Date: 10/27/2020 2:50:06 PM

Data Last Edit Date: 10/27/2020 2:50:06 PM

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