Overspeed audit
Checking GPS pings from speed_temp against OSM limits via sp_check_overspeed.
Run settings
Vehicles (sys_service_id)
Comma, space or newline separated.
Only pings above (mph)
Matches
gps_speed > 31
in the source query.
Row cap for a trial run
Start with 500 to time one batch before running the lot.
Skip pings without a GPS fix
Write every checked ping to the CSV, not just alerts
Start run
Download CSV
0
pings read
0
roads matched
0
overspeed alerts
0
no road nearby
0
skipped
Status
idle
Alerts as they land
Latest 50 shown here; the CSV holds all of them.
Vehicle
Time (IST)
Speed
Limit
Over by
Road
Distance
No alerts yet. Start a run to fill this.