Skip to content

Instantly share code, notes, and snippets.

@booo

booo/gist:1115556

Created July 30, 2011 14:01
Show Gist options
  • Save booo/1115556 to your computer and use it in GitHub Desktop.
Save booo/1115556 to your computer and use it in GitHub Desktop.
Download ZIP
average over the tags per node (osm)
Raw
gistfile1.sql
SELECT avg(tagspernode) FROM (SELECT id, count(tags) AS tagsPerNode FROM (SELECT each(tags) as tags, id FROM nodes) AS tuples GROU LIMIT 10000) BY id) AS foo;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment