[tylerhannan]

ahhhh...space-filling curves.

With some of the recent work done with ClickHouse this has been an area I've had to learn about and, tbh, wish I had found this earlier.

Our CTO started using Morton curves for interesting purposes several months ago with initially piqued my interest and started me down the path.

https://reversedns.space/ (a map of the Internet) - Morton curve is used as a visualization tool;

https://adsb.exposed/ (a visualizer of air traffic) - Morton curve is used as a database index;

Our most recent release post dove into the usage of Hilbert curves in context of maintaining spatial locality for weather measurements

https://clickhouse.com/blog/clickhouse-release-24-06#hilbert...

Quite an interesting area of study and optimisation!