Michael Simons<p>Today is rest day, in all dimensions.</p><p>So why not computing the administrative areas around the world I've visited while running and cycling with <span class="h-card" translate="no"><a href="https://mastodon.social/@duckdb" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>duckdb</span></a></span> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> and a bit of <a href="https://mastodon.social/tags/Java" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Java</span></a> </p><p><a href="https://github.com/michael-simons/biking3/blob/main/bin/collect_administrative_areas.java#L210" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/michael-simons/biki</span><span class="invisible">ng3/blob/main/bin/collect_administrative_areas.java#L210</span></a></p><p>Doing all the <a href="https://mastodon.social/tags/spatial" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>spatial</span></a> stuff directly from within the db, working on temp tables. </p><p>Eventually getting a deeply nested <a href="https://mastodon.social/tags/JSON" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>JSON</span></a> structure out of it:</p><p><a href="https://github.com/michael-simons/biking3/blob/25fd2c462954395f84ca3ec5fd4f81851746caa0/schema/api.sql#L632-L673" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/michael-simons/biki</span><span class="invisible">ng3/blob/25fd2c462954395f84ca3ec5fd4f81851746caa0/schema/api.sql#L632-L673</span></a></p><p>Thanks <span class="h-card" translate="no"><a href="https://mastodon.social/@lukaseder" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>lukaseder</span></a></span> for inspiration, <span class="h-card" translate="no"><a href="https://discuss.systems/@hannes" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>hannes</span></a></span> for that piece of tech :)</p>