Name: Enriched_Enriched_Tri_county_Basic

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: -13733696.0836
YMin: 5842137.1046
XMax: -13431217.1983
YMax: 6275284.4211
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"visualVariables":[{"type":"sizeInfo","target":"outline","expression":"view.scale","valueExpression":"$view.scale","stops":[{"size":1.5,"value":223790},{"size":0.75,"value":699342},{"size":0.375,"value":2797369},{"size":0,"value":5594738}]}],"authoringInfo":{"type":"relationship","numClasses":3,"focus":"HH","field1":{"field":"MEDVAL_CY","classBreakInfos":[{"minValue":36250,"maxValue":323485},{"minValue":323485,"maxValue":425000},{"minValue":425000,"maxValue":779948}]},"field2":{"field":"MEDHINC_CY","classBreakInfos":[{"minValue":28886,"maxValue":61341},{"minValue":61341,"maxValue":79282},{"minValue":79282,"maxValue":106536}]},"classificationMethod":"esriClassifyQuantile"},"type":"uniqueValue","valueExpression":"var field1 = $feature['MEDVAL_CY'];\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 = [[36250,323485],[323485,425000],[425000,779948]];\nvar breaks2 = [[28886,61341],[61341,79282],[79282,106536]];\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":0,"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)
• 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)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, 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)
• EDR_CY (type: esriFieldTypeDouble, alias: 2021 EDR, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• SENREDR_CY (type: esriFieldTypeDouble, alias: 2021 Senior EDR, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• AVGHHSZ_CY (type: esriFieldTypeDouble, alias: 2021 Average Household Size, 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)
• ACSHHDIS (type: esriFieldTypeDouble, alias: 2019 HHs w/1+ Persons w/Disability (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• AVGFMSZ10 (type: esriFieldTypeDouble, alias: 2010 Average Family Size, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• AVGNFMSZ10 (type: esriFieldTypeDouble, alias: 2010 Average Nonfamily Size, 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)
• 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)
• ACSMEDVAL (type: esriFieldTypeDouble, alias: 2019 Median Home Value (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSAVGVAL (type: esriFieldTypeDouble, alias: 2019 Average Home Value (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• DIVINDX_CY (type: esriFieldTypeDouble, alias: 2021 Diversity Index, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• AVGFMSZ_CY (type: esriFieldTypeDouble, alias: 2021 Average Family Size, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• TSHU10_CY (type: esriFieldTypeDouble, alias: 2010 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)
• 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)
• VACANT_CY (type: esriFieldTypeDouble, alias: 2021 Vacant Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSTOTHU (type: esriFieldTypeDouble, alias: 2019 Total Housing Units (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSOWNER (type: esriFieldTypeDouble, alias: 2019 Owner Households (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSVCHUNTS (type: esriFieldTypeDouble, alias: 2019 Total Vacant HUs (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSVCFRSLE (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: For Sale Only (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSVCSLDNO (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Sold, Not Occupied (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACANT_FY (type: esriFieldTypeDouble, alias: 2026 Vacant Housing Units, 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)
• ACSMEDHINC (type: esriFieldTypeDouble, alias: 2019 Median HH Income (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSAVGHINC (type: esriFieldTypeDouble, alias: 2019 Average HH Income (ACS 5-Yr), 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: 12/4/2021 8:36:21 PM

Schema Last Edit Date: 12/4/2021 8:36:21 PM

Data Last Edit Date: 12/4/2021 8:36:21 PM

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