-
Notifications
You must be signed in to change notification settings - Fork 0
/
burjaIO(1).sql
364 lines (347 loc) · 25.4 KB
/
burjaIO(1).sql
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
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
-- phpMyAdmin SQL Dump
-- version 4.8.0.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jun 08, 2018 at 10:06 AM
-- Server version: 10.1.29-MariaDB-6
-- PHP Version: 7.2.3-1ubuntu1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `burjaIO`
--
-- --------------------------------------------------------
--
-- Table structure for table `Podatki`
--
CREATE TABLE `Podatki` (
`Lokacija` varchar(40) COLLATE utf16_slovenian_ci NOT NULL,
`Latitude` double NOT NULL,
`Longitude` double NOT NULL,
`TimeStamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`Naprava` varchar(20) COLLATE utf16_slovenian_ci NOT NULL,
`Sunki` float NOT NULL,
`HitrostVetra` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_slovenian_ci;
--
-- Dumping data for table `Podatki`
--
INSERT INTO `Podatki` (`Lokacija`, `Latitude`, `Longitude`, `TimeStamp`, `Naprava`, `Sunki`, `HitrostVetra`) VALUES
('Ajdovscina_Dama', 45.88199255, 13.89494207, '2017-12-28 23:59:59', 'RSkripta', 12.7153, 19.6601),
('Ajdovscina_Dama', 45.88199255, 13.89494207, '2018-01-28 23:59:59', 'RSkripta', 27.2176, 12.0023),
('Ajdovscina_Dama', 45.88199255, 13.89494207, '2018-02-28 23:59:59', 'RSkripta', 46.86, 31.6715),
('Ajdovscina_Dama', 45.88199255, 13.89494207, '2018-03-28 23:59:59', 'RSkripta', 39.377, 22.3704),
('Ajdovscina_Dama', 45.88199255, 13.89494207, '2018-04-18 10:53:50', 'Skripta', 19, 37),
('Ajdovscina_Dama', 45.88199255, 13.89494207, '2018-05-28 23:59:59', 'RSkripta', 2.95139, 10.5972),
('Ajdovscina_Dama', 45.88199255, 13.89494207, '2018-06-28 23:59:59', 'RSkripta', 10.5386, 10.8309),
('Ajdovscina_Izvoz', 45.88017015, 13.90215184, '2017-12-28 23:59:59', 'RSkripta', 21.0486, 15.1601),
('Ajdovscina_Izvoz', 45.88017015, 13.90215184, '2018-01-28 23:59:59', 'RSkripta', 22.9676, 13.5023),
('Ajdovscina_Izvoz', 45.88017015, 13.90215184, '2018-02-28 23:59:59', 'RSkripta', 28.5266, 36.6715),
('Ajdovscina_Izvoz', 45.88017015, 13.90215184, '2018-03-28 23:59:59', 'RSkripta', 30.377, 18.3704),
('Ajdovscina_Izvoz', 45.88017015, 13.90215184, '2018-04-18 10:53:49', 'Skripta', 16, 34),
('Ajdovscina_Izvoz', 45.88017015, 13.90215184, '2018-05-28 23:59:59', 'RSkripta', 7.45139, 20.5972),
('Ajdovscina_Izvoz', 45.88017015, 13.90215184, '2018-06-28 23:59:59', 'RSkripta', 20.5386, 2.41422),
('Ajdovscina_Kozmani', 45.87481611, 13.91948964, '2017-12-28 23:59:59', 'RSkripta', 4.71528, 8.33995),
('Ajdovscina_Kozmani', 45.87481611, 13.91948964, '2018-01-28 23:59:59', 'RSkripta', 16.2176, 0.247685),
('Ajdovscina_Kozmani', 45.87481611, 13.91948964, '2018-02-28 23:59:59', 'RSkripta', 12.86, 46.1715),
('Ajdovscina_Kozmani', 45.87481611, 13.91948964, '2018-03-28 23:59:59', 'RSkripta', 25.377, 19.3704),
('Ajdovscina_Kozmani', 45.87481611, 13.91948964, '2018-04-18 10:53:25', 'Skripta', 14, 28),
('Ajdovscina_Kozmani', 45.87481611, 13.91948964, '2018-05-28 23:59:59', 'RSkripta', 13.2014, 22.8472),
('Ajdovscina_Kozmani', 45.87481611, 13.91948964, '2018-06-28 23:59:59', 'RSkripta', 1.20522, 1.41911),
('Ajdovscina_Mercator', 45.87855682, 13.90841748, '2017-12-28 23:59:59', 'RSkripta', 14.4653, 7.99339),
('Ajdovscina_Mercator', 45.87855682, 13.90841748, '2018-01-28 23:59:59', 'RSkripta', 14.7176, 19.5023),
('Ajdovscina_Mercator', 45.87855682, 13.90841748, '2018-02-28 23:59:59', 'RSkripta', 25.36, 20.9215),
('Ajdovscina_Mercator', 45.87855682, 13.90841748, '2018-03-28 23:59:59', 'RSkripta', 12.377, 23.7037),
('Ajdovscina_Mercator', 45.87855682, 13.90841748, '2018-04-18 10:53:42', 'Skripta', 16, 33),
('Ajdovscina_Mercator', 45.87855682, 13.90841748, '2018-05-28 23:59:59', 'RSkripta', 37.9514, 9.59722),
('Ajdovscina_Mercator', 45.87855682, 13.90841748, '2018-06-28 23:59:59', 'RSkripta', 2.03856, 4.08089),
('Ajdovščina zahod', 45.885986, 13.887062, '2017-12-28 17:30:00', 'Arhiv', 16.6111, 12.713),
('Ajdovščina zahod', 45.885986, 13.887062, '2018-01-13 20:15:00', 'Arhiv', 16.9074, 14.4167),
('Ajdovščina zahod', 45.885986, 13.887062, '2018-02-23 01:30:00', 'Arhiv', 27.1296, 23.287),
('Ajdovščina zahod', 45.885986, 13.887062, '2018-04-15 05:15:00', 'Arhiv', 14.25, 16),
('Ajdovščina zahod', 45.885986, 13.887062, '2018-05-08 23:35:03', 'LIVE Promet.si', 17.2222, 16.4167),
('Ajdovščina zahod', 45.885986, 13.887062, '2018-06-08 10:05:02', 'LIVE Promet.si', 6.38889, 9.19444),
('Ajdovščina_Dolga_Poljana', 45.87093172, 13.92641385, '2017-12-28 23:59:59', 'RSkripta', 12.0486, 16.4101),
('Ajdovščina_Dolga_Poljana', 45.87093172, 13.92641385, '2018-01-28 23:59:59', 'RSkripta', 16.7176, 11.0856),
('Ajdovščina_Dolga_Poljana', 45.87093172, 13.92641385, '2018-02-28 23:59:59', 'RSkripta', 25.1933, 33.1715),
('Ajdovščina_Dolga_Poljana', 45.87093172, 13.92641385, '2018-03-28 23:59:59', 'RSkripta', 20.0437, 35.8704),
('Ajdovščina_Dolga_Poljana', 45.87093172, 13.92641385, '2018-04-18 10:53:17', 'Skripta', 21, 26),
('Ajdovščina_Dolga_Poljana', 45.87093172, 13.92641385, '2018-05-28 23:59:59', 'RSkripta', 21.9514, 12.2639),
('Ajdovščina_Dolga_Poljana', 45.87093172, 13.92641385, '2018-06-28 23:59:59', 'RSkripta', 14.4614, 2.41911),
('Batuje', 45.89835964, 13.77951416, '2017-12-28 23:59:59', 'RSkripta', 11.7153, 11.4101),
('Batuje', 45.89835964, 13.77951416, '2018-01-28 23:59:59', 'RSkripta', 22.2176, 21.7523),
('Batuje', 45.89835964, 13.77951416, '2018-02-28 23:59:59', 'RSkripta', 28.86, 6.17146),
('Batuje', 45.89835964, 13.77951416, '2018-03-28 23:59:59', 'RSkripta', 11.377, 32.8704),
('Batuje', 45.89835964, 13.77951416, '2018-04-18 10:54:48', 'Skripta', 16, 63),
('Batuje', 45.89835964, 13.77951416, '2018-05-28 23:59:59', 'RSkripta', 7.45139, 15.3472),
('Batuje', 45.89835964, 13.77951416, '2018-06-28 23:59:59', 'RSkripta', 8.28856, 1.58089),
('Budanje', 45.8646314, 13.93447576, '2017-12-28 23:59:59', 'RSkripta', 15.3819, 14.3267),
('Budanje', 45.8646314, 13.93447576, '2018-01-28 23:59:59', 'RSkripta', 23.7176, 11.7523),
('Budanje', 45.8646314, 13.93447576, '2018-02-28 23:59:59', 'RSkripta', 24.36, 32.1715),
('Budanje', 45.8646314, 13.93447576, '2018-03-28 23:59:59', 'RSkripta', 25.377, 23.7037),
('Budanje', 45.8646314, 13.93447576, '2018-04-18 10:52:55', 'Skripta', 24, 35),
('Budanje', 45.8646314, 13.93447576, '2018-05-28 23:59:59', 'RSkripta', 22.2014, 8.59722),
('Budanje', 45.8646314, 13.93447576, '2018-06-28 23:59:59', 'RSkripta', 3.53856, 27.0809),
('Cesta', 45.88372528, 13.88485696, '2017-12-28 23:59:59', 'RSkripta', 14.4653, 15.4101),
('Cesta', 45.88372528, 13.88485696, '2018-01-28 23:59:59', 'RSkripta', 20.7176, 23.2523),
('Cesta', 45.88372528, 13.88485696, '2018-02-28 23:59:59', 'RSkripta', 46.86, 23.5048),
('Cesta', 45.88372528, 13.88485696, '2018-03-28 23:59:59', 'RSkripta', 21.627, 15.3704),
('Cesta', 45.88372528, 13.88485696, '2018-04-18 10:53:52', 'Skripta', 20, 40),
('Cesta', 45.88372528, 13.88485696, '2018-05-28 23:59:59', 'RSkripta', 14.4514, 13.5972),
('Cesta', 45.88372528, 13.88485696, '2018-06-28 23:59:59', 'RSkripta', 0.538556, 12.3309),
('Dobravlje', 45.88805065, 13.84052255, '2017-12-28 23:59:59', 'RSkripta', 20.0486, 5.66005),
('Dobravlje', 45.88805065, 13.84052255, '2018-01-28 23:59:59', 'RSkripta', 24.2176, 8.75231),
('Dobravlje', 45.88805065, 13.84052255, '2018-02-28 23:59:59', 'RSkripta', 25.86, 11.1715),
('Dobravlje', 45.88805065, 13.84052255, '2018-03-28 23:59:59', 'RSkripta', 21.127, 18.8704),
('Dobravlje', 45.88805065, 13.84052255, '2018-04-18 10:54:22', 'Skripta', 19, 44),
('Dobravlje', 45.88805065, 13.84052255, '2018-05-28 23:59:59', 'RSkripta', 23.9514, 12.5972),
('Dobravlje', 45.88805065, 13.84052255, '2018-06-28 23:59:59', 'RSkripta', 20.5386, 1.58089),
('FE', 46.04485, 14.489245, '2018-06-06 18:38:27', 'Arduino', 47.78, 47.78),
('Gojace', 45.89302118, 13.80085122, '2017-12-28 23:59:59', 'RSkripta', 13.2153, 10.3267),
('Gojace', 45.89302118, 13.80085122, '2018-01-28 23:59:59', 'RSkripta', 16.9676, 18.7523),
('Gojace', 45.89302118, 13.80085122, '2018-02-28 23:59:59', 'RSkripta', 34.86, 22.6715),
('Gojace', 45.89302118, 13.80085122, '2018-03-28 23:59:59', 'RSkripta', 18.127, 20.3704),
('Gojace', 45.89302118, 13.80085122, '2018-04-18 10:54:40', 'Skripta', 18, 48),
('Gojace', 45.89302118, 13.80085122, '2018-05-28 23:59:59', 'RSkripta', 15.2014, 21.2639),
('Gojace', 45.89302118, 13.80085122, '2018-06-28 23:59:59', 'RSkripta', 8.78856, 23.0809),
('Kamnje', 45.88637781, 13.83069494, '2017-12-28 23:59:59', 'RSkripta', 22.7153, 1.66005),
('Kamnje', 45.88637781, 13.83069494, '2018-01-28 23:59:59', 'RSkripta', 25.0509, 13.7523),
('Kamnje', 45.88637781, 13.83069494, '2018-02-28 23:59:59', 'RSkripta', 26.11, 32.8381),
('Kamnje', 45.88637781, 13.83069494, '2018-03-28 23:59:59', 'RSkripta', 34.377, 46.3704),
('Kamnje', 45.88637781, 13.83069494, '2018-04-18 10:54:29', 'Skripta', 17, 44),
('Kamnje', 45.88637781, 13.83069494, '2018-05-28 23:59:59', 'RSkripta', 14.2014, 12.9306),
('Kamnje', 45.88637781, 13.83069494, '2018-06-28 23:59:59', 'RSkripta', 10.5386, 12.0809),
('Male_Zablje', 45.88563591, 13.85776549, '2017-12-28 23:59:59', 'RSkripta', 2.28472, 7.41005),
('Male_Zablje', 45.88563591, 13.85776549, '2018-01-28 23:59:59', 'RSkripta', 16.2176, 7.75232),
('Male_Zablje', 45.88563591, 13.85776549, '2018-02-28 23:59:59', 'RSkripta', 38.86, 19.5048),
('Male_Zablje', 45.88563591, 13.85776549, '2018-03-28 23:59:59', 'RSkripta', 16.377, 35.3704),
('Male_Zablje', 45.88563591, 13.85776549, '2018-04-18 10:54:17', 'Skripta', 22, 42),
('Male_Zablje', 45.88563591, 13.85776549, '2018-05-28 23:59:59', 'RSkripta', 0.951389, 35.5972),
('Male_Zablje', 45.88563591, 13.85776549, '2018-06-28 23:59:59', 'RSkripta', 0.461444, 3.58089),
('Manče', 45.82479, 13.95812, '2017-12-28 16:59:59', 'Arhiv', 16.1296, 12.4907),
('Manče', 45.82479, 13.95812, '2018-01-13 20:44:59', 'Arhiv', 21.5556, 19.1944),
('Manče', 45.82479, 13.95812, '2018-02-24 20:30:00', 'Arhiv', 35.7222, 28.1944),
('Manče', 45.82479, 13.95812, '2018-03-18 21:15:00', 'Arhiv', 25.0278, 29.5185),
('Manče', 45.82479, 13.95812, '2018-04-27 01:45:00', 'Arhiv', 20.1389, 21.7222),
('Manče', 45.82479, 13.95812, '2018-05-11 10:20:02', 'LIVE Promet.si', 18.0556, 17.25),
('Manče', 45.82479, 13.95812, '2018-06-08 10:05:02', 'LIVE Promet.si', 4.44444, 13.9167),
('Place', 45.88473502, 13.87675456, '2017-12-28 23:59:59', 'RSkripta', 34.7153, 7.99339),
('Place', 45.88473502, 13.87675456, '2018-01-28 23:59:59', 'RSkripta', 22.9676, 5.75232),
('Place', 45.88473502, 13.87675456, '2018-02-28 23:59:59', 'RSkripta', 34.36, 35.6715),
('Place', 45.88473502, 13.87675456, '2018-03-28 23:59:59', 'RSkripta', 19.627, 24.3704),
('Place', 45.88473502, 13.87675456, '2018-04-18 10:54:02', 'Skripta', 15, 42),
('Place', 45.88473502, 13.87675456, '2018-05-28 23:59:59', 'RSkripta', 19.4514, 12.5972),
('Place', 45.88473502, 13.87675456, '2018-06-28 23:59:59', 'RSkripta', 13.5386, 4.08089),
('Podnanos', 45.80403, 13.967603, '2017-12-28 17:15:00', 'Arhiv', 12.1667, 9.13889),
('Podnanos', 45.80403, 13.967603, '2018-01-11 18:45:00', 'Arhiv', 24.6667, 19.5278),
('Podnanos', 45.80403, 13.967603, '2018-02-23 06:29:59', 'Arhiv', 35.8333, 29.4722),
('Podnanos', 45.80403, 13.967603, '2018-03-18 20:44:59', 'Arhiv', 25.6944, 28.2407),
('Podnanos', 45.80403, 13.967603, '2018-04-27 03:29:59', 'Arhiv', 19.0833, 22.5556),
('Podnanos', 45.80403, 13.967603, '2018-05-11 10:05:01', 'LIVE Promet.si', 18.3333, 18.3611),
('Podnanos', 45.80403, 13.967603, '2018-06-08 10:05:02', 'LIVE Promet.si', 7.22222, 11.4167),
('Potoče', 45.8883, 13.822906, '2017-12-16 00:00:00', 'Arhiv', 16.3889, 11.7341),
('Potoče', 45.8883, 13.822906, '2018-01-13 16:59:59', 'Arhiv', 17.2222, 12.5278),
('Potoče', 45.8883, 13.822906, '2018-02-24 10:00:00', 'Arhiv', 23.3333, 19.7315),
('Potoče', 45.8883, 13.822906, '2018-03-19 06:15:00', 'Arhiv', 16.9907, 20.0185),
('Potoče', 45.8883, 13.822906, '2018-04-18 10:54:32', 'Arhiv', 4.16667, 9.16667),
('Potoče', 45.8883, 13.822906, '2018-04-27 05:30:00', 'Arhiv', 13.5093, 16.7222),
('Potoče', 45.8883, 13.822906, '2018-05-08 22:40:02', 'LIVE Promet.si', 19.4444, 19.75),
('Potoče', 45.8883, 13.822906, '2018-06-08 10:05:02', 'LIVE Promet.si', 5, 10.3056),
('Selo', 45.89460422, 13.7910236, '2017-12-28 23:59:59', 'RSkripta', 7.21528, 8.66005),
('Selo', 45.89460422, 13.7910236, '2018-01-28 23:59:59', 'RSkripta', 22.2176, 4.24768),
('Selo', 45.89460422, 13.7910236, '2018-02-28 23:59:59', 'RSkripta', 33.61, 36.6715),
('Selo', 45.89460422, 13.7910236, '2018-03-28 23:59:59', 'RSkripta', 34.377, 31.3704),
('Selo', 45.89460422, 13.7910236, '2018-04-18 10:54:47', 'Skripta', 19, 55),
('Selo', 45.89460422, 13.7910236, '2018-05-28 23:59:59', 'RSkripta', 14.9514, 21.9306),
('Selo', 45.89460422, 13.7910236, '2018-06-28 23:59:59', 'RSkripta', 3.20522, 23.0809),
('Skrilje', 45.88746593, 13.8514062, '2017-12-28 23:59:59', 'RSkripta', 3.71528, 33.6601),
('Skrilje', 45.88746593, 13.8514062, '2018-01-28 23:59:59', 'RSkripta', 23.2176, 12.7523),
('Skrilje', 45.88746593, 13.8514062, '2018-02-28 23:59:59', 'RSkripta', 25.36, 24.9215),
('Skrilje', 45.88746593, 13.8514062, '2018-03-28 23:59:59', 'RSkripta', 15.877, 30.7037),
('Skrilje', 45.88746593, 13.8514062, '2018-04-18 10:54:17', 'Skripta', 16, 35),
('Skrilje', 45.88746593, 13.8514062, '2018-05-28 23:59:59', 'RSkripta', 10.9514, 22.5972),
('Skrilje', 45.88746593, 13.8514062, '2018-06-28 23:59:59', 'RSkripta', 1.87189, 25.0809),
('Stomaz', 45.899516, 13.856338, '2018-06-01 14:41:20', 'Arduino', 7.33, 5.67),
('Stomaz', 45.899516, 13.856338, '2018-06-28 23:59:59', 'RSkripta', 0.461444, 11.0809),
('Šmihel', 45.94693, 13.711239, '2017-12-16 00:00:00', 'Arhiv', 20.8333, 11.0198),
('Šmihel', 45.94693, 13.711239, '2018-01-01 16:14:59', 'Arhiv', 17.2222, 14.0463),
('Šmihel', 45.94693, 13.711239, '2018-02-22 00:29:59', 'Arhiv', 35.4444, 27.1389),
('Šmihel', 45.94693, 13.711239, '2018-03-21 00:00:00', 'Arhiv', 22.4167, 28.4444),
('Šmihel', 45.94693, 13.711239, '2018-04-09 14:44:59', 'Arhiv', 10.5278, 11.7778),
('Šmihel', 45.94693, 13.711239, '2018-05-08 23:30:03', 'LIVE Promet.si', 18.8889, 16.4167),
('Šmihel', 45.94693, 13.711239, '2018-06-08 10:05:02', 'LIVE Promet.si', 4.16667, 6.13889),
('Vipava_Dars', 45.82869251, 13.95867924, '2017-12-28 23:59:59', 'RSkripta', 12.0486, 9.16005),
('Vipava_Dars', 45.82869251, 13.95867924, '2018-01-28 23:59:59', 'RSkripta', 24.7176, 10.419),
('Vipava_Dars', 45.82869251, 13.95867924, '2018-02-28 23:59:59', 'RSkripta', 45.86, 31.1715),
('Vipava_Dars', 45.82869251, 13.95867924, '2018-03-28 23:59:59', 'RSkripta', 8.37698, 6.37037),
('Vipava_Dars', 45.82869251, 13.95867924, '2018-04-18 10:52:53', 'Skripta', 14, 40),
('Vipava_Dars', 45.82869251, 13.95867924, '2018-05-28 23:59:59', 'RSkripta', 22.7014, 26.5972),
('Vipava_Dars', 45.82869251, 13.95867924, '2018-06-28 23:59:59', 'RSkripta', 2.53856, 12.9191),
('Vipava_Fama', 45.84086281, 13.95238933, '2017-12-28 23:59:59', 'RSkripta', 12.7153, 4.33995),
('Vipava_Fama', 45.84086281, 13.95238933, '2018-01-28 23:59:59', 'RSkripta', 25.7176, 14.5023),
('Vipava_Fama', 45.84086281, 13.95238933, '2018-02-28 23:59:59', 'RSkripta', 37.5266, 39.1715),
('Vipava_Fama', 45.84086281, 13.95238933, '2018-03-28 23:59:59', 'RSkripta', 24.627, 20.3704),
('Vipava_Fama', 45.84086281, 13.95238933, '2018-04-14 11:28:47', 'Skripta', 15, 60),
('Vipava_Fama', 45.84086281, 13.95238933, '2018-05-28 23:59:59', 'RSkripta', 23.9514, 14.2639),
('Vipava_Fama', 45.84086281, 13.95238933, '2018-06-28 23:59:59', 'RSkripta', 4.46144, 12.0809),
('Vipava_Izvoz', 45.83584, 13.95442, '2017-12-28 23:59:59', 'RSkripta', 24.0486, 19.3267),
('Vipava_Izvoz', 45.83583987, 13.95442352, '2017-12-28 23:59:59', 'RSkripta', 25.7153, 9.66005),
('Vipava_Izvoz', 45.83584, 13.95442, '2018-01-28 23:59:59', 'RSkripta', 13.4676, 30.7523),
('Vipava_Izvoz', 45.83583987, 13.95442352, '2018-01-28 23:59:59', 'RSkripta', 15.4676, 20.0023),
('Vipava_Izvoz', 45.83584, 13.95442, '2018-02-28 23:59:59', 'RSkripta', 32.36, 18.1715),
('Vipava_Izvoz', 45.83583987, 13.95442352, '2018-02-28 23:59:59', 'RSkripta', 38.36, 36.6715),
('Vipava_Izvoz', 45.83584, 13.95442, '2018-03-28 23:59:59', 'RSkripta', 16.377, 20.3704),
('Vipava_Izvoz', 45.83583987, 13.95442352, '2018-03-28 23:59:59', 'RSkripta', 20.627, 31.7037),
('Vipava_Izvoz', 45.83583987, 13.95442352, '2018-04-14 11:28:27', 'Skripta', 17, 71),
('Vipava_Izvoz', 45.83584, 13.95442, '2018-04-25 09:48:35', 'Skripta', 17, 43.4),
('Vipava_Izvoz', 45.83583987, 13.95442352, '2018-05-28 23:59:59', 'RSkripta', 3.04861, 36.5972),
('Vipava_Izvoz', 45.83584, 13.95442, '2018-05-28 23:59:59', 'RSkripta', 13.4514, 22.2639),
('Vipava_Izvoz', 45.83584, 13.95442, '2018-06-28 23:59:59', 'RSkripta', 0.205222, 8.83089),
('Vipava_Izvoz', 45.83583987, 13.95442352, '2018-06-28 23:59:59', 'RSkripta', 4.46144, 4.58089),
('Vipava_Petrol', 45.84811329, 13.94875611, '2017-12-28 23:59:59', 'RSkripta', 21.4653, 4.66005),
('Vipava_Petrol', 45.84811329, 13.94875611, '2018-01-28 23:59:59', 'RSkripta', 23.2176, 13.7523),
('Vipava_Petrol', 45.84811329, 13.94875611, '2018-02-28 23:59:59', 'RSkripta', 38.86, 10.1715),
('Vipava_Petrol', 45.84811329, 13.94875611, '2018-03-28 23:59:59', 'RSkripta', 25.877, 24.037),
('Vipava_Petrol', 45.84811329, 13.94875611, '2018-04-14 11:30:40', 'Skripta', 16, 53),
('Vipava_Petrol', 45.84811329, 13.94875611, '2018-05-28 23:59:59', 'RSkripta', 19.7014, 26.5972),
('Vipava_Petrol', 45.84811329, 13.94875611, '2018-06-28 23:59:59', 'RSkripta', 19.5386, 17.5809),
('Vipava_Skofijska', 45.84481507, 13.95054397, '2017-12-28 23:59:59', 'RSkripta', 12.7153, 9.16005),
('Vipava_Skofijska', 45.84481507, 13.95054397, '2018-01-28 23:59:59', 'RSkripta', 1.28241, 12.7523),
('Vipava_Skofijska', 45.84481507, 13.95054397, '2018-02-28 23:59:59', 'RSkripta', 23.86, 29.5048),
('Vipava_Skofijska', 45.84481507, 13.95054397, '2018-03-28 23:59:59', 'RSkripta', 19.127, 29.6204),
('Vipava_Skofijska', 45.84481507, 13.95054397, '2018-04-14 11:30:21', 'Skripta', 75, 65),
('Vipava_Skofijska', 45.84481507, 13.95054397, '2018-05-28 23:59:59', 'RSkripta', 30.9514, 24.5972),
('Vipava_Skofijska', 45.84481507, 13.95054397, '2018-06-28 23:59:59', 'RSkripta', 0.961444, 1.08089),
('Vipavski_Kriz', 45.88470693, 13.8676181, '2017-12-28 23:59:59', 'RSkripta', 22.3819, 17.1601),
('Vipavski_Kriz', 45.88470693, 13.8676181, '2018-01-28 23:59:59', 'RSkripta', 12.7176, 21.0023),
('Vipavski_Kriz', 45.88470693, 13.8676181, '2018-02-28 23:59:59', 'RSkripta', 35.1933, 30.1715),
('Vipavski_Kriz', 45.88470693, 13.8676181, '2018-03-28 23:59:59', 'RSkripta', 18.877, 31.1204),
('Vipavski_Kriz', 45.88470693, 13.8676181, '2018-04-18 10:54:14', 'Skripta', 18, 45),
('Vipavski_Kriz', 45.88470693, 13.8676181, '2018-05-28 23:59:59', 'RSkripta', 8.45139, 16.0972),
('Vipavski_Kriz', 45.88470693, 13.8676181, '2018-06-28 23:59:59', 'RSkripta', 4.03856, 10.0809),
('Vitovlje', 45.921715, 13.755232, '2017-12-16 00:00:00', 'Arhiv', 20, 12.6468),
('Vitovlje', 45.921715, 13.755232, '2018-01-22 00:29:59', 'Arhiv', 12.7778, 10.6389),
('Vitovlje', 45.921715, 13.755232, '2018-02-22 01:30:00', 'Arhiv', 34.4444, 30.1204),
('Vitovlje', 45.921715, 13.755232, '2018-03-21 02:30:00', 'Arhiv', 25.6759, 28.0556),
('Vitovlje', 45.921715, 13.755232, '2018-04-26 22:30:00', 'Arhiv', 11.2685, 13.3333),
('Vitovlje', 45.921715, 13.755232, '2018-05-08 23:10:02', 'LIVE Promet.si', 18.8889, 19.1944),
('Vitovlje', 45.921715, 13.755232, '2018-06-08 10:05:02', 'LIVE Promet.si', 4.44444, 20),
('Vrtovin', 45.89133645, 13.81008992, '2017-12-28 23:59:59', 'RSkripta', 20.2153, 6.32672),
('Vrtovin', 45.89133645, 13.81008992, '2018-01-28 23:59:59', 'RSkripta', 12.7176, 11.2523),
('Vrtovin', 45.89133645, 13.81008992, '2018-02-28 23:59:59', 'RSkripta', 41.86, 9.17146),
('Vrtovin', 45.89133645, 13.81008992, '2018-03-28 23:59:59', 'RSkripta', 20.7103, 29.1204),
('Vrtovin', 45.89133645, 13.81008992, '2018-04-18 10:54:33', 'Skripta', 22, 44),
('Vrtovin', 45.89133645, 13.81008992, '2018-05-28 23:59:59', 'RSkripta', 8.45139, 12.5972),
('Vrtovin', 45.89133645, 13.81008992, '2018-06-28 23:59:59', 'RSkripta', 12.0386, 11.0809),
('Zemono', 45.86793, 13.931388, '2017-12-28 16:30:00', 'Arhiv', 17.6481, 15.0093),
('Zemono', 45.86793, 13.931388, '2018-01-01 16:00:00', 'Arhiv', 19.6667, 17.3611),
('Zemono', 45.86793, 13.931388, '2018-02-21 19:45:00', 'Arhiv', 26.5, 24.4352),
('Zemono', 45.86793, 13.931388, '2018-03-18 19:59:59', 'Arhiv', 20.3981, 23.6111),
('Zemono', 45.86793, 13.931388, '2018-04-15 02:30:00', 'Arhiv', 14.3426, 17.0185),
('Zemono', 45.85472935, 13.94437875, '2018-04-18 10:52:34', 'Skripta', 20, 42),
('Zemono', 45.86793, 13.931388, '2018-05-08 23:15:02', 'LIVE Promet.si', 19.4444, 19.75),
('Zemono', 45.86793, 13.931388, '2018-06-08 10:05:02', 'LIVE Promet.si', 5.27778, 10.3056),
('Žapuže', 45.87594, 13.917871, '2017-12-16 00:15:00', 'Arhiv', 21.9444, 16.5278),
('Žapuže', 45.87594, 13.917871, '2018-01-13 20:30:00', 'Arhiv', 19.7222, 18.3056),
('Žapuže', 45.87594, 13.917871, '2018-02-26 08:15:00', 'Arhiv', 28.4722, 26.9921),
('Žapuže', 45.87594, 13.917871, '2018-03-20 23:30:00', 'Arhiv', 27.4352, 33.7037),
('Žapuže', 45.87594, 13.917871, '2018-04-27 06:29:59', 'Arhiv', 17.1759, 21.1111),
('Žapuže', 45.87594, 13.917871, '2018-05-11 08:40:02', 'LIVE Promet.si', 13.3333, 13.6389),
('Žapuže', 45.87594, 13.917871, '2018-06-08 10:05:02', 'LIVE Promet.si', 5, 8.36111);
-- --------------------------------------------------------
--
-- Table structure for table `Povprecja`
--
CREATE TABLE `Povprecja` (
`HitrostVetra` float NOT NULL,
`PovprecniSunki` float NOT NULL,
`Lokacija` varchar(40) COLLATE utf16_slovenian_ci NOT NULL,
`Latutide` float NOT NULL,
`Longitude` float NOT NULL,
`Leto` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_slovenian_ci;
--
-- Dumping data for table `Povprecja`
--
INSERT INTO `Povprecja` (`HitrostVetra`, `PovprecniSunki`, `Lokacija`, `Latutide`, `Longitude`, `Leto`) VALUES
(19.6601, 12.7153, 'Ajdovscina_Dama', 45.882, 13.8949, 2017),
(15.1601, 21.0486, 'Ajdovscina_Izvoz', 45.8802, 13.9022, 2017),
(8.33995, 4.71528, 'Ajdovscina_Kozmani', 45.8748, 13.9195, 2017),
(7.99339, 14.4653, 'Ajdovscina_Mercator', 45.8786, 13.9084, 2017),
(12.713, 16.6111, 'Ajdovščina zahod', 45.886, 13.8871, 2017),
(16.4101, 12.0486, 'Ajdovščina_Dolga_Poljana', 45.8709, 13.9264, 2017),
(11.4101, 11.7153, 'Batuje', 45.8984, 13.7795, 2017),
(14.3267, 15.3819, 'Budanje', 45.8646, 13.9345, 2017),
(15.4101, 14.4653, 'Cesta', 45.8837, 13.8849, 2017),
(5.66005, 20.0486, 'Dobravlje', 45.8881, 13.8405, 2017),
(10.3267, 13.2153, 'Gojace', 45.893, 13.8009, 2017),
(1.66005, 22.7153, 'Kamnje', 45.8864, 13.8307, 2017),
(7.41005, 2.28472, 'Male_Zablje', 45.8856, 13.8578, 2017),
(12.4907, 16.1296, 'Manče', 45.8248, 13.9581, 2017),
(7.99339, 34.7153, 'Place', 45.8847, 13.8768, 2017),
(9.13889, 12.1667, 'Podnanos', 45.804, 13.9676, 2017),
(11.7341, 16.3889, 'Potoče', 45.8883, 13.8229, 2017),
(8.66005, 7.21528, 'Selo', 45.8946, 13.791, 2017),
(33.6601, 3.71528, 'Skrilje', 45.8875, 13.8514, 2017),
(11.0198, 20.8333, 'Šmihel', 45.9469, 13.7112, 2017),
(9.16005, 12.0486, 'Vipava_Dars', 45.8287, 13.9587, 2017),
(4.33995, 12.7153, 'Vipava_Fama', 45.8409, 13.9524, 2017),
(14.4934, 24.8819, 'Vipava_Izvoz', 45.8358, 13.9544, 2017),
(4.66005, 21.4653, 'Vipava_Petrol', 45.8481, 13.9488, 2017),
(9.16005, 12.7153, 'Vipava_Skofijska', 45.8448, 13.9505, 2017),
(17.1601, 22.3819, 'Vipavski_Kriz', 45.8847, 13.8676, 2017),
(12.6468, 20, 'Vitovlje', 45.9217, 13.7552, 2017),
(6.32672, 20.2153, 'Vrtovin', 45.8913, 13.8101, 2017),
(15.0093, 17.6481, 'Zemono', 45.8679, 13.9314, 2017),
(16.5278, 21.9444, 'Žapuže', 45.8759, 13.9179, 2017),
(20.7454, 24.3241, 'Ajdovscina_Dama', 45.882, 13.8949, 2018),
(20.9259, 20.9769, 'Ajdovscina_Izvoz', 45.8802, 13.9022, 2018),
(19.676, 13.8102, 'Ajdovscina_Kozmani', 45.8748, 13.9195, 2018),
(18.4676, 18.0741, 'Ajdovscina_Mercator', 45.8786, 13.9084, 2018),
(15.863, 16.3796, 'Ajdovščina zahod', 45.886, 13.8871, 2018),
(20.1351, 19.8946, 'Ajdovščina_Dolga_Poljana', 45.8709, 13.9264, 2018),
(23.4537, 15.6991, 'Batuje', 45.8984, 13.7795, 2018),
(23.0509, 20.5324, 'Budanje', 45.8646, 13.9345, 2018),
(21.3426, 20.6991, 'Cesta', 45.8837, 13.8849, 2018),
(16.162, 22.4491, 'Dobravlje', 45.8881, 13.8405, 2018),
(47.78, 47.78, 'FE', 46.0448, 14.4892, 2018),
(25.6898, 18.6574, 'Gojace', 45.893, 13.8009, 2018),
(26.9954, 21.213, 'Kamnje', 45.8864, 13.8307, 2018),
(23.9676, 15.8112, 'Male_Zablje', 45.8856, 13.8578, 2018),
(21.6327, 20.8241, 'Manče', 45.8248, 13.9581, 2018),
(20.7454, 20.8241, 'Place', 45.8847, 13.8768, 2018),
(21.5957, 21.8056, 'Podnanos', 45.804, 13.9676, 2018),
(15.4603, 14.2381, 'Potoče', 45.8883, 13.8229, 2018),
(28.7168, 21.2269, 'Selo', 45.8946, 13.791, 2018),
(25.1759, 15.5463, 'Skrilje', 45.8875, 13.8514, 2018),
(8.37544, 3.89572, 'Stomaz', 45.8995, 13.8563, 2018),
(17.3272, 18.1111, 'Šmihel', 45.9469, 13.7112, 2018),
(21.2462, 19.6991, 'Vipava_Dars', 45.8287, 13.9587, 2018),
(26.7315, 21.8807, 'Vipava_Fama', 45.8409, 13.9524, 2018),
(28.6954, 15.9855, 'Vipava_Izvoz', 45.8358, 13.9544, 2018),
(24.1898, 23.8657, 'Vipava_Petrol', 45.8481, 13.9488, 2018),
(27.0926, 25.197, 'Vipava_Skofijska', 45.8448, 13.9505, 2018),
(25.5787, 16.213, 'Vipavski_Kriz', 45.8847, 13.8676, 2018),
(20.2238, 17.9167, 'Vitovlje', 45.9217, 13.7552, 2018),
(19.537, 19.6296, 'Vrtovin', 45.8913, 13.8101, 2018),
(22.0688, 17.9471, 'Zemono', 45.8679, 13.9314, 2018),
(20.3521, 18.5231, 'Žapuže', 45.8759, 13.9179, 2018);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `Podatki`
--
ALTER TABLE `Podatki`
ADD PRIMARY KEY (`Lokacija`,`TimeStamp`,`Sunki`,`HitrostVetra`);
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;