OpenStreetMap contributor metrics

[dhimmel]

It would be great to have some stats like:

• XX OpenStreetMap accounts have contributed to ski areas, with YY changesets within the last year
• Top OSM contributor per ski area
• Distribution of age of last edit for ski area nodes and ways

Best place to start is likely extracting the OpenSkiMap OSM sources information.

[dhimmel]

Here are some example run/ski area sources (code below):

• https://www.openstreetmap.org/relation/6981791
• https://www.openstreetmap.org/way/1086387374
• https://www.openstreetmap.org/way/1120228854
• https://www.openstreetmap.org/way/1137312157

It would be great to get the history of changesets for each way and relation containing:

• changeset id
• user
• date
• counts of nodes and ways changed (less essential)

Expand for code

import polars as pl
from openskistats.analyze import load_runs_pl, load_ski_areas_pl
import random

run_sources = (
    load_runs_pl()
    .explode("run_sources")
    .select(
        "run_id",
        "run_name",
        "ski_area_ids",
        pl.col("run_sources").alias("run_source"),
    )
    .collect()
)

ski_area_sources = (
    load_ski_areas_pl()
    .explode("ski_area_sources")
    .select(
        "ski_area_id",
        "ski_area_name",
        pl.col("ski_area_sources").alias("ski_area_source"),
    )
    .filter(pl.col("ski_area_source").str.starts_with("https://www.openstreetmap.org"))
)

osm_sources = sorted(set(ski_area_sources["ski_area_source"]) | set(run_sources["run_source"]))

for x in sorted(random.Random(4).sample(osm_sources, 10)):
    print(f"- {x}")

[dhimmel]

Noting that there are potentially two ways to approach this:

1. via single-way/relation queries to api.openstreetmap.org as proposed in Get changsets for the osm ways and relations #27
2. By downloading history-latest.osm.pbf, currently 133 GB and using a tool to subset/process this dataset like osmium.