Script utlising CARTO H3 support to visualise OSM Edits for the United Kingdom

osm_edit_history.sql

DECLARE
  bbox GEOGRAPHY;
SET
  bbox = (
  SELECT
    geom
  FROM
    `global_boundaries_dataset`
  WHERE
    NAME_EN = 'United Kingdom');
WITH
  h3s AS (
  SELECT
    id,
    `carto-un`.carto.H3_FROMGEOGPOINT(geometry,
      8) AS h3
  FROM
    `bigquery-public-data.geo_openstreetmap.history_nodes`
  WHERE
    ST_INTERSECTS(geometry,bbox))
SELECT
  COUNT(id) AS edit_count,
  h3
FROM
  h3s
GROUP BY
2;