 Wie, wenn man das so sagen möchte, warum das ein bisschen schwierig ist, das so genau zu sagen. Why is it so difficult? That's a little bit hard to say. We have to first describe what exactly is code for Germany. So we're actually gathering knowledge all across Germany. Usually you might have access to one city and we want to distribute to everyone. We want to network everyone into a big family, into here. It's also hard to say, we were doing it because we're really a distributed whole separate communities. But let's describe a little bit who exactly is doing what. And when we say we're working on something, we don't actually mean work on one thing, but we're working on different separate things. So we have all these different projects. And of course this is shown on the slide so you can also watch while you're listening to us. What actually do we want to code? There's really a lot of tech teams involved. There's a lot of tech companies or tech clubs. And they're saying we want to do XYZ. And we want to have a good business model. We want to ask what is actually, what can actually help people? We are putting things into practice. We are looking at data from open street maps or open other sources. It's a question of how you actually open it and what data format. So it's not just PDFs or one other thing, but lots of things. And of course the question of how do you exchange between and among all these organizations and all these people. We have a really detailed world. And there's a question of what is the government or what are the different organizations actually transmitting for the data. And therefore we are really excited about digitalizing everything. It's really a problem when one person said, this is my product, this is my app, this is my startup. And then there's the question, yeah, it's cool, we have this application and we have a different application and then another application, of course, maybe on a different device. It's a very fancy application, very detailed for one example, but what is actually behind it. But what actually can my super app really do in the background? There are so many data silos, which means that we have this whole application. And then this application gathers a lot of data. And there are lots of people that want innovation really fast, as fast as possible. But there's a question, what is behind all of this? There's lots of people that make hackathons. There's creative people gathering their innovation, innovating and imagining things. Or maybe we need startups that really fast and agile develop all of these digital products. Or we have on the business side, we have the economy, we have business doing their innovation. But as for Germany, it's a little bit different. Since 2014, we've been developing. Wir machen das in unserer Freizeit und dabei haben wir eine ganze Menge gelernt. Wenn ich jetzt so sage, wir machen das jetzt schon seit Jahren. Bitte versteht das nicht falsch. Wir lieben das nämlich zu hacken oder zu cohen oder hackathons. Sonst wirst uns ja eigentlich gar nicht geben. Wir lieben das nämlich zu hacken oder zu cohen oder hackathons. Was wollt ihr eigentlich, wenn ihr sagt, ihr wollt Innovation hackathons? So, we love to code and we are wondering what is innovation. Hackathons can be super fast and really is a super amount of creativity. They can get many people together and work on topics that may just fade into the background normally. You can build great prototypes and see how things look and hackathons can be a lot of fun, of course. They can spread knowledge and maybe take one or two days and learn from each other and have fun, of course. And one thing should not be forgotten with all this hackathons cannot be sustainable. And that is the interesting question. How can you reach sustainability with digitalization? And that on the one hand means something like ecological sustainability, so kind of software sustainability. Applications that look nice but aren't quite finished prototypes and many, many hours of work on a voluntary basis have been put in. If that is the situation, the question is how can you avoid these kinds of data silos and you have to think a bit further for that and ask yourself what infrastructure is actually behind this. How can the data that is produced at the end can be reused? And that is why it's important for us to have open data, because many applications don't actually have such a large effect. But if the data that has been used for them is made public. For example, I can enter opening times for my shop around the corner into an app. Then maybe the app will store that in its own database, which is all nice and dandy. But if half a year later the app is not going to be used anymore, if the project dies for some reason, people break up for some reason, then the data I've entered have all gone. But what can happen is if I link this to OpenStreetMap, an existing large project and can take these data for all other kinds of applications, that is the kind of aim that we have. So, that's why we say, hey, open data, not the kind of open data that we produce as a volunteer civil society organization, but also the one, the data that is joined through the administrations from administrations or from authorities. Don't just put them into small scale projects, but open the data that you receive so that you, but all the others can make use of it. We want free software because only free software can be developed further. I don't have to start you on security aspects. It is necessary that as many people as possible can look into the software. But to continue developing and say, hey, this is an element that will suit this project nicely and also have open interfaces, of course, so that people can work together. And what about licenses? There's no use if I have a certain licensed file format that I can't use in the future. And then the last item, open government, so to have structures that we as citizens can easily look into government processes. That is the problem. What you see here, these are data, lots of data. I think it's nature parks in the city of Wuppertal and nature reserves. And if we say we would like to access this data and use it, this kind of data, of course, is much too abstract. And that gets us to the question, who puts this into a nice representation? Who can work the state into something nice? This is an example. This is code for America. They have started a bit before us and they thought, how can we make applications from citizens, for citizens that can actually be of use so that they can be easily used, that they're accessible to many, without barriers. And how can we make them sensible? And we thought, okay, this is 2020. Everyone's talking about the climate and the environment. So let's see if we can bring these two issues together. So on the one hand, open data, open administration, open government or the other sustainability, how we can get this together. And for that, we were wondering, okay, we can do this on several levels. We can think about individual behavior, how that can be influenced, all these kinds of apps that we as individual people use to somehow get better or be better. And one thing we came up with is the drinking water app. A bit older, but we want to update it. Then we thought climate watch. In order to get involved at the political level, you have to know what's going on. And that you can see if you use open data and visualize it. And there is a project for that to climate watch. And also the utopia, the ideal target is that you don't have this individual data silos with these small-scale parts where everyone wants to just realize their own business model, but to say we want overreaching platforms. So, let's look at this in detail. What, for example, is this drinking water app? This is what we're talking about. It asks, what is it by drinking water? As I said, this is a bit older, but it works. This is a visualization for drinking water data. As it comes out of the tap, many people go to the supermarket and buy water in bottles. Not necessarily because it tastes better to them, but because I think it may be more healthy or better in some way. But the fact is, in Germany, drinking water is one of the best tested goods for food consumption. Not perhaps in the house, but there are approaches for that as well. But the actual supply to the house. And how can, then can you watch what is in the drinking water and people in certain cities such as Berlin and Leipzig and others thought about how to visualize the minerals that are found in their individual drinking water supply. Is it worth going to the shops and buying bottled water? And this bottled water, of course, has to be transported to the shop and to me first. And that brought about this app that visualizes this. But actually we wanted to go further now. And Leipzig is working hard on this. We want to move forward with the process to have this data. This data has to be published, because that's how it is supposed to be set up. But it's often published as PDF documents. And as we all know, PDF documents are not at all suited to have any structured analysis and get the data. So what would be much better would be something like comma separated values. So individual Numbers, separated by commas, that you could then read into other programs, interfaces, whatever. And exactly this interface is an item that we're working on. We want to ask what are the current measurements in the drinking water through various connected platforms such as freedom of information platforms und currently surely health authorities, local health authorities, have a bit more urgent things to do rather than looking at our drinking water. So we kind of push this back a little. And what you want to see at the end is a database that you can use easily to query values, compare different cities and get an overall picture in Germany about the drinking water quality. And see how can you actually through open data and how getting the data and linking the data together can change the behavior of individuals and improve things for the environment. So simply because people can inform themselves. So if you're interested in that, as I said, Leipzig is working on this actively, but other places are doing it too. Germany is, this is kind of our favorite community project in Germany, because it's such a tangible thing and looks nice. But you are still invited to join. And another thing that we have is climate watch. And this is something that the City of Münster came up with, where we asked, hey, we have all these different active groups that need data and there is data in the cities. And to then see how you can get this together data and politically active groups. And various other cities have now got involved, but everyone can get involved really, just as it was with the drinking water app. We simply, you simply need the various files with its value. And you write to, say, Münster at code4.de. And you can then ask, how can you get the data or say, I want to use this data for something. And you can then get involved in climate watch. And the question here is, if you are in the political arena, what can you do? And how can you use this data? And another issue, of course, is cycling. And, of course, there have been cycling referenda in cities. This interpreter is active in the cycling referendum in the city of Bielefeld. And Bielefeld is thinking, Bielefeld, who has just joined, of course, the founding meeting, unfortunately, unfortunately had to be cancelled. And they have, but they have been putting the work in and they are working on questions of what you can do with cycling data and put this data into a format that can be used in other places. Of course, again, you can email Bielefeld at code4.de and get involved. And also, did you transit? I don't think I have to talk on this a lot. Because you may all have seen the talk in the last Congress. Hacking the transport turnaround. The people from Olm have shown how you can do this all, make this all a bit more attractive. The question of getting from A to B. I hope that everyone that hasn't watched the talk has now got this QR code and scanned it. And you can search for it on media.csc.de as well. But the digital transit thought came from Finland, actually. And the question was, how can we create a single platform that can use data from all kinds of sources? And often it's, the question is, oh, this big. You look at the big cities, but actually digital transit is quite active. It's developed in a very small city, near Stuttgart, which is called Hamburg. And people there are trying to get this process forward and see how you can get this all updated to the latest Java version, for example. And they've managed to do this. And now you can see how different things can be connected, like train data and various private options of coming from A to B. Merchants that are making these trips anyway. How can you link these up anyway? So that's a thing to look at. If you look at the way these individuals work, you have this small scale action where open data, public data, can help. There's this next level, the political systems. And then we have these issues where you can say, okay, the aim would be to have every administration gain their expertise within their administrative authorities und have them develop these things themselves and have them show these things to volunteers and then have groups such as in Hamburg, Stuttgart, where people had this great problem. And when you then realize that maybe there's some money lying around, you can run a test and maybe improve the city climate that way. Because by getting data together and have open interfaces and then see how this is put together, everyone that's been working with data in that area knows. The problems are there all the time. The same bus stop has been entered five times in different ways via data, maybe longitude and latitude have been exchanged. So, when I say I'd like open data, it sounds very easy, but there's a lot of problems behind that in the detail. And then we have this very new thing. Localworks.de. So here on this website, we are asking people to actually participate together. In this time of Corona, it makes sense to participate online here. It doesn't matter if we know you already. If you're participating from far away, you can still go on the website. And here on this website, we're showing the different programs we're doing. We're doing something with open street maps. And for different cities, we can do the exact same thing that we've done here in this example. Here we see on the screenshot, we see exactly what we've done in Bonn so far. Bonn actually supports us with giving us different types of information. Here's access to the databases. And what's really amazing is they have no closed data. So they have all of it actually open. The data is always there, even though there's the usual hindrances that they don't have time or whatever. In this case, they're actually making it all open. So there's still a question of who is doing this and who is it for. Here's a little overview of who this could be for. There's environmental data. So, for instance, drinking water, quality, traffic data, the price for rent in a certain city. This can be a catastrophe nowadays. We all know how high the price of rent can be. But it would be nice if it actually is open and then everyone knows this. And then you know exactly, okay, how much could I pay? How much should I pay? We have the examples there. What have we learned so far? We have some, the time we've already been developing this, we have some ideas already. We see how important this is and we're searching for a better world. And we're hoping that the digitalization process can help us make it so. We're here on Twitter. And we have to make a summary here at the end. The... The... The... The... The... The... So, when you have an app and it's just superficial, it doesn't actually bring anything. You need to have the data that's behind it. Und there's a question, okay, how good is the data actually? For a problem analysis, what is the goal that we're trying to reach here? So, when a certain government or location actually has data, when we want to develop an app for it, we need the access to the data behind it. We had the example already of Finland, what they're doing there. It would be great if they have co-operations and then people can work together. So, we have to make a summary here. We have to make a summary here. It would be great if they have co-operations and then people can work together. We have lots of hackathons, but it's... There can be 100.000 people working on the same problem in a different way. And we want to increase the chances that something good comes out of it. And then we have to ask ourselves, what do we want to come out of it? Do we want to bring further digitalization into the government? Then we have to look at who is connected and who is meeting this data. And then we have to look at the different groups that could use the data and say, how could we actually support the groups that are doing good in the world with the data? That means that all of this digitalization process and connecting the different open data is not something for a hackathon for a weekend, but it's more like a marathon. It has to be a continuous process. And we need a lot of things for this to work. So, we're looking at the financial support, how this should work. So, in a lot of cases, we're looking at something that's a shorter time period for a couple of weeks or maybe just a couple of days. But the problem to find funding for this is that there's a lot of funding for new things, but for this continuous process that's ongoing, it's harder to find. So, to connect different clubs, maybe there could be funding there. And also, we want to support free and open software. And then at least it's open and going in this direction. So, that was a little bit of a summary of what we're trying to do here. So, we're trying to find funding for this summery, what we're trying to do here. We hope that we see everything, we said everything that I wanted to say correctly here. And we're looking for support for these projects. And of course, we hope to influence the politics, which is very important for open data. This is all the things that we do. Hopefully this is interesting. We have a handbook available. It's about crisis, resilience in the government. And of course, it's very timely in this time of the coronavirus crisis. It's a huge document and it contains a lot of information about all of the organizations that are involved. And of course, you have lots of links of the open data available there. So, this is the end of the talk. You're invited, please come and take a look at us. You can reach us at code4.de. It should be available in about two weeks. That should be finished then. We also have a GitHub repo. And thank you very much all across Germany and across the world who is listening. And you can see here some ideas of what we can actually do in Germany. And you can see how we're doing things and how everything is functioning here. And of course, all of the volunteers that are supporting us of the digital products, you all rock. And now we're done. Are there questions available? Okay, das heißt, ich halte dann am besten meine Kamera. Okay, I can see all the questions that you've handed in. And more by the minute. I'll just start with those that have a plus one in front of them. A question about the standard format. Why CSV? Wouldn't you rather have JSON or other formats that you can use on a web interface, for example? Yeah, actually, I'm fully with you and I hope everyone's applauding. We want much more. We just want to explain to the administration that Excel is not really what we want. Particularly not with these multi-line, multi-column things. So we try to say, well, CSV is something very simple so that everyone can open it up. So we try to say, well, CSV is something very simple so that everyone can open it up. So that everyone can open and that is hard enough. But yes, of course, everyone that is able to provide something more elaborate, they should provide that as well. Okay, then as a question with a plus two, I can see that question answered in the chat already. I'll just go with the questions, not any more comments. Do you have any mental help for me to feel more comfortable for Germany in the name? Maybe the question is, why only for Germany? Wie gesagt, wir kommen halt, wir sind so ein bisschen entstanden als das Schwesterprojekt von Code for America. Well, we kind of where this is the project of Code for America and the Americans want to have this kind of patriotism and we have a kind of a local patriotism here. What did I want to say? So, this is actually just the analogy to America. And there is this international thing, there is Code for Africa and many other regions are doing the same thing. So there is a continent wide thing as well. If you have a problem with that, well, as I said, it's a difficult thing. We always wonder whether we should just call it okay labs, open knowledge labs. If you have a great idea, please say but it will be hard to find something else. But it's hard with all these links to the other projects. Okay, I'll just continue maybe off topic. What's the role of SAFE by Hub in the sense of open knowledge for the climate? Or could I perhaps supplement my activism with competence? Okay. Of course, naturally I would say it's very strong to go in the open access direction. So, for instance the PayPal could be there to collect money and be free. And of course there's other supports coming in from other directions. Ich glaube, wir haben so ein bisschen festgestellt, dass es total schwer an allen Fronten gleichzeitig zu kämpfen und deswegen haben wir wirklich versucht, wie gesagt, es ist so schwer, Mensch überhaupt zu erklären, was ist CSV und dass es ist, in dem an Excel. And of course there's a question of Excel and we're great. Maybe I request to the outside if you put these questions into the chat. Please keep them short. Now the next question. The context of this talk is climate. And we can see you present a new platform here, open data and common interfaces. The German Meteorological Service does open data DWD, even though the data is not in standardized format. You can get climate data from models from the Max Planck Institute through the Weather and Research Forecast Model a local model by the American Meteorological Service, you can run calculations to. What about that? I can't don't see anything relevant to the climate in this talk. Right exactly. And there's lots of other projects that address this. But this is here only an example of what we're doing here. So encode for Germany we're doing a lot of things and then code for climate means this is one example of what we're doing and I thought okay, I'll just give a couple examples. It doesn't mean that we have an open data groups there that are working on it. But it's just one that is shown to this platform and we're looking at digital models here and ask Okay, next question of topic, which microphone are you using the sound is very good. Oh, that's good. Yeah, the audio is really important. Right, you just enter it into the pad, right? Next question, does the climate watch app use data from the open sense map because that sort of sends data from my own weather station with the particle matter and all that. That's a good question. I think it's only the data that's open that has the prognosis and then for the contact data it's going to be a different story. Yeah, next question with local apps and hackathons, I'm always sucked by the fact that there's more value placed on presentations rather than orderly content. How do you get something like presentation such as CSV or a good space of JSON? How do you get that? Good question. So, we have to learn as a community of how to do this and how we can further develop this and what we can do. What one thing we can do at the beginning is ask ourselves how can we actually describe this and what do we actually need? There are a couple of arguments you can collect you can make self-organized sessions to discuss this. How can I describe this? Like I said I think it's really hard. Okay, onto the next question of course these questions are growing faster than any renewable resource. Do you use the OFM tag some kind of actually I can just say for the stream the answer is in the stream someone put it an issue has been open for that so that this will come sorry for interrupting you there. It's really perfect. So like I said this is just scratching the surface here. Yes and we will talk about GitHub as well. Okay, mp4 underscore 404 plus 3 how difficult is it to actually get in touch with the government and convince these people to hand out data and what typical reasons do you hear to not hand out the data? So just to say clearly so there's a good example of all the reasons we want to collect this data more so than why we wouldn't and another point is actually so difficult for the government to do this there's lots of people that say a thousand times please do open data and then other people may respond but then we have to look at it again and it's not what we want so we say no this is not what we actually mean or what we want from open data we can use the example of barn the local government there's this hack day in the town hall and you have these people the code for project and the town getting very close together and the city sometimes you just need the right people getting together that you can call and you have to know this and in Münster for example there are two people at code for Münster actually now working in the town administration one is dealing with open data and the other with smart city so we are trying to get ourselves involved it's hard it takes time the question is how so we have to be quick in explaining that and where are the interfaces could you perhaps say in more concrete terms what you do other than asking health authorities and get measurements from pdf files and make the machine readable after all these buzzwords I've kind of lost the concrete information the information about the concrete work that you do and it's less clear to me than it has been before also I am not clear why for example the water project has to have the objective of changing people's behavior because actually surely this is a question of taste and not a decision about destroying the environment and having drinking tap water or is it okay yes that's a shame that it's about I would think that people are on different levels of how they think about this and I would think there's more people who want to sit together and they want nice things and they want to think about what is going on here and what is going on with my drinking water and it's one of our last goals that we want to reach that the government actually sees that wow people are using this information and then at the end we have a result that comes out that helps us reach our goal in the end that we're contributing to sustainable development on the digital level so it's not just about having the most fancy app but what is actually possible right great next question do you coordinate with at thelocavirkt.de platform do you coordinate with the SM community they have stayopen.de they they that was the French thing so yes I believe I am not directly involved in this project so there are a lot of people that are promised how you could actually participate in this but I don't know in what direction how deep they've gone but there are also other projects there okay so the last question is there a similar project in Austria is it possible to spread this all to all of central Europe yes of course yes we'd love it please do it further of course oh god I don't I hope I don't see the false thing here but I don't think it's actually done yet so when there's nothing yet we believe that this could be implemented very quickly I believe it's also in Austria when it's not then please write to us and please say hey but what's going on we could found this here as well and work on this further remote and we've really learned a lot today and there's a lot of people here that are on the chat and working live here okay great so at this point I'll say don't switch off your TV don't go to the toilet we will be glad to have you back so I've for the next event and take your trash with you and see if everything is okay until the left and right just as with any normal event so I'll go to that other lounge and we'll be back around 5 o'clock thanks Julia and a huge applause please warm welcome and the interpreters are asking an der Stelle was einspielen picture