diff options
author | mfuji09 <fujimoto@internet.ne.jp> | 2015-03-21 21:59:19 +0900 |
---|---|---|
committer | mfuji09 <fujimoto@internet.ne.jp> | 2015-03-21 21:59:19 +0900 |
commit | 918e63f3b03007739eef932d00e2c59dcddafb07 (patch) | |
tree | 954c7bc0329f8adbd756781a8fa3256e911f3345 /sources/db/post.sql | |
parent | 88b8b2de918c8fe24406f943bf1850ddaaa15686 (diff) | |
parent | 70f35022161f625e26dba93bcba6c6383e798623 (diff) | |
download | taginfo-918e63f3b03007739eef932d00e2c59dcddafb07.tar taginfo-918e63f3b03007739eef932d00e2c59dcddafb07.tar.gz |
Merge branch 'master' of https://github.com/joto/taginfo
Diffstat (limited to 'sources/db/post.sql')
-rw-r--r-- | sources/db/post.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sources/db/post.sql b/sources/db/post.sql index c321377..49cc634 100644 --- a/sources/db/post.sql +++ b/sources/db/post.sql @@ -38,6 +38,13 @@ INSERT INTO stats (key, value) SELECT 'characters_in_keys_space', count(*) FRO INSERT INTO stats (key, value) SELECT 'characters_in_keys_problem', count(*) FROM keys WHERE characters='problem'; INSERT INTO stats (key, value) SELECT 'characters_in_keys_rest', count(*) FROM keys WHERE characters='rest'; +INSERT INTO stats (key, value) SELECT 'grade_bad', count(*) FROM keys WHERE grade='b'; +INSERT INTO stats (key, value) SELECT 'grade_unknown', count(*) FROM keys WHERE grade='u'; +INSERT INTO stats (key, value) SELECT 'grade_good', count(*) FROM keys WHERE grade='g'; +INSERT INTO stats (key, value) SELECT 'grade_key_count_bad', sum(count_all) FROM keys WHERE grade='b'; +INSERT INTO stats (key, value) SELECT 'grade_key_count_unknown', sum(count_all) FROM keys WHERE grade='u'; +INSERT INTO stats (key, value) SELECT 'grade_key_count_good', sum(count_all) FROM keys WHERE grade='g'; + INSERT INTO stats (key, value) VALUES ('objects', (SELECT sum(value) FROM stats WHERE key IN ('nodes', 'ways', 'relations'))); INSERT INTO stats (key, value) VALUES ('object_tags', (SELECT sum(value) FROM stats WHERE key IN ('node_tags', 'way_tags', 'relation_tags'))); |