Name: Enriched_Senior_Afford_Index

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: -13714791.2518
YMin: 5903316.6335
XMax: -13603544.6753
YMax: 5973832.0656
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"visualVariables":null,"authoringInfo":{"type":"relationship","numClasses":3,"focus":"HH","field1":{"field":"EDR_CY","classBreakInfos":[{"minValue":0,"maxValue":94.1},{"minValue":94.1,"maxValue":115.4},{"minValue":115.4,"maxValue":1250.5}]},"field2":{"field":"HAI_CY","classBreakInfos":[{"minValue":0,"maxValue":102},{"minValue":102,"maxValue":124},{"minValue":124,"maxValue":350}]},"classificationMethod":"esriClassifyQuantile"},"type":"uniqueValue","valueExpression":"var field1 = $feature['EDR_CY'];\nvar field2 = $feature['HAI_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 = [[0,94.1],[94.1,115.4],[115.4,1250.5]];\nvar breaks2 = [[0,102],[102,124],[124,350]];\nvar classCodes = [\"L\",\"M\",\"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","label":"High - High","symbol":{"color":[92,71,61,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"HM","label":"High - Medium","symbol":{"color":[66,122,142,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"HL","label":"High - Low","symbol":{"color":[0,175,231,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"MH","label":"Medium - High","symbol":{"color":[170,95,55,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"MM","label":"Medium - Medium","symbol":{"color":[175,151,139,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"ML","label":"Medium - Low","symbol":{"color":[152,207,229,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"LH","label":"Low - High","symbol":{"color":[249,117,41,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"LM","label":"Low - Medium","symbol":{"color":[255,178,134,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"LL","label":"Low - Low","symbol":{"color":[255,239,226,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}}]},"transparency":25,"showLabels":false}

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• STATEFP10 (type: esriFieldTypeString, alias: STATEFP10, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
• COUNTYFP10 (type: esriFieldTypeString, alias: COUNTYFP10, SQL Type: sqlTypeNVarchar, length: 3, nullable: true, editable: true)
• TRACTCE10 (type: esriFieldTypeString, alias: TRACTCE10, SQL Type: sqlTypeNVarchar, length: 6, nullable: true, editable: true)
• BLKGRPCE10 (type: esriFieldTypeString, alias: BLKGRPCE10, SQL Type: sqlTypeNVarchar, length: 1, nullable: true, editable: true)
• GEOID10 (type: esriFieldTypeString, alias: GEOID10, SQL Type: sqlTypeNVarchar, length: 12, nullable: true, editable: true)
• NAMELSAD10 (type: esriFieldTypeString, alias: NAMELSAD10, SQL Type: sqlTypeNVarchar, length: 13, nullable: true, editable: true)
• MTFCC10 (type: esriFieldTypeString, alias: MTFCC10, SQL Type: sqlTypeNVarchar, length: 5, nullable: true, editable: true)
• FUNCSTAT10 (type: esriFieldTypeString, alias: FUNCSTAT10, SQL Type: sqlTypeNVarchar, length: 1, nullable: true, editable: true)
• ALAND10 (type: esriFieldTypeDouble, alias: ALAND10, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• AWATER10 (type: esriFieldTypeDouble, alias: AWATER10, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• INTPTLAT10 (type: esriFieldTypeString, alias: INTPTLAT10, SQL Type: sqlTypeNVarchar, length: 11, nullable: true, editable: true)
• INTPTLON10 (type: esriFieldTypeString, alias: INTPTLON10, SQL Type: sqlTypeNVarchar, length: 12, nullable: true, editable: true)
• ACRES (type: esriFieldTypeDouble, alias: ACRES, 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)
• TOTPOP_CY (type: esriFieldTypeDouble, alias: 2021 Total Population, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• MEDHINC_CY (type: esriFieldTypeDouble, alias: 2021 Median Household Income, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• AVGHINC_CY (type: esriFieldTypeDouble, alias: 2021 Average Household Income, 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)
• AVGHHSZ_CY (type: esriFieldTypeDouble, alias: 2021 Average Household Size, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• HAI_CY (type: esriFieldTypeDouble, alias: 2021 Housing Affordability Index, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• AVGFMSZ_CY (type: esriFieldTypeDouble, alias: 2021 Average Family Size, 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)
• 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)
• RENTER_CY (type: esriFieldTypeDouble, alias: 2021 Renter Occupied HUs, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACANT_CY (type: esriFieldTypeDouble, alias: 2021 Vacant Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• DIVINDX_CY (type: esriFieldTypeDouble, alias: 2021 Diversity Index, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• HISPPOP_CY (type: esriFieldTypeDouble, alias: 2021 Hispanic Population, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• WHITE_CY (type: esriFieldTypeDouble, alias: 2021 White Population, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• POPDENS_CY (type: esriFieldTypeDouble, alias: 2021 Population Density, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• EDR_CY (type: esriFieldTypeDouble, alias: 2021 EDR, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ID_1 (type: esriFieldTypeString, alias: Id, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• sourceCountry_1 (type: esriFieldTypeString, alias: Country code, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ENRICH_FID_1 (type: esriFieldTypeInteger, alias: ENRICH_FID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• aggregationMethod_1 (type: esriFieldTypeString, alias: Aggregation method, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• populationToPolygonSizeRating_1 (type: esriFieldTypeDouble, alias: Population to polygon size rating for the country, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• apportionmentConfidence_1 (type: esriFieldTypeDouble, alias: Apportionment confidence for the country, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• HasData_1 (type: esriFieldTypeInteger, alias: Has data, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SENREDR_CY (type: esriFieldTypeDouble, alias: 2021 Senior EDR, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• CHLDEDR_CY (type: esriFieldTypeDouble, alias: 2021 Child EDR, SQL Type: sqlTypeDecimal, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/28/2021 3:46:42 AM

Schema Last Edit Date: 11/28/2021 3:46:42 AM

Data Last Edit Date: 11/28/2021 3:46:42 AM

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