Skip to content

Instantly share code, notes, and snippets.

@allenday

allenday/prolific-users.sql

Created December 27, 2019 05:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save allenday/dbfeaeaa63af3d054a28b2d7149f2fc2 to your computer and use it in GitHub Desktop.
Save allenday/dbfeaeaa63af3d054a28b2d7149f2fc2 to your computer and use it in GitHub Desktop.
Download ZIP
Which users have contributed the most relations to the current version of OpenStreetMap?
Raw
prolific-users.sql
SELECT username, COUNT(*) AS c
FROM
`bigquery-public-data.geo_openstreetmap.planet_relations` AS relations
GROUP BY username
ORDER BY c DESC
@tyrasd
Copy link

tyrasd commented Jan 28, 2020

doesn't this only return the “number of users who are the last modifier of relations in the current OpenStreetMap dataset”, which might be quite a different number from the original question in the description of this query (i.e. “ Which users have contributed the most relations to the current version of OpenStreetMap?”)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment