Uses of Police Data
Written by Crime Content Coordinator   
crime graph

Using a free software package, OpenOffice, neighborhood leaders with an analytic bent can make a graph of their neighborhood crime experience.  Picking up a line of data from the police crime incident table for Midvale Park, a graph like the one shown here can be created.

Read more about other examples and how to interpret them:



One use of police incident data available for each neighborhood is to produce a graph of weekly counts. This example, by Lois Pawlak, Treasurer of the Garden District NA, shows her neighborhood's year to date crime call experience.

"I made one of the charts by putting the info in Excel as you suggested. That was very easy!" Lois said.

Lois found the Garden District's line of data in the table, copied it to her clipboard and pasted it into Excel (spreadsheet software).  Then she labeled the graph, added a trendline and a title, and was done.

The graph shows the week to week ups and downs of crime incident counts, which average about 31 per week.  The spike in the ninth week is followed by a return to 'normal' levels. The overall impression is that crime incident levels are much the same from the beginning of the year to the most recent week.

Peter Howell graph


Some folks may not have the Excel spreadsheet program available to them.

This example was created using Google Docs which is a free program available over the internet.

Users can create a spreadsheet, paste in data and create a chart like this example.

Last Updated ( Sunday, 09 November 2008 )
< Prev   Next >
Copywrite 2007-08 All Rights Reserved
Providing Information and Support Services to Neighborhood Leaders in the Tucson Region
School Joomla Websites