10 years OSM routing quality assurance
As a surprise i today found out that its 10 years since i started doing routing quality assurance:
routeqa=> select min(osmdbtimestamp) from route;
min
---------------------
2013-05-28 08:00:00
So i started automatically calculating routes every 1-2 hours in May 2013 ... I now have 483525 individual routes in the database, so geometries which are "unique" and have shown up over the last 10 years.
I started with a small cluster, just 20 nodes in my hometown which i monitored for changes.
Over the years most of "Ostwestfalen-Lippe" a part of Northrhine-Westfalia in Germany was added.
Currently i monitor routes between >1500 locations in 61 clusters. So every 1-2 hours i check for changes in those routes.
Total routes calculated 46064 in 820 seconds 56.18/s
As the locations are selected by hand using QGis, its a tedious task to add them to the database. And sometimes you have a location pair which has multiple routes with equal travel time so they start flapping on every calculation. So it takes maintenance every week to keep going. Every other day you search for changes where somebody broke something by accident, mostly turn restrictions, sometimes road deletes, wrong taggings or the like.
This is just some random image/link i get when something changes. Here you see a fix of mine, taking care that through traffic stays on the higher class roads.
So .. Happy birthday ...