Data Dictionary

Column Type Label Description
OCC_DATE text

Date Collision Occurred (time is displayed in UTC format when downloaded as a CSV)

OCC_MONTH text

Month Collision Occurred

OCC_DOW text

Day of Week Collision Occurred

OCC_YEAR text

Year Collision Occurred

OCC_HOUR text

Hour Collision Occurred

DIVISION text

Police Division where Collision Occurred

FATALITIES int4

Number of Person’s Killed associated with the Collision (See definitions)

INJURY_COLLISIONS text

Indicates whether a Collision had an associated Injury (See definitions)

FTR_COLLISIONS text

Indicates whether a Collision was associated to Fail to Remain (See definitions)

PD_COLLISIONS text

Indicates Whether a Collision was associated to Property Damage (See definitions)

HOOD_158 text

Identifier of Neighbourhood

NEIGHBOURHOOD_158 text

Name of Neighbourhood where Collision Occurred

LONG_WGS84 text

Longitude Coordinate (Offset to nearest intersection)

LAT_WGS84 text

Latitude Coordinate (Offset to nearest intersection)

AUTOMOBILE text

Indicates whether a Collision involved a person in an automobile

MOTORCYCLE text

Indicates whether a Collision involved a person in a motorcycle

PASSENGER text

Indicates whether a Collision involved a passenger in a motor vehicle

BICYCLE text

Indicates whether a Collision involved a cyclist

PEDESTRIAN text

Indicates whether a Collision involved a pedestrian

geometry text

Longitude Coordinate (Offset to nearest intersection) & Latitude Coordinate

Additional Information

Field Value
Data last updated August 19, 2022
Metadata last updated March 27, 2025
Created August 19, 2022
Format GeoJSON
License No License Provided
Datastore activeTrue
Datastore cache{'CSV': {'4326': 'cb890861-ed20-4862-bb75-b1f9ec1e58dd', '2952': '3fed26a8-62fa-4c7c-8e76-9bacb6401d16'}, 'SHP': {'4326': 'd55b9b58-cd50-4a48-9f2a-b1ae2198bbc7', '2952': 'ed28938c-3e8c-4984-995a-176e0d76cfca'}, 'GPKG': {'4326': '2b852c7e-e18b-4263-94cb-dc43bf1786c6', '2952': 'dea321e6-a63e-4703-b961-23b29ffdd4d0'}, 'GEOJSON': {'4326': 'a279e21c-9fcf-4a62-9902-b985476051ec'}}
Datastore cache last update1 month ago
Extract jobAirflow - files_to_datastore.py - police-annual-statistical-report-traffic-collisions
Has viewsTrue
Id4ad77de0-a9e0-4725-95d9-dbce6776d6cf
Is previewTrue
Package idec53f7b2-769b-4914-91fe-a37ee27a90b3
Package name or idpolice-annual-statistical-report-traffic-collisions
Position0
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - police-annual-statistical-report-traffic-collisions
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. SHP
  3. GPKG
  4. GEOJSON
Datastore Cache Last Updated
Datastore resource's ID