-
Notifications
You must be signed in to change notification settings - Fork 9
/
Copy pathwaste_manage.sql
1024 lines (993 loc) · 62 KB
/
waste_manage.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
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
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 4.6.6deb5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 08, 2019 at 01:50 AM
-- Server version: 5.7.25-0ubuntu0.18.04.2
-- PHP Version: 7.2.15-0ubuntu0.18.04.2
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `waste_manage`
--
-- --------------------------------------------------------
--
-- Table structure for table `bin_master`
--
CREATE TABLE `bin_master` (
`bin_id` varchar(35) NOT NULL,
`bin_location_name` varchar(50) NOT NULL,
`description` text NOT NULL,
`created_by` int(11) NOT NULL,
`created_on` datetime NOT NULL,
`latitude` varchar(20) DEFAULT NULL,
`longitude` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bin_master`
--
INSERT INTO `bin_master` (`bin_id`, `bin_location_name`, `description`, `created_by`, `created_on`, `latitude`, `longitude`) VALUES
('OD001', 'KharavelaNagar', 'KharavelaNagar first bin', 1, '2018-07-22 02:38:19', '20.2728', '85.8409'),
('OD004', 'VaniVihar', 'VaniVihar first bin', 1, '2018-07-22 02:19:32', '20.3040', '85.8397'),
('OD007', 'SatyaNagar', 'SatyaNagar first bin', 1, '2018-07-22 02:55:42', '20.2804', '85.8499'),
('OD012', 'Nayapalli', 'Nayapalli first bin', 1, '2018-07-22 02:35:34', '20.2899', '85.8102'),
('OD013', 'JaydevVihar', 'JaydevVihar first bin', 1, '2018-07-22 02:31:04', '20.299', '85.8173'),
('OD021', 'SailashreeVihar', 'SailashreeVihar first bin', 1, '2018-07-21 23:27:06', '20.3329', '85.8070'),
('OD022', 'AcharyaVihar', 'AcharyaVihar first bin', 1, '2018-07-22 02:28:41', '20.2948', '85.8294'),
('OD024', 'Patia', 'Patia first bin', 1, '2018-07-21 23:37:30', '20.3619', '85.8310');
-- --------------------------------------------------------
--
-- Table structure for table `bin_sensor_data`
--
CREATE TABLE `bin_sensor_data` (
`id` bigint(20) NOT NULL,
`fk_bin_id` varchar(35) NOT NULL,
`is_bin_present` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - bin present at the location, 0 - bin missing',
`latitude` varchar(20) DEFAULT NULL,
`longitude` varchar(20) DEFAULT NULL,
`bin_level` int(10) NOT NULL,
`created_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bin_sensor_data`
--
INSERT INTO `bin_sensor_data` (`id`, `fk_bin_id`, `is_bin_present`, `latitude`, `longitude`, `bin_level`, `created_time`) VALUES
(988, 'OD004', 1, '20.3040', '85.8397', 40, '2018-07-23 13:34:46'),
(989, 'OD007', 1, '20.2804', '85.8499', 21, '2018-07-23 13:34:46'),
(990, 'OD012', 1, '20.2899', '85.8102', 58, '2018-07-23 13:34:46'),
(991, 'OD013', 1, '20.2990', '85.8173', 37, '2018-07-23 13:34:47'),
(992, 'OD004', 1, '20.3040', '85.8397', 37, '2018-07-23 13:35:07'),
(993, 'OD007', 1, '20.2804', '85.8499', 0, '2018-07-23 13:35:08'),
(994, 'OD012', 1, '20.2899', '85.8102', 56, '2018-07-23 13:35:08'),
(995, 'OD013', 1, '20.2990', '85.8173', 31, '2018-07-23 13:35:08'),
(996, 'OD004', 0, '20.3040', '85.8397', 0, '2018-07-23 13:35:28'),
(997, 'OD007', 1, '20.2804', '85.8499', 0, '2018-07-23 13:35:29'),
(998, 'OD012', 1, '20.2899', '85.8102', 56, '2018-07-23 13:35:29'),
(999, 'OD013', 1, '20.2990', '85.8173', 31, '2018-07-23 13:35:29'),
(1000, 'OD004', 0, '20.3040', '85.8397', 0, '2018-07-23 13:35:49'),
(1001, 'OD007', 1, '20.2804', '85.8499', 0, '2018-07-23 13:35:50'),
(1002, 'OD012', 1, '20.2899', '85.8102', 43, '2018-07-23 13:35:50'),
(1003, 'OD013', 1, '20.2990', '85.8173', 33, '2018-07-23 13:35:50'),
(1004, 'OD004', 0, '20.3040', '85.8397', 0, '2018-07-23 13:36:11'),
(1005, 'OD007', 1, '20.2804', '85.8499', 0, '2018-07-23 13:36:11'),
(1006, 'OD012', 1, '20.2899', '85.8102', 55, '2018-07-23 13:36:11'),
(1007, 'OD013', 1, '20.2990', '85.8173', 17, '2018-07-23 13:36:11'),
(1008, 'OD004', 0, '20.3040', '85.8397', 0, '2018-07-23 13:36:32'),
(1009, 'OD007', 1, '20.2804', '85.8499', 0, '2018-07-23 13:36:32'),
(1010, 'OD012', 1, '20.2899', '85.8102', 54, '2018-07-23 13:36:32'),
(1011, 'OD013', 1, '20.2990', '85.8173', 30, '2018-07-23 13:36:32'),
(1012, 'OD004', 0, '20.3040', '85.8397', 0, '2018-07-23 13:36:53'),
(1013, 'OD007', 1, '20.2804', '85.8499', 0, '2018-07-23 13:36:53'),
(1014, 'OD012', 1, '20.2899', '85.8102', 0, '2018-07-23 13:36:53'),
(1015, 'OD013', 1, '20.2990', '85.8173', 33, '2018-07-23 13:36:53'),
(1016, 'OD004', 0, '20.3040', '85.8397', 0, '2018-07-23 13:37:14'),
(1017, 'OD007', 1, '20.2804', '85.8499', 0, '2018-07-23 13:37:14'),
(1018, 'OD012', 1, '20.2899', '85.8102', 57, '2018-07-23 13:37:14'),
(1019, 'OD013', 1, '20.2990', '85.8173', 32, '2018-07-23 13:37:14'),
(1020, 'OD004', 0, '20.3040', '85.8397', 0, '2018-07-23 13:37:35'),
(1021, 'OD007', 1, '20.2804', '85.8499', 0, '2018-07-23 13:37:35'),
(1022, 'OD012', 1, '20.2899', '85.8102', 85, '2018-07-23 13:37:35'),
(1023, 'OD013', 1, '20.2990', '85.8173', 30, '2018-07-23 13:37:35'),
(1024, 'OD004', 1, '20.3040', '85.8397', 75, '2018-07-23 15:58:20'),
(1025, 'OD007', 1, '20.2804', '85.8499', 64, '2018-07-23 15:58:21'),
(1026, 'OD012', 1, '20.2899', '85.8102', 76, '2018-07-23 15:58:21'),
(1027, 'OD013', 1, '20.2990', '85.8173', 53, '2018-07-23 15:58:21'),
(1028, 'OD004', 1, '20.3040', '85.8397', 29, '2018-07-23 15:58:42'),
(1029, 'OD007', 1, '20.2804', '85.8499', 24, '2018-07-23 15:58:42'),
(1030, 'OD012', 1, '20.2899', '85.8102', 0, '2018-07-23 15:58:42'),
(1031, 'OD013', 1, '20.2990', '85.8173', 30, '2018-07-23 15:58:42'),
(1032, 'OD004', 0, '20.3040', '85.8397', 0, '2018-07-23 15:59:03'),
(1033, 'OD007', 1, '20.2804', '85.8499', 24, '2018-07-23 15:59:03'),
(1034, 'OD012', 1, '20.2899', '85.8102', 23, '2018-07-23 15:59:03'),
(1035, 'OD013', 1, '20.2990', '85.8173', 38, '2018-07-23 15:59:03'),
(1036, 'OD004', 1, '20.3040', '85.8397', 32, '2018-07-23 15:59:24'),
(1037, 'OD007', 1, '20.2804', '85.8499', 24, '2018-07-23 15:59:24'),
(1038, 'OD012', 1, '20.2899', '85.8102', 38, '2018-07-23 15:59:24'),
(1039, 'OD013', 1, '20.2990', '85.8173', 38, '2018-07-23 15:59:24'),
(1040, 'OD004', 1, '20.3040', '85.8397', 28, '2018-07-23 15:59:45'),
(1041, 'OD007', 1, '20.2804', '85.8499', 25, '2018-07-23 15:59:45'),
(1042, 'OD012', 1, '20.2899', '85.8102', 39, '2018-07-23 15:59:45'),
(1043, 'OD013', 1, '20.2990', '85.8173', 25, '2018-07-23 15:59:46'),
(1044, 'OD004', 1, '20.3040', '85.8397', 33, '2018-07-23 16:00:06'),
(1045, 'OD007', 1, '20.2804', '85.8499', 24, '2018-07-23 16:00:06'),
(1046, 'OD012', 1, '20.2899', '85.8102', 0, '2018-07-23 16:00:07'),
(1047, 'OD013', 1, '20.2990', '85.8173', 29, '2018-07-23 16:00:07'),
(1048, 'OD004', 1, '20.3040', '85.8397', 29, '2018-07-23 16:00:27'),
(1049, 'OD007', 1, '20.2804', '85.8499', 29, '2018-07-23 16:00:27'),
(1050, 'OD012', 1, '20.2899', '85.8102', 0, '2018-07-23 16:00:28'),
(1051, 'OD013', 1, '20.2990', '85.8173', 35, '2018-07-23 16:00:28'),
(1052, 'OD004', 1, '20.3040', '85.8397', 24, '2018-07-23 16:00:48'),
(1053, 'OD007', 1, '20.2804', '85.8499', 26, '2018-07-23 16:00:49'),
(1054, 'OD012', 1, '20.2899', '85.8102', 65, '2018-07-23 16:00:49'),
(1055, 'OD013', 1, '20.2990', '85.8173', 32, '2018-07-23 16:00:49'),
(1056, 'OD004', 1, '20.3040', '85.8397', 29, '2018-07-23 16:01:09'),
(1057, 'OD007', 1, '20.2804', '85.8499', 23, '2018-07-23 16:01:10'),
(1058, 'OD012', 1, '20.2899', '85.8102', 69, '2018-07-23 16:01:10'),
(1059, 'OD013', 1, '20.2990', '85.8173', 30, '2018-07-23 16:01:10'),
(1060, 'OD004', 1, '20.3040', '85.8397', 31, '2018-07-23 16:01:30'),
(1061, 'OD007', 1, '20.2804', '85.8499', 29, '2018-07-23 16:01:31'),
(1062, 'OD012', 1, '20.2899', '85.8102', 70, '2018-07-23 16:01:31'),
(1063, 'OD013', 1, '20.2990', '85.8173', 34, '2018-07-23 16:01:31'),
(1064, 'OD004', 1, '20.3040', '85.8397', 32, '2018-07-23 16:01:52'),
(1065, 'OD007', 1, '20.2804', '85.8499', 29, '2018-07-23 16:01:52'),
(1066, 'OD012', 1, '20.2899', '85.8102', 64, '2018-07-23 16:01:52'),
(1067, 'OD013', 1, '20.2990', '85.8173', 0, '2018-07-23 16:01:52'),
(1068, 'OD004', 1, '20.3040', '85.8397', 32, '2018-07-23 16:02:13'),
(1069, 'OD007', 1, '20.2804', '85.8499', 31, '2018-07-23 16:02:13'),
(1070, 'OD012', 1, '20.2899', '85.8102', 63, '2018-07-23 16:02:13'),
(1071, 'OD013', 1, '20.2990', '85.8173', 0, '2018-07-23 16:02:13'),
(1072, 'OD004', 0, '20.3040', '85.8397', 0, '2018-07-23 16:02:34'),
(1073, 'OD007', 1, '20.2804', '85.8499', 14, '2018-07-23 16:02:34'),
(1074, 'OD012', 1, '20.2899', '85.8102', 66, '2018-07-23 16:02:34'),
(1075, 'OD013', 1, '20.2990', '85.8173', 38, '2018-07-23 16:02:34'),
(1076, 'OD004', 0, '20.3040', '85.8397', 0, '2018-07-23 16:02:55'),
(1077, 'OD007', 1, '20.2804', '85.8499', 13, '2018-07-23 16:02:55'),
(1078, 'OD012', 1, '20.2899', '85.8102', 66, '2018-07-23 16:02:55'),
(1079, 'OD013', 1, '20.2990', '85.8173', 38, '2018-07-23 16:02:55'),
(1080, 'OD004', 1, '20.3040', '85.8397', 67, '2018-07-23 16:03:16'),
(1081, 'OD007', 1, '20.2804', '85.8499', 13, '2018-07-23 16:03:16'),
(1082, 'OD012', 1, '20.2899', '85.8102', 62, '2018-07-23 16:03:16'),
(1083, 'OD013', 1, '20.2990', '85.8173', 39, '2018-07-23 16:03:16'),
(1084, 'OD004', 1, '20.3040', '85.8397', 63, '2018-07-23 16:03:37'),
(1085, 'OD007', 1, '20.2804', '85.8499', 19, '2018-07-23 16:03:37'),
(1086, 'OD012', 1, '20.2899', '85.8102', 63, '2018-07-23 16:03:37'),
(1087, 'OD013', 1, '20.2990', '85.8173', 38, '2018-07-23 16:03:38'),
(1088, 'OD004', 1, '20.3040', '85.8397', 40, '2018-07-23 16:03:58'),
(1089, 'OD007', 1, '20.2804', '85.8499', 13, '2018-07-23 16:03:58'),
(1090, 'OD012', 1, '20.2899', '85.8102', 63, '2018-07-23 16:03:58'),
(1091, 'OD013', 1, '20.2990', '85.8173', 37, '2018-07-23 16:03:59'),
(1092, 'OD004', 1, '20.3040', '85.8397', 66, '2018-07-24 14:39:25'),
(1093, 'OD007', 1, '20.2804', '85.8499', 40, '2018-07-24 14:39:25'),
(1094, 'OD012', 1, '20.2899', '85.8102', 55, '2018-07-24 14:39:25'),
(1095, 'OD013', 1, '20.2990', '85.8173', 73, '2018-07-24 14:39:25'),
(1096, 'OD004', 1, '20.3040', '85.8397', 7, '2018-07-24 14:39:46'),
(1097, 'OD007', 1, '20.2804', '85.8499', 27, '2018-07-24 14:39:46'),
(1098, 'OD012', 1, '20.2899', '85.8102', 51, '2018-07-24 14:39:47'),
(1099, 'OD013', 1, '20.2990', '85.8173', 59, '2018-07-24 14:39:47'),
(1100, 'OD004', 0, '20.3040', '85.8397', 0, '2018-07-24 14:40:07'),
(1101, 'OD007', 1, '20.2804', '85.8499', 30, '2018-07-24 14:40:07'),
(1102, 'OD012', 1, '20.2899', '85.8102', 51, '2018-07-24 14:40:08'),
(1103, 'OD013', 1, '20.2990', '85.8173', 30, '2018-07-24 14:40:08'),
(1104, 'OD004', 1, '20.3040', '85.8397', 68, '2018-07-24 14:40:28'),
(1105, 'OD007', 1, '20.2804', '85.8499', 30, '2018-07-24 14:40:28'),
(1106, 'OD012', 1, '20.2899', '85.8102', 54, '2018-07-24 14:40:29'),
(1107, 'OD013', 1, '20.2990', '85.8173', 18, '2018-07-24 14:40:29'),
(1108, 'OD004', 1, '20.3040', '85.8397', 62, '2018-07-24 14:40:49'),
(1109, 'OD007', 1, '20.2804', '85.8499', 30, '2018-07-24 14:40:50'),
(1110, 'OD012', 1, '20.2899', '85.8102', 65, '2018-07-24 14:40:50'),
(1111, 'OD013', 1, '20.2990', '85.8173', 22, '2018-07-24 14:40:50'),
(1112, 'OD004', 1, '20.3040', '85.8397', 66, '2018-07-24 14:41:11'),
(1113, 'OD007', 1, '20.2804', '85.8499', 27, '2018-07-24 14:41:11'),
(1114, 'OD012', 1, '20.2899', '85.8102', 25, '2018-07-24 14:41:11'),
(1115, 'OD013', 1, '20.2990', '85.8173', 20, '2018-07-24 14:41:11'),
(1116, 'OD004', 1, '20.3040', '85.8397', 65, '2018-07-24 14:41:32'),
(1117, 'OD007', 1, '20.2804', '85.8499', 31, '2018-07-24 14:41:32'),
(1118, 'OD012', 1, '20.2899', '85.8102', 40, '2018-07-24 14:41:32'),
(1119, 'OD013', 1, '20.2990', '85.8173', 6, '2018-07-24 14:41:32'),
(1120, 'OD004', 1, '20.3040', '85.8397', 64, '2018-07-24 14:41:53'),
(1121, 'OD007', 1, '20.2804', '85.8499', 26, '2018-07-24 14:41:53'),
(1122, 'OD012', 1, '20.2899', '85.8102', 31, '2018-07-24 14:41:53'),
(1123, 'OD013', 1, '20.2990', '85.8173', 27, '2018-07-24 14:41:54'),
(1124, 'OD004', 1, '20.3040', '85.8397', 66, '2018-07-24 14:42:14'),
(1125, 'OD007', 1, '20.2804', '85.8499', 29, '2018-07-24 14:42:14'),
(1126, 'OD012', 1, '20.2899', '85.8102', 37, '2018-07-24 14:42:14'),
(1127, 'OD013', 1, '20.2990', '85.8173', 8, '2018-07-24 14:42:15'),
(1128, 'OD004', 1, '20.3040', '85.8397', 62, '2018-07-24 14:42:35'),
(1129, 'OD007', 1, '20.2804', '85.8499', 25, '2018-07-24 14:42:35'),
(1130, 'OD012', 1, '20.2899', '85.8102', 35, '2018-07-24 14:42:36'),
(1131, 'OD013', 1, '20.2990', '85.8173', 27, '2018-07-24 14:42:36'),
(1132, 'OD004', 1, '20.3040', '85.8397', 63, '2018-07-24 14:42:56'),
(1133, 'OD007', 1, '20.2804', '85.8499', 22, '2018-07-24 14:42:57'),
(1134, 'OD012', 1, '20.2899', '85.8102', 31, '2018-07-24 14:42:57'),
(1135, 'OD013', 1, '20.2990', '85.8173', 12, '2018-07-24 14:42:57'),
(1136, 'OD004', 1, '20.3040', '85.8397', 64, '2018-07-24 14:43:17'),
(1137, 'OD007', 1, '20.2804', '85.8499', 30, '2018-07-24 14:43:18'),
(1138, 'OD012', 1, '20.2899', '85.8102', 45, '2018-07-24 14:43:18'),
(1139, 'OD013', 1, '20.2990', '85.8173', 20, '2018-07-24 14:43:18'),
(1140, 'OD004', 1, '20.3040', '85.8397', 64, '2018-07-24 14:43:39'),
(1141, 'OD007', 1, '20.2804', '85.8499', 0, '2018-07-24 14:43:39'),
(1142, 'OD012', 1, '20.2899', '85.8102', 47, '2018-07-24 14:43:39'),
(1143, 'OD013', 1, '20.2990', '85.8173', 13, '2018-07-24 14:43:39'),
(1144, 'OD004', 1, '20.3040', '85.8397', 64, '2018-07-24 14:44:00'),
(1145, 'OD007', 1, '20.2804', '85.8499', 31, '2018-07-24 14:44:00'),
(1146, 'OD012', 1, '20.2899', '85.8102', 42, '2018-07-24 14:44:00'),
(1147, 'OD013', 1, '20.2990', '85.8173', 6, '2018-07-24 14:44:00'),
(1148, 'OD004', 1, '20.3040', '85.8397', 64, '2018-07-24 14:44:21'),
(1149, 'OD007', 1, '20.2804', '85.8499', 28, '2018-07-24 14:44:21'),
(1150, 'OD012', 1, '20.2899', '85.8102', 39, '2018-07-24 14:44:21'),
(1151, 'OD013', 1, '20.2990', '85.8173', 20, '2018-07-24 14:44:21'),
(1152, 'OD004', 1, '20.3040', '85.8397', 64, '2018-07-24 14:44:42'),
(1153, 'OD007', 1, '20.2804', '85.8499', 30, '2018-07-24 14:44:42'),
(1154, 'OD012', 1, '20.2899', '85.8102', 33, '2018-07-24 14:44:42'),
(1155, 'OD013', 1, '20.2990', '85.8173', 14, '2018-07-24 14:44:42'),
(1156, 'OD004', 1, '20.3040', '85.8397', 63, '2018-07-24 14:45:03'),
(1157, 'OD007', 1, '20.2804', '85.8499', 32, '2018-07-24 14:45:03'),
(1158, 'OD012', 1, '20.2899', '85.8102', 37, '2018-07-24 14:45:03'),
(1159, 'OD013', 1, '20.2990', '85.8173', 17, '2018-07-24 14:45:03'),
(1160, 'OD004', 1, '20.3040', '85.8397', 34, '2018-07-24 14:45:24'),
(1161, 'OD007', 1, '20.2804', '85.8499', 29, '2018-07-24 14:45:24'),
(1162, 'OD012', 1, '20.2899', '85.8102', 34, '2018-07-24 14:45:24'),
(1163, 'OD013', 1, '20.2990', '85.8173', 0, '2018-07-24 14:45:25'),
(1164, 'OD004', 1, '20.3040', '85.8397', 18, '2018-07-24 14:45:45'),
(1165, 'OD007', 1, '20.2804', '85.8499', 29, '2018-07-24 14:45:45'),
(1166, 'OD012', 1, '20.2899', '85.8102', 33, '2018-07-24 14:45:46'),
(1167, 'OD013', 1, '20.2990', '85.8173', 10, '2018-07-24 14:45:46'),
(1168, 'OD004', 1, '20.3040', '85.8397', 16, '2018-07-24 14:46:06'),
(1169, 'OD007', 1, '20.2804', '85.8499', 15, '2018-07-24 14:46:07'),
(1170, 'OD012', 1, '20.2899', '85.8102', 34, '2018-07-24 14:46:07'),
(1171, 'OD013', 1, '20.2990', '85.8173', 9, '2018-07-24 14:46:07'),
(1172, 'OD004', 1, '20.3040', '85.8397', 13, '2018-07-24 14:46:27'),
(1173, 'OD007', 1, '20.2804', '85.8499', 27, '2018-07-24 14:46:28'),
(1174, 'OD012', 1, '20.2899', '85.8102', 48, '2018-07-24 14:46:28'),
(1175, 'OD013', 1, '20.2990', '85.8173', 6, '2018-07-24 14:46:28'),
(1176, 'OD004', 1, '20.3040', '85.8397', 0, '2018-07-24 14:46:49'),
(1177, 'OD007', 1, '20.2804', '85.8499', 27, '2018-07-24 14:46:49'),
(1178, 'OD012', 1, '20.2899', '85.8102', 22, '2018-07-24 14:46:49'),
(1179, 'OD013', 1, '20.2990', '85.8173', 0, '2018-07-24 14:46:49'),
(1180, 'OD004', 1, '20.3040', '85.8397', 0, '2018-07-24 14:47:10'),
(1181, 'OD007', 1, '20.2804', '85.8499', 29, '2018-07-24 14:47:10'),
(1182, 'OD012', 1, '20.2899', '85.8102', 55, '2018-07-24 14:47:10'),
(1183, 'OD013', 1, '20.2990', '85.8173', 6, '2018-07-24 14:47:11'),
(1184, 'OD004', 1, '20.3040', '85.8397', 83, '2018-08-22 13:24:31'),
(1185, 'OD007', 1, '20.2804', '85.8499', 47, '2018-08-22 13:24:32'),
(1186, 'OD012', 1, '20.2899', '85.8102', 73, '2018-08-22 13:24:32'),
(1187, 'OD013', 1, '20.2990', '85.8173', 71, '2018-08-22 13:24:32'),
(1188, 'OD004', 1, '20.3040', '85.8397', 73, '2018-08-22 13:24:53'),
(1189, 'OD007', 1, '20.2804', '85.8499', 32, '2018-08-22 13:24:53'),
(1190, 'OD012', 1, '20.2899', '85.8102', 55, '2018-08-22 13:24:53'),
(1191, 'OD013', 1, '20.2990', '85.8173', 0, '2018-08-22 13:24:53'),
(1192, 'OD004', 0, '20.3040', '85.8397', 0, '2018-08-22 13:25:14'),
(1193, 'OD007', 1, '20.2804', '85.8499', 33, '2018-08-22 13:25:14'),
(1194, 'OD012', 1, '20.2899', '85.8102', 54, '2018-08-22 13:25:14'),
(1195, 'OD013', 1, '20.2990', '85.8173', 0, '2018-08-22 13:25:15'),
(1196, 'OD004', 0, '20.3040', '85.8397', 0, '2018-08-22 13:25:35'),
(1197, 'OD007', 1, '20.2804', '85.8499', 32, '2018-08-22 13:25:35'),
(1198, 'OD012', 1, '20.2899', '85.8102', 55, '2018-08-22 13:25:35'),
(1199, 'OD013', 1, '20.2990', '85.8173', 0, '2018-08-22 13:25:36'),
(1200, 'OD004', 0, '20.3040', '85.8397', 0, '2018-08-22 13:25:56'),
(1201, 'OD007', 1, '20.2804', '85.8499', 33, '2018-08-22 13:25:56'),
(1202, 'OD012', 1, '20.2899', '85.8102', 56, '2018-08-22 13:25:56'),
(1203, 'OD013', 1, '20.2990', '85.8173', 0, '2018-08-22 13:25:57'),
(1204, 'OD004', 0, '20.3040', '85.8397', 0, '2018-08-22 13:26:17'),
(1205, 'OD007', 1, '20.2804', '85.8499', 33, '2018-08-22 13:26:17'),
(1206, 'OD012', 1, '20.2899', '85.8102', 57, '2018-08-22 13:26:18'),
(1207, 'OD013', 1, '20.2990', '85.8173', 0, '2018-08-22 13:26:18'),
(1208, 'OD004', 0, '20.3040', '85.8397', 0, '2018-08-22 13:26:38'),
(1209, 'OD007', 1, '20.2804', '85.8499', 33, '2018-08-22 13:26:39'),
(1210, 'OD012', 1, '20.2899', '85.8102', 53, '2018-08-22 13:26:39'),
(1211, 'OD013', 1, '20.2990', '85.8173', 0, '2018-08-22 13:26:39'),
(1212, 'OD004', 0, '20.3040', '85.8397', 0, '2018-08-22 13:26:59'),
(1213, 'OD007', 1, '20.2804', '85.8499', 31, '2018-08-22 13:27:00'),
(1214, 'OD012', 1, '20.2899', '85.8102', 55, '2018-08-22 13:27:00'),
(1215, 'OD013', 1, '20.2990', '85.8173', 0, '2018-08-22 13:27:00'),
(1216, 'OD004', 0, '20.3040', '85.8397', 0, '2018-08-22 13:27:21'),
(1217, 'OD007', 1, '20.2804', '85.8499', 34, '2018-08-22 13:27:21'),
(1218, 'OD012', 1, '20.2899', '85.8102', 37, '2018-08-22 13:27:21'),
(1219, 'OD013', 1, '20.2990', '85.8173', 0, '2018-08-22 13:27:21'),
(1220, 'OD004', 0, '20.3040', '85.8397', 0, '2018-08-22 13:27:42'),
(1221, 'OD007', 1, '20.2804', '85.8499', 31, '2018-08-22 13:27:42'),
(1222, 'OD012', 1, '20.2899', '85.8102', 11, '2018-08-22 13:27:42'),
(1223, 'OD013', 1, '20.2990', '85.8173', 5, '2018-08-22 13:27:42'),
(1224, 'OD004', 0, '20.3040', '85.8397', 0, '2018-08-22 13:28:03'),
(1225, 'OD007', 1, '20.2804', '85.8499', 38, '2018-08-22 13:28:03'),
(1226, 'OD012', 1, '20.2899', '85.8102', 13, '2018-08-22 13:28:03'),
(1227, 'OD013', 1, '20.2990', '85.8173', 0, '2018-08-22 13:28:04'),
(1228, 'OD004', 1, '20.3040', '85.8397', 37, '2018-08-22 13:28:24'),
(1229, 'OD007', 1, '20.2804', '85.8499', 32, '2018-08-22 13:28:24'),
(1230, 'OD012', 1, '20.2899', '85.8102', 12, '2018-08-22 13:28:24'),
(1231, 'OD013', 1, '20.2990', '85.8173', 51, '2018-08-22 13:28:25'),
(1232, 'OD004', 1, '20.3040', '85.8397', 39, '2018-08-22 13:28:45'),
(1233, 'OD007', 1, '20.2804', '85.8499', 35, '2018-08-22 13:28:45'),
(1234, 'OD012', 1, '20.2899', '85.8102', 14, '2018-08-22 13:28:46'),
(1235, 'OD013', 1, '20.2990', '85.8173', 56, '2018-08-22 13:28:46'),
(1236, 'OD004', 1, '20.3040', '85.8397', 40, '2018-08-22 13:29:06'),
(1237, 'OD007', 1, '20.2804', '85.8499', 39, '2018-08-22 13:29:06'),
(1238, 'OD012', 1, '20.2899', '85.8102', 8, '2018-08-22 13:29:07'),
(1239, 'OD013', 1, '20.2990', '85.8173', 61, '2018-08-22 13:29:07'),
(1240, 'OD004', 1, '20.3040', '85.8397', 41, '2018-08-22 13:29:27'),
(1241, 'OD007', 1, '20.2804', '85.8499', 34, '2018-08-22 13:29:28'),
(1242, 'OD012', 1, '20.2899', '85.8102', 15, '2018-08-22 13:29:28'),
(1243, 'OD013', 1, '20.2990', '85.8173', 62, '2018-08-22 13:29:28'),
(1244, 'OD004', 1, '20.3040', '85.8397', 38, '2018-08-22 13:29:49'),
(1245, 'OD007', 1, '20.2804', '85.8499', 31, '2018-08-22 13:29:49'),
(1246, 'OD012', 1, '20.2899', '85.8102', 13, '2018-08-22 13:29:49'),
(1247, 'OD013', 1, '20.2990', '85.8173', 62, '2018-08-22 13:29:49'),
(1248, 'OD004', 1, '20.3040', '85.8397', 38, '2018-08-22 13:30:10'),
(1249, 'OD007', 1, '20.2804', '85.8499', 34, '2018-08-22 13:30:10'),
(1250, 'OD012', 1, '20.2899', '85.8102', 14, '2018-08-22 13:30:10'),
(1251, 'OD013', 1, '20.2990', '85.8173', 63, '2018-08-22 13:30:10'),
(1252, 'OD004', 1, '20.3040', '85.8397', 79, '2019-03-07 11:14:43'),
(1253, 'OD007', 1, '20.2804', '85.8499', 58, '2019-03-07 11:14:44'),
(1254, 'OD012', 1, '20.2899', '85.8102', 68, '2019-03-07 11:14:44'),
(1255, 'OD013', 1, '20.2990', '85.8173', 70, '2019-03-07 11:14:44'),
(1256, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-07 11:15:04'),
(1257, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-07 11:15:05'),
(1258, 'OD012', 1, '20.2899', '85.8102', 58, '2019-03-07 11:15:05'),
(1259, 'OD013', 1, '20.2990', '85.8173', 11, '2019-03-07 11:15:05'),
(1260, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-07 11:15:26'),
(1261, 'OD007', 1, '20.2804', '85.8499', 41, '2019-03-07 11:15:26'),
(1262, 'OD012', 1, '20.2899', '85.8102', 56, '2019-03-07 11:15:26'),
(1263, 'OD013', 1, '20.2990', '85.8173', 19, '2019-03-07 11:15:26'),
(1264, 'OD004', 1, '20.3040', '85.8397', 60, '2019-03-07 11:15:47'),
(1265, 'OD007', 1, '20.2804', '85.8499', 40, '2019-03-07 11:15:47'),
(1266, 'OD012', 1, '20.2899', '85.8102', 72, '2019-03-07 11:15:47'),
(1267, 'OD013', 1, '20.2990', '85.8173', 9, '2019-03-07 11:15:47'),
(1268, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-07 11:16:08'),
(1269, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-07 11:16:08'),
(1270, 'OD012', 1, '20.2899', '85.8102', 72, '2019-03-07 11:16:08'),
(1271, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 11:16:08'),
(1272, 'OD004', 1, '20.3040', '85.8397', 81, '2019-03-07 12:28:00'),
(1273, 'OD007', 1, '20.2804', '85.8499', 90, '2019-03-07 12:28:01'),
(1274, 'OD012', 1, '20.2899', '85.8102', 69, '2019-03-07 12:28:01'),
(1275, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:28:01'),
(1276, 'OD004', 1, '20.3040', '85.8397', 38, '2019-03-07 12:28:12'),
(1277, 'OD007', 1, '20.2804', '85.8499', 56, '2019-03-07 12:28:12'),
(1278, 'OD012', 1, '20.2899', '85.8102', 69, '2019-03-07 12:28:12'),
(1279, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:28:12'),
(1280, 'OD004', 1, '20.3040', '85.8397', 37, '2019-03-07 12:28:23'),
(1281, 'OD007', 1, '20.2804', '85.8499', 57, '2019-03-07 12:28:23'),
(1282, 'OD012', 1, '20.2899', '85.8102', 69, '2019-03-07 12:28:23'),
(1283, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:28:23'),
(1284, 'OD004', 1, '20.3040', '85.8397', 78, '2019-03-07 12:29:04'),
(1285, 'OD007', 1, '20.2804', '85.8499', 38, '2019-03-07 12:29:04'),
(1286, 'OD012', 1, '20.2899', '85.8102', 52, '2019-03-07 12:29:04'),
(1287, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:29:05'),
(1288, 'OD004', 1, '20.3040', '85.8397', 37, '2019-03-07 12:29:07'),
(1289, 'OD007', 1, '20.2804', '85.8499', 53, '2019-03-07 12:29:07'),
(1290, 'OD012', 1, '20.2899', '85.8102', 71, '2019-03-07 12:29:07'),
(1291, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:29:08'),
(1292, 'OD004', 1, '20.3040', '85.8397', 40, '2019-03-07 12:29:10'),
(1293, 'OD007', 1, '20.2804', '85.8499', 46, '2019-03-07 12:29:10'),
(1294, 'OD012', 1, '20.2899', '85.8102', 68, '2019-03-07 12:29:11'),
(1295, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:29:11'),
(1296, 'OD004', 1, '20.3040', '85.8397', 38, '2019-03-07 12:29:13'),
(1297, 'OD007', 1, '20.2804', '85.8499', 49, '2019-03-07 12:29:13'),
(1298, 'OD012', 1, '20.2899', '85.8102', 66, '2019-03-07 12:29:14'),
(1299, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:29:14'),
(1300, 'OD004', 1, '20.3040', '85.8397', 32, '2019-03-07 12:29:16'),
(1301, 'OD007', 1, '20.2804', '85.8499', 71, '2019-03-07 12:29:16'),
(1302, 'OD012', 1, '20.2899', '85.8102', 67, '2019-03-07 12:29:17'),
(1303, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:29:17'),
(1304, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-07 12:29:19'),
(1305, 'OD007', 1, '20.2804', '85.8499', 58, '2019-03-07 12:29:20'),
(1306, 'OD012', 1, '20.2899', '85.8102', 69, '2019-03-07 12:29:20'),
(1307, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:29:20'),
(1308, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-07 12:29:22'),
(1309, 'OD007', 1, '20.2804', '85.8499', 54, '2019-03-07 12:29:23'),
(1310, 'OD012', 1, '20.2899', '85.8102', 71, '2019-03-07 12:29:23'),
(1311, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:29:23'),
(1312, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-07 12:29:26'),
(1313, 'OD007', 1, '20.2804', '85.8499', 43, '2019-03-07 12:29:26'),
(1314, 'OD012', 1, '20.2899', '85.8102', 68, '2019-03-07 12:29:26'),
(1315, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:29:26'),
(1316, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-07 12:29:29'),
(1317, 'OD007', 1, '20.2804', '85.8499', 56, '2019-03-07 12:29:29'),
(1318, 'OD012', 1, '20.2899', '85.8102', 67, '2019-03-07 12:29:29'),
(1319, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:29:29'),
(1320, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-07 12:29:32'),
(1321, 'OD007', 1, '20.2804', '85.8499', 47, '2019-03-07 12:29:32'),
(1322, 'OD012', 1, '20.2899', '85.8102', 65, '2019-03-07 12:29:32'),
(1323, 'OD013', 1, '20.2990', '85.8173', 0, '2019-03-07 12:29:32'),
(1324, 'OD004', 1, '20.3040', '85.8397', 44, '2019-03-11 09:37:56'),
(1325, 'OD007', 1, '20.2804', '85.8499', 50, '2019-03-11 09:37:56'),
(1326, 'OD012', 1, '20.2899', '85.8102', 65, '2019-03-11 09:37:56'),
(1327, 'OD013', 1, '20.2990', '85.8173', 60, '2019-03-11 09:37:56'),
(1328, 'OD004', 1, '20.3040', '85.8397', 59, '2019-03-11 09:37:58'),
(1329, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:37:58'),
(1330, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:37:58'),
(1331, 'OD013', 1, '20.2990', '85.8173', 42, '2019-03-11 09:37:59'),
(1332, 'OD004', 1, '20.3040', '85.8397', 57, '2019-03-11 09:38:00'),
(1333, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:00'),
(1334, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:01'),
(1335, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:38:01'),
(1336, 'OD004', 1, '20.3040', '85.8397', 59, '2019-03-11 09:38:02'),
(1337, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:02'),
(1338, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:03'),
(1339, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:38:03'),
(1340, 'OD004', 1, '20.3040', '85.8397', 58, '2019-03-11 09:38:04'),
(1341, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:04'),
(1342, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:05'),
(1343, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:38:05'),
(1344, 'OD004', 1, '20.3040', '85.8397', 60, '2019-03-11 09:38:06'),
(1345, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:06'),
(1346, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:07'),
(1347, 'OD013', 1, '20.2990', '85.8173', 37, '2019-03-11 09:38:07'),
(1348, 'OD004', 1, '20.3040', '85.8397', 58, '2019-03-11 09:38:08'),
(1349, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:08'),
(1350, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:09'),
(1351, 'OD013', 1, '20.2990', '85.8173', 29, '2019-03-11 09:38:09'),
(1352, 'OD004', 1, '20.3040', '85.8397', 59, '2019-03-11 09:38:10'),
(1353, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:10'),
(1354, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:11'),
(1355, 'OD013', 1, '20.2990', '85.8173', 25, '2019-03-11 09:38:11'),
(1356, 'OD004', 1, '20.3040', '85.8397', 57, '2019-03-11 09:38:12'),
(1357, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:13'),
(1358, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:13'),
(1359, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:38:13'),
(1360, 'OD004', 1, '20.3040', '85.8397', 57, '2019-03-11 09:38:14'),
(1361, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:15'),
(1362, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:15'),
(1363, 'OD013', 1, '20.2990', '85.8173', 37, '2019-03-11 09:38:15'),
(1364, 'OD004', 1, '20.3040', '85.8397', 57, '2019-03-11 09:38:16'),
(1365, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:17'),
(1366, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:17'),
(1367, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:38:17'),
(1368, 'OD004', 1, '20.3040', '85.8397', 59, '2019-03-11 09:38:19'),
(1369, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:19'),
(1370, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:19'),
(1371, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:38:19'),
(1372, 'OD004', 1, '20.3040', '85.8397', 59, '2019-03-11 09:38:21'),
(1373, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:21'),
(1374, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:21'),
(1375, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:38:21'),
(1376, 'OD004', 1, '20.3040', '85.8397', 57, '2019-03-11 09:38:23'),
(1377, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:23'),
(1378, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:23'),
(1379, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:38:23'),
(1380, 'OD004', 1, '20.3040', '85.8397', 57, '2019-03-11 09:38:25'),
(1381, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:25'),
(1382, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:25'),
(1383, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:38:25'),
(1384, 'OD004', 1, '20.3040', '85.8397', 57, '2019-03-11 09:38:27'),
(1385, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:27'),
(1386, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:27'),
(1387, 'OD013', 1, '20.2990', '85.8173', 36, '2019-03-11 09:38:28'),
(1388, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:29'),
(1389, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:29'),
(1390, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:29'),
(1391, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:38:30'),
(1392, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:31'),
(1393, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:31'),
(1394, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:31'),
(1395, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:38:32'),
(1396, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:33'),
(1397, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:33'),
(1398, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:34'),
(1399, 'OD013', 1, '20.2990', '85.8173', 36, '2019-03-11 09:38:34'),
(1400, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:35'),
(1401, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:36'),
(1402, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:36'),
(1403, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:38:36'),
(1404, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:38'),
(1405, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:38'),
(1406, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:38'),
(1407, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:38:38'),
(1408, 'OD004', 1, '20.3040', '85.8397', 5, '2019-03-11 09:38:40'),
(1409, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:40'),
(1410, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:40'),
(1411, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:38:40'),
(1412, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:42'),
(1413, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:42'),
(1414, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:42'),
(1415, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:38:43'),
(1416, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:44'),
(1417, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:44'),
(1418, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:45'),
(1419, 'OD013', 1, '20.2990', '85.8173', 36, '2019-03-11 09:38:45'),
(1420, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:46'),
(1421, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:47'),
(1422, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:47'),
(1423, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:38:47'),
(1424, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:48'),
(1425, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:49'),
(1426, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:49'),
(1427, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:38:49'),
(1428, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:51'),
(1429, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:51'),
(1430, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:51'),
(1431, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:38:51'),
(1432, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:53'),
(1433, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:53'),
(1434, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:53'),
(1435, 'OD013', 1, '20.2990', '85.8173', 36, '2019-03-11 09:38:54'),
(1436, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:55'),
(1437, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:55'),
(1438, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:56'),
(1439, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:38:56'),
(1440, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:38:57'),
(1441, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:38:58'),
(1442, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:38:58'),
(1443, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:38:58'),
(1444, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:39:00'),
(1445, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:00'),
(1446, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:00'),
(1447, 'OD013', 1, '20.2990', '85.8173', 30, '2019-03-11 09:39:00'),
(1448, 'OD004', 1, '20.3040', '85.8397', 5, '2019-03-11 09:39:02'),
(1449, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:02'),
(1450, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:02'),
(1451, 'OD013', 1, '20.2990', '85.8173', 50, '2019-03-11 09:39:03'),
(1452, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:39:04'),
(1453, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:04'),
(1454, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:04'),
(1455, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:39:05'),
(1456, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:39:06'),
(1457, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:06'),
(1458, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:07'),
(1459, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:39:07'),
(1460, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:39:08'),
(1461, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:09'),
(1462, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:09'),
(1463, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:39:09'),
(1464, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:11'),
(1465, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:11'),
(1466, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:11'),
(1467, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:39:11'),
(1468, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:13'),
(1469, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:13'),
(1470, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:13'),
(1471, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:39:13'),
(1472, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:15'),
(1473, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:15'),
(1474, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:16'),
(1475, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:39:16'),
(1476, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:17'),
(1477, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:18'),
(1478, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:18'),
(1479, 'OD013', 1, '20.2990', '85.8173', 39, '2019-03-11 09:39:18'),
(1480, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:20'),
(1481, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:20'),
(1482, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:20'),
(1483, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:39:20'),
(1484, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:22'),
(1485, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:22'),
(1486, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:22'),
(1487, 'OD013', 1, '20.2990', '85.8173', 15, '2019-03-11 09:39:22'),
(1488, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:24'),
(1489, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:24'),
(1490, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:24'),
(1491, 'OD013', 1, '20.2990', '85.8173', 38, '2019-03-11 09:39:24'),
(1492, 'OD004', 1, '20.3040', '85.8397', 34, '2019-03-11 09:39:26'),
(1493, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:26'),
(1494, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:26'),
(1495, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:39:27'),
(1496, 'OD004', 1, '20.3040', '85.8397', 39, '2019-03-11 09:39:28'),
(1497, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:28'),
(1498, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:28'),
(1499, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:39:29'),
(1500, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:30'),
(1501, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:30'),
(1502, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:30'),
(1503, 'OD013', 1, '20.2990', '85.8173', 45, '2019-03-11 09:39:31'),
(1504, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:32'),
(1505, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:32'),
(1506, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:32'),
(1507, 'OD013', 1, '20.2990', '85.8173', 36, '2019-03-11 09:39:33'),
(1508, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:34'),
(1509, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:35'),
(1510, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:35'),
(1511, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:39:35'),
(1512, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:36'),
(1513, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:37'),
(1514, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:37'),
(1515, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:39:37'),
(1516, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:38'),
(1517, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:39'),
(1518, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:39'),
(1519, 'OD013', 1, '20.2990', '85.8173', 40, '2019-03-11 09:39:39'),
(1520, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:41'),
(1521, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:41'),
(1522, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:41'),
(1523, 'OD013', 1, '20.2990', '85.8173', 39, '2019-03-11 09:39:41'),
(1524, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:43'),
(1525, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:43'),
(1526, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:43'),
(1527, 'OD013', 1, '20.2990', '85.8173', 42, '2019-03-11 09:39:43'),
(1528, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:45'),
(1529, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:45'),
(1530, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:45'),
(1531, 'OD013', 1, '20.2990', '85.8173', 38, '2019-03-11 09:39:45'),
(1532, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:47'),
(1533, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:47'),
(1534, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:47'),
(1535, 'OD013', 1, '20.2990', '85.8173', 19, '2019-03-11 09:39:47'),
(1536, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:49'),
(1537, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:49'),
(1538, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:49'),
(1539, 'OD013', 1, '20.2990', '85.8173', 36, '2019-03-11 09:39:49'),
(1540, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:51'),
(1541, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:51'),
(1542, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:51'),
(1543, 'OD013', 1, '20.2990', '85.8173', 32, '2019-03-11 09:39:52'),
(1544, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:53'),
(1545, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:53'),
(1546, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:54'),
(1547, 'OD013', 1, '20.2990', '85.8173', 41, '2019-03-11 09:39:54'),
(1548, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:55'),
(1549, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:55'),
(1550, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:56'),
(1551, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:39:56'),
(1552, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:57'),
(1553, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:39:58'),
(1554, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:39:58'),
(1555, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:39:58'),
(1556, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:39:59'),
(1557, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:40:00'),
(1558, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:00'),
(1559, 'OD013', 1, '20.2990', '85.8173', 36, '2019-03-11 09:40:00'),
(1560, 'OD004', 1, '20.3040', '85.8397', 91, '2019-03-11 09:40:02'),
(1561, 'OD007', 1, '20.2804', '85.8499', 8, '2019-03-11 09:40:02'),
(1562, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:02'),
(1563, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:40:02'),
(1564, 'OD004', 1, '20.3040', '85.8397', 94, '2019-03-11 09:40:04'),
(1565, 'OD007', 1, '20.2804', '85.8499', 17, '2019-03-11 09:40:04'),
(1566, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:04'),
(1567, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:40:04'),
(1568, 'OD004', 1, '20.3040', '85.8397', 92, '2019-03-11 09:40:06'),
(1569, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:40:06'),
(1570, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:06'),
(1571, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:40:06'),
(1572, 'OD004', 1, '20.3040', '85.8397', 86, '2019-03-11 09:40:08'),
(1573, 'OD007', 1, '20.2804', '85.8499', 18, '2019-03-11 09:40:08'),
(1574, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:08'),
(1575, 'OD013', 1, '20.2990', '85.8173', 21, '2019-03-11 09:40:09'),
(1576, 'OD004', 1, '20.3040', '85.8397', 94, '2019-03-11 09:40:10'),
(1577, 'OD007', 1, '20.2804', '85.8499', 9, '2019-03-11 09:40:10'),
(1578, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:10'),
(1579, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:40:11'),
(1580, 'OD004', 1, '20.3040', '85.8397', 94, '2019-03-11 09:40:12'),
(1581, 'OD007', 1, '20.2804', '85.8499', 9, '2019-03-11 09:40:12'),
(1582, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:12'),
(1583, 'OD013', 1, '20.2990', '85.8173', 24, '2019-03-11 09:40:13'),
(1584, 'OD004', 1, '20.3040', '85.8397', 94, '2019-03-11 09:40:14'),
(1585, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:40:14'),
(1586, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:14'),
(1587, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:40:15'),
(1588, 'OD004', 1, '20.3040', '85.8397', 91, '2019-03-11 09:40:16'),
(1589, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:40:16'),
(1590, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:17'),
(1591, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:40:17'),
(1592, 'OD004', 1, '20.3040', '85.8397', 95, '2019-03-11 09:40:18'),
(1593, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:40:18'),
(1594, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:19'),
(1595, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:40:19'),
(1596, 'OD004', 1, '20.3040', '85.8397', 95, '2019-03-11 09:40:20'),
(1597, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:40:21'),
(1598, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:21'),
(1599, 'OD013', 1, '20.2990', '85.8173', 36, '2019-03-11 09:40:21'),
(1600, 'OD004', 1, '20.3040', '85.8397', 75, '2019-03-11 09:40:22'),
(1601, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:40:23'),
(1602, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:23'),
(1603, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:40:23'),
(1604, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:25'),
(1605, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:40:25'),
(1606, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:25'),
(1607, 'OD013', 1, '20.2990', '85.8173', 39, '2019-03-11 09:40:25'),
(1608, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:27'),
(1609, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:40:27'),
(1610, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:27'),
(1611, 'OD013', 1, '20.2990', '85.8173', 40, '2019-03-11 09:40:27'),
(1612, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:29'),
(1613, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:40:29'),
(1614, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:29'),
(1615, 'OD013', 1, '20.2990', '85.8173', 39, '2019-03-11 09:40:29'),
(1616, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:31'),
(1617, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:40:31'),
(1618, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:31'),
(1619, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:40:31'),
(1620, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:33'),
(1621, 'OD007', 1, '20.2804', '85.8499', 8, '2019-03-11 09:40:33'),
(1622, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:33'),
(1623, 'OD013', 1, '20.2990', '85.8173', 37, '2019-03-11 09:40:34'),
(1624, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:35'),
(1625, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:40:35'),
(1626, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:36'),
(1627, 'OD013', 1, '20.2990', '85.8173', 52, '2019-03-11 09:40:36'),
(1628, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:37'),
(1629, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:40:37'),
(1630, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:38'),
(1631, 'OD013', 1, '20.2990', '85.8173', 38, '2019-03-11 09:40:38'),
(1632, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:39'),
(1633, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:40:39'),
(1634, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:40'),
(1635, 'OD013', 1, '20.2990', '85.8173', 39, '2019-03-11 09:40:40'),
(1636, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:41'),
(1637, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:40:42'),
(1638, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:42'),
(1639, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:40:42'),
(1640, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:43'),
(1641, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:40:44'),
(1642, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:44'),
(1643, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:40:44'),
(1644, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:45'),
(1645, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:40:46'),
(1646, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:46'),
(1647, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:40:46'),
(1648, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:48'),
(1649, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:40:48'),
(1650, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:48'),
(1651, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:40:48'),
(1652, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:50'),
(1653, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:40:50'),
(1654, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:50'),
(1655, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:40:50'),
(1656, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:52'),
(1657, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:40:52'),
(1658, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:52'),
(1659, 'OD013', 1, '20.2990', '85.8173', 37, '2019-03-11 09:40:52'),
(1660, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:54'),
(1661, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:40:54'),
(1662, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:54'),
(1663, 'OD013', 1, '20.2990', '85.8173', 22, '2019-03-11 09:40:54'),
(1664, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:56'),
(1665, 'OD007', 1, '20.2804', '85.8499', 23, '2019-03-11 09:40:56'),
(1666, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:56'),
(1667, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:40:56'),
(1668, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:40:58'),
(1669, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:40:58'),
(1670, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:40:58'),
(1671, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:40:58'),
(1672, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:41:00'),
(1673, 'OD007', 1, '20.2804', '85.8499', 12, '2019-03-11 09:41:00'),
(1674, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:00'),
(1675, 'OD013', 1, '20.2990', '85.8173', 28, '2019-03-11 09:41:01'),
(1676, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:41:02'),
(1677, 'OD007', 1, '20.2804', '85.8499', 12, '2019-03-11 09:41:02'),
(1678, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:02'),
(1679, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:41:03'),
(1680, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:41:04'),
(1681, 'OD007', 1, '20.2804', '85.8499', 12, '2019-03-11 09:41:04'),
(1682, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:04'),
(1683, 'OD013', 1, '20.2990', '85.8173', 40, '2019-03-11 09:41:05'),
(1684, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:41:06'),
(1685, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:41:06'),
(1686, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:07'),
(1687, 'OD013', 1, '20.2990', '85.8173', 43, '2019-03-11 09:41:07'),
(1688, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:41:08'),
(1689, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:41:08'),
(1690, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:09'),
(1691, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:41:09'),
(1692, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:41:10'),
(1693, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:41:10'),
(1694, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:11'),
(1695, 'OD013', 1, '20.2990', '85.8173', 38, '2019-03-11 09:41:11'),
(1696, 'OD004', 0, '20.3040', '85.8397', 0, '2019-03-11 09:41:12'),
(1697, 'OD007', 1, '20.2804', '85.8499', 9, '2019-03-11 09:41:13'),
(1698, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:13'),
(1699, 'OD013', 1, '20.2990', '85.8173', 32, '2019-03-11 09:41:13'),
(1700, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:41:15'),
(1701, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:41:15'),
(1702, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:15'),
(1703, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:41:15'),
(1704, 'OD004', 1, '20.3040', '85.8397', 0, '2019-03-11 09:41:17'),
(1705, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:41:17'),
(1706, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:17'),
(1707, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:41:17'),
(1708, 'OD004', 1, '20.3040', '85.8397', 61, '2019-03-11 09:41:19'),
(1709, 'OD007', 1, '20.2804', '85.8499', 9, '2019-03-11 09:41:19'),
(1710, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:19'),
(1711, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:41:20'),
(1712, 'OD004', 1, '20.3040', '85.8397', 60, '2019-03-11 09:41:21'),
(1713, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:41:21'),
(1714, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:21'),
(1715, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:41:22'),
(1716, 'OD004', 1, '20.3040', '85.8397', 63, '2019-03-11 09:41:23'),
(1717, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:41:23'),
(1718, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:23'),
(1719, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:41:24'),
(1720, 'OD004', 1, '20.3040', '85.8397', 63, '2019-03-11 09:41:25'),
(1721, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:41:25'),
(1722, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:26'),
(1723, 'OD013', 1, '20.2990', '85.8173', 41, '2019-03-11 09:41:26'),
(1724, 'OD004', 1, '20.3040', '85.8397', 61, '2019-03-11 09:41:27'),
(1725, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:41:27'),
(1726, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:28'),
(1727, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:41:28'),
(1728, 'OD004', 1, '20.3040', '85.8397', 60, '2019-03-11 09:41:29'),
(1729, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:41:29'),
(1730, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:30'),
(1731, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:41:30'),
(1732, 'OD004', 1, '20.3040', '85.8397', 62, '2019-03-11 09:41:31'),
(1733, 'OD007', 1, '20.2804', '85.8499', 5, '2019-03-11 09:41:32'),
(1734, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:32'),
(1735, 'OD013', 1, '20.2990', '85.8173', 40, '2019-03-11 09:41:32'),
(1736, 'OD004', 1, '20.3040', '85.8397', 62, '2019-03-11 09:41:33');
INSERT INTO `bin_sensor_data` (`id`, `fk_bin_id`, `is_bin_present`, `latitude`, `longitude`, `bin_level`, `created_time`) VALUES
(1737, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:41:34'),
(1738, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:34'),
(1739, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:41:34'),
(1740, 'OD004', 1, '20.3040', '85.8397', 60, '2019-03-11 09:41:35'),
(1741, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:41:36'),
(1742, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:36'),
(1743, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:41:36'),
(1744, 'OD004', 1, '20.3040', '85.8397', 62, '2019-03-11 09:41:38'),
(1745, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:41:38'),
(1746, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:38'),
(1747, 'OD013', 1, '20.2990', '85.8173', 42, '2019-03-11 09:41:38'),
(1748, 'OD004', 1, '20.3040', '85.8397', 59, '2019-03-11 09:41:40'),
(1749, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:41:40'),
(1750, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:40'),
(1751, 'OD013', 1, '20.2990', '85.8173', 32, '2019-03-11 09:41:40'),
(1752, 'OD004', 1, '20.3040', '85.8397', 75, '2019-03-11 09:41:42'),
(1753, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:41:42'),
(1754, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:42'),
(1755, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:41:42'),
(1756, 'OD004', 1, '20.3040', '85.8397', 62, '2019-03-11 09:41:44'),
(1757, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:41:44'),
(1758, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:44'),
(1759, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:41:45'),
(1760, 'OD004', 1, '20.3040', '85.8397', 52, '2019-03-11 09:41:46'),
(1761, 'OD007', 1, '20.2804', '85.8499', 8, '2019-03-11 09:41:46'),
(1762, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:46'),
(1763, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:41:47'),
(1764, 'OD004', 1, '20.3040', '85.8397', 70, '2019-03-11 09:41:48'),
(1765, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:41:48'),
(1766, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:48'),
(1767, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:41:49'),
(1768, 'OD004', 1, '20.3040', '85.8397', 50, '2019-03-11 09:41:50'),
(1769, 'OD007', 1, '20.2804', '85.8499', 8, '2019-03-11 09:41:50'),
(1770, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:51'),
(1771, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:41:51'),
(1772, 'OD004', 1, '20.3040', '85.8397', 62, '2019-03-11 09:41:52'),
(1773, 'OD007', 1, '20.2804', '85.8499', 8, '2019-03-11 09:41:52'),
(1774, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:53'),
(1775, 'OD013', 1, '20.2990', '85.8173', 32, '2019-03-11 09:41:53'),
(1776, 'OD004', 1, '20.3040', '85.8397', 61, '2019-03-11 09:41:54'),
(1777, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:41:55'),
(1778, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:55'),
(1779, 'OD013', 1, '20.2990', '85.8173', 36, '2019-03-11 09:41:55'),
(1780, 'OD004', 1, '20.3040', '85.8397', 60, '2019-03-11 09:41:56'),
(1781, 'OD007', 1, '20.2804', '85.8499', 13, '2019-03-11 09:41:57'),
(1782, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:57'),
(1783, 'OD013', 1, '20.2990', '85.8173', 36, '2019-03-11 09:41:57'),
(1784, 'OD004', 1, '20.3040', '85.8397', 60, '2019-03-11 09:41:59'),
(1785, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:41:59'),
(1786, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:41:59'),
(1787, 'OD013', 1, '20.2990', '85.8173', 32, '2019-03-11 09:41:59'),
(1788, 'OD004', 1, '20.3040', '85.8397', 58, '2019-03-11 09:42:01'),
(1789, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:42:01'),
(1790, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:01'),
(1791, 'OD013', 1, '20.2990', '85.8173', 37, '2019-03-11 09:42:01'),
(1792, 'OD004', 1, '20.3040', '85.8397', 64, '2019-03-11 09:42:03'),
(1793, 'OD007', 1, '20.2804', '85.8499', 9, '2019-03-11 09:42:03'),
(1794, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:03'),
(1795, 'OD013', 1, '20.2990', '85.8173', 21, '2019-03-11 09:42:03'),
(1796, 'OD004', 1, '20.3040', '85.8397', 61, '2019-03-11 09:42:05'),
(1797, 'OD007', 1, '20.2804', '85.8499', 9, '2019-03-11 09:42:05'),
(1798, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:05'),
(1799, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:42:05'),
(1800, 'OD004', 1, '20.3040', '85.8397', 60, '2019-03-11 09:42:07'),
(1801, 'OD007', 1, '20.2804', '85.8499', 7, '2019-03-11 09:42:07'),
(1802, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:07'),
(1803, 'OD013', 1, '20.2990', '85.8173', 34, '2019-03-11 09:42:07'),
(1804, 'OD004', 1, '20.3040', '85.8397', 57, '2019-03-11 09:42:09'),
(1805, 'OD007', 1, '20.2804', '85.8499', 8, '2019-03-11 09:42:09'),
(1806, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:09'),
(1807, 'OD013', 1, '20.2990', '85.8173', 47, '2019-03-11 09:42:09'),
(1808, 'OD004', 1, '20.3040', '85.8397', 60, '2019-03-11 09:42:11'),
(1809, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:42:11'),
(1810, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:11'),
(1811, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:42:11'),
(1812, 'OD004', 1, '20.3040', '85.8397', 63, '2019-03-11 09:42:13'),
(1813, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:42:13'),
(1814, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:13'),
(1815, 'OD013', 1, '20.2990', '85.8173', 35, '2019-03-11 09:42:14'),
(1816, 'OD004', 1, '20.3040', '85.8397', 56, '2019-03-11 09:42:15'),
(1817, 'OD007', 1, '20.2804', '85.8499', 0, '2019-03-11 09:42:15'),
(1818, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:15'),
(1819, 'OD013', 1, '20.2990', '85.8173', 31, '2019-03-11 09:42:16'),
(1820, 'OD004', 1, '20.3040', '85.8397', 56, '2019-03-11 09:42:17'),
(1821, 'OD007', 1, '20.2804', '85.8499', 8, '2019-03-11 09:42:17'),
(1822, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:17'),
(1823, 'OD013', 1, '20.2990', '85.8173', 30, '2019-03-11 09:42:18'),
(1824, 'OD004', 1, '20.3040', '85.8397', 61, '2019-03-11 09:42:19'),
(1825, 'OD007', 1, '20.2804', '85.8499', 15, '2019-03-11 09:42:19'),
(1826, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:19'),
(1827, 'OD013', 1, '20.2990', '85.8173', 29, '2019-03-11 09:42:20'),
(1828, 'OD004', 1, '20.3040', '85.8397', 59, '2019-03-11 09:42:21'),
(1829, 'OD007', 1, '20.2804', '85.8499', 9, '2019-03-11 09:42:21'),
(1830, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:22'),
(1831, 'OD013', 1, '20.2990', '85.8173', 36, '2019-03-11 09:42:22'),
(1832, 'OD004', 1, '20.3040', '85.8397', 63, '2019-03-11 09:42:23'),
(1833, 'OD007', 1, '20.2804', '85.8499', 12, '2019-03-11 09:42:23'),
(1834, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:24'),
(1835, 'OD013', 1, '20.2990', '85.8173', 37, '2019-03-11 09:42:24'),
(1836, 'OD004', 1, '20.3040', '85.8397', 54, '2019-03-11 09:42:25'),
(1837, 'OD007', 1, '20.2804', '85.8499', 6, '2019-03-11 09:42:26'),
(1838, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:26'),
(1839, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:42:26'),
(1840, 'OD004', 1, '20.3040', '85.8397', 60, '2019-03-11 09:42:27'),
(1841, 'OD007', 1, '20.2804', '85.8499', 12, '2019-03-11 09:42:28'),
(1842, 'OD012', 1, '20.2899', '85.8102', 0, '2019-03-11 09:42:28'),
(1843, 'OD013', 1, '20.2990', '85.8173', 33, '2019-03-11 09:42:28');
-- --------------------------------------------------------
--
-- Table structure for table `role`
--
CREATE TABLE `role` (
`id` int(11) NOT NULL,
`role` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `role`
--
INSERT INTO `role` (`id`, `role`) VALUES
(1, 'ADMIN'),
(2, 'MANAGER');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) NOT NULL,
`email` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`phone` bigint(20) NOT NULL,
`full_name` varchar(50) NOT NULL,
`role` int(11) NOT NULL,
`last_login` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `email`, `password`, `phone`, `full_name`, `role`, `last_login`) VALUES
(1, '[email protected]', '1235', 8280144660, 'Shubhajit Das', 1, '2018-07-14 00:00:00');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `bin_master`
--
ALTER TABLE `bin_master`
ADD PRIMARY KEY (`bin_id`);
--
-- Indexes for table `bin_sensor_data`
--
ALTER TABLE `bin_sensor_data`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `role`
--
ALTER TABLE `role`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),