have you ever wanted to produce a geoparquet database file / from all repositories containing who's on first style documents in a github organization / now you can – https://github.com/whosonfirst/go-whosonfirst-geoparquet

do who's on first places really need to be discoverable via webfinger / I don't know either but in an effort to better understand the shape of things circa late-2022... it will be possible soon – https://github.com/whosonfirst/go-whosonfirst-browser/compare/webfinger

there is now a handy dockerfile / for automating the building of protomaps databases / full of who's on first features for point-in-polygon-ing – https://github.com/whosonfirst/go-whosonfirst-spatial-pmtiles/tree/main/docker

I realize I've been banging on about stuffing who's on first data in to protomaps database files / but it turns out you can fit all the administrative data for every country in the world in to a 4GB file / and then host that file in an S3 bucket which can be queried over HTTP / which means you can not only point-in-polygon any place on the planet / from continents all the way down to microhoods and everything in between / but it's fast (ish), cheap and easy

happy fun screenshot time / to show that a work-in-progress branch of the protomaps implementation of the who's on first spatial interfaces / is caching features so that geometries can be returned to web applications / that tippecanoe is in fact clipping geometries to tile boundaries / and that caching is a boundless font of surprises and potential information leakage

geometries are not being rendered yet because reasons / but here are screenshots of the server tool from the https://github.com/whosonfirst/go-whosonfirst-spatial-www-pmtiles package / point-in-polygon-ing it up using a 1.5GB protomaps database derived from all the who's on first places in US

the bad news is that the blog post about making the who's on first browser tool work as a tailscale virtual private service using protomaps elegantly has been delayed because of heisenbugs / and because it's time to step away from the computer / the good news is that the inelegant way of doing things totally works / screenshots attached