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 09:53:53
ID #19790 • 192.168.7.123:50000
|
1 | 15.354 | 2.56 | -189.460 | outgoing | - | |
|
2025-11-24 09:53:45
ID #19784 • 192.168.7.123:50000
|
1 | 50.682 | 2.56 | -89.880 | outgoing | - | |
|
2025-11-24 09:52:42
ID #19780 • 192.168.7.123:50000
|
1 | 6.138 | 5.12 | -90.210 | outgoing | - | |
|
2025-11-24 09:52:42
ID #19779 • 192.168.7.123:50000
|
1 | 37.626 | 2.56 | -92.020 | outgoing | - | |
|
2025-11-24 09:52:31
ID #19777 • 192.168.7.123:50000
|
1 | 33.786 | 5.12 | -92.020 | outgoing | - | |
|
2025-11-24 09:51:48
ID #19776 • 192.168.7.123:50000
|
1 | 9.21 | 5.12 | -91.220 | outgoing | - | |
|
2025-11-24 09:51:48
ID #19775 • 192.168.7.123:50000
|
1 | 22.266 | 5.12 | -91.180 | outgoing | - | |
|
2025-11-24 09:51:48
ID #19774 • 192.168.7.123:50000
|
1 | 52.218 | 5.12 | -90.820 | outgoing | - | |
|
2025-11-24 09:51:30
ID #19772 • 192.168.7.123:50000
|
1 | 8.442 | 5.12 | -91.700 | outgoing | - | |
|
2025-11-24 09:51:30
ID #19771 • 192.168.7.123:50000
|
1 | 30.714 | 5.12 | -91.460 | outgoing | - | |
|
2025-11-24 09:51:30
ID #19770 • 192.168.7.123:50000
|
1 | 45.306 | 2.56 | -90.130 | outgoing | - | |
|
2025-11-24 09:51:18
ID #19767 • 192.168.7.123:50000
|
1 | 38.394 | 2.56 | -90.250 | outgoing | - | |
|
2025-11-24 09:49:56
ID #19765 • 192.168.7.123:50000
|
1 | 36.858 | 5.12 | -89.910 | outgoing | - | |
|
2025-11-24 09:49:56
ID #19764 • 192.168.7.123:50000
|
1 | 39.162 | 5.12 | -91.200 | outgoing | - | |
|
2025-11-24 09:49:32
ID #19760 • 192.168.7.123:50000
|
1 | 43.77 | 2.56 | -92.000 | outgoing | - | |
|
2025-11-24 09:49:27
ID #19759 • 192.168.7.123:50000
|
1 | 33.786 | 7.68 | -90.680 | outgoing | - | |
|
2025-11-24 09:48:12
ID #19756 • 192.168.7.123:50000
|
1 | 29.946 | 2.56 | -199.700 | outgoing | - | |
|
2025-11-24 09:43:03
ID #19749 •
|
2 | 52.998 | 2.56 | -90.410 | incoming | - | |
|
2025-11-24 09:41:26
ID #19747 •
|
1 | 59.898 | 2.56 | -90.080 | outgoing | - | |
|
2025-11-24 09:40:14
ID #19746 •
|
2 | 57.606 | 2.56 | -90.920 | incoming | - | |
|
2025-11-24 09:40:14
ID #19745 •
|
2 | 40.71 | 2.56 | -90.270 | incoming | - | |
|
2025-11-24 09:40:04
ID #19743 •
|
1 | 52.986 | 2.56 | -89.980 | outgoing | - | |
|
2025-11-24 09:33:15
ID #19741 •
|
2 | 52.998 | 2.56 | -89.990 | incoming | - | |
|
2025-11-24 09:33:15
ID #19740 •
|
2 | 45.318 | 2.56 | -91.590 | incoming | - | |
|
2025-11-24 09:32:57
ID #19737 •
|
2 | 59.91 | 2.56 | -89.970 | incoming | - | |
|
2025-11-24 09:32:57
ID #19736 •
|
2 | 52.998 | 2.56 | -91.480 | incoming | - | |
|
2025-11-24 09:21:56
ID #19727 •
|
1 | 25.34 | 2.56 | -91.850 | outgoing | - | |
|
2025-11-24 09:15:59
ID #19720 •
|
1 | 23.03 | 2.56 | -90.580 | outgoing | - | |
|
2025-11-24 09:11:56
ID #19716 •
|
1 | 24.57 | 5.12 | -91.750 | outgoing | - | |
|
2025-11-24 09:11:55
ID #19715 •
|
1 | 13.82 | 2.56 | -90.780 | outgoing | - | |
|
2025-11-24 09:05:57
ID #19714 •
|
1 | 36.09 | 2.56 | -90.250 | outgoing | - | |
|
2025-11-24 09:05:10
ID #19713 •
|
2 | 59.142 | 5.12 | -91.540 | incoming | - | |
|
2025-11-24 09:02:41
ID #19712 •
|
1 | 57.594 | 2.56 | -90.200 | outgoing | - | |
|
2025-11-24 09:00:25
ID #19711 •
|
2 | 31.494 | 5.12 | -91.260 | incoming | - | |
|
2025-11-24 09:00:25
ID #19710 •
|
2 | 52.998 | 5.12 | -91.900 | incoming | - | |
|
2025-11-24 08:12:13
ID #19695 • 192.168.7.123:50000
|
1 | 53.207912480051 | 5.12 | -91.500 | outgoing | - | |
|
2025-11-24 08:10:00
ID #19689 • 192.168.7.123:50000
|
1 | 33.786 | 5.12 | -91.880 | outgoing | - | |
|
2025-11-24 08:10:00
ID #19688 • 192.168.7.123:50000
|
1 | 54.522 | 5.12 | -91.290 | outgoing | - | |
|
2025-11-24 08:10:00
ID #19687 • 192.168.7.123:50000
|
1 | 56.058 | 5.12 | -91.780 | outgoing | - | |
|
2025-11-24 08:10:00
ID #19686 • 192.168.7.123:50000
|
1 | 42.234 | 5.12 | -91.860 | outgoing | - | |
|
2025-11-24 08:09:58
ID #19685 • 192.168.7.123:50000
|
1 | 55.29 | 5.12 | -89.700 | outgoing | - | |
|
2025-11-24 08:09:58
ID #19684 • 192.168.7.123:50000
|
1 | 41.466 | 5.12 | -89.730 | outgoing | - | |
|
2025-11-24 08:09:57
ID #19683 • 192.168.7.123:50000
|
1 | 39.162 | 5.12 | -89.900 | outgoing | - | |
|
2025-11-24 08:06:53
ID #19681 • 192.168.7.123:50000
|
1 | 36.230670521002 | 2.56 | -91.920 | outgoing | - | |
|
2025-11-24 08:06:53
ID #19680 • 192.168.7.123:50000
|
1 | 39.347549174577 | 2.56 | -91.870 | outgoing | - | |
|
2025-11-24 08:06:53
ID #19679 • 192.168.7.123:50000
|
1 | 47.529355640212 | 2.56 | -91.800 | outgoing | - | |
|
2025-11-24 08:06:53
ID #19678 • 192.168.7.123:50000
|
1 | 49.477404798697 | 2.56 | -91.710 | outgoing | - | |
|
2025-11-24 08:06:52
ID #19677 • 192.168.7.123:50000
|
1 | 47.918965471909 | 2.56 | -91.090 | outgoing | - | |
|
2025-11-24 08:06:51
ID #19676 • 192.168.7.123:50000
|
1 | 46.360526145121 | 2.56 | -90.230 | outgoing | - | |
|
2025-11-24 08:05:51
ID #19675 • 192.168.7.123:50000
|
1 | 45.631264009986 | 2.56 | -92.160 | outgoing | - |