Welcome to ohsome-data-insights Workshop @ SOTM 2024

This workshop teaches you how you can accelerate OSM data analysis without the need to run your own computing cluster. We will provide a sneak preview about our new cloud hosted ohsome full history contributions data and will show you how can use it to understand the dynamics in OSM.

Contact

Benjamin Herfort benjamin.herfort [at] heigit.org
Michael Auer michael.auer [at] heigit.org
Rafael Troilo rafael.troilo [at] heigit.org

HeiGIT gGmbH, affiliated Institute at Heidelberg University

Heidelberg Institute for Geoinformation Technology

Berliner Str. 45 (Mathematikon)

D-69120 Heidelberg

ohsome Team- ohsome [at] heigit.org

---

Getting Started

• Why should you be excited about ohsome-data-insights?
• Connect to MinIO Object Store
• Connect to Apache Iceberg
• Data Structure

Data Extraction

• Download latest OSM data as GeoPackage

Simple Data Analysis

• Currentness of Buildings
• Vandalism Detection for LineStrings
• Attribute Completeness for Street Surface Tags

Data Integration

• HOT Tasking Manager project analysis
• Mapillary Coverage Analysis

Advanced Data Analysis

• Corporate Edits Analysis
• User activity map
• Road Network Evolution

Background

• Partitioning and Sorting
• DuckDB: Currentness of Buildings
• DuckDB: Data Extraction from geo-sorted ohsome contributions