Building a State-Level Rollup From OpenStreetMap Surveillance Tags
If you have ever built a "counts by state" page on top of OpenStreetMap data, you learn quickly that the hard part is not the query. It is deciding what a count means, and then making every derived number carry…