Data Dictionary

Column Type Label Description
EVENT_UNIQUE_ID text

Offence Number

PRIMARY_OFFENCE text

Primary Offence Type

OCC_DATE date

Date of Offence

OCC_YEAR text

Year Offence Occurred

OCC_MONTH text

Month Offence Occurred

OCC_DOW text

Day of the Month Offence Occurred

OCC_DAY text

Day of the Year Offence Occurred

OCC_DOY text

Day of the Week Offence Occurred

OCC_HOUR text

Hour Offence Occurred

REPORT_DATE date

Date Offence was Reported

REPORT_YEAR text

Year Offence was Reported

REPORT_MONTH text

Month Offence was Reported

REPORT_DOW text

Day of the Month Offence was Reported

REPORT_DAY text

Day of the Year Offence was Reported

REPORT_DOY text

Day of the Week Offence was Reported

REPORT_HOUR text

Hour Offence was Reported

DIVISION text

Police Division where Offence Occurred

LOCATION_TYPE text

Location Type of Offence

PREMISES_TYPE text

Premises Type of Offence

BIKE_MAKE text

Make of Bicycle

BIKE_MODEL text

Model of Bicycle

BIKE_TYPE text

Type of Bicycle

BIKE_SPEED text

Speed of Bicycle

BIKE_COLOUR text

Colour of Bicycle

BIKE_COST float8

Cost of Bicycle

STATUS text

Status of Bicycle

LONG_WGS84 float8

Longitude coordinate

LAT_WGS84 float8

Latitude coordinate

geometry text

Additional Information

Field Value
Data last updated March 23, 2021
Metadata last updated March 27, 2025
Created March 23, 2021
Format GeoJSON
License No License Provided
Datastore activeTrue
Datastore cache{'CSV': {'4326': '55136dac-26b1-4028-b9f5-7c2344f94153', '2952': 'a5bdf7c5-946b-47ed-9b38-105b3d05514d'}, 'SHP': {'4326': '384b9df0-8ed0-4f58-b963-2958a3f2f2de', '2952': '59cbef24-ebc6-4d14-b445-ca02463fcd94'}, 'GPKG': {'4326': '5432bcad-59c4-4e07-b2c7-72ecd1f02258', '2952': '63945347-543d-4d3a-9cc4-d86aa66fd605'}, 'GEOJSON': {'4326': 'e7fe6133-17d8-4a39-88af-352440dec684'}}
Datastore cache last update1 month ago
Has viewsTrue
Id34e4206d-549e-4957-a0da-093d703a1c62
Is datastore cache fileFalse
Is previewTrue
Package idc7d34d9b-23d2-44fe-8b3b-cd82c8b38978
Position0
Revision id8d1ddc93-7ea7-44f7-8761-597aac3ccd64
Stateactive
Url typedatastore
Extract Job
Is Datastore Cache File? False
Datastore Cache
  1. CSV
  2. SHP
  3. GPKG
  4. GEOJSON
Datastore Cache Last Updated
Datastore resource's ID