Summary
The VoterTurnout tool appends tabular election data for voter turnout to a set of features and a related table for use in the Election Results solution. This tool also computes ballots not cast so charts can be shown in the Election Results application.
Before running the tool, verify that the election districts (precincts, counties, and so on) have been published as feature layers (ArcGIS Online or Portal for ArcGIS) or exist in a feature service (ArcGIS for Server or ArcGIS Enterprise), and that they are participating in a geodatabase relationship with a table for the voter turnout information using district identifiers for keys.
Parameters
| Parameter | Explanation | Data Type |
| Input Spreadsheet (in_features) | Spreadsheet (TXT tab-delimited, CSV, xls, xlsx) containing the election results that will be used to update the services. | Table |
| District ID Field - Spreadsheet (ss_precinct_fld) | Input spreadsheet field containing the identifiers for the election result geography. These could be county names, precinct IDs, district IDs, and so on. For example: PRECINCTID, COUNTY. | Field |
| Number of Registered Voters - Spreadsheet (ss_voters_fld) | Spreadsheet field containing the number of registered voters in each district. | Field |
| Number of Ballots - Spreadsheet (ss_ballots_fld) | Optional spreadsheet field containing the name of the winning candidate's party in each district. | Field |
| Voter Turnout - Spreadsheet (ss_turnout_fld) (Optional) | Optional spreadsheet field containing the voter turnout in each district. If no voter turnout field is provided, voter turnout will be calculated by dividing the number of registered voters by the number of ballots cast. The tool assumes these to be values between 0 and 1. To use values between 0 and 100, open this toolbox in a text editor and search for max_value = 1 (near the top). Update this to max_value = 100 and save. | Field |
| These results are updating a service published using: (pub_env) | This tool can update services that have been published using ArcGIS Online, ArcGIS for Server, and Portal for ArcGIS. Choose the method used to publish the service that will be updated with these results. For ArcGIS Online services, this value should be the URL to your organization. For example, http://myorganization.maps.arcgis.com. For Portal for ArcGIS services, this value should be the URL of the servers REST endpoint. For example http://webadaptor.domain.com:6080/arcgis or https://webadaptor.domain.com:6443/arcgis. | String |
| Organization URL (org_url) (Optional) | This parameter is required if the service was published using either ArcGIS Online or Portal for ArcGIS. | String |
| Username (username) (Optional) | Organizational account for ArcGIS Online or Portal for ArcGIS with administrative access to the service. This could be the service owner or an administrative account. This parameter is required for ArcGIS Online and Portal for ArcGIS services. | String |
| Password (password) (Optional) | Password corresponding to the provided username. This parameter is required for ArcGIS Online and Portal for ArcGIS services. | String |
| Feature Layer URL (service_url) (Optional) | REST endpoint of a feature layer (including layer index value) containing the geometry of the election districts. This feature layer must use district identifiers (precincts ID, county name, and so on) as the primary key in a one-to-many relationship with a table layer of candidate results. If fields are provided, this layer may also include the total winning party and the number of ballots cast in each district. This parameter is required for ArcGIS Online and Portal for ArcGIS services. | String |
| Table Layer URL (table_url) (Optional) | REST endpoint of a table layer (including layer index value) containing the results for each candidate in each district. This table layer must use district identifiers as the foreign key in a one-to-many relationship with a feature layer containing the geometry of the districts. This layer should contain fields for the district identifier, the candidate names, and the number of ballots cast for each candidate. Fields may also be provided for the vote percentage received by each candidate and each candidate party affiliation. This parameter is required for ArcGIS Online and Portal for ArcGIS services. | String |
| Feature Class (feature_class) Optional) | Path to a feature class containing the geometry of the election districts. This feature class must use district identifiers as the primary key in a one-to-many relationship with a table of candidate results. If fields are provided, this feature class may also include the total winning party and the number of ballots cast in each district. This parameter is required for ArcGIS for Server or ArcGIS Enterprise services. | Feature Class |
| Related Table (related_table) (Optional) | Path to a table containing the results for each candidate in each district. This table must use district identifiers as the foreign key in a one-to-many relationship with a feature class containing the geometry of the districts. This table should contain fields for the district identifier, the candidate names, and the number of ballots cast for each candidate. Fields may also be provided for the vote percentage received by each candidate and each candidate party affiliation. This parameter is required for ArcGIS for Server or ArcGIS Enterprise services. | Table |
| District ID Field - Feature Layer/Class (ft_precinct_fld) (Optional) | String field in the feature layer (ArcGIS Online or Portal for ArcGIS) or feature class (ArcGIS for Server or ArcGIS Enterprise) containing the district identifiers. This field should also be the primary key in a one-to-many geodatabase relationship with the candidate table. This field must be populated for each feature before running the tool. | String |
| Number of Registered Voters - Feature Layer (ft_voters_fld) (Optional) | Numeric field in the feature layer (ArcGIS Online or Portal for ArcGIS) or feature class (ArcGIS for Server or ArcGIS Enterprise) for the number of registered voters in each district. | String |
| Number of Ballots Cast - Feature Layer (ft_ballots_fld) (Optional) | Numeric field in the feature layer (ArcGIS Online or Portal for ArcGIS) or feature class (ArcGIS for Server or ArcGIS Enterprise) for the number of ballots cast in each district. | String |
| Voter Turnout - Feature Layer (ft_turnout_fld) (Optional) | Numeric field in the feature layer (ArcGIS Online or Portal for ArcGIS) or feature class (ArcGIS for Server or ArcGIS Enterprise) for the number of ballots cast in each district. | String |
| District ID Field - Table (tb_precinct_fld) (Optional) | String field in the feature layer (ArcGIS Online or Portal for ArcGIS) or feature class (ArcGIS for Server or ArcGIS Enterprise) containing the district identifiers. This field should also be the primary key in a one-to-many geodatabase relationship with the candidate table. This field must be populated for each feature before running the tool. | String |
| Report Type - Table Layer (tb_count_fld) (Optional) | The Election Results application charts voter turnout as the number of voters who cast ballots vs the number who did not. The tool will calculate both values using either the provided voter turnout information or the number of registered voters and the number of ballots cast. This string field records which of these two values is in the corresponding Ballot Counts field for use when configuring the chart. | String |
| Ballot Counts - Table Layer (tb_count_fld) (Optional) | The Election Results application charts voter turnout as the number of voters who cast ballots vs the number who did not. The tool will calculate both values using either the provided voter turnout information or the number of registered voters and the number of ballots cast. This numeric field records the number of ballots that were and were not cast. | String |
| Ballot % - Table Layer (tb_perc_fld) (Optional) | The Election Results application charts voter turnout as the number of voters who cast ballots vs the number who did not. The tool will calculate both values using either the provided voter turnout information or the number of registered voters and the number of ballots cast. This numeric field records the percentage of ballots that were and were not cast. | String |