Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Which users have contributed the most relations to the current version of OpenStreetMap?
SELECT username, COUNT(*) AS c
FROM
`bigquery-public-data.geo_openstreetmap.planet_relations` AS relations
GROUP BY username
ORDER BY c DESC
@tyrasd

This comment has been minimized.

Copy link

@tyrasd 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
You can’t perform that action at this time.