Chaos Computer Club - archive feed

aktueller Streit in der Ampel | das EU-Urteil am 20.9. | „gezielte“ & IP-Vorratsdatenspeicherung Am 20. September wird der EU-Gerichtshof sein Urteil über die deutsche Vorratsdatenspeicherung verkünden. Wenn das Gericht keinen Kurswechsel vornimmt, wird das aktuelle Gesetz als unvereinbar mit Unionsrecht gekippt werden, weil es eine anlasslose, unterschiedslose und generelle Speicherpflicht von Telefon- und Standortdaten vorsieht. Über die Frage, wie es danach weiter geht ist im Vorfeld zu dem Urteil in der Ampel ein offener Streit ausgebrochen: Justizminister Buschmann (FDP) will die Kommunikations-Massenüberwachung abschaffen, aber Innenministerin Faeser (SPD) will an einer IP-Vorratsdatenspeicherung festhalten. In seinem Talk erklärt der EU-Abgeordnete Dr. Patrick Breyer warum der deutsche Streit wichtig für die Zukunft der Vorratsdatenspeicherung in der EU ist und er warnt vor einer neuen Generation von Gesetzen zur Vorratsdatenspeicherung. about this event: https://talks.datenspuren.de/ds22/talk/9GVP8F/

Laut Han Solo sind Wookies dafür bekannt, dass sie ihren Mitspielern die Arme ausreißen, wenn diese zu oft gewinnen. In der Popkultur um Spiele hat sich daraus der Begriff des Wookiefaktors entwickelt. Was sich dahinter verbirgt und welche Auswirkungen dieser aufs Spiel haben kann, erfahrt ihr in diesem Vortrag. about this event: https://cfp.fairydust.reisen/iger-2022/talk/YFNMKV/

Jeder kann dazu beitragen, sein Lieblingsgerät von einem Vendor-Lock zu entfernen. Neuere Hardware verbindet sich immer häufiger zu Servern und holt sich Updates sowie Informationen von diesen. Solange diese Server noch existent sind, ist auch alles in Ordnung. Problematisch wird es, wenn der Anbieter insolvent geht, oder entscheidet das Produkt nicht mehr weiterzuführen und damit auch die Server aufzugeben. Das teuer gekaufte Produkt wird zu einem Briefbeschwerer und im schlimmsten Fall Elektroschrott. Im Rahmen des Vortrags soll es um verschiedene Szenarien gehen, wie man mit Reverse Engineering und einer starken Community dagegen wirken kann, um Geräte von einem Vendor-Lock zu befreien. Der Vortrag richtet sich nicht nur an Personen mit technischem Hintergrund, sondern ist auch aufbereitet, um alle in die spannende Welt der Nachhaltigkeit durch Reverse Engineering einzuführen. Jeder kann helfen! about this event: https://cfp.fairydust.reisen/iger-2022/talk/PSCEHJ/

Geschichten erzählen und gestalten mit freier Software In diesem Vortrag möchte ich den Zuhörenden zeigen, wie man Comics gestaltet mit freier Software. Angefangen von Hardware-Anforderungen über Grobkonzept und Gestaltung bis hin zur Reinzeichnung des Comics werden die Schritte einmal dargelegt. about this event: https://talks.datenspuren.de/ds22/talk/J9VMZF/

How do you make applications, websites and networks faster? What efforts and projects have been developed? Let's talk about what network speed is (psst it's not just bandwidth and latency). Slides: https://0x90.space/tamara-iger-talk/ "The internet is so slow today!" Often it is hard to explain why users feel this way. But in this talk I try to cover a few aspects of what makes internet applications feel slow: the networks and the applications. Consumer networks suck. They are complex and contain a lot of bad hardware. From slow uplinks and shared mediums to cheap networking gear, there are plentyful things that can make applications slow. What are bufferbloat, dropped packages and etc. and how do they influence TCP? How can you improve my servers and applications to compensate for this? It's actually not that hard when you write a new application. And if you are hosting, you can tune your OS too. about this event: https://cfp.fairydust.reisen/iger-2022/talk/X8QX3V/

Communication Analysis Team - Ukraine Daily reports are send to the key Ukrainian authorities coordinating the informational frontlines An Analysis for February 24 - April 4 a prerecorded Video Talk no QNA about this event: https://talks.datenspuren.de/ds22/talk/DYGZDG/

Dieser Vortrag beschäftigt sich mit den realen Gefahren intelligenter Systeme, die sich meist hinter den Kulissen abspielen, aber uns alle direkt oder indirekt beeinflussen. Wenn man der Popkultur Glauben schenkt, wird die Menschheit spätestens in den nächsten hundert Jahren von Maschinen unterjocht oder ausgerottet. Dieser Vortrag will zumindest diese Angst etwas nehmen und den Fokus auf die realen Gefahren moderner KI richten. Diese sind meist nicht sofort ersichtlich, können aber einen großen Einfluss auf unsere Gesellschaft haben. Wir werden uns unter anderem ansehen, wie der YouTube-Algorithmus radikale Strömungen begünstigen kann und wie Social Bots unterschwellig unsere Meinung beeinflussen können. Damit es nicht zu pessimistisch wird, gebe ich am Ende Tipps zu einem bewussteren Umgang mit KI. about this event: https://cfp.fairydust.reisen/iger-2022/talk/CZMVAY/

Flexible Virtualisierung mit NixOS about this event: https://talks.datenspuren.de/ds22/talk/TBCPMA/

Eine übersicht über den Handynetzausbau in West-Afrika. Wie gut ist er, wo gibts überall Internet. Ich gebe erst einen grobe Übersicht über meine Afrikareisen und gebe dem Publikum einen Einblick in ein Handynetz, fast ohne Netzlücken auf einem Kontinet, wo auch noch die letzte Strohhütte mit LTE versorgt wird. Ich zeige welche möglichkeiten den Einheimischen diese biedet und welche Vorteile eine flächendeckende Netzabdeckung noch bringen kann. Der Vortrag wird durch Anekdoten meiner Reisen aufgelockert. about this event: https://cfp.fairydust.reisen/iger-2022/talk/HTQYFK/

Was soll schon bei JSON schiefgehen? Es kann viel schief gehen, wenn man nicht aufpasst. JSON ist ein ziemlich einfaches Format, welches gerne fuer Datenuebertragungen zwischen verschiedenen Sprachen eingesetzt wird. Es gilt als einfach und leicht verstaendlich. Diese Einfachheit und etwas klobige Art kann aber zu Probleme fuehren, ueber welche wir in dem Rahmen kurz reden wollen. Die Folien sind auf Englisch, der Vortrag wird aber in Deutsch sein. about this event: https://cfp.fairydust.reisen/iger-2022/talk/CWBYLK/

Talking about how buses and trams communicate over radio and how we extract useful data from it. about this event: https://talks.datenspuren.de/ds22/talk/T78WZT/

Wird die Komplexität von maschinellem Lernen überschätzt? Vielleicht hat der eine oder die andere Programmierer\*in Scheu davor mit maschinellem Lernen ihre Anwendung aufzuwerten. Dazu gibt es eigentlich keine Gründe. Oder doch? Das klassische Programmier\*innen-Handwerk bleibt weiterhin entscheidend. Zunächst gebe ich eine kleine Einführung in Maschinelles Lernen und Neuronale Netze. Anhand eines kleinen Anwendungsbeispiels möchte ich zeigen, dass die Verwendung eines Neuronalen Netzes sehr einfach sein kann. Schließlich möchte ich Beispiele zeigen, bei denen "klassische" Programmierer\*innen-Tätigkeiten entscheidend für die erfolgreiche Anwendung von Maschinellem Lernen ist. Besonders freue ich mich auf die anschließende Diskussion darüber ob ML/KI trivial ist oder nicht. about this event: https://cfp.fairydust.reisen/iger-2022/talk/3X7HFM/

Physikalische Modelle im Wandel der Zeit Modelle mit denen wir unsere Welt zu berechnen Suchen unterliegen immer auch dem Kenntnisstand der jeweiligen Zeit. Der Vortrag diskutiert an Beispielen, welche Probleme wann wichtig genug waren um Ressourcen auf sie anzusetzen. Welche unterschiedlichen Arten von Modellen es gibt und was bei der Erweiterung eines Modells zu beachten ist. Dabei gibt es sowohl Modelle die sich am Rand der physikalischen Erkenntnis bewegen, als auch Modelle die der Reduktion der Komplexit\"at bei der numerischen Berechnung dienen. Eine anekdotische Reise durch die Zeit. about this event: https://talks.datenspuren.de/ds22/talk/7XD3S7/

Digital Natives sind eher digital naiv. Was das bedeutet, und warum digitale Naivität an sich nicht problematisch ist, solange sie nicht bei den Bildungsverantwortlichen auftaucht, ist Inhalt dieses Vortrages. Es wird in der Didaktik immer wieder darüber diskutiert, dass Jugendliche heutzutage "Digital Natives" seien, und dass dies den Umgang mit Medien im Unterricht generell verändert. Dieser Umstand wird von Teil der Didaktiker als Ausgangspunkt für eine neue "digitale Didaktik" benutzt. Dabei wird die ganze Zeit von Bildung gesprochen und Möglichkeiten beschworen. Warum diese Annahme eher falsch ist, und die digitale Naivität, die mit dem reinen Benutzen von Geräten einhergeht, eigentlich bedeutet, dass Unterricht mehr Deutungswissen braucht, ist der erste Aufschlag dieses Vortrages, der auch eine Digitaldidaktik kritisieren möchte, die naiv davon ausgeht, dass alles jetzt einfach und anders ist. about this event: https://cfp.fairydust.reisen/iger-2022/talk/M8TEQR/

Die Uni Würzburg betreibt einen hybriden HPC-Cluster mit knapp 100 Knoten. In diesem Vortrag geht es um die administrative Infrastruktur dahinter. Welche Software wird für was verwendet und wie funktioniert das ganze? Der Julia-Cluster der Uni Würzburg besteht aus einem klassischen HPC mit Job-Scheduler und einem Private-Cloud-Teil über OpenStack. Wie wird Julia administrativ betrieben? Was ist dafür notwendig? Wie reagiert man auf eventuell sich ändernde Anforderungen der User und versucht diesen gerecht zu werden? Dieser Vortrag beschäftigt sich mit dem Aufbau und administrativen Betrieb des Julia-Clusters. Stichpunkte hierbei sind: Bare-Metal-Deployment, grundlegende Netzkonfiguration, Storage über BeeGFS und Ceph, OpenStack, SLURM und Ansible. about this event: https://cfp.fairydust.reisen/iger-2022/talk/PDXBAM/

Eine Einführung in DNSSEC und dessen Entwicklung in den letzten Jahren. Mit DNSSEC lässt sich die Integrität und Authentizität von Antworten auf DNS-Queries sicherstellen. Bisher hatte DNSSEC allerdings eher ein Schattendasein gefristet, und keine grosse Verbreitung gefunden. Allerdings hat sich da in letzter Zeit einiges geändert. Dieser Vortrag gibt eine kurze Einführung in DNSSEC und erläutert dessen Entwicklungen in den letzten Jahren. about this event: https://c3voc.de

about this event: https://c3voc.de

In diesem Petit Foo wird ein kurzer Überblick über das Datenmodell der OpenStreetMap gegeben und an einem Beispiel gezeigt, wie man die freie Karte erweitern bzw. verbessern kann. about this event: https://www.chaospott.de

"Kannst du mal eben die Fotos online stellen?" ist ein häufiges Problem. Wenn man die Bilder dann nicht zu Facebook oder in irgendwelchen Messaging-Kanälen ist der erste Griff natürlich zu einer Fotogallerie oder CMS-Software, die man selbst hostet. Allerdings hat man dann wieder einen zusätzlichen Dienst zu betreuen. Ungünstig, wenn man eine Fire-and-forget Lösung sucht, um die man sich nicht mehr kümmern muss. Dafür bieten sich statische Webseiten an, die werden einmal generiert und benötigen keine Updates oder Pflege mehr. Wie man dieses Problem in fünf Minuten abarbeitet erkläre ich in diesem Petit Foo. about this event: https://www.chaospott.de

Die Chatkontrolle ist momentan der größte Angriff auf digitale Grundrechte - und sie ist nicht mal das richtige Instrument für das eigentliche Ziel, konsequenter gegen den Vertrieb von Missbrauchsdarstellungen von Kindern vorgehen zu können. Wir erklären warum es diesen Verordnungsentwurf eigentlich gibt und was er wirklich bedeutet. Weiter wollen wir auf die Gefahren bei der Umsetzung aufmerksam machen und erklären was passieren muss damit wird das Schlimmste verhindern können. about this event: https://c3voc.de

about this event: https://c3voc.de

about this event: https://c3voc.de

about this event: https://c3voc.de

In diesem Petit Foo werde ich unter dem Titel "Lessons Learned from Three Years of Petit Foo" im Petit Foo einen Blick auf (mehr als) drei Jahre regelmäßiger Vorträge zurück werfen. about this event: https://www.chaospott.de

about this event: https://programm.froscon.org/2022/events/2824.html

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

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

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

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

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

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 closing session of the State of the Map 2022 conference. about this event: https://2022.stateofthemap.org/sessions/LX3EGF/

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/

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,

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

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

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

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

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

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

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

How much effort does it take to build a Libre bicycle computer? I found out so you don't have to. Jazda.org is a project I started this year. It combines my 3 favorite things: bicycles, Rust the programming language, and tiny, networkless electronics. I will introduce you to the concept of a bike computer, and show why building one differs from building your typical gadget. about this event: https://programm.froscon.org/2022/events/2851.html