If you don't yet have a login to OakCrime.org, send a request to firstname.lastname@example.org. Please include which beat / NCPC you live in (cf. OPD District & Beat Locator), and a description of your intended use of the facility, so we can plan accordingly.
With a valid login, you will see the home splash page shown below:
There are currently four starting points for analysis of OPD incident data:
The central map shows a heatmap of crime across all of Oakland during the last 90 days. You should (depending on your web browser client's capabilities) be able to shift and zoom in and out on this map to capture a region as you wish.
:The figure above shows the date sliders at the top have been slid to select a narrower date range. Similarly, some of the crime category buttons along the left side have been selected. After zooming in and setting date and crime categories, hit the blue Update selection button and a new map will be repopulated according to these constraints. The result is shown in the figure below.
:If you zoom in close enough, the heatmap dissolves into a set of individual points that each correspond to specific incidents. Major crimes (homicide, rape, robbery, assault or weapons charges) are plotted with red pins, all other crimes use green pins. Yellow dots correspond to incidents described only in Patrol logs, but not in the standard incident reporting. Clicking any incident marker pops up its details (incident number, date and time, and crime category). The highlighted blue incident number is a hot link that goes to an incident-specific report page.
This view shows only crimes involving guns, as reported in the patrol logs, but otherwise follows the same basic operation as the heatmap.
This workflow begins with the longitudinal plot query page:
This form asks a user to specify a Beat of interest, then either one or two Crime Categories. All incidents since 2007 are included in the resulting plot.
The figure below shows the result of a query concerning beat 07X, and
COURT (blue lines) and
HOMICIDE (green lines) crime types:
As part of the title, the total number of (both beat and all-Oakland) incidents is shown for each crime type. Then, for each Crime Category, both:
A second workflow allows investigation of crime incidents based on their location. Results near pre-computed BART stops can be used to plot nearby crimes. The plot below shows incidents during the previous six months near the Macarthur BART station.
:The total number of crimes appears in the plot title. Major crimes (homicide, rape, robbery, assault or weapons charges) are plotted with red pins, all other crimes use green pins. Mousing over any incident marker pops up its details (incident number, date and time, and crime category).
A similar analysis is available for some (District 4) Oakland parks.
Three API endpoints have been defined, mirroring query patterns of the interface. All queries begin with the same
oakcrime.org/dailyIncid prefix, followed by one of three different strings:
For crimes relating to a specific beat, eg:
restricted to the last two years.
For crimes of a certain category, eg:
restricted to last 6 months
For crimes within 500m of some longitude_latitude, eg:
restricted to last 6 months. Note that longitude is provided first, and separated by an underbar(_) from latitude.
The default result is an HTML page. JSON output can be returned instead by adding the suffix
?format=json to the query, eg
Users that have been identified as the contact representative for their local NCPC can access a report in preparation for their regular meeting. An example is shown in this figure:
The report heading lists the dates for your beat that are included. In the map, incidents that OPD has assigned to your beat(s) are shown in large red circles. A relaxed "bounding box" around these incidents is shown as a gray rectangle. This region defines a larger set of other incidents in the vicinity of your beat. These other adjacent incidents are marked with smaller black dots. (Black dots within the beat seem to suggest incidents with incorrect beat assignment by OPD.)
Yellow dots correspond to incidents described only in Patrol logs, but not in the standard incident reporting.
Clicking on any dot will pop-up date and crime type information particular to that incident. The highlighted blue incident number is a hot link that goes to an incident-specific report page.
Above the map is a blue "Download beat data" button. Clicking it will download A CSV file to your computer. It containing all incidents associated with your beat (but not those only in the vicinity) during the time period.