diff options
| -rw-r--r-- | sources/db/post.sql | 4 | ||||
| -rw-r--r-- | web/views/sources/db.erb | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/sources/db/post.sql b/sources/db/post.sql index 22f05af..e182a28 100644 --- a/sources/db/post.sql +++ b/sources/db/post.sql @@ -45,8 +45,8 @@ 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) VALUES ('objects', (SELECT sum(value) FROM stats WHERE key IN ('nodes', 'ways', 'relations'))); -INSERT INTO stats (key, value) VALUES ('objects_tags', (SELECT sum(value) FROM stats WHERE key IN ('node_tags', 'way_tags', 'relation_tags'))); +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'))); UPDATE keys SET prevalent_values=( SELECT group_concat(value, '|') FROM ( diff --git a/web/views/sources/db.erb b/web/views/sources/db.erb index d03dd76..d8adf20 100644 --- a/web/views/sources/db.erb +++ b/web/views/sources/db.erb @@ -15,7 +15,7 @@ of information about tags. It shows what tags are actually used.</p> <h2><img class="icon_large" src="/img/types/node.24.png" alt=""/> Nodes</h2> <table class="stats"> <tr><td style="width: 7em;">There are </td><td style="width: 7em;" class="number"><%= @db.stats('nodes').to_s_with_ts %></td><td> nodes</td></tr> - <tr><td>of which </td><td class="number"><%= @db.stats('nodes_with_tags').to_s_with_ts %></td><td> have at least on tag</td></tr> + <tr><td>of which </td><td class="number"><%= @db.stats('nodes_with_tags').to_s_with_ts %></td><td> have at least one tag</td></tr> <tr><td>(thats </td><td class="number"><%= (10000.0 * @db.stats('nodes_with_tags') / @db.stats('nodes')).to_i.to_f / 100 %></td><td> %)</td></tr> <tr><td>with together </td><td class="number"><%= @db.stats('node_tags').to_s_with_ts %></td><td> tags</td></tr> <tr><td>(or about </td><td class="number"><%= ( 100.0 * @db.stats('node_tags') / @db.stats('nodes_with_tags')).to_i.to_f / 100 %></td><td> tags per tagged node)</td></tr> |