{"guid":"533f1d14-81e5-5b87-ad38-8bf0bdb0c9cc","title":"Innovating on derivative OpenStreetMap datasets","subtitle":null,"slug":"sotm2022-18481-innovating-on-derivative-openstreetmap-datasets","link":"https://2022.stateofthemap.org/sessions/VXECJQ/","description":"OpenStreetMap consists of tagged nodes, ways and relations. Many use cases of geographic data, however, need a tabular dataset of points, lines and polygons. Processing OSM into derivative datasets is a crucial task that can benefit from new tools and formats. This talk will cover several topics around this theme, including:\n\n* Existing approaches such as the Export Tool\n* Why FlatGeobuf is a suitable forwards-thinking format\n* Computational challenges for processing global-scale relations\n* A new open-source program, Protoshapes, to generate admin polygons in FlatGeobuf format\n* Efficient approaches for global datasets such as coastlines, oceans, and road connectivity\n* Frequently updating datasets using the open-source OSM Express database","original_language":"eng","persons":["Brandon Liu"],"tags":["sotm2022","18481","2022","Software Development","OSM","OpenStreetMap"],"view_count":64,"promoted":false,"date":"2022-08-19T14:30:00.000+02:00","release_date":"2022-09-21T00:00:00.000+02:00","updated_at":"2025-09-22T00:15:08.211+02:00","length":1556,"duration":1556,"thumb_url":"https://static.media.ccc.de/media/events/sotm/2022/18481-533f1d14-81e5-5b87-ad38-8bf0bdb0c9cc.jpg","poster_url":"https://static.media.ccc.de/media/events/sotm/2022/18481-533f1d14-81e5-5b87-ad38-8bf0bdb0c9cc_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/sotm/2022/18481-533f1d14-81e5-5b87-ad38-8bf0bdb0c9cc.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/sotm/2022/18481-533f1d14-81e5-5b87-ad38-8bf0bdb0c9cc.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/sotm2022-18481-innovating-on-derivative-openstreetmap-datasets","url":"https://api.media.ccc.de/public/events/533f1d14-81e5-5b87-ad38-8bf0bdb0c9cc","conference_title":"State of the Map 2022","conference_url":"https://api.media.ccc.de/public/conferences/sotm2022","related":[],"recordings":[{"size":122,"length":1556,"mime_type":"video/webm","language":"eng","filename":"sotm2022-18481-eng-Innovating_on_derivative_OpenStreetMap_datasets_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2022-09-21T22:10:08.724+02:00","recording_url":"https://cdn.media.ccc.de/events/sotm/2022/webm-hd/sotm2022-18481-eng-Innovating_on_derivative_OpenStreetMap_datasets_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/61892","event_url":"https://api.media.ccc.de/public/events/533f1d14-81e5-5b87-ad38-8bf0bdb0c9cc","conference_url":"https://api.media.ccc.de/public/conferences/sotm2022"},{"size":58,"length":1556,"mime_type":"video/webm","language":"eng","filename":"sotm2022-18481-eng-Innovating_on_derivative_OpenStreetMap_datasets_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2022-09-21T21:47:17.145+02:00","recording_url":"https://cdn.media.ccc.de/events/sotm/2022/webm-sd/sotm2022-18481-eng-Innovating_on_derivative_OpenStreetMap_datasets_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/61891","event_url":"https://api.media.ccc.de/public/events/533f1d14-81e5-5b87-ad38-8bf0bdb0c9cc","conference_url":"https://api.media.ccc.de/public/conferences/sotm2022"},{"size":40,"length":1556,"mime_type":"video/mp4","language":"eng","filename":"sotm2022-18481-eng-Innovating_on_derivative_OpenStreetMap_datasets_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2022-09-21T21:33:04.692+02:00","recording_url":"https://cdn.media.ccc.de/events/sotm/2022/h264-sd/sotm2022-18481-eng-Innovating_on_derivative_OpenStreetMap_datasets_sd.mp4","url":"https://api.media.ccc.de/public/recordings/61890","event_url":"https://api.media.ccc.de/public/events/533f1d14-81e5-5b87-ad38-8bf0bdb0c9cc","conference_url":"https://api.media.ccc.de/public/conferences/sotm2022"},{"size":23,"length":1556,"mime_type":"audio/mpeg","language":"eng","filename":"sotm2022-18481-eng-Innovating_on_derivative_OpenStreetMap_datasets_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2022-09-21T21:31:03.957+02:00","recording_url":"https://cdn.media.ccc.de/events/sotm/2022/mp3/sotm2022-18481-eng-Innovating_on_derivative_OpenStreetMap_datasets_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/61889","event_url":"https://api.media.ccc.de/public/events/533f1d14-81e5-5b87-ad38-8bf0bdb0c9cc","conference_url":"https://api.media.ccc.de/public/conferences/sotm2022"},{"size":88,"length":1556,"mime_type":"video/mp4","language":"eng","filename":"sotm2022-18481-eng-Innovating_on_derivative_OpenStreetMap_datasets_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2022-09-21T21:28:41.919+02:00","recording_url":"https://cdn.media.ccc.de/events/sotm/2022/h264-hd/sotm2022-18481-eng-Innovating_on_derivative_OpenStreetMap_datasets_hd.mp4","url":"https://api.media.ccc.de/public/recordings/61888","event_url":"https://api.media.ccc.de/public/events/533f1d14-81e5-5b87-ad38-8bf0bdb0c9cc","conference_url":"https://api.media.ccc.de/public/conferences/sotm2022"}]}