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:

• Existing approaches such as the Export Tool
• Why FlatGeobuf is a suitable forwards-thinking format
• Computational challenges for processing global-scale relations
• A new open-source program, Protoshapes, to generate admin polygons in FlatGeobuf format
• Efficient approaches for global datasets such as coastlines, oceans, and road connectivity
• Frequently updating datasets using the open-source OSM Express database