Thanks!

Seems like you get centroid of changeset and reverse geocode it and get country from that.

It’s exactly this! I’m taking the center of the “square” defined in the changeset bounding box.

I would have tried either assigning all countries intersecting changeset or only adding countries to changesets that are completely within the borders (maybe with some buffer)

I would not overthink this, since most of the subsets are scoped on a district / city. It’s from OSM best practices to create changesets that “should be local.” (source: osm.wiki/Changeset).

Also, people have requested me few things that seems to be doable with your tool :

• An overview for a particular country: the idea would be to have the same set of graphs, and just be able to select the country as a variable (like from a dropdown)
• Same for a particular username

Hello! Great work :)

I did something similar but converted in JSON instead of Parquet, and then leveraged Datadog to create some charts. You can see the MVP here : osm-monitor.com.

There is as well a dashboard focused on editors.

Hope this can give you some ideas.

Happy to sync with you to continue the discussion ! Cheers