Chaos Computer Club - archive feed

Tröten statt Zwitschern. Fediverse statt Metaverse. Sascha Foerster stellt die Twitter-Alternative Mastodon am Beispiel von Bonn.social vor. Die EU ist schon lange dort und Ulrich Kelber sowieso, ansonsten war Mastodon aber in Deutschland eher unbekannt. Das änderte sich, als Elon Musk im Frühjahr ankündigte, Twitter zu übernehmen. Nicht nur Jan Böhmermann versuchte daraufhin, seine Follower zum Umzug auf Mastodon zu bewegen. Auch die EU hat inzwischen eigene Instanzen. Bonn hat seine Instanz bereits seit 2017. Das soziale Netzwerk Mastodon basiert auf quelloffener Software und wird von Freiwilligen betrieben, deren dezentrale Server sich zum globalen „Fediverse“ verbinden, dank des Protokolls ActivityPub. Sascha Foerster hostet mit seiner Agentur Bonn.digital einen dieser Knotenpunkte: Bonn.social. Er erklärt, was das föderierte Netzwerk von anderen sozialen Medien unterscheidet und gibt eine Einschätzung seiner Erfolgsaussichten. Ebenso gibt es einen Blick hinter die Kulissen. about this event: https://programm.froscon.org/2022/events/2745.html

Have you ever heard from CTEs or Window functions? What is it and when and how to use it? Can you remember correlated subselects? The talk shows some fancy SQL commands that you can use with PostgreSQL, MariaDB and MySQL. SQL just has 14 commands ... but these can get very complex. Also since a few years there are some very useful new functionalities like CTEs and Window functions. Additionally the talk shortly will show correlated subselects and more. about this event: https://programm.froscon.org/2022/events/2738.html

Die Bestrebungen "Identität" von Menschen digital zu greifen und Kontext-übergreifend zu nutzen, werden immer konkreter. Was aber ist "Identität" eigentlich für uns Menschen. Und wie können wir aus "Identität" irgendwelches Vertrauen ableiten? In wie weit machen hier zentrale Ansätze bzw. Kontext übergreifende Ansätze Sinn? Und für wen? Gibt es alternative Ansätze? Menschen haben im täglichen Umgang miteinander ganz andere Vorstellungen von ihrere Identität oder der anderer Menschen, als was häufig versucht wird digital abzubilden. Von vielen Menschen, mit denen wir interagieren kennen wir nicht einmal den Namen und häufig genug interessiert er uns auch nicht wirklich. Selbst von Stammkunden weiß z.B. der Bäcker häufig nicht den Namen, wo sie sonst noch einkaufen, wo sie wohnen oder wie alt sie genau sind. Und wir können uns z.B. auf einer Veranstaltung stundenlang mit jemandem unterhalten, ohne den Namen zu kennen. Um andere Menschen einzuordnen sind uns andere Dinge wichtiger, wie gemeinsame Bekannte, Hobbys, Beruf. All dies sind für uns viel wichtigere "Filter", als die "Eigenschaften" die sich typischerweise in staatlichen Identitätsansätzen niederschlagen. Auf der anderen Seite gibt es die sozialen Medien. Diese können viele verschiedene Verbindungen zwischen Menschen und ihren Aktivitäten herstellen und uns ziemlich gut abbilden. Aber dafür gibt es hier andere Probleme. Menschen "sind" je nach Kontext unterschiedliche "Personen". Wir zeigen uns auf der Arbeit typischerweise anders, als gegenüber der Familie, beim Sport oder auf einer Party. Umgekehrt interessieren wir uns je nach Kontext auch für andere Eigenschaften des jeweiligen Gegenübers. In wie weit macht es hier überhaupt Sinn die verschiedenen "Persona" zu verknüpfen? Wir nutzen für verschiedene Kontexte ja auch bewusst unterschiedliche Tools, Emails, Gruppen, Accounts und teilweise sogar Geräte. Eine "Identität" bildet uns nicht wirklich gut ab. Wir trennen bewusst auch die eigenen Informationen über uns und andere aus den verschiedenen Kontexten voneinander ab. Eine einzelne, allwissende, allmächtige "Identität" benötigen wir nicht und ist im Zweifel sogar schädlich. Wie kann man es anders machen? Es einige alternative Ansätze. Und auch solche, die dezentral sind, ohne der Akkumulation der Informationen, wo man sonst noch so aktiv ist bei einem zentralen Anbieter auskommen, generell nur die Informationen herausgeben, die für den jeweiligen Kontext relevant sind und unsere zwischenmenschlichen Vernetzungen mit berücksichtigen können. Ein Ansatz von CAcert verwendet Client-Zertifikate basierend auf einem WebOfTrust und openId Connect. Dies ist aber nur ein Beispiel. Wichtiger ist, dass wir als Open Source Community uns den Weg zu "menschlicheren" Ansätzen nicht verbauen und uns nicht nur singulär auf die Big Player verlassen. about this event: https://programm.froscon.org/2022/events/2801.html

The Systems Engineering / SRE world has undergone a shift of thinking towards intend driven holistic configuration management a long time ago, but it feels like the majority of network automation solutions are still following the idea of making incremental changes to the routers and switches out there, which at the same time might also be managed manually by operators typing (or copying) magic spells into a CLI. This makes the device configuration the synchronization point and we don’t really have an idea of what this configuration will look like in full without checking back on the device. I believe we as Network (Automation) Engineers need to follow suit, make the mental shift to the holistic approach, let Perl, Shell and expect scripts be, and bring software engineering methods to network automation. This way we are able to tackle the problems at hand at an abstract level, build solutions which can be reasoned with, tested on their own, and scale to our needs. For the most daunting problem of configuration management this means plugging some of those systems together and building a solution which generates and owns the full device configuration. Dealing with diverging configuration parts, across the fleet, carefully cleaning up old approaches to configure X, doing incremental changes, and figuring out how to interact with a platform API, a dialect of NETCONF, YANG, etc. would all be from the past –-- wouldn’t that be great? about this event: https://programm.froscon.org/2022/events/2820.html

Erläutert werden Fallbeispiele aus Sicht des Produkt-Managers und Entwicklers, der die Entscheidung zwischen Integration in den Standard oder kundenspezifisches Customizing trifft. „Gescheitert am ERP-System“ titelt die Computerwoche und meint damit unter anderem die fehlgeschlagene Einführung von SAP bei Lidl. An dritter Stelle der Ursachenforschung wird unverhältnismäßiges Customizing genannt. Die Abwägung im Standard zu bleiben oder auf die Benutzer-Wünsche einzugehen fällt oft nicht leicht. Allerdings ist es mit git und dessen Rebase-Funktionalität möglich die Grenze etwas weiter in Richtung wartungsfähiges Customizing zu verschieben und somit die individuelle Benutzerakzeptanz zu erhöhen. Ferner helfen individuelle kundenspezifische Software-Tests bei der langfristigen Integrations-Arbeit. about this event: https://programm.froscon.org/2022/events/2767.html

Die meisten Linux-Distributionen verwenden für die Festplattenverschlüsselung ein Passwort. sectpmctl benutzt das TPM 2.0 Modul zusammen mit Secure Boot für die Verschlüsselung. Wahlweise kann zusätzlich eine Boot-PIN verwendet werden, die hardwareseitig vor Brute-Force Angriffen geschützt ist. Veränderungen der Secure Boot Schlüssel und der Boot-Dateien durch Viren oder Angreifer werden erkannt und der Bootvorgang verhindert. Im Falle eines Diebstahls sind alle Daten des Geräts geschützt. Dieses Tool ist eine komplett integrierte und einfache Lösung. Die typischen Probleme, die mit dem TPM entstehen (PCR Brittleness z. B.) werden umgangen durch die Verwaltung und Nutzung von Secure Boot und dem Provisionieren des TPM's nach dem TOFU Prinzip (Trust on first use). Die Nutzung des TPM's ist immun vor Änderungen durch System Upgrades, die Entschlüsselung wird nicht an den Userspace gebunden, sondern an den Hardware-Zustand. Zum Booten wird systemd-stub and systemd-boot verwendet. about this event: https://programm.froscon.org/2022/events/2766.html

Zu einem Projekt beitragen, aber wie und warum? Spielerisch geht das mit Gamification. Besonders Crowdsourcing-Projekte können von Gamification profitieren und es Einsteiger*innen leicht machen. In diesem Vortrag erzählen wir, wie man zum Beispiel zu OpenStreetMap spielerisch beitragen kann und was überhaupt Gamification und Crowdsourcing ist. Wir zeigen verschiedene Beispiele aus dem Open- und Closed-Source-Bereich. Anhand von OpenStreetMap schauen wir uns Ansätze an, wie aus spielerischen Beiträgen Daten werden und wie später aus diesen Daten sogar wieder neue Spiele werden. Zuletzt überlegen wir, welche Probleme es mit dem Gamification-Konzept gibt, was Datenschutz und Lizenzen damit zu tun haben und ob daraus wirklich wertvolle Beiträge zu Open-Source-Projekten werden können. about this event: https://programm.froscon.org/2022/events/2800.html

The closing session of the State of the Map 2022 conference. about this event: https://2022.stateofthemap.org/sessions/LX3EGF/

This proposal expands an understanding of humanitarian mapping from an ethnographic perspective, seeking to understand the complex mechanics behind this confluence of humanitarianism, technology, and crowdsourced labor. It seeks to scaffold a notion of the “open source mapping supply chain”, situating both humanitarian mapping and OpenStreetMap itself within a larger ecosystem of commercial, humanitarian, open source, government, and other actors in developing geospatial-related technologies. This presentation presents a selection of a MA dissertation project, pursued over the course of more than 1.5 years of immersive fieldwork on OpenStreetMap. This presentation will focus on humanitarian mapping through qualitative study, seeking to expand an understanding of humanitarian mapping (particularly that which has emerged from mappers associated with the Humanitarian OpenStreetMap Team - also known as HOT) through the use of ethnographic tools, seeking to understand the complex mechanics behind this confluence of humanitarianism, technology, and crowdsourced labor, asking how and why people contribute to open-source platforms like OSM, and what role humanitarian mapping plays within the wider ecosystem of geospatial and mapping technologies. Ultimately however, it seeks to scaffold a notion of the “open source mapping supply chain”, situating both humanitarian mapping and OpenStreetMap itself within a larger ecosystem of commercial, humanitarian, open source, government, and other actors in developing geospatial-related technologies. Founded in the aftermath of the 2010 earthquake in Haiti, the Humanitarian OpenStreetMap Team (HOT) helps both globally remote and local in-person volunteers to identify roads, buildings, and other features on the OpenStreetMap (OSM) platform. Created as a “free, editable map of the world,” OSM has enabled the mass-creation of volunteered geographical information (VGI) on a scale that is now more accurate than proprietary maps in many places, particularly as “crisis-mapping” has emerged as a means to gather real-time data on areas that have been affected by natural disasters or socio-political conflicts. OSM has also become also a site of resistance, where local and indigenous communities have engaged in mapping projects to reclaim autonomy, agency, and space through the historically contested practice of (digital) mapping. For these reasons, such crowdsourced maps have increasingly been used by humanitarian organisations to facilitate aid and disaster relief, and as open training data for algorithms learning how to automatically detect features through Artificial Intelligence (AI). As a key partner of humanitarian, corporate, and local actors, and having mobilised over 200,000 volunteers since 2010, HOT lies at the crux of these ongoing entanglements and contestations, both within and around the field of OSM. Previous studies of crowdsourced geographical information and crisis-mapping have generally revolved around quantitative analyses of OSM’s data, focusing on the credibility of the data itself, the makeup of the communities that contribute to it, the effects of “event-centric” crowdsourcing, or “newcomer retention” in humanitarian mapping (Dittus et al., 2016a, 2016b, 2017; Haklay, 2010; Haworth et al., 2018; Sui et al., 2013). Alternatively, they have also focused on the “spatial knowledge”, “hacker political imaginary”, and gender composition of mappers themselves (Brandusescu & Sieber, 2018; McConchie, 2015; Stephens, 2013). Parallel studies of other volunteer-driven communities like “Wikipedians” have taken similar approaches, analysing “user-generated content” and the motivations behind them (Nov, 2007; Yang & Lai, 2010). Both hacking and free and open source software (F/OSS) have also been explored ethnographically (Coleman, 2012; Kelty, 2008). While automated detection of features on OpenStreetMap has only recently become an important topic of research, ongoing studies have primarily focused on the accuracy or credibility of this endeavour (Brovelli et al., 2017; Resor, 2016). While existing studies of digital communities have focused on the socialities they engender or labor they require, they tend to forget the bureaucratic apparatuses that have emerged to govern them, both implicitly and explicitly (Coleman, 2012; Kelty, 2008). Similarly, studies of humanitarianism have focused on the ethics they operationalize, or the technologies that are mobilized in turn, but often at the expense of engaging in the wider spectrum of social and economic life that they enable (Cross, 2013; Redfield, 2012, 2016a; Scott-Smith, 2013, 2016a, 2019; Ticktin, 2014a). While this project draws upon these overlapping strains of research, it seeks to push the debate in an ethnographic direction, scaffolded by theories of bureaucratic technology, political economy, and humanitarianism. This research draws from participation in over 40 online events over 1.5 years, including mapathons,

Wikimedia Italia, the Italian OpenStreetMap Local Chapter of the OSM Foundation, presents its activities, online infrastructure developed to support OpenStreetMap in Italy and the Italian community. The talk will share the experience, situations and factors that have influenced agreat collaboration with the local contributors and institutions during the last years. The presentation will go through different areas of the Local Chapter’s activities. The recently updated infrastructure, composed by the Tasking Manager and the OSM extracts for Italy. Those tools are available and used by the Italian OSM community. Moreover, the official new Italian OSM website, the OSM licences tracking process and other tools developed to support the community will be presented. Other experiences that will be shared are the collaborations with local institutions, with the scope of strengthening local communities and increase the data in OSM. The keys to success are the volunteer coordinators. They are a point of contact important to establishing collaborations with individuals and institutions throughout the national territory about this event: https://2022.stateofthemap.org/sessions/MRK3C8/

Vortrag über den neuen MySQL Operator für den Betrieb von MySQL in Kubernetes Umgebungen (mit Demo). Kubernetes ist eine standardisierte Umgebung für die Verwaltung von Arbeitslasten auf verschiedenen Maschinen, die sowohl für die Bereitstellung vor Ort als auch von allen großen Cloud-Anbietern unterstützt wird. Kubernetes funktioniert durch die Bereitstellung von containerisierten Arbeitslasten, indem deklarative Beschreibungen des geforderten Zustands bereitgestellt werden. Ursprünglich war Kubernetes auf einfache zustandslose Microservices ausgerichtet, hat sich aber schnell auf andere Workloads ausgeweitet und kann daher für eine breite Palette von Lösungen verwendet werden. Einige Dienste, wie z. B. Datenbanken, benötigen jedoch eine besondere Behandlung. Für den Umgang mit dieser Art von Diensten kann Kubernetes mit Operatoren erweitert werden, die eine spezielle Art von Dienst an die Kubernetes-Plattform binden. Mit der jüngsten Veröffentlichung von MySQL 8.0.29 wurde der neue MySQL Operator für Kubernetes veröffentlicht. Der MySQL Operator für Kubernetes unterstützt den Lebenszyklus eines MySQL InnoDB Clusters innerhalb eines Kubernetes Clusters. Dies reicht von der Vereinfachung der Bereitstellung von MySQL-Server- und MySQL-Router-Instanzen, einschließlich der Verwaltung von TLS-Zertifikaten und der Einrichtung der Replikation, über die laufende Verwaltung dieser Instanzen bis hin zur Unterstützung von Backups, sei es einmalig oder nach einem Zeitplan. Beim Deployment läuft der MySQL Operator innerhalb des Kubernetes-Clusters und achtet auf Änderungen des gewünschten Zustands. about this event: https://programm.froscon.org/2022/events/2762.html

Data minimization, data economy and transparency are mandatory for getting GDPR conform. This talk is a discussion, what you could do on your database to increase your privacy level. Getting GDPR conform still is an issue for lots of developers. How you can implement some GDPR rules directly in your database? What kind of extra. columns does your SQL database need? How to control your SQL data? How to solve some transparency rules in your database? The talk just will discuss ideas how you could solve some mandatory GDPR specification directly in your SQL database. about this event: https://programm.froscon.org/2022/events/2739.html

Because of access restrictions imposed during the Covid-19 pandemic, access to the physical laboratories of our university was no longer possible for students. Lectures requiring specific hardware which is only available to students in laboratories could no longer take place. Therefore, we developed a solution which allows remote access to hardware of our laboratory. The FLOSS application WorkAdventure is used as base for our platform. WorkAdventure (WA) already makes privacy friendly online meetings possible in a 16-bit 2D computer game design. We extended WA to provide interactive, virtual lecture rooms by integrating BigBlueButton (BBB). However, privately communicating with fellow students sitting nearby is still possible. This creates a more realistic feeling when attending online lectures. As far as this solution is well known, but we wanted considerably more... In order to give lecturers and students different rights in BBB, we reimplemented parts of the proprietary administration services of WA. With them, we can give out different invitation links, so they also act as access control method. Furthermore, we embed noVNC, a web application acting as VNC client, into WA. With noVNC, it is possible to access virtual machines (VM) we set up on the computers residing in our physical laboratory from home. Here, we also developed a software which makes it possible to work in groups on the VMs remotely. This software puts all users connected to a VM into a Jitsi conference room, which allows the users to communicate. By using USB pass-through, it is possible to connect the physical hardware to the VMs. Then, by accessing the VMs, students can control the hardware remotely. Therefore, we were able to offer the lectures and exercises requiring special hardware by offering them in our virtual laboratory. Our software solution has a high transferability: New use-cases can be addressed quickly, as web applications can be integrated into WA easily. On the other side, parts of our solution can be used independently in own instances targeting other use cases. We invite developers to participate in the project and further develop the solution for possible use in high schools. Problem Description: Working in physical laboratories during the Covid-19 pandemic was no longer possible due to imposed access restrictions. This makes lectures with special hardware requirements impossible, as students can no longer access the laboratory. Furthermore, we have not enough devices to hand out to students. Therefore, it was necessary to find a solution that allows us to use hardware located in a laboratory in groups online. In our use case, students should be able to program Internet of Things (IoT) microcontrollers remotely. Furthermore, many online lectures were not as interactive as we hoped. While students can ask questions in popular online lecturing tools like BigBlueButton (BBB), it is not possible to quickly switch between working in groups and lecturing. Moreover, switching between multiple groups is not straightforward. Also discussing the lecture's topics with seat neighbors is no longer possible when using only BBB. Therefore, we looked for a solution, which creates a more lecture-like feeling. Furthermore, students should be able to work within groups and switch between them easily. Especially commercial products often harvest user data and use it for analyses. Some companies even sell collected data to advertisement companies. However, the personal information of students should be well protected. Therefore, our solution should also be privacy-friendly. In the optimal case, the used software follows privacy-by-design principles. This means it only collects information which is necessary for operating the service. Approach: During our research in order to find a solution, we could not find a FLOSS application which offers all the features we required. Therefore, we decided to build our own platform. We chose to use the FLOSS software WorkAdventure (WA), developed by TheCodingMachine, as underlying platform. WA is a web application which enables interactive online conferences and has a 16-bit 2D computer game design. WA follows the privacy-by-design principles, as almost all information exchanged with the clients is only stored temporary and removed from the backend after the user closes the tab. Furthermore, decentralized communication channels based on WebRTC technologies are used whenever possible. In WA, people walk a character over a map. Whenever multiple people stand nearby, a communication channel is established between their clients and they can communicate. The communication channel is closed when walking away from the group. However, this way of communication only works for smaller groups. When entering specific, pre-defined areas of the map, corresponding actions can be run in the users' browsers. By default, WA uses this feature to allow embedding Jitsi conference rooms in order to make bigger conf

Serverlandschaften sind ständigen Änderungen unterworfen. Umso wichtiger ist die Verwendung von Configuration-Managment-Tools zur Strukturierung der eigenen Infrastruktur. In Zeiten der Public, Hybrid oder sogar Multi Cloud-Umgebungen kann dies jedoch rasch zu einem ganzen ‚Zoo‘ an plattformspezifischen Management-Tools führen. Diese müssen einzeln gepflegt und gewartet werden, eine aufwändige und unübersichtliche Arbeit. Eine zentrale, plattformunabhängige Verwaltung des eigenen Rechenzentrums kann hier viel Arbeit und Zeit einsparen. Dieser Vortrag zeigt, wie Terraform genau in so einem Fall Abhilfe schaffen kann. Im Rahmen diese Vortrags wird eine kurze Einführung in Terraform gegeben, sowie am Beispiel zweier grundlegender Setups das Multi Cloud Prinzip demonstriert. Serverlandschaften sind ständigen Änderungen unterworfen. Umso wichtiger ist die Verwendung von Configuration-Managment-Tools zur Strukturierung der eigenen Infrastruktur. In Zeiten der Public, Hybrid oder sogar Multi Cloud-Umgebungen kann dies jedoch rasch zu einem ganzen ‚Zoo‘ an plattformspezifischen Management-Tools führen. Diese müssen einzeln gepflegt und gewartet werden, eine aufwändige und unübersichtliche Arbeit. Eine zentrale, plattformunabhängige Verwaltung des eigenen Rechenzentrums kann hier viel Arbeit und Zeit einsparen. Dieser Vortrag zeigt, wie Terraform genau in so einem Fall Abhilfe schaffen kann. Terraform ist ein plattformunabhängiges Open Source Tool zur Konfiguration und fortlaufendem Management der eigenen Infrastruktur. Mit Hilfe von Terraform lassen sich Änderungen an der Infrastruktur planen, reviewen und ausrollen. Terraform folgt dabei dem „infrastucture as code (IaC)“ Prinzip, d.h. Infrastrukturspezifikationen werden in entsprechenden Konfigurationsdateien hinterlegt. Dies erlaubt die Verwendung von Versionskontrolle und CI/CD Tools zum automatischen Deployment von Setups. Terraform bietet an dieser Stelle eine Vielzahl an verfügbaren Providern für einzelnen Service- und Clouddienste an und erleichtert somit die Benutzung im Zusammenhang von Multi Cloud Umgebungen. Im Rahmen diese Vortrags wird eine kurze Einführung in Terraform gegeben, sowie am Beispiel zweier grundlegender Setups das Multi Cloud Prinzip demonstriert. about this event: https://programm.froscon.org/2022/events/2765.html

Die Zeiten des einsamen weißen Hackers im Keller seiner Eltern sind lange vorbei. Moderne Cyber-Angriffe werden von Staaten oder organisierten kriminellen Gruppen durchgeführt. Um gegen die schiere Anzahl solcher Angriff und Akteure an zu kommen ist viel Kreativität und Durchhaltevermögen gefragt. Man spricht klassischerweise davon, dass es eine Asymmetrie zwischen Hackern und Defendern gibt: die erste Gruppe ist Pro-Aktiv, braucht nur einmal erfolgreich sein, und muss die Malware lediglich schreiben. Defender auf der anderen Seite können immer nur reagieren, müssen <i>immer</i> erfolgreich sein, und das manuelle Analysieren von Malware ist sehr zeitaufwändig. In diesem Talk werden wir exemplarisch einige Vorfälle durchgehen und einen Vorschlag umreißen, welche Asymmetrien in die entgegengesetzte Richtung bestehen. about this event: https://programm.froscon.org/2022/events/2778.html

Geo-literacy provides skills to read, interpret and use geospatial information, where little evidence exists regarding the potential and capacity of new education programs in advancing these skills. We present a citizen science project held in 13 high schools in Israel, where the students practice participatory mapping with OpenStreetMap to map features relevant to the navigation of visually impaired pedestrians. We show that students improve their geospatial thinking and reasoning skills, including their self-esteem. We believe that this research contributes to various pedagogic and education levels, in terms of theoretical knowledge about the integration of innovative geo-literacy programs. The 21st Century dictates that people have a good spatial and geographic understanding and knowledge. Geo-literacy is aimed to provide skills to read, interpret and use geospatial information. This is achieved by acquiring critical spatial thinking, reasoning, and analysis, and presenting understanding of the world using geographical terms and spatial language. Recent years have led to the development of new geo-literacy education programs specifically designed to nurture and promote these skills. These education programs build on geographical education that promotes spatial thinking and active citizenship. Still, little evidence exists regarding the potential and capacity of these programs in advancing civic and geographic skills and knowledge in the 21st Century, and on its contribution to - and advancing of - the individual and the society. The aim of this research is to gain a better understanding of the development of geo-literacy in the framework of a citizen science project in high schools. The citizen science project implemented in several schools in Israel – landmarks for accessible space, advances scientific research that aims to make the urban environment more accessible for visually impaired pedestrians. The participating high school students practice participatory mapping with OpenStreetMap (OSM) to map features relevant to the navigation of visually impaired pedestrians. These map features are used for the automatic calculation of optimal walking routes. The project combines social involvement, learning through geographic information systems, and familiarity with the field of urban accessibility for visually impaired people. The project includes the following stage: 1. Pre-stage that includes a) the design of the modular learning environment, b) the organizational and pedagogical preparation of the project integration in schools, and c) questionnaires examining the current level of geographic literacy of the participating students and their perspective regarding the integration of citizen science in schools. 2. Intervention program that includes guest seminars (including YouTube videos), lectures and learning activities, exposure to the world of visually impaired people, and the need for accessible environments and learning activities in the field of geoinformation with emphasis on OSM, crowdsourcing, and participatory mapping. 3. Mapping missing data into OSM. This stage is carried out in the field with a designated app developed for this project. The app - “Mundi” - allows the mapping of specific geographic features (mapping elements) used for the calculation of accessible routes designed specifically for visually impaired pedestrians. The features include, among others, sidewalks, crossings, accessibility aids, and handrails. The app includes gamification and tasks to encourage the students to map the missing features in their area of residence. 4. Post-stage questionnaires aimed to investigate and analyze the development of spatial skills in the context of participation in this program, examining whether students’ level of geographic literacy improved and whether they gained new knowledge on urban accessibility and the navigation proficiencies of visually impaired pedestrians. This stage also included a quantitative analysis of the students’ contributions in terms of OSM mapping, among others, the number of map edits, type of mapped features, the spatial coverage and temporal extent of their mapping activity. The study was conducted in the last two years in 13 high schools, including 25 classes and 460 students. The intervention model was implemented for three months in each class. The participating students implemented this project within their Cyber Geography studies, enabling them to learn through various geographic information systems. In total, close to 10,000 OSM edits were made by the students, which included more than 3,000 new crossings (and attributed tags), 400 new sidewalks, and 7,000 new street objects and obstacles (e.g., bus stations, light poles, trees, gates, bicycle parking). Preliminary analysis showed that participation in the citizen science project increased the students’ geospatial thinking and reasoning. For example, according to the questionnaire variables, on a score scale of

Follow the OSM journey of the Médecins Sans Frontières (MSF) from a mapathon in Berlin in 2014 to creating and contributing geodata for numerous MSF operations through the Missing Maps project. This talk will be about how MSF uses OpenStreetMap internally and how we contribute through remote and field mapping. We will also share the lessons learned and reflect on the biggest challenges for MSF in creating and using the OSM data. The OpenStreetMap journey of Médecins Sans Frontières (MSF) started in 2014 with a mapping party in Berlin and field mapping in Lubumbashi. Eight years later, OpenStreetMap is the reference geographical dataset for most of MSF operations on the ground. OpenStreetMap has been used in public health interventions, disease outbreaks, mortality studies and to support large logistical operations. Still every day we are learning how geographical information can support us in doing our job better, in reaching more people, in saving more lives. MSF is not only using OpenStreetMap, but it also actively contributes to the map through the Missing Maps project launched in 2014 together with the American Red Cross, the British Red Cross, and the Humanitarian OpenStreetMap Team. Since then, MSF has trained dozens of Missing Maps champions, co-organized hundreds mapathons and involved thousands of volunteers in some 30 countries. In this presentation we will talk about how MSF uses OpenStreetMap internally and how we contribute through remote and field mapping. We will also share the lessons learned and reflect on the biggest challenges for MSF in creating and using the OSM data. about this event: https://2022.stateofthemap.org/sessions/XJZBFH/

The YouthMappers experience lends itself to explore interesting questions about the cultural and organizational aspects of data production and usage practices in OpenStreetMap, in order to improve them. First, this study aims to identify what are some of the qualitative and quantitative characteristics distinguishing the performance of YouthMappers as an academic-based community within OSM. Second, this study aims to better understand how the design approach taken by and on behalf of YouthMappers reinforces an identity as unique contributors. Increasingly ubiquitous open spatial technologies offer the opportunity for new actors to participate in creating knowledge about the places where they live and work, and where they connect to others around the world. University students are one set of actors who have grown significantly in their visibility and contributions to OpenStreetMap, in part through the establishment of YouthMappers in 2015. This inclusive international network of university-based, youth-led, faculty-mentored chapters on more than 320 campuses in 66+ countries works to mobilize and support university student mapping action that responds to humanitarian and development needs by creating and using an ecosystem of data and tools centered on OpenStreetMap. The YouthMappers experience lends itself to explore interesting questions about the cultural and organizational aspects of data production and usage practices in OpenStreetMap, in order to improve them. In this case, we explore these aspects as they occur within and through the academic sector, particularly through the hands and eyes of student youth. As a consortium design, this networked set of local groups works on the one hand, to create and use data on their local campuses and home communities, and on the other, to remotely contribute data on imagery-visible features in response to humanitarian, development, and knowledge needs wherever they may occur around the globe. Furthermore, they act not only within the OSM “community of communities” framework (Solís 2016), but also within an existing global infrastructure of academic institutions with its own set of shared educational aims, knowledge generating practices, and cultural norms. Meanwhile, students are motivated both by learning and using new skills and workforce competencies as well as by the opportunity to participate in the world’s largest volunteered geographic information project and the activities that make common good use of the data. So how do YouthMappers navigate these different aims within these different spaces of action? To address this question, two aspects of this experience are the focus of attention in this study. First, this study aims to identify what are some of the qualitative and quantitative characteristics distinguishing the performance of YouthMappers as an academic-based community within OSM. Second, this study aims to better understand how the design approach taken by and on behalf of YouthMappers reinforces an identity as unique contributors. The presentation first will provide a description and justification for the purposeful design of the YouthMappers consortium (Solís et al. 2018) within the context of OpenStreetMap (Brovelli et al. 2019). The study will be contextualized with a review of literature on the current state of higher education, particularly with respect to a present tension around higher ed institutions’ purpose as sites for both workforce preparation and global citizenship. The latter point will be situated with reference to scholarship on the global targets of the Sustainable Development Goals (SDGs), as perhaps the predominant discourse for international action across humanitarian domains. This review sets up three interlocking hypotheses that the evidence is anticipated to reject: H1: (Action-of-Performance) Participating youth either map only locally or remotely, but not both; H2: (Hybrid-Roles) Participating youth cannot simultaneously pursue personal aims to prepare themselves for the workforce and to express their identities as global citizens; and H3: (Movement-Minded) Participating youth cannot articulate the impacts/benefits of actions undertaken for broader communities or society through their work with OSM, nor identify the roles/contributions of youth action in this work for the common good. Data to test the first hypothesis relate to performance and include a range of metrics of participation (Andal et al. 2022; Boateng et al. 2022; Walachosky et al., 2022); statistics of known users (Anderson 2022), and a review of data from other studies of YouthMappers’ editing contributions (e.g., Mahmud et al. 2022). Data to test the second hypotheses relate to identity and come from the long-running student-authored blogs (Hite et al., 2018), as well as a global survey of YouthMappers collected in 2019 accompanied by a qualitative set of member queries to iterate interpretation of the survey results (Solís, Anderson & Rajagopalan 2020

OpenIndoor is an open source SaaS that uses OpenStreetMap indoor data to display a 3D graphical rendering of building interiors. The resulting map offers a gamified experience to meet different types of needs: indoor navigation, data representation, immersive tour etc. We will discuss how we use the available open data and the Maplibre engine to address these different use cases. about this event: https://2022.stateofthemap.org/sessions/HEKRDY/

This talk explores the effects of OpenStreetMapping on the mappers. These effects also infer that OSM mapping can be used as a tool for skill-building. OpenStreetMap, the crowdsourced geospatial database, currently has over eight million registered members [1]. This makes it one of the largest VGI projects with proven multifaceted use cases e.g. post-disaster response, combating female genital mutilation, app development, and navigation. The database is wholly made and maintained by its contributors, making all decisions without a top-down governing authority. People in OSM contribute in multiple ways, extending databases, onboarding newcomers, building community, exchanging information, and providing public benefit. Within the OSM community, OSM mapping is regarded as a form of volunteering to create freely accessible geodata. However, recent studies suggest that the experience a mapper gains through the mapping process could be equally important as well [2-4]. Building on the existing body of knowledge, in this talk, we will share the findings our research on how mapping in OSM affects the mapper. Being a quality OSM mapper requires training and practice. The act of OSM mapping requires transitioning from having an interest in mapping to creating an OSM account, learning how to use the application, developing an understanding of the technical and theoretical dimensions of mapping, and then applying these skills and knowledge to accurately convert satellite imagery into map data. Such a process engages mappers in multiple decision-making processes and continuously exposes them to buildings, topographies, and features of satellite imagery. We suggest that such experiences affect the mapper in multiple ways. We studied a youth mapping internship called Digital Internship and Leadership (DIAL) Program conducted in three cohorts. We chose this internship program for its inclusiveness in terms of academia, gender, and the geographical locations that the participants came from. Participant mappers were called through an open invitation on social media. Recent high school graduates and undergraduate students participated in the mapping internship. They were from diverse academic backgrounds (geomatics engineering, architecture, crisis management, management, forestry, geomatics engineering, computer science and engineering, electronics engineering, management, public health, mechanical engineering). The internship aimed to reduce OSM data gaps in rural Nepal through the involvement of Nepali high school graduates. The program was designed and executed by Kathmandu Living Labs (KLL). We studied the self-assessed experiences of the participant mappers at two different points of time: (i) during the mapping program (ii) after two years for Cohorts II and III, and three years for Cohort I. Short-term effects were studied through grounded theory coding of reports and blogs documented during the internship period. For long-term impacts, an online survey administered to identify if the effects persisted. Results show OSM mapping helps the mappers develop a number of vital skill sets and expand their knowledge in a variety of areas. Some of them are: deepening of civic engagement, development of social identity, expansion of geographic knowledge, spatial awareness, increase in happiness and satisfaction. They retain most of these skills even in the long run, irrespective of differences in gender, academic, or professional backgrounds. Surprisingly, 44.8% of the participants cited ‌they considered being a professional mapper or cartographer at some point in time because of their experience in DIAL. The same people report that OSM mapping increased their belief in their ability to help society. Apart from these individual benefits, we also sense collective benefits. Collective benefits such as network development and an increased sense of civic responsibility hold potential to facilitate broader public good. These might also be applicable for youth mobilization, team building, and collective work. It is difficult to pinpoint the exact root cause of this development, however, the benefits of OSM mapping may be in part related to the continuous exposure to satellite imagery, continuous use of technology, the requirement of multiple layers of decision-making, humanitarian aspects of OSM, and the growing global OSM community encouraging conversations around it. Our findings build upon the studies of the use of OSM in high schools, which was noted to increase creativity and spatial awareness among the students [5, 3, 2]. When compared to Minghini et al.’s (2016) study with ten-year-olds, the similarity in findings suggests ‌these developments might be similar across ages. These developments suggest new directions toward the use of OSM as a tool for youth skill building and youth community engagement and design newer incentive mechanisms for people to join and retain in OSM. There is still a huge scope of investigation left in t

OpenStreetMap data represents a valuable source of information for public green areas in large urban centers and effectively measures the United Nations' Sustainable Development Goal 11.7. Our study provides a threefold contribution in this direction. First, we validate land-use-related tags in OpenStreetMap, through a comparison with satellite data from the European Urban Atlas. We then propose a framework and an interactive tool to measure access to public green areas through several established indices. Finally, we show how the framework can be used to simulate the impact of new green areas and help policymakers design effective interventions. As of 2020, around 55% of the worldwide population lives in urban areas and the World Bank estimates forecast an increase of around 1.5 times in the urban population by 2045. Cities are also major contributors to the climate-change, with a consumption of about 78% of the worldwide energy and a production of 60% of greenhouse gas emissions. A transition toward greener cities is often called as one of the solutions to reduce the environmental impact of cities, but also to make the urban environments more liveable, with positive spillovers on the mental and physical health of their population. In this context, the United Nations' Sustainable Development Goals 11.7 [1] indicates the need to make cities more inclusive and safe, but also environmentally sustainable, calling for the universal provision of safe, inclusive, and accessible, green and public spaces. A proper evaluation of this target requires complementing standard average metrics, looking for instance at the surface of green areas per capita within an urban area, with more sophisticated metrics, that are able to capture the interplay between the spatial distribution of both the population and green areas within a city. A few studies on selected cities worldwide highlighted the importance of considering this interplay [2-7]. A recent study on the city of Seoul [3] shows that vast portions of the parks in the city are located in outer areas so that frequent opportunities to visit them are relatively minimal. In general, urban green areas in Seoul are inadequately distributed in relation to population, land use, and development density. By contrast, in the case of Shanghai [6], the degree of accessibility to green areas appears to decrease as we move from the city core to the urban periphery. The authors also found a negative association between the degree of accessibility to green areas and the housing prices, which translates directly into a large environmental inequality, wherein wealthier communities benefit more from green space accessibility than disadvantaged communities. A similar socio-economic, but also ethnic, stratification is observed in the city of Chicago, where white-majority census tracts generally enjoy a significantly higher degree of accessibility to green areas than minority-dominated census tracts [7]. The former ethnic group also presents a lower income-based green-areas accessibility inequity compared to the other racial-ethnic groups. Efforts to move beyond case studies and provide more accurate cross-country indicators have led to the construction of the 'generalised potential access to green areas’ from the European Commission, which is provided as one of the city-level indicators of the Global Human Settlement - Urban Centers Database [8]. The metric measures the proportion of the urban population for urban centers included in the atlas living in high green areas. Based on satellite data on the Normalized Difference Vegetation Index, the metric is however agnostic with respect to the characteristics of these high green areas - for instance, whether these are public or private green areas - and any accessibility notion, since the metric does not consider that people can move from their residential location. These limitations are accounted for in a recent study for the European Environmental Agency [9], whose geographical coverage is however limited to specific urban hotspots in Europe, for which high-resolution land use data from the Urban Atlas (https://land.copernicus.eu/local/urban-atlas) is available. With its worldwide coverage and detailed mapping, the use of land use and street network data from OpenStreetMap [10] allows to expand the analysis beyond the European boundary. Our study provides a threefold contribution in this direction. First, we compare detailed high-resolution land use data on green uses for European hotspots included in the Urban Atlas with land use-related tags in OpenStreetMap for similar geographical areas. We use similarity indices to assess the degree of completeness of the OSM tags of natural land uses in urban environments and show how the quality varies according to the type of natural use and the size as well as the geographical area of the urban center under consideration. Second, we propose a framework for the monitoring of the target fo

Cities worldwide encourage urban active mobility by advocating policy and planning. Although contribution is evident, in practice, these actions disregard population parts that have mobility impairments. This research suggests using OpenStreetMap data in customized analytical models to assess the accessibility level of the urban environment for visually impaired pedestrians. Models results show the existence and spatial distribution of existing accessibility problems, including challenging street network connectivity and dangerous walking areas. These models can be used to enable decision makers, city stakeholders and practitioners to enrich management, monitoring and development of their cities, and support sustainable, livable lifestyles and walkability equality. Many efforts that include city policy and planning strategies are implemented to encourage urban active mobility. The outcome of these actions is measured by how transportable and accessible the city is. Although contribution is evident, in practice, the commonly used measures mostly disregard a huge part of the population that have mobility impairments, which require specific accessibility needs, preventing them to be an equal part of the sustainable city vision. This research suggests using OpenStreetMap (OSM) data in customized analytical models to assess the accessibility level of the urban environment for visually impaired pedestrians. In principle, the models analyze the city on two levels: routing and accessibility. These are evaluated, correspondingly, based on possible routes, e.g., how long the optimal route is for visually impaired pedestrians compared to the shortest one, and on area, e.g., what is the overall accessibility and safety of a predefined urban extent. The play of both measures enables us to quantify the level of mobility and accessibility of the analyzed city. To do so, we implement the following steps: 1. We examine the navigation preferences of visually impaired pedestrians in the urban space. This allows a better understanding of the various environmental and morphological factors and characteristics of the urban form that promote safe and accessible navigation. These are translated into spatial and temporal criterion: a) Way Type, which quantifies how suitable the path is in terms of usage and safety; b) the existence of Vision Impairment Assistive Landmarks that support safe wayfinding and navigation; c) Way Complexity, which measures the level of linearity of the path; and d) Crowdedness, which measures the overall pedestrian traffic volume. 2. We transform OSM’s street network into a weighted graph, where for each graph edge we calculate the cost according to the above criteria. Cost is derived from segments that facilitate safe and accessible walking for visually impaired pedestrians (e.g., separated sidewalks and straight paths), and segments that hinder safe and accessible walking for visually impaired pedestrians (e.g., shared and overcrowded streets). 3. We develop three analytical models that measure the accessibility level of the urban environment for visually impaired pedestrians: a) street-based, which relies on averaging the costs of all graph edges for a given area, hence it can be implemented for different urban levels (spatial extents); b) centrality-based, which adds on the street-based the centrality indices betweenness and closeness that consider the significance of each graph edge in the street network in respect to all other edges (high centrality values mostly signify streets that attract large pedestrian traffic flow); c) route-based, a navigational method, in which numerous routes are generated on the graph for location tuples, and then the weight ratio of the optimal route for visually impaired pedestrians and the shortest route (commonly used for seeing pedestrians) is evaluated. The smaller the weight value, the more accessible the route. The developed models are evaluated for Greater London, the UK. 33 boroughs with their wards are analyzed, resulting in processing 421,107 streets, 377,164 OSM nodes and 634, 871 OSM ways. Results show the existence and spatial distribution of accessibility problems for visually impaired pedestrians. The street-based model highlights the fact that urban nature and green spaces, which are typically considered as contributing to wellbeing and encourage walking, are less accessible for visually impaired people, mostly due to the existing road types, e.g., gravel and dirt roads or shared spaces (bikes and pedestrians that share the same path), which are less accessible for this population. The centrality-based model shows that central streets are mostly more accessible, meaning that borough centers are considered in general as accessible, but as distance from city centers grows, the urban environment becomes less accessible. The route-based model, where more than 1,500,000 routes (with length shorter than 1,000 meters) were calculated, showed that on average the

As part of a larger endeavour to make floor plan representations from building models available for indoor map and navigation services, we study the integration of IFC and OSM. # Introduction, background, motivation Official geo data is increasingly published not only in the form of 2D maps, but also in 3D, mainly as city models in CityGML. Usually the outer shell of buildings is captured in such models, but they may also involve more intricate detail. Even more detailed building models are generated during the planning process for new buildings and renovations. These are nowadays produced in digital form, archived in as-built phase by owners and operators for the life time of a building and, in the future, may even be required to be submitted for building permits. At the same time there is an increasing public interest in detailed information about public and semi-public interior spaces, for example about their accessibility, localization of barriers or targets (e.g. contact persons in public administration, shops in malls, booths on fairs, markets or larger info events, departments or hospital wards) or resources (e.g. books in libraries, charging stations, fire equipment or defibrillators) or to get a first impression in advance (e.g. virtual open day). The interest and the points of interest may be temporary or permanent. Since the context of creating and capturing geo data and building data is fundamentally different, there is hardly any integration. Indoor data for maps and navigation models is manually captured or at best derived in undocumented multi-step semi-automatic workflows. # Aim and purpose of the study The project "Level Out" sets out to develop automated methods and services to make detailed indoor data from digital building models selectively available for the population of city models, map and navigation services (in the form of 2,5 D floorplans). Towards this end, we are developing a platform to check building models whether they are suitable and contain required data, extract selected and simplified indoor data and convert it into various formats: CityGML LOD0 (Indoor), IndoorGML and OSM Indoor. As input we rely on data in the format IFC (Industry Foundation Classes), the most widespread standard format for digital building models. Indoor OSM, in particular geometry with Simple Indoor Tagging, is one of the various extraction targets. The data created may not be directly fed into OpenStreetMap, but serve as a viable base for further mapping. There are already older solutions, e.g. BIMServerOsmSerializer (<https://github.com/BIMDataHub/BIMServerOsmSerializer>), which are only built for a version of IFC, which has been a long time standard version, but currently approaches towards its end of life: IFC2x3. There are also solutions under active development, e.g. the JOSM plugin "Indoor Helper" (<https://wiki.openstreetmap.org/wiki/JOSM/Plugins/indoorhelper>), which, however, lack some general approach on the IFC side and coverage of the heterogeneous options to represent geometry in the IFC schema. With this research and development we aim to provide a workflow and software to systematically access floorplan data in IFC. # Methodology We start from both ends of integration by looking at the detailed structures of the source and target models in parallel. From the group of target models, we derive a common model, which will have, at best, near-trivial mappings to OSM Indoor, CityGML, IndoorGML. Although not strictly necessary for the IFC-to-OSM conversion case or any other bilateral integration, the intermediate model will not only allow to tackle integration of IFC with multiple targets besides OSM, but also integration of OSM with multiple sources besides IFC. Next, we identify relevant information in the source model. IFC exposes a wide variety of geometry modelling constructions from CAD software, mainly following the modelling paradigm of constructive solid geometry (CSG). So far, we found the following principle representation options: a) Direct floorplan representation in 2.5D: Here we have 2D representations located in 3D space, usually located at the level of the floor finish for a particular storey. There are two versions to be distinguished: space boundaries versus abstract representations of space-defining elements. b) Extraction from CSG: Spaces (as well as constructive elements) are often represented as solids resulting from extrusion of a planar shape. If extruded in z-direction, the base shape can be extracted and used as 2.5-D representation. c) Projection onto floor level: If the geometry is not in CSG-form with extrusions, but in BREP (boundary representation), then projection followed by a simplification of the projection result is a possible way to extract. In addition to the geometric elements, there are semantic elements connected to the geometry that are connected themselves and can be used to charge the geometric model elements with m

This talk will cover topics related to providing relevant recommendations to users. We don’t aim to declare one recommendation method as the best but instead highlight different approaches to enriching recommendations by combining machine learning with graph databases. The methods we evaluate include: - Matrix Factorization with Graph Embeddings - Content-based TFIDF - Cosine Similarity with AQL and User Ratings The talk will briefly cover the methods and how we generated the distance metrics and provide notebooks that go into further detail. We will show how we integrated these findings into a frontend application for movie recommendations. The talk aims to show how pairing machine learning with graph databases can improve the quality of recommendations and offers some insights into the challenges of productionizing machine learning models. Topics: Machine Learning, Python, Data science, MLOps, Visualization about this event: https://programm.froscon.org/2022/events/2735.html

The lack of data on the distribution of the water resources, possess a great challenge for the water resource investment and AI/ML-enabled advancements in the water sector compared to all other sectors like heath. This paper describes the methodology for combining different water mapping schemas to create comprehensive multi-platform water infrastructure data and enhance rapid updates to support a suite of water resource analytics and extended advanced technology explorations towards improved decision-making. Access to clean and safe drinking water is critical to public health and socioeconomic prosperity, yet an estimated quarter of the world’s population lacks such. This was evidenced by the unprecedented outbreak of the COVID-19 pandemic, which left communities extremely vulnerable to fatal illnesses due to the limited access to water for handwashing or lack of knowledge of the existence of the utility. Subsequently, the lack of data on the distribution of the water resources poses a great challenge to the water resource investment and AI/ML-enabled advancements in the water sector compared to all other sectors like heath. Influencing the frequency of water point data collection through crowdsourcing and volunteered geographic information, would greatly improve the availability of water point data, and contribute to the extended roles of water resource distribution, monitoring, and management especially in rural communities. Therefore, this paper describes the methodology for combining different water mapping schemas to create comprehensive multi-platform water infrastructure data and enhance rapid updates to support a suite of water resource analytics and extended advanced technology explorations towards improved decision-making. The recent technological advances including the web 2.0, cameras, smartphones and sensor networks continue to empower the development of empirical methods as well as the generation of big data and analytical platforms that provide predictive performance on the various socioeconomic needs for sustainable development. OpenStreetMap (OSM) is a crowdsourcing platform which offers a collaborative experience through its database, community, and wiki platforms, to create and update data relevant to support or transform various data deficiencies whether humanitarian or planning. However, the project’s data quality shortcomings often hinder simultaneous data integration with other analytical platforms such as the Water Point Data Exchange (WPdx) that would explicitly maximize the usage and application of these crowdsourced data. Through a project dubbed ‘Water Infrastructure Mapping Uganda’, a data model based upon open mapping methods and survey tools was developed to facilitate the mapping of water infrastructure data points and simultaneous updates of both the WPdx and OSM databases. The project engaged a comprehensive review of the OSM water tag, rural water infrastructure data standards and the WPdx database to generate a survey data form that supported one-time collection of a water point for both OSM and WPdx databases. Underlying the development of the data model/schema in the overall project, a design criterion was established which guided and justified the overall selection of the most relevant factors to include in the process that would eventually become detailed to communicate water infrastructure and functionality. The criteria were followed by an assessment of the; compliance [agreement of the tag], consistency [temporal and spatial representation of the tag], completeness [attribute description of the tag], and granularity [quality of the event information] of the OSM tag to support the development of the. osm language in the Kobo toolbox. Gulu district, located in the North of Uganda, was identified as a potential pilot area for improving the approach created by the project based on its rich WPdx footprint as well as a well-established OSM community of YouthMappers. Up to date satellite imagery of up to 50cm spatial resolution was acquired through the USAID GeoCentre to facilitate any visual detection of water points, and the digitization of base map data including, buildings, roads and waterways, to be employed in the field mapping exercise. A field mapping workflow was designed to facilitate the field-data collection employing the developed water infrastructure data model and Kobo toolbox. An API link was developed that simultaneously tapped the open-source field collected data into the WPdx database. Through the project, more than 15000 buildings, 1400square kilometres of roads and over 500 water data points were added to OSM as well as the WPdx database for the later data. Also, from the project, several observations were made regarding the improvement of such processes and the extension of the data model beyond one geographical area. The developed workflows characterized and provided a general improvement in the water infrastructure data quality especially for OSM

Bei der Eisenbahn wird seit ungefähr 150 Jahren Sicherheit (=Safety) gelebt. Seit kurzem kommen diese komischen Nerds und wollen der Bahn ihre Sicherheit (=Security) beibringen. Das muss ja schiefgehen, oder? Ein hoffentlich sehr unterhaltsamer Überblick über die Bahn und die Herausforderungen der Informationssicherheit bei der Bahn Die Eisenbahn ist der faszinierendste Verkehrsträger der Welt. Gleichzeitig ist das System Rad-Schiene die ökologischste Form des Transports wenn das Fahrrad nicht mehr ausreicht. Die Politik verlässt sich darauf, dass wir bei der Eisenbahn in den nächsten Jahren viel mehr Güter und Menschen umweltfreundlich an ihr Ziel bringen. Damit das klappt, müssen wir das Schienennetz in Deutschland umfassend digitalisieren, ohne die hohe Zuverlässigkeit und Sicherheit der Eisenbahn zu riskieren. Im Vortrag berichte ich aus der Praxis der Informationssicherheit der DB Netz AG, wie wir an der Zukunft des digitalen Schienennetz arbeiten und von 150 Jahren gelebter Fehlerkultur bei der Eisenbahn profitieren um die Zukunft der Bahn sicher zu gestalten. about this event: https://programm.froscon.org/2022/events/2758.html

The CrypTool Team is in the middle of finishing the new edition of the CrypTool-Book at the moment. We added/updated many SageMath Examples, some of which will be shown and also provided for trying them out by yourself. The CrypTool Book is an Open-Source-Project containing texts from various authors about many topics of cryptography, via LaTeX all in one PDF, together with a lot of SageMath Examples. In addition, there are instructions on how to try them out in the various software versions of the CrypTool family (including CrypTool 1, CrypTool 2, JCrypTool and CrypToolOnline) for all the methods discussed. The book has been around since the year 2000. It is available in two languages ​​(English and German), now has over 600 pages and typesetting the file takes between 8 and 30 minutes, depending on the computer. It contains a comprehensive literature section, maths, and a lot of code examples. We will walk through some of the SageMath Code Examples contained in the book. We will NOT give an introduction to SageMath, you should have it installed already if you want to try out the examples treated in the talk. about this event: https://programm.froscon.org/2022/events/2808.html