Full text
Analysis of the weeklyOSM profile over the last ten years with PostgreSQL Dr. Raquel Dezidério Souto Editor for the pt-BR version of the weeklyOSM weeklyOSM-stats IVIDES DATA Manila, Philippines October 3-5, 2025 State of the Map 2025
At the beginning of the weeklyOSM Actual workflow The OSM Blog Collector (OSMBC) Scope and general objective Methodology General results Selected software results Final considerations Analysis of the weeklyOSM profile over the last ten years with PostgreSQL weeklyOSM-stats
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL At the beginning of the weeklyOSM... “Overcoming language barriers with OpenStreetMap” Teachers and students of the EU-funded Comenius project MychOSM. Coordination: Geschwister-Scholl-Schule BBS Saarburg (Rhineland-Palatinate). Contact person: Manfred Reiter. [Source] 3 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL At the beginning of the weeklyOSM... EuYoutH OSM (2018-2020/22) Five schools from European countries (Ireland, Portugal, Spain, Romania and Germany) integrate the European YoutHumanitarian OpenStreetMap. In this photography, participating in the State of the Map 2019. Coordination: Heidelberg Institute for Geoinformation Technology - HeiGIT. Contact person: Manfred Reiter. [Source] 4 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL At the beginning of the weeklyOSM... 2010 - Start of the Wochennotiz 2014 - Start of the weeklyOSM (edition #219) as a spin off the MychOSM project 2015 - First edition of the weeklyOSM produced with OSMBC (edition #272) Some weeklyOSM milestones 5 of 24
Revision process by human (50+ Reviewers) Two or more reviewers completed your review English to other 13 languages translation (personal or automatic translation by DeepL®) Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL Send a link by the OSM Blog Collector Actual workflow Editor/User find something interesting Publish Share to Mailing lists, RSS, Mastodon and other social media Drafting the articles 6 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL The OSM Blog Collector (OSMBC) by TheFive, which has been designing, programming and continuously improving OSMBC for the last ten years 7 of 24 https://github.com/TheFive/osmbc https://www.openstreetmap.org/user/TheFive
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL Scope and general objective of our analysis The objective of this analysis is obtain the content profile of the weeklyOSM, by processing the articles dataset using PostgreSQL. So, we are interested in obtain the general profile and prospect the most cited categories and softwares, considering the period from 2015 (WN272) to 2025 (WN768), since the adoption of the OSM Blog Collector (OSMBC). But why calculate it? These statistics can be a proxy for understanding the use of OSM-related software by the OSM mappers community and which categories have received the most attention in various media, such as social networks, blogs, OSMF channels or institutional websites, all belong to the OSM ecosystem. 8 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL PostgreSQL Database Methodology CSV files (articles extraction 272 to 768) Data Processing with SQL Initial cleaning - selection of the editions 272 to 768 Standardizing categories Article selection based on selected software Validation of the software list with specialists Dataset Analysis - generation of the statistics Visualization of results and documentation Generation of graphics Documentation of the project - GitHub Dissemination weeklyOSM - issue 769 State of the Map 2025 State of the Map Africa 2025 9 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL Selected software results 16 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL Selected software results 17 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL Selected software results 18 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL Selected software results 19 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL Selected software results 20 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL Final considerations The project has grown a lot in the last 10 years, and today reaches 14 languages with translations from the English. In addition to a large group of editors (52 persons) by the weeklyOSM Team translate, validate and help to disseminate it. The weeklyOSM covers a wide range of categories, from technical aspects to OSM mappers' community events; And covers a wide range of softwares, on pratically all groups - editors, conversors, quality analysis, extractors... The results of the occurrence of software per group show the predominance of free and open software, which is the same philosophy of the weeklyOSM. 21 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL Contributors to this research Raquel Dezidério Souto - Conception of the research object, methodology, data processing and presentation. TheFive - Export of the weeklyOSM dataset and OSMBC maintenance. Strubbl, MatthiasMatthias - Validation of the software list. Manfred Reiter - General revision. To know more https://wiki.openstreetmap.org/wiki/WeeklyOSM https://umap.openstreetmap.fr/en/map/weeklyosm-is-currently-produced-in_56718#2/14.8/-34.1 https://erasmusplus.schule/foerderung/erfahrungsberichte/open-street-map How to contribute Send a link by the OSM Blog Collector (OSMBC) https://osmbc.openstreetmap.de/article/create 22 of 24
Analysis of the weeklyOSM's profile over the last ten years with PostgreSQL Reference of the images p. 2 - Top-Down: cover picture of the weeklyOSM's issues: 759, 763, 767 e 770. p. 3 - Manfred Reiter and students of the Comenius school project. https://weeklyosm.eu/wp-content/uploads/2015/02/Comenius-Gruppenfoto-2014.jpg p. 4 - Manfred Reiter and students taking part in the State of the Map 2019. p. 5 - Logos in the first issue <https://blog.openstreetmap.de/blog/2010/07/osm-wochennotiz-nr-1/> and actually <https://weeklyosm.eu/editorial-page>. p. 6 - Free Canva icons. p. 7 - Screenshot of the OSM Blog Collector homepage <https://osmbc.openstreetmap.de/login>. P. 9 - Free Canva icons. Disclaimer: all images have open licenses that are compatible with the Creative Commons Attribution International 3.0 or later (CC BY 3.0+) 23 of 24
Thank you! IVIDES DATA Creative Commons Attribution International 3.0 or later (CC BY 3.0+) Dr. Raquel Dezidério Souto Editor for the pt-BR version of the weeklyOSM https://ivides.org/raquel-deziderio Manila, Philippines, October 3-5, 2025
