Name: Join_Features_to_USA_States_(Generalized)rzz

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: -19839092.3042881
YMin: 2145729.6799178
XMax: -7454985.14648812
YMax: 11542624.9160178
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"visualVariables":[{"type":"sizeInfo","valueExpression":"$feature[\"Female_Commute__45_to_59_minute\"];\n$feature[\"Male_Commute__45_to_59_minutes\"];\n$feature[\"Female_Commute__5_to_9_minutes\"];\n$feature[\"Male_Commute__5_to_9_minutes\"];\nvar fieldNames = [ \"Female_Commute__45_to_59_minute\", \"Male_Commute__45_to_59_minutes\", \"Female_Commute__5_to_9_minutes\", \"Male_Commute__5_to_9_minutes\" ];\nvar numFields = 4;\nvar value, i, totalValue = null;\nfor(i = 0; i < numFields; i++) {\nvalue = $feature[fieldNames[i]];\nif(value != null && value >= 0) {\nif (totalValue == null) { totalValue = 0; }\ntotalValue = totalValue + value;\n}\n}\nreturn totalValue;","valueUnit":"unknown","legendOptions":{"title":"Sum of categories"},"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":54976,"maxDataValue":2858568},{"type":"transparencyInfo","valueExpression":"$feature[\"Female_Commute__45_to_59_minute\"];\n$feature[\"Male_Commute__45_to_59_minutes\"];\n$feature[\"Female_Commute__5_to_9_minutes\"];\n$feature[\"Male_Commute__5_to_9_minutes\"];\nvar fieldNames = [ \"Female_Commute__45_to_59_minute\", \"Male_Commute__45_to_59_minutes\", \"Female_Commute__5_to_9_minutes\", \"Male_Commute__5_to_9_minutes\" ];\nvar numFields = 4;\nvar maxValueField = null;\nvar maxValue = -Infinity;\nvar value, i, totalValue = null;\nfor(i = 0; i < numFields; i++) {\nvalue = $feature[fieldNames[i]];\nif(value > 0) {\nif(value > maxValue) {\nmaxValue = value;\nmaxValueField = fieldNames[i];\n}\nelse if (value == maxValue) {\nmaxValueField = null;\n}\n}\nif(value != null && value >= 0) {\nif (totalValue == null) { totalValue = 0; }\ntotalValue = totalValue + value;\n}\n}\nvar strength = null;\nif (maxValueField != null && totalValue > 0) {\nstrength = (maxValue / totalValue) * 100;\n}\nreturn strength;","stops":[{"value":25,"transparency":85},{"value":40.8,"transparency":0}],"legendOptions":{"title":"Strength of predominance"}}],"authoringInfo":{"type":"predominance","fields":["Female_Commute__45_to_59_minute","Male_Commute__45_to_59_minutes","Female_Commute__5_to_9_minutes","Male_Commute__5_to_9_minutes"],"visualVariables":[{"type":"transparencyInfo","minSliderValue":0,"maxSliderValue":100}]},"type":"uniqueValue","valueExpression":"$feature[\"Female_Commute__45_to_59_minute\"];\n$feature[\"Male_Commute__45_to_59_minutes\"];\n$feature[\"Female_Commute__5_to_9_minutes\"];\n$feature[\"Male_Commute__5_to_9_minutes\"];\nvar fieldNames = [ \"Female_Commute__45_to_59_minute\", \"Male_Commute__45_to_59_minutes\", \"Female_Commute__5_to_9_minutes\", \"Male_Commute__5_to_9_minutes\" ];\nvar numFields = 4;\nvar maxValueField = null;\nvar maxValue = -Infinity;\nvar value, i, totalValue = null;\nfor(i = 0; i < numFields; i++) {\nvalue = $feature[fieldNames[i]];\nif(value > 0) {\nif(value > maxValue) {\nmaxValue = value;\nmaxValueField = fieldNames[i];\n}\nelse if (value == maxValue) {\nmaxValueField = null;\n}\n}\n}\nreturn maxValueField;","valueExpressionTitle":"Predominant category","uniqueValueInfos":[{"value":"Female_Commute__5_to_9_minutes","symbol":{"color":[132,0,168,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Female Commute: 5 to 9 minutes"},{"value":"Male_Commute__45_to_59_minutes","symbol":{"color":[38,115,0,64],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Male Commute: 45 to 59 minutes"},{"value":"Male_Commute__5_to_9_minutes","symbol":{"color":[38,115,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Male Commute: 5 to 9 minutes"},{"value":"Female_Commute__45_to_59_minute","symbol":{"color":[132,0,168,64],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Female Commute: 45 to 59 minutes"}],"backgroundFillSymbol":{"color":[0,0,0,0],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},"transparency":0}

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)
• Join_Count (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TARGET_FID (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• STATE_NAME (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeNVarchar, length: 25, nullable: true, editable: true)
• STATE_FIPS (type: esriFieldTypeString, alias: FIPS, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
• SUB_REGION (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeNVarchar, length: 20, nullable: true, editable: true)
• STATE_ABBR (type: esriFieldTypeString, alias: Abbreviation, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
• POPULATION (type: esriFieldTypeInteger, alias: Population (2017), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• POP_SQMI (type: esriFieldTypeDouble, alias: Pop. per Sq. Mi., 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)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Total_Male_Commuters (type: esriFieldTypeInteger, alias: Total Male Commuters, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Male_Commute__5_to_9_minutes (type: esriFieldTypeInteger, alias: Male Commute: 5 to 9 minutes, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Male_Commute__20_to_24_minutes (type: esriFieldTypeInteger, alias: Male Commute: 20 to 24 minutes, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Male_Commute__45_to_59_minutes (type: esriFieldTypeInteger, alias: Male Commute: 45 to 59 minutes, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Female_Commuters (type: esriFieldTypeInteger, alias: Total Female Commuters, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Female_Commute__5_to_9_minutes (type: esriFieldTypeInteger, alias: Female Commute: 5 to 9 minutes, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Female_Commute__20_to_24_minute (type: esriFieldTypeInteger, alias: Female_Commute__20_to_24_minute, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Female_Commute__45_to_59_minute (type: esriFieldTypeInteger, alias: Female_Commute__45_to_59_minute, SQL Type: sqlTypeInteger, 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: 8/14/2021 3:21:34 AM

Schema Last Edit Date: 8/14/2021 3:21:34 AM

Data Last Edit Date: 8/14/2021 3:21:34 AM

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