 Welcome everyone to another session of DevCon 2022. My name is Ambriya Veselov and me and Richard Philo are moderating this session. Next up, we have Robert Spaal speaking about how data helps to make a better city. This session is live and please feel free to ask your questions in the chat and use the Q&A section. And from now on, I'm giving the word to speaker and Robert, yeah, you can start. See you soon. Thank you very much, Andrei. I would like to welcome everyone and I think we can start. Q&A will be at the end, so you can type your questions and I'll answer them later on. I'll share my screen firstly. Hopefully you can see it. This is a little bit. So as we all know, cities are immensely complex organisms that millions of people every day live in, work in and do lots of kinds of stuff. And for every city that wants to be successful and every city that wants to bring a high quality life to its citizens, it needs to be managed well, it needs to be managed wisely. And without the data, it's incredibly impossible nowadays. So without the data, you cannot make your city successful. Instead of talking about how important is the data and how significant it is, I would like to focus this presentation more on practical showcases and use cases, how data and data analytics improves the lives of our citizens in here in Brno city. Before I start a little bit of disclaimer, I'm from the data and analytics department of Brno city and most of all of the use cases and showcases I'm going to demonstrate here can be found at datahub.brno.cz. Most of them unfortunately are in English, are in Czech. In English, we have only several apps and tools. You can find them in the section apps or if you are Czech speaking person, you can go to the Czech version and all of them are in the app section there as well. So after we have this done, we can start with our use cases and the examples. So the first one I would like to introduce and it's quite, I would say it's a typical use case. As a city, we manage thousands and thousands, sometimes hundreds of thousands of data points. You can imagine it, when you walk on the street, there are benches, there are lampposts, there are technical networks, underground, there are buildings, parks, greenery, there are containers for recyclables and many, many, many things. Even you can be physical and also can be non-physical such as crime data and things like that. And for the most of those, we have passports and GIS systems where we input those data and we do the decision making based on the data from those passports. Here, this one, you can see the passport of the greenery where every tree, every green area is cataloged and in Brno, for example, in Brno City, greenery is managed by the city districts, but those districts get the money from the city, from the central city and they get it based on what is in the passport. So if they manage their passports well, they get more money. So this is one I would like this to be like, to show you or tell you, this is the very typical use case of passports and of passport data we have in the city and without them, we wouldn't be able to manage and to work properly. So after this one, there is another really nice use case. For example, we use a heat map of Brno City, we make a heat map every couple of years, I think four, and this heat map allows environmental department to see the changes in the heat, in the heat, in the temperature of temperatures across the years so they can react or adapt and plant more trees in the area or something or similar. This is a very widely used tool by the environmental department. Another really cool example is insulation map, which shows how much energy is falling from the sun on the buildings and areas in the city. So here, as you can see on the left, I have a legend which says and states how much energy, how many kilowatts per year per square meter are falling on certain surfaces. So here, for example, you can clearly see that these surfaces are much more insulated and you can build your solar power plants there. City is launching a bit recently, city launched a huge building program for solar panels on city buildings. And we are daily using this map to evaluate each city building and put panels on the buildings where it would be most efficient and most useful for us and would bring the most energy. The app can be also used by private citizens or private companies, anyone basically, but we use it in this way. So if you are from Brno City and you want to install solar panels on your rooftop, you can have a look and check out how much energy would you get. Another really nice example we have or we use is we use mobile phone data about that tell us how many people are where and how people move all across the different parts of the city. You can see the graphs of rhythms of several city districts. So we can see during the day that you can see the time during the day we can see how many people stay in each district or in each part of the city. And this helps us to divide the city in certain districts. So for example, the red ones are highly work districts and the deep blue ones are mostly residential districts. We also we can also see what is the strength of the flow of the people between the different parts of the town. You would ask why is it useful or what do we use it for? So for example, when there is a big construction coming or big transportation project as it was the case with the Trump to the university campus two years ago, we had to ask for funds from the EU and from the central government, national government and as a part of a part of the documents and was used was this data which which said how many people were traveling to the university campus area each day how how how utilized would be the public transport in this area. And at the end we've got the funds and partly it was because of the data we had and we could successfully argue that oh we need the Trump here because so many and so many people come here every morning, every day and so on so on. So in this way we can really easily identify high flow areas in the city. Another quite another example from the transportation topic is the is the biking data. We have our transportation department didn't have for many years bike intensity, intensities all across the city so they couldn't plan properly and after so many years we were able to acquire a data set which is which is updated every year and it's a data set of of all biking rides in May of those people who go to work and who are enrolled in the in the in the action called bike to work or project bike to work. So we have we get every year a new data that say how many people are biking on certain streets. So here you can see if I click in the map you can see that the bike intensity is how do they change and how big are they and and our colleagues at the transportation department they get the overall picture and if they want to create some project they can use these data from this app. We also incorporated the bike bike accidents those are the numbers you can see here. So this class to represents bike accidents since 2012 so you can also easily see which sections and what parts of the network are are are problematic and that helps as well. So that's another one another case from the environmental department is that here you can see a map of of containers for recyclables for which are publicly available. Here these dots or circles you can see these are these represent each represent the container so blue ones are for paper yellow ones are for plastic and the brown ones are for biological and so on so on biological waste and so on so on. And our our colleagues and the environmental department they have to distribute these and they should distribute these bins regularly and most efficiently but till now they didn't have any tool to do it they did it by just like with the side and with the best guess. As you can see the the network is not perfect the network is not very regular and sometimes there are gaps but they had no scientific way or yeah they didn't have any scientific way to to assess if if the network is efficient and so on. So that's why we are going to implement next month they will get the new map in in their system in in this one you can see they will get the new map of of walking distances to each to each bin so they will see where in the city there are gaps and where they should put the new containers. So for example here you can see these are I think 200 300 and 500 meters to each container and if I draw containers you can see these are the containers for glass and as you can see there there you you get the model which tells you how efficient your network is. So so our colleagues at the environmental department can very quickly and easily assess that efficiency and we'll be able to create much more just and much more efficient recyclables containers network. Another example is from the transportational department as well. For those who live in the city you know that the public transport here is quite great and we are very proud of it but as you know everything is getting more complicated and complex so to stay on the top and have that efficient system we needed to develop a tool that would allow our our transportational planners to plan the traffic plan the the whole network much more efficiently. So here you can see the app and there are some inputs you can you can you can input basically and you can choose you can choose day of the week you can choose time of the week you can choose a travel interval for each zone number of zones and then you can choose the address and you click in the map you wait for the model to calculate and oh I have to refresh it I'm sorry I and then it will output it will give you output of of accessibility rings or polygons which will show you how how is your neighborhood or how is the city how is the city transport how how is access the city or the area accessible by the public transport yeah all right when the demonstration doesn't work it worked a bit ago once once more please but I'm not sure why it didn't work but I checked it out a moment before and hopefully it works now because it's quite difficult to imagine if you don't see it so so hopefully yeah it's doing something so hopefully it's all right now it's used by our public transport planners but the app is accessible to the general public as well so you can for example if you're looking for a new flat in Brno and you have a job somewhere and you want the job or that flat to be I don't know 20 minutes from the job by the public transport you can use the model and to see what areas are suitable for your for your for your new flat for example the app is built on top of the gtfs data for those of you don't know gtfs it's basically an electronic schedule of of trams and buses and all the vehicles in the system and it doesn't work it's usually it's perfect for the demonstration if something breaks it needs to break I'm sorry I have to go but I can guarantee you it works I tried it before I don't know what happened now so we also have a main architect of the city of Brno which which works which creates a master plan and evaluates new projects and they also they also they also build and develop new squares and the streets and they design how they should look and this is one of the tools that help them to evaluate and assess what and what and how the city or street or the public space should look like and or the buildings so here you can see my my mouse goes to every building or every building in the city and you can see unfortunately it's in Chicago only but you can see the functions of the building so if it's a if it's for living for commercial use for storage use if it's a technical building and so on and so on so for every building it shows the specifications and this is a live model which is updated and and live so if something changes in the city it changes here and everyone can really easily use it as well and another app that main architect and also architects and construction engineers use is a 3d model which you can see here which is quite used you can very easily model whatever you want to build in a city and how it fits to the surroundings so for example you want to build a building you want to fit it in the model you can download the model which is accessible on the on the data platform and you can fit it in there and you can conceal you can negotiate with our department with city departments how and what should the building look like here in the model you can see you can do some several things so for example you can see how how your building affects the the shadows and creating and making shadows in the in its surroundings and many many more things i encourage you to use that app and because it's really really nice and another thing i would like to showcase we have also real-time data of a public transit in our city and so far the public transit data wasn't utilized for any decision-making and policy planning and fortunately that changes soon in next two or three months we should launch a new app that will show places and identify spots in the city where public transit is creating or is delayed more than usually and this will for example help our colleagues at the transportation department and planning agency to identify those spots and hopefully remove those clogging spots where where where vehicles are where vehicles are delayed so for example here you can see there is a huge crossroad and there is a delay happening there so hopefully in the in the in the future we'll be able to remove that and so this for example the one you see the demonstration you can see here is line eight it's a tram it goes from one end of the city to another and these bright yellow areas are the areas where that delay happens so this was it and one more thing i wanted to showcase another thing we are working currently on is is is the problem that several of our streets in the city are quite narrow and only one way and quite long so when the garbage truck goes to this to that street they they clog whole street and the traffic jams occur for so for many many minutes like 20 34 minutes easily here in the map you can see the one such a typical street which is called Franzowska which is very long and the garbage truck creates more than half an hour delays there we and then this is not the only street and we got many many complaints from the citizens that this is a problem so we tried to find a solution and after careful consideration because there are many solutions which were all right but that they would be really really expensive we decided to go with the data solution we will be providing navigational companies such as Waze or Garmin with positional data of our garbage trucks they will incorporate the data in their navigations so when a garbage truck enters such a street the drivers with navigations we will get the we'll get the warning we'll see it in the map and we'll get we will be told and advised to take another route so for example you take Merhaut and Mila de Hora Koverut instead of the Franzowska when you see that there is a garbage track in this way this will be very efficient and cost efficient and then we hope that it will it will it will get rid get us rid of the problem we have yeah yeah that's it basically actually okay that I appeared right in time I'm yeah I would I wanted to say that I'm very sorry to interrupt but if is that that's it so it's okay yes please you have a few questions and I can read it for you the first one is we have we have three minutes left so the first one is how does something like a bike incidence get tracked yeah they get tracked by the police so only the serious ones so for example we have a little bump or whatever that doesn't happen but the police has a really detailed has a very and very detailed statistics about the bike data and we get this data yearly every year so this is basically the way they even get attributes like what was the weather and what was the road condition and things like that so so I didn't showcase it but we have several dashboards not we but the transportational department has several dashboards where they can examine in detail those bike traffic data thank you and the next one do you gather any data that shows the noise level in the different parts of this city no we don't but the ministry of health does every four years noise pollution maps they create those maps every four years and and we get that data from them we unfortunately don't have the last data but in 2021 they did the research again and this year we should be getting the data with the map and everything should be as open as well thank you we have one minute left so two more questions it's a little unclear to me which is which of those use cases you showed throughout the presentation are actually being used to plan stuff right at this moment by the city so for example I'm sorry for for the app that didn't work for the for the modeling of transit accessibility the app that didn't work I don't know why but for example that app is used by the transportation planners to design the network so for example now they it's difficult to explain where they where you didn't see it but they have they have this app they know that for example with the app they know that for example this part of the city is is less accessible by tram than that this part of the city they can compare it they and they and they know they now know with this information that they should improve the accessibility of that region of the city so for example that was one thing another one for example the greenery passport without that our city districts they wouldn't know how big how how big budget they need for maintenance of of their greenery because they wouldn't know how much of a green areas there are how much of cutting of grass how much care of the trees because they go they also I didn't show it there I showed just the map but they get also statistics overall statistics so it shows in your city districts there is xy trees there is a xy meter squared of grass and so on so they use it for calculation and it is with like that with most of the cases only cases which is not like that is once we are currently working on or that are very new so that's the question okay yeah thank you very much we have really strict we have really strict time timing so I need I think we we are finished here and yeah I'm saying thank you to the speaker and thank you to the audience it was really impressive presentation thank you very much