Haven't had time to check out cool new technology recently, but decided to try parquet and DuckDB-WASM for cheap interactive Canada-wide dot-density maps. This is running in the browser backed by remote hosted parquet. Still lots of room for improvement, but this already works quite well.
Haven't had time to check out cool new technology recently, but decided to try parquet and DuckDB-WASM for cheap interactive Canada-wide dot-density maps. This is running in the browser backed by remote hosted parquet. Still lots of room for improvement, but this already works quite well.
0 views
Published on 11/10/2026 18:38
0:17
Haven't had time to check out cool new technology recently, but decided to try parquet and DuckDB-WASM for cheap interactive Canada-wide dot-density maps. This is running in the browser backed by remote hosted parquet. Still lots of room for improvement, but this already works quite well.
2 comments
?
It's an amazing combo! And just seems to keep getting better.
By-product of this: Verifying how census geographies match up against other data sources like the NAR, RNF, ODB, RQA, GHSL. Good news, generally quite well. Some issues in rural areas. The one exception is urban Toronto where the census geographies have problems. E.g. this sliver.
How much data in Canada is available at that level of granularity? Last time I did a national data-viz (Miles Corak's merger of census + tax to produce mobility geographies) the closest we could get was census division (Greater Toronto has five). Americans could get it down to street or closer.
Still struggling with clean matching and identification. Most work out quite well, but lots of edge cases to check in and verify. Could also spread out the jitter radius for dwelling units in large buildings to smooth things out a bit. Or bring in building footprint data, but that has quirks too.