PSDP Open Data Documentation
PSDP Open Data Documentation
Page 1 of 37
Analytics & Innovation
The Toronto Police Service is committed to the ongoing release of open data for public
safety, awareness, greater openness and transparency. The Service’s Open Data Program strives
to release valuable open data and provide continuous support for public understanding, use
and application of police information.
Government agencies and institutions under the Freedom of Information and Protection
of Privacy Act (FIPPA), the Municipal Freedom of Information and Protection of Privacy Act
(MFIPPA) and/or the Personal Health Information Protection Act (PHIPA) are required to provide
members of the public with access to public government data, unless the data is exempt for
legal, privacy, security, confidentiality or commercially-sensitive reasons 1. The Toronto Police
Service has adopted the Government of Ontario’s Open Data Directive and all police open
datasets are subject to the Open Government Licence. Open government guidelines define open
data as structured data that is machine-readable, freely shared, used and built on without
restrictions 2.
The Toronto Police Service publishes open datasets via the Toronto Police Service Public
Safety Data Portal designed to provide access to police open datasets for public use. This open
data portal delivers police information by providing downloadable open datasets that meet the
industry standards for open data, data visualizations, web mapping applications and supporting
documentation to aid public understanding and open data literacy of police information. The
Public Safety Data Portal can be accessed through the Toronto Police Service website or by
visiting directly at: [Link]
1
[Link]
2
[Link]
Page 2 of 37
Police Open Data & Privacy Considerations
Police open data includes any data collected or maintained by the Toronto Police Service unless
certain data or data in its entirety is exempt for legal, privacy, security, and confidentiality or
commercially-sensitive reasons. The Toronto Police Service considers privacy and data quality to
be of utmost importance. The Toronto Police Service is committed to the proactive provision of
police open data while taking necessary measures to protect privacy, legal and confidential data.
Therefore, the Toronto Police Service will:
• Not disclose data exempt for legal, privacy, security, confidentially or commercially-
sensitive reasons.
• Exclude data when the service is prevented from disclosing data by law/or authorized by
law to refuse its existence.
• Personal information is strictly protected unless sufficient statutory authority for release
and where appropriate.
The Toronto Police Service reserves the right to exclude the release of personal identification
information or any data that has the potential to identify an individual.
Geographic Information
Toronto Police Service Open Data includes geographic location information provided in
the projected coordinate system, WGS 1984 Web Mercator (auxiliary sphere). The location of
events were offset to the nearest road intersection to protect the privacy of parties involved in
the event. All data must be considered an approximate location of the event and users are
advised not to interpret any of these locations as related to a specific address or individual. For
datasets without location information, events are either at the neighbourhood level or they are
aggregated in a category.
Neighbourhood and coordinate information (latitude and longitude) will appear to be
Not Specified Area (NSA) and (0,0), respectively, if any of the following conditions are met: (1)
Division is NSA OR (2) Originating X/Y values are 0 OR (3) Originating X/Y values are outside the
City of Toronto.
City of Toronto neighbourhood information has been provided for both the old 140
neighbourhood structure as well as the new 158 neighbourhood structure. 3
3
[Link]
profiles/
Page 3 of 37
Important note regarding TPS Divisional boundaries: June 2018 marked the amalgamation
of divisions 54 and 55 and thus after this point all offences/crimes occurring in the boundaries
of “54 Division” have been marked as “55 Division”. Please note, data summarized in the open
analytics combines all data for 54 and 55 divisions together for historical comparisons.
Toronto Police Service Open Data is updated quarterly. Due to the dynamic nature of
police reporting, a complete update of the entire dataset is required. However, all historical date
ranges will be provided. See Appendix A for a complete list of datasets and their respective date
range availability.
Toronto Police Service provides open analytics to aid in visualizing and understanding
police information. These interactive visualizations provide trend analysis and important
information at a glance. Open analytics are delivered through Last Five (5) Years and Historical
Reports.
Last Five (5) Years: depending on the button selected, refers to the last five years including the
present year for the period of January 1 up to and including the previous Sunday as indicated
for Year-to-Date. For Year End, the period refers to January 1st to December 31st of the last five
full years:
Year-to-Date: refers to the period beginning on January 1st of the current year up to
and including the present date or date as indicated. The same time period may be
applied across multiple years in order to determine trends over time. The purpose of this
report is to keep the public informed of criminal activity and other police information on
a regular basis. Year-to-date open analytics are updated every Monday and include data
up to the previous day.
Important Note: Open Data for downloading is not available for Year-to-date reports. The
open data is provided to the public for awareness and reporting purposes only. Due to the
dynamic nature of police information, Uniform Crime Reporting information associated
with recently reported occurrences is preliminary and subject to change upon further
investigation.
Year End: refers to the full year period beginning on January 1st and ending on
December 31st. This time period may be applied across multiple years in order to
Page 4 of 37
compare year over year changes and/or determine trends over time. The purpose of this
report is to provide an overview of statistics for the previous year.
Historical: refers to all compiled data from previous years. Historical reports and open datasets
are updated and available for download upon the release of the associated open data at the end
of the first and third quarters of every year.
Web Mapping Applications
Toronto Police Service provides web mapping applications to visualize data spatially.
These dynamic and interactive web mapping applications allow users to visualize crime and
traffic data where it occurs. Crime App Year-to-date and Fatal Traffic Collisions web applications
provide up-to-date information related to the current year and are updated at different
intervals. Crime App Year-to-date is updated twice daily, with valid data up to the previous day.
Fatal Traffic Collisions is updated 1-2 business days after a fatality occurs. Web mapping
applications associated with downloadable open datasets are updated upon the open data
release associated with that dataset. For a complete list of web mapping applications, please
visit the Maps section on the portal.
This document is designed to provide a comprehensive guide regarding the various open
datasets currently provided on the Public Safety Data Portal 4. This document provides a list of
the open datasets currently available for downloading supplemented by detailed metadata, data
qualifiers, glossary of terms and links to related open analytics and web mapping applications.
This document also contains an Open Data Summary Table which includes a list of all open
datasets, table identifiers, data extraction dates, and date range. The Glossary can be found at
the end of this document (See Appendix B).
4
This guide excludes the Annual Statistical Report datasets, please refer to the ASR documentation. This
guide also excludes data currently reported through open analytics but not currently available as
downloadable open datasets (e.g. Sexual Violations).
Page 5 of 37
7. Field Information Reports (FIRS)
8. Traffic Collisions
9. Mental Health Act (MHA) Apprehensions
10. Persons in Crisis (PIC) Calls for Service Attended (CFSA)
11. Budget & Staffing
12. Theft from Motor Vehicle
13. Hate Crimes
OPEN DATASETS
Description
This dataset includes all Major Crime Indicators (MCI) occurrences by reported date and related
offences. The MCI categories include Assault, Break and Enter, Auto Theft, Robbery and Theft
Over. This data is provided at the offence and/or victim level (offence and/or vehicle level for
auto thefts), therefore one occurrence number may have several records associated to the
various MCIs used to categorize the occurrence. This data does not include occurrences that
have been deemed unfounded. The definition of unfounded according to Statistics Canada is: “It
has been determined through police investigation that the offence reported did not occur, nor
was it attempted” (Statistics Canada, 2020). 5
5
Statistics Canada. 2020. Uniform Crime Reporting Manual. Surveys and Statistical Programs. Canadian
Centre for Justice Statistics.
Page 6 of 37
10 OCC_YEAR Year Offence Occurred
11 OCC_MONTH Month Offence Occurred
12 OCC_DAY Day of the Month Offence Occurred
13 OCC_DOY Day of the Year Offence Occurred
14 OCC_DOW Day of the Week Offence Occurred
15 OCC_HOUR Hour Offence Occurred
16 DIVISION Police Division where Offence Occurred
17 LOCATION_TYPE Location Type of Offence
18 PREMISES_TYPE Premises Type of Offence
19 UCR_CODE UCR Code for Offence
20 UCR_EXT UCR Extension for Offence
21 OFFENCE Title of Offence
22 MCI_CATEGORY MCI Category of Occurrence
23 Identifier of Neighbourhood using City of Toronto's
HOOD_158 new 158 neighbourhood structure
24 Name of Neighbourhood using City of Toronto's new
NEIGHBOURHOOD_158 158 neighbourhood structure
25 Identifier of Neighbourhood using City of Toronto's old
HOOD_140 140 neighbourhood structure
26 Name of Neighbourhood using City of Toronto's old
NEIGHBOURHOOD_140 140 neighbourhood structure
27 LONG_WGS84 Longitude Coordinates (Offset to nearest intersection)
28 LAT_WGS84 Latitude Coordinates (Offset to nearest intersection)
Open Analytics
The Toronto Police Service currently reports on MCIs by providing a Year-to-date, a Year End
and a Historical report. Open analytics for each individual MCI are also available on the Data
Analytics page on the portal, however, these only include a historical report.
Homicides (ASR-RC-TBL-002)
Description
This dataset includes all Homicides occurrences. This includes offences of First Degree Murder,
Second Degree Murder, and Manslaughter. A homicide occurs when a person directly or
indirectly, by any means, causes the death of another human being. Deaths caused by criminal
Page 7 of 37
negligence, suicide, or accidental or justifiable homicide (i.e self-defence) are not included.
Homicide data is compiled based on the Homicide Squad Case List Log. Count is based on
offence (i.e each deceased victim).
Open Analytics
The Toronto Police Service currently reports on Homicide by providing a Year-to-date, a Year
End and a Historical report.
Page 8 of 37
Shootings & Firearm Discharges
Description
This dataset contains all shooting-related occurrences reported to the Toronto Police Service,
including, but not limited to, those that may have been deemed unfounded after investigation.
Shooting incidents in this dataset include both firearm discharges and shooting events, which
are defined in the glossary in Appendix B.
In 2014, the Toronto Police Service changed records management systems. For occurrences
prior to this date, coordinates are limited, therefore for some events with 0, 0 coordinates the
neighbourhood will be identified as ‘NSA’ to indicate ‘Not Specified Area.
Page 9 of 37
Open Analytics
The Toronto Police Service currently reports on Shootings by providing a Year-to-date, a Year
End and a Historical report.
Description
This dataset includes all of the Crime Data by Neighbourhood. Counts are available for Assault,
Auto Theft, Break and Enter, Robbery, Theft Over, Homicide and Shooting & Firearm Discharges.
Data also includes the crime rate per 100,000 population calculated using the population
estimates provided by Environics Analytics.
Page 10 of 37
Open Analytics
The Toronto Police Service does not currently provide open analytics reports for Neighbourhood
Crime Rates.
Bicycle Thefts
Description
This dataset contains occurrences related to bicycle thefts. These occurrences are related to a
variety of offences where the theft of a bicycle was included.
Page 11 of 37
21 BIKE_MODEL Model of Bicycle
22 BIKE_TYPE Type of Bicycle
23 BIKE_SPEED Speed of Bicycle
24 BIKE_COLOUR Colour of Bicycle
25 BIKE_COST Cost of Bicycle
26 STATUS Status of Bicycle
27 Identifier of Neighbourhood using City of Toronto's
HOOD_158 new 158 neighbourhood structure
28 Name of Neighbourhood using City of Toronto's new
NEIGHBOURHOOD_158 158 neighbourhood structure
29 Identifier of Neighbourhood using City of Toronto's
HOOD_140 old 140 neighbourhood structure
30 Name of Neighbourhood using City of Toronto's old
NEIGHBOURHOOD_140 140 neighbourhood structure
31 LONG_WGS84 Longitude Coordinates (Offset to nearest intersection)
32 LAT_WGS84 Latitude Coordinates (Offset to nearest intersection)
Open Analytics
The Toronto Police Service currently only provides a Historical Bike Theft report.
Description
This Killed or Seriously Injured (KSI) dataset is a subset from all traffic collision events. The
source of the data comes from police reports where an officer attended an event related to a
traffic collision. Please note that this dataset does not include all traffic collision events. The KSI
data only includes events where a person sustained a major or fatal injury in a traffic collision
event. The definitions included in Appendix B relate to the severity of injury used to classify the
events in this dataset. Other injury types including minor or none are associated to every
individual included in the event.
The KSI data includes a record (row) for every person involved in the collision event regardless
of their level of injury, it includes everyone who was involved in a particular collision event. The
field “Index” provides an arbitrary unique identification for every record in the entire dataset.
The “ACCNUM” is a unique identification for each traffic collision event. Since the data includes
every person involved in a collision event, this identification is duplicated. Please note that this
number is not unique and it may repeat year over year. Careful consideration must be made
Page 12 of 37
when creating a subset for unique events, as the detailed information provided is for every
person involved and its associated role and information may be lost.
For example, the event with ACCNUM=6000607400 has 5 persons involved in the collision (5
records). The field “INVTYPE” indicates the role of the person in the collision event. The
“INVAGE” indicates the age range of the person and the “INJURY” type indicates the level of
injury they sustained. Therefore, this event can be interpreted in the following way:
1. Passenger 1 age 20 to 24 sustained a fatal injury.
2. Passenger 2 age 15-19 sustained a fatal injury.
3. Passenger 3 age 20 to 24 sustained a major injury
4. Driver age 1 20 to 24 sustained a major injury.
5. Driver 2 age 45 to 49 sustained a major injury.
Synopsis: “IMPACTYPE” indicates this was a rear-end type of collision. “MANOUVER”, “DRIVACT”
and “DRIVCON” indicates Driver 2 stopped, was driving properly and in normal condition.
However, Driver 1 was changing lanes, sped too fast for conditions and had been drinking.
There are thirteen categories related to the type of event. Each record is flagged with a “Yes” if
this collision is considered to fall under this criteria. Definitions for those categories are provided
below.
Page 13 of 37
16 RDSFCOND Road Surface Condition
17 ACCLASS Classification of Accident
18 IMPACTYPE Initial Impact Type
19 INVTYPE Involvement Type
20 INVAGE Age of Involved Party
21 INJURY Severity of Injury
22 FATAL_NO Sequential Number
23 INITDIR Initial Direction of Travel
24 VEHTYPE Type of Vehicle
25 MANOEUVER Vehicle Manoeuver
26 DRIVACT Apparent Driver Action
27 DRIVCOND Driver Condition
28 PEDTYPE Pedestrian Crash Type - detail
29 PEDACT Pedestrian Action
30 PEDCOND Condition of Pedestrian
31 CYCLISTYPE Cyclist Crash Type - detail
32 CYCACT Cyclist Action
33 CYCCOND Cyclist Condition
34 PEDESTRIAN Pedestrian Involved In Collision
35 CYCLIST Cyclists Involved in Collision
36 AUTOMOBILE Driver Involved in Collision
37 MOTORCYCLE Motorcyclist Involved in Collision
38 TRUCK Truck Driver Involved in Collision
39 TRSN_CITY_VEH Transit or City Vehicle Involved in Collision
40 EMERG_VEH Emergency Vehicle Involved in Collision
41 PASSENGER Passenger Involved in Collision
42 SPEEDING Speeding Related Collision
43 AG_DRIV Aggressive and Distracted Driving Collision
44 REDLIGHT Red Light Related Collision
45 ALCOHOL Alcohol Related Collision
46 DISABILITY Medical or Physical Disability Related Collision
47 HOOD_158 Unique ID for City of Toronto Neighbourhood (new)
48 NEIGHBOURHOOD_158 City of Toronto Neighbourhood name (new)
49 HOOD_140 Unique ID for City of Toronto Neighbourhood (old)
50 NEIGHBOURHOOD_140 City of Toronto Neighbourhood name (old)
51 DIVISION Toronto Police Service Division
52 ObjectID Unique Identifier (auto generated)
Open Analytics
The Toronto Police Service currently only provides a Historical Killed or Seriously Injured Traffic
Collisions report. These historical reports are available for each individual Killed or Serially
Injured category.
Page 14 of 37
Web Mapping Applications
The Fatal Traffic Collisions includes historical fatal traffic collisions only, a subset of the Killed or
Serially Injured dataset.
Description
As part of our ongoing commitment to open data, the Toronto Police Service continues to
release data sets relating to completed Municipal Freedom of Information and Protection of
Privacy Act requests that are of public interest. This data includes Field Information Reports
reported between 2008.01.01 and 2013.11.04.
Format: CSV
Note: Please note this dataset is no longer updated.
Open Analytics
The Toronto Police Service does not currently provide open data analytics for Field Information
Reports.
Page 15 of 37
Traffic Collisions (ASR-T-TBL-001)
Description
This dataset includes all Motor Vehicle Collision (MVC) occurrences by their occurrence date and
related offences. The MVC categories include property damage (PD) collisions, Fail to Remain
(FTR) collisions, injury collisions and fatalities. This data is provided at the occurrence level,
therefore multiple offences and/or victims can be associated with each record. This data does
not include occurrences that have been deemed unfounded. The definition of unfounded
according to Statistics Canada is: “It has been determined through police investigation that the
offence reported did not occur, nor was it attempted” (Statistics Canada, 2020). 6
In this dataset a collision is defined as the contact resulting from the motion of a motor vehicle
or streetcar or its load, which produces property damage, injury or death. The term collision
indicates that the initial point of contact involved at least one motor vehicle or streetcar.
Definitions:
Fatal Collisions occur when an individual’s injuries from a MVC result in a fatality within 30 days.
Please note this category excludes:
(i) Occurrences on private property
(ii) Occurrences related to sudden death prior to collision (suicide or medical episode)
(iii) Occurrences where the individual has died more than 30 days after the collision
Personal Injury Collisions occur when an individual involved in a MVC suffers personal injuries.
Fail to Remain Collisions occur when an individual involved in a MVC fails to stop and provide
their information at the scene of a collision.
Property Damage Collisions occur when an individual’s property has been damaged in a MVC
or the value of damages is less than $2,000 for all involved parties.
6
Statistics Canada. 2020. Uniform Crime Reporting Manual. Surveys and Statistical Programs. Canadian
Centre for Justice Statistics.
Page 16 of 37
7 DIVISION Police Division where Collision Occurred
8 Number of Person’s Killed associated with the Collision
FATALITIES
(See definitions)
9 Indicates whether a Collision had an associated Injury (See
INJURY_COLLISIONS
definitions)
10 Indicates whether a Collision was associated to Fail to
FTR_COLLISIONS
Remain (See definitions)
11 Indicates Whether a Collision was associated to Property
PD_COLLISIONS
Damage (See definitions)
12 HOOD_158 Identifier of Neighbourhood
13 NEIGHBOURHOOD_158 Name of Neighbourhood where Collision Occurred
14 LONG_WGS84 Longitude Coordinate (Offset to nearest intersection)
15 LAT_WGS84 Latitude Coordinate (Offset to nearest intersection)
16 Indicates whether a Collision involved a person in an
AUTOMOBILE
automobile
17 Indicates whether a Collision involved a person in a
MOTORCYCLE
motorcycle
18 Indicates whether a Collision involved a passenger in a
PASSENGER
motor vehicle
19 BICYCLE Indicates whether a Collision involved a cyclist
20 PEDESTRIAN Indicates whether a Collision involved a pedestrian
Open Analytics
Toronto Police Service currently reports on Total Motor Vehicle Collisions in the Annual
Statistical Report Crime & Traffic Dashboard which is updated annually.
Description
This dataset includes Mental Health Act (MHA) Apprehensions pursuant to the Mental Health
Act.
MHA Apprehensions of individuals aged 17 and under have been omitted to protect youth
identity. From 2014 to 2020, these individuals comprised 6.5% (4,724 of 71,717) of all MHA
Apprehensions, with individuals under 12 comprising 0.4% (320 of 71,717), and 12-17
Page 17 of 37
comprising 6.1% (4,404 of 71,717) respectively. There are instances where an individual’s age
group is classified as “Not Recorded”; these account for 1.3% (915 of 71,717) of all MHA
Apprehensions.
There are instances where an individual’s sex is classified as “Not Recorded”. In line with
recommendations 5f, 11c, and 25c in Police Reform in Toronto: Systemic Racism, Alternative
Community Safety and Crisis Response Models and Building New Confidence in Public Safety,
Toronto Police Service continues to work towards enhancing data collection to include non-
binary gender options.
Each row in the dataset represents a distinct MHA Apprehension and this dataset is queried
based on reported date. Please note while each row represents the apprehension of an
individual under the Mental Health Act, a unique individual may have been apprehended
multiple times and thus account for multiple records of apprehensions
MHA Apprehension types are as follows:
• MHA Section 17 (Police Officer’s Power of Apprehension);
• MHA Section 15 (Form 1 - Physician - Application for Psychiatric
Assessment);
• MHA Section 16 (Form 2 – Justice of the Peace – Order for Examination);
• MHA Section 28 (1) (Form 9 - Elopee - Order for Return); and,
• MHA Section 33.4 (Form 47 - Community Treatment Order for Examination).
Format: CSV
Page 18 of 37
13 OCC_DAY Day of the Month Offence Occurred
14 OCC_DOW Day of the Week Offence Occurred
15 OCC_HOUR Hour Offence Occurred
16 DIVISION Police Division where Offence Occurred
17 PREMISES_TYPE Premises Type of Offence
18 The section applied when apprehending an individual
APPREHENSION_TYPE pursuant to the Mental Health Act
19 SEX Sex of Person Apprehended
20 AGE_COHORT Age category of Person Apprehended
21 Identifier of Neighbourhood using City of Toronto's new
HOOD_158 158 neighbourhood structure
22 Name of Neighbourhood using City of Toronto's new
NEIGHBOURHOOD_158 158 neighbourhood structure
23 Identifier of Neighbourhood using City of Toronto's old
HOOD_140 140 neighbourhood structure
24 Name of Neighbourhood using City of Toronto's old 140
NEIGHBOURHOOD_140 neighbourhood structure
Open Analytics
The Toronto Police Service currently reports on MHA Apprehensions by providing a Historical
report.
Description
This dataset includes all Persons in Crisis (PIC) calls for service attended (CFSA) which includes
the following Event Types: Attempt Suicide, Person in Crisis, Elopee, Overdose and Threaten
Suicide. To protect the privacy of individuals involved in Calls for Service, these Event Types have
been aggregated into Person in Crisis calls (Person in Crisis, Elopee), Suicide-related calls
(Attempt Suicide, Threaten Suicide), and Overdose calls. This dataset includes only events that
were attended by an officer of the Toronto Police Service (TPS), but excludes events attended by
TPS members in Parking, Marine, Court or Primary Report Intake Management and Entry
(PRIME). This dataset is queried based on event date.
Effective May 2023, the Toronto Police Service has removed the Jumper event type. Calls of this
nature are now being processed as Threatening Suicide.
Page 19 of 37
Format: CSV
Open Analytics
Toronto Police Service currently reports on PIC CFSA by providing a Historical report.
Description
These datasets include a line-by-line breakdown of the Toronto Police Service budget and actual
expenditures at a Service-wide level and a summarized breakdown of the Toronto Police Service
Page 20 of 37
budget and actual expenditures and approved and actual staffing level by command. Budget is
provided by the categories Proposed Budget, Approved Budget and Actual Expenditures.
Please note that a salary settlement of $23,402,500 is not included in the 2022 Proposed Budget
Open Data.
Definitions:
Approved Budget: Operating funding approved by the Toronto Police Services Board and City
Council for a specific fiscal year.
Actual Expenditures: Operating expenses incurred by the Toronto Police Service during a fiscal
year.
Approved Staffing: All positions which have been approved via the annual and/or ad hoc
budget process for continuous delivery of core operations and services and/or specific
projects/initiatives.
Actual Staffing: All full-time, part-time and temporary employees active on the operating
payroll or who are on paid leave at the end of the year.
Proposed Budget: Operating funding presented to the Toronto Police Services Board for
approval for a specific fiscal year.
SAP: Enterprise resource planning software suite made by SAP SE. This is the system of record
for financial information of the Toronto Police Service.
Format: CSV
Budget Line-by-Line
Page 21 of 37
structure, and may have multiple Pillars within its span of
control.
A Pillar, headed by a Director (Civilian) or Staff
Superintendent (Uniform) represents the second highest
level of the organizational structure, and may have
5 Pillar Name
multiple Districts within its span of control. TPS Pillars
include but are not limited to East Field Command, West
Field Command, and Detective Operations.
A District represents the third highest level of the
6 District Name organizational structure, and may have multiple Units
within its span of control.
A Unit represents the fourth highest level of the
organizational structure and focuses on a specific area of
7 Unit Name operations. Examples of units within Toronto Police
Service include Employee Services, Talent Acquisition,
name a few more across TPS
A group of cost elements of the same type. For
8 Feature_Category
example, Salaries, Benefits, Equipment or Revenue.
In SAP, it represents a numerical reference to a particular
kind of expense or revenue. For example, 2510 is the
9 Cost Element cost element denoting “Survey Supplies”. A cost
element corresponds to a cost-relevant item in the City’s
chart of accounts.
Name of the cost element as presented in SAP. For
10 Cost Element Long Name example, Membership Fees, Long Term Disability or
Gasoline.
Funding (requested, approved or actual expenditures)
11 Amount
for a particular budget line item.
Budget by Command
Page 22 of 37
revenue categories include Salaries, Benefits, Equipment
or Revenue.
Funding (requested, approved or actual expenditures)
5 Amount
for a particular budget line item.
Staffing by Command
Open Analytics
Toronto Police Service currently reports on the Actual Expenditures and Staffing in the Annual
Statistical Report Administrative Dashboard which is updated annually.
Description
This dataset includes all Theft from Motor Vehicle occurrences by reported date and related
offences. The Theft from Motor Vehicle offences include Theft from Motor Vehicle Under and
Theft from Motor Vehicle Over. This data is provided at the offence and/or victim level, therefore
one occurrence number may have several records associated to the various offences used to
categorize the occurrence. This data does not include occurrences that have been deemed
unfounded. The definition of unfounded according to Statistics Canada is: “It has been
Page 23 of 37
determined through police investigation that the offence reported did not occur, nor was it
attempted” (Statistics Canada, 2020). 7
7
Statistics Canada. 2020. Uniform Crime Reporting Manual. Surveys and Statistical Programs. Canadian
Centre for Justice Statistics.
Page 24 of 37
28 LAT_WGS84 Latitude Coordinates (Offset to nearest intersection)
Open Analytics
The Toronto Police Service currently reports on Theft from Motor Vehicle occurrences by
providing open analytics on the Data Analytics page on the portal in a historical report.
Hate Crimes
Description
This dataset includes all verified Hate Crime occurrences investigated by the Hate Crime Unit by
reported date since 2018. The Hate Crime categories (bias categories) include Age, Mental or
Physical Disability, Race, Ethnicity, Language, Religion, Sexual Orientation, Gender and Other
Similar Factor.
The categories relating to Disability, Race, Ethnicity, Religion, Sexual Orientation, and Gender
were developed and standardized with the collaboration of the following units: Hate Crimes
Unit; Equity, Inclusion and Human Rights Unit; Analytics & Innovation Unit; and the Information
Management Pillar (Data Governance team). The Race categories are in compliance with
Ontario’s Anti-Racism Data Standards. Ethnicity and Religion categories were taken from
Statistics Canada’s 2021 census. Categories for Sexual Orientation and Gender were developed
as part of EIHR’s Gender Diverse and Trans Inclusion (GDTI) initiative through community
consultations and engagements with other organizations such as the City of Toronto.
This data is provided at the offence and/or occurrence level, therefore one occurrence may have
multiple bias (multi-bias) categories associated to the victim.
This data only includes confirmed hate crimes. This data does not include occurrences that have
been deemed unfounded, classified as hate incidents or suspected. The definition of unfounded
according to Statistics Canada is: “It has been determined through police investigation that the
offence reported did not occur, nor was it attempted” (Statistics Canada, 2020). 8
8
Statistics Canada. 2020. Uniform Crime Reporting Manual. Surveys and Statistical Programs. Canadian
Centre for Justice Statistics.
Page 25 of 37
Definitions:
Hate crime
A hate crime is a criminal offence committed against a person or property motivated in whole or
in part by bias, prejudice or hate based on race, national or ethnic origin, language, colour,
religion, sex, age, mental or physical disability, sexual orientation or gender identity or
expression or any other similar factor.
Hate incident
A hate incident is a non-criminal action or behaviour that is motivated by hate against an
identifiable group. Examples of hate incidents include using racial slurs, or insulting a person
because of their ethnic or religious dress or how they identify.
Format: CSV
Page 26 of 37
19 GENDER_BIAS A Hate Crime committed on the basis of the Suspect’s
perception of the Victim’s gender
20 MULTI_BIAS A Hate Crime with more than one Bias Category
21 PRIMARY_OFFENCE The Offence committed in relation to the Hate Crime.
22 HOOD_158 Identifier of Neighbourhood using City of Toronto's new
158 neighbourhood structure
23 NEIGHBOURHOOD_158 Name of Neighbourhood using City of Toronto's new
158 neighbourhood structure
24 HOOD_140 Identifier of Neighbourhood using City of Toronto's old
140 neighbourhood structure
25 NEIGHBOURHOOD_140 Name of Neighbourhood using City of Toronto's old
140 neighbourhood structure
26 ARREST_MADE An entity can be considered arrested when a charge is
laid, recommended or the person(s) who committed the
offence has been identified and taken into custody for
the same.
Open Analytics
The Toronto Police Service currently reports on hate crime by providing open analytics on the
Data Analytics page on the portal. Previous Hate/Bias crime documentation can be found at:
[Link]
Note, hate crime counts are subject to change based on re-evaluation of the occurrence or
changes in reporting methodology.
Page 27 of 37
Appendix A:
Open Data Summary Table
Page 28 of 37
Premises Type Summary Table
Page 29 of 37
Ttc Bus
Ttc Bus Garage
Ttc Light Rail Transit Station
Ttc Light Rail Vehicle
Ttc Street Car
Ttc Subway Station
Ttc Subway Train
Ttc Subway Tunnel / Outdoor Tracks
Ttc Support Vehicle
Ttc Wheel Trans Vehicle
Page 30 of 37
Appendix B:
Glossary
Actual Expenditures
Operating expenses incurred by the Toronto Police Service during a fiscal year.
Actual Staffing
All full-time, part-time and temporary employees active on the operating payroll or who are on
paid leave at the end of the year.
Aggressive Driving
These events include any serious or fatal collision where aggressive driving played a role in the
collision. Aggressive Driving events refer to one or more persons operating a motor vehicle who
were acting in one or more of the following ways:
• Operating the vehicle at a speed in excess of the maximum posted limit
• Operating the vehicle within the posted limit, but too fast for existing road conditions
• Following too closely
• Disobeying a traffic control
• Failing to yield right-of-way
• Passing improperly
Alcohol
These events include any serious or fatal collision where alcohol consumption played a role in
the collision. Alcohol consumption is involved when one or more persons operating a motor
vehicle had consumed alcohol and, upon testing, were found to either:
• Have a blood-alcohol level in excess of 80 mg
• Had consumed sufficient alcohol to warrant being charged with a drinking and driving
offence.
Approved Budget
Operating funding approved by the Toronto Police Services Board and City Council for a specific
fiscal year.
Approved Staffing
All positions which have been approved via the annual and/or ad hoc budget process for
continuous delivery of core operations and services and/or specific projects/initiatives.
Assault
The direct or indirect application of force to another person, or the attempt or threat to apply
force to another person, without that person’s consent.
Page 31 of 37
Automobile
Traffic-related collisions involving occupants of an Automobile. It includes motor vehicle with
more than three wheels for general use including: cars, station wagons, taxis, passenger vans,
delivery vans, pickup trucks, tow trucks, SUVs.
Auto Theft
The act of taking another person's vehicle (not including attempts). Auto Theft figures represent
the number of vehicles stolen.
Bicycle Theft
An occurrence where a theft of a bicycle occurred.
Collision
The contact resulting from the motion of a motor vehicle or streetcar or its load, which produces
property damage, injury or death. The term collision indicates that the initial point of contact
involved at least one motor vehicle or streetcar.
Crime Rate
Following the standard definition by Statistics Canada, crime rate is defined as the crime count
per 100,000 population 9 per year.
Cyclists
These events include any serious or fatal collision where a cyclist is involved. A cyclist is a person
controlling or a passenger on a road vehicle propelled by human power (i.e. pedalling) through
a belt, chain or gear. (i.e.) a moped or bicycle.
Death
Where the injured person (as defined above) has died as a result of injuries sustained from a
bullet(s).
Emergency Vehicle
These events include any serious or fatal involving an operator or passenger of an emergency
vehicle. An emergency vehicle is any vehicle that is designated and authorized to respond to an
emergency. These vehicles are usually operated by designated agencies, often part of the
government, but also run by charities, nongovernmental organizations and some commercial
companies. Emergency vehicles include the following:
• Police car
9 Population figures reflect only the resident population of a region. The temporary population such as the
commuters and business patrons are not included.
Page 32 of 37
• Ambulance
• Fire truck
Fatal Collisions
These collisions occur when an individual’s injuries from a MVC result in a fatality within 30 days.
Please note this category excludes:
(i) Occurrences on private property
(ii) Occurrences related to sudden death prior to collision (suicide or medical episode)
(iii) Occurrences where the individual has died more than 30 days after the collision
Firearm Discharge
Any incident where evidence exists that a projectile was discharged from a firearm (as defined
under the Criminal Code of Canada) including accidental discharge (non-police), celebratory fire,
drive-by etc.
Homicide Occurrence
The homicide category includes the offences of First Degree Murder, Second Degree Murder,
and Manslaughter. A homicide occurs when a person directly or indirectly, by any means, causes
the death of another human being. Deaths caused by criminal negligence, suicide, or accidental
or justifiable homicide (i.e self-defence) are not included. Homicide data is compiled based on
the Homicide Squad Case List Log. Count is based on offence (i.e each deceased victim).
Homicide Victim
Any deceased person where the offence of First or Second Degree Murder or Manslaughter was
committed.
Homicide Type
Homicides are categorized into three types:
• Shooting: Where the cause of death was as a result of being shot with a firearm.
• Stabbing: Where the cause of death was as a result of an edged weapon (such as a
knife or other blade).
• Other: Where the cause of death was as a result of other methods such as blunt force
trauma or strangulation.
Injuries
Where the injured person (as defined above) has non-fatal physical injuries as a result of a
bullet(s).
Page 33 of 37
Killed or Seriously Injured (KSI)
Traffic collision where a person was killed or seriously injured.
Major Injury
A non-fatal injury that is severe enough to require the injured person to be admitted to hospital,
even if only for observation at the time of the collision. Includes: fracture, internal injury, severe
cuts, crushing, burns, concussion, severe general shocks.
Motorcyclists
These events include any serious or fatal collision where a motorcyclist is involved. A
Motorcyclist is a person operator or a passenger of a self-propelled motor vehicle with not more
than three wheels.
Passenger
These events include any serious or fatal collisions where a passenger is involved. A passenger is
an occupant of a vehicle who is not in control of said vehicle.
Pedestrian
These events include any serious or fatal collision where a Pedestrian is involved. A pedestrian is
a person not occupying a bicycle or motor vehicle and can be doing any of the following:
• Walking
• Sitting
Page 34 of 37
• Lying
• Standing
• Working on a road or place
• Or using a small wheeled device that provides personal mobility such as the following:
o skateboard
o skates
o in-line skates
o scooter
o Segway
o stroller
o wheelchair
Persons Involved
Total persons involved in the collisions either killed or seriously injured.
Physical/Medical Disability
These events include any serious of fatal collisions where the operator of the vehicle has a
medical or physical disability. Any serious or fatal collision where one or more persons operating
a motor vehicle have a medical or physical disability that may or may not have played a factor in
the collision. A medical or physical disability is a condition such as the following:
• Diabetes
• Epilepsy
• Amputee
• Broken bones, etc.
Proposed Budget
Operating funding presented to the Toronto Police Services Board for approval for a specific
fiscal year.
Page 35 of 37
Red Light
These events include any serious or fatal collision where red light running played a role in the
collision. Red light running is when one or more persons operating a motor vehicle proceeded
into a signalized intersection while the signal display indication was red.
Robbery
The act of taking property from another person or business by the use of force or intimidation in
the presence of the victim.
SAP
Enterprise resource planning software suite made by SAP SE. This is the system of record for
financial information of the Toronto Police Service.
Sexual Violation
A wide range of offences that fall under the Sexual Assault category, including sexual assault (s.
271), sexual assault with a weapon, threats to a third party or causing bodily harm (s. 272),
aggravated sexual assault (s. 273), administering drugs for sex (s. 212), indecent assault (s. 141,
149, 148, 156) sexual interference (s. 151), invitation to sexual touching (s. 152), and sexual
exploitation (s. 153). It refers to any type of sexual activity that is not consented to. Behaviours
may range in severity from gestures, verbal assaults and attempts, to forced penetration,
disfigurement and endangerment of life. More so than with any other type of crime, sexual
assaults (including child abuse) are often reported to police long after the incident has taken
place, if they are reported at all.
Shooting Event/Occurrence
Any incident in which a projectile is discharged from a firearm (as defined under the Criminal
Code of Canada) and injures a person. This excludes events such as suicide and police involved
firearm discharges.
Speeding
These events include any serious or fatal collision where speeding played a role in the collision.
Speeding is when one or more persons operating a motor vehicle were either: operating the
vehicle at a speed in excess of the maximum posted limit or operating the vehicle within the
posted limit, but too fast for existing road conditions.
Theft Over
The act of stealing property in excess of $5,000 (excluding auto theft).
Page 36 of 37
Time Periods
Year-to-Date
Refers to the period beginning on January 1st of the current year up to and including the
present date or date as indicated. The same time period may be applied across multiple
years in order to determine trends over time.
Year End
Refers to the full year period beginning on January 1st and ending on December 31st.
This time period may be applied across multiple years in order to compare year over year
changes and/or determine trends over time.
Historical
Refers to all compiled data from previous years.
Truck
These events include any serious or fatal collision involving an operator or passenger of a truck.
A truck is a large motorized vehicle of transport such as the following: open truck, closed truck,
tanker truck, dump truck, car carrier or a tractor trailer. The definition of truck does not include
the following: delivery van, passenger van, pickup truck, van or an SUV.
TTC/Municipal Vehicle
These events include any serious or fatal collision involving an operator or passenger of a transit
vehicle or streetcar.
Page 37 of 37
The Toronto Police Service's crime data can be accessed in formats including CSV, KML, Shapefile, and GeoJSON. Both the Homicide and Shooting datasets are available in these formats .
The Toronto Police Service uses two systems to classify neighbourhoods: the new 158 neighbourhood structure and the old 140 neighbourhood structure. This dual system helps in historical comparisons and continuity in crime reporting across administrative changes .
The Toronto Police Service incorporates geographic information by identifying the neighbourhood where an offence occurred using two systems: the new 158 neighbourhood structure and the old 140 neighbourhood structure. Coordinates (Longitude and Latitude) are also provided, offset to the nearest intersection .
The Toronto Police Service reports on MCIs through Year-to-date, Year End, and Historical reports. They provide open analytics for each MCI, available on their Data Analytics page. Web Mapping Applications, such as the Neighbourhood Crime Map, offer interactive thematic maps for analysis .
The MCI Category plays a critical role in crime reporting by enabling the Toronto Police Service to classify offences into distinct categories for better analysis, trend identification, and resource allocation. This categorization helps in systematically addressing specific crime types .
Deaths caused by criminal negligence, suicide, or accidental or justifiable homicide (i.e., self-defense) are not included in the Toronto Police Service’s homicide dataset .
Homicides are categorized into three types: Shooting, Stabbing, and Other. Shooting involves deaths caused by firearms, Stabbing by edged weapons like knives, and Other includes methods such as blunt force trauma or strangulation .
A personal injury collision is defined as an event where an individual involved in a motor vehicle collision suffers physical injuries. This classification can impact how incidents are prioritized and investigated based on injury severity .
Crime rate is defined as the crime count per 100,000 population per year, following the standard definition by Statistics Canada .
Bicycle thefts are managed and reported by including occurrences related to a variety of offences involving the theft of bicycles. Data is available in formats such as CSV, KML, Shapefile, and GeoJSON, allowing for comprehensive analysis and reporting .