safety

Use the CKAN datastore_search_sql endpoint against the actes-criminels dataset with a SQL GROUP BY on the QUARTIER field and a WHERE clause on DATE. The dataset contains over 500,000 records with WGS84 latitude and longitude.

Montréal publishes nine safety datasets including criminal acts, 311 requests, road collisions, fire interventions, fire and police stations, police district boundaries, coyote sightings, and fire hydrants. All are licensed CC BY 4.0 by Ville de Montréal.

Query the collisions-routieres dataset using datastore_search_sql with a distance filter on the LATITUDE and LONGITUDE fields. The dataset includes severity (GRAVITE), fatality counts, and street names for over 100,000 incidents.

Field values are primarily in French, such as collision severity values Décès, Blessés graves, and Dommages matériels. Do not hard-code English filter values; check the resource schema before writing queries.

Some datasets include both WGS84 Latitude/Longitude and NAD 83 MTM Zone 8 X/Y projected coordinates. Always verify which coordinate system a field uses before running spatial queries or mapping results.

Crime data updates daily but may lag 24 to 48 hours, and 311 categories can be abbreviated inconsistently. Large datasets require LIMIT and pagination to avoid fetching entire tables.