allenday/OSM-layer-counts.sql

Created September 25, 2019 09:21

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/allenday/884d6ee371e0aba91470710e9a5fb82b.js"></script>
Save allenday/884d6ee371e0aba91470710e9a5fb82b to your computer and use it in GitHub Desktop.

Download ZIP

How many objects are in each OSM layer?

Raw

OSM-layer-counts.sql

	SELECT name, COUNT(name) AS c
	FROM `bigquery-public-data.geo_openstreetmap.layers`
	GROUP BY name ORDER BY c DESC

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