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 10:36:38
ID #19856 • 192.168.7.123:50000
|
1 | 14.586 | 2.56 | -90.910 | outgoing | - | |
|
2025-11-24 10:32:30
ID #19853 • 192.168.7.123:50000
|
1 | 35.322 | 7.68 | -91.190 | outgoing | - | |
|
2025-11-24 10:32:30
ID #19852 • 192.168.7.123:50000
|
1 | 47.61 | 2.56 | -90.400 | outgoing | - | |
|
2025-11-24 10:30:46
ID #19849 • 192.168.7.123:50000
|
2 | 32.262 | 5.12 | -92.010 | incoming | - | |
|
2025-11-24 10:30:46
ID #19848 • 192.168.7.123:50000
|
2 | 39.942 | 5.12 | -90.990 | incoming | - | |
|
2025-11-24 10:30:26
ID #19842 • 192.168.7.123:50000
|
1 | 6.138 | 5.12 | -91.820 | outgoing | - | |
|
2025-11-24 10:30:21
ID #19840 • 192.168.7.123:50000
|
1 | 8.442 | 5.12 | -91.230 | outgoing | - | |
|
2025-11-24 10:30:21
ID #19839 • 192.168.7.123:50000
|
1 | 11.514 | 5.12 | -91.730 | outgoing | - | |
|
2025-11-24 10:30:17
ID #19838 • 192.168.7.123:50000
|
1 | 5.37 | 5.12 | -90.770 | outgoing | - | |
|
2025-11-24 10:27:15
ID #19832 • 192.168.7.123:50000
|
1 | 50.682 | 5.12 | -89.860 | outgoing | - | |
|
2025-11-24 10:27:07
ID #19829 • 192.168.7.123:50000
|
1 | 43.002 | 2.56 | -90.700 | outgoing | - | |
|
2025-11-24 10:26:16
ID #19828 • 192.168.7.123:50000
|
1 | 29.946 | 2.56 | -91.450 | outgoing | - | |
|
2025-11-24 10:26:06
ID #19823 • 192.168.7.123:50000
|
2 | 52.998 | 2.56 | -90.510 | incoming | - | |
|
2025-11-24 10:04:05
ID #19815 • 192.168.7.123:50000
|
1 | 37.073 | 2.56 | -90.460 | outgoing | - | |
|
2025-11-24 10:04:05
ID #19814 • 192.168.7.123:50000
|
1 | 31.869 | 2.56 | -89.620 | outgoing | - | |
|
2025-11-24 10:04:04
ID #19813 • 192.168.7.123:50000
|
2 | 33.502 | 2.56 | -89.740 | incoming | - | |
|
2025-11-24 10:03:56
ID #19811 • 192.168.7.123:50000
|
1 | 37.544 | 2.56 | -91.270 | outgoing | - | |
|
2025-11-24 10:03:14
ID #19809 • 192.168.7.123:50000
|
2 | 51.726 | 5.12 | -90.530 | incoming | - | |
|
2025-11-24 09:54:47
ID #19797 • 192.168.7.123:50000
|
1 | 22.266 | 5.12 | -91.340 | outgoing | - | |
|
2025-11-24 09:54:47
ID #19796 • 192.168.7.123:50000
|
1 | 59.898 | 5.12 | -91.310 | outgoing | - | |
|
2025-11-24 09:53:59
ID #19792 • 192.168.7.123:50000
|
1 | 48.378 | 2.56 | -90.090 | outgoing | - | |
|
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 | - |