COALESCE(ts_local, DATE_ADD(ts_utc, INTERVAL 8 HOUR)) agar konsisten WITA.
| Time (WITA) | Lane | Speed | Distance | Angle | Dir | Snapshot | Action |
|---|---|---|---|---|---|---|---|
|
2025-11-24 06:47:57
ID #19504 • 192.168.7.123:50000
|
1 | 51.353121023061 | 7.68 | -92.100 | outgoing | - | |
|
2025-11-24 06:47:56
ID #19503 • 192.168.7.123:50000
|
1 | 35.675615863294 | 7.68 | -90.350 | outgoing | - | |
|
2025-11-24 06:47:55
ID #19502 • 192.168.7.123:50000
|
1 | 5.4018127961588 | 2.56 | -91.190 | outgoing | - | |
|
2025-11-24 06:47:55
ID #19501 • 192.168.7.123:50000
|
1 | 11.348452684346 | 2.56 | -91.490 | outgoing | - | |
|
2025-11-24 06:47:55
ID #19500 • 192.168.7.123:50000
|
1 | 8.6454345533519 | 2.56 | -91.560 | outgoing | - | |
|
2025-11-24 06:47:55
ID #19499 • 192.168.7.123:50000
|
1 | 24.322939713119 | 2.56 | -91.990 | outgoing | - | |
|
2025-11-24 06:45:41
ID #19490 • 192.168.7.123:50000
|
1 | 41.561497792511 | 2.56 | -91.060 | outgoing | - | |
|
2025-11-24 06:45:40
ID #19487 • 192.168.7.123:50000
|
1 | 51.101424018229 | 2.56 | -90.500 | outgoing | - | |
|
2025-11-24 06:45:40
ID #19484 • 192.168.7.123:50000
|
1 | 40.880074490674 | 2.56 | -89.670 | outgoing | - | |
|
2025-11-24 06:44:47
ID #19474 • 192.168.7.123:50000
|
1 | 48.378 | 5.12 | -90.260 | outgoing | - | |
|
2025-11-24 06:44:46
ID #19473 • 192.168.7.123:50000
|
1 | 14.586 | 5.12 | -91.560 | outgoing | - | |
|
2025-11-24 06:44:46
ID #19472 • 192.168.7.123:50000
|
1 | 8.442 | 5.12 | -91.030 | outgoing | - | |
|
2025-11-24 06:44:44
ID #19471 • 192.168.7.123:50000
|
1 | 27.756 | 0.01 | -4.950 | outgoing | - | |
|
2025-11-24 06:44:44
ID #19470 • 192.168.7.123:50000
|
1 | 27.756 | 0.01 | -12.630 | outgoing | - | |
|
2025-11-24 06:44:31
ID #19463 • 192.168.7.123:50000
|
1 | 26.106 | 5.12 | -91.680 | outgoing | - | |
|
2025-11-24 06:44:30
ID #19462 • 192.168.7.123:50000
|
1 | 7.674 | 5.12 | -90.310 | outgoing | - | |
|
2025-11-24 06:44:30
ID #19461 • 192.168.7.123:50000
|
1 | 13.818 | 5.12 | -91.170 | outgoing | - | |
|
2025-11-24 06:44:29
ID #19460 • 192.168.7.123:50000
|
1 | 16.89 | 5.12 | -90.170 | outgoing | - | |
|
2025-11-24 06:40:47
ID #19452 •
|
1 | 6.906 | 5.12 | -90.270 | outgoing | - | |
|
2025-11-24 06:40:45
ID #19451 •
|
1 | 59.898 | 5.12 | -90.770 | outgoing | - | |
|
2025-11-24 06:37:00
ID #19449 •
|
1 | 45.306 | 2.56 | -92.000 | outgoing | - | |
|
2025-11-24 06:35:15
ID #19446 •
|
1 | 16.077 | 12.81 | -53.770 | outgoing | - | |
|
2025-11-24 06:35:11
ID #19441 •
|
1 | 45.306 | 2.56 | -20.480 | outgoing | - | |
|
2025-11-24 06:35:09
ID #19439 •
|
1 | 52.986 | 2.56 | 0.010 | outgoing | - | |
|
2025-11-24 06:35:04
ID #19435 •
|
1 | 59.898 | 5.12 | -92.050 | outgoing | - | |
|
2025-11-24 06:34:20
ID #19434 •
|
1 | 31.482 | 5.12 | -89.970 | outgoing | - | |
|
2025-11-24 06:33:11
ID #19433 •
|
2 | 36.102 | 7.68 | -90.160 | incoming | - | |
|
2025-11-24 06:33:09
ID #19431 •
|
2 | 20.742 | 7.68 | -91.850 | incoming | - | |
|
2025-11-24 06:33:09
ID #19430 •
|
2 | 25.35 | 7.68 | -90.180 | incoming | - | |
|
2025-11-24 06:33:09
ID #19429 •
|
2 | 55.302 | 7.68 | -89.610 | incoming | - | |
|
2025-11-24 06:33:05
ID #19426 •
|
2 | 55.302 | 7.68 | -91.450 | incoming | - | |
|
2025-11-24 06:33:01
ID #19421 •
|
1 | 10.746 | 7.68 | -104.960 | outgoing | - | |
|
2025-11-24 06:33:01
ID #19420 •
|
1 | 41.466 | 7.68 | -94.720 | outgoing | - | |
|
2025-11-24 06:32:56
ID #19416 •
|
1 | 51.45 | 5.12 | -90.760 | outgoing | - | |
|
2025-11-24 06:32:53
ID #19413 •
|
1 | 41.466 | 5.12 | -110.080 | outgoing | - | |
|
2025-11-24 06:32:53
ID #19412 •
|
1 | 33.018 | 7.68 | -90.140 | outgoing | - | |
|
2025-11-24 06:32:53
ID #19411 •
|
2 | 56.07 | 2.56 | -99.840 | incoming | - | |
|
2025-11-24 06:29:28
ID #19405 •
|
1 | 40.698 | 2.56 | -90.960 | outgoing | - | |
|
2025-11-24 06:29:07
ID #19402 •
|
1 | 44.538 | 2.56 | -89.790 | outgoing | - | |
|
2025-11-24 06:28:58
ID #19400 •
|
2 | 29.19 | 2.56 | -92.100 | incoming | - | |
|
2025-11-24 06:28:57
ID #19399 •
|
2 | 36.87 | 2.56 | -91.040 | incoming | - | |
|
2025-11-24 06:28:38
ID #19396 •
|
2 | 45.318 | 5.12 | -90.920 | incoming | - | |
|
2025-11-24 06:26:56
ID #19392 •
|
2 | 32.262 | 2.56 | -90.120 | incoming | - | |
|
2025-11-24 06:26:48
ID #19388 •
|
2 | 50.694 | 2.56 | -92.100 | incoming | - | |
|
2025-11-24 06:26:44
ID #19385 •
|
1 | 55.29 | 2.56 | -90.910 | outgoing | - | |
|
2025-11-24 06:25:52
ID #19377 •
|
1 | 53.754 | 5.12 | -91.010 | outgoing | - | |
|
2025-11-24 06:25:51
ID #19376 •
|
1 | 42.234 | 5.12 | -92.110 | outgoing | - | |
|
2025-11-24 06:25:51
ID #19375 •
|
1 | 16.122 | 5.12 | -90.220 | outgoing | - | |
|
2025-11-24 06:25:51
ID #19374 •
|
1 | 6.906 | 5.12 | -91.820 | outgoing | - | |
|
2025-11-24 06:25:18
ID #19372 •
|
1 | 56.058 | 2.56 | -89.730 | outgoing | - |