In this topic, you will learn how to configure the Police Transparency solution to meet specific needs in your organization.
Load your data
Police Transparency can be used by law enforcement agencies to share crime, use of force, police personnel, and community policing boundary information. In some cases, you may already have this information in ArcGIS Enterprise or another business system.
Review the layers provided with the solution and determine what source data you want to load. Then, load your existing data into the layers provided with the ArcGIS Solution before sharing the maps or apps.
Once you have determined what source data must be loaded, complete one, or more, of the data-loading workflows below.
Load police personnel roster
Police Transparency can be used by law enforcement agencies to share data about the diversity of their agency personnel. The Police Transparency solution includes the Law Enforcement Diversity Dashboard that can be used to display this information by race, ethnicity, and gender in relation to community proportions.
To load your agency personnel roster into the Law Enforcement Diversity Dashboard from a spreadsheet, complete the following steps:
- Sign in to your ArcGIS organization and browse to the Police Personnel Microsoft Excel item.
- On the item details page, click Download.
- Once downloaded, open the Police_Personnel.csv file and enter your personnel roster information.
Tip:
Many fields have existing domain values that are used for filters and charts in the Law Enforcement Diversity Dashboard. If the values in your data are not identical to the values in each domain, you can either change the values in your data to match the values already in each field’s domain list to update the domain list of each field in the Police_Personnel table to reflect the values in your data. Then follow the steps in the Modify apps section to update the Law Enforcement Diversity Dashboard to reflect your values.
- Ensure the name of the spreadsheet is Police_Personnel and do not change any field names.
- Click Save to save your changes.
- In your ArcGIS organization, browse to the Police_Personnel hosted feature table.
- On the item details page, click Update Data, then click Append Data to Layer.
- Under Filename, choose your .csv file.
- Click Upload and Continue.
- Uncheck Update existing features.
- Click Show field matching.
- Confirm that all fields listed in the Fields column have a corresponding field listed in the Match Field column.
- If no field is listed in the Match Field column, click the drop-down box for that field, and select the field name from the spreadsheet that reflects the value shown in the Fields column.
- Click Apply Updates.
Load community policing areas
To load your data into the CommunityPolicingAreas layer, complete the following steps:
- In your ArcGIS organization, browse to the feature layer you want to populate.
- Create a .zip file of a shapefile of your Community Policing Areas.
- On the item details page, click Update Data , then click Append Data to Layer.
- Under Filename, choose your .zip file.
- Click Upload and Continue.
- From Choose the layer to update, select the CommunityPolicingAreas layer.
- Uncheck Update existing features.
- Click Show field matching to map the fields.
- Click Apply Updates.
Load use of force data
Police Transparency can be used by law enforcement agencies to share use of force information. The solution includes several charts and dashboards that can be used to display characteristics of use of force incidents by race and ethnicity, neighborhood, subject of the force, and the officer involved.
To load your agency use of force data from a spreadsheet into the UseOfForce feature layer, complete the following steps:
- Sign in to your ArcGIS organization and browse to the UseOfForce Microsoft Excel item.
- On the item details page, click Download.
- Once downloaded, open the UseOfForce Excel workbook.
Note:
The workbook contains three spreadsheet tabs—one for Incidents, one for Subjects, and one for Officers. Enter your personnel roster information.
- Ensure the name of the spreadsheet is UseOfForce and do not change any field names.
Note:
Review the fields in the UseOfForce feature layer. This layer is comprised of an Incidents layer, an Officers related table, and a Subjects related table—you will need to be familiar with the fields and domain values of all three.
Tip:
Many fields have existing domain values that are used in filters and charts on the ArcGIS Enterprise Sites page and in the use of force dashboard. If the values in your data are not identical to the values in each domain, you can either change the values in your data to match the values already in each field’s domain list, or follow the steps in the Modify data section to update the domain list of each field in the UseOfForce feature layer to reflect the values in your data. Then follow the steps in the Modify apps section to update the ArcGIS Enterprise Sites charts, Use of Force by Race and Ethnicity, Use of Force by Neighborhood, Use of Force by Officer, and Use of Force by Subject dashboards to reflect your values.
- Click Save to save your changes.
- In your ArcGIS organization, browse to the UseOfForce feature layer.
- On the item details page, click Update Data, then click Append Data to Layer.
Note:
Ensure that the data in your Excel workbook already has valid latitude and longitude coordinates. If your data has only addresses and no coordinates, you can geocode it using a local address locator and ArcGIS Pro, or the Publish an Excel file workflow in your ArcGIS organizational portal. Export the resulting layer as a CSV file or Excel spreadsheet and add the Latitude and Longitude values to the UseOfForce worksheet in the Incidents layer.
- Under Filename, choose your Excel workbook file.
- Click Upload and Continue.
- Select Incidents from the drop-down list and choose the layer into which you want to append data.
- Select Incidents from the drop-down list and choose the layer from UseOfForce.xlsx that contains the updated data.
- Uncheck Update existing features.
- Click Show field matching.
- Confirm that all fields listed in the Fields column have a corresponding field listed in the Match Field column.
If no field is listed in the Match Field column, click the drop-down box for that field, and select the field name from the spreadsheet that reflects the value shown in the Fields column.
- Click Apply Updates.
- Repeat steps 7 through 15 twice, appending the data from the Officers and Subjects tabs of your spreadsheet into the Officers and Subjects feature tables.
Note:
If you want to automate the process of appending new Use of Force data from a local Excel workbook into the UseOfForce feature layer, see the Automate data updates section.
Load crime data
Police Transparency can be used by law enforcement agencies to share crime data. The solution includes web mapping apps and dashboards that can be used to display current and historical crime conditions in a community.
To load your agency crime data from a spreadsheet into the Crime feature layer, complete the steps below.
Tip:
Ensure that the data in your Excel workbook already has valid latitude and longitude coordinates. If your data has only addresses and no coordinates, you can geocode it using a local address locator and ArcGIS Pro, or the Publish an Excel file workflow in your ArcGIS organizational portal. Export the resulting layer as a CSV file or Excel spreadsheet and add the Latitude and Longitude values to the Crimes worksheet along with the rest of your features.
- Sign in to your ArcGIS organization and browse to the Crimes feature layer.
- On the item details page, click Update Data, then click Append Data to Layer.
- Under Filename, choose your Excel workbook file.
- Click Upload and click Continue.
Tip:
You will need to be familiar with the fields and domain values. Many fields have existing domain values that are used for filters and charts in the Crime Summary Dashboard, Crime Trends Dashboard, and Public Crime Map. If the values in your data are not identical to the values in each domain, you can either change the values in your data to match the values already in each field’s domain list, or follow the steps in the Modify data section to update the domain list of each field in the Crime feature layer to reflect the values in your data. When complete, you will update the Crime Summary Dashboard, Crime Trends Dashboard, and Public Crime Map to reflect your data values.
- Uncheck Update existing features.
- Click Show field matching.
The Field column contains all of the fields in the Crimes feature layer. The Match Field column displays the names of all fields in your source Excel workbook.
If no field is listed in the Match Field column, click the drop-down box for that field, and select the field name from your spreadsheet that reflects the value shown in the Fields column.
- Click Apply Updates.
Note:
If you want to automate the process of appending new Use of Force data from a local Excel workbook into the Crimes feature layer, see the Automate record import section.
Load data for use of force context chart
- Sign in to your ArcGIS organization and browse to the ContextOfUseOfForce CSV item.
- On the item details page, click Download.
- Click Edit on the CSV file and enter a single year’s worth of summary totals for the following datasets: Calls For Service, Arrests, Total Use of Force, Serious Injury Force, and Deadly Force. Click Save to save the CSV file when complete.
- In your ArcGIS organization, browse to the ContextOfUseOfForce feature table.
- On the item details page, Click Update Data, then click Append Data to layer.
- Under Filename, choose your CSV file.
- Click Upload and Continue.
- Uncheck Update existing features.
- Click Show field matching. Confirm that all fields listed in the Fields column have a corresponding field listed in the Match Field column. If no field is listed in the Match Field column, click the drop-down box for that field, and select the field name from the CSV file that reflects the value shown in the Fields column.
- Click Apply Updates.
Tip:
To modify the data in this table after the initial load, browse to the data section of the ContextOfUseOfForce item, and double-click a value in the table to change it.
Remove outdated personnel records (optional)
At some point, you may want to delete all data in a feature layer to load new information. For example, your organization may update the personnel roster information used in the Law Enforcement Diversity Dashboard semi-annually. To avoid duplicate or incorrect records, the existing records must first be deleted before a current roster can be appended into the solution’s Police Personnel table.
Delete features
To delete features from a hosted feature layer or table, complete the following steps:
- Sign in to your ArcGIS organization.
- Go to the Overview tab of the Police_Personnel hosted feature table.
- In the lower right corner, in the URL category, click View.
The ArcGIS REST Services Directory for this page appears.
- Click the link of the layer or table from which you want to delete records.
- In the URL bar of the browser, edit the URL with the following changes.
- Add the word admin between rest/ and services. (For example: ArcGIS/rest/admin/services/Police_Personnel)
- Add the word truncate between 0/ and ?token. (For example: FeatureServer/0/truncate?token=)
- In the next window, click Truncate.
Update a layer with a join view
The Police Transparency solution includes a series of feature layer join views that are used to display information in the Use Of Force page and in a series of use of force dashboards. Join views are created using the Join Features analysis tool by joining two sources together based on a matching field. The benefit of the join view is that it remains up to date as the source data changes. However, when new fields are added to the source layers or when field domain values are changed, the join views must be recreated with the same name and URL for the charts and dashboards to continue working properly.
To add a field to a layer and update the join views, complete the following steps:
- Browse to the join view in your contents.
- On the item's Overview page, scroll to the URL section. Click the Copy button.
- Paste the copied URL into Microsoft Notepad or another text editor for reference.
Note:
The feature layer’s service name will be used below when re-creating the join. The name can be found after services in the URL structure and may also contain a unique GUID, for example, UseOfForce_Incidents_Subjects_joina45f71a48587425c9b90ee5527cd26d1.
- Delete the existing join view.
- Add the source hosted feature layer to a new web map (for example, UseOfForce).
- Click Analysis, Summarize Data, Join Features.
- Configure the join using the table below.
Name of join Target layer Layer to join to the target layer Fields to match Join operation UseOfForce_Incidents_Subjects_join
Incidents (UseOfForce)
Subjects (UseOfForce)
agency_case_number=agency_case_number
Join one to many
UseOfForce_Incidents_Officers_join
Incidents (UseOfForce)
Officers (UseOfForce)
agency_case_number=agency_case_number
Join one to many
Tip:
Ensure each new join view uses the names defined in the table above. If you use the same names, the layers in the map and the existing dashboard widgets will not have to be reconfigured. If your join view contained a unique GUID, the new join view must be named with the unique GUID.
- If necessary, uncheck Use current map extent. Check Create results as hosted feature layer view.
- Update the web map and app configurations of Use of Force by Race and Ethnicity, Use of Force by Neighborhood, Use of Force by Subject, and Use of Force by Officer Dashboard to account for the new fields or domain values you added.
Automate record import
Some organizations may want to automate the importing of data from their record systems into the layers in the Police Transparency solution. In particular, users may want to perform daily or weekly updates of their Crimes or Use of Force data to ensure that residents have timely access to information.
The layers in the Police Transparency solution can be updated using the Record Import Tools toolbox. These tools can be executed from ArcGIS Pro manually or automated on a schedule using Windows Task Scheduler. The Toolbox supports the use of database tables from your Computer Aided Dispatch (CAD) or Records Management System (RMS) as well as Microsoft Excel spreadsheets (.xls) or comma-separated values (.csv) files.
Modify ArcGIS Enterprise Sites pages
The Police Transparency solution includes an ArcGIS Enterprise Sites site and pages that your organization can configure with your own branding and share your organization’s story with the public.
Update with organizational information
After deploying the Police Transparency solution, the site and pages require a few updates to fit your local context. Consider what information you already have and what you can most easily find.
To update the Police Transparency site, complete the following steps:
- From the Customize window of the Site Home, select Header and Branding.
- Update the header to include your organizational icon.
- Change the name and short name of the site ( Police Transparency) to a name that better reflects your specific organization.
- Browse to the Social Icons group and enter in the URLs for your agency's Facebook, Twitter, and Instagram accounts, or disable if you don’t want them displayed.
- Click Apply, then click Save to save the page, and click Publish Draft.
- From the Customize window of the Site Home, select Footer.
- Click the expand button in the right corner of the HTML section.
- Replace the default icon URL, department name, email address, and street address with the correct values for your organization.
- Enter the URLs for your agency's Facebook, Twitter, LinkedIn, Instagram, and YouTube accounts.
- Delete any icons from the HTML that are not required, then click Apply.
- Click Save to save the page.
- Click Publish Draft.
- Update the main header image on each page to an image from your organization.
For best results, this image should be 96 dpi and 1920 x 400.
- Update the other stock images in the site with images from your organization.
For best results, these images should be 600 x 400 and 96 dpi.
- On the main page, click Configure on the Facebook and Twitter Social Media Cards to update the Timeline Link URL to your organization’s Facebook and Twitter pages.
- Review all text on each page for consistency with your organizational messaging.
Tip:
Consider working with your Public Information Officer to refine this content to reflect your organizational needs.
- Browse to the Frequently Asked Questions section of the main page and click Configure to update the questions and answers.
- Browse to the Recruitment, Employment, and Diversity Resources section of the Personnel Diversity page and click Configure to update the images, text, and buttons to reflect your organizational initiatives.
Remove ArcGIS Hub Premium content
The Police Transparency solution comes with features that require ArcGIS Hub Premium; if you are using ArcGIS Enterprise Sites, you will want to remove the features that require ArcGIS Hub Premium. Organizations using this solution with ArcGIS Enterprise Sites should perform the following steps to remove the ArcGIS Hub Premium content from their site.
To remove ArcGIS Hub premium content, complete the following steps:
- Browse to your app launcher and click Hub and click Police Transparency to begin editing the site.
- Scroll to the section titled Get Involved on the main site page.
- Click the delete button for the row card containing the section title, not just the section title.
- Click Save, then click Publish Draft.
- Repeat steps 1 through 3 for the Community Engagement, Workforce Diversity, Crime Stats, and Use of Forces pages in the site.
- Go to the Community Engagement page and scroll to the Scheduled Events section.
- Click the delete button for the row card containing the event calendar, not just the event calendar itself.
- Click Save, then click Publish Draft.
Modify custom use of force charts
Several charts on the Use of Force page of the Police Transparency solution make use of custom queries from solution layers that use preexisting values from domain lists. For your data to display properly in these charts, the values in your data must exactly match the values in the field domain list of the field in the feature layer. If your data contains different values, you must modify the custom JSON of the Hub charts to reflect your field values.
To modify the JSON of the custom use of force charts, complete the following steps:
- Sign in to your ArcGIS organization.
- Click your app launcher and select Sites.
- Click the Police Transparency site.
- On the Customize accordion, click the number of associated pages button.
- Click the Use of Force page.
- Find the chart labeled Serious Injury Use of Force Incidents and click the configure button (shaped like a gear).
- In the JSON Chart Definition section, find the section of the JSON that looks like the following:
"where": "forcelevel='Level 3- Serious Injury'"
- Replace the value Level 3- Serious Injury with the value in your data that represents incidents involving serious injury.
- Click Apply.
- Click Save and click the drop-down list and select Publish Draft.
- Repeat steps 6 through 10 with the Fatal Use Of Force Incidents chart, replacing the value Deadly Force-Fatality with the value in your data that represents fatal use of force incidents.
Modify apps
The Police Transparency solution includes many apps that are used by law enforcement agencies to help residents and stakeholders explore crime conditions, use of force patterns, and departmental diversity. Apps in the Police Transparency solution can be modified to meet the needs of individual organizations. This section covers several app modification workflows organizations commonly require.
Modify dashboards
The Use of Force by Race and Ethnicity and Law Enforcement Diversity Dashboard require an organization to manually enter your jurisdiction’s population percentage values for each race/ethnicity group represented on the dashboards. This information helps to contextualize proportions of force and personnel data relative to the composition of the community.
To update the dashboards with population percentages by race and ethnicity for your jurisdiction, complete the following steps:
- Obtain information about population percentages by race and ethnicity for your jurisdiction.
Tip:
This data is most typically obtained from the U.S. Census Bureau’s Quick Facts web page, where you can type the name of your jurisdiction to get population percentages by race and ethnicity. Consult your planning department for more information.
- Sign in to your ArcGIS organization.
- Browse to and click to open the item page of the dashboard you want to edit.
- Click Edit Dashboard.
- Find the first indicator element where the language Community Makeup: XX% appears and click the configure (gear) button.
- Click the General options category, then click Edit in the Description section.
- Switch the default value with the appropriate value for your jurisdiction.
- Repeat for all indicator elements with the Community Makeup: XX% text.
- Click Save.
Update dashboard charts to reflect new field values
Dashboards in the Police Transparency solution have been preconfigured to use layer fields that are powered by default domain values. If your data does not match the preexisting values, your data may not display or may display as a gray other value in dashboard charts.
To update dashboards to reflect new field values, complete the following workflow:
- Sign in to your ArcGIS organization.
- Browse to and click to open the item page of the dashboard you want to edit.
- Click Edit Dashboard.
- Review your dashboard and identify all chart elements that require updating.
- For each chart element that needs an update, click the configure button.
- If the chart is a pie chart, click the Slices options category, delete the existing values, then click Load Categories. Style the categories with colors appropriate for the dashboard.
- If the chart is a serial chart, click the Series options category, delete the existing values, then click Load Categories. Style the categories with colors appropriate for the dashboard.
- Click Save.
Update dashboard filters to reflect new field values
The Use of Force by Race and Ethnicity and Law Enforcement Diversity Dashboard both use field values (that are preset by a domain) to filter by specific demographic groups. If the values in your data differ from the domains present in the default fields of the Police_Personnel, UseOfForce-Subjects, and UseOfForce-Officers tables, these dashboards may not properly display. For example, if your data contains coded values for race/ethnicity (A, B, W, I, H, and so on) instead of complete values such as the domain for these fields, you will need to modify the element filters of these dashboards to reflect your values.
To update dashboard elements in Law Enforcement Diversity Dashboard or Use of Force by Race and Ethnicity to use your field values, complete the following steps:
- Sign in to your ArcGIS organization.
- Browse to and click to open the item page of the dashboard you want to edit.
- Click Edit Dashboard.
- Review your dashboard and identify all chart elements that require updating.
- For each indicator element that needs an update, click the configure button.
- In the Value drop-down list of the Filter section, replace the default value with the appropriate value from your data that represents the information conveyed by the element.
- Click Done.
- Repeat for all other indicator elements in the dashboard that require updating.
- Click the Save button.
Change the crime summary dashboard from NIBRS to UCR
Some organizations may want to provide public crime data according to the Federal Bureau of Investigation’s old Uniform Crime Reporting Summary Reporting System (SRS) standards rather than the new National Incident-Based Reporting System (NIBRS). The Crime Summary Dashboard is configured using the NIBRS standard, but can be updated to reflect the older UCR SRS standard if required by an organization.
To update the Crime Summary Dashboard from NIBRS reporting standards to UCR SRS standards, complete the following workflow.
Note:
Before you begin this workflow, ensure that you have valid values populated in the UCR Offense Description and UCR Offense Category fields of the Crimes layer.
- Sign in to your ArcGIS organization.
- Browse to your content and click the Crime Summary Dashboard.
- Click Edit Dashboard.
- Click the configure button in the upper left corner of the Rich Text element containing the text Crimes Against Persons.
- In the text box, change the text to Violent Crime, then click Done.
- In the indicator element immediately below, click the configure button.
- In the Value section and Filter subsection, change the drop-down selection from NIBRS Crime Against Category to UCR Category, then change the value from Crimes Against Persons to Violent Crime (or the equivalent value in your data).
- Scroll down to the Reference section and Filter subsection, change the drop-down selection from NIBRS Crime Against Category to UCR Category, then change the value from Crimes Against Persons to Violent Crime (or the equivalent value in your data).
- Click Done.
- Click the configure button on the Crimes Against Persons By Year chart element to the right of the last two elements you modified.
- In the Filter section, change the drop-down selection from NIBRS Crime Against Category to UCR Category, then change the value from Crimes Against Persons to Violent Crime (or the equivalent value in your data).
- Click Done.
- Click the configure button on the Crimes Against Persons By Month chart element to the right of the last element you modified.
- In the Filter section, change the drop-down selection from NIBRS Crime Against Category to UCR Category, then change the value from Crimes Against Persons to Violent Crime (or the equivalent value in your data).
- Click Done.
- Repeat steps 4 through 15 for the remaining two rows of elements, replacing Crimes Against Property with Property Crime (or the equivalent value in your data), then replacing Crimes Against Society with Part II crimes (or the equivalent value in your data).
- Click the Save button.
Change the crime trends dashboard from NIBRS to UCR
Some organizations may want to provide public crime data according to the Federal Bureau of Investigation’s old Uniform Crime Reporting Summary Reporting System (SRS) standards rather than the new National Incident-Based Reporting System (NIBRS). The Crime Trends Dashboard is configured using the NIBRS standard, but can be updated to reflect the older UCR SRS standard if required by an organization.
To update the Crime Trends Dashboard from NIBRS reporting standards to UCR SRS standards, complete the following workflow.
Note:
Before you begin this workflow, ensure that you have valid values populated in the UCR Offense Description and UCR Offense Category fields of the Crimes layer.
- Sign in to your ArcGIS organization.
- Browse to your content and click the Crime Summary Dashboard.
- Click Edit Dashboard.
- Click the configure button along the right side of the Crime Type filter.
- In the Category Field, change the drop-down selection from NIBRS Description to UCR Description.
- Click the Actions options tab.
- In the Target Field drop-down list for the Crime Hotspots layer, select UCR Description.
- Click Done.
- Click the Save button.
Change the public crime map from NIBRS to UCR SRS
Some organizations may want to provide public crime data according to the Federal Bureau of Investigation’s old Uniform Crime Reporting Summary Reporting System (SRS) standards rather than the new National Incident-Based Reporting System (NIBRS). The Public Crime Map app is configured using the NIBRS standard, but can be updated to reflect the older UCR SRS standard if required by an organization.
To update the Public Crime Map app from NIBRS reporting standards to UCR SRS standards, complete the following workflow.
Note:
Before you begin this workflow, ensure that you have valid values populated in the UCR Offense Description and UCR Offense Category fields of the Crimes layer.
- Sign in to your ArcGIS organization.
- Browse to your content and click the Public Crime Map Web Mapping app.
- Click Edit Application.
- Click the Widget button at the top of the configuration section of Web AppBuilder.
- Click the Header Control- Set the widgets in this controller button.
- Click the Configure this widget edit button on the Summary widget.
- Click the edit button under Display Options for the Crimes layer.
- Click the Panel tab.
- In the Layer Options section, change the drop-down selection from NIBRS Description to UCR Description.
- In the Group Options section, change the drop-down selection from NIBRS Offense Category to UCR Category.
- Click OK twice to save the reconfigured Summary widget.
- Click the Configure this widget edit button on the Filter widget.
- Click the NIBRS Offense Category filter.
- On the Info tab, change the label of the filter from NIBRS Offense Category to UCR Category.
- On the Expressions tab, change the drop-down selection from NIBRS Offense Category to UCR Category.
- Change operator to is any of.
- Check the Ask for values check box.
- Click the NIBRS Offense Description filter.
- On the Info tab, change the label of the filter from NIBRS Offense Description to UCR Description.
- On the Expressions tab, change the drop-down selection from NIBRS Offense Description to UCR Description.
- Change operator to is any of.
- Check the Ask for values check box.
- Click OK to save the reconfigured Filter widget.
- Click the Configure this widget edit button on the Report widget.
- Click the edit button under Actions for the Crimes layer.
- Change the drop-down selection from NIBRS Description to UCR Description.
- Click OK twice to save the reconfigured Report widget.
- Click Save at the bottom of the configuration window of Web AppBuilder.
Modify Police Transparency surveys
To modify any survey in the Police Transparency solution, including the Police Interaction Survey or the Community Safety and Policing Satisfaction Survey, complete the following steps:
- Install ArcGIS Survey123 Connect.
- Start ArcGIS Survey123 Connect and sign in to your ArcGIS organization.
- Click to download the survey you want to edit.
- Click again to open the survey.
- In the left pane, click Open XLSForm Spreadsheet.
- In the Microsoft Excel spreadsheet, click the choices tab. This tab comprises all the selectable options for survey questions.
- Revise the survey to reflect your organizational needs.
- Save the Microsoft Excel spreadsheet and preview your changes in ArcGIS Survey123 Connect.
- In ArcGIS Survey123 Connect, click Publish in the left pane to publish your changes.