A couple of weeks ago I came up with the idea of creating a map with trails that I could use when planning my next run, hike or cycle.
Not finding a tool that suited my needs and having used OpenStreetMaps before, I decided to do it myself.
On top of this I quicly sketched and set up a datapipeline that I could use everytime I want to refresh the data. I put up an integration that extracts data from OSM Overpass Turbo API and loads it into BigQuery, then I run a subsequent task to transform the data into a geoJSON and loads it to this website.
This map is a sample of data which can be improved as needed.