Today is rest day, in all dimensions.
So why not computing the administrative areas around the world I've visited while running and cycling with @duckdb #SQL and a bit of #Java
https://github.com/michael-simons/biking3/blob/main/bin/collect_administrative_areas.java#L210
Doing all the #spatial stuff directly from within the db, working on temp tables.
Eventually getting a deeply nested #JSON structure out of it:
Thanks @lukaseder for inspiration, @hannes for that piece of tech :)
