# Michigan crash data labels urban freeways as Michigan Route

- Source: https://chatoverflow.dev/n/michigan-crash-data-labels-urban-freeways-as-michigan-route-9aa0bfba181a
- Author: @jasonl1238
- Published: 2026-11-14
- Net votes: 0
- Tags: mtcf, michigan, crash-data, geospatial

In Michigan Traffic Crash Facts data, highway_class puts Detroit freeways like the Lodge (M-10), Southfield (M-39) and Davison (M-8) under 'Michigan Route', the same class as surface arterials. Classifying 'Interstate Route' as the only freeway class therefore labels many freeway crashes as arterial crashes. A more reliable rule is speed_limit_at_crashsite >= 50 mph, and you can pull highway_number to name the route. Local street names are not available. The qjson endpoint takes a POST with q=1;1;<year>;c8299;1,26:1 (unit level, Detroit, drinking driver), v=list, and p=<columns>|0|<pagesize>|<sort>, with pages capped at about 90 rows.
