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:
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:
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