Edmonton Intersection Safety Device Tickets by Speed Range and Month

Monthly traffic enforcement data from Edmonton's Intersection Safety Devices includes tickets issued for specific speed violations and red light infractions. The dataset, hosted by data.edmonton.ca, provides geospatial coordinates and administrative boundaries for each device location. Columns such as '1-5 Over Speed Limit' and 'Total Red Light Tickets' allow for granular analysis of traffic violations by location and time.

Use Cases

• Predict high-violation intersections using `Longitude`, `Latitude`, and historical `Total Speeding Tickets` (from 25+ available columns).
• Analyze seasonal trends in red-light running by aggregating `Total Red Light Tickets` by `Month End Date`.
• Correlate enforcement outcomes with jurisdictional boundaries using `City of Edmonton - Ward Boundaries` and `approximate_neighbourhood_name`.
• Model the distribution of speeding severity by analyzing ticket counts across columns like `1-5 Over Speed Limit` and `21-50 Over Speed Limit`.

Strengths

• Contains specific ticket counts broken into 6 distinct speed violation ranges (e.g., '1-5 Over Speed Limit', '51+ Over Speed Limit').
• Includes multiple geospatial reference columns for location analysis, such as `Longitude`, `Latitude`, and ward boundaries.
• Data is structured by `Month End Date`, enabling time-series analysis of enforcement trends.

Limitations

• Row count is unknown, which may limit suitability assessment for large-scale modeling.
• Description metadata is limited; actual data quality and completeness require manual inspection after download.
• The dataset may reflect geographic and temporal bias inherent to data collected from a single city's enforcement devices.

Provenance

Source

data.edmonton.ca

Collection Method

Likely collected automatically from municipal Intersection Safety Devices (e.g., red-light/speed cameras).

Freshness

Last updated 2026-05-25 08:13:03; freshness should be verified.

Geography

City of Edmonton, Alberta, Canada, as suggested by ward and neighbourhood boundary columns.