This repository has been archived by the owner on Apr 17, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
subway_easy_up_station.sql
1111 lines (1069 loc) · 57.7 KB
/
subway_easy_up_station.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 5.1.1
-- https://www.phpmyadmin.net/
--
-- 主機： 127.0.0.1
-- 產生時間： 2023-09-26 14:50:39
-- 伺服器版本： 10.4.22-MariaDB
-- PHP 版本： 7.4.27
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- 資料庫: `subway_easy_up_station`
--
-- --------------------------------------------------------
--
-- 資料表結構 `access_signal`
--
CREATE TABLE `access_signal` (
`idx` int(11) NOT NULL,
`cid` int(5) NOT NULL,
`route_way` varchar(3) NOT NULL,
`leave_station` int(3) NOT NULL,
`enter_station` int(3) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- 傾印資料表的資料 `access_signal`
--
INSERT INTO `access_signal` (`idx`, `cid`, `route_way`, `leave_station`, `enter_station`, `timestamp`) VALUES
(1, 168, 'OT1', 1, 0, '2023-07-28 18:26:15'),
(2, 168, 'OT1', 1, 0, '2023-07-29 11:00:00'),
(3, 168, 'OT1', 2, 1, '2023-07-29 14:41:07'),
(4, 168, 'OT1', 3, 2, '2023-07-29 14:55:41'),
(5, 168, 'OT1', 0, 0, '2023-07-29 15:01:35'),
(6, 168, 'OT1', 1, 0, '2023-07-29 15:50:45'),
(7, 168, 'OT1', 0, 0, '2023-07-30 09:10:04'),
(8, 168, 'OT1', 1, 0, '2023-07-30 10:03:31'),
(9, 168, 'OT1', 1, 1, '2023-07-30 10:20:56'),
(10, 168, 'OT1', 1, 0, '2023-07-30 12:57:34'),
(11, 168, 'OT1', 0, 0, '2023-07-30 13:11:49'),
(12, 168, 'OT1', 1, 0, '2023-07-31 07:54:40'),
(13, 168, 'OT1', 0, 0, '2023-07-31 08:01:45'),
(14, 168, 'OT1', 3, 3, '2023-07-31 13:02:06'),
(15, 168, 'OT1', 0, 0, '2023-07-31 16:45:09'),
(17, 168, 'OT1', 1, 0, '2023-07-31 16:53:50'),
(18, 168, 'OT1', 1, 1, '2023-07-31 16:54:00'),
(19, 168, 'OT1', 2, 1, '2023-07-31 16:54:10'),
(20, 168, 'OT1', 2, 2, '2023-07-31 16:54:22'),
(21, 168, 'OT1', 3, 2, '2023-07-31 16:54:32'),
(22, 168, 'OT1', 3, 3, '2023-07-31 16:54:42'),
(23, 168, 'OT1', 4, 3, '2023-07-31 16:54:53'),
(24, 168, 'OT1', 4, 4, '2023-07-31 16:55:03'),
(25, 168, 'OT1', 3, 3, '2023-07-31 17:00:44'),
(26, 168, 'OT1', 4, 3, '2023-07-31 17:01:13'),
(27, 168, 'OT1', 4, 4, '2023-07-31 17:01:23'),
(28, 168, 'OT1', 0, 0, '2023-07-31 17:05:21'),
(29, 168, 'OT1', 1, 0, '2023-07-31 17:05:38'),
(30, 168, 'OT1', 1, 1, '2023-07-31 17:05:48'),
(31, 168, 'OT1', 2, 1, '2023-07-31 17:05:59'),
(32, 168, 'OT1', 2, 2, '2023-07-31 17:06:14'),
(33, 168, 'OT1', 3, 2, '2023-07-31 17:06:24'),
(34, 168, 'OT1', 3, 3, '2023-07-31 17:06:34'),
(35, 168, 'OT1', 4, 3, '2023-07-31 17:06:50'),
(36, 168, 'OT1', 4, 4, '2023-07-31 17:07:05'),
(37, 168, 'OT1', 2, 1, '2023-08-01 12:50:24'),
(38, 168, 'OT1', 2, 1, '2023-08-01 17:08:51'),
(39, 168, 'OT1', 2, 1, '2023-08-01 17:33:27'),
(40, 168, 'OT1', 2, 1, '2023-08-01 17:42:18'),
(41, 168, 'OT1', 1, 0, '2023-08-01 18:05:03'),
(42, 133, 'OT1', 2, 1, '2023-08-01 18:05:03'),
(43, 168, 'OT1', 1, 0, '2023-08-01 18:07:19'),
(44, 168, 'OT1', 2, 1, '2023-08-02 03:21:02'),
(45, 168, 'OT1', 3, 2, '2023-08-02 03:22:00'),
(46, 133, 'OT1', 1, 0, '2023-08-02 03:34:33'),
(47, 168, 'OT1', 2, 1, '2023-08-02 03:35:20'),
(48, 168, 'OT1', 1, 0, '2023-08-02 03:41:00'),
(49, 133, 'OT1', 1, 0, '2023-08-02 03:47:49'),
(50, 168, 'OT1', 1, 1, '2023-08-02 04:02:31'),
(51, 168, 'OT1', 2, 1, '2023-08-02 04:02:48'),
(52, 168, 'OT1', 2, 2, '2023-08-02 04:02:59'),
(53, 168, 'OT1', 3, 2, '2023-08-02 04:03:11'),
(54, 168, 'OT1', 1, 0, '2023-08-02 05:32:19'),
(55, 168, 'OT1', 1, 0, '2023-08-02 07:37:41'),
(56, 168, 'OT1', 1, 0, '2023-08-02 07:46:47'),
(57, 168, 'OT1', 0, 0, '2023-08-02 08:24:49'),
(58, 168, 'OT1', 1, 0, '2023-08-02 08:32:52'),
(59, 168, 'OT1', 1, 1, '2023-08-02 08:33:03'),
(60, 168, 'OT1', 2, 1, '2023-08-02 08:34:33'),
(61, 168, 'OT1', 2, 2, '2023-08-02 08:34:44'),
(62, 168, 'OT1', 3, 2, '2023-08-02 08:35:55'),
(63, 168, 'OT1', 3, 3, '2023-08-02 08:36:05'),
(64, 168, 'OT1', 0, 0, '2023-08-02 08:39:30'),
(65, 168, 'OT1', 3, 3, '2023-08-03 02:28:43'),
(66, 168, 'OT1', 0, 0, '2023-08-03 02:57:44'),
(67, 168, 'OT1', 1, 0, '2023-08-03 02:58:57'),
(68, 168, 'OT1', 1, 1, '2023-08-03 03:01:00'),
(69, 168, 'OT1', 2, 1, '2023-08-03 03:02:00'),
(70, 168, 'OT1', 2, 2, '2023-08-03 03:04:01'),
(71, 168, 'OT1', 3, 2, '2023-08-03 03:05:02'),
(72, 168, 'OT1', 3, 3, '2023-08-03 03:07:03'),
(73, 168, 'OT1', 0, 0, '2023-08-03 13:48:06'),
(74, 168, 'OT1', 1, 0, '2023-08-03 13:50:35'),
(75, 168, 'OT1', 1, 1, '2023-08-03 13:52:36'),
(76, 168, 'OT1', 2, 1, '2023-08-03 13:53:37'),
(77, 168, 'OT1', 2, 2, '2023-08-03 13:55:37'),
(78, 168, 'OT1', 3, 2, '2023-08-03 13:56:38'),
(79, 168, 'OT1', 0, 0, '2023-08-03 13:58:54'),
(80, 168, 'OT1', 0, 0, '2023-08-03 14:06:40'),
(81, 168, 'OT1', 0, 0, '2023-08-03 14:10:58'),
(84, 168, 'OT1', 1, 1, '2023-08-03 15:55:03'),
(85, 168, 'OT1', 0, 0, '2023-08-03 16:06:18'),
(86, 168, 'OT1', 1, 0, '2023-08-03 16:12:57'),
(87, 168, 'OT1', 2, 2, '2023-08-03 16:41:20'),
(89, 176, 'O1', 0, 0, '2023-08-03 16:49:21'),
(90, 168, 'OT1', 2, 1, '2023-08-03 17:02:39'),
(91, 168, 'OT1', 2, 2, '2023-08-03 17:03:42'),
(92, 168, 'OT1', 3, 2, '2023-08-03 17:04:50'),
(93, 168, 'OT1', 2, 1, '2023-08-04 08:19:06'),
(94, 168, 'O1', 2, 1, '2023-08-04 08:28:13'),
(95, 168, 'OT1', 2, 1, '2023-08-04 09:30:45'),
(96, 168, 'O1', 2, 1, '2023-08-04 09:53:59'),
(97, 168, 'O1', 2, 2, '2023-08-04 09:55:00'),
(98, 168, 'O1', 0, 0, '2023-08-04 09:57:07'),
(99, 168, 'OT1', 0, 0, '2023-08-04 10:04:16'),
(100, 168, 'OT1', 1, 0, '2023-08-04 10:04:53'),
(101, 168, 'OT1', 1, 1, '2023-08-04 10:05:04'),
(102, 168, 'OT1', 2, 1, '2023-08-04 10:05:19'),
(103, 168, 'OT1', 2, 2, '2023-08-04 10:05:37'),
(104, 168, 'OT1', 3, 2, '2023-08-04 10:05:47'),
(105, 168, 'OT1', 3, 3, '2023-08-04 10:05:58'),
(106, 168, 'O1', 0, 0, '2023-08-04 10:06:31'),
(107, 168, 'O1', 1, 0, '2023-08-05 13:01:23'),
(108, 168, 'O1', 1, 1, '2023-08-05 13:01:34'),
(109, 168, 'O1', 2, 1, '2023-08-05 13:01:44'),
(110, 168, 'O1', 2, 2, '2023-08-05 13:01:54'),
(111, 168, 'O1', 3, 2, '2023-08-05 13:02:04'),
(112, 168, 'O1', 3, 3, '2023-08-05 13:02:15'),
(113, 168, 'O1', 1, 0, '2023-08-05 13:03:29'),
(114, 168, 'O1', 1, 1, '2023-08-05 13:03:42'),
(115, 168, 'O1', 2, 1, '2023-08-05 13:03:55'),
(116, 168, 'O1', 2, 2, '2023-08-05 13:04:12'),
(117, 168, 'O1', 3, 2, '2023-08-05 13:04:23'),
(118, 168, 'O1', 3, 3, '2023-08-05 13:04:35'),
(119, 168, 'O1', 1, 0, '2023-08-05 13:06:55'),
(120, 168, 'O1', 1, 0, '2023-08-05 13:36:15'),
(121, 168, 'OT1', 1, 0, '2023-08-05 13:42:55'),
(122, 133, 'O1', 1, 0, '2023-08-05 13:45:56'),
(124, 133, 'O1', 1, 1, '2023-08-05 13:59:02'),
(125, 133, 'O1', 1, 0, '2023-08-05 14:03:37'),
(126, 168, 'O1', 0, 0, '2023-08-05 14:06:13'),
(127, 168, 'O1', 4, 4, '2023-08-05 14:06:35'),
(129, 168, 'OT1', 0, 0, '2023-08-07 02:32:52'),
(130, 168, 'OT1', 1, 0, '2023-08-07 02:34:02'),
(131, 168, 'OT1', 1, 1, '2023-08-07 02:34:12'),
(132, 168, 'OT1', 2, 1, '2023-08-07 02:34:23'),
(133, 168, 'OT1', 2, 2, '2023-08-07 02:34:38'),
(134, 168, 'OT1', 3, 2, '2023-08-07 02:34:48'),
(135, 168, 'OT1', 3, 3, '2023-08-07 02:35:04'),
(136, 168, 'OT1', 0, 0, '2023-08-07 02:45:06'),
(137, 168, 'OT1', 1, 0, '2023-08-07 02:49:08'),
(138, 168, 'OT1', 1, 1, '2023-08-07 03:13:06'),
(139, 168, 'OT1', 2, 1, '2023-08-07 03:13:17'),
(140, 168, 'OT1', 2, 2, '2023-08-07 03:13:43'),
(141, 168, 'OT1', 3, 2, '2023-08-07 03:13:54'),
(142, 168, 'OT1', 3, 3, '2023-08-07 03:14:04'),
(143, 168, 'OT1', 0, 0, '2023-08-07 06:11:11'),
(144, 168, 'OT1', 1, 0, '2023-08-07 06:13:13'),
(145, 168, 'OT1', 1, 1, '2023-08-07 06:13:23'),
(146, 168, 'OT1', 2, 1, '2023-08-07 06:14:27'),
(147, 168, 'OT1', 2, 2, '2023-08-07 06:14:39'),
(148, 168, 'OT1', 3, 2, '2023-08-07 06:14:51'),
(149, 168, 'OT1', 3, 3, '2023-08-07 06:15:03'),
(150, 168, 'OT1', 0, 0, '2023-08-07 06:17:39'),
(151, 168, 'OT1', 1, 0, '2023-08-07 06:18:11'),
(152, 168, 'OT1', 1, 1, '2023-08-07 06:21:37'),
(153, 168, 'OT1', 2, 1, '2023-08-07 06:21:47'),
(154, 168, 'OT1', 0, 0, '2023-08-07 15:20:39'),
(155, 168, 'OT1', 1, 0, '2023-08-07 15:20:39'),
(156, 168, 'OT1', 1, 1, '2023-08-07 15:20:39'),
(157, 168, 'OT1', 2, 1, '2023-08-07 15:20:39'),
(158, 168, 'OT1', 2, 2, '2023-08-07 15:20:39'),
(160, 168, 'OT1', 0, 0, '2023-08-07 16:01:38'),
(161, 168, 'OT1', 0, 0, '2023-08-07 16:04:16'),
(162, 168, 'OT1', 1, 0, '2023-08-07 16:04:16'),
(163, 168, 'OT1', 1, 1, '2023-08-07 16:04:16'),
(164, 168, 'OT1', 2, 1, '2023-08-07 16:04:16'),
(165, 168, 'OT1', 0, 0, '2023-08-07 16:07:35'),
(166, 168, 'OT1', 1, 0, '2023-08-07 16:07:35'),
(167, 168, 'OT1', 1, 1, '2023-08-07 16:07:35'),
(168, 168, 'OT1', 2, 1, '2023-08-07 16:07:35'),
(169, 168, 'OT1', 0, 0, '2023-08-07 16:19:53'),
(170, 168, 'OT1', 1, 0, '2023-08-07 16:20:03'),
(171, 168, 'OT1', 1, 1, '2023-08-07 16:20:13'),
(172, 168, 'OT1', 2, 1, '2023-08-07 16:20:24'),
(173, 168, 'OT1', 0, 0, '2023-08-07 16:24:05'),
(174, 168, 'OT1', 1, 0, '2023-08-07 16:24:15'),
(175, 168, 'OT1', 1, 1, '2023-08-07 16:24:25'),
(176, 168, 'OT1', 2, 1, '2023-08-07 16:24:35'),
(177, 168, 'OT1', 0, 0, '2023-08-07 16:25:00'),
(178, 168, 'OT1', 1, 0, '2023-08-07 16:25:10'),
(179, 168, 'OT1', 1, 1, '2023-08-07 16:25:20'),
(180, 168, 'OT1', 2, 1, '2023-08-07 16:25:30'),
(181, 168, 'OT1', 0, 0, '2023-08-07 16:26:08'),
(182, 168, 'OT1', 1, 0, '2023-08-07 16:26:18'),
(183, 168, 'OT1', 1, 1, '2023-08-07 16:26:28'),
(184, 168, 'OT1', 2, 1, '2023-08-07 16:26:38'),
(185, 168, 'OT1', 0, 0, '2023-08-07 16:28:55'),
(186, 168, 'OT1', 1, 0, '2023-08-07 16:29:05'),
(187, 168, 'OT1', 1, 1, '2023-08-07 16:29:15'),
(188, 168, 'OT1', 2, 1, '2023-08-07 16:29:25'),
(189, 168, 'OT1', 0, 0, '2023-08-07 16:30:51'),
(190, 168, 'OT1', 1, 0, '2023-08-07 16:31:01'),
(191, 168, 'OT1', 1, 1, '2023-08-07 16:31:11'),
(192, 168, 'OT1', 2, 1, '2023-08-07 16:31:21'),
(193, 168, 'OT1', 0, 0, '2023-08-07 16:32:15'),
(194, 168, 'OT1', 1, 0, '2023-08-07 16:32:25'),
(195, 168, 'OT1', 1, 1, '2023-08-07 16:32:35'),
(196, 168, 'OT1', 2, 1, '2023-08-07 16:32:45'),
(197, 168, 'OT1', 0, 0, '2023-08-07 16:35:29'),
(198, 168, 'OT1', 0, 0, '2023-08-07 16:40:20'),
(199, 168, 'OT1', 1, 0, '2023-08-07 16:41:21'),
(200, 168, 'OT1', 1, 1, '2023-08-07 16:43:21'),
(201, 168, 'OT1', 2, 1, '2023-08-07 16:44:21'),
(202, 168, 'OT1', 0, 0, '2023-08-07 16:54:19'),
(203, 168, 'OT1', 0, 0, '2023-08-07 16:56:26'),
(204, 168, 'OT1', 1, 0, '2023-08-07 16:57:18'),
(205, 168, 'OT1', 1, 1, '2023-08-07 16:59:18'),
(206, 168, 'OT1', 0, 0, '2023-08-07 17:02:57'),
(207, 168, 'OT1', 1, 0, '2023-08-07 17:04:12'),
(208, 168, 'OT1', 1, 1, '2023-08-07 17:06:12'),
(209, 168, 'OT1', 0, 0, '2023-08-07 17:09:48'),
(210, 168, 'OT1', 1, 0, '2023-08-07 17:10:32'),
(211, 168, 'OT1', 1, 1, '2023-08-07 17:12:34'),
(212, 168, 'OT1', 0, 0, '2023-08-07 18:06:38'),
(213, 168, 'OT1', 1, 0, '2023-08-07 18:07:37'),
(214, 168, 'OT1', 1, 1, '2023-08-07 18:09:41'),
(215, 168, 'OT1', 0, 0, '2023-08-07 18:15:10'),
(216, 168, 'OT1', 1, 0, '2023-08-07 18:15:44'),
(217, 168, 'OT1', 1, 1, '2023-08-07 18:17:44'),
(218, 168, 'OT1', 0, 0, '2023-08-08 08:08:40'),
(219, 168, 'OT1', 0, 0, '2023-08-08 08:11:32'),
(220, 168, 'OT1', 1, 0, '2023-08-08 08:12:27'),
(221, 168, 'OT1', 0, 0, '2023-08-08 08:14:29'),
(222, 168, 'OT1', 1, 0, '2023-08-08 08:15:09'),
(223, 168, 'OT1', 0, 0, '2023-08-08 08:15:31'),
(224, 168, 'OT1', 1, 0, '2023-08-08 08:16:09'),
(225, 168, 'OT1', 1, 1, '2023-08-08 08:18:09'),
(226, 168, 'OT1', 0, 0, '2023-08-08 08:21:00'),
(227, 168, 'OT1', 0, 0, '2023-08-08 08:24:31'),
(228, 168, 'OT1', 1, 0, '2023-08-08 08:25:01'),
(229, 168, 'OT1', 0, 0, '2023-08-08 08:25:23'),
(230, 168, 'OT1', 1, 0, '2023-08-08 08:25:53'),
(231, 168, 'OT1', 1, 1, '2023-08-08 08:27:53'),
(232, 168, 'OT1', 2, 1, '2023-08-08 08:28:23'),
(233, 168, 'OT1', 1, 0, '2023-08-08 16:25:03'),
(234, 168, 'OT1', 0, 0, '2023-08-08 17:20:17'),
(235, 168, 'OT1', 0, 0, '2023-08-08 18:07:01'),
(236, 168, 'OT1', 0, 0, '2023-08-08 18:09:32'),
(237, 168, 'OT1', 0, 0, '2023-08-08 18:09:49'),
(238, 168, 'OT1', 0, 0, '2023-08-08 18:10:07'),
(239, 168, 'OT1', 0, 0, '2023-08-08 18:10:49'),
(240, 168, 'OT1', 0, 0, '2023-08-08 18:11:24'),
(241, 168, 'OT1', 0, 0, '2023-08-08 18:11:40'),
(242, 168, 'OT1', 0, 0, '2023-08-08 18:11:53'),
(243, 168, 'OT1', 0, 0, '2023-08-08 18:12:57'),
(244, 168, 'OT1', 0, 0, '2023-08-08 18:13:11'),
(245, 168, 'OT1', 0, 0, '2023-08-08 18:13:37'),
(246, 168, 'OT1', 0, 0, '2023-08-08 18:13:42'),
(247, 168, 'OT1', 0, 0, '2023-08-08 18:13:53'),
(248, 168, 'OT1', 0, 0, '2023-08-08 18:14:11'),
(249, 168, 'OT1', 0, 0, '2023-08-08 18:15:15'),
(250, 168, 'OT1', 0, 0, '2023-08-08 18:22:40'),
(251, 168, 'OT1', 0, 0, '2023-08-08 18:23:39'),
(252, 168, 'OT1', 0, 0, '2023-08-08 18:26:33'),
(253, 168, 'OT1', 1, 0, '2023-08-08 18:27:04'),
(254, 168, 'OT1', 1, 1, '2023-08-08 18:29:04'),
(255, 168, 'OT1', 2, 1, '2023-08-08 18:29:35'),
(256, 168, 'OT1', 0, 0, '2023-08-09 02:31:56'),
(257, 168, 'OT1', 1, 0, '2023-08-09 02:32:26'),
(258, 168, 'OT1', 1, 1, '2023-08-09 02:34:27'),
(259, 168, 'OT1', 2, 1, '2023-08-09 02:34:58'),
(260, 168, 'OT1', 0, 0, '2023-08-09 02:37:04'),
(261, 168, 'OT1', 0, 0, '2023-08-09 02:37:18'),
(262, 168, 'OT1', 1, 0, '2023-08-09 02:37:49'),
(263, 168, 'OT1', 0, 0, '2023-08-09 02:38:00'),
(264, 168, 'OT1', 0, 0, '2023-08-09 02:38:09'),
(265, 168, 'OT1', 0, 0, '2023-08-09 02:38:20'),
(266, 168, 'OT1', 0, 0, '2023-08-09 02:38:26'),
(267, 168, 'OT1', 0, 0, '2023-08-09 02:38:39'),
(268, 168, 'OT1', 0, 0, '2023-08-09 02:39:04'),
(269, 168, 'OT1', 0, 0, '2023-08-09 02:39:14'),
(270, 168, 'OT1', 0, 0, '2023-08-09 02:39:22'),
(271, 168, 'OT1', 0, 0, '2023-08-09 02:39:41'),
(272, 168, 'OT1', 0, 0, '2023-08-09 02:40:02'),
(273, 168, 'OT1', 0, 0, '2023-08-09 02:40:27'),
(274, 168, 'OT1', 0, 0, '2023-08-09 02:40:36'),
(275, 168, 'OT1', 0, 0, '2023-08-09 02:40:43'),
(276, 168, 'OT1', 0, 0, '2023-08-09 02:40:54'),
(277, 168, 'OT1', 0, 0, '2023-08-09 02:41:19'),
(278, 168, 'OT1', 0, 0, '2023-08-09 02:41:44'),
(279, 168, 'OT1', 0, 0, '2023-08-09 02:41:59'),
(280, 168, 'OT1', 0, 0, '2023-08-09 02:42:07'),
(281, 168, 'OT1', 0, 0, '2023-08-09 02:42:16'),
(282, 168, 'OT1', 0, 0, '2023-08-09 02:42:21'),
(283, 168, 'OT1', 1, 0, '2023-08-09 02:42:51'),
(284, 168, 'OT1', 0, 0, '2023-08-09 02:43:10'),
(285, 168, 'OT1', 0, 0, '2023-08-09 02:43:24'),
(286, 168, 'OT1', 1, 0, '2023-08-09 02:43:54'),
(287, 168, 'OT1', 1, 1, '2023-08-09 02:45:55'),
(288, 168, 'OT1', 2, 1, '2023-08-09 02:46:26'),
(289, 168, 'OT1', 0, 0, '2023-08-09 03:01:07'),
(290, 168, 'OT1', 1, 0, '2023-08-09 03:01:37'),
(291, 168, 'OT1', 0, 0, '2023-08-09 03:02:27'),
(292, 168, 'OT1', 1, 0, '2023-08-09 03:02:57'),
(293, 168, 'OT1', 1, 1, '2023-08-09 03:06:15'),
(294, 168, 'OT1', 1, 0, '2023-08-09 03:49:45'),
(295, 168, 'OT1', 0, 0, '2023-08-09 03:53:47'),
(296, 168, 'OT1', 0, 0, '2023-08-09 04:04:38'),
(297, 168, 'OT1', 1, 0, '2023-08-09 04:05:25'),
(298, 168, 'OT1', 0, 0, '2023-08-09 05:26:58'),
(299, 168, 'OT1', 3, 3, '2023-08-09 07:00:33'),
(300, 168, 'OT1', 2, 2, '2023-08-09 07:16:17'),
(301, 168, 'OT1', 1, 1, '2023-08-09 07:18:37'),
(302, 168, 'OT1', 0, 0, '2023-08-09 09:57:38'),
(303, 168, 'OT1', 1, 0, '2023-08-09 09:58:11'),
(304, 168, 'OT1', 1, 1, '2023-08-09 10:01:09'),
(305, 168, 'OT1', 0, 0, '2023-08-09 10:10:06'),
(306, 168, 'OT1', 1, 0, '2023-08-09 10:10:41'),
(307, 168, 'OT1', 1, 1, '2023-08-09 10:12:41'),
(308, 168, 'OT1', 0, 0, '2023-08-09 14:04:57'),
(309, 168, 'OT1', 1, 0, '2023-08-09 14:05:27'),
(310, 168, 'OT1', 0, 0, '2023-08-09 14:05:53'),
(311, 168, 'OT1', 0, 0, '2023-08-09 14:06:05'),
(312, 168, 'OT1', 0, 0, '2023-08-09 14:06:23'),
(313, 168, 'OT1', 1, 0, '2023-08-09 14:06:54'),
(314, 168, 'OT1', 0, 0, '2023-08-09 14:06:56'),
(315, 168, 'OT1', 1, 0, '2023-08-09 14:07:26'),
(316, 168, 'OT1', 1, 1, '2023-08-09 14:09:26'),
(317, 168, 'OT1', 2, 1, '2023-08-09 14:09:57'),
(318, 168, 'OT1', 0, 0, '2023-08-09 14:10:11'),
(319, 168, 'OT1', 1, 0, '2023-08-09 14:10:41'),
(320, 168, 'OT1', 0, 0, '2023-08-09 14:11:36'),
(321, 168, 'OT1', 1, 0, '2023-08-09 14:12:06'),
(322, 168, 'OT1', 1, 1, '2023-08-09 14:14:06'),
(323, 168, 'OT1', 2, 1, '2023-08-09 14:14:36'),
(324, 168, 'OT1', 0, 0, '2023-08-09 14:17:51'),
(325, 168, 'OT1', 1, 0, '2023-08-09 14:18:28'),
(326, 168, 'OT1', 1, 1, '2023-08-09 14:20:28'),
(327, 168, 'OT1', 0, 0, '2023-08-09 15:59:50'),
(328, 168, 'OT1', 0, 0, '2023-08-09 16:02:15'),
(329, 168, 'OT1', 1, 0, '2023-08-09 16:02:50'),
(330, 168, 'OT1', 1, 1, '2023-08-09 16:04:50'),
(331, 168, 'OT1', 0, 0, '2023-08-09 16:17:32'),
(332, 168, 'OT1', 0, 0, '2023-08-09 16:17:34'),
(333, 168, 'OT1', 1, 0, '2023-08-09 16:18:04'),
(334, 168, 'OT1', 0, 0, '2023-08-09 16:18:27'),
(335, 168, 'OT1', 1, 1, '2023-08-09 16:20:05'),
(336, 168, 'OT1', 2, 1, '2023-08-09 16:20:36');
-- --------------------------------------------------------
--
-- 資料表結構 `carriage_info`
--
CREATE TABLE `carriage_info` (
`idx` int(11) NOT NULL,
`cid` int(5) NOT NULL,
`cNo` int(3) NOT NULL,
`dNo` int(2) NOT NULL DEFAULT 1,
`pNum` enum('不壅擠','尚可','壅擠') DEFAULT '不壅擠',
`air` float NOT NULL DEFAULT 0,
`volume` float NOT NULL DEFAULT 0,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- 傾印資料表的資料 `carriage_info`
--
INSERT INTO `carriage_info` (`idx`, `cid`, `cNo`, `dNo`, `pNum`, `air`, `volume`, `timestamp`) VALUES
(1, 168, 1, 1, '不壅擠', 20, 50, '2023-07-28 18:25:03'),
(2, 168, 2, 5, '不壅擠', 20, 50, '2023-07-28 18:25:04'),
(3, 168, 3, 9, '不壅擠', 20, 50, '2023-07-28 18:25:04'),
(4, 168, 1, 1, '不壅擠', 21, 21, '2023-07-29 11:00:57'),
(5, 168, 1, 1, '尚可', 21, 21, '2023-08-01 10:28:42'),
(6, 168, 2, 6, '不壅擠', 21, 21, '2023-08-01 10:28:42'),
(7, 168, 3, 9, '不壅擠', 21, 21, '2023-08-01 10:28:42'),
(8, 133, 1, 1, '不壅擠', 34, 34, '2023-08-05 14:01:41'),
(9, 133, 2, 7, '不壅擠', 34, 34, '2023-08-05 14:01:41'),
(10, 133, 3, 9, '不壅擠', 34, 34, '2023-08-05 14:01:41'),
(11, 133, 2, 8, '不壅擠', 34, 34, '2023-08-05 14:04:58'),
(12, 168, 1, 1, '尚可', 0.823108, 95, '2023-08-07 16:04:16'),
(13, 168, 1, 1, '壅擠', 0.378117, 60, '2023-08-07 16:04:16'),
(14, 168, 1, 1, '壅擠', 0.45506, 45, '2023-08-07 16:04:16'),
(15, 168, 1, 1, '不壅擠', 0.971225, 53, '2023-08-07 16:04:16'),
(16, 168, 1, 1, '尚可', 0.314009, 69, '2023-08-07 16:07:35'),
(17, 168, 1, 1, '尚可', 0.513569, 54, '2023-08-07 16:07:35'),
(18, 168, 1, 1, '不壅擠', 0.370556, 82, '2023-08-07 16:07:35'),
(19, 168, 1, 1, '壅擠', 0.5727, 34, '2023-08-07 16:07:35'),
(20, 168, 1, 1, '不壅擠', 0.412449, 26, '2023-08-07 16:19:53'),
(21, 168, 1, 1, '不壅擠', 0.181942, 58, '2023-08-07 16:20:03'),
(22, 168, 1, 1, '壅擠', 0.477978, 95, '2023-08-07 16:20:13'),
(23, 168, 1, 1, '尚可', 0.42103, 44, '2023-08-07 16:20:24'),
(24, 168, 1, 1, '壅擠', 0.957319, 40, '2023-08-07 16:24:05'),
(25, 168, 1, 1, '壅擠', 0.890364, 65, '2023-08-07 16:24:15'),
(26, 168, 1, 1, '壅擠', 0.846714, 28, '2023-08-07 16:24:25'),
(27, 168, 1, 1, '壅擠', 0.642523, 84, '2023-08-07 16:24:35'),
(28, 168, 1, 1, '不壅擠', 0.314376, 89, '2023-08-07 16:25:00'),
(29, 168, 1, 1, '不壅擠', 0.7186, 100, '2023-08-07 16:25:10'),
(30, 168, 1, 1, '不壅擠', 0.841772, 21, '2023-08-07 16:25:20'),
(31, 168, 1, 1, '壅擠', 0.0880368, 42, '2023-08-07 16:25:30'),
(32, 168, 1, 1, '不壅擠', 0.935522, 86, '2023-08-07 16:26:08'),
(33, 168, 1, 1, '不壅擠', 0.695355, 92, '2023-08-07 16:26:18'),
(34, 168, 1, 1, '壅擠', 0.314549, 52, '2023-08-07 16:26:28'),
(35, 168, 1, 1, '尚可', 0.427091, 51, '2023-08-07 16:26:38'),
(36, 168, 1, 1, '尚可', 0.249039, 89, '2023-08-07 16:28:55'),
(37, 168, 1, 1, '壅擠', 0.556091, 22, '2023-08-07 16:29:05'),
(38, 168, 1, 1, '壅擠', 0.96541, 27, '2023-08-07 16:29:15'),
(39, 168, 1, 1, '不壅擠', 0.254039, 69, '2023-08-07 16:29:25'),
(40, 168, 1, 1, '壅擠', 0.751205, 20, '2023-08-07 16:30:51'),
(41, 168, 1, 1, '不壅擠', 0.904106, 48, '2023-08-07 16:31:01'),
(42, 168, 1, 1, '壅擠', 0.343052, 58, '2023-08-07 16:31:11'),
(43, 168, 1, 1, '壅擠', 0.921238, 95, '2023-08-07 16:31:21'),
(44, 168, 1, 1, '不壅擠', 0.138692, 48, '2023-08-07 16:32:15'),
(45, 168, 1, 1, '壅擠', 0.195637, 90, '2023-08-07 16:32:25'),
(46, 168, 1, 1, '壅擠', 0.381445, 86, '2023-08-07 16:32:35'),
(47, 168, 1, 1, '壅擠', 0.637015, 66, '2023-08-07 16:32:45'),
(48, 168, 1, 1, '不壅擠', 0.0833493, 30, '2023-08-07 16:35:29'),
(49, 168, 1, 1, '壅擠', 0.720954, 98, '2023-08-07 16:40:20'),
(50, 168, 1, 1, '壅擠', 0.57305, 39, '2023-08-07 16:41:21'),
(51, 168, 1, 1, '尚可', 0.994253, 38, '2023-08-07 16:43:21'),
(52, 168, 1, 1, '尚可', 0.790465, 41, '2023-08-07 16:44:21'),
(53, 168, 1, 1, '壅擠', 0.0211322, 91, '2023-08-07 16:57:18'),
(54, 168, 1, 1, '不壅擠', 0.914832, 21, '2023-08-07 16:59:18'),
(55, 168, 1, 1, '不壅擠', 0.808837, 30, '2023-08-07 17:04:12'),
(56, 168, 1, 1, '壅擠', 0.383174, 98, '2023-08-07 17:06:12'),
(57, 168, 1, 1, '尚可', 0.45805, 67, '2023-08-07 17:10:02'),
(58, 168, 1, 1, '尚可', 0.200408, 65, '2023-08-07 17:10:33'),
(59, 168, 1, 1, '壅擠', 0.492493, 64, '2023-08-07 17:10:38'),
(60, 168, 1, 1, '壅擠', 0.214915, 65, '2023-08-07 17:10:43'),
(61, 168, 1, 1, '壅擠', 0.0709676, 35, '2023-08-07 17:10:48'),
(62, 168, 1, 1, '壅擠', 0.652169, 41, '2023-08-07 17:10:53'),
(63, 168, 1, 1, '不壅擠', 0.826607, 30, '2023-08-07 17:10:58'),
(64, 168, 1, 1, '壅擠', 0.0891825, 71, '2023-08-07 17:11:03'),
(65, 168, 1, 1, '不壅擠', 0.240005, 60, '2023-08-07 17:11:08'),
(66, 168, 1, 1, '壅擠', 0.792109, 63, '2023-08-07 17:11:14'),
(67, 168, 1, 1, '尚可', 0.276664, 68, '2023-08-07 17:11:20'),
(68, 168, 1, 1, '不壅擠', 0.0880043, 24, '2023-08-07 17:11:26'),
(69, 168, 1, 1, '壅擠', 0.553696, 39, '2023-08-07 17:11:32'),
(70, 168, 1, 1, '壅擠', 0.30757, 83, '2023-08-07 17:11:38'),
(71, 168, 1, 1, '不壅擠', 0.601748, 39, '2023-08-07 17:11:43'),
(72, 168, 1, 1, '不壅擠', 0.862975, 65, '2023-08-07 17:11:48'),
(73, 168, 1, 1, '不壅擠', 0.711176, 41, '2023-08-07 17:11:54'),
(74, 168, 1, 1, '壅擠', 0.654076, 90, '2023-08-07 17:12:00'),
(75, 168, 1, 1, '壅擠', 0.398774, 22, '2023-08-07 17:12:06'),
(76, 168, 1, 1, '尚可', 0.300317, 74, '2023-08-07 17:12:12'),
(77, 168, 1, 1, '不壅擠', 0.594377, 71, '2023-08-07 17:12:18'),
(78, 168, 1, 1, '壅擠', 0.110436, 59, '2023-08-07 17:12:24'),
(79, 168, 1, 1, '壅擠', 0.518042, 62, '2023-08-07 17:12:30'),
(80, 168, 1, 1, '不壅擠', 0.085551, 60, '2023-08-07 17:12:36'),
(81, 168, 1, 1, '壅擠', 0.607837, 22, '2023-08-07 18:06:46'),
(82, 168, 1, 1, '壅擠', 0.867562, 41, '2023-08-07 18:07:02'),
(83, 168, 1, 1, '壅擠', 0.0603292, 81, '2023-08-07 18:07:06'),
(84, 168, 1, 1, '不壅擠', 0.0924192, 99, '2023-08-07 18:07:41'),
(85, 168, 1, 1, '尚可', 0.358428, 58, '2023-08-07 18:07:47'),
(86, 168, 1, 1, '壅擠', 0.56421, 37, '2023-08-07 18:07:53'),
(87, 168, 1, 1, '壅擠', 0.505217, 74, '2023-08-07 18:07:59'),
(88, 168, 1, 1, '不壅擠', 0.883063, 91, '2023-08-07 18:08:05'),
(89, 168, 1, 1, '不壅擠', 0.250487, 96, '2023-08-07 18:08:11'),
(90, 168, 1, 1, '尚可', 0.38873, 61, '2023-08-07 18:08:17'),
(91, 168, 1, 1, '壅擠', 0.999537, 82, '2023-08-07 18:08:23'),
(92, 168, 1, 1, '尚可', 0.728721, 99, '2023-08-07 18:08:29'),
(93, 168, 1, 1, '尚可', 0.309938, 66, '2023-08-07 18:08:35'),
(94, 168, 1, 1, '尚可', 0.462941, 28, '2023-08-07 18:08:41'),
(95, 168, 1, 1, '壅擠', 0.0822041, 30, '2023-08-07 18:08:47'),
(96, 168, 1, 1, '不壅擠', 0.276048, 65, '2023-08-07 18:08:53'),
(97, 168, 1, 1, '不壅擠', 0.890163, 86, '2023-08-07 18:08:59'),
(98, 168, 1, 1, '壅擠', 0.924346, 99, '2023-08-07 18:09:05'),
(99, 168, 1, 1, '壅擠', 0.2924, 24, '2023-08-07 18:09:10'),
(100, 168, 1, 1, '不壅擠', 0.567103, 90, '2023-08-07 18:09:15'),
(101, 168, 1, 1, '不壅擠', 0.326334, 56, '2023-08-07 18:09:20'),
(102, 168, 1, 1, '尚可', 0.499992, 100, '2023-08-07 18:09:25'),
(103, 168, 1, 1, '壅擠', 0.481083, 88, '2023-08-07 18:09:30'),
(104, 168, 1, 1, '不壅擠', 0.80488, 82, '2023-08-07 18:09:35'),
(105, 168, 1, 1, '壅擠', 0.456721, 69, '2023-08-07 18:09:40'),
(106, 168, 1, 1, '不壅擠', 0.430421, 92, '2023-08-07 18:15:44'),
(107, 168, 1, 1, '不壅擠', 0.446495, 43, '2023-08-07 18:15:49'),
(108, 168, 1, 1, '壅擠', 0.355664, 41, '2023-08-07 18:15:54'),
(109, 168, 1, 1, '不壅擠', 0.398502, 31, '2023-08-07 18:15:59'),
(110, 168, 1, 1, '不壅擠', 0.360792, 76, '2023-08-07 18:16:04'),
(111, 168, 1, 1, '壅擠', 0.543588, 33, '2023-08-07 18:16:09'),
(112, 168, 1, 1, '尚可', 0.628497, 22, '2023-08-07 18:16:14'),
(113, 168, 1, 1, '尚可', 0.647596, 77, '2023-08-07 18:16:19'),
(114, 168, 1, 1, '尚可', 0.598982, 84, '2023-08-07 18:16:25'),
(115, 168, 1, 1, '尚可', 0.393067, 68, '2023-08-07 18:16:30'),
(116, 168, 1, 1, '壅擠', 0.170749, 60, '2023-08-07 18:16:35'),
(117, 168, 1, 1, '尚可', 0.0583568, 47, '2023-08-07 18:16:40'),
(118, 168, 1, 1, '尚可', 0.840308, 66, '2023-08-07 18:16:45'),
(119, 168, 1, 1, '壅擠', 0.888866, 77, '2023-08-07 18:16:50'),
(120, 168, 1, 1, '不壅擠', 0.729685, 84, '2023-08-07 18:16:55'),
(121, 168, 1, 1, '尚可', 0.412832, 93, '2023-08-07 18:17:00'),
(122, 168, 1, 1, '不壅擠', 0.187222, 54, '2023-08-07 18:17:05'),
(123, 168, 1, 1, '不壅擠', 0.563164, 73, '2023-08-07 18:17:10'),
(124, 168, 1, 1, '不壅擠', 0.0598936, 38, '2023-08-07 18:17:15'),
(125, 168, 1, 1, '尚可', 0.715223, 95, '2023-08-07 18:17:20'),
(126, 168, 1, 1, '不壅擠', 0.695743, 94, '2023-08-07 18:17:25'),
(127, 168, 1, 1, '壅擠', 0.86883, 75, '2023-08-07 18:17:30'),
(128, 168, 1, 1, '不壅擠', 0.575271, 27, '2023-08-07 18:17:35'),
(129, 168, 1, 1, '不壅擠', 0.652546, 29, '2023-08-07 18:17:40'),
(130, 168, 1, 1, '不壅擠', 0.58338, 48, '2023-08-07 18:17:45'),
(131, 168, 1, 1, '壅擠', 0.239852, 33, '2023-08-08 08:12:27'),
(132, 168, 1, 1, '壅擠', 0.295033, 55, '2023-08-08 08:12:32'),
(133, 168, 1, 1, '不壅擠', 0.997804, 72, '2023-08-08 08:12:37'),
(134, 168, 1, 1, '尚可', 0.288318, 34, '2023-08-08 08:12:43'),
(135, 168, 1, 1, '壅擠', 0.644641, 25, '2023-08-08 08:12:49'),
(136, 168, 1, 1, '尚可', 0.215547, 43, '2023-08-08 08:12:55'),
(137, 168, 1, 1, '壅擠', 0.774055, 61, '2023-08-08 08:13:01'),
(138, 168, 1, 1, '尚可', 0.419618, 48, '2023-08-08 08:13:07'),
(139, 168, 1, 1, '尚可', 0.623139, 94, '2023-08-08 08:13:13'),
(140, 168, 1, 1, '不壅擠', 0.89821, 65, '2023-08-08 08:13:19'),
(141, 168, 1, 1, '壅擠', 0.136356, 57, '2023-08-08 08:13:25'),
(142, 168, 1, 1, '不壅擠', 0.802503, 28, '2023-08-08 08:13:31'),
(143, 168, 1, 1, '不壅擠', 0.643982, 47, '2023-08-08 08:13:37'),
(144, 168, 1, 1, '不壅擠', 0.253284, 88, '2023-08-08 08:13:43'),
(145, 168, 1, 1, '尚可', 0.759097, 43, '2023-08-08 08:16:09'),
(146, 168, 1, 1, '不壅擠', 0.433044, 42, '2023-08-08 08:16:14'),
(147, 168, 1, 1, '不壅擠', 0.804111, 36, '2023-08-08 08:16:19'),
(148, 168, 1, 1, '壅擠', 0.27138, 64, '2023-08-08 08:16:24'),
(149, 168, 1, 1, '壅擠', 0.47928, 98, '2023-08-08 08:16:29'),
(150, 168, 1, 1, '尚可', 0.28924, 90, '2023-08-08 08:16:34'),
(151, 168, 1, 1, '壅擠', 0.59376, 33, '2023-08-08 08:16:39'),
(152, 168, 1, 1, '壅擠', 0.232235, 55, '2023-08-08 08:16:44'),
(153, 168, 1, 1, '壅擠', 0.881961, 28, '2023-08-08 08:16:49'),
(154, 168, 1, 1, '壅擠', 0.39802, 60, '2023-08-08 08:16:54'),
(155, 168, 1, 1, '壅擠', 0.083061, 72, '2023-08-08 08:16:59'),
(156, 168, 1, 1, '壅擠', 0.893129, 28, '2023-08-08 08:17:04'),
(157, 168, 1, 1, '不壅擠', 0.218561, 33, '2023-08-08 08:17:09'),
(158, 168, 1, 1, '不壅擠', 0.220695, 35, '2023-08-08 08:17:14'),
(159, 168, 1, 1, '尚可', 0.907621, 24, '2023-08-08 08:17:19'),
(160, 168, 1, 1, '壅擠', 0.0424268, 59, '2023-08-08 08:17:24'),
(161, 168, 1, 1, '尚可', 0.664586, 65, '2023-08-08 08:17:29'),
(162, 168, 1, 1, '不壅擠', 0.571248, 29, '2023-08-08 08:17:34'),
(163, 168, 1, 1, '尚可', 0.666354, 77, '2023-08-08 08:17:39'),
(164, 168, 1, 1, '壅擠', 0.872952, 39, '2023-08-08 08:17:44'),
(165, 168, 1, 1, '不壅擠', 0.781568, 57, '2023-08-08 08:17:50'),
(166, 168, 1, 1, '壅擠', 0.21798, 92, '2023-08-08 08:17:55'),
(167, 168, 1, 1, '壅擠', 0.803695, 26, '2023-08-08 08:18:00'),
(168, 168, 1, 1, '尚可', 0.51112, 36, '2023-08-08 08:18:05'),
(169, 168, 1, 1, '尚可', 0.931027, 90, '2023-08-08 08:18:10'),
(170, 168, 1, 1, '壅擠', 0.852318, 26, '2023-08-08 08:21:00'),
(171, 168, 1, 1, '不壅擠', 0.350103, 84, '2023-08-08 08:24:31'),
(172, 168, 1, 1, '不壅擠', 0.851724, 87, '2023-08-08 08:25:01'),
(173, 168, 1, 1, '壅擠', 0.298098, 66, '2023-08-08 08:25:23'),
(174, 168, 1, 1, '尚可', 0.37142, 26, '2023-08-08 08:25:53'),
(175, 168, 1, 1, '壅擠', 0.431652, 78, '2023-08-08 08:27:53'),
(176, 168, 1, 1, '壅擠', 0.0443191, 93, '2023-08-08 08:28:23'),
(177, 168, 1, 1, '不壅擠', 2.5, 2.5, '2023-08-08 16:24:50'),
(178, 168, 2, 5, '不壅擠', 0.5, 2.5, '2023-08-08 16:24:51'),
(180, 168, 1, 1, '壅擠', 0.0182786, 0.0818469, '2023-08-08 18:07:01'),
(181, 168, 1, 1, '壅擠', 0.526938, 0.612078, '2023-08-08 18:09:32'),
(182, 168, 1, 1, '壅擠', 2.59668, 0.117742, '2023-08-08 18:09:49'),
(183, 168, 1, 1, '尚可', 0.805836, 0.413459, '2023-08-08 18:10:07'),
(184, 168, 1, 1, '不壅擠', 0.336154, 1.3334, '2023-08-08 18:10:49'),
(185, 168, 1, 1, '尚可', 1.68056, 2.1262, '2023-08-08 18:11:24'),
(186, 168, 1, 1, '尚可', 2.26512, 0.863036, '2023-08-08 18:11:40'),
(187, 168, 1, 1, '不壅擠', 1.37853, 2.97525, '2023-08-08 18:11:53'),
(188, 168, 1, 1, '不壅擠', 1.50354, 2.68703, '2023-08-08 18:12:57'),
(189, 168, 1, 1, '不壅擠', 1.70609, 0.475518, '2023-08-08 18:13:11'),
(190, 168, 1, 1, '壅擠', 0.940661, 2.03406, '2023-08-08 18:13:37'),
(191, 168, 1, 1, '壅擠', 1.00834, 2.46999, '2023-08-08 18:13:42'),
(192, 168, 1, 1, '不壅擠', 1.57779, 1.45172, '2023-08-08 18:13:53'),
(193, 168, 1, 1, '尚可', 1.67398, 2.19788, '2023-08-08 18:14:11'),
(194, 168, 1, 1, '不壅擠', 0.450265, 1.75974, '2023-08-08 18:15:15'),
(195, 168, 1, 1, '壅擠', 2.16127, 2.1133, '2023-08-08 18:22:40'),
(196, 168, 1, 1, '不壅擠', 2.06245, 0.76982, '2023-08-08 18:23:39'),
(197, 168, 1, 1, '不壅擠', 0.5, 0.5, '2023-08-08 18:26:04'),
(198, 168, 1, 1, '尚可', 2.55023, 1.17888, '2023-08-08 18:26:33'),
(200, 168, 1, 1, '壅擠', 2.12199, 1.52582, '2023-08-08 18:27:04'),
(201, 168, 1, 1, '不壅擠', 1.59414, 0.122362, '2023-08-08 18:29:04'),
(202, 168, 1, 1, '不壅擠', 2.27031, 1.6293, '2023-08-08 18:29:35'),
(203, 168, 1, 1, '不壅擠', 2.83998, 1.48866, '2023-08-09 02:31:56'),
(204, 168, 1, 1, '不壅擠', 1.18663, 1.85053, '2023-08-09 02:32:26'),
(205, 168, 1, 1, '壅擠', 1.7735, 1.91971, '2023-08-09 02:34:27'),
(206, 168, 1, 1, '壅擠', 2.88009, 2.26458, '2023-08-09 02:34:58'),
(207, 168, 1, 1, '不壅擠', 0.405895, 1.50236, '2023-08-09 02:37:04'),
(208, 168, 1, 1, '壅擠', 2.31982, 1.72545, '2023-08-09 02:37:18'),
(209, 168, 1, 1, '尚可', 0.4068, 1.11059, '2023-08-09 02:37:49'),
(210, 168, 1, 1, '尚可', 2.68125, 1.27865, '2023-08-09 02:38:00'),
(211, 168, 1, 1, '不壅擠', 0.277013, 2.23704, '2023-08-09 02:38:09'),
(212, 168, 1, 1, '尚可', 1.40834, 1.4491, '2023-08-09 02:38:20'),
(213, 168, 1, 1, '尚可', 1.93478, 1.80188, '2023-08-09 02:38:26'),
(214, 168, 1, 1, '壅擠', 1.02058, 1.9453, '2023-08-09 02:38:39'),
(215, 168, 1, 1, '壅擠', 2.41039, 1.3208, '2023-08-09 02:39:04'),
(216, 168, 1, 1, '不壅擠', 1.56813, 0.452211, '2023-08-09 02:39:14'),
(217, 168, 1, 1, '壅擠', 0.862829, 1.77886, '2023-08-09 02:39:22'),
(218, 168, 1, 1, '尚可', 0.998085, 2.54665, '2023-08-09 02:39:41'),
(219, 168, 1, 1, '不壅擠', 2.71699, 2.7655, '2023-08-09 02:40:02'),
(220, 168, 1, 1, '不壅擠', 1.95771, 1.11834, '2023-08-09 02:40:27'),
(221, 168, 1, 1, '壅擠', 2.28714, 0.988365, '2023-08-09 02:40:36'),
(222, 168, 1, 1, '尚可', 0.139104, 0.250582, '2023-08-09 02:40:43'),
(223, 168, 1, 1, '尚可', 1.54219, 1.45078, '2023-08-09 02:40:54'),
(224, 168, 1, 1, '尚可', 1.92203, 2.21821, '2023-08-09 02:41:19'),
(225, 168, 1, 1, '壅擠', 1.02577, 2.47264, '2023-08-09 02:41:44'),
(226, 168, 1, 1, '尚可', 1.54578, 2.57101, '2023-08-09 02:41:59'),
(227, 168, 1, 1, '不壅擠', 1.56496, 1.68461, '2023-08-09 02:42:07'),
(228, 168, 1, 1, '壅擠', 1.82892, 0.843671, '2023-08-09 02:42:16'),
(229, 168, 1, 1, '不壅擠', 2.25994, 0.86704, '2023-08-09 02:42:21'),
(230, 168, 1, 1, '尚可', 0.425991, 0.849823, '2023-08-09 02:42:51'),
(231, 168, 1, 1, '不壅擠', 0.715972, 0.913515, '2023-08-09 02:43:10'),
(232, 168, 1, 1, '壅擠', 2.39642, 2.90933, '2023-08-09 02:43:24'),
(233, 168, 1, 1, '不壅擠', 1.54604, 1.18286, '2023-08-09 02:43:54'),
(234, 168, 1, 1, '不壅擠', 1.97707, 2.70635, '2023-08-09 02:45:55'),
(235, 168, 1, 1, '壅擠', 1.97713, 1.26494, '2023-08-09 02:46:26'),
(236, 168, 1, 1, '尚可', 0.900334, 0.940988, '2023-08-09 03:01:07'),
(237, 168, 1, 1, '尚可', 0.687574, 1.90117, '2023-08-09 03:01:37'),
(238, 168, 1, 1, '不壅擠', 2.69979, 1.98004, '2023-08-09 03:02:27'),
(239, 168, 1, 1, '壅擠', 1.42815, 0.100327, '2023-08-09 03:02:57'),
(240, 168, 1, 1, '壅擠', 0.576863, 2.47956, '2023-08-09 03:04:15'),
(241, 168, 1, 1, '尚可', 0.656317, 1.70465, '2023-08-09 03:04:20'),
(242, 168, 1, 1, '尚可', 1.97951, 2.19153, '2023-08-09 03:04:25'),
(243, 168, 1, 1, '尚可', 1.44821, 0.980377, '2023-08-09 03:04:30'),
(244, 168, 1, 1, '壅擠', 2.39273, 1.13042, '2023-08-09 03:04:35'),
(245, 168, 1, 1, '不壅擠', 2.02002, 2.6397, '2023-08-09 03:04:40'),
(246, 168, 1, 1, '不壅擠', 2.82602, 2.72315, '2023-08-09 03:04:45'),
(247, 168, 1, 1, '壅擠', 1.97326, 0.653373, '2023-08-09 03:04:50'),
(248, 168, 1, 1, '尚可', 1.71519, 2.05846, '2023-08-09 03:04:55'),
(249, 168, 1, 1, '尚可', 1.56923, 2.17014, '2023-08-09 03:05:00'),
(250, 168, 1, 1, '壅擠', 1.93306, 2.42455, '2023-08-09 03:05:05'),
(251, 168, 1, 1, '不壅擠', 2.7955, 2.25434, '2023-08-09 03:05:10'),
(252, 168, 1, 1, '不壅擠', 1.68602, 2.82542, '2023-08-09 03:05:15'),
(253, 168, 1, 1, '壅擠', 2.52558, 2.90647, '2023-08-09 03:05:20'),
(254, 168, 1, 1, '尚可', 2.39782, 2.80877, '2023-08-09 03:05:25'),
(255, 168, 1, 1, '壅擠', 2.00246, 2.20589, '2023-08-09 03:05:30'),
(256, 168, 1, 1, '尚可', 1.0498, 1.83396, '2023-08-09 03:05:35'),
(257, 168, 1, 1, '壅擠', 2.75359, 0.112456, '2023-08-09 03:05:40'),
(258, 168, 1, 1, '不壅擠', 2.62141, 2.49578, '2023-08-09 03:05:45'),
(259, 168, 1, 1, '壅擠', 0.497033, 0.388499, '2023-08-09 03:05:50'),
(260, 168, 1, 1, '不壅擠', 0.909819, 0.547406, '2023-08-09 03:05:55'),
(261, 168, 1, 1, '不壅擠', 0.667385, 2.44335, '2023-08-09 03:06:00'),
(262, 168, 1, 1, '尚可', 1.85119, 1.01881, '2023-08-09 03:06:06'),
(263, 168, 1, 1, '壅擠', 2.80569, 1.52622, '2023-08-09 03:06:11'),
(264, 168, 1, 1, '尚可', 2.90473, 2.9643, '2023-08-09 03:06:16'),
(265, 168, 1, 1, '壅擠', 0.600218, 1.7401, '2023-08-09 03:49:49'),
(266, 168, 1, 1, '不壅擠', 0.774622, 2.94987, '2023-08-09 03:49:54'),
(267, 168, 1, 1, '不壅擠', 1.76513, 0.62478, '2023-08-09 03:49:59'),
(268, 168, 1, 1, '不壅擠', 1.21065, 0.337608, '2023-08-09 03:50:04'),
(269, 168, 1, 1, '壅擠', 2.95194, 0.206082, '2023-08-09 03:50:09'),
(270, 168, 1, 1, '不壅擠', 2.14302, 2.67958, '2023-08-09 03:50:14'),
(271, 168, 1, 1, '不壅擠', 0.2363, 0.139815, '2023-08-09 03:50:19'),
(272, 168, 1, 1, '壅擠', 2.29171, 0.754702, '2023-08-09 03:50:25'),
(273, 168, 1, 1, '壅擠', 2.14102, 2.97665, '2023-08-09 03:50:31'),
(274, 168, 1, 1, '尚可', 2.21098, 1.42582, '2023-08-09 03:50:36'),
(275, 168, 1, 1, '不壅擠', 1.69087, 1.46486, '2023-08-09 03:50:42'),
(276, 168, 1, 1, '尚可', 2.70965, 0.540153, '2023-08-09 03:50:48'),
(277, 168, 1, 1, '不壅擠', 1.27647, 0.729851, '2023-08-09 03:50:54'),
(278, 168, 1, 1, '不壅擠', 2.54327, 1.11349, '2023-08-09 03:51:00'),
(279, 168, 1, 1, '不壅擠', 2.36506, 1.77199, '2023-08-09 03:51:06'),
(280, 168, 1, 1, '不壅擠', 2.91237, 0.534555, '2023-08-09 03:51:12'),
(281, 168, 1, 1, '尚可', 1.56251, 1.74995, '2023-08-09 03:51:18'),
(282, 168, 1, 1, '壅擠', 0.544342, 1.69284, '2023-08-09 03:51:23'),
(283, 168, 1, 1, '壅擠', 0.290577, 2.55739, '2023-08-09 03:51:24'),
(284, 168, 1, 1, '不壅擠', 2.07454, 2.18562, '2023-08-09 03:51:29'),
(285, 168, 1, 1, '尚可', 0.622038, 1.56088, '2023-08-09 03:51:34'),
(286, 168, 1, 1, '尚可', 0.0172131, 1.25214, '2023-08-09 03:51:40'),
(287, 168, 1, 1, '不壅擠', 0.258048, 0.662476, '2023-08-09 03:51:42'),
(288, 168, 1, 1, '不壅擠', 0.439425, 1.46279, '2023-08-09 03:51:47'),
(289, 168, 1, 1, '不壅擠', 1.77097, 2.64248, '2023-08-09 03:51:52'),
(290, 168, 1, 1, '壅擠', 1.87015, 0.558986, '2023-08-09 03:51:57'),
(291, 168, 1, 1, '尚可', 1.04763, 2.58295, '2023-08-09 03:52:02'),
(292, 168, 1, 1, '尚可', 1.10219, 2.45139, '2023-08-09 03:52:08'),
(293, 168, 1, 1, '尚可', 1.35736, 2.65387, '2023-08-09 03:52:14'),
(294, 168, 1, 1, '尚可', 1.65215, 1.0921, '2023-08-09 03:52:19'),
(295, 168, 1, 1, '尚可', 2.59035, 0.0583735, '2023-08-09 03:52:24'),
(296, 168, 1, 1, '壅擠', 1.36543, 2.48958, '2023-08-09 03:52:30'),
(297, 168, 1, 1, '尚可', 0.545142, 2.184, '2023-08-09 03:52:31'),
(298, 168, 1, 1, '壅擠', 1.88728, 2.195, '2023-08-09 03:52:36'),
(299, 168, 1, 1, '尚可', 0.102264, 2.09508, '2023-08-09 03:52:39'),
(300, 168, 1, 1, '不壅擠', 1.76502, 0.121626, '2023-08-09 03:52:44'),
(301, 168, 1, 1, '尚可', 0.137025, 1.42075, '2023-08-09 03:52:50'),
(302, 168, 1, 1, '尚可', 0.848344, 2.54455, '2023-08-09 03:52:51'),
(303, 168, 1, 1, '壅擠', 0.152599, 2.05216, '2023-08-09 03:52:57'),
(304, 168, 1, 1, '尚可', 1.71648, 0.188436, '2023-08-09 03:53:02'),
(305, 168, 1, 1, '壅擠', 2.27765, 0.545877, '2023-08-09 03:53:07'),
(306, 168, 1, 1, '尚可', 0.692192, 1.68727, '2023-08-09 03:53:12'),
(307, 168, 1, 1, '壅擠', 0.742877, 1.6073, '2023-08-09 03:53:17'),
(308, 168, 1, 1, '不壅擠', 0.0986307, 2.39117, '2023-08-09 03:53:22'),
(309, 168, 1, 1, '尚可', 2.313, 2.52633, '2023-08-09 03:53:27'),
(310, 168, 1, 1, '壅擠', 0.169115, 2.55574, '2023-08-09 03:53:27'),
(311, 168, 1, 1, '壅擠', 0.131048, 0.380245, '2023-08-09 03:53:32'),
(312, 168, 1, 1, '不壅擠', 0.358677, 2.73184, '2023-08-09 03:53:38'),
(313, 168, 1, 1, '尚可', 0.0771386, 0.748494, '2023-08-09 03:53:43'),
(314, 168, 1, 1, '尚可', 2.09001, 2.19407, '2023-08-09 03:53:49'),
(315, 168, 1, 1, '壅擠', 2.45624, 0.785846, '2023-08-09 04:04:46'),
(316, 168, 1, 1, '壅擠', 2.5164, 2.15732, '2023-08-09 04:05:26'),
(317, 168, 1, 1, '壅擠', 2.96751, 2.349, '2023-08-09 04:05:31'),
(318, 168, 1, 1, '不壅擠', 2.71865, 2.65164, '2023-08-09 04:05:36'),
(319, 168, 1, 1, '壅擠', 1.29073, 1.34981, '2023-08-09 04:05:41'),
(320, 168, 1, 1, '尚可', 0.039446, 1.59657, '2023-08-09 04:05:46'),
(322, 168, 1, 1, '不壅擠', 0.5, 0.5, '2023-08-09 08:42:57'),
(323, 168, 1, 2, '不壅擠', 0, 0.5, '2023-08-09 08:42:57'),
(324, 168, 1, 3, '不壅擠', 0.5, 0.5, '2023-08-09 08:42:57'),
(325, 168, 1, 4, '不壅擠', 0, 0.5, '2023-08-09 08:42:57'),
(326, 168, 2, 8, '不壅擠', 0.5, 0.5, '2023-08-09 08:42:57'),
(327, 168, 2, 7, '不壅擠', 0, 0.5, '2023-08-09 08:42:57'),
(328, 168, 2, 6, '不壅擠', 0.5, 0.5, '2023-08-09 08:42:57'),
(329, 168, 2, 5, '不壅擠', 0.5, 0.5, '2023-08-09 08:42:57'),
(330, 168, 3, 10, '不壅擠', 0.5, 0.5, '2023-08-09 08:42:57'),
(331, 168, 3, 9, '不壅擠', 0.5, 0.5, '2023-08-09 08:42:57'),
(332, 168, 3, 12, '不壅擠', 0.5, 0.5, '2023-08-09 08:42:57'),
(333, 168, 3, 11, '不壅擠', 0.5, 0.5, '2023-08-09 08:42:57'),
(334, 168, 1, 9, '壅擠', 0.963973, 0.20487, '2023-08-09 09:58:12'),
(335, 168, 1, 12, '尚可', 0.270087, 1.608, '2023-08-09 09:58:17'),
(336, 168, 1, 6, '尚可', 2.62935, 1.13602, '2023-08-09 09:58:22'),
(337, 168, 1, 2, '不壅擠', 2.41979, 0.910281, '2023-08-09 09:58:27'),
(338, 168, 1, 1, '尚可', 1.53129, 1.6416, '2023-08-09 09:58:32'),
(339, 168, 1, 9, '尚可', 2.62123, 2.83961, '2023-08-09 09:58:37'),
(340, 168, 1, 1, '不壅擠', 2.80917, 2.06849, '2023-08-09 09:58:43'),
(341, 168, 1, 6, '尚可', 2.29996, 1.93417, '2023-08-09 09:58:49'),
(342, 168, 1, 12, '壅擠', 2.24405, 0.477113, '2023-08-09 09:58:55'),
(343, 168, 1, 3, '尚可', 0.0163188, 2.18661, '2023-08-09 09:59:01'),
(344, 168, 1, 12, '尚可', 0.0687787, 0.992871, '2023-08-09 09:59:07'),
(345, 168, 1, 2, '不壅擠', 1.31656, 2.18578, '2023-08-09 09:59:09'),
(346, 168, 1, 4, '不壅擠', 0.941779, 0.793088, '2023-08-09 09:59:14'),
(347, 168, 1, 3, '壅擠', 1.30539, 0.959767, '2023-08-09 09:59:19'),
(348, 168, 1, 9, '壅擠', 2.12796, 2.09253, '2023-08-09 09:59:24'),
(349, 168, 1, 6, '壅擠', 0.683811, 1.4862, '2023-08-09 09:59:29'),
(350, 168, 1, 5, '尚可', 1, 0.337638, '2023-08-09 09:59:34'),
(351, 168, 1, 3, '壅擠', 2.76643, 0.233953, '2023-08-09 09:59:39'),
(352, 168, 1, 6, '壅擠', 1.03103, 1.42387, '2023-08-09 09:59:44'),
(353, 168, 1, 1, '不壅擠', 2.528, 1.32442, '2023-08-09 09:59:49'),
(354, 168, 1, 11, '不壅擠', 1.76061, 1, '2023-08-09 09:59:54'),
(355, 168, 1, 3, '尚可', 2.82976, 2.70272, '2023-08-09 09:59:59'),
(356, 168, 1, 9, '不壅擠', 1, 1.10877, '2023-08-09 10:00:04'),
(357, 168, 1, 12, '壅擠', 2.27575, 2.92143, '2023-08-09 10:00:09'),
(358, 168, 1, 2, '不壅擠', 0.837335, 1.04479, '2023-08-09 10:00:14'),
(359, 168, 1, 4, '壅擠', 0.0438356, 1.50393, '2023-08-09 10:00:19'),
(360, 168, 1, 7, '壅擠', 0.544244, 0.591473, '2023-08-09 10:00:24'),
(361, 168, 1, 3, '不壅擠', 1.66123, 0.245761, '2023-08-09 10:00:29'),
(362, 168, 1, 8, '不壅擠', 1.15772, 1, '2023-08-09 10:00:34'),
(363, 168, 1, 12, '壅擠', 1.52524, 2.58163, '2023-08-09 10:00:39'),
(364, 168, 1, 4, '壅擠', 0.687544, 2.7974, '2023-08-09 10:00:45'),
(365, 168, 1, 6, '壅擠', 0.581456, 0.8573, '2023-08-09 10:00:50'),
(366, 168, 1, 7, '壅擠', 0.941096, 0.18185, '2023-08-09 10:00:55'),
(367, 168, 1, 12, '尚可', 0.520833, 1.22005, '2023-08-09 10:01:00'),
(368, 168, 1, 1, '不壅擠', 2.60467, 2.7644, '2023-08-09 10:01:05'),
(369, 168, 1, 4, '壅擠', 0, 0, '2023-08-09 10:01:10'),
(370, 168, 1, 1, '壅擠', 0.306752, 0.554164, '2023-08-09 10:10:41'),
(371, 168, 1, 1, '尚可', 1.18833, 2.5791, '2023-08-09 10:10:46'),
(372, 168, 1, 1, '尚可', 2.0972, 0.528463, '2023-08-09 10:10:51'),
(373, 168, 1, 1, '不壅擠', 1.24084, 2.6091, '2023-08-09 10:10:56'),
(374, 168, 1, 1, '不壅擠', 2.24062, 2.08562, '2023-08-09 10:11:01'),
(375, 168, 1, 1, '壅擠', 2.04782, 2.80899, '2023-08-09 10:11:07'),
(376, 168, 1, 1, '尚可', 2.55453, 1.50286, '2023-08-09 10:11:12'),
(377, 168, 1, 1, '壅擠', 1.83258, 1.53403, '2023-08-09 10:11:17'),
(378, 168, 1, 1, '尚可', 2.35031, 2.44249, '2023-08-09 10:11:22'),
(379, 168, 1, 1, '壅擠', 2.97737, 0.663079, '2023-08-09 10:11:27'),
(380, 168, 1, 1, '尚可', 0.905887, 0.290297, '2023-08-09 10:11:32'),
(381, 168, 1, 1, '不壅擠', 0.85673, 1.58745, '2023-08-09 10:11:37'),
(382, 168, 1, 1, '尚可', 1.40969, 2.4635, '2023-08-09 10:11:42'),
(383, 168, 1, 1, '不壅擠', 1.88635, 1.19635, '2023-08-09 10:11:47'),
(384, 168, 1, 1, '壅擠', 0.760281, 0.622844, '2023-08-09 10:11:52'),
(385, 168, 1, 1, '不壅擠', 1.70533, 1.53107, '2023-08-09 10:11:57'),
(386, 168, 1, 1, '壅擠', 0.832601, 2.31247, '2023-08-09 10:12:02'),
(387, 168, 1, 1, '尚可', 0.13247, 2.07565, '2023-08-09 10:12:07'),
(388, 168, 1, 1, '尚可', 0.606429, 1.10256, '2023-08-09 10:12:12'),
(389, 168, 1, 1, '尚可', 2.33832, 0.808133, '2023-08-09 10:12:17'),
(390, 168, 1, 1, '尚可', 1.89139, 2.69121, '2023-08-09 10:12:22'),
(391, 168, 1, 1, '不壅擠', 2.04985, 0.500022, '2023-08-09 10:12:27'),
(392, 168, 1, 1, '尚可', 1.33281, 0.0298974, '2023-08-09 10:12:33'),
(393, 168, 1, 1, '尚可', 0.498947, 1.04826, '2023-08-09 10:12:39'),
(394, 168, 1, 1, '不壅擠', 0.69155, 0.136269, '2023-08-09 10:12:44'),
(395, 168, 1, 1, '尚可', 2.02595, 1.3359, '2023-08-09 14:04:57'),
(396, 168, 1, 1, '尚可', 0.643914, 2.31324, '2023-08-09 14:05:27'),
(397, 168, 1, 1, '壅擠', 0.24231, 2.92281, '2023-08-09 14:05:53'),
(398, 168, 1, 1, '不壅擠', 2.07141, 2.45605, '2023-08-09 14:06:05'),
(399, 168, 1, 1, '壅擠', 2.37506, 1.30833, '2023-08-09 14:06:23'),
(400, 168, 1, 1, '尚可', 2.0793, 1.57479, '2023-08-09 14:06:54'),
(401, 168, 1, 1, '壅擠', 2.96443, 2.51216, '2023-08-09 14:06:56'),
(402, 168, 1, 1, '不壅擠', 2.17814, 2.0324, '2023-08-09 14:07:26'),
(403, 168, 1, 1, '壅擠', 1.64691, 2.92794, '2023-08-09 14:09:26'),
(404, 168, 1, 1, '壅擠', 0.837547, 0.488037, '2023-08-09 14:09:57'),
(405, 168, 1, 1, '不壅擠', 1.34928, 1.67435, '2023-08-09 14:10:11'),
(406, 168, 1, 1, '不壅擠', 0.51186, 2.33157, '2023-08-09 14:10:41'),
(407, 168, 1, 1, '壅擠', 1.64739, 2.58829, '2023-08-09 14:11:36'),
(408, 168, 1, 1, '尚可', 2.25788, 0.792669, '2023-08-09 14:12:06'),
(409, 168, 1, 1, '壅擠', 0.12512, 2.1296, '2023-08-09 14:14:06'),
(410, 168, 1, 1, '尚可', 1.82398, 2.30489, '2023-08-09 14:14:36'),
(411, 168, 1, 1, '尚可', 1.60449, 2.04139, '2023-08-09 14:18:28'),
(412, 168, 1, 1, '不壅擠', 0.877459, 1.31858, '2023-08-09 14:18:33'),
(413, 168, 1, 1, '尚可', 0.106212, 0.736788, '2023-08-09 14:18:38'),
(414, 168, 1, 1, '尚可', 2.39534, 1.73892, '2023-08-09 14:18:43'),
(415, 168, 1, 1, '尚可', 0.308779, 1.00386, '2023-08-09 14:18:48'),
(416, 168, 1, 1, '不壅擠', 1.62323, 0.255837, '2023-08-09 14:18:53'),
(417, 168, 1, 1, '壅擠', 0.493133, 2.27734, '2023-08-09 14:18:58'),
(418, 168, 1, 1, '不壅擠', 1.05719, 0.516841, '2023-08-09 14:19:03'),
(419, 168, 1, 1, '尚可', 1.52885, 2.02535, '2023-08-09 14:19:08'),
(420, 168, 1, 1, '尚可', 0.312228, 2.17359, '2023-08-09 14:19:13'),
(421, 168, 1, 1, '壅擠', 1.23885, 0.362678, '2023-08-09 14:19:18'),
(422, 168, 1, 1, '不壅擠', 1.25249, 2.48507, '2023-08-09 14:19:23'),
(423, 168, 1, 1, '尚可', 0.327422, 0.854709, '2023-08-09 14:19:29'),
(424, 168, 1, 1, '壅擠', 0.580643, 0.30515, '2023-08-09 14:19:34'),
(425, 168, 1, 1, '尚可', 0.128069, 0.464658, '2023-08-09 14:19:39'),
(426, 168, 1, 1, '尚可', 0.380169, 1.78511, '2023-08-09 14:19:44'),
(427, 168, 1, 1, '不壅擠', 1.35606, 1.75368, '2023-08-09 14:19:49'),
(428, 168, 1, 1, '不壅擠', 1.70957, 0.740903, '2023-08-09 14:19:54'),
(429, 168, 1, 1, '尚可', 0.0295526, 1.36903, '2023-08-09 14:19:59'),
(430, 168, 1, 1, '壅擠', 0.896911, 1.33825, '2023-08-09 14:20:04'),
(431, 168, 1, 1, '壅擠', 0.336951, 0.802074, '2023-08-09 14:20:09'),
(432, 168, 1, 1, '壅擠', 1.48126, 2.07963, '2023-08-09 14:20:14'),
(433, 168, 1, 1, '壅擠', 2.35912, 1.13623, '2023-08-09 14:20:19'),
(434, 168, 1, 1, '不壅擠', 0.0650181, 2.16395, '2023-08-09 14:20:24'),
(435, 168, 1, 1, '不壅擠', 0.188269, 1.69075, '2023-08-09 14:20:29'),
(436, 168, 1, 1, '壅擠', 1.83508, 2.33605, '2023-08-09 16:02:50'),
(437, 168, 1, 1, '壅擠', 2.15639, 2.47459, '2023-08-09 16:02:55'),
(438, 168, 1, 1, '不壅擠', 0.728135, 0.550325, '2023-08-09 16:03:00'),
(439, 168, 1, 1, '壅擠', 0.330964, 2.27507, '2023-08-09 16:03:05'),
(440, 168, 1, 1, '壅擠', 1.40604, 1.50755, '2023-08-09 16:03:10'),
(441, 168, 1, 1, '尚可', 1.60227, 2.17703, '2023-08-09 16:03:15'),
(442, 168, 1, 1, '壅擠', 0.449964, 1.7029, '2023-08-09 16:03:20'),
(443, 168, 1, 1, '尚可', 1.07719, 2.19238, '2023-08-09 16:03:26'),
(444, 168, 1, 1, '不壅擠', 0.745326, 2.33442, '2023-08-09 16:03:31'),
(445, 168, 1, 1, '不壅擠', 1.7103, 2.12228, '2023-08-09 16:03:36'),
(446, 168, 1, 1, '尚可', 0.0111075, 1.37524, '2023-08-09 16:03:41'),
(447, 168, 1, 1, '不壅擠', 2.17534, 1.58952, '2023-08-09 16:03:46'),
(448, 168, 1, 1, '尚可', 1.58975, 2.2424, '2023-08-09 16:03:51'),
(449, 168, 1, 1, '不壅擠', 1.61081, 1.41597, '2023-08-09 16:03:56'),
(450, 168, 1, 1, '壅擠', 0.114842, 0.250806, '2023-08-09 16:04:01'),
(451, 168, 1, 1, '壅擠', 0.380485, 1.09758, '2023-08-09 16:04:06'),
(452, 168, 1, 1, '尚可', 1.57651, 1.6099, '2023-08-09 16:04:11'),
(453, 168, 1, 1, '壅擠', 1.19835, 1.06004, '2023-08-09 16:04:16'),
(454, 168, 1, 1, '尚可', 0.532014, 0.483717, '2023-08-09 16:04:21'),
(455, 168, 1, 1, '不壅擠', 2.14646, 0.562197, '2023-08-09 16:04:27'),
(456, 168, 1, 1, '尚可', 1.02431, 0.814151, '2023-08-09 16:04:33'),
(457, 168, 1, 1, '尚可', 1.37864, 0.82126, '2023-08-09 16:04:38'),
(458, 168, 1, 1, '壅擠', 1.24343, 2.00971, '2023-08-09 16:04:43'),
(459, 168, 1, 1, '壅擠', 1.53776, 0.0171351, '2023-08-09 16:04:48'),
(460, 168, 1, 1, '尚可', 2.31802, 0.0703245, '2023-08-09 16:04:53'),
(461, 168, 1, 1, '壅擠', 0.796819, 2.41419, '2023-08-09 16:17:32'),
(462, 168, 1, 1, '尚可', 1.50132, 2.18555, '2023-08-09 16:17:34'),
(463, 168, 1, 1, '不壅擠', 1.56244, 1.46836, '2023-08-09 16:18:04'),
(464, 168, 1, 1, '尚可', 0.111812, 1.36222, '2023-08-09 16:18:27'),
(465, 168, 1, 1, '尚可', 1.35002, 2.36669, '2023-08-09 16:20:05'),
(466, 168, 1, 1, '尚可', 2.47832, 2.05713, '2023-08-09 16:20:36'),
(467, 168, 1, 1, '尚可', 0.413954, 2.05607, '2023-08-09 16:35:23'),
(468, 168, 1, 1, '壅擠', 0.664594, 1.63797, '2023-08-09 16:35:28'),
(469, 168, 1, 1, '不壅擠', 1.10404, 0.367284, '2023-08-09 16:35:34'),
(470, 168, 1, 1, '壅擠', 1.40895, 2.38189, '2023-08-09 16:35:40'),
(471, 168, 1, 1, '壅擠', 2.22574, 1.1624, '2023-08-09 16:35:46'),
(472, 168, 1, 1, '尚可', 0.681883, 0.744776, '2023-08-09 16:35:52'),
(473, 168, 1, 1, '尚可', 0.35034, 0.353622, '2023-08-09 16:35:58'),
(474, 168, 1, 1, '壅擠', 1.54453, 1.02458, '2023-08-09 16:36:03'),
(475, 168, 1, 1, '壅擠', 0.735283, 0.944953, '2023-08-09 16:36:09'),
(476, 168, 1, 1, '尚可', 1.2535, 1.21123, '2023-08-09 16:36:14'),
(477, 168, 1, 1, '不壅擠', 2.09077, 1.19354, '2023-08-09 16:36:19'),
(478, 168, 1, 1, '壅擠', 0.167333, 1.4021, '2023-08-09 16:36:25'),
(479, 168, 1, 1, '壅擠', 2.20722, 0.781878, '2023-08-09 16:36:31'),
(480, 168, 1, 1, '壅擠', 1.95621, 2.01837, '2023-08-09 16:36:36'),
(481, 168, 1, 1, '壅擠', 0.354425, 0.0743174, '2023-08-09 16:36:41'),
(482, 168, 1, 1, '壅擠', 2.08986, 0.488841, '2023-08-09 16:36:46'),
(483, 168, 1, 1, '尚可', 1.38006, 0.263137, '2023-08-09 16:36:51'),
(484, 168, 1, 1, '壅擠', 1.84363, 0.584231, '2023-08-09 16:36:56'),
(485, 168, 1, 1, '壅擠', 1.51228, 1.80663, '2023-08-09 16:37:01'),
(486, 168, 1, 1, '尚可', 0.695054, 0.777846, '2023-08-09 16:37:07'),
(487, 168, 1, 1, '尚可', 0.838095, 1.23467, '2023-08-09 16:37:12'),
(488, 168, 1, 1, '不壅擠', 1.4223, 1.56426, '2023-08-09 16:37:17'),
(489, 168, 1, 1, '不壅擠', 1.76834, 1.20238, '2023-08-09 16:37:22'),
(490, 168, 1, 1, '不壅擠', 2.49417, 0.843774, '2023-08-09 16:37:27'),
(491, 168, 1, 1, '尚可', 1.79632, 1.46962, '2023-08-09 16:37:32'),
(492, 168, 1, 1, '壅擠', 1.41549, 1.40963, '2023-08-09 16:37:37'),
(493, 168, 1, 1, '尚可', 0.521913, 0.123139, '2023-08-09 16:37:42'),
(494, 168, 1, 1, '壅擠', 2.08451, 0.446256, '2023-08-09 16:37:47'),
(495, 168, 1, 1, '尚可', 0.716693, 0.148329, '2023-08-09 16:37:52'),
(496, 168, 1, 1, '', 0, 20, '2023-09-10 10:06:50'),
(497, 168, 1, 1, '', 0, 20, '2023-09-10 10:07:10'),
(498, 168, 1, 1, '', 0, 20, '2023-09-10 10:07:30');
-- --------------------------------------------------------
--
-- 資料表結構 `facility_location`
--
CREATE TABLE `facility_location` (
`idx` int(11) NOT NULL,
`sid` varchar(3) NOT NULL,
`sName` varchar(15) NOT NULL,
`way` enum('OT1','O1') NOT NULL,
`facility_type` varchar(15) NOT NULL,
`facility_way` varchar(3) DEFAULT NULL,
`relative_position` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- 傾印資料表的資料 `facility_location`
--
INSERT INTO `facility_location` (`idx`, `sid`, `sName`, `way`, `facility_type`, `facility_way`, `relative_position`) VALUES
(1, 'O1', '西子灣', 'OT1', 'display_panel', NULL, 1),
(2, 'O1', '西子灣', 'OT1', 'stairs', 'OT1', 4.5),
(3, 'O1', '西子灣', 'OT1', 'escalator', 'OT1', 7.5),
(4, 'O1', '西子灣', 'OT1', 'stairs', 'OT1', 9.5),
(5, 'O1', '西子灣', 'OT1', 'display_panel', NULL, 10.5),
(6, 'O1', '西子灣', 'OT1', 'elevator', NULL, 11),
(7, 'O1', '西子灣', 'OT1', 'stairs', 'O1', 12),
(8, 'O1', '西子灣', 'OT1', 'escalator', 'O1', 12),
(9, 'O2', '鹽埕埔', 'OT1', 'display_panel', NULL, 2.5),
(10, 'O2', '鹽埕埔', 'OT1', 'escalator', 'OT1', 5.5),
(11, 'O2', '鹽埕埔', 'OT1', 'stairs', 'OT1', 9),
(12, 'O2', '鹽埕埔', 'OT1', 'elevator', NULL, 9.5),
(13, 'O2', '鹽埕埔', 'OT1', 'display_panel', NULL, 10),
(14, 'O2', '鹽埕埔', 'OT1', 'escalator', 'O1', 12),
(15, 'O2', '鹽埕埔', 'O1', 'display_panel', NULL, 3.5),
(16, 'O2', '鹽埕埔', 'O1', 'escalator', 'O1', 7),
(17, 'O2', '鹽埕埔', 'O1', 'display_panel', NULL, 9),
(18, 'O2', '鹽埕埔', 'O1', 'elevator', NULL, 12),
(19, 'O2', '鹽埕埔', 'O1', 'stairs', 'OT1', 12),
(20, 'O2', '鹽埕埔', 'O1', 'escalator', 'OT1', 12),
(21, 'O4', '市議會(舊址)', 'OT1', 'display_panel', NULL, 1.5),
(22, 'O4', '市議會(舊址)', 'OT1', 'display_panel', NULL, 3.5),
(23, 'O4', '市議會(舊址)', 'OT1', 'escalator', 'O1', 4),
(24, 'O4', '市議會(舊址)', 'OT1', 'display_panel', NULL, 8.5),
(25, 'O4', '市議會(舊址)', 'OT1', 'stairs', 'O1', 9.5),
(26, 'O4', '市議會(舊址)', 'OT1', 'elevator', NULL, 12),
(27, 'O4', '市議會(舊址)', 'OT1', 'stairs', 'OT1', 12),
(28, 'O4', '市議會(舊址)', 'OT1', 'escalator', 'OT1', 12),
(29, 'O4', '市議會(舊址)', 'O1', 'display_panel', NULL, 1.5),
(30, 'O4', '市議會(舊址)', 'O1', 'display_panel', NULL, 4.5),
(31, 'O4', '市議會(舊址)', 'O1', 'escalator', 'OT1', 5.5),
(32, 'O4', '市議會(舊址)', 'O1', 'display_panel', NULL, 8.5),
(33, 'O4', '市議會(舊址)', 'O1', 'stairs', 'OT1', 8.5),
(34, 'O4', '市議會(舊址)', 'O1', 'elevator', NULL, 12),
(35, 'O4', '市議會(舊址)', 'O1', 'stairs', 'O1', 12),
(36, 'O4', '市議會(舊址)', 'O1', 'escalator', 'O1', 12),
(37, 'O5', '美麗島', 'OT1', 'escalator', 'O1', 5),
(38, 'O5', '美麗島', 'OT1', 'display_panel', NULL, 5),
(39, 'O5', '美麗島', 'OT1', 'stairs', 'O1', 9),
(40, 'O5', '美麗島', 'OT1', 'elevator', NULL, 10),
(41, 'O5', '美麗島', 'OT1', 'display_panel', NULL, 10.5),
(42, 'O5', '美麗島', 'OT1', 'stairs', 'O1', 11),
(43, 'O5', '美麗島', 'OT1', 'escalator', 'O1', 12),
(44, 'O5', '美麗島', 'OT1', 'stairs', 'O1', 12),
(45, 'O5', '美麗島', 'O1', 'display_panel', NULL, 3),
(46, 'O5', '美麗島', 'O1', 'stairs', 'O1', 4),
(47, 'O5', '美麗島', 'O1', 'escalator', 'O1', 7.5),
(48, 'O5', '美麗島', 'O1', 'display_panel', NULL, 7.5),
(49, 'O5', '美麗島', 'O1', 'stairs', 'O1', 11),
(50, 'O5', '美麗島', 'O1', 'elevator', NULL, 12),
(51, 'O5', '美麗島', 'O1', 'stairs', 'O1', 12),
(52, 'O5', '美麗島', 'O1', 'escalator', 'O1', 12),
(56, 'O1', '西子灣', 'O1', 'stairs', 'O1', 2),
(57, 'O1', '西子灣', 'O1', 'escalator', 'O1', 3),
(58, 'O1', '西子灣', 'O1', 'stairs', 'O1', 4.5),
(59, 'O1', '西子灣', 'O1', 'elevator', '', 12),
(60, 'O1', '西子灣', 'O1', 'stairs', 'OT1', 12),
(61, 'O1', '西子灣', 'O1', 'escalator', 'OT1', 12);
-- --------------------------------------------------------
--
-- 資料表結構 `station`
--
CREATE TABLE `station` (
`idx` int(11) NOT NULL,
`sid` varchar(3) NOT NULL,
`sName` varchar(15) NOT NULL,
`route` enum('O','R','C') NOT NULL,
`route_order` int(3) NOT NULL,
`english_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- 傾印資料表的資料 `station`
--
INSERT INTO `station` (`idx`, `sid`, `sName`, `route`, `route_order`, `english_name`) VALUES
(1, 'O1', '西子灣', 'O', 0, 'Sizihwan'),
(2, 'O2', '鹽埕埔', 'O', 1, 'Yanchengpu'),
(3, 'O4', '市議會(舊址)', 'O', 2, 'City Council (Former Site)'),
(4, 'O5', '美麗島', 'O', 3, 'Formosa Boulevard'),
(5, 'OT1', '大寮(前庄)', 'O', 4, 'Daliao');
-- --------------------------------------------------------
--