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-7" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 11830714 | 11830714 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:47:15.000000 | 38 | 39 | 2024-10-17 07:47:15+02:00 | 1 |
| 11830713 | 11830713 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:47:12.000000 | 48 | 40 | 2024-10-17 07:47:12+02:00 | -8 |
| 11830712 | 11830712 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:47:07.000000 | 35 | 26 | 2024-10-17 07:47:07+02:00 | -9 |
| 11830711 | 11830711 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:46:59.000000 | 38 | 34 | 2024-10-17 07:46:59+02:00 | -4 |
| 11830710 | 11830710 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:46:54.000000 | 36 | 25 | 2024-10-17 07:46:54+02:00 | -11 |
| 11830709 | 11830709 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:46:45.000000 | 46 | 41 | 2024-10-17 07:46:45+02:00 | -5 |
| 11830708 | 11830708 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:46:13.000000 | 27 | 12 | 2024-10-17 07:46:13+02:00 | -15 |
| 11830707 | 11830707 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:46:02.000000 | 35 | 26 | 2024-10-17 07:46:02+02:00 | -9 |
| 11830706 | 11830706 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:45:54.000000 | 52 | 36 | 2024-10-17 07:45:54+02:00 | -16 |
| 11830705 | 11830705 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:44:48.000000 | 46 | 31 | 2024-10-17 07:44:48+02:00 | -15 |
| 11830704 | 11830704 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:44:42.000000 | 48 | 44 | 2024-10-17 07:44:42+02:00 | -4 |
| 11830703 | 11830703 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:43:20.000000 | 26 | 24 | 2024-10-17 07:43:20+02:00 | -2 |
| 11830702 | 11830702 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:43:15.000000 | 37 | 28 | 2024-10-17 07:43:15+02:00 | -9 |
| 11830701 | 11830701 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:42:08.000000 | 31 | 24 | 2024-10-17 07:42:08+02:00 | -7 |
| 11830700 | 11830700 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:58.000000 | 36 | 30 | 2024-10-17 07:41:58+02:00 | -6 |
| 11830699 | 11830699 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:53.000000 | 16 | 22 | 2024-10-17 07:41:53+02:00 | 6 |
| 11830698 | 11830698 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:37.000000 | 28 | 27 | 2024-10-17 07:41:37+02:00 | -1 |
| 11830697 | 11830697 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:28.000000 | 35 | 31 | 2024-10-17 07:41:28+02:00 | -4 |
| 11830696 | 11830696 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:25.000000 | 41 | 31 | 2024-10-17 07:41:25+02:00 | -10 |
| 11830695 | 11830695 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:15.000000 | 47 | 40 | 2024-10-17 07:41:15+02:00 | -7 |
| 11830694 | 11830694 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:40:29.000000 | 32 | 31 | 2024-10-17 07:40:29+02:00 | -1 |
| 11830693 | 11830693 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:40:17.000000 | 43 | 32 | 2024-10-17 07:40:17+02:00 | -11 |
| 11830692 | 11830692 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:40:13.000000 | 28 | 30 | 2024-10-17 07:40:13+02:00 | 2 |
| 11830691 | 11830691 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:58.000000 | 46 | 36 | 2024-10-17 07:39:58+02:00 | -10 |
| 11830690 | 11830690 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:51.000000 | 53 | 46 | 2024-10-17 07:39:51+02:00 | -7 |
| 11830689 | 11830689 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:49.000000 | 30 | 22 | 2024-10-17 07:39:49+02:00 | -8 |
| 11830688 | 11830688 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:39.000000 | 34 | 30 | 2024-10-17 07:39:39+02:00 | -4 |
| 11830687 | 11830687 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:24.000000 | 36 | 27 | 2024-10-17 07:39:24+02:00 | -9 |
| 11830686 | 11830686 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:16.000000 | 41 | 36 | 2024-10-17 07:39:16+02:00 | -5 |
| 11830685 | 11830685 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:06.000000 | 38 | 24 | 2024-10-17 07:39:06+02:00 | -14 |
| 11830684 | 11830684 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:38:42.000000 | 31 | 19 | 2024-10-17 07:38:42+02:00 | -12 |
| 11830683 | 11830683 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:38:32.000000 | 37 | 29 | 2024-10-17 07:38:32+02:00 | -8 |
| 11830682 | 11830682 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:37:43.000000 | 29 | 24 | 2024-10-17 07:37:43+02:00 | -5 |
| 11830681 | 11830681 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:37:13.000000 | 34 | 26 | 2024-10-17 07:37:13+02:00 | -8 |
| 11830680 | 11830680 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:37:04.000000 | 48 | 34 | 2024-10-17 07:37:04+02:00 | -14 |
| 11830679 | 11830679 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:36:32.000000 | 29 | 33 | 2024-10-17 07:36:32+02:00 | 4 |
| 11830678 | 11830678 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:36:24.000000 | 43 | 35 | 2024-10-17 07:36:24+02:00 | -8 |
| 11830677 | 11830677 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:36:17.000000 | 47 | 41 | 2024-10-17 07:36:17+02:00 | -6 |
| 11830676 | 11830676 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:46.000000 | 23 | 27 | 2024-10-17 07:35:46+02:00 | 4 |
| 11830675 | 11830675 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:43.000000 | 24 | 25 | 2024-10-17 07:35:43+02:00 | 1 |
| 11830674 | 11830674 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:33.000000 | 40 | 30 | 2024-10-17 07:35:33+02:00 | -10 |
| 11830673 | 11830673 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:27.000000 | 31 | 29 | 2024-10-17 07:35:27+02:00 | -2 |
| 11830672 | 11830672 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:13.000000 | 46 | 30 | 2024-10-17 07:35:13+02:00 | -16 |
| 11830671 | 11830671 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:06.000000 | 40 | 26 | 2024-10-17 07:35:06+02:00 | -14 |
| 11830670 | 11830670 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:05.000000 | 41 | 40 | 2024-10-17 07:35:05+02:00 | -1 |
| 11830669 | 11830669 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:34:58.000000 | 49 | 46 | 2024-10-17 07:34:58+02:00 | -3 |
| 11830668 | 11830668 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:34:50.000000 | 51 | 47 | 2024-10-17 07:34:50+02:00 | -4 |
| 11830667 | 11830667 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:34:03.000000 | 38 | 28 | 2024-10-17 07:34:03+02:00 | -10 |
| 11830666 | 11830666 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:33:56.000000 | 13 | 30 | 2024-10-17 07:33:56+02:00 | 17 |
| 11830665 | 11830665 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:33:55.000000 | 41 | 38 | 2024-10-17 07:33:55+02:00 | -3 |
| 11830664 | 11830664 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:33:09.000000 | 29 | 27 | 2024-10-17 07:33:09+02:00 | -2 |
| 11830663 | 11830663 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:59.000000 | 50 | 29 | 2024-10-17 07:32:59+02:00 | -21 |
| 11830662 | 11830662 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:53.000000 | 51 | 48 | 2024-10-17 07:32:53+02:00 | -3 |
| 11830661 | 11830661 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:46.000000 | 35 | 29 | 2024-10-17 07:32:46+02:00 | -6 |
| 11830660 | 11830660 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:29.000000 | 35 | 24 | 2024-10-17 07:32:29+02:00 | -11 |
| 11830659 | 11830659 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:24.000000 | 34 | 23 | 2024-10-17 07:32:24+02:00 | -11 |
| 11830658 | 11830658 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:01.000000 | 36 | 32 | 2024-10-17 07:32:01+02:00 | -4 |
| 11830657 | 11830657 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:31:29.000000 | 38 | 34 | 2024-10-17 07:31:29+02:00 | -4 |
| 11830656 | 11830656 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:30:41.000000 | 29 | 26 | 2024-10-17 07:30:41+02:00 | -3 |
| 11830655 | 11830655 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:30:05.000000 | 35 | 31 | 2024-10-17 07:30:05+02:00 | -4 |
| 11830654 | 11830654 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:29:57.000000 | 49 | 35 | 2024-10-17 07:29:57+02:00 | -14 |
| 11830653 | 11830653 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:29:26.000000 | 20 | 22 | 2024-10-17 07:29:26+02:00 | 2 |
| 11830652 | 11830652 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:28:43.000000 | 31 | 27 | 2024-10-17 07:28:43+02:00 | -4 |
| 11830651 | 11830651 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:28:33.000000 | 43 | 30 | 2024-10-17 07:28:33+02:00 | -13 |
| 11830650 | 11830650 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:28:26.000000 | 48 | 43 | 2024-10-17 07:28:26+02:00 | -5 |
| 11830649 | 11830649 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:27:27.000000 | 35 | 29 | 2024-10-17 07:27:27+02:00 | -6 |
| 11830648 | 11830648 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:27:02.000000 | 46 | 32 | 2024-10-17 07:27:02+02:00 | -14 |
| 11830647 | 11830647 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:26:58.000000 | 34 | 28 | 2024-10-17 07:26:58+02:00 | -6 |
| 11830646 | 11830646 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:26:52.000000 | 33 | 33 | 2024-10-17 07:26:52+02:00 | 0 |
| 11830645 | 11830645 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:26:47.000000 | 45 | 37 | 2024-10-17 07:26:47+02:00 | -8 |
| 11830644 | 11830644 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:26:43.000000 | 48 | 33 | 2024-10-17 07:26:43+02:00 | -15 |
| 11830643 | 11830643 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:24:34.000000 | 36 | 29 | 2024-10-17 07:24:34+02:00 | -7 |
| 11830642 | 11830642 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:24:25.000000 | 41 | 36 | 2024-10-17 07:24:25+02:00 | -5 |
| 11830641 | 11830641 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:24:22.000000 | 53 | 38 | 2024-10-17 07:24:22+02:00 | -15 |
| 11830640 | 11830640 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:24:08.000000 | 26 | 37 | 2024-10-17 07:24:08+02:00 | 11 |
| 11830639 | 11830639 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:23:13.000000 | 38 | 31 | 2024-10-17 07:23:13+02:00 | -7 |
| 11830638 | 11830638 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:22:26.000000 | 40 | 30 | 2024-10-17 07:22:26+02:00 | -10 |
| 11830637 | 11830637 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:22:21.000000 | 45 | 38 | 2024-10-17 07:22:21+02:00 | -7 |
| 11830636 | 11830636 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:21:22.000000 | 29 | 24 | 2024-10-17 07:21:22+02:00 | -5 |
| 11830635 | 11830635 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:21:11.000000 | 33 | 28 | 2024-10-17 07:21:11+02:00 | -5 |
| 11830634 | 11830634 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:21:02.000000 | 43 | 32 | 2024-10-17 07:21:02+02:00 | -11 |
| 11830633 | 11830633 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:19:31.000000 | 32 | 27 | 2024-10-17 07:19:31+02:00 | -5 |
| 11830632 | 11830632 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:19:21.000000 | 40 | 31 | 2024-10-17 07:19:21+02:00 | -9 |
| 11830631 | 11830631 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:18:49.000000 | 35 | 29 | 2024-10-17 07:18:49+02:00 | -6 |
| 11830630 | 11830630 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:18:43.000000 | 27 | 24 | 2024-10-17 07:18:43+02:00 | -3 |
| 11830628 | 11830628 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:18:32.000000 | 31 | 30 | 2024-10-17 07:18:32+02:00 | -1 |
| 11830629 | 11830629 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:18:32.000000 | 30 | 26 | 2024-10-17 07:18:32+02:00 | -4 |
| 11830627 | 11830627 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:18:22.000000 | 34 | 30 | 2024-10-17 07:18:22+02:00 | -4 |
| 11830626 | 11830626 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:17:34.000000 | 53 | 44 | 2024-10-17 07:17:34+02:00 | -9 |
| 11830625 | 11830625 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:17:26.000000 | 20 | 18 | 2024-10-17 07:17:26+02:00 | -2 |
| 11830624 | 11830624 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:16:53.000000 | 26 | 24 | 2024-10-17 07:16:53+02:00 | -2 |
| 11830623 | 11830623 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:16:50.000000 | 38 | 29 | 2024-10-17 07:16:50+02:00 | -9 |
| 11830622 | 11830622 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:16:43.000000 | 49 | 38 | 2024-10-17 07:16:43+02:00 | -11 |
| 11830621 | 11830621 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:16:33.000000 | 34 | 34 | 2024-10-17 07:16:33+02:00 | 0 |
| 11830620 | 11830620 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:16:14.000000 | 39 | 27 | 2024-10-17 07:16:14+02:00 | -12 |
| 11830619 | 11830619 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:15:56.000000 | 35 | 30 | 2024-10-17 07:15:56+02:00 | -5 |
| 11830618 | 11830618 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:15:15.000000 | 31 | 28 | 2024-10-17 07:15:15+02:00 | -3 |
| 11830617 | 11830617 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:14:44.000000 | 33 | 30 | 2024-10-17 07:14:44+02:00 | -3 |
| 11830616 | 11830616 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:14:04.000000 | 23 | 28 | 2024-10-17 07:14:04+02:00 | 5 |
| 11830615 | 11830615 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:13:23.000000 | 33 | 30 | 2024-10-17 07:13:23+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");