-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathNewDatas.sql
More file actions
703 lines (700 loc) · 188 KB
/
NewDatas.sql
File metadata and controls
703 lines (700 loc) · 188 KB
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
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
USE [BusDB]
GO
/****** Object: Table [dbo].[BusTrace] Script Date: 2019. 10. 05. 11:14:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BusTrace](
[Id] [int] IDENTITY(1,1) NOT NULL,
[BusId] [varchar](20) NOT NULL,
[Longitude] [float] NOT NULL,
[Latitude] [float] NOT NULL,
[Timestamp] [datetime] NOT NULL,
[speed] [float] NULL,
CONSTRAINT [PK_BusTrace] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[MeasuredData] Script Date: 2019. 10. 05. 11:14:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MeasuredData](
[ID] [int] IDENTITY(1,1) NOT NULL,
[From] [int] NOT NULL,
[To] [int] NOT NULL,
[duration] [int] NOT NULL,
[dateTime] [datetime] NOT NULL,
CONSTRAINT [PK_MeasuredData] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[References] Script Date: 2019. 10. 05. 11:14:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[References](
[id] [int] IDENTITY(1,1) NOT NULL,
[From] [int] NOT NULL,
[To] [int] NOT NULL,
[duration] [time](7) NOT NULL,
[intervalTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Timetable] Script Date: 2019. 10. 05. 11:14:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Timetable](
[id] [int] IDENTITY(1,1) NOT NULL,
[busNr] [int] NOT NULL,
[startTime] [time](0) NOT NULL,
[stationID] [int] NOT NULL,
[weekday] [int] NOT NULL,
CONSTRAINT [PK_Timetable] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[BusTrace] ON
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (43, N'44', 24.6020014, 46.5243824, CAST(N'2019-06-26T16:13:44.380' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (44, N'44', 24.599186, 46.5268513, CAST(N'2019-06-26T16:14:15.373' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (45, N'44', 24.5972605, 46.5315512, CAST(N'2019-06-26T16:14:48.633' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (46, N'44', 24.5910137, 46.5322139, CAST(N'2019-06-26T16:15:21.900' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (47, N'44', 24.5896157, 46.5336392, CAST(N'2019-06-26T16:15:54.790' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (48, N'44', 24.5917985, 46.5342839, CAST(N'2019-06-26T16:16:26.513' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (49, N'44', 24.5935632, 46.5351441, CAST(N'2019-06-26T16:16:58.187' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (50, N'44', 24.5948922, 46.5360109, CAST(N'2019-06-26T16:17:42.940' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (51, N'44', 24.5926453, 46.5364253, CAST(N'2019-06-26T16:18:13.623' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (52, N'44', 24.5903672, 46.5370617, CAST(N'2019-06-26T16:18:57.630' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (53, N'44', 24.5883662, 46.5382194, CAST(N'2019-06-26T16:19:30.213' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (54, N'44', 24.5871455, 46.538535, CAST(N'2019-06-26T16:20:03.283' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (55, N'44', 24.5845423, 46.5392471, CAST(N'2019-06-26T16:20:36.000' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (56, N'44', 24.5843474, 46.5382029, CAST(N'2019-06-26T16:21:13.007' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (57, N'44', 24.5846244, 46.5365174, CAST(N'2019-06-26T16:21:46.647' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (58, N'44', 24.5842017, 46.5359603, CAST(N'2019-06-26T16:22:19.290' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (59, N'44', 24.5827491, 46.5354487, CAST(N'2019-06-26T16:22:51.830' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (60, N'44', 24.5818725, 46.5360267, CAST(N'2019-06-26T16:23:24.583' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (61, N'44', 24.579713, 46.5354932, CAST(N'2019-06-26T16:23:57.847' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (62, N'44', 24.5782511, 46.5351558, CAST(N'2019-06-26T16:24:30.420' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (63, N'44', 24.5755886, 46.5353911, CAST(N'2019-06-26T16:25:05.390' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (64, N'44', 24.5748445, 46.5356151, CAST(N'2019-06-26T16:25:44.730' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (65, N'44', 24.5738044, 46.5378273, CAST(N'2019-06-26T16:26:30.547' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (66, N'44', 24.5730399, 46.5377663, CAST(N'2019-06-26T16:27:04.250' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (67, N'44', 24.5717954, 46.5376693, CAST(N'2019-06-26T16:27:40.980' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (68, N'44', 24.5718317, 46.5365247, CAST(N'2019-06-26T16:28:13.773' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (69, N'44', 24.5723862, 46.5337713, CAST(N'2019-06-26T16:28:54.910' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (70, N'44', 24.5712142, 46.5330227, CAST(N'2019-06-26T16:29:28.240' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (71, N'44', 24.5687785, 46.5335283, CAST(N'2019-06-26T16:30:05.843' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (72, N'44', 24.5658385, 46.535103, CAST(N'2019-06-26T16:30:41.003' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (73, N'44', 24.5628139, 46.5363404, CAST(N'2019-06-26T16:31:14.723' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (74, N'44', 24.562103, 46.5365723, CAST(N'2019-06-26T16:31:48.087' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (75, N'44', 24.5587731, 46.5373719, CAST(N'2019-06-26T16:32:22.947' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (76, N'44', 24.5581327, 46.5374453, CAST(N'2019-06-26T16:32:59.360' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (77, N'44', 24.5582882, 46.5363034, CAST(N'2019-06-26T16:33:34.493' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (78, N'44', 24.559212, 46.5348452, CAST(N'2019-06-26T16:34:09.293' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (79, N'44', 24.5586873, 46.5325263, CAST(N'2019-06-26T16:34:45.663' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (80, N'44', 24.5576894, 46.5316553, CAST(N'2019-06-26T16:35:17.027' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (81, N'44', 24.5569415, 46.5310315, CAST(N'2019-06-26T16:35:49.207' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (82, N'44', 24.5543512, 46.5288028, CAST(N'2019-06-26T16:36:22.613' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (83, N'44', 24.554013, 46.528806, CAST(N'2019-06-26T16:36:52.440' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (84, N'44', 24.5513411, 46.5275408, CAST(N'2019-06-26T16:37:37.783' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (85, N'44', 24.5509705, 46.5299193, CAST(N'2019-06-26T16:38:09.590' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (86, N'44', 24.5504909, 46.5314498, CAST(N'2019-06-26T16:38:50.147' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (87, N'44', 24.5493739, 46.5306187, CAST(N'2019-06-26T16:39:21.800' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (88, N'44', 24.5475312, 46.5294552, CAST(N'2019-06-26T16:39:54.120' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (89, N'44', 24.5450981, 46.5281693, CAST(N'2019-06-26T16:40:27.130' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (90, N'44', 24.5427605, 46.5275642, CAST(N'2019-06-26T16:40:59.940' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (91, N'44', 24.5398479, 46.5258713, CAST(N'2019-06-26T16:41:32.853' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (92, N'44', 24.5378778, 46.5248972, CAST(N'2019-06-26T16:42:04.300' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (93, N'44', 24.5374178, 46.5246255, CAST(N'2019-06-26T16:42:35.973' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (94, N'44', 24.534523, 46.5234505, CAST(N'2019-06-26T16:43:19.427' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (95, N'44', 24.5328482, 46.5225089, CAST(N'2019-06-26T16:43:53.873' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (96, N'27', 24.6009502, 46.5252281, CAST(N'2019-06-26T16:44:18.657' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (97, N'44', 24.5313643, 46.5218631, CAST(N'2019-06-26T16:44:41.337' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (98, N'44', 24.5275309, 46.5203241, CAST(N'2019-06-26T16:45:13.437' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (99, N'27', 24.595325, 46.5304828, CAST(N'2019-06-26T16:45:18.423' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (100, N'44', 24.527748, 46.5201948, CAST(N'2019-06-26T16:45:55.573' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (101, N'27', 24.5920865, 46.5320076, CAST(N'2019-06-26T16:45:57.043' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (102, N'44', 24.5258957, 46.5187606, CAST(N'2019-06-26T16:46:20.113' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (103, N'27', 24.5886279, 46.5329411, CAST(N'2019-06-26T16:46:37.883' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (104, N'44', 24.5230616, 46.5177858, CAST(N'2019-06-26T16:47:01.880' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (105, N'44', 24.5212027, 46.5163571, CAST(N'2019-06-26T16:47:27.397' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (106, N'27', 24.5865586, 46.5338952, CAST(N'2019-06-26T16:47:38.257' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (107, N'44', 24.5180756, 46.5157282, CAST(N'2019-06-26T16:48:00.893' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (108, N'27', 24.5839004, 46.5349014, CAST(N'2019-06-26T16:48:24.547' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (109, N'44', 24.5142829, 46.5133421, CAST(N'2019-06-26T16:48:41.673' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (110, N'27', 24.5836248, 46.535117, CAST(N'2019-06-26T16:48:54.643' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (111, N'44', 24.5105405, 46.5126668, CAST(N'2019-06-26T16:49:13.197' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (112, N'27', 24.5836659, 46.5350536, CAST(N'2019-06-26T16:49:27.540' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (113, N'44', 24.5106479, 46.5115032, CAST(N'2019-06-26T16:49:45.290' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (114, N'27', 24.583299, 46.5349142, CAST(N'2019-06-26T16:49:57.520' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (115, N'27', 24.5825453, 46.5342941, CAST(N'2019-06-26T16:50:29.583' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (116, N'27', 24.5793819, 46.5330221, CAST(N'2019-06-26T16:51:30.450' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (117, N'27', 24.5786555, 46.53321, CAST(N'2019-06-26T16:52:00.623' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (118, N'27', 24.5753327, 46.53296, CAST(N'2019-06-26T16:52:32.963' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (119, N'27', 24.5716575, 46.5330156, CAST(N'2019-06-26T16:53:04.707' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (120, N'27', 24.5711363, 46.5332901, CAST(N'2019-06-26T16:53:35.030' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (121, N'27', 24.5702534, 46.5336363, CAST(N'2019-06-26T16:54:04.727' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (122, N'27', 24.5667874, 46.5336485, CAST(N'2019-06-26T16:54:35.393' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (123, N'27', 24.5653646, 46.535373, CAST(N'2019-06-26T16:55:13.270' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (124, N'27', 24.5623884, 46.5364097, CAST(N'2019-06-26T16:55:48.433' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (125, N'27', 24.5586155, 46.5374607, CAST(N'2019-06-26T16:56:26.977' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (126, N'27', 24.55809, 46.537907, CAST(N'2019-06-26T16:57:14.510' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (127, N'27', 24.5588508, 46.5398792, CAST(N'2019-06-26T16:57:44.933' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (128, N'27', 24.5588592, 46.5393524, CAST(N'2019-06-26T16:58:14.403' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (129, N'27', 24.558731, 46.5396083, CAST(N'2019-06-26T16:58:58.140' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (130, N'27', 24.557523, 46.5415305, CAST(N'2019-06-26T16:59:27.973' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (131, N'27', 24.5599158, 46.5435938, CAST(N'2019-06-26T17:00:00.577' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (132, N'27', 24.5602995, 46.5438159, CAST(N'2019-06-26T17:00:32.657' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (133, N'27', 24.5623387, 46.5451015, CAST(N'2019-06-26T17:01:06.003' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (134, N'27', 24.5633739, 46.5458269, CAST(N'2019-06-26T17:01:35.730' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (135, N'27', 24.5636812, 46.5467644, CAST(N'2019-06-26T17:02:08.440' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (136, N'27', 24.5642989, 46.5477572, CAST(N'2019-06-26T17:02:44.907' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (137, N'27', 24.5644631, 46.5482136, CAST(N'2019-06-26T17:03:13.873' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (138, N'27', 24.5653755, 46.5507911, CAST(N'2019-06-26T17:03:57.757' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (139, N'27', 24.5659393, 46.5514108, CAST(N'2019-06-26T17:04:27.710' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (140, N'27', 24.5670751, 46.5522637, CAST(N'2019-06-26T17:04:59.553' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (141, N'27', 24.5685149, 46.5533856, CAST(N'2019-06-26T17:05:31.840' AS DateTime), NULL)
GO
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (142, N'27', 24.5708241, 46.5550721, CAST(N'2019-06-26T17:06:05.197' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (143, N'27', 24.5747573, 46.557224, CAST(N'2019-06-26T17:06:45.510' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (144, N'27', 24.5758005, 46.5577898, CAST(N'2019-06-26T17:07:23.317' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (145, N'27', 24.5760309, 46.5577892, CAST(N'2019-06-26T17:08:05.497' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (146, N'27', 24.5789918, 46.5574362, CAST(N'2019-06-26T17:08:50.510' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (147, N'27', 24.5799854, 46.5594211, CAST(N'2019-06-26T17:09:27.197' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (148, N'27', 24.5823692, 46.5594894, CAST(N'2019-06-26T17:10:32.180' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (149, N'27', 24.5807023, 46.5558976, CAST(N'2019-06-26T17:11:51.073' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (150, N'27', 24.5789186, 46.5544426, CAST(N'2019-06-26T17:12:29.383' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (151, N'27', 24.5768529, 46.5531425, CAST(N'2019-06-26T17:13:04.997' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (152, N'27', 24.5744794, 46.5512834, CAST(N'2019-06-26T17:13:43.387' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (153, N'27', 24.5732322, 46.5505956, CAST(N'2019-06-26T17:14:36.053' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (154, N'27', 24.5720858, 46.5478337, CAST(N'2019-06-26T17:15:10.897' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (155, N'27', 24.5693321, 46.5466589, CAST(N'2019-06-26T17:15:36.933' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (156, N'27', 24.5680215, 46.5463701, CAST(N'2019-06-26T17:16:28.677' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (157, N'27', 24.5630456, 46.5464153, CAST(N'2019-06-26T17:17:16.650' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (158, N'27', 24.5611403, 46.5455725, CAST(N'2019-06-26T17:17:46.593' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (159, N'27', 24.5613891, 46.5459366, CAST(N'2019-06-26T17:18:19.597' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (160, N'27', 24.5596009, 46.5437674, CAST(N'2019-06-26T17:18:54.347' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (161, N'27', 24.5575978, 46.5407641, CAST(N'2019-06-26T17:19:24.097' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (162, N'27', 24.5575121, 46.5404647, CAST(N'2019-06-26T17:19:56.203' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (163, N'27', 24.5582678, 46.5401891, CAST(N'2019-06-26T17:20:57.497' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (164, N'27', 24.5608664, 46.5393616, CAST(N'2019-06-26T17:21:34.543' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (165, N'27', 24.5626586, 46.5396328, CAST(N'2019-06-26T17:22:14.403' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (166, N'27', 24.565964, 46.5380702, CAST(N'2019-06-26T17:22:51.577' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (167, N'27', 24.5652051, 46.5349065, CAST(N'2019-06-26T17:24:08.343' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (168, N'27', 24.5678556, 46.5332915, CAST(N'2019-06-26T17:24:39.947' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (169, N'27', 24.5722176, 46.5328238, CAST(N'2019-06-26T17:25:12.407' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (170, N'27', 24.5722713, 46.5327494, CAST(N'2019-06-26T17:25:44.530' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (171, N'27', 24.5761201, 46.5328236, CAST(N'2019-06-26T17:26:29.430' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (172, N'27', 24.5796256, 46.5329625, CAST(N'2019-06-26T17:27:26.903' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (173, N'27', 24.5818283, 46.5335463, CAST(N'2019-06-26T17:27:56.913' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (174, N'27', 24.5833992, 46.5349517, CAST(N'2019-06-26T17:28:28.417' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (175, N'27', 24.5843551, 46.5346317, CAST(N'2019-06-26T17:29:01.563' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (176, N'27', 24.5856368, 46.5341309, CAST(N'2019-06-26T17:29:31.817' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (177, N'27', 24.5893276, 46.5328713, CAST(N'2019-06-26T17:30:04.440' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (178, N'27', 24.5897343, 46.5326618, CAST(N'2019-06-26T17:30:36.610' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (179, N'27', 24.5923824, 46.5319202, CAST(N'2019-06-26T17:31:06.633' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (180, N'27', 24.5931018, 46.5308896, CAST(N'2019-06-26T17:31:37.267' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (181, N'27', 24.5980571, 46.5274915, CAST(N'2019-06-26T17:32:11.173' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (182, N'27', 24.6009079, 46.5246342, CAST(N'2019-06-26T17:33:25.433' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (183, N'27', 24.5986195, 46.5234808, CAST(N'2019-06-26T17:34:05.553' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (184, N'44', 24.5108932, 46.5124293, CAST(N'2019-06-26T18:14:28.240' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (185, N'44', 24.5117582, 46.5122102, CAST(N'2019-06-26T18:15:04.730' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (186, N'44', 24.5194087, 46.5159225, CAST(N'2019-06-26T18:15:35.200' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (187, N'44', 24.5220822, 46.5181129, CAST(N'2019-06-26T18:16:09.557' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (188, N'44', 24.5285971, 46.5205501, CAST(N'2019-06-26T18:17:01.267' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (189, N'44', 24.5314761, 46.5217604, CAST(N'2019-06-26T18:17:39.337' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (190, N'44', 24.5316149, 46.5218464, CAST(N'2019-06-26T18:18:10.297' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (191, N'44', 24.5317933, 46.5218644, CAST(N'2019-06-26T18:18:46.837' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (192, N'44', 24.5335499, 46.5226283, CAST(N'2019-06-26T18:19:10.543' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (193, N'44', 24.5354854, 46.5236093, CAST(N'2019-06-26T18:19:49.300' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (194, N'44', 24.5376774, 46.5247936, CAST(N'2019-06-26T18:20:12.570' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (195, N'44', 24.5384114, 46.5253747, CAST(N'2019-06-26T18:21:02.413' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (196, N'44', 24.538302, 46.5254008, CAST(N'2019-06-26T18:21:28.917' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (197, N'44', 24.5412585, 46.5267833, CAST(N'2019-06-26T18:22:06.687' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (198, N'44', 24.5450248, 46.5282241, CAST(N'2019-06-26T18:22:28.907' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (199, N'44', 24.5460929, 46.5291569, CAST(N'2019-06-26T18:23:01.943' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (200, N'44', 24.5491382, 46.5309113, CAST(N'2019-06-26T18:23:50.300' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (201, N'44', 24.5503605, 46.5315705, CAST(N'2019-06-26T18:24:26.867' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (202, N'44', 24.5509874, 46.5282463, CAST(N'2019-06-26T18:25:04.630' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (203, N'44', 24.5531062, 46.5284762, CAST(N'2019-06-26T18:25:42.377' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (204, N'44', 24.5558265, 46.5301754, CAST(N'2019-06-26T18:26:26.590' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (205, N'44', 24.5564647, 46.5307095, CAST(N'2019-06-26T18:26:57.010' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (206, N'44', 24.5560547, 46.5323722, CAST(N'2019-06-26T18:27:32.837' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (207, N'44', 24.5593472, 46.5331656, CAST(N'2019-06-26T18:28:05.400' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (208, N'44', 24.5586717, 46.5362952, CAST(N'2019-06-26T18:28:54.047' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (209, N'44', 24.5583394, 46.5369873, CAST(N'2019-06-26T18:29:33.837' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (210, N'44', 24.5597353, 46.5376215, CAST(N'2019-06-26T18:30:18.220' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (211, N'44', 24.5645152, 46.5354276, CAST(N'2019-06-26T18:30:59.003' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (212, N'44', 24.5663245, 46.534055, CAST(N'2019-06-26T18:31:43.167' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (213, N'44', 24.5696831, 46.5336531, CAST(N'2019-06-26T18:32:25.083' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (214, N'44', 24.5717209, 46.5330741, CAST(N'2019-06-26T18:33:12.573' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (215, N'44', 24.5720899, 46.5355354, CAST(N'2019-06-26T18:33:44.267' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (216, N'44', 24.5715249, 46.5376765, CAST(N'2019-06-26T18:34:22.497' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (217, N'44', 24.5732375, 46.538088, CAST(N'2019-06-26T18:34:55.057' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (218, N'44', 24.57484, 46.5358147, CAST(N'2019-06-26T18:35:39.437' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (219, N'44', 24.5753325, 46.5354479, CAST(N'2019-06-26T18:36:12.187' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (220, N'44', 24.5769845, 46.5359304, CAST(N'2019-06-26T18:36:42.217' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (221, N'44', 24.5793248, 46.5353079, CAST(N'2019-06-26T18:37:25.053' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (222, N'44', 24.5805958, 46.536034, CAST(N'2019-06-26T18:38:04.017' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (223, N'44', 24.5824444, 46.5354433, CAST(N'2019-06-26T18:39:08.580' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (224, N'44', 24.583781, 46.5356372, CAST(N'2019-06-26T18:39:39.477' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (225, N'44', 24.5846077, 46.5371273, CAST(N'2019-06-26T18:40:11.487' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (226, N'44', 24.5843133, 46.5378927, CAST(N'2019-06-26T18:40:44.063' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (227, N'44', 24.5844471, 46.5392219, CAST(N'2019-06-26T18:41:19.197' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (228, N'44', 24.58819, 46.5383225, CAST(N'2019-06-26T18:41:58.670' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (229, N'44', 24.5912833, 46.5367139, CAST(N'2019-06-26T18:42:31.187' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (230, N'44', 24.5930518, 46.53652, CAST(N'2019-06-26T18:43:03.793' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (231, N'44', 24.5946402, 46.5353405, CAST(N'2019-06-26T18:43:37.480' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (232, N'44', 24.5930986, 46.53487, CAST(N'2019-06-26T18:44:07.620' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (233, N'44', 24.5898796, 46.5337962, CAST(N'2019-06-26T18:44:52.480' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (234, N'44', 24.5892316, 46.532944, CAST(N'2019-06-26T18:45:22.763' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (235, N'44', 24.5897774, 46.5327493, CAST(N'2019-06-26T18:45:56.013' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (236, N'44', 24.5920198, 46.5320518, CAST(N'2019-06-26T18:46:28.430' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (237, N'44', 24.5950737, 46.5310698, CAST(N'2019-06-26T18:47:03.563' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (238, N'44', 24.5984578, 46.5276369, CAST(N'2019-06-26T18:47:48.077' AS DateTime), NULL)
INSERT [dbo].[BusTrace] ([Id], [BusId], [Longitude], [Latitude], [Timestamp], [speed]) VALUES (239, N'44', 24.6010125, 46.5248785, CAST(N'2019-06-26T18:48:24.000' AS DateTime), NULL)
SET IDENTITY_INSERT [dbo].[BusTrace] OFF
SET IDENTITY_INSERT [dbo].[References] ON
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (1, 1, 2, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (2, 2, 3, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (3, 3, 4, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (4, 4, 5, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (5, 5, 6, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (6, 6, 7, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (7, 7, 8, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (8, 8, 9, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (9, 9, 10, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (10, 10, 11, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (11, 11, 12, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (12, 12, 13, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (13, 13, 14, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (14, 14, 15, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (15, 15, 16, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (16, 16, 17, CAST(N'00:07:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (17, 17, 18, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (18, 18, 19, CAST(N'00:06:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (19, 19, 20, CAST(N'00:06:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (20, 20, 21, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (21, 21, 22, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (22, 22, 23, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (23, 23, 24, CAST(N'00:03:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (24, 24, 25, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (25, 25, 26, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (26, 26, 27, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (27, 27, 28, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (28, 28, 29, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (29, 29, 30, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (30, 30, 31, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (31, 31, 32, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (32, 32, 33, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (33, 33, 34, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (34, 34, 35, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (35, 35, 36, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (36, 36, 37, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (37, 37, 38, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (38, 38, 39, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (39, 39, 40, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (40, 40, 41, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (41, 41, 42, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (42, 42, 43, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (43, 43, 44, CAST(N'00:03:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (44, 44, 1, CAST(N'00:03:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (45, 44, 45, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (46, 45, 46, CAST(N'00:06:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (47, 46, 47, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (48, 47, 48, CAST(N'00:07:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (49, 48, 49, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (50, 49, 50, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (51, 50, 51, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (52, 51, 52, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (53, 52, 53, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (54, 53, 54, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (55, 54, 55, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (56, 55, 56, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (57, 56, 57, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (58, 57, 58, CAST(N'00:03:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (59, 58, 59, CAST(N'00:03:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (60, 59, 40, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (62, 60, 61, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (63, 61, 62, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (64, 62, 63, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (65, 63, 10, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (66, 12, 76, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (67, 76, 47, CAST(N'00:07:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (68, 47, 64, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (69, 64, 65, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (70, 65, 66, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (71, 66, 67, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (72, 67, 68, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (73, 68, 69, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (74, 69, 70, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (75, 70, 71, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (76, 71, 56, CAST(N'00:05:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (77, 57, 72, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (78, 72, 61, CAST(N'00:06:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (79, 61, 73, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (80, 73, 74, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (81, 74, 75, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
INSERT [dbo].[References] ([id], [From], [To], [duration], [intervalTime]) VALUES (82, 75, 43, CAST(N'00:04:00' AS Time), CAST(N'2016-12-21T00:00:00.000' AS DateTime))
SET IDENTITY_INSERT [dbo].[References] OFF
SET IDENTITY_INSERT [dbo].[Timetable] ON
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (1, 44, CAST(N'05:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (2, 44, CAST(N'05:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (3, 44, CAST(N'05:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (4, 44, CAST(N'06:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (5, 44, CAST(N'06:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (6, 44, CAST(N'06:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (7, 44, CAST(N'07:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (8, 44, CAST(N'07:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (9, 44, CAST(N'07:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (10, 44, CAST(N'08:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (11, 44, CAST(N'08:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (12, 44, CAST(N'08:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (13, 44, CAST(N'09:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (14, 44, CAST(N'09:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (15, 44, CAST(N'09:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (16, 44, CAST(N'10:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (17, 44, CAST(N'10:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (18, 44, CAST(N'10:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (19, 44, CAST(N'11:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (20, 44, CAST(N'11:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (21, 44, CAST(N'11:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (22, 44, CAST(N'12:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (23, 44, CAST(N'12:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (24, 44, CAST(N'12:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (25, 44, CAST(N'13:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (26, 44, CAST(N'13:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (27, 44, CAST(N'13:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (28, 44, CAST(N'14:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (29, 44, CAST(N'14:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (30, 44, CAST(N'14:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (31, 44, CAST(N'15:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (32, 44, CAST(N'15:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (33, 44, CAST(N'15:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (34, 44, CAST(N'16:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (35, 44, CAST(N'16:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (36, 44, CAST(N'16:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (37, 44, CAST(N'17:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (38, 44, CAST(N'17:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (39, 44, CAST(N'17:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (40, 44, CAST(N'18:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (41, 44, CAST(N'18:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (42, 44, CAST(N'18:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (43, 44, CAST(N'19:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (44, 44, CAST(N'19:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (45, 44, CAST(N'19:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (46, 44, CAST(N'20:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (47, 44, CAST(N'20:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (48, 44, CAST(N'20:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (49, 44, CAST(N'21:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (50, 44, CAST(N'21:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (51, 44, CAST(N'22:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (52, 44, CAST(N'05:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (53, 44, CAST(N'05:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (54, 44, CAST(N'05:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (55, 44, CAST(N'06:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (56, 44, CAST(N'06:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (57, 44, CAST(N'06:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (58, 44, CAST(N'07:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (59, 44, CAST(N'07:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (60, 44, CAST(N'07:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (61, 44, CAST(N'08:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (62, 44, CAST(N'08:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (63, 44, CAST(N'08:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (64, 44, CAST(N'09:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (65, 44, CAST(N'09:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (66, 44, CAST(N'09:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (67, 44, CAST(N'10:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (68, 44, CAST(N'10:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (69, 44, CAST(N'10:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (70, 44, CAST(N'11:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (71, 44, CAST(N'11:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (72, 44, CAST(N'11:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (73, 44, CAST(N'12:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (74, 44, CAST(N'12:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (75, 44, CAST(N'12:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (76, 44, CAST(N'13:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (77, 44, CAST(N'13:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (78, 44, CAST(N'13:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (79, 44, CAST(N'14:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (80, 44, CAST(N'14:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (81, 44, CAST(N'14:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (82, 44, CAST(N'15:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (83, 44, CAST(N'15:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (84, 44, CAST(N'15:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (85, 44, CAST(N'16:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (86, 44, CAST(N'16:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (87, 44, CAST(N'16:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (88, 44, CAST(N'17:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (89, 44, CAST(N'17:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (90, 44, CAST(N'17:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (91, 44, CAST(N'18:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (92, 44, CAST(N'18:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (93, 44, CAST(N'18:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (94, 44, CAST(N'19:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (95, 44, CAST(N'19:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (96, 44, CAST(N'19:50:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (97, 44, CAST(N'20:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (98, 44, CAST(N'20:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (99, 44, CAST(N'20:50:00' AS Time), 24, 1)
GO
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (100, 44, CAST(N'21:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (102, 44, CAST(N'21:30:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (103, 44, CAST(N'22:10:00' AS Time), 24, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (104, 44, CAST(N'05:20:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (105, 44, CAST(N'06:15:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (107, 44, CAST(N'06:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (108, 44, CAST(N'07:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (109, 44, CAST(N'08:10:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (110, 44, CAST(N'08:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (111, 44, CAST(N'09:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (112, 44, CAST(N'10:10:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (113, 44, CAST(N'10:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (114, 44, CAST(N'11:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (115, 44, CAST(N'12:10:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (116, 44, CAST(N'12:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (117, 44, CAST(N'13:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (118, 44, CAST(N'14:10:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (119, 44, CAST(N'14:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (120, 44, CAST(N'15:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (121, 44, CAST(N'16:10:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (122, 44, CAST(N'16:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (123, 44, CAST(N'17:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (124, 44, CAST(N'18:10:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (125, 44, CAST(N'18:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (126, 44, CAST(N'19:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (127, 44, CAST(N'20:10:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (128, 44, CAST(N'20:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (129, 44, CAST(N'21:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (130, 44, CAST(N'22:10:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (131, 44, CAST(N'05:30:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (132, 44, CAST(N'06:10:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (133, 44, CAST(N'06:50:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (134, 44, CAST(N'07:30:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (135, 44, CAST(N'08:10:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (136, 44, CAST(N'08:50:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (137, 44, CAST(N'09:30:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (138, 44, CAST(N'10:10:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (139, 44, CAST(N'10:50:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (140, 44, CAST(N'11:30:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (141, 44, CAST(N'12:10:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (142, 44, CAST(N'12:50:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (143, 44, CAST(N'13:30:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (144, 44, CAST(N'14:10:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (145, 44, CAST(N'14:50:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (146, 44, CAST(N'15:30:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (147, 44, CAST(N'16:10:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (148, 44, CAST(N'16:50:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (149, 44, CAST(N'17:30:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (150, 44, CAST(N'18:10:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (151, 44, CAST(N'18:50:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (152, 44, CAST(N'19:30:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (153, 44, CAST(N'20:10:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (154, 44, CAST(N'20:50:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (155, 44, CAST(N'21:30:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (156, 44, CAST(N'22:10:00' AS Time), 24, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (157, 26, CAST(N'05:20:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (158, 26, CAST(N'05:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (159, 26, CAST(N'06:20:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (160, 26, CAST(N'06:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (161, 26, CAST(N'07:20:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (162, 26, CAST(N'07:55:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (163, 26, CAST(N'08:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (164, 26, CAST(N'09:05:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (165, 26, CAST(N'09:40:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (166, 26, CAST(N'10:15:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (167, 26, CAST(N'10:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (168, 26, CAST(N'11:25:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (169, 26, CAST(N'12:00:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (170, 26, CAST(N'12:35:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (171, 26, CAST(N'13:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (172, 26, CAST(N'13:45:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (173, 26, CAST(N'14:20:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (174, 26, CAST(N'14:55:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (175, 26, CAST(N'15:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (176, 26, CAST(N'16:05:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (177, 26, CAST(N'16:40:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (178, 26, CAST(N'17:15:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (179, 26, CAST(N'17:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (180, 26, CAST(N'18:25:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (181, 26, CAST(N'19:00:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (182, 26, CAST(N'19:35:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (183, 26, CAST(N'20:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (184, 26, CAST(N'20:45:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (185, 26, CAST(N'21:20:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (186, 26, CAST(N'22:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (187, 26, CAST(N'05:20:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (188, 26, CAST(N'05:50:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (189, 26, CAST(N'06:20:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (190, 26, CAST(N'06:50:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (191, 26, CAST(N'07:20:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (192, 26, CAST(N'07:55:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (193, 26, CAST(N'08:30:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (194, 26, CAST(N'09:05:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (195, 26, CAST(N'09:40:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (196, 26, CAST(N'10:15:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (197, 26, CAST(N'10:50:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (198, 26, CAST(N'11:25:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (199, 26, CAST(N'12:00:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (200, 26, CAST(N'12:35:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (201, 26, CAST(N'13:10:00' AS Time), 51, 1)
GO
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (202, 26, CAST(N'13:45:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (203, 26, CAST(N'14:20:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (204, 26, CAST(N'14:55:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (205, 26, CAST(N'15:30:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (206, 26, CAST(N'16:05:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (207, 26, CAST(N'16:40:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (208, 26, CAST(N'17:15:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (209, 26, CAST(N'17:50:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (210, 26, CAST(N'18:25:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (211, 26, CAST(N'19:00:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (212, 26, CAST(N'19:35:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (213, 26, CAST(N'20:10:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (214, 26, CAST(N'20:45:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (215, 26, CAST(N'21:20:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (216, 26, CAST(N'22:10:00' AS Time), 51, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (217, 26, CAST(N'05:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (218, 26, CAST(N'06:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (219, 26, CAST(N'07:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (220, 26, CAST(N'08:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (221, 26, CAST(N'09:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (222, 26, CAST(N'10:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (223, 26, CAST(N'11:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (224, 26, CAST(N'12:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (227, 26, CAST(N'15:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (228, 26, CAST(N'16:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (229, 26, CAST(N'17:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (230, 26, CAST(N'18:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (231, 26, CAST(N'19:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (232, 26, CAST(N'20:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (233, 26, CAST(N'21:30:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (234, 26, CAST(N'05:10:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (235, 26, CAST(N'06:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (236, 26, CAST(N'07:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (237, 26, CAST(N'08:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (238, 26, CAST(N'09:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (239, 26, CAST(N'10:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (240, 26, CAST(N'11:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (241, 26, CAST(N'12:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (242, 26, CAST(N'13:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (243, 26, CAST(N'14:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (244, 26, CAST(N'15:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (245, 26, CAST(N'16:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (246, 26, CAST(N'17:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (247, 26, CAST(N'18:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (248, 26, CAST(N'19:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (249, 26, CAST(N'20:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (250, 26, CAST(N'21:00:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (251, 26, CAST(N'22:10:00' AS Time), 51, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (252, 27, CAST(N'05:00:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (253, 27, CAST(N'05:35:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (254, 27, CAST(N'06:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (255, 27, CAST(N'06:45:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (256, 27, CAST(N'07:20:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (257, 27, CAST(N'07:55:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (258, 27, CAST(N'08:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (259, 27, CAST(N'09:05:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (260, 27, CAST(N'09:40:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (261, 27, CAST(N'10:15:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (262, 27, CAST(N'10:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (263, 27, CAST(N'11:25:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (264, 27, CAST(N'12:00:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (265, 27, CAST(N'12:35:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (266, 27, CAST(N'13:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (267, 27, CAST(N'13:45:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (268, 27, CAST(N'14:20:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (269, 27, CAST(N'14:55:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (270, 27, CAST(N'15:30:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (271, 27, CAST(N'16:05:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (272, 27, CAST(N'16:40:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (273, 27, CAST(N'17:15:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (274, 27, CAST(N'17:50:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (275, 27, CAST(N'18:25:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (276, 27, CAST(N'19:00:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (277, 27, CAST(N'19:35:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (278, 27, CAST(N'20:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (279, 27, CAST(N'20:45:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (280, 27, CAST(N'21:40:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (281, 27, CAST(N'22:10:00' AS Time), 1, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (282, 27, CAST(N'05:00:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (283, 27, CAST(N'05:30:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (284, 27, CAST(N'06:05:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (285, 27, CAST(N'06:40:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (286, 27, CAST(N'07:15:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (287, 27, CAST(N'07:50:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (288, 27, CAST(N'08:25:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (289, 27, CAST(N'09:00:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (290, 27, CAST(N'09:35:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (291, 27, CAST(N'10:10:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (292, 27, CAST(N'10:45:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (293, 27, CAST(N'11:20:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (294, 27, CAST(N'11:55:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (295, 27, CAST(N'12:30:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (296, 27, CAST(N'13:05:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (297, 27, CAST(N'13:40:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (298, 27, CAST(N'14:15:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (299, 27, CAST(N'14:50:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (300, 27, CAST(N'15:25:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (301, 27, CAST(N'16:00:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (302, 27, CAST(N'16:35:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (303, 27, CAST(N'17:10:00' AS Time), 67, 1)
GO
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (304, 27, CAST(N'17:45:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (305, 27, CAST(N'18:20:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (306, 27, CAST(N'18:55:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (307, 27, CAST(N'19:30:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (308, 27, CAST(N'20:05:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (309, 27, CAST(N'20:40:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (310, 27, CAST(N'21:15:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (311, 27, CAST(N'22:10:00' AS Time), 67, 1)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (312, 27, CAST(N'05:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (313, 27, CAST(N'06:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (314, 27, CAST(N'07:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (315, 27, CAST(N'08:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (316, 27, CAST(N'09:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (317, 27, CAST(N'10:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (318, 27, CAST(N'11:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (319, 27, CAST(N'12:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (320, 27, CAST(N'13:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (321, 27, CAST(N'14:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (322, 27, CAST(N'15:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (323, 27, CAST(N'16:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (324, 27, CAST(N'17:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (325, 27, CAST(N'18:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (326, 27, CAST(N'19:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (327, 27, CAST(N'20:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (328, 27, CAST(N'21:50:00' AS Time), 1, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (329, 27, CAST(N'06:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (330, 27, CAST(N'07:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (331, 27, CAST(N'08:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (332, 27, CAST(N'09:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (333, 27, CAST(N'10:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (334, 27, CAST(N'11:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (335, 27, CAST(N'12:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (336, 27, CAST(N'13:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (337, 27, CAST(N'14:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (338, 27, CAST(N'15:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (339, 27, CAST(N'16:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (340, 27, CAST(N'17:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (341, 27, CAST(N'18:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (342, 27, CAST(N'19:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (343, 27, CAST(N'20:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (344, 27, CAST(N'21:15:00' AS Time), 67, 0)
INSERT [dbo].[Timetable] ([id], [busNr], [startTime], [stationID], [weekday]) VALUES (345, 27, CAST(N'20:10:00' AS Time), 67, 0)
SET IDENTITY_INSERT [dbo].[Timetable] OFF