Einzelmessungen
- Messung_Datum
- Datum der Messung
- Messung_Timestamp
- Zeitpunkt der Messung
- Messung_Zeit
- Uhrzeit der Messung
- Phase
- Phase der Messung (Vormessung, Betrieb, Nachmessung oder nach Ende)
- V_Ausfahrt
- Ausfahrtsgeschwindigkeit in km/h
- V_Delta
- Differenz zwischen Einfahrts- und Ausfahrtsgeschwindigkeit in km/h
- V_Einfahrt
- Einfahrtsgeschwindigkeit in km/h
- Zyklus
- Messzyklus
- id_standort
- Eindeutige Standortkennung
>10,000 rows count all where ID = "4-116" sorted by Messung_Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Messung_Datum (date), Messung_Timestamp (date)
| Link | rowid | ID | id_standort | Zyklus | Phase | Messung_Datum | Messung_Zeit | V_Einfahrt | V_Ausfahrt | Messung_Timestamp ▲ | V_Delta |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1649758 | 1649758 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:53:17.000000 | 15 | 22 | 2024-10-17 05:53:17+02:00 | 7 |
| 1649757 | 1649757 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:53:07.000000 | 29 | 25 | 2024-10-17 05:53:07+02:00 | -4 |
| 1649756 | 1649756 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:52:42.000000 | 29 | 24 | 2024-10-17 05:52:42+02:00 | -5 |
| 1649755 | 1649755 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:52:17.000000 | 19 | 16 | 2024-10-17 05:52:17+02:00 | -3 |
| 1649754 | 1649754 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:51:27.000000 | 20 | 25 | 2024-10-17 05:51:27+02:00 | 5 |
| 1649753 | 1649753 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:51:07.000000 | 29 | 20 | 2024-10-17 05:51:07+02:00 | -9 |
| 1649752 | 1649752 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:50:22.000000 | 15 | 19 | 2024-10-17 05:50:22+02:00 | 4 |
| 1649751 | 1649751 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:47:58.000000 | 29 | 25 | 2024-10-17 05:47:58+02:00 | -4 |
| 1649750 | 1649750 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:45:38.000000 | 28 | 26 | 2024-10-17 05:45:38+02:00 | -2 |
| 1649749 | 1649749 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:43:47.000000 | 19 | 17 | 2024-10-17 05:43:47+02:00 | -2 |
| 1649748 | 1649748 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:42:48.000000 | 26 | 20 | 2024-10-17 05:42:48+02:00 | -6 |
| 1649747 | 1649747 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:42:37.000000 | 24 | 23 | 2024-10-17 05:42:37+02:00 | -1 |
| 1649746 | 1649746 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:39:33.000000 | 28 | 26 | 2024-10-17 05:39:33+02:00 | -2 |
| 1649745 | 1649745 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:38:12.000000 | 25 | 18 | 2024-10-17 05:38:12+02:00 | -7 |
| 1649744 | 1649744 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:37:46.000000 | 28 | 25 | 2024-10-17 05:37:46+02:00 | -3 |
| 1649743 | 1649743 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:36:51.000000 | 34 | 13 | 2024-10-17 05:36:51+02:00 | -21 |
| 1649742 | 1649742 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:36:44.000000 | 29 | 20 | 2024-10-17 05:36:44+02:00 | -9 |
| 1649741 | 1649741 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:36:14.000000 | 23 | 25 | 2024-10-17 05:36:14+02:00 | 2 |
| 1649740 | 1649740 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:36:00.000000 | 24 | 23 | 2024-10-17 05:36:00+02:00 | -1 |
| 1649739 | 1649739 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:35:44.000000 | 26 | 26 | 2024-10-17 05:35:44+02:00 | 0 |
| 1649738 | 1649738 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:34:50.000000 | 33 | 29 | 2024-10-17 05:34:50+02:00 | -4 |
| 1649737 | 1649737 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:34:41.000000 | 35 | 32 | 2024-10-17 05:34:41+02:00 | -3 |
| 1649736 | 1649736 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:32:59.000000 | 30 | 26 | 2024-10-17 05:32:59+02:00 | -4 |
| 1649735 | 1649735 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:32:42.000000 | 36 | 31 | 2024-10-17 05:32:42+02:00 | -5 |
| 1649734 | 1649734 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:32:30.000000 | 28 | 23 | 2024-10-17 05:32:30+02:00 | -5 |
| 1649733 | 1649733 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:31:17.000000 | 36 | 25 | 2024-10-17 05:31:17+02:00 | -11 |
| 1649732 | 1649732 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:30:10.000000 | 17 | 23 | 2024-10-17 05:30:10+02:00 | 6 |
| 1649731 | 1649731 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:29:54.000000 | 26 | 24 | 2024-10-17 05:29:54+02:00 | -2 |
| 1649730 | 1649730 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:29:43.000000 | 24 | 25 | 2024-10-17 05:29:43+02:00 | 1 |
| 1649729 | 1649729 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:27:46.000000 | 19 | 26 | 2024-10-17 05:27:46+02:00 | 7 |
| 1649728 | 1649728 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:26:56.000000 | 32 | 28 | 2024-10-17 05:26:56+02:00 | -4 |
| 1649727 | 1649727 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:26:52.000000 | 30 | 27 | 2024-10-17 05:26:52+02:00 | -3 |
| 1649726 | 1649726 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:26:42.000000 | 14 | 29 | 2024-10-17 05:26:42+02:00 | 15 |
| 1649725 | 1649725 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:26:29.000000 | 18 | 26 | 2024-10-17 05:26:29+02:00 | 8 |
| 1649724 | 1649724 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:24:35.000000 | 27 | 31 | 2024-10-17 05:24:35+02:00 | 4 |
| 1649723 | 1649723 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:24:23.000000 | 26 | 22 | 2024-10-17 05:24:23+02:00 | -4 |
| 1649722 | 1649722 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:23:25.000000 | 31 | 27 | 2024-10-17 05:23:25+02:00 | -4 |
| 1649721 | 1649721 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:23:22.000000 | 25 | 10 | 2024-10-17 05:23:22+02:00 | -15 |
| 1649720 | 1649720 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:23:10.000000 | 20 | 24 | 2024-10-17 05:23:10+02:00 | 4 |
| 1649719 | 1649719 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:22:40.000000 | 15 | 24 | 2024-10-17 05:22:40+02:00 | 9 |
| 1649718 | 1649718 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:22:23.000000 | 32 | 26 | 2024-10-17 05:22:23+02:00 | -6 |
| 1649717 | 1649717 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:21:56.000000 | 30 | 31 | 2024-10-17 05:21:56+02:00 | 1 |
| 1649716 | 1649716 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:20:57.000000 | 40 | 36 | 2024-10-17 05:20:57+02:00 | -4 |
| 1649715 | 1649715 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:20:02.000000 | 16 | 23 | 2024-10-17 05:20:02+02:00 | 7 |
| 1649714 | 1649714 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:19:50.000000 | 31 | 27 | 2024-10-17 05:19:50+02:00 | -4 |
| 1649713 | 1649713 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:18:03.000000 | 28 | 26 | 2024-10-17 05:18:03+02:00 | -2 |
| 1649712 | 1649712 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:12:49.000000 | 33 | 33 | 2024-10-17 05:12:49+02:00 | 0 |
| 1649711 | 1649711 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:12:20.000000 | 25 | 22 | 2024-10-17 05:12:20+02:00 | -3 |
| 1649710 | 1649710 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:09:31.000000 | 29 | 24 | 2024-10-17 05:09:31+02:00 | -5 |
| 1649709 | 1649709 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:09:18.000000 | 18 | 28 | 2024-10-17 05:09:18+02:00 | 10 |
| 1649708 | 1649708 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:07:48.000000 | 27 | 23 | 2024-10-17 05:07:48+02:00 | -4 |
| 1649707 | 1649707 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:07:37.000000 | 24 | 26 | 2024-10-17 05:07:37+02:00 | 2 |
| 1649706 | 1649706 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:07:33.000000 | 27 | 26 | 2024-10-17 05:07:33+02:00 | -1 |
| 1649705 | 1649705 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:06:37.000000 | 28 | 22 | 2024-10-17 05:06:37+02:00 | -6 |
| 1649704 | 1649704 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:06:35.000000 | 23 | 15 | 2024-10-17 05:06:35+02:00 | -8 |
| 1649703 | 1649703 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:05:59.000000 | 18 | 22 | 2024-10-17 05:05:59+02:00 | 4 |
| 1649702 | 1649702 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:02:34.000000 | 35 | 24 | 2024-10-17 05:02:34+02:00 | -11 |
| 1649701 | 1649701 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:02:26.000000 | 10 | 22 | 2024-10-17 05:02:26+02:00 | 12 |
| 1649700 | 1649700 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:01:03.000000 | 30 | 22 | 2024-10-17 05:01:03+02:00 | -8 |
| 1649699 | 1649699 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 05:00:47.000000 | 32 | 29 | 2024-10-17 05:00:47+02:00 | -3 |
| 1649698 | 1649698 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:59:53.000000 | 32 | 28 | 2024-10-17 04:59:53+02:00 | -4 |
| 1649697 | 1649697 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:59:34.000000 | 20 | 22 | 2024-10-17 04:59:34+02:00 | 2 |
| 1649696 | 1649696 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:56:33.000000 | 20 | 16 | 2024-10-17 04:56:33+02:00 | -4 |
| 1649695 | 1649695 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:56:19.000000 | 16 | 19 | 2024-10-17 04:56:19+02:00 | 3 |
| 1649693 | 1649693 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:54:29.000000 | 29 | 27 | 2024-10-17 04:54:29+02:00 | -2 |
| 1649694 | 1649694 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:54:29.000000 | 28 | 20 | 2024-10-17 04:54:29+02:00 | -8 |
| 1649692 | 1649692 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:53:47.000000 | 26 | 23 | 2024-10-17 04:53:47+02:00 | -3 |
| 1649691 | 1649691 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:53:32.000000 | 26 | 25 | 2024-10-17 04:53:32+02:00 | -1 |
| 1649690 | 1649690 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:53:20.000000 | 29 | 27 | 2024-10-17 04:53:20+02:00 | -2 |
| 1649689 | 1649689 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:51:48.000000 | 34 | 27 | 2024-10-17 04:51:48+02:00 | -7 |
| 1649688 | 1649688 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:49:50.000000 | 32 | 28 | 2024-10-17 04:49:50+02:00 | -4 |
| 1649687 | 1649687 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:49:41.000000 | 33 | 31 | 2024-10-17 04:49:41+02:00 | -2 |
| 1649686 | 1649686 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:49:31.000000 | 30 | 29 | 2024-10-17 04:49:31+02:00 | -1 |
| 1649685 | 1649685 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:49:21.000000 | 30 | 29 | 2024-10-17 04:49:21+02:00 | -1 |
| 1649684 | 1649684 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:48:42.000000 | 18 | 24 | 2024-10-17 04:48:42+02:00 | 6 |
| 1649683 | 1649683 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:42:57.000000 | 28 | 25 | 2024-10-17 04:42:57+02:00 | -3 |
| 1649682 | 1649682 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:42:41.000000 | 25 | 30 | 2024-10-17 04:42:41+02:00 | 5 |
| 1649681 | 1649681 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:42:15.000000 | 33 | 28 | 2024-10-17 04:42:15+02:00 | -5 |
| 1649680 | 1649680 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:41:16.000000 | 25 | 14 | 2024-10-17 04:41:16+02:00 | -11 |
| 1649679 | 1649679 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:41:04.000000 | 23 | 24 | 2024-10-17 04:41:04+02:00 | 1 |
| 1649678 | 1649678 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:41:00.000000 | 17 | 20 | 2024-10-17 04:41:00+02:00 | 3 |
| 1649677 | 1649677 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:36:45.000000 | 28 | 28 | 2024-10-17 04:36:45+02:00 | 0 |
| 1649676 | 1649676 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:36:34.000000 | 27 | 27 | 2024-10-17 04:36:34+02:00 | 0 |
| 1649675 | 1649675 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:36:17.000000 | 26 | 22 | 2024-10-17 04:36:17+02:00 | -4 |
| 1649674 | 1649674 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:34:22.000000 | 26 | 22 | 2024-10-17 04:34:22+02:00 | -4 |
| 1649673 | 1649673 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:34:11.000000 | 17 | 25 | 2024-10-17 04:34:11+02:00 | 8 |
| 1649672 | 1649672 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:31:09.000000 | 27 | 25 | 2024-10-17 04:31:09+02:00 | -2 |
| 1649671 | 1649671 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:30:56.000000 | 33 | 26 | 2024-10-17 04:30:56+02:00 | -7 |
| 1649670 | 1649670 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:30:44.000000 | 32 | 25 | 2024-10-17 04:30:44+02:00 | -7 |
| 1649669 | 1649669 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:27:46.000000 | 35 | 32 | 2024-10-17 04:27:46+02:00 | -3 |
| 1649668 | 1649668 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:27:34.000000 | 30 | 34 | 2024-10-17 04:27:34+02:00 | 4 |
| 1649667 | 1649667 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:26:18.000000 | 26 | 22 | 2024-10-17 04:26:18+02:00 | -4 |
| 1649666 | 1649666 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:26:06.000000 | 23 | 25 | 2024-10-17 04:26:06+02:00 | 2 |
| 1649665 | 1649665 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:25:32.000000 | 16 | 14 | 2024-10-17 04:25:32+02:00 | -2 |
| 1649664 | 1649664 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:22:52.000000 | 30 | 28 | 2024-10-17 04:22:52+02:00 | -2 |
| 1649663 | 1649663 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:22:42.000000 | 25 | 29 | 2024-10-17 04:22:42+02:00 | 4 |
| 1649662 | 1649662 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:22:21.000000 | 26 | 23 | 2024-10-17 04:22:21+02:00 | -3 |
| 1649661 | 1649661 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:22:09.000000 | 29 | 25 | 2024-10-17 04:22:09+02:00 | -4 |
| 1649660 | 1649660 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:21:59.000000 | 29 | 28 | 2024-10-17 04:21:59+02:00 | -1 |
| 1649659 | 1649659 | Güterstrasse 4-116 | 116 | 4 | Nachmessung | 2024-10-17 | 04:19:06.000000 | 23 | 26 | 2024-10-17 04:19:06+02:00 | 3 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE Einzelmessungen (
ID TEXT,
id_standort INTEGER,
Zyklus INTEGER,
Phase TEXT,
Messung_Datum TEXT,
Messung_Zeit TEXT,
V_Einfahrt INTEGER,
V_Ausfahrt INTEGER,
Messung_Timestamp TEXT,
V_Delta INTEGER,
FOREIGN KEY (ID) REFERENCES Einsatzplan (ID) ON DELETE CASCADE
);
CREATE INDEX idx_Einzelmessungen_id ON "Einzelmessungen" ("ID");
CREATE INDEX idx_Einzelmessungen_id_standort ON "Einzelmessungen" ("id_standort");
CREATE INDEX idx_Einzelmessungen_zyklus ON "Einzelmessungen" ("Zyklus");
CREATE INDEX idx_Einzelmessungen_phase ON "Einzelmessungen" ("Phase");
CREATE INDEX idx_Einzelmessungen_messung_datum ON "Einzelmessungen" ("Messung_Datum");
CREATE INDEX idx_Einzelmessungen_messung_timestamp ON "Einzelmessungen" ("Messung_Timestamp");