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 = "1-109" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 6351653 | 6351653 | Rittergasse 1-109 | 109 | 1 | Nach Ende | 2023-07-11 | 13:33:01.000000 | 30 | 17 | 2023-07-11 13:33:01+02:00 | -13 |
| 6351652 | 6351652 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:32:07.000000 | 2 | 5 | 2023-07-11 13:32:07+02:00 | 3 |
| 6351651 | 6351651 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:28:01.000000 | 15 | 15 | 2023-07-11 13:28:01+02:00 | 0 |
| 6351650 | 6351650 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:27:13.000000 | 17 | 15 | 2023-07-11 13:27:13+02:00 | -2 |
| 6351649 | 6351649 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:25:44.000000 | 2 | 6 | 2023-07-11 13:25:44+02:00 | 4 |
| 6351648 | 6351648 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:24:39.000000 | 19 | 14 | 2023-07-11 13:24:39+02:00 | -5 |
| 6351647 | 6351647 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:22:27.000000 | 2 | 7 | 2023-07-11 13:22:27+02:00 | 5 |
| 6351646 | 6351646 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:20:58.000000 | 24 | 17 | 2023-07-11 13:20:58+02:00 | -7 |
| 6351645 | 6351645 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:20:44.000000 | 19 | 12 | 2023-07-11 13:20:44+02:00 | -7 |
| 6351644 | 6351644 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:17:39.000000 | 2 | 6 | 2023-07-11 13:17:39+02:00 | 4 |
| 6351643 | 6351643 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:13:42.000000 | 24 | 22 | 2023-07-11 13:13:42+02:00 | -2 |
| 6351642 | 6351642 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:13:13.000000 | 2 | 3 | 2023-07-11 13:13:13+02:00 | 1 |
| 6351641 | 6351641 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:12:43.000000 | 28 | 23 | 2023-07-11 13:12:43+02:00 | -5 |
| 6351640 | 6351640 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:09:32.000000 | 15 | 22 | 2023-07-11 13:09:32+02:00 | 7 |
| 6351639 | 6351639 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:08:27.000000 | 25 | 23 | 2023-07-11 13:08:27+02:00 | -2 |
| 6351638 | 6351638 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:07:27.000000 | 25 | 12 | 2023-07-11 13:07:27+02:00 | -13 |
| 6351637 | 6351637 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:04:30.000000 | 18 | 12 | 2023-07-11 13:04:30+02:00 | -6 |
| 6351636 | 6351636 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:02:51.000000 | 20 | 11 | 2023-07-11 13:02:51+02:00 | -9 |
| 6351635 | 6351635 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:54:19.000000 | 4 | 7 | 2023-07-11 12:54:19+02:00 | 3 |
| 6351634 | 6351634 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:47:48.000000 | 19 | 18 | 2023-07-11 12:47:48+02:00 | -1 |
| 6351633 | 6351633 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:47:10.000000 | 17 | 17 | 2023-07-11 12:47:10+02:00 | 0 |
| 6351632 | 6351632 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:50.000000 | 19 | 17 | 2023-07-11 12:46:50+02:00 | -2 |
| 6351631 | 6351631 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:42.000000 | 24 | 19 | 2023-07-11 12:46:42+02:00 | -5 |
| 6351630 | 6351630 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:19.000000 | 15 | 18 | 2023-07-11 12:46:19+02:00 | 3 |
| 6351629 | 6351629 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:14.000000 | 20 | 22 | 2023-07-11 12:46:14+02:00 | 2 |
| 6351628 | 6351628 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:45:48.000000 | 25 | 15 | 2023-07-11 12:45:48+02:00 | -10 |
| 6351627 | 6351627 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:44:39.000000 | 5 | 3 | 2023-07-11 12:44:39+02:00 | -2 |
| 6351626 | 6351626 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:43:05.000000 | 10 | 3 | 2023-07-11 12:43:05+02:00 | -7 |
| 6351625 | 6351625 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:42:44.000000 | 23 | 8 | 2023-07-11 12:42:44+02:00 | -15 |
| 6351624 | 6351624 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:42:43.000000 | 15 | 11 | 2023-07-11 12:42:43+02:00 | -4 |
| 6351623 | 6351623 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:42:25.000000 | 19 | 12 | 2023-07-11 12:42:25+02:00 | -7 |
| 6351622 | 6351622 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:30:16.000000 | 3 | 3 | 2023-07-11 12:30:16+02:00 | 0 |
| 6351621 | 6351621 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:29:13.000000 | 20 | 18 | 2023-07-11 12:29:13+02:00 | -2 |
| 6351620 | 6351620 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:28:53.000000 | 2 | 7 | 2023-07-11 12:28:53+02:00 | 5 |
| 6351619 | 6351619 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:24:17.000000 | 14 | 12 | 2023-07-11 12:24:17+02:00 | -2 |
| 6351618 | 6351618 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:15:59.000000 | 3 | 4 | 2023-07-11 12:15:59+02:00 | 1 |
| 6351617 | 6351617 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:13:47.000000 | 16 | 13 | 2023-07-11 12:13:47+02:00 | -3 |
| 6351616 | 6351616 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:11:57.000000 | 2 | 5 | 2023-07-11 12:11:57+02:00 | 3 |
| 6351615 | 6351615 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:10:45.000000 | 25 | 16 | 2023-07-11 12:10:45+02:00 | -9 |
| 6351614 | 6351614 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:09:33.000000 | 3 | 6 | 2023-07-11 12:09:33+02:00 | 3 |
| 6351613 | 6351613 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:04:44.000000 | 3 | 8 | 2023-07-11 12:04:44+02:00 | 5 |
| 6351612 | 6351612 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:00:38.000000 | 2 | 4 | 2023-07-11 12:00:38+02:00 | 2 |
| 6351611 | 6351611 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:59:40.000000 | 17 | 16 | 2023-07-11 11:59:40+02:00 | -1 |
| 6351610 | 6351610 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:57:20.000000 | 4 | 5 | 2023-07-11 11:57:20+02:00 | 1 |
| 6351609 | 6351609 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:55:39.000000 | 16 | 4 | 2023-07-11 11:55:39+02:00 | -12 |
| 6351608 | 6351608 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:54:13.000000 | 2 | 11 | 2023-07-11 11:54:13+02:00 | 9 |
| 6351607 | 6351607 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:54:00.000000 | 19 | 17 | 2023-07-11 11:54:00+02:00 | -2 |
| 6351606 | 6351606 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:53:34.000000 | 15 | 14 | 2023-07-11 11:53:34+02:00 | -1 |
| 6351605 | 6351605 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:51:33.000000 | 4 | 5 | 2023-07-11 11:51:33+02:00 | 1 |
| 6351604 | 6351604 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:51:03.000000 | 2 | 3 | 2023-07-11 11:51:03+02:00 | 1 |
| 6351603 | 6351603 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:47:46.000000 | 2 | 6 | 2023-07-11 11:47:46+02:00 | 4 |
| 6351602 | 6351602 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:35:53.000000 | 23 | 13 | 2023-07-11 11:35:53+02:00 | -10 |
| 6351601 | 6351601 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:35:16.000000 | 3 | 8 | 2023-07-11 11:35:16+02:00 | 5 |
| 6351600 | 6351600 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:32:24.000000 | 15 | 12 | 2023-07-11 11:32:24+02:00 | -3 |
| 6351599 | 6351599 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:29:39.000000 | 18 | 18 | 2023-07-11 11:29:39+02:00 | 0 |
| 6351598 | 6351598 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:29:35.000000 | 3 | 4 | 2023-07-11 11:29:35+02:00 | 1 |
| 6351597 | 6351597 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:24:26.000000 | 14 | 12 | 2023-07-11 11:24:26+02:00 | -2 |
| 6351596 | 6351596 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:21:08.000000 | 4 | 6 | 2023-07-11 11:21:08+02:00 | 2 |
| 6351595 | 6351595 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:17:24.000000 | 2 | 9 | 2023-07-11 11:17:24+02:00 | 7 |
| 6351594 | 6351594 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:15:46.000000 | 11 | 17 | 2023-07-11 11:15:46+02:00 | 6 |
| 6351593 | 6351593 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:15:32.000000 | 20 | 9 | 2023-07-11 11:15:32+02:00 | -11 |
| 6351592 | 6351592 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:04:03.000000 | 17 | 15 | 2023-07-11 11:04:03+02:00 | -2 |
| 6351591 | 6351591 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:03:51.000000 | 3 | 15 | 2023-07-11 11:03:51+02:00 | 12 |
| 6351590 | 6351590 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:01:44.000000 | 27 | 13 | 2023-07-11 11:01:44+02:00 | -14 |
| 6351589 | 6351589 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:01:14.000000 | 3 | 3 | 2023-07-11 11:01:14+02:00 | 0 |
| 6351588 | 6351588 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:56:37.000000 | 6 | 4 | 2023-07-11 10:56:37+02:00 | -2 |
| 6351587 | 6351587 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:55:50.000000 | 2 | 10 | 2023-07-11 10:55:50+02:00 | 8 |
| 6351586 | 6351586 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:47:39.000000 | 9 | 9 | 2023-07-11 10:47:39+02:00 | 0 |
| 6351585 | 6351585 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:45:29.000000 | 4 | 6 | 2023-07-11 10:45:29+02:00 | 2 |
| 6351584 | 6351584 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:43:45.000000 | 3 | 3 | 2023-07-11 10:43:45+02:00 | 0 |
| 6351583 | 6351583 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:40:38.000000 | 2 | 5 | 2023-07-11 10:40:38+02:00 | 3 |
| 6351582 | 6351582 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:34:05.000000 | 19 | 12 | 2023-07-11 10:34:05+02:00 | -7 |
| 6351580 | 6351580 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:31:37.000000 | 25 | 22 | 2023-07-11 10:31:37+02:00 | -3 |
| 6351581 | 6351581 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:31:37.000000 | 13 | 16 | 2023-07-11 10:31:37+02:00 | 3 |
| 6351579 | 6351579 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:30:03.000000 | 3 | 5 | 2023-07-11 10:30:03+02:00 | 2 |
| 6351578 | 6351578 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:29:44.000000 | 19 | 13 | 2023-07-11 10:29:44+02:00 | -6 |
| 6351577 | 6351577 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:27:17.000000 | 8 | 3 | 2023-07-11 10:27:17+02:00 | -5 |
| 6351576 | 6351576 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:26:17.000000 | 7 | 3 | 2023-07-11 10:26:17+02:00 | -4 |
| 6351575 | 6351575 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:25:42.000000 | 17 | 15 | 2023-07-11 10:25:42+02:00 | -2 |
| 6351574 | 6351574 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:25:16.000000 | 23 | 23 | 2023-07-11 10:25:16+02:00 | 0 |
| 6351573 | 6351573 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:21:00.000000 | 15 | 13 | 2023-07-11 10:21:00+02:00 | -2 |
| 6351572 | 6351572 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:19:01.000000 | 25 | 20 | 2023-07-11 10:19:01+02:00 | -5 |
| 6351571 | 6351571 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:17:52.000000 | 27 | 19 | 2023-07-11 10:17:52+02:00 | -8 |
| 6351570 | 6351570 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:17:38.000000 | 3 | 4 | 2023-07-11 10:17:38+02:00 | 1 |
| 6351569 | 6351569 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:16:10.000000 | 9 | 7 | 2023-07-11 10:16:10+02:00 | -2 |
| 6351568 | 6351568 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:15:56.000000 | 7 | 5 | 2023-07-11 10:15:56+02:00 | -2 |
| 6351567 | 6351567 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:15:28.000000 | 14 | 4 | 2023-07-11 10:15:28+02:00 | -10 |
| 6351566 | 6351566 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:12:06.000000 | 18 | 14 | 2023-07-11 10:12:06+02:00 | -4 |
| 6351565 | 6351565 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:04:35.000000 | 12 | 17 | 2023-07-11 10:04:35+02:00 | 5 |
| 6351564 | 6351564 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:56:43.000000 | 3 | 8 | 2023-07-11 09:56:43+02:00 | 5 |
| 6351563 | 6351563 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:55:36.000000 | 23 | 7 | 2023-07-11 09:55:36+02:00 | -16 |
| 6351562 | 6351562 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:54:35.000000 | 30 | 31 | 2023-07-11 09:54:35+02:00 | 1 |
| 6351561 | 6351561 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:54:24.000000 | 27 | 22 | 2023-07-11 09:54:24+02:00 | -5 |
| 6351560 | 6351560 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:54:04.000000 | 5 | 5 | 2023-07-11 09:54:04+02:00 | 0 |
| 6351559 | 6351559 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:52:25.000000 | 12 | 22 | 2023-07-11 09:52:25+02:00 | 10 |
| 6351558 | 6351558 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:48:56.000000 | 16 | 19 | 2023-07-11 09:48:56+02:00 | 3 |
| 6351557 | 6351557 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:48:26.000000 | 25 | 22 | 2023-07-11 09:48:26+02:00 | -3 |
| 6351556 | 6351556 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:47:39.000000 | 14 | 9 | 2023-07-11 09:47:39+02:00 | -5 |
| 6351555 | 6351555 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:42:19.000000 | 19 | 15 | 2023-07-11 09:42:19+02:00 | -4 |
| 6351554 | 6351554 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:39:59.000000 | 16 | 6 | 2023-07-11 09:39:59+02:00 | -10 |
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");