summaryrefslogtreecommitdiff
path: root/web/views/reports/database_statistics.erb
blob: 232a37d31f2d9f8a53531de50526ebb98847a9aa (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<h1><%= h(t.reports.database_statistics.name) %></h1>

<table class="boxes" style="margin-bottom: 10px;">
    <tr>
        <td><h2><img class="icon_large" src="/img/types/all.20.png" alt=""/> <%= h(t.osm.objects) %></h2></td>
        <td rowspan="4" width="20"></td>
        <td><h2><img class="icon_large" src="/img/types/tag.20.png" alt=""/> <%= h(t.osm.tags) %></h2></td>
        <td rowspan="4" width="20"></td>
        <td></td>
    </tr>
    <tr>
        <td class="box">
            <table>
                <tr><td><%= t.reports.database_statistics.objects_in_db %>:</td><td class="number"><%= @db.stats('objects').to_s_with_ts %></td></tr>
                <tr><td><%= t.reports.database_statistics.tags_in_db %>:</td><td class="number"><%= @db.stats('object_tags').to_s_with_ts %></td></tr>
            </table>
        </td>
        <td class="box">
            <table>
                <tr><td><%= t.reports.database_statistics.distinct_keys %>:</td><td class="number"><%= @db.stats('num_keys').to_s_with_ts %></td></tr>
                <tr><td><%= t.reports.database_statistics.distinct_tags %>:</td><td class="number"><%= @db.stats('num_tags').to_s_with_ts %></td></tr>
            </table>
        </td>
        <td></td>
    </tr>
    <tr>
        <td><h2><img class="icon_large" src="/img/types/node.20.png" alt=""/> <%= h(t.osm.nodes) %></h2></td>
        <td><h2><img class="icon_large" src="/img/types/way.20.png" alt=""/> <%= h(t.osm.ways) %></h2></td>
        <td><h2><img class="icon_large" src="/img/types/relation.20.png" alt=""/> <%= h(t.osm.relations) %></h2></td>
    </tr>
    <tr>
        <td class="box">
            <table>
                <tr><td><%= t.reports.database_statistics.nodes_in_db %>:</td><td class="number"><%= @db.stats('nodes').to_s_with_ts %></td></tr>
                <tr><td><%= t.reports.database_statistics.nodes_with_tags_in_db %>:</td><td class="number"><%= @db.stats('nodes_with_tags').to_s_with_ts %></td></tr>
                <tr><td><%= t.reports.database_statistics.nodes_with_tags_in_db_percent %>:</td><td class="number"><%= (10000.0 * @db.stats('nodes_with_tags') / @db.stats('nodes')).to_i.to_f / 100 %>%</td></tr>
                <tr><td><%= t.reports.database_statistics.tags_on_nodes %>:</td><td class="number"><%= @db.stats('node_tags').to_s_with_ts %></td></tr>
                <tr><td><%= t.reports.database_statistics.avg_tags_per_tagged_node %>:</td><td class="number"><%= ( 100.0 * @db.stats('node_tags') / @db.stats('nodes_with_tags')).to_i.to_f / 100 %></td></tr>
            </table>
        </td>
        <td class="box">
            <table>
                <tr><td><%= t.reports.database_statistics.ways_in_db %>:</td><td class="number"><%= @db.stats('ways').to_s_with_ts %></td></tr>
                <tr><td><%= t.reports.database_statistics.closed_ways_in_db %>:</td><td class="number"><%= @db.stats('closed_ways').to_s_with_ts %></td></tr>
                <tr><td><%= t.reports.database_statistics.tags_on_ways %>:</td><td class="number"><%= @db.stats('way_tags').to_s_with_ts %></td></tr>
                <tr><td><%= t.reports.database_statistics.avg_tags_per_way %>:</td><td class="number"><%= ( 100.0 * @db.stats('way_tags') / @db.stats('ways')).to_i.to_f / 100 %></td></tr>
            </table>
        </td>
        <td class="box">
            <table>
                <tr><td><%= t.reports.database_statistics.relations_in_db %>:</td><td class="number"><%= @db.stats('relations').to_s_with_ts %></td></tr>
                <tr><td><%= t.reports.database_statistics.tags_on_relations %>:</td><td class="number"><%= @db.stats('relation_tags').to_s_with_ts %></td></tr>
                <tr><td><%= t.reports.database_statistics.avg_tags_per_relation %>:</td><td class="number"><%= ( 100.0 * @db.stats('relation_tags') / @db.stats('relations')).to_i.to_f / 100 %></td></tr>
            </table>
        </td>
    </tr>
</table>