Municipal Bylaw Infractions with Geospatial Coordinates

Bylaw infraction records include citizen complaints and officer-initiated investigations for issues like sidewalk snow, graffiti, and nuisance properties. The dataset contains columns for complaint type, location, neighbourhood, and status, sourced from the City of Edmonton's open data portal. It was last updated in April 2026.

Use Cases

• Predict complaint type (COMPLAINT) based on NEIGHBOURHOOD and MONTH using classification models.
• Analyze spatial clusters of incidents using LATITUDE and LONGITUDE for hotspot mapping.
• Model the relationship between REPORT_PERIOD/YEAR and COUNT of complaints to forecast seasonal trends.
• Compare complaint STATUS and INITIATED_BY (citizen vs. officer) across different City of Edmonton - Ward Boundaries.
• Assess the distribution of complaints like 'Snow on City sidewalk' or 'Graffiti' across Neighbourhood Boundaries : 2019.

Strengths

• Includes precise geospatial coordinates (LATITUDE, LONGITUDE) and Geometry Point for mapping.
• Contains multiple administrative boundary layers (Ward, School District, Neighbourhood) for spatial joins.
• Data is updated regularly, with a last update date of 2026-04-03.

Limitations

• Sample data and total row count are unavailable, preventing assessment of dataset scale.
• Key metadata like license, author, and exact temporal coverage (time_range) is unknown.
• Contains multiple boundary columns with specific effective dates, which may cause confusion if used for temporal analysis outside their validity.

Provenance

Source

data.edmonton.ca (City of Edmonton open data portal).

Collection Method

Collected from citizen complaint reports and officer-initiated investigations.

Time Range

null

Freshness

Updated in April 2026, indicating recent maintenance.

Geography

City of Edmonton, Alberta, Canada.