Skip to Main Content View Text-Only

The City of Portland, Oregon

Police Bureau

Sworn to protect. Dedicated to serve.

Phone: 503-823-0000

Fax: 503-823-0342

Non-Emergency: 503-823-3333

1111 S.W. 2nd Avenue, Portland, OR 97204

Dashboard Walkthrough

Dispatched Calls Statistics Report Walkthrough

1. Report Overview

The Dispatched Call Statistics Report is an interactive data visualization of the 9-1-1 and non-emergency calls responded to by the Portland Police Bureau. This tool is built to provide custom analyses of call data to interested members of the community, especially as it relates to the Portland neighborhoods.  For a more detailed map of the neighborhood boundaries used by the Police Bureau, click here.

The data used in this report is collected by the Bureau of Emergency Communications (BOEC) and sourced from the PPB's record management system, RegJIN. The data is a record of community-generated 9-1-1 and non-emergency public safety calls requiring a police response. Calls are included in the dashboard when at least one PPB officer is dispatched by BOEC to respond to the scene.


2. Technical Specifications

The report has been customized to work on personal computers, smart phones and tablets.  For the best experience, it is recommended you use a desktop or laptop computer.

No additional software is required to use this report. The report runs completely within the internet browser using JavaScript. Most modern browsers automatically activate JavaScript; however, it can be turned off based on the security settings of the computer.  For more information on activating JavaScript, refer to the browser’s help section or click here for help on Windows computers and click here for help on Apple computers.


3. Visualization Walkthrough

The Dispatched Calls Statistics Report is an interactive data visualization. This interactivity allows users to filter the information based on the questions they are hoping to answer with this dataset. An overview of the pre-built filters is included below.


a. Priority of Call Filter

The Priority of Call Filter is divided into three categories: High, Medium, and Low (for more information on these categories, please click here). To change the views, click the dropdown box and select the corresponding call priority you wish to view. All subsequent visuals will update accordingly. To remove the filer, either hover over the top-right corner of the filter and click the "Show All Values" button or click the dropdown again and select "(All)".


b. Neighborhood Filter

The Neighborhood Filter lists all neighborhoods in the City of Portland. To filter the visualizations by neighborhood, click the down arrow to the right of "(All)". You can either type in the neighborhood you are searching for in the "Enter search text" box or use the scroll bar to find the relevant neighborhood. To unselect all neighborhoods, click the checkmark to the left of "(All)" and then select the neighborhood you are interested in. Once you have made your selection, click on the "Apply" button at the bottom of the dropdown box.

If you are unsure which neighborhood you are interested in, click here to find out how to locate your neighborhood on PortlandMaps.com.

TIP: To quickly view all neighborhoods again, click the "(All)" box and the click "Apply".

 

 

 

 

 

 


c. Call Count and Average Response Time (min)

Call Count represents the total number of dispatched calls for the thirteen month time period. Average Response Time is the average time, in minutes, from when a call is first placed in the queue awaiting a dispatch to the time when the first officer arrived on-scene. Times are rounded to the nearest minute.

Both values will update based on any selected filters.


d. Total Dispatched Calls Map

The Total Dispatched Calls Map is an outline of all Portland neighborhoods using the Portland Police Bureau boundaries. The map dynamically updates based on selected filters. Darker colors signal that a greater number of calls occurred during the time period. The minimum and maximum values on the color scale adjust based on the other filters. Hover the mouse cursor over a shape to get basic information about that neighborhood, including its name and its respective number of dispatched calls.

The map can also be used to filter results in the different maps, values, and charts. To filter statistics by neighborhood, select the neighborhood on the map. Multiple neighborhoods can be selected by dragging the mouse when clicking or holding down the CTRL button on the keyboard when clicking the neighborhoods.

TIP: To reset the selected neighborhoods, click one of the highlighted neighborhoods to deselect.


e. Average Response Time Map

The Average Response Time Map is an outline of all Portland neighborhoods using the Portland Police Bureau boundaries. The map dynamically updates based on selected filters. Darker colors signal that, on average, it takes a Portland Police officer longer to respond to incidents in that neighborhood. The minimum and maximum values on the color scale adjust based on the other filters. Hover the mouse cursor over a shape to get basic information about that neighborhood, including its name and the average response time.

The map can also be used to filter results in the different maps, values, and charts. To filter statistics by neighborhood, select the neighborhood on the map. Multiple neighborhoods can be selected by dragging the mouse when clicking or holding down the CTRL button on the keyboard when clicking the neighborhoods.

TIP: To reset the selected neighborhoods, click one of the highlighted neighborhoods to deselect.


f.  Total Calls by Group

The first bar chart on the page is the Total Calls by Group bar chart. This chart details the frequency of calls by their respective groupings in the selected priority levels, neighborhoods, and months. For more information on call groupings, click here.

Like the Total Dispatched Calls and Average Response Time maps, the bar chart can be used to filter results. To filter, select one (or more) call groups to view how calls in that category are distributed geographically and over time.

TIP: Select more than one call by dragging the mouse when clicking or holding down the CTRL button on the keyboard when clicking the month.


 g.  Call Priority by Average Response Time

The graph on the lower-left of the report, Call Priority by Average Response Time, corresponds to the average call response at each priority level (high, medium, and low). For more information on priority levels, click here.

The bar char can be used to filter results on the other maps and charts on this visualization. To filter, select one (or more) priority groups to view how quickly calls in that grouping are responded to, either by month or neighborhood.


 g.  Total Calls by Month

The final view on the main report is the Total Calls by Month with Trend Line bar chart. This chart highlights the total number of calls (or, if filtered, the total count of all selected call groupings, priority, and/or neighborhoods) for the last 13 months.

Like the Total Calls by Group chart and Total Dispatched Calls and Average Response Time maps, the bar chart can be used to filter results; select one (or more) months to view the count of calls by groups and neighborhood for the selected months.

TIP: Select more than one month by dragging the mouse when clicking or holding down the CTRL button on the keyboard when clicking the month.


e. Toolbar

The toolbar, located at the bottom of the visualization, contains several buttons that assist in the analysis of the data.

The “Undo” and “Redo” buttons become active when the above filters are applied to the report. They operate just like the Undo and Redo buttons in other programs such as Microsoft Word.

The “Reset” button reverts all filters back to their original setting when you first visited the page. This is a great way to start with a “clean slate” after clicking several filters.

Tableau is the name of the software used to create this report visualization.

The “Download” button allows users to save a static version of the visualization. This option is great for printing out copies of the map to share at meetings or to include in a presentation.

“Get the App” takes you to a download page to acquire a Free Trial of Tableau Desktop.  This is not necessary, or recommended, to fully analyze and view the report.

“Tableau Workbook” allows you to download a file that works with the full version of Tableau Desktop, mentioned above. This is not necessary or recommended.

“PDF” allows users to export the report, with all of the filters you set, as a PDF. The options dialogue allows custom scaling and paper size options. When choosing to export as PDF, make sure to keep the layout as portrait and content as “this dashboard.”

The "Crosstab" and "Data" options are unavailable for use on the workbook's main page.

“Image” creates a .png file of the report with all of the selected filters.


f. Download Data

The Portland Police Bureau is a proud member of the Police Data Initiative. Open Data provides an opportunity to improve the relationship between the community and the PPB by increasing transparency, building community trust, and strengthening accountability.

The Download Data tab of this report was custom-built to meet the Bureau’s Open Data goals. To download a copy of the data for custom analyses and presentation, follow these steps:

    1. Click on the Download Data tab at the top of the report.
    2. Use the optional filters to splice and shrink the dataset based on desired parameters.
    3. Click on the “Download” button on the toolbar in the lower-right corner of the report.
    4. Click on “Data.”
    5. A new window will pop-up that shows only the first 200 rows of data. Click on the blue link that says “Download all rows as a text file.
    6. Once downloaded, the file can be imported to Microsoft Excel or other data analysis programs.

Location data is only provided to the block level to preserve victim anonymity. Calls deemed sensitive due to the nature of the call, potential victim or offender, potential victim/offender relationship, or investigation status may contain data that cannot be shared openly at this time. Call numbers and specific location information for sensitive cases are not included in the open data. These call numbers are signified with an “X” in their title.

TIP: If address information is not required for the desired analysis, click “Crosstab” instead of “Data” under the download tab. This removes a couple of steps, but still preserves all selected filters.