Name: Housing_stats_by_block_group
Display Field:
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -13535964.3905
YMin: 3794155.7249
XMax: -12447685.4591
YMax: 4504154.8914
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"visualVariables":[{"type":"transparencyInfo","valueExpression":"\n $feature[\"TSHU11_CY\"];\n$feature[\"TSHU12_CY\"];\n$feature[\"TSHU13_CY\"];\n$feature[\"TSHU14_CY\"];\n$feature[\"TSHU15_CY\"];\n$feature[\"TSHU16_CY\"];\n$feature[\"TSHU17_CY\"];\n$feature[\"TSHU18_CY\"];\n$feature[\"TSHU19_CY\"];\n$feature[\"TSHU20_CY\"];\n\n \n var fieldNames = [ \"TSHU11_CY\", \"TSHU12_CY\", \"TSHU13_CY\", \"TSHU14_CY\", \"TSHU15_CY\", \"TSHU16_CY\", \"TSHU17_CY\", \"TSHU18_CY\", \"TSHU19_CY\", \"TSHU20_CY\" ];\n var numFields = 10;\n var maxValueField = null;\n var maxValue = -Infinity;\n var value, i, totalValue = null;\n\n for(i = 0; i < numFields; i++) {\n value = $feature[fieldNames[i]];\n\n if(value > 0) {\n if(value > maxValue) {\n maxValue = value;\n maxValueField = fieldNames[i];\n }\n else if (value == maxValue) {\n maxValueField = null;\n }\n }\n \n if(value != null && value >= 0) {\n if (totalValue == null) { totalValue = 0; }\n totalValue = totalValue + value;\n }\n \n }\n \n\n var strength = null;\n\n if (maxValueField != null && totalValue > 0) {\n strength = (maxValue / totalValue) * 100;\n }\n\n return strength;\n ","legendOptions":{"title":"Strength of predominance"},"stops":[{"value":10,"transparency":85},{"value":13.7,"transparency":0}]}],"authoringInfo":{"fields":["TSHU20_CY","TSHU19_CY","TSHU18_CY","TSHU17_CY","TSHU16_CY","TSHU15_CY","TSHU14_CY","TSHU13_CY","TSHU12_CY","TSHU11_CY"],"type":"predominance","visualVariables":[{"maxSliderValue":38.9179,"minSliderValue":0,"type":"transparencyInfo"}]},"type":"uniqueValue","valueExpression":"\n $feature[\"TSHU11_CY\"];\n$feature[\"TSHU12_CY\"];\n$feature[\"TSHU13_CY\"];\n$feature[\"TSHU14_CY\"];\n$feature[\"TSHU15_CY\"];\n$feature[\"TSHU16_CY\"];\n$feature[\"TSHU17_CY\"];\n$feature[\"TSHU18_CY\"];\n$feature[\"TSHU19_CY\"];\n$feature[\"TSHU20_CY\"];\n\n \n var fieldNames = [ \"TSHU11_CY\", \"TSHU12_CY\", \"TSHU13_CY\", \"TSHU14_CY\", \"TSHU15_CY\", \"TSHU16_CY\", \"TSHU17_CY\", \"TSHU18_CY\", \"TSHU19_CY\", \"TSHU20_CY\" ];\n var numFields = 10;\n var maxValueField = null;\n var maxValue = -Infinity;\n var value, i, totalValue = null;\n\n for(i = 0; i < numFields; i++) {\n value = $feature[fieldNames[i]];\n\n if(value > 0) {\n if(value > maxValue) {\n maxValue = value;\n maxValueField = fieldNames[i];\n }\n else if (value == maxValue) {\n maxValueField = null;\n }\n }\n \n }\n \n return maxValueField;\n ","valueExpressionTitle":"Predominant category","uniqueValueInfos":[{"value":"TSHU20_CY","symbol":{"color":[179,0,0,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"2020 Housing Units (Esri 2021)"},{"value":"TSHU19_CY","symbol":{"color":[124,17,88,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"2019 Housing Units (Esri 2021)"},{"value":"TSHU18_CY","symbol":{"color":[68,33,175,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"2018 Housing Units (Esri 2021)"},{"value":"TSHU17_CY","symbol":{"color":[26,83,255,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"2017 Housing Units (Esri 2021)"},{"value":"TSHU16_CY","symbol":{"color":[13,136,230,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"2016 Housing Units (Esri 2021)"},{"value":"TSHU15_CY","symbol":{"color":[0,183,199,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"2015 Housing Units (Esri 2021)"},{"value":"TSHU14_CY","symbol":{"color":[90,212,90,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"2014 Housing Units (Esri 2021)"},{"value":"TSHU13_CY","symbol":{"color":[139,224,78,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"2013 Housing Units (Esri 2021)"},{"value":"TSHU12_CY","symbol":{"color":[197,217,109,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"2012 Housing Units (Esri 2021)"},{"value":"TSHU11_CY","symbol":{"color":[235,220,120,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"2011 Housing Units (Esri 2021)"}]},"transparency":0}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
- FIPS (type: esriFieldTypeString, alias: FIPS, SQL Type: sqlTypeNVarchar, length: 12, nullable: true, editable: true)
- COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeNVarchar, length: 30, nullable: true, editable: true)
- STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
- POPULATION (type: esriFieldTypeInteger, alias: POP2020, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- SQMI (type: esriFieldTypeDouble, alias: SQMI, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- ID (type: esriFieldTypeString, alias: Id, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- sourceCountry (type: esriFieldTypeString, alias: Country code, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- ENRICH_FID (type: esriFieldTypeInteger, alias: ENRICH_FID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- aggregationMethod (type: esriFieldTypeString, alias: Aggregation method, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- populationToPolygonSizeRating (type: esriFieldTypeDouble, alias: Population to polygon size rating for the country, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- apportionmentConfidence (type: esriFieldTypeDouble, alias: Apportionment confidence for the country, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- HasData (type: esriFieldTypeInteger, alias: Has data, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- TSHU10_CY (type: esriFieldTypeDouble, alias: 2010 Housing Units (Esri 2021), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TSHU11_CY (type: esriFieldTypeDouble, alias: 2011 Housing Units (Esri 2021), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TSHU12_CY (type: esriFieldTypeDouble, alias: 2012 Housing Units (Esri 2021), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TSHU13_CY (type: esriFieldTypeDouble, alias: 2013 Housing Units (Esri 2021), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TSHU14_CY (type: esriFieldTypeDouble, alias: 2014 Housing Units (Esri 2021), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TSHU15_CY (type: esriFieldTypeDouble, alias: 2015 Housing Units (Esri 2021), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TSHU16_CY (type: esriFieldTypeDouble, alias: 2016 Housing Units (Esri 2021), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TSHU17_CY (type: esriFieldTypeDouble, alias: 2017 Housing Units (Esri 2021), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TSHU18_CY (type: esriFieldTypeDouble, alias: 2018 Housing Units (Esri 2021), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TSHU19_CY (type: esriFieldTypeDouble, alias: 2019 Housing Units (Esri 2021), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TSHU20_CY (type: esriFieldTypeDouble, alias: 2020 Housing Units (Esri 2021), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TOTHU_CY (type: esriFieldTypeDouble, alias: 2021 Total Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- OWNER_CY (type: esriFieldTypeDouble, alias: 2021 Owner Occupied HUs, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- RENTER_CY (type: esriFieldTypeDouble, alias: 2021 Renter Occupied HUs, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- INCMORT_CY (type: esriFieldTypeDouble, alias: 2021 Pct of Income for Mortgage, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- HAI_CY (type: esriFieldTypeDouble, alias: 2021 Housing Affordability Index, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VACANT_CY (type: esriFieldTypeDouble, alias: 2021 Vacant Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- HHPRATE_CY (type: esriFieldTypeDouble, alias: 2021 HH-Weighted Property Tax Rate, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- TOTHU20 (type: esriFieldTypeDouble, alias: 2020 Total Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- HUGRW1020 (type: esriFieldTypeDouble, alias: 2010-2020 Growth Rate: Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- HUGRW0020 (type: esriFieldTypeDouble, alias: 2000-2020 Growth Rate: Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VACANT20 (type: esriFieldTypeDouble, alias: 2020 Vacant Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VACGRW1020 (type: esriFieldTypeDouble, alias: 2010-2020 Growth Rate: Vacant Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VACGRW0020 (type: esriFieldTypeDouble, alias: 2000-2020 Growth Rate: Vacant Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL0_CY (type: esriFieldTypeDouble, alias: 2021 Home Value <$50000, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL50K_CY (type: esriFieldTypeDouble, alias: 2021 Home Value $50K-99999, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL100K_CY (type: esriFieldTypeDouble, alias: 2021 Home Value $100K-149999, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL150K_CY (type: esriFieldTypeDouble, alias: 2021 Home Value $150K-199999, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL200K_CY (type: esriFieldTypeDouble, alias: 2021 Home Value $200K-249999, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL250K_CY (type: esriFieldTypeDouble, alias: 2021 Home Value $250K-299999, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL300K_CY (type: esriFieldTypeDouble, alias: 2021 Home Value $300K-399999, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL400K_CY (type: esriFieldTypeDouble, alias: 2021 Home Value $400K-499999, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL500K_CY (type: esriFieldTypeDouble, alias: 2021 Home Value $500K-749999, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL750K_CY (type: esriFieldTypeDouble, alias: 2021 Home Value $750K-999999, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL1M_CY (type: esriFieldTypeDouble, alias: 2021 Home Value $1 Million-1499999, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL1PT5MCY (type: esriFieldTypeDouble, alias: 2021 Home Value $1.5 Million-1999999, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VAL2M_CY (type: esriFieldTypeDouble, alias: 2021 Home Value $2 Million+, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- MEDVAL_CY (type: esriFieldTypeDouble, alias: 2021 Median Home Value, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- AVGVAL_CY (type: esriFieldTypeDouble, alias: 2021 Average Home Value, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- VALBASE_CY (type: esriFieldTypeDouble, alias: 2021 Home Value Base, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/9/2022 4:19:46 PM
Schema Last Edit Date: 2/9/2022 4:19:46 PM
Data Last Edit Date: 2/9/2022 4:19:46 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat