Layer: Enriched_USA_States_(Generalized) (ID:0)

View In: Map Viewer

Name: Enriched_USA_States_(Generalized)

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:

Drawing Info:

{"renderer":{"visualVariables":[{"type":"transparencyInfo","valueExpression":"// Write a script that returns a value that will be used to draw features.\n// For example, find the percentage of males:\n// Round(($feature.MalePop / $feature.TotalPop) * 100, 2)\n\n/******************* % Strength of Predominance ********************************/\n\n\nvar fields = [\n { value: $feature.INDADMN_CY, alias: \"Admin/Waste Mgmt\" },\n { value: $feature.INDAGRI_CY, alias: \"Agriculture\" },\n { value: $feature.INDARTS_CY, alias: \"Arts/Entertainment/Rec\" },\n { value: $feature.INDCONS_CY, alias: \"Construction\" },\n { value: $feature.INDEDUC_CY, alias: \"Educational Services\" },\n { value: $feature.INDFIN_CY, alias: \"Finance/Insurance\" },\n { value: $feature.INDFOOD_CY, alias: \"Accommodation/Food Svcs\" },\n { value: $feature.INDHLTH_CY, alias: \"Health Care\" },\n { value: $feature.INDINFO_CY, alias: \"Information\" },\n { value: $feature.INDMANU_CY, alias: \"Manufacturing\" },\n { value: $feature.INDMGMT_CY, alias: \"Management\" },\n { value: $feature.INDMIN_CY, alias: \"Mining\" },\n { value: $feature.INDOTSV_CY, alias: \"Other Services\" },\n { value: $feature.INDPUBL_CY, alias: \"Public Administration\" },\n { value: $feature.INDRE_CY, alias: \"Real Estate\" },\n { value: $feature.INDRTTR_CY, alias: \"Retail Trade\" },\n { value: $feature.INDTECH_CY, alias: \"Professional/Tech Svcs\" },\n { value: $feature.INDTRAN_CY, alias: \"Transportation\" },\n { value: $feature.INDUTIL_CY, alias: \"Utilities\" },\n { value: $feature.INDWHTR_CY, alias: \"Wholesale Trade\" }\n];\n\nfunction map (array, callback){\n var values = [];\n for(var k in array){\n values[k] = callback(array[k]);\n }\n return values;\n}\n\nfunction getFieldValueCallback (field){\n return field.value;\n}\n\nfunction getFieldValues(fieldsArray){\n return map(fieldsArray, getFieldValueCallback);\n}\n\nvar fieldValues = getFieldValues(fields);\n\nvar winner = Max(fieldValues);\nvar total = Sum(fieldValues);\nreturn (winner/total) * 100;\n","valueExpressionTitle":"Strength of Predominance","stops":[{"value":13.1,"transparency":70},{"value":17,"transparency":0}]},{"type":"sizeInfo","field":null,"valueExpression":"$feature[\"INDADMN_CY\"]+\n$feature[\"INDAGRI_CY\"]+\n$feature[\"INDARTS_CY\"]+\n$feature[\"INDCONS_CY\"]+\n$feature[\"INDEDUC_CY\"]+\n$feature[\"INDFIN_CY\"]+\n$feature[\"INDFOOD_CY\"]+\n$feature[\"INDHLTH_CY\"]+\n$feature[\"INDINFO_CY\"]+\n$feature[\"INDMANU_CY\"]+\n$feature[\"INDMGMT_CY\"]+\n$feature[\"INDMIN_CY\"]+\n$feature[\"INDOTSV_CY\"]+\n$feature[\"INDPUBL_CY\"]+\n$feature[\"INDRE_CY\"]+\n$feature[\"INDRTTR_CY\"]+\n$feature[\"INDTECH_CY\"]+\n$feature[\"INDTRAN_CY\"]+\n$feature[\"INDUTIL_CY\"]+\n$feature[\"INDWHTR_CY\"]","valueExpressionTitle":"Total Workers","valueUnit":"unknown","minSize":{"type":"sizeInfo","expression":"view.scale","valueExpression":"$view.scale","stops":[{"value":1128,"size":12},{"value":288895,"size":12},{"value":73957191,"size":6.75},{"value":591657528,"size":1.5}]},"maxSize":{"type":"sizeInfo","expression":"view.scale","valueExpression":"$view.scale","stops":[{"value":1128,"size":60},{"value":288895,"size":60},{"value":73957191,"size":37.5},{"value":591657528,"size":18.75}]},"minDataValue":300000,"maxDataValue":18000000}],"authoringInfo":{"visualVariables":[{"type":"sizeInfo","minSliderValue":298163,"maxSliderValue":18497112},{"type":"transparencyInfo","minSliderValue":11.505429023764796,"maxSliderValue":19.344650200399236}]},"type":"uniqueValue","field1":null,"valueExpression":"// Write a script that returns a value that will be used to draw features.\n// For example, find the percentage of males:\n// Round(($feature.MalePop / $feature.TotalPop) * 100, 2)\n\n/************************ Predominant Category *******************************************/\n\nvar fields = [\n { value: $feature.INDADMN_CY, alias: \"Admin/Waste Mgmt\" },\n { value: $feature.INDAGRI_CY, alias: \"Agriculture/Forestry/Fishing & Hunting\" },\n { value: $feature.INDARTS_CY, alias: \"Arts/Entertainment/Recreation\" },\n { value: $feature.INDCONS_CY, alias: \"Construction\" },\n { value: $feature.INDEDUC_CY, alias: \"Educational Services\" },\n { value: $feature.INDFIN_CY, alias: \"Finance/Insurance\" },\n { value: $feature.INDFOOD_CY, alias: \"Accommodation/Food Services\" },\n { value: $feature.INDHLTH_CY, alias: \"Health Care/Social Services\" },\n { value: $feature.INDINFO_CY, alias: \"Information\" },\n { value: $feature.INDMANU_CY, alias: \"Manufacturing\" },\n { value: $feature.INDMGMT_CY, alias: \"Management\" },\n { value: $feature.INDMIN_CY, alias: \"Mining/Quarrying/Oil & Gas Extraction\" },\n { value: $feature.INDOTSV_CY, alias: \"Other Services\" },\n { value: $feature.INDPUBL_CY, alias: \"Public Administration\" },\n { value: $feature.INDRE_CY, alias: \"Real Estate\" },\n { value: $feature.INDRTTR_CY, alias: \"Retail Trade\" },\n { value: $feature.INDTECH_CY, alias: \"Professional/Technical Services\" },\n { value: $feature.INDTRAN_CY, alias: \"Transportation\" },\n { value: $feature.INDUTIL_CY, alias: \"Utilities\" },\n { value: $feature.INDWHTR_CY, alias: \"Wholesale Trade\" }\n];\n\nfunction getPredominantCategory(fieldsArray){\n var maxValue = -Infinity;\n var maxCategory = \"\";\n for(var k in fieldsArray){\n if(fieldsArray[k].value > maxValue){\n maxValue = fieldsArray[k].value;\n maxCategory = fieldsArray[k].alias;\n } else if (fieldsArray[k].value == maxValue){\n maxCategory = maxCategory + \"/\" + fieldsArray[k].alias;\n } else {\n // max and predominant categories remain the same\n }\n }\n return maxCategory;\n}\n\ngetPredominantCategory(fields);\n","valueExpressionTitle":"Predominant Industry","uniqueValueInfos":[{"value":"Health Care/Social Services","symbol":{"color":[237,81,81,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Health Care/Social Services"},{"value":"Manufacturing","symbol":{"color":[20,158,206,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Manufacturing"},{"value":"Accommodation/Food Services","symbol":{"color":[247,137,216,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Accommodation/Food Services"},{"value":"Professional/Technical Services","symbol":{"color":[107,107,214,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Professional/Technical Services"},{"value":"Retail Trade","symbol":{"color":[158,85,156,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Retail Trade"}],"backgroundFillSymbol":{"color":[0,0,0,0],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},"transparency":20}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
STATE_NAME (type: esriFieldTypeString, alias: STATE_NAME, SQL Type: sqlTypeNVarchar, length: 25, nullable: true, editable: true)
STATE_FIPS (type: esriFieldTypeString, alias: STATE_FIPS, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
SUB_REGION (type: esriFieldTypeString, alias: SUB_REGION, SQL Type: sqlTypeNVarchar, length: 20, nullable: true, editable: true)
STATE_ABBR (type: esriFieldTypeString, alias: STATE_ABBR, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
POPULATION (type: esriFieldTypeInteger, alias: POPULATION, SQL Type: sqlTypeInteger, nullable: true, editable: true)
POP_SQMI (type: esriFieldTypeDouble, alias: POP_SQMI, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
POP2010 (type: esriFieldTypeInteger, alias: POP2010, SQL Type: sqlTypeInteger, nullable: true, editable: true)
POP10_SQMI (type: esriFieldTypeDouble, alias: POP10_SQMI, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
WHITE (type: esriFieldTypeInteger, alias: WHITE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
BLACK (type: esriFieldTypeInteger, alias: BLACK, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AMERI_ES (type: esriFieldTypeInteger, alias: AMERI_ES, SQL Type: sqlTypeInteger, nullable: true, editable: true)
ASIAN (type: esriFieldTypeInteger, alias: ASIAN, SQL Type: sqlTypeInteger, nullable: true, editable: true)
HAWN_PI (type: esriFieldTypeInteger, alias: HAWN_PI, SQL Type: sqlTypeInteger, nullable: true, editable: true)
HISPANIC (type: esriFieldTypeInteger, alias: HISPANIC, SQL Type: sqlTypeInteger, nullable: true, editable: true)
OTHER (type: esriFieldTypeInteger, alias: OTHER, SQL Type: sqlTypeInteger, nullable: true, editable: true)
MULT_RACE (type: esriFieldTypeInteger, alias: MULT_RACE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
MALES (type: esriFieldTypeInteger, alias: MALES, SQL Type: sqlTypeInteger, nullable: true, editable: true)
FEMALES (type: esriFieldTypeInteger, alias: FEMALES, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_UNDER5 (type: esriFieldTypeInteger, alias: AGE_UNDER5, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_5_9 (type: esriFieldTypeInteger, alias: AGE_5_9, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_10_14 (type: esriFieldTypeInteger, alias: AGE_10_14, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_15_19 (type: esriFieldTypeInteger, alias: AGE_15_19, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_20_24 (type: esriFieldTypeInteger, alias: AGE_20_24, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_25_34 (type: esriFieldTypeInteger, alias: AGE_25_34, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_35_44 (type: esriFieldTypeInteger, alias: AGE_35_44, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_45_54 (type: esriFieldTypeInteger, alias: AGE_45_54, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_55_64 (type: esriFieldTypeInteger, alias: AGE_55_64, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_65_74 (type: esriFieldTypeInteger, alias: AGE_65_74, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_75_84 (type: esriFieldTypeInteger, alias: AGE_75_84, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AGE_85_UP (type: esriFieldTypeInteger, alias: AGE_85_UP, SQL Type: sqlTypeInteger, nullable: true, editable: true)
MED_AGE (type: esriFieldTypeDouble, alias: MED_AGE, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
MED_AGE_M (type: esriFieldTypeDouble, alias: MED_AGE_M, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
MED_AGE_F (type: esriFieldTypeDouble, alias: MED_AGE_F, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
HOUSEHOLDS (type: esriFieldTypeInteger, alias: HOUSEHOLDS, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AVE_HH_SZ (type: esriFieldTypeDouble, alias: AVE_HH_SZ, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
HSEHLD_1_M (type: esriFieldTypeInteger, alias: HSEHLD_1_M, SQL Type: sqlTypeInteger, nullable: true, editable: true)
HSEHLD_1_F (type: esriFieldTypeInteger, alias: HSEHLD_1_F, SQL Type: sqlTypeInteger, nullable: true, editable: true)
MARHH_CHD (type: esriFieldTypeInteger, alias: MARHH_CHD, SQL Type: sqlTypeInteger, nullable: true, editable: true)
MARHH_NO_C (type: esriFieldTypeInteger, alias: MARHH_NO_C, SQL Type: sqlTypeInteger, nullable: true, editable: true)
MHH_CHILD (type: esriFieldTypeInteger, alias: MHH_CHILD, SQL Type: sqlTypeInteger, nullable: true, editable: true)
FHH_CHILD (type: esriFieldTypeInteger, alias: FHH_CHILD, SQL Type: sqlTypeInteger, nullable: true, editable: true)
FAMILIES (type: esriFieldTypeInteger, alias: FAMILIES, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AVE_FAM_SZ (type: esriFieldTypeDouble, alias: AVE_FAM_SZ, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
HSE_UNITS (type: esriFieldTypeInteger, alias: HSE_UNITS, SQL Type: sqlTypeInteger, nullable: true, editable: true)
VACANT (type: esriFieldTypeInteger, alias: VACANT, SQL Type: sqlTypeInteger, nullable: true, editable: true)
OWNER_OCC (type: esriFieldTypeInteger, alias: OWNER_OCC, SQL Type: sqlTypeInteger, nullable: true, editable: true)
RENTER_OCC (type: esriFieldTypeInteger, alias: RENTER_OCC, SQL Type: sqlTypeInteger, nullable: true, editable: true)
NO_FARMS12 (type: esriFieldTypeDouble, alias: NO_FARMS12, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
AVE_SIZE12 (type: esriFieldTypeDouble, alias: AVE_SIZE12, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
CROP_ACR12 (type: esriFieldTypeDouble, alias: CROP_ACR12, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
AVE_SALE12 (type: esriFieldTypeDouble, alias: AVE_SALE12, SQL Type: sqlTypeDecimal, 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: sourceCountry, 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: aggregationMethod, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
HasData (type: esriFieldTypeInteger, alias: HasData, SQL Type: sqlTypeInteger, nullable: true, editable: true)
INDAGRI_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Agriculture, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDMIN_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Mining, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDCONS_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Construction, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDMANU_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Manufacturing, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDWHTR_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Wholesale Trade, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDRTTR_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Retail Trade, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDTRAN_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Transportation, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDUTIL_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Utilities, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDINFO_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Information, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDFIN_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Finance/Insurance, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDRE_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Real Estate, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDTECH_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Professional/Tech Svcs, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDMGMT_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Management, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDADMN_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Admin/Waste Mgmt, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDEDUC_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Educational Services, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDHLTH_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Health Care, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDARTS_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Arts/Entertainment/Rec, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDFOOD_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Accommodation/Food Svcs, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDOTSV_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Other Services, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
INDPUBL_CY (type: esriFieldTypeDouble, alias: 2018 Industry: Public Administration, SQL Type: sqlTypeDecimal, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/24/2018 12:22:03 AM

Schema Last Edit Date: 8/24/2018 12:22:03 AM

Data Last Edit Date: 8/24/2018 12:22:03 AM

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