Name: Housing Affordability-Income-Growth Relationship
Display Field: NAME
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: ALLCBSAs_2018HAI
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: -19849009.9359
YMin: 2144547.4811
XMax: -7563019.4878
YMax: 9728969.9838
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"visualVariables":[{"type":"sizeInfo","field":"HHGRW10CY","valueExpression":null,"valueUnit":"unknown","minSize":4.5,"maxSize":24,"minDataValue":0.5,"maxDataValue":2.5}],"authoringInfo":{"type":"relationship","numClasses":2,"focus":"HH","field1":{"field":"HAI18","classBreakInfos":[{"minValue":47.4,"maxValue":124},{"minValue":124,"maxValue":350}]},"field2":{"field":"MEDHINC_CY","classBreakInfos":[{"minValue":28294,"maxValue":58000},{"minValue":58000,"maxValue":108337}]},"visualVariables":[{"type":"sizeInfo","minSliderValue":0.01,"maxSliderValue":8.19}]},"type":"uniqueValue","valueExpression":"var field1 = $feature['HAI18'];\nvar field2 = $feature['MEDHINC_CY'];\nvar hasNormField1 = false;\nvar hasNormField2 = false;\nvar normField1 = null;\nvar normField2 = null;\nif (\n IsEmpty(field1) || \n IsEmpty(field2) ||\n (hasNormField1 && (IsEmpty(normField1) || normField1 == 0)) ||\n (hasNormField2 && (IsEmpty(normField2) || normField2 == 0))\n) {\n return null; \n}\nvar value1 = IIf(hasNormField1, (field1 / normField1), field1);\nvar value2 = IIf(hasNormField2, (field2 / normField2), field2);\nvar breaks1 = [[47.4,124],[124,350]];\nvar breaks2 = [[28294,58000],[58000,108337]];\nvar classCodes = [\"L\",\"H\"];\nfunction getClassCode(value, breaks) {\n var code = null;\n for (var i in breaks) {\n var info = breaks[i];\n if (value >= info[0] && value <= info[1]) {\n code = classCodes[i];\n break;\n }\n }\n return code;\n}\nvar code1 = getClassCode(value1, breaks1);\nvar code2 = getClassCode(value2, breaks2);\nvar classValue = IIf(IsEmpty(code1) || IsEmpty(code2), null, code1 + code2);\nreturn classValue;","valueExpressionTitle":"Relationship","uniqueValueInfos":[{"value":"HH","symbol":{"color":[204,90,90,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"High - High"},{"value":"HL","symbol":{"color":[99,22,115,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"High - Low"},{"value":"LH","symbol":{"color":[153,153,153,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Low - High"},{"value":"LL","symbol":{"color":[252,184,48,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Low - Low"}],"backgroundFillSymbol":{"color":null,"outline":{"color":null,"width":0.75,"type":"esriSLS","style":"esriSLSNull"},"type":"esriSFS","style":"esriSFSSolid"}},"transparency":0}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- ID (type: esriFieldTypeString, alias: ID, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- NAME (type: esriFieldTypeString, alias: CBSA Name, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
- CBSA_TYPE (type: esriFieldTypeString, alias: CBSA Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- ST_ABBREV (type: esriFieldTypeString, alias: State Abbreviation, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- TOTHH10 (type: esriFieldTypeDouble, alias: 2010 Total Households, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TOTHH_CY (type: esriFieldTypeDouble, alias: 2018 Total Households, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HHGRW10CY (type: esriFieldTypeDouble, alias: 2010-2018 Household Growth Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HAI18 (type: esriFieldTypeDouble, alias: 2018 Housing Affordability Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MEDHINC_CY (type: esriFieldTypeDouble, alias: 2018 Median Household Income, SQL Type: sqlTypeOther, 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)
- 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)
- IDn (type: esriFieldTypeInteger, alias: IDn, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: Housing Affordability-Income-Growth Relationship
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/3/2019 3:26:35 PM
Schema Last Edit Date: 7/3/2019 3:26:35 PM
Data Last Edit Date: 7/3/2019 3:26:35 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat