Configure Election Results

In this topic, you’ll learn how to configure the Election Results solution to meet specific needs in your organization.

Understanding the Election Results feature layers

The Election Results solution includes the ElectionResults feature layer used to store your tabulated election results data. The ElectionResults feature layer has two sublayers, Voting Jurisdictions and the Election Results table. Voting Jurisdictions stores the geographic jurisdiction you’re using to visualize election results on a map (ex, County, Municipality, or Precinct). The Election Results table stores the results of ballot measures where each record represents the results of a ballot measure by contest, candidate, and jurisdiction. Each record in the Election Results table is also categorized as an Elected Office or Proposal using the Contest Category field.

In the below example, two candidates ran for Mayor in a community with three precincts.

ContestContest CategoryJurisdiction NameCandidatePartyNumber of VotesPercent Vote

Mayor

Elected Office

Precinct 1

John Doe

Democratic

306

51

Mayor

Elected Office

Precinct 2

John Doe

Democratic

147

39

Mayor

Elected Office

Precinct 3

John Doe

Democratic

350

51

Mayor

Elected Office

Precinct 1

Jane Smith

Republican

245

49

Mayor

Elected Office

Precinct 2

Jane Smith

Republican

153

51

Mayor

Elected Office

Precinct 3

Jane Smith

Republican

294

49

The Election Results table can also be used to store the results of ballot measure proposals. Yes and No are populated in the Candidate field. In the below example, Proposal 1 was voted on in a community with three precincts.

ContestContest CategoryJurisdiction NameCandidatePartyNumber of VotesPercent Vote

Proposal 1

Proposal

Precinct 1

Yes

306

51

Proposal 1

Proposal

Precinct 2

Yes

147

39

Proposal 1

Proposal

Precinct 3

Yes

350

51

Proposal 1

Proposal

Precinct 1

No

245

49

Proposal 1

Proposal

Precinct 2

No

153

51

Proposal 1

Proposal

Precinct 3

No

294

49

Load election results

You may need to load election results data from a spreadsheet sourced from your tabulation system. The Election Results solution includes a .csv file that can be used to load data into the ElectionResults feature layer. Populate the ElectionResults.csv fields with your election results data, then complete the steps below to load your election results data:

  1. Sign in to your ArcGIS organization and browse to the ElectionResults.csv item.
  2. On the item page, click Download.
  3. Edit the csv and provide your election results data.
  4. In your ArcGIS organization, browse to the ElectionResults feature layer.
  5. On the item page, click Update Data > Append Data to layer.
  6. Under Filename choose your .csv file.
  7. Click Upload and Continue.
  8. From Choose the layer that you wish to append data into, select Election Results.
  9. Uncheck Update existing features.
  10. Click Show field matching to map the fields.
  11. Click Apply Updates.

Extend election results

The Election Results solution also includes two feature layer views created from the ElectionResults feature layer: ElectionResults_join and ElectionResults_dashboard. These feature layer views are used in the Election Results dashboard. Your organization may want to modify the ElectionResults feature layer fields to include additional information. When doing so, the new fields must be exposed in the appropriate views. Additionally, some views are created by joining two sources together and these views must be recreated with the same name and url after a new field is added.

Update feature layer view

  1. Sign into your ArcGIS organization and search for the ElectionResults feature layer.
  2. Add a new field to a layer in the ElectionResults feature layer.
  3. Navigate to the ElectionResults_dashboard view in your contents.
  4. Click the Open in Map View down arrow, then Add to new map.
  5. Click the More Options ellipses on the appropriate layer or table, then click Set View Definition. Click Define Fields.
  6. Scroll to the newly created field, check the box.
  7. Click Apply.

    The new field is added to the view’s definition.

Share historical results

The Election Results solution can be deployed multiple times to share results for multiple election cycles. Each Election Results dashboard can be configured to share the results of an election. The Election Results dashboards can then be shared with the Minimal Gallery app and embedded in your website.

Create your Historical Election Results group

  1. If necessary, sign into your ArcGIS Organization.
  2. Create the following group in your ArcGIS Online organization.

    Group NameHistorical Election Results

    Summary

    A collection of historical election results apps hosted by our organization

    Description

    A collection of historical election results apps hosted by our organization. The public can use this gallery of apps to access specific information on past elections

    Tags

    Historical Election Results, Primary Election Results, General Election Results

    Who can view this group

    Everyone (public)

    Who can join this group

    Only those invited by a group manager

    Who can contribute content to the group

    Group members

    Sort group content by

    Title and Ascending

Create your Historical Election Results Gallery app

The Historical Election Results Gallery is a configuration of the Minimal Gallery configurable application template. The app consumes the Election Results solution dashboards that you have authored and shared in the Historical Election Results group. This app can be hosted in ArcGIS Online, or downloaded and hosted on your local web server.

  1. If necessary, sign into your ArcGIS Organization.
  2. Create an app from a group using the Historical Election Results group and Minimal Gallery configurable application template, then share it with your Public Maps and Apps group. For more information on configuring Minimal Gallery, see Minimal Gallery item page.
  3. Browse to the Historical Election Results Gallery app and edit the item details.
  4. Share the Historical Election Results Gallery app with everyone.
  5. Embed the Historical Election Results Gallery app in your election website.