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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
|
--
-- Taginfo source: Database
--
-- pre.sql
--
.bail ON
INSERT INTO source (id, name, update_start) SELECT 'db', 'Database', datetime('now');
DROP TABLE IF EXISTS keys;
CREATE TABLE keys (
key VARCHAR,
count_all INTEGER DEFAULT 0,
count_nodes INTEGER DEFAULT 0,
count_ways INTEGER DEFAULT 0,
count_relations INTEGER DEFAULT 0,
values_all INTEGER DEFAULT 0,
values_nodes INTEGER DEFAULT 0,
values_ways INTEGER DEFAULT 0,
values_relations INTEGER DEFAULT 0,
users_all INTEGER DEFAULT 0,
users_nodes INTEGER DEFAULT 0,
users_ways INTEGER DEFAULT 0,
users_relations INTEGER DEFAULT 0,
cells_nodes INTEGER DEFAULT 0,
cells_ways INTEGER DEFAULT 0,
in_wiki INTEGER DEFAULT 0,
in_wiki_en INTEGER DEFAULT 0,
in_projects INTEGER DEFAULT 0,
in_josm INTEGER DEFAULT 0,
in_potlatch INTEGER DEFAULT 0,
characters VARCHAR
);
DROP TABLE IF EXISTS prevalent_values;
CREATE TABLE prevalent_values (
key TEXT,
value TEXT,
count INTEGER,
fraction REAL
);
DROP TABLE IF EXISTS key_distributions;
CREATE TABLE key_distributions (
key VARCHAR,
object_type VARCHAR(1), -- (n)ode, (w)ay,
png BLOB
);
DROP TABLE IF EXISTS tag_distributions;
CREATE TABLE tag_distributions (
key VARCHAR,
value VARCHAR,
object_type VARCHAR(1), -- (n)ode, (w)ay,
png BLOB
);
DROP TABLE IF EXISTS tags;
CREATE TABLE tags (
key VARCHAR,
value VARCHAR,
count_all INTEGER DEFAULT 0,
count_nodes INTEGER DEFAULT 0,
count_ways INTEGER DEFAULT 0,
count_relations INTEGER DEFAULT 0,
object_type VARCHAR(1), -- (n)ode, (w)ay, (r)elation
object_id INTEGER,
in_wiki INTEGER DEFAULT 0,
in_wiki_en INTEGER DEFAULT 0,
in_projects INTEGER DEFAULT 0,
in_josm INTEGER DEFAULT 0,
in_potlatch INTEGER DEFAULT 0
);
DROP TABLE IF EXISTS key_combinations;
CREATE TABLE key_combinations (
key1 VARCHAR,
key2 VARCHAR,
count_all INTEGER,
count_nodes INTEGER,
count_ways INTEGER,
count_relations INTEGER
);
DROP TABLE IF EXISTS tag_combinations;
CREATE TABLE tag_combinations (
key1 VARCHAR,
value1 VARCHAR,
key2 VARCHAR,
value2 VARCHAR,
count_all INTEGER,
count_nodes INTEGER,
count_ways INTEGER,
count_relations INTEGER
);
DROP TABLE IF EXISTS relation_types;
CREATE TABLE relation_types (
rtype VARCHAR,
count INTEGER,
members_all INTEGER,
members_nodes INTEGER,
members_ways INTEGER,
members_relations INTEGER
);
DROP TABLE IF EXISTS relation_roles;
CREATE TABLE relation_roles (
rtype VARCHAR,
role VARCHAR,
count_all INTEGER,
count_nodes INTEGER,
count_ways INTEGER,
count_relations INTEGER
);
DROP TABLE IF EXISTS prevalent_roles;
CREATE TABLE prevalent_roles (
rtype TEXT,
role TEXT,
count INTEGER,
fraction REAL
);
-- deprecated: can be removed soon
DROP TABLE IF EXISTS selected_tags;
CREATE TABLE selected_tags (
skey VARCHAR,
svalue VARCHAR,
count_all INTEGER DEFAULT 0,
count_nodes INTEGER DEFAULT 0,
count_ways INTEGER DEFAULT 0,
count_relations INTEGER DEFAULT 0,
in_wiki INTEGER,
in_wiki_en INTEGER
);
|