DB Delay

Search mask
Routing
Map

Inspiration

The Deutsche Bahn is know for its delays. You can't rely on it arriving on time. We want to help people by predicting the best times of the day to take a train in order to be on time at the choosen destination before the delays are actually known and published by the DB.

What it does

The user can search for a connection between 2 cities on any day of the week. He will then receive a bar chart showcasing the average delays for different hours of the chosen day in minutes.
The user can look at a map of Germany which shows the delays between cities in colors (red, yellow green) depending on how big the average delays of the train are.

How we built it

We used a mysql database to store historic train-delay data. We built the backend with python and flask and the frontend with react native.

Challenges we ran into

Getting the historic data
Build useful datastructures in the backend to filter the train data efficiently and hand over the information to the frontend.
Building a flexible, expandible, and user friendly frontend (especially the map)
No prior knowledge in the React Native Framework

Accomplishments that we're proud of

Good split of team skills into frontend and backend
Building a fully functional app, despite being mid-app-developers
providing helpful information for a possibly, big audience of people: being able to help users arrive at their destination on time and not being late because of common train delays

What we learned

It is important to plan a structure beforehand
Flip charts are awesome
many interesting facts about DB delays like the worst routes, worst times to travel and much more