Stripping routes of the time based component
I loaded most of the Traficlab information on My DB and I was dismayed at finding the huge number of trips for a given route, sometimes with more than 200 passing by a single stop. I also noticed most of them have a single destination but a different time; what brought me to think they are the actual expected buses during the day, rather than the lines in the sense of paths following the same route. In my app I am showing the lines passing for a stop in the annotation and I cannot of course display 200+ labels that would all but fill the screen. Moreover they would slow the queries in the DB. So I need to strip them in order to have separate lines for separate paths. One idea would be to group them according to the destination, but that would also ditch lines having the same destination but a different starting point and/or intervening stops.
Also I did not yet tackle the real time information, nor the path calculation, waiting first to fix the loading, and so I do not know if they are based on the huge table entries, and if I delete the lines I could have dangling lines attached to arriving buses.