Zugmonitor - decoding realtime train data for publishing

Video thumbnail (Frame 0) Video thumbnail (Frame 4585) Video thumbnail (Frame 13991) Video thumbnail (Frame 23397) Video thumbnail (Frame 24329) Video thumbnail (Frame 27476) Video thumbnail (Frame 38694) Video thumbnail (Frame 49846) Video thumbnail (Frame 60998) Video thumbnail (Frame 63539) Video thumbnail (Frame 64763) Video thumbnail (Frame 67447)
Video in TIB AV-Portal: Zugmonitor - decoding realtime train data for publishing

Formal Metadata

Zugmonitor - decoding realtime train data for publishing
Title of Series
Part Number
Number of Parts
CC Attribution - ShareAlike 3.0 Germany:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this license.
Release Date

Content Metadata

Subject Area
Millions of passengers use Germany's railway system every month - but which trains are often running late, what are the structural problems? Doing an interactive piece about that complex network is of great worth for both journalism and society. Stefan Plöchinger, editor-in-chief of Süddeutsche Zeitung's online news site, and Lorenz Matzat, co-founder of OpenDataCity, give an overview of the project: idea, process, obstacles, working with data, doing journalism with data and reactions. Pieter Colpaert will talk about Informing commuters in Belgium In 2008 our not-for profit organisation created a simple mobile web-app to look up train schedules, called iRail.be. As no other mobile app existed, this became a huge success, until we had some dispute over copyright in 2010. In 2012 our servers are still up and running, we started a legal structure supporting 30 volunteers, and we are promoting digital creativity using open transport data.
Filter <Stochastik> Trail Information Multiplication sign Electronic mailing list Real-time operating system Mereology Cartesian coordinate system Computer programming Number Word Software Videoconferencing Website Marginal distribution
Sensitivity analysis Transportation theory (mathematics) Code Logistic distribution Multiplication sign Workstation <Musikinstrument> Mereology Computer programming Usability Web 2.0 Triangulation (psychology) Sign (mathematics) Very-high-bit-rate digital subscriber line Different (Kate Ryan album) Monster group Social class Physical system Touchscreen Mapping Cross-platform Software developer Moment (mathematics) Bit Connected space Arithmetic mean Digital photography Process (computing) Website Quicksort Point (geometry) Ocean current Metre Classical physics Computer file Robot Similarity (geometry) Deutscher Filmpreis Element (mathematics) Prototype Causality Internetworking Touch typing User interface Mobile Web Interface (computing) Line (geometry) Cartesian coordinate system Symbol table Subject indexing Spring (hydrology) Computer animation Software Video game
Computer animation Line (geometry) Connected space
Web page Service (economics) Computer animation Link (knot theory) Block (periodic table) Multiplication sign Source code Touch typing Letterpress printing Expert system Connected space
Web page Point (geometry) Android (robot) Service (economics) State of matter Multiplication sign Plotter Letterpress printing Real-time operating system Open set Disk read-and-write head Computer programming Strategy game Touch typing Videoconferencing Software testing Physical system Predictability Electric generator Projective plane Data storage device Sound effect Planning Cartesian coordinate system Data mining Type theory Computer animation Software Integrated development environment Tower Video game Website Right angle
Context awareness Group action Building Presentation of a group Transportation theory (mathematics) Code Decision theory Direction (geometry) Multiplication sign Design by contract Frustration Real-time operating system Open set Coma Berenices Mathematics Different (Kate Ryan album) Core dump Endliche Modelltheorie Area Touchscreen Arm Mapping File format Digitizing Software developer Electronic mailing list 3 (number) Lattice (order) Representational state transfer Data management Googol Internet service provider Self-organization Website Freeware Spacetime Row (database) Point (geometry) Laptop Open source Divisor Observational study Spiral Similarity (geometry) Student's t-test Heat transfer Mass Event horizon Power (physics) Twitter Revision control Latent heat Authorization Data structure Mobile Web Addition Dialect Information Weight Cellular automaton Projective plane Line (geometry) Uniform resource locator Data exchange Software Personal digital assistant Google Maps Statement (computer science) Speech synthesis Game theory Object (grammar) Pressure
Area Uniform resource locator Centralizer and normalizer Computer animation Software Mapping Multiplication sign Projective plane Quicksort Position operator
Latent heat Computer animation Open set Cartesian coordinate system Mereology Power (physics)
Mobile Web Scaling (geometry) Mapping Multiplication sign Workstation <Musikinstrument> Projective plane Sheaf (mathematics) Design by contract Online help Shape (magazine) Mereology Graph coloring Frequency Word Visualization (computer graphics) Internet forum Figurate number
Mobile Web Point (geometry) Area Context awareness Theory of relativity Transportation theory (mathematics) Random walk Multiplication sign Workstation <Musikinstrument> Planning Insertion loss Open set Heat transfer Mereology Field (computer science) Medical imaging Summierbarkeit PRINCE2 Arithmetic progression
there can be we're beginning with so so be FIL marginals to put the question to the audience and how many people and have been traveling here with on thank you for telling with the tomb of the dead and this was his joke originally had and how many of you late on what they read and some of the program is
not that as this is here showcase and thanks for the introduction and we're talking about 20 minutes about the morning talk and we do it in 2 parts Time from more about how we made it and how it was produced and at some on talking about the long list of stuff earlier but he didn't come in the doors of the and the idea that came out last year around this time and the 1st 2 to get the data out of the German Railways Corporation knowledge about them and we 1st thought about doing Freedom of Information Act request and then we came up with the idea to to scrape the website on Dutch about because we we we are quite sure they're not they don't want to give us this information but before I talk about this them to show you the the video how how it's working it's 1 1 minute 30 minutes of 2nd so you get an idea and housing and application which kind of features this got and stuff but it's not working with someone remote you know that we we made some some English words in my thing 1 month after the German and Coast Guard and was featured it and we we had quite a few international requests about so we from the Germans and they wave website we're saying that they give up the information atleast in 5 minutes that's how late trains are going to be and so we we have the software great whose going there every few minutes for every training which is on on the tracks and we get the information that's for example it's 40 minutes later and what what what's the reason for the delay an you can explore this in real time or this in real time in this application or can go back in time and place to play it if you want to offer you I think we got it from October 2011 and you can filters the request for which train number what kind of training tide is fast
over my training for example the ICT which is the fastest train and so can requested for which ranking for our every train station so that that's basically how it works and only the scraper the data we get from the website of thought about looks more or less like this for every training wheels craving we only scraping the long-distance trains sentences that bought 1 thousand day because if you I think Dodge minus about 25 thousand connections every day if you have local trains and as far as which of the in the cities the from the transportation and the difference to the website of thought about Dutch only displaces the next delay they fall that the delays before so you can't do research on the porch abound website about the delays from the day before or even 1 hour ago so we we collect for every station with the ladies and the have so we have a huge dataset now about maybe I so we not solvent connection more or less and it's not the beginning this crater was quite there was not really functioning very well with the website after such a because this is the monster I and she was that looks a little bit like it has been started up before the World Wide Web in the seventies and it's it's changing ideas and stuff but if you're interested in this you can talk to or code about is heavily to talk to someone from the that I US quite from what is eyes and that's what we now have for every training and long-distance train at least and to to get an idea what we have what kind of data we got we 1st make some dive sensitive data of this is I think it was from all this last year we had about 1 month of scraped data at this point of time and you know what you see here is the the causes of delays so how long it in and in average you have to wait if it's for example it's some uh that whether this about this is the cause of the delay it's 60 minutes on about and and so we have an idea what we can do what we can tailor was this state of because this is the 2nd part of what we call data-journalism you have 1st you get data and to get more and more data and then you get an idea what kind of story sign there and how you can tell them now and column and then we say it's I called for me it's like a process of of writing an article but we don't know we're not liking it was with works but was with software designing and application we design interface and that's how we start telling the story and when you write an article for example you have some story talk and you have an introduction you tell you point and you have and and where you come to a conclusion for example you don't have this when you designing data journalism application as the staffing think so you have a beginning that's when people come to the website and that's a 1st impression of you of your data journalism application and the best the best you know things would be understand in without any explanation they know what to do with this application so it's a lot about how to design the interface the user interface and of course the usability how to how people can interact with the file as a set before I think there are a lot of similarities to writing an article as story but if you're not using letters from To prove presented on screen but you use symbols you use UI elements and stuff and you see how we are designer who started to think about how to presented is how to design this map what can people can do to interact with the data from cotton ideas how people can interact and I I think the secret of a good application is to scroll way at least 70 or 80 per cent of the features you think that the application should have because we add much more idea what you can do is data for example here we so we can integrate in some realization how the delays on tell developing over time and we had a kind of certain budget and current means that we have that kind of time and you have to swallow where things because they don't have the money to develop them and many are very confusing for the end user at least because if you deep into the development of an application you're very into the subject and you know everything in every of the application of our not allowed to to come to use it but the best that is to say take someone you've never seen it before the city moral before the computer and let him users and just write on a piece of paper what he or she is saying about it and you mostly known they don't understand a lot of things not in this way you authorship in the end we can we came up with this small this is this line which was in the and implemented we had a lot of problems because of some of the taught you wanted to evidence about the HTML 5 which means we will of the I and because of that that I had and that means problems with
Internet Explorer to which many people still using concept to Internet Explorer 9 it's a problem about JavaScript actually it didn't work it's a Dutch tightening and many workplaces here that because there is still using E 67 so I'm happy 2 years so so there will be no Internet Explorer 807 anymore and then it's much more easier to develop cross problem applications and cross-platform mobile and stuff and mobile means you have to think about touch interfaces to must work on a desktop PC on a touch was using was touched so it means for example on makes a bot too small and can you use a swipe gestures and stuff OK that was designed in the end when we had a prototype for quite some time and some which looks looked I think and those 3 days before we launch class this and then we have to rework the um the map completely but it was when when we had something where in winter was sort the 1st time this small and like like little ants crawling over the map that was the kind of a huge moment for us because we 1st saw now the application came together and how you can tell a story about it because now I think we see now about 200 what 150 trains at once on this map and you get an idea of the logistics of talked about what they're doing every day and I think it's quite interesting I think and they want a lot of money for this weather doing quite a good job and in the end we came to use this kind of application which now runs for I think 6 6 weeks and for the the in the in the sense that it may be the last technical thing about it what what is and Paul and what has been important for us was that I we knew when we will look when we launched this application that a lot of people will come at once so that means we have a meter system which can deliver the data to display on the on the screen of every user that had to be delivered very fast and you have to optimize the data you have to reduce it and we were able to presented the data you can more or less without many some hesitation will be can just scores for this time and some so is this same I think just as the to what it's about experience sort indexes data how fast you can deliver the data to the user before that was text or maybe a photograph or not men we DO and now we have to to deliver data as a part of journalism and that the thing for me is that's really interesting thing and where's the fun in this to produce software development as a kind of journalism so I gave over now to I'm Stephane give us some idea about the process that you pay him what what why did we do this and will Germany's this newspaper and well we're not actually in the software programming business so we were quite happy when the July 2011 we met at that speculation actually also conference in Hamburg and while I was always interesting stuff Lawrence was sitting in system was doing and we were just chatting what we could do together and you brought up the idea of there's this thing with triangulates everybody's interested in entering ladies in Germany and why don't we scraped Deutsche bond website and that well and my very own personal situation is and logistics and trains and cars motorways and so and really interested in this and as the person and not as a journalist and well there were 2 things combined this moment and % Lawrence well why not try this thing out and it took about 9 months from then on here just to give you a bit of course the idea to to visualize the train data life on the Web is not new something like was trained for example was an inspiration for us we ate some different vantage which is the consumer of is of the magazine nation foundations testing stuff they made of feature last year in spring freelance afterwards it's the same thing as in this great to website for 1 month the boat and but it is more or less classical print products article about it was with realizations like this and then in last autumn a single guy and start started to thin out which is about basically doing the same thing as prominent In and 1 when I saw this and I was getting and the idea that there could be story and a alike data journalism and I always think there's gonna story and use now you see all how many pieces with we did with the data and that you guys great for us and it was about a dozen 2 dozen stories and we could extract of this data that's never been mined for while there some interesting things like that of the high-speed train network in Germany is the part of the network and which has the most significant delays as large a value that nobody else and we could scrape can we can we could be actually there was a so the red lines this is Germany's high-speed railways and and we look at the
data and this was quite complicated to look at the data in this way when we get down OK this is this line on the delay train connection in Germany here this is between all the big cities this is a good story actually and we want to what to write that this came after world half a year after you really started to that of a few scraper really work so this was in not that common for us to say OK we're going invest a lot of money and and
you guys and you do the scraping and we don't
know which so will come and we didn't know what to look March of this year we so it would come out the use of escaping in October and in March we began diving into the data and the really various statistical ways and then I have to think about all the things that and University of statistics and when are thing significant and and how many connections have to be counted until something of significant data and so on and in the end we we have some very good service well there's been the highway In the high-speed train links are problem we get the story that such a bond is telling customers the full truth about today's we found some very serious blocks in the in the data and the like touch upon says it's when the train late 7 minutes they say it's 5 minutes because they want people to arrive at the train station in time so they don't have to wait and things like that never heard that before and this were some clues we we get out of the data and our readers really appreciated and and we we try to get the the print edition of the day in March was published so that we made up of all to pages broadsheet panorama and in the paper with 4 big pieces amount would be found out and was also very good cooperation between the online content and that of the online department and the newspaper would is very common in Germany these days well it was really good cooperation because our print virtually bonds and expert and confronted with such a bond with the the findings we made and we made you actually some some various sources of yeah and we published data and this is in Google Fusion Tables and everybody
has access to the state that we we were working with 1 and
can do some sorting himself we made an API and you didn't you didn't want to publish all the data as an API and now we're experiencing that it doesn't stop with stories in our coverage of and but and some people out there are working with the API and doing a an iPhone and Android app some of the guys this is 1 guys trying to make a prognosis of latest this training gonna be and based on what we got here and they all reading this stuff that is in the API was a complicated and press the interesting thing was that we we we really learned about a lot about data generation we didn't do that before when we were quite happy to have you on board and as we wouldn't have been able to let alone the it's it's really a big a newspaper is trying to get things right in the digital age of and it's the 1st project of course now we're planning the 2nd 1 and the 3rd 1 and we're trying to do it not because I think and as a newspaper we have to be able to do these things in the world and to have all the knowledge from in our house on for me as editor-in-chief it's the best 1 of the best things of this is that everybody situational really understands that there is stories in data mining and data journalism and you can get the head of the market by doing such stories and the only classical stories but in the well I want to say something about the Open Data has effect on this but I would say this is the same the open because we the fossils the 1st time I think not many people this is before kind of real-time data journalism and means we have to be providing all the data we have scraping Wallace in real time to other people using the API the application programming interfaces um and we are not allowed because we're scraping the data from the bomb plot about website which I think it's a public body in its own by the people in Germany so obligated to do it themselves they don't do it and so we did that for them but we have not the right to say you can we use it for commercial proposed think the be problematic so we said you can you reuse it but only for all kind of research for for testing and not to to sail for example a mobile applications but but what we're hoping is that we give inspiration to go to bond to open up their are and what to give to provide an because think some it's a mutual portunity for them to be transparent and I think we would see great services built on this API and is talk before the 1 application for example they give a prediction about what you delay would be probably and we have half of the year of delay so we can say if you're traveling on Friday afternoon you probably going to be late 7 minutes on this particularly in the training so and a lot of work while and we we had a more ideas I said before we reach we killed a lot of features to make it somewhat complicated here I think we have signals that we shouldn't delayed the animal cells also thank you for listening so traveling with us and maybe we have time for 2 questions if somebody interested to put some up and hold so for much but when I want to people come to people being it will be thank you for presenting this very interesting project and when it is my and I wanna know what just like your again with this tool is not know that you are running this on the URL you just waiting what happens or do you have any this is also interesting for newspaper your programming tool that because program tool and you have to maintain it yeah we we're we are planning to maintain it and perhaps and storage bond is rethinking its policy concerning and giving data to the public and we will that tools something like that and you constantly developed that that's that's the point and we get no real budget for that but that's another subject what kind of expected to get from touch upon what will we asked them before we publish the articles and what they can tell us about what we find out and the well they answer the questions that's all that there was no problem at all and that this but it in no problem in all the uh the only contact to the bond was before the publication of the article and after the system thing I think they they got that there are guys doing the scripting uh and well I think as the following a transparency policy as a company it wouldn't have written there is to keep some In this strategy to to balance US of some type they didn't do that and they didn't react badly so we didn't expect it it was kind of experiment and did you release the spread of you it OK I'd be interested because some the software that touch plan runs runs worldwide pretty much as far as I know puzzles in exactly 1 soul I guess a bunch of people usually use you'd like to hack all of them or something like that so we went the rest of his life environment just 1 last year I saw the saw quite high is that we only what the did you get from you put colleagues in regard that where there is a return on invested at the end of the original question was the thing and print colleagues don't think about that and and no they were quite amazed because this approach to and never did anything like that and that they were getting digital Jonassen could be In the end this is something that everybody gets to know in our big tower induced finicky and they they looked at and it's fun playing around with this saying there a panorama page and paper so really everybody get something out of it and they get a clue that there could be more than text and video and all so some you
waiting for you OK yeah but did you also 1st for the data note that really did what he easier to ask for forgiveness and but I yeah and I'm going to take over thank you and I'm thank you and 5 uh P 3 typical light from Belgium and I see a lot of similarities between them and the germans and uh the German issues and the Belgian issues we also have is really company and there also that belied to what's what's Open Data supplied that text so we started spiral irony is a not-for-profit organization Y is slides from OK so I was not for profit organization that focuses on on transports data in Belgium so am my um I started recently like 2 months ago started the Open Knowledge Fundación Belgium and you're trying to to still open later this year and I have started I'm not going to do to make a list here but the best real-time digital signage company in the world so if you want to buy screens come to me and also also you everything and we everything so that that we do right now it starts with our 1st in that started 2 years ago and it's called spiral what happened well and in 2008 we had a mobile website just a simple scraper just like the German guys from 22 and and yeah we we send a letter and I substituted essence and of European and yet the national Rally Company of Belgium stating that we're we just did this it's easy to access on iPhone and it's it's something they like because there was no such thing as a model outside or let's say and act or some kind and and and 2 years later we got an answer on this this letter in the latter was from the most from the biggest at Fort lawyer company in Belgium stating that we had immediately to stop with everything that we were doing that like a site 30 visitors a day on which which which easily access that may have made it possible to access the weight data on your mobile phone and yeah just published this cease-and-desist letter online and this is what happens even both the the Dutch people and the the french people in Belgium uh published about this and and the biggest newspapers that I has to stop so let's get it let's give some context because Belgium yeah we're like these neighbors from in there somewhere um but it is very we're pretty much divided a little with the busses we have we have flounders we have Brussels and we have 1 and each of these 3 regions have their own company plans this is simple I think and Florida that the readily company it's even simpler we just have 1 Railway Company this is a problem 2 2 0 0 it some the old these uh these differences and these different organizations have to listen to different governments that there may be a little country but we have 6 governments haven't many many um yet there was a time that that uh we we we didn't have a government ordered did they told people that in in in foreign countries but did this wasn't true we still had too much government so these 4 companies listen to 2 different governments and each time you want to do to make the Open Data statement you will have to go to different uh different governments so we went to the Flemish Government and no at this point there are already publishing or have a statement for Open Data insight directives stuff the Brussels Government has already published open data no people and governments don't even bother that the federal government it's also working towards Open Data right but we have we also have some pressure from Europe and in 2005 we had to splits the Belgian Railway Company because we really have wanted this was a good point that that because we only had 1 uh 1 organization to go to to see to to to have a meeting and then do attempted to convince to do Open Data but now we have a the d the Railway maintain recalled and from well then we have d dead the core organization that works with the trains that that tries to change this is a the European decision everyone in Europe you should do this and then we have a 3rd company and D. holding and and these are talking to to both of these or should be talking to both of of these companies and with the government so these auditory see those of these 3 companies and we talked to all of these 3 companies this takes a lot of time and we talked to to these guys and the open data this is also the yeah let let's let's do this because then we have cells the 2nd 1 says again let's you break brainstorm sessions and we've been doing a digital creativity in in and bring some sessions the problem these guys don't have data that are like Open Data and that guy over there and then that's looking like this they says that although they crisis it's from him and no 1 should even bother asking for data not even this guy did this is a big balls of the day he doesn't receive data from that guy so it's not a problem of open they that's even a problem of internal structure the I row we started then an organization in a living lab and that's that's a cool work just for um just for something that takes frustration from people that uses the the idea for-profit organization puts it into ideas and maybe projects commodities produced can can fail we we had some some projects that were really bad and people put the put sometime and but are whatever DTDs than these went back to frustration that we we had some good projects which uh which is actually some some spinoffs were created from that so after 4 years of frustration we're still online had this is a big point because we we had a lot of lawyers asking asking for explanations
and then a lot of politicians do we just for for um and for explanation and these were all in my really examinations and not the best students our wasn't the best students in in the world so have a lot of examinations and I was doing these projects and i got sued in all this stuff happened and I had to to to to talk to politicians do these companies and uh conclusion I did some extra years that in we had this aren't you have 30 active volunteers we have told them in joules maintained datasets on data the title of the EU which is a RESTful API which publishes dynamic data and we have 4 or spin-off project so the goal of the you of you not for profit organization right now is organizing events during community building and then we have some some events like that like wrote Summer of Code which you can um which which uh goddess students to work on these 12 data sets that that we were talking about the stall datasets are about busses are about trains and and so on and that said and done that we we area of maintaining and financing the data that I Robot EU RESTful API uh we incubating start-ups factor tool this is due to the company and I was talking about before um that this digital signage these uses data from inside the Ireland the 1st sight is a dating site it's a it's a dating site for a for a train users so and so you can go to to your your own train Brussels you see you see a pretty lady or a a handsome guy and and and when you get out of and and you've been talking or not when you get out of you you just take your laptop using our goal to 1st sight or outside beautiful later a handsome guy with a with the the brown jacket today red scarf and maybe you'll get back in touch after while we opened this is not a start-up which gathers data Open Data at low inside and and a RESTful API 204 parties again that that this is is is a game again that this a game in which you have to conquer in which have conquered districts from a city by just doing Foursquare checkins and know we're of we're taking this projects to the next level by by adding mobile mobile or transport information to it and last but not least fear of copyright management for free libre and open source software and we have a lot of volunteer projects we all doing this open source and you can go to get help build comes less spiral and you will see all the software projects so that was the B of thanks few art any questions the meanwhile I learned that ties means husky in English that right still has only In addition to your arm great entertainment presentation of there was a similar case in in Berlin some active apart developed in that for the mentally you have been in trying for millions it is called the adapt and she got problems with the pollution of some public transfer authority as well therefore beats him to use to scrape the data are and here it was quite funny because there is so stupid to full beaten initiatives like that maybe it's interesting because it's a simple yes indeed be reworked together also with the with all the other people who who do Open Data Open transport data being non official people like in the Netherlands you also have something similar like open the and that's called that's 1 guy who just opened up the entire country it is amazing uh and again you know you also have a lot of different projects thanks to the other questions thank you thank you OK condensed tumultuous which the MIR that considerable global public transport data version you know as some of Racine possibly see now 2 case studies 1 forward Germany Dutch bond and 1 for Belgium and is going to give you a broad overview of what kind of public transport data is available in the whole world because you know that they're more places about they have public transport and there was this 1 company that is supposed to get all the data of course Google and and I don't know most of us don't know that probably but if you go to Google Maps in some countries that supports public transit properly you cannot only see like public transport lines on the map but who knows the routine like in Germany can rooting from a to B with the car and can walk and but in New York in many other places in the world actually these places you can also use and public transport rooting on Google maps directly on the map and perfect because of why why why is that and they get the data from the public transport providers and and the 1st step is to that it was actually to define hallmark of the general trend that fits this occasion it used to be called which under the specification change that to be more general ideas and and this is now and this is the format that encompasses the locations of stops and when the busses coming where is it going you all all the times and in between and and so public transit can publish it can create this dataset in this format it into google and then there be a users can users on Google maps and in the area of the public transport provide a really neat idea and works in many places and the space is perfect but it doesn't work in Germany well why is that because the role of the Germans we don't like Google somehow I mean you don't like speech you really don't like them to give them data and the 2nd record the same problem here the problem also is that it's going to get the data that make a contract with the public transport provider about this data and the data is not necessarily available for all and this is psychologically of estate exchange G festival transferred specification and this site collects all datasets in in this format that is publicly available so if you're a developer check the size of objective as data exchange . com and then you can download a massive amounts of public transport data unfortunately not from Germany because we don't like a really like power open data in the public transport sector unfortunately but but were many other places like it so we have seen here in the US is full of which is the every major city publishes data about and public transport and in Germany we are lucky if we get the like the raw what's on the maps and but the data is not available there so um how
do I come to this approach to to to the realization of this so much data as well as in 2009 I solve map you mental is a project in the UK and rebate can say OK this is the by the beam pipe postcode and how can I think about how much time does it take me from which area to get to the central location for example if you will arrive at the center of the stopped at 9 in the morning and you can make travel from around all the highlighted area really nice project and uh all does not only work from London as seen here but also the whole UK so what I actually had just leave brilliant idea here as a solid the monitor and I wanna take this data and is trying to make something like OK I'm in Berlin and and where can I go in like 5 hours can I reach interesting yes of course but can arrange also Hambrick yes of course we can reach sort of maybe so that you can see how careful slider and now and from this position in whole Germany that that's the next thing I think I'm going to try out the problem is that because of the relative maybe the data is available in the DAPI the to the people talk about but what I did is I scraped the data for Berlin and if it if I had network you have actually show you how it works and what is called magnificent and you can like put your dot in the middle of Berlin and moved around it shows you how much time it takes to get around Berlin the public transport it was lighter and their lower right corner you can say OK 15 minutes 20 minutes and it shows you immediately how far you can go in that time so what is it useful for all I I did not only for for burden but also
for some francisco Washington we oracles Angeles
Chicago or Miami and basically a lot of other
cities and why am I just need to know because school I just wrote a 1 from problem and the data is available medicine to put more data into the problem and it just works and so this is like the power of open data and also open specifications that you just have to write the application once and run it with data from anywhere and and yeah I I'm I'm really happy that it worked so far but as you can see and the US is always presented and and Europe and you know we something London some parts of Spain France and Italy and said but Germany with the Berlin the but also I scraped myself there's no open data for that anyway so what do do
with that and that I made a printed map that I actually followed like printing the nice maps we can just hang it in your home and see again I have to go to force emotional support and how much time will take me and then I can see all the colors green OK that might mean 20 minutes or something and yet Iike you want to sell these maps and some problem because of the data size greater than of the States sectional great but under some weird contract from the BDG and the IocaI canceled this this is really a problem for me and I am also thought about here this is
also a nice project I actually want you don't need to show them the 2 can do not and this is from the Netherlands and they have like 1 to the training company for everything and also want ticket and here this is a nice visualization that shows and them wholeheartedly also go but it doesn't and it shows you by deforming the Netherlands actually so that the metal under section of that's the shape help you to that but there is actually 2 transforms to form a circle so that you can see that it's also represents that I no 20 minutes or something and it grows and you can see immediately how far you can go actually do the same thing for Berlin and unfortunately it doesn't more for the shape of word and but you can see in Figure on stations and shows you on a radial and this scale basically um Hall Forum how fast you can make it to other stations so for example if you click on something like frequency or parts them everything moves so far out because it's so far away but if you if you click on fresh US everything moves closer to the center because from 3 shows can get grits anywhere really fast so it's also nice for mobility
planning the support of them actually currently during for Brandenburg for a planning company there and they they have like the the use the random walk is really in a bad place because everybody's moving away from the forward and and the mobility situations that really bad so this is basically the situation if you're at 7 pm and 7 in the evening and you want to get from Prince what somewhere else and all the red parts is our stations you can usually get to but at 7 PM and the best of 7 in the evening can only get like to 2 other stations basically in this image there some more down there but it is so you can have a nice relation and that is used in my brain workers has a really bad mobility planning and that is something to be done about that so in the lobby of the work for rest these images that makes it easier to understand how but the situation is or how good the solutions and and my my my and I'm thinking about doing start of the actually uses the public transport data to bring that to more fields because publisher for data is actually and not only for going to try to be but also can be used in many other contexts for example apartment search where can I live so that I only need to 20 minutes to work and 30 minutes to my girlfriend so know where this is actually a really complex and varied but it can be done with public transportation because show me the partners that are available in this area and issue because it's not in there because it's like 3 commodity kilometers away but it's maybe just 5 minutes away so at time is really more important in this context and public transport data can convey that yeah so my marginal 15 years ago a lot of undiscovered possibilities of hope I've shown you so some things you haven't seen before and the best that the sum of the 1 that someone else deal with data that someone else has opened and I hope that we see more open data especially in Germany and just 2 2 days ago I was more active then from the Green Party in the BGG interview review also there but there weren't so happy about public open transfer data and come down on them and they may be removed to get better at some point uh but of this total loss of what we were doing in Berlin Germany and that we have to do for that but air I'm still very hopeful that to receive some and good progress there in the future alright thank you uh the the we get the use of the most