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
8,966 rows where ID = "2-25" sorted by Messung_Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Phase, Messung_Datum, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1370685 | 1370685 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:46:13.000000 | 23 | 29 | 2023-09-01 08:46:13+02:00 | 6 |
| 1370684 | 1370684 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:43:07.000000 | 19 | 22 | 2023-09-01 08:43:07+02:00 | 3 |
| 1370683 | 1370683 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:35:57.000000 | 25 | 22 | 2023-09-01 08:35:57+02:00 | -3 |
| 1370682 | 1370682 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:29:01.000000 | 18 | 19 | 2023-09-01 08:29:01+02:00 | 1 |
| 1370681 | 1370681 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:28:02.000000 | 13 | 20 | 2023-09-01 08:28:02+02:00 | 7 |
| 1370680 | 1370680 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:27:11.000000 | 24 | 27 | 2023-09-01 08:27:11+02:00 | 3 |
| 1370679 | 1370679 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:24:23.000000 | 16 | 13 | 2023-09-01 08:24:23+02:00 | -3 |
| 1370678 | 1370678 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:24:14.000000 | 28 | 15 | 2023-09-01 08:24:14+02:00 | -13 |
| 1370677 | 1370677 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:15:06.000000 | 15 | 20 | 2023-09-01 08:15:06+02:00 | 5 |
| 1370676 | 1370676 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:14:55.000000 | 24 | 24 | 2023-09-01 08:14:55+02:00 | 0 |
| 1370675 | 1370675 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:56:14.000000 | 16 | 14 | 2023-09-01 07:56:14+02:00 | -2 |
| 1370674 | 1370674 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:49:32.000000 | 15 | 19 | 2023-09-01 07:49:32+02:00 | 4 |
| 1370673 | 1370673 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:39:46.000000 | 19 | 17 | 2023-09-01 07:39:46+02:00 | -2 |
| 1370672 | 1370672 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:30:59.000000 | 16 | 18 | 2023-09-01 07:30:59+02:00 | 2 |
| 1370671 | 1370671 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:30:48.000000 | 27 | 28 | 2023-09-01 07:30:48+02:00 | 1 |
| 1370670 | 1370670 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:30:24.000000 | 27 | 26 | 2023-09-01 07:30:24+02:00 | -1 |
| 1370669 | 1370669 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:29:04.000000 | 14 | 12 | 2023-09-01 07:29:04+02:00 | -2 |
| 1370668 | 1370668 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:26:41.000000 | 33 | 27 | 2023-09-01 07:26:41+02:00 | -6 |
| 1370667 | 1370667 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:18:06.000000 | 23 | 20 | 2023-09-01 07:18:06+02:00 | -3 |
| 1370666 | 1370666 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:11:31.000000 | 16 | 18 | 2023-09-01 07:11:31+02:00 | 2 |
| 1370665 | 1370665 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:06:06.000000 | 12 | 20 | 2023-09-01 07:06:06+02:00 | 8 |
| 1370664 | 1370664 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:00:28.000000 | 17 | 13 | 2023-09-01 07:00:28+02:00 | -4 |
| 1370663 | 1370663 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:45:12.000000 | 16 | 17 | 2023-09-01 06:45:12+02:00 | 1 |
| 1370662 | 1370662 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:38:13.000000 | 31 | 24 | 2023-09-01 06:38:13+02:00 | -7 |
| 1370661 | 1370661 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:31:37.000000 | 15 | 20 | 2023-09-01 06:31:37+02:00 | 5 |
| 1370660 | 1370660 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:30:03.000000 | 16 | 17 | 2023-09-01 06:30:03+02:00 | 1 |
| 1370659 | 1370659 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:27:23.000000 | 26 | 22 | 2023-09-01 06:27:23+02:00 | -4 |
| 1370658 | 1370658 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:27:17.000000 | 14 | 12 | 2023-09-01 06:27:17+02:00 | -2 |
| 1370657 | 1370657 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:26:56.000000 | 3 | 3 | 2023-09-01 06:26:56+02:00 | 0 |
| 1370656 | 1370656 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:26:40.000000 | 11 | 13 | 2023-09-01 06:26:40+02:00 | 2 |
| 1370655 | 1370655 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:25:45.000000 | 28 | 20 | 2023-09-01 06:25:45+02:00 | -8 |
| 1370654 | 1370654 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:22:48.000000 | 11 | 17 | 2023-09-01 06:22:48+02:00 | 6 |
| 1370653 | 1370653 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:17:37.000000 | 15 | 20 | 2023-09-01 06:17:37+02:00 | 5 |
| 1370652 | 1370652 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:17:36.000000 | 25 | 22 | 2023-09-01 06:17:36+02:00 | -3 |
| 1370651 | 1370651 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:17:13.000000 | 25 | 20 | 2023-09-01 06:17:13+02:00 | -5 |
| 1370650 | 1370650 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:13:36.000000 | 31 | 27 | 2023-09-01 06:13:36+02:00 | -4 |
| 1370649 | 1370649 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:12:13.000000 | 16 | 18 | 2023-09-01 06:12:13+02:00 | 2 |
| 1370648 | 1370648 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:12:00.000000 | 24 | 25 | 2023-09-01 06:12:00+02:00 | 1 |
| 1370647 | 1370647 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:06:33.000000 | 26 | 22 | 2023-09-01 06:06:33+02:00 | -4 |
| 1370646 | 1370646 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:45:00.000000 | 17 | 17 | 2023-09-01 05:45:00+02:00 | 0 |
| 1370645 | 1370645 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:43:58.000000 | 20 | 19 | 2023-09-01 05:43:58+02:00 | -1 |
| 1370644 | 1370644 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:39:44.000000 | 24 | 25 | 2023-09-01 05:39:44+02:00 | 1 |
| 1370643 | 1370643 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:36:40.000000 | 29 | 24 | 2023-09-01 05:36:40+02:00 | -5 |
| 1370642 | 1370642 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:35:14.000000 | 17 | 19 | 2023-09-01 05:35:14+02:00 | 2 |
| 1370641 | 1370641 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:31:47.000000 | 19 | 16 | 2023-09-01 05:31:47+02:00 | -3 |
| 1370640 | 1370640 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:28:57.000000 | 17 | 10 | 2023-09-01 05:28:57+02:00 | -7 |
| 1370639 | 1370639 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:28:38.000000 | 24 | 22 | 2023-09-01 05:28:38+02:00 | -2 |
| 1370638 | 1370638 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:26:04.000000 | 29 | 22 | 2023-09-01 05:26:04+02:00 | -7 |
| 1370637 | 1370637 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:25:43.000000 | 16 | 15 | 2023-09-01 05:25:43+02:00 | -1 |
| 1370636 | 1370636 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:24:50.000000 | 14 | 14 | 2023-09-01 05:24:50+02:00 | 0 |
| 1370635 | 1370635 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:22:31.000000 | 20 | 19 | 2023-09-01 05:22:31+02:00 | -1 |
| 1370634 | 1370634 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:18:05.000000 | 26 | 27 | 2023-09-01 05:18:05+02:00 | 1 |
| 1370633 | 1370633 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:15:21.000000 | 30 | 26 | 2023-09-01 05:15:21+02:00 | -4 |
| 1370632 | 1370632 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:13:24.000000 | 20 | 17 | 2023-09-01 05:13:24+02:00 | -3 |
| 1370631 | 1370631 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:08:00.000000 | 18 | 22 | 2023-09-01 05:08:00+02:00 | 4 |
| 1370630 | 1370630 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:07:06.000000 | 31 | 27 | 2023-09-01 05:07:06+02:00 | -4 |
| 1370629 | 1370629 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:03:55.000000 | 26 | 20 | 2023-09-01 05:03:55+02:00 | -6 |
| 1370628 | 1370628 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:03:33.000000 | 26 | 25 | 2023-09-01 05:03:33+02:00 | -1 |
| 1370627 | 1370627 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:00:42.000000 | 17 | 17 | 2023-09-01 05:00:42+02:00 | 0 |
| 1370626 | 1370626 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:00:24.000000 | 23 | 20 | 2023-09-01 05:00:24+02:00 | -3 |
| 1370625 | 1370625 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:57:28.000000 | 24 | 17 | 2023-09-01 04:57:28+02:00 | -7 |
| 1370624 | 1370624 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:45:21.000000 | 14 | 17 | 2023-09-01 04:45:21+02:00 | 3 |
| 1370623 | 1370623 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:41:01.000000 | 11 | 13 | 2023-09-01 04:41:01+02:00 | 2 |
| 1370622 | 1370622 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:07:28.000000 | 28 | 23 | 2023-09-01 04:07:28+02:00 | -5 |
| 1370621 | 1370621 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:02:46.000000 | 26 | 24 | 2023-09-01 04:02:46+02:00 | -2 |
| 1370620 | 1370620 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 03:57:28.000000 | 25 | 15 | 2023-09-01 03:57:28+02:00 | -10 |
| 1370619 | 1370619 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 03:51:23.000000 | 12 | 18 | 2023-09-01 03:51:23+02:00 | 6 |
| 1370618 | 1370618 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 03:41:35.000000 | 23 | 22 | 2023-09-01 03:41:35+02:00 | -1 |
| 1370617 | 1370617 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 02:55:41.000000 | 26 | 22 | 2023-09-01 02:55:41+02:00 | -4 |
| 1367294 | 1367294 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 23:06:04.000000 | 17 | 22 | 2023-08-31 23:06:04+02:00 | 5 |
| 1367293 | 1367293 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:42:01.000000 | 25 | 18 | 2023-08-31 22:42:01+02:00 | -7 |
| 1367292 | 1367292 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:27:36.000000 | 18 | 17 | 2023-08-31 22:27:36+02:00 | -1 |
| 1367291 | 1367291 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:27:26.000000 | 23 | 22 | 2023-08-31 22:27:26+02:00 | -1 |
| 1367290 | 1367290 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:10:51.000000 | 23 | 20 | 2023-08-31 22:10:51+02:00 | -3 |
| 1367289 | 1367289 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:04:59.000000 | 28 | 16 | 2023-08-31 22:04:59+02:00 | -12 |
| 1367288 | 1367288 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:02:58.000000 | 20 | 23 | 2023-08-31 22:02:58+02:00 | 3 |
| 1367287 | 1367287 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:54:34.000000 | 37 | 31 | 2023-08-31 21:54:34+02:00 | -6 |
| 1367286 | 1367286 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:50:35.000000 | 12 | 20 | 2023-08-31 21:50:35+02:00 | 8 |
| 1367285 | 1367285 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:46:19.000000 | 17 | 18 | 2023-08-31 21:46:19+02:00 | 1 |
| 1367284 | 1367284 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:45:45.000000 | 17 | 24 | 2023-08-31 21:45:45+02:00 | 7 |
| 1367283 | 1367283 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:39:14.000000 | 17 | 17 | 2023-08-31 21:39:14+02:00 | 0 |
| 1367282 | 1367282 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:31:16.000000 | 24 | 22 | 2023-08-31 21:31:16+02:00 | -2 |
| 1367281 | 1367281 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:25:45.000000 | 17 | 16 | 2023-08-31 21:25:45+02:00 | -1 |
| 1367280 | 1367280 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:07:51.000000 | 17 | 12 | 2023-08-31 21:07:51+02:00 | -5 |
| 1367279 | 1367279 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:07:34.000000 | 19 | 17 | 2023-08-31 21:07:34+02:00 | -2 |
| 1367278 | 1367278 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:58:00.000000 | 19 | 11 | 2023-08-31 20:58:00+02:00 | -8 |
| 1367277 | 1367277 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:37:29.000000 | 33 | 29 | 2023-08-31 20:37:29+02:00 | -4 |
| 1367276 | 1367276 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:37:27.000000 | 37 | 29 | 2023-08-31 20:37:27+02:00 | -8 |
| 1367275 | 1367275 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:36:59.000000 | 24 | 29 | 2023-08-31 20:36:59+02:00 | 5 |
| 1367274 | 1367274 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:28:09.000000 | 26 | 25 | 2023-08-31 20:28:09+02:00 | -1 |
| 1367273 | 1367273 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:20:03.000000 | 26 | 19 | 2023-08-31 20:20:03+02:00 | -7 |
| 1367272 | 1367272 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:04:46.000000 | 32 | 25 | 2023-08-31 20:04:46+02:00 | -7 |
| 1367271 | 1367271 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:55:16.000000 | 28 | 24 | 2023-08-31 19:55:16+02:00 | -4 |
| 1367270 | 1367270 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:37:42.000000 | 14 | 14 | 2023-08-31 19:37:42+02:00 | 0 |
| 1367269 | 1367269 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:36:39.000000 | 10 | 17 | 2023-08-31 19:36:39+02:00 | 7 |
| 1367268 | 1367268 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:34:05.000000 | 32 | 35 | 2023-08-31 19:34:05+02:00 | 3 |
| 1367267 | 1367267 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:11:28.000000 | 20 | 20 | 2023-08-31 19:11:28+02:00 | 0 |
| 1367266 | 1367266 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:09:01.000000 | 24 | 28 | 2023-08-31 19:09:01+02:00 | 4 |
| 1367265 | 1367265 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 18:51:41.000000 | 23 | 18 | 2023-08-31 18:51:41+02:00 | -5 |
| 1367264 | 1367264 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 18:43:12.000000 | 11 | 10 | 2023-08-31 18:43:12+02:00 | -1 |
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");