Nice, I did not know about polygonToCellsExperimental. As for DuckDB & rtree, it's alas not a replacement of postgis yet and the indices cannot be used (yet) i

Nice, I did not know about polygonToCellsExperimental. As for DuckDB & rtree, it's alas not a replacement of postgis yet and the indices cannot be used (yet) in joins. In fact, I even have workflows where I iterate over rows in python and run duckdb queries one after the other rather than joining in just one query because of this very issue.