Data Dictionary

ID
EVENT_UNIQUE_ID
Type
text
Description

Offence Number

ID
REPORT_DATE
Type
date
Description

Date Offence was Reported

ID
OCC_DATE
Type
date
Description

Date of Offence

ID
REPORT_YEAR
Type
text
Description

Year Offence was Reported

ID
REPORT_MONTH
Type
text
Description

Month Offence was Reported

ID
REPORT_DAY
Type
text
Description

Day of the Month Offence was Reported

ID
REPORT_DOY
Type
text
Description

Day of the Year Offence was Reported

ID
REPORT_DOW
Type
text
Description

Day of the Week Offence was Reported

ID
REPORT_HOUR
Type
text
Description

Hour Offence was Reported

ID
OCC_YEAR
Type
text
Description

Year Offence Occurred

ID
OCC_MONTH
Type
text
Description

Month Offence Occurred

ID
OCC_DAY
Type
text
Description

Day of the Month Offence Occurred

ID
OCC_DOY
Type
text
Description

Day of the Year Offence Occurred

ID
OCC_DOW
Type
text
Description

Day of the Week Offence Occurred

ID
OCC_HOUR
Type
text
Description

Hour Offence Occurred

ID
DIVISION
Type
text
Description

Police Division where Offence Occurred

ID
LOCATION_TYPE
Type
text
Description

Location Type of Offence

ID
PREMISES_TYPE
Type
text
Description

Premises Type of Offence

ID
UCR_CODE
Type
text
Description

UCR Code for Offence

ID
UCR_EXT
Type
text
Description

UCR Extension for Offence

ID
OFFENCE
Type
text
Description

Title of Offence

ID
CSI_CATEGORY
Type
text
Description

CSI Category of Occurrence

ID
HOOD_158
Type
text
Description

Identifier of Neighbourhood using City of Toronto's new 158 neighbourhood structure

ID
LONG_WGS84
Type
float8
Description

Longitude coordinate

ID
LAT_WGS84
Type
float8
Description

Latitude coordinate

Additional Information

Field Value
Data last updated May 3, 2022
Metadata last updated April 23, 2026
Created May 3, 2022
Format GeoJSON
License License not specified
Datastore activeTrue
Datastore cache{'CSV': {'4326': 'a8b3ec01-2c82-41b8-81f3-eec5758e519f', '2952': 'ff35e5ec-c730-4e61-9f22-13865d36e697'}, 'SHP': {'4326': 'a44d98f2-f797-44ad-b48d-87e27c5bef72', '2952': '0bd37a09-c858-4b0e-a185-d2a600216744'}, 'GPKG': {'4326': 'c8f3edc5-b1d8-42bd-9ba9-b33287876266', '2952': 'cd2a3958-2294-4a53-b406-b073bc49ca7d'}, 'GEOJSON': {'4326': 'da7df019-3741-46df-8a77-d172802cfcfa'}}
Datastore cache last update2 weeks ago
Extract jobAirflow - files_to_datastore.py - theft-from-motor-vehicle
Has viewsTrue
Id138efc01-91ca-4bfb-9e92-721e1477dc6a
Is previewTrue
Package id1fc65d1e-7dae-4766-98dd-3b172e40a089
Package name or idtheft-from-motor-vehicle
Position0
Record count106,574
Stateactive
Url typedatastore
Vertex count106,574
Extract Job Airflow - files_to_datastore.py - theft-from-motor-vehicle
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. SHP
  3. GPKG
  4. GEOJSON
Datastore Cache Last Updated
Datastore resource's ID