Name: OCVID_INC_VAL_relationship

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: -13888506.6579694
YMin: 5707500.82902678
XMax: -13015028.3638695
YMax: 6275284.42112679
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"visualVariables":[{"type":"sizeInfo","target":"outline","expression":"view.scale","valueExpression":"$view.scale","stops":[{"size":1.5,"value":177289},{"size":0.75,"value":554029},{"size":0.375,"value":2216114},{"size":0,"value":4432228}]}],"authoringInfo":{"type":"relationship","numClasses":3,"focus":"HH","field1":{"field":"MEDVAL_CY","normalizationField":"ACSMEDVAL","classBreakInfos":[{"minValue":0,"maxValue":1.174187},{"minValue":1.174187,"maxValue":1.324304},{"minValue":1.324304,"maxValue":3.867458}]},"field2":{"field":"MEDHINC_CY","normalizationField":"ACSMEDHINC","classBreakInfos":[{"minValue":0,"maxValue":1.022136},{"minValue":1.022136,"maxValue":1.080614},{"minValue":1.080614,"maxValue":1.381772}]},"classificationMethod":"esriClassifyQuantile"},"type":"uniqueValue","valueExpression":"var field1 = $feature['MEDVAL_CY'];\nvar field2 = $feature['MEDHINC_CY'];\nvar hasNormField1 = true;\nvar hasNormField2 = true;\nvar normField1 = $feature['ACSMEDVAL'];\nvar normField2 = $feature['ACSMEDHINC'];\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,1.174187],[1.174187,1.324304],[1.324304,3.867458]];\nvar breaks2 = [[0,1.022136],[1.022136,1.080614],[1.080614,1.381772]];\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":26}

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)
• FIPS (type: esriFieldTypeString, alias: FIPS, SQL Type: sqlTypeNVarchar, length: 11, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeNVarchar, length: 50, 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)
• MEDHINC_CY (type: esriFieldTypeDouble, alias: 2021 Median Household Income, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSMEDHINC (type: esriFieldTypeDouble, alias: 2019 Median HH Income (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSMEDVAL (type: esriFieldTypeDouble, alias: 2019 Median Home Value (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• MEDVAL_CY (type: esriFieldTypeDouble, alias: 2021 Median Home Value, SQL Type: sqlTypeDecimal, nullable: true, editable: true)

Templates:

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

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/5/2021 10:54:02 PM

Schema Last Edit Date: 12/5/2021 10:54:02 PM

Data Last Edit Date: 12/5/2021 10:54:02 PM

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