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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 3918578 | 3918578 | 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 |
| 3918577 | 3918577 | 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 |
| 3918576 | 3918576 | 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 |
| 3918575 | 3918575 | 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 |
| 3918574 | 3918574 | 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 |
| 3918573 | 3918573 | 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 |
| 3918572 | 3918572 | 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 |
| 3918571 | 3918571 | 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 |
| 3918570 | 3918570 | 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 |
| 3918569 | 3918569 | 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 |
| 3918568 | 3918568 | 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 |
| 3918567 | 3918567 | 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 |
| 3918566 | 3918566 | 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 |
| 3918565 | 3918565 | 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 |
| 3918564 | 3918564 | 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 |
| 3918563 | 3918563 | 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 |
| 3918562 | 3918562 | 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 |
| 3918561 | 3918561 | 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 |
| 3918560 | 3918560 | 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 |
| 3918559 | 3918559 | 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 |
| 3918558 | 3918558 | 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 |
| 3918557 | 3918557 | 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 |
| 3918556 | 3918556 | 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 |
| 3918555 | 3918555 | 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 |
| 3918554 | 3918554 | 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 |
| 3918553 | 3918553 | 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 |
| 3918552 | 3918552 | 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 |
| 3918551 | 3918551 | 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 |
| 3918550 | 3918550 | 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 |
| 3918549 | 3918549 | 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 |
| 3918548 | 3918548 | 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 |
| 3918547 | 3918547 | 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 |
| 3918546 | 3918546 | 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 |
| 3918545 | 3918545 | 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 |
| 3918544 | 3918544 | 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 |
| 3918543 | 3918543 | 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 |
| 3918542 | 3918542 | 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 |
| 3918541 | 3918541 | 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 |
| 3918540 | 3918540 | 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 |
| 3918539 | 3918539 | 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 |
| 3918538 | 3918538 | 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 |
| 3918537 | 3918537 | 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 |
| 3918536 | 3918536 | 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 |
| 3918535 | 3918535 | 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 |
| 3918534 | 3918534 | 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 |
| 3918533 | 3918533 | 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 |
| 3918532 | 3918532 | 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 |
| 3918531 | 3918531 | 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 |
| 3918530 | 3918530 | 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 |
| 3918529 | 3918529 | 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 |
| 3918528 | 3918528 | 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 |
| 3918527 | 3918527 | 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 |
| 3918526 | 3918526 | 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 |
| 3918525 | 3918525 | 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 |
| 3918524 | 3918524 | 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 |
| 3918523 | 3918523 | 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 |
| 3918522 | 3918522 | 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 |
| 3918521 | 3918521 | 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 |
| 3918520 | 3918520 | 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 |
| 3918519 | 3918519 | 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 |
| 3918518 | 3918518 | 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 |
| 3918517 | 3918517 | 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 |
| 3918516 | 3918516 | 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 |
| 3918515 | 3918515 | 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 |
| 3918513 | 3918513 | 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 |
| 3918514 | 3918514 | 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 |
| 3918512 | 3918512 | 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 |
| 3918511 | 3918511 | 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 |
| 3918510 | 3918510 | 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 |
| 3918509 | 3918509 | 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 |
| 3918508 | 3918508 | 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 |
| 3918507 | 3918507 | 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 |
| 3918506 | 3918506 | 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 |
| 3918505 | 3918505 | 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 |
| 3918504 | 3918504 | 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 |
| 3918503 | 3918503 | 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 |
| 3918502 | 3918502 | 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 |
| 3918501 | 3918501 | 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 |
| 3918500 | 3918500 | 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 |
| 3918499 | 3918499 | 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 |
| 3918498 | 3918498 | 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 |
| 3918497 | 3918497 | 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 |
| 3918496 | 3918496 | 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 |
| 3918495 | 3918495 | 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 |
| 3918494 | 3918494 | 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 |
| 3918493 | 3918493 | 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 |
| 3918492 | 3918492 | 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 |
| 3918491 | 3918491 | 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 |
| 3918490 | 3918490 | 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 |
| 3918489 | 3918489 | 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 |
| 3918488 | 3918488 | 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 |
| 3918487 | 3918487 | 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 |
| 3918486 | 3918486 | 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 |
| 3918485 | 3918485 | 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 |
| 3918484 | 3918484 | 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 |
| 3918483 | 3918483 | 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 |
| 3918482 | 3918482 | 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 |
| 3918481 | 3918481 | 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 |
| 3918480 | 3918480 | 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 |
| 3918479 | 3918479 | 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");