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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 7038460 | 7038460 | 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 |
| 7038459 | 7038459 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:32:07.000000 | 2 | 5 | 2023-07-11 13:32:07+02:00 | 3 |
| 7038458 | 7038458 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:28:01.000000 | 15 | 15 | 2023-07-11 13:28:01+02:00 | 0 |
| 7038457 | 7038457 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:27:13.000000 | 17 | 15 | 2023-07-11 13:27:13+02:00 | -2 |
| 7038456 | 7038456 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:25:44.000000 | 2 | 6 | 2023-07-11 13:25:44+02:00 | 4 |
| 7038455 | 7038455 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:24:39.000000 | 19 | 14 | 2023-07-11 13:24:39+02:00 | -5 |
| 7038454 | 7038454 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:22:27.000000 | 2 | 7 | 2023-07-11 13:22:27+02:00 | 5 |
| 7038453 | 7038453 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:20:58.000000 | 24 | 17 | 2023-07-11 13:20:58+02:00 | -7 |
| 7038452 | 7038452 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:20:44.000000 | 19 | 12 | 2023-07-11 13:20:44+02:00 | -7 |
| 7038451 | 7038451 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:17:39.000000 | 2 | 6 | 2023-07-11 13:17:39+02:00 | 4 |
| 7038450 | 7038450 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:13:42.000000 | 24 | 22 | 2023-07-11 13:13:42+02:00 | -2 |
| 7038449 | 7038449 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:13:13.000000 | 2 | 3 | 2023-07-11 13:13:13+02:00 | 1 |
| 7038448 | 7038448 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:12:43.000000 | 28 | 23 | 2023-07-11 13:12:43+02:00 | -5 |
| 7038447 | 7038447 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:09:32.000000 | 15 | 22 | 2023-07-11 13:09:32+02:00 | 7 |
| 7038446 | 7038446 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:08:27.000000 | 25 | 23 | 2023-07-11 13:08:27+02:00 | -2 |
| 7038445 | 7038445 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:07:27.000000 | 25 | 12 | 2023-07-11 13:07:27+02:00 | -13 |
| 7038444 | 7038444 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:04:30.000000 | 18 | 12 | 2023-07-11 13:04:30+02:00 | -6 |
| 7038443 | 7038443 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:02:51.000000 | 20 | 11 | 2023-07-11 13:02:51+02:00 | -9 |
| 7038442 | 7038442 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:54:19.000000 | 4 | 7 | 2023-07-11 12:54:19+02:00 | 3 |
| 7038441 | 7038441 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:47:48.000000 | 19 | 18 | 2023-07-11 12:47:48+02:00 | -1 |
| 7038440 | 7038440 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:47:10.000000 | 17 | 17 | 2023-07-11 12:47:10+02:00 | 0 |
| 7038439 | 7038439 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:50.000000 | 19 | 17 | 2023-07-11 12:46:50+02:00 | -2 |
| 7038438 | 7038438 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:42.000000 | 24 | 19 | 2023-07-11 12:46:42+02:00 | -5 |
| 7038437 | 7038437 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:19.000000 | 15 | 18 | 2023-07-11 12:46:19+02:00 | 3 |
| 7038436 | 7038436 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:14.000000 | 20 | 22 | 2023-07-11 12:46:14+02:00 | 2 |
| 7038435 | 7038435 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:45:48.000000 | 25 | 15 | 2023-07-11 12:45:48+02:00 | -10 |
| 7038434 | 7038434 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:44:39.000000 | 5 | 3 | 2023-07-11 12:44:39+02:00 | -2 |
| 7038433 | 7038433 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:43:05.000000 | 10 | 3 | 2023-07-11 12:43:05+02:00 | -7 |
| 7038432 | 7038432 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:42:44.000000 | 23 | 8 | 2023-07-11 12:42:44+02:00 | -15 |
| 7038431 | 7038431 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:42:43.000000 | 15 | 11 | 2023-07-11 12:42:43+02:00 | -4 |
| 7038430 | 7038430 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:42:25.000000 | 19 | 12 | 2023-07-11 12:42:25+02:00 | -7 |
| 7038429 | 7038429 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:30:16.000000 | 3 | 3 | 2023-07-11 12:30:16+02:00 | 0 |
| 7038428 | 7038428 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:29:13.000000 | 20 | 18 | 2023-07-11 12:29:13+02:00 | -2 |
| 7038427 | 7038427 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:28:53.000000 | 2 | 7 | 2023-07-11 12:28:53+02:00 | 5 |
| 7038426 | 7038426 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:24:17.000000 | 14 | 12 | 2023-07-11 12:24:17+02:00 | -2 |
| 7038425 | 7038425 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:15:59.000000 | 3 | 4 | 2023-07-11 12:15:59+02:00 | 1 |
| 7038424 | 7038424 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:13:47.000000 | 16 | 13 | 2023-07-11 12:13:47+02:00 | -3 |
| 7038423 | 7038423 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:11:57.000000 | 2 | 5 | 2023-07-11 12:11:57+02:00 | 3 |
| 7038422 | 7038422 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:10:45.000000 | 25 | 16 | 2023-07-11 12:10:45+02:00 | -9 |
| 7038421 | 7038421 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:09:33.000000 | 3 | 6 | 2023-07-11 12:09:33+02:00 | 3 |
| 7038420 | 7038420 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:04:44.000000 | 3 | 8 | 2023-07-11 12:04:44+02:00 | 5 |
| 7038419 | 7038419 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:00:38.000000 | 2 | 4 | 2023-07-11 12:00:38+02:00 | 2 |
| 7038418 | 7038418 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:59:40.000000 | 17 | 16 | 2023-07-11 11:59:40+02:00 | -1 |
| 7038417 | 7038417 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:57:20.000000 | 4 | 5 | 2023-07-11 11:57:20+02:00 | 1 |
| 7038416 | 7038416 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:55:39.000000 | 16 | 4 | 2023-07-11 11:55:39+02:00 | -12 |
| 7038415 | 7038415 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:54:13.000000 | 2 | 11 | 2023-07-11 11:54:13+02:00 | 9 |
| 7038414 | 7038414 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:54:00.000000 | 19 | 17 | 2023-07-11 11:54:00+02:00 | -2 |
| 7038413 | 7038413 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:53:34.000000 | 15 | 14 | 2023-07-11 11:53:34+02:00 | -1 |
| 7038412 | 7038412 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:51:33.000000 | 4 | 5 | 2023-07-11 11:51:33+02:00 | 1 |
| 7038411 | 7038411 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:51:03.000000 | 2 | 3 | 2023-07-11 11:51:03+02:00 | 1 |
| 7038410 | 7038410 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:47:46.000000 | 2 | 6 | 2023-07-11 11:47:46+02:00 | 4 |
| 7038409 | 7038409 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:35:53.000000 | 23 | 13 | 2023-07-11 11:35:53+02:00 | -10 |
| 7038408 | 7038408 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:35:16.000000 | 3 | 8 | 2023-07-11 11:35:16+02:00 | 5 |
| 7038407 | 7038407 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:32:24.000000 | 15 | 12 | 2023-07-11 11:32:24+02:00 | -3 |
| 7038406 | 7038406 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:29:39.000000 | 18 | 18 | 2023-07-11 11:29:39+02:00 | 0 |
| 7038405 | 7038405 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:29:35.000000 | 3 | 4 | 2023-07-11 11:29:35+02:00 | 1 |
| 7038404 | 7038404 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:24:26.000000 | 14 | 12 | 2023-07-11 11:24:26+02:00 | -2 |
| 7038403 | 7038403 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:21:08.000000 | 4 | 6 | 2023-07-11 11:21:08+02:00 | 2 |
| 7038402 | 7038402 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:17:24.000000 | 2 | 9 | 2023-07-11 11:17:24+02:00 | 7 |
| 7038401 | 7038401 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:15:46.000000 | 11 | 17 | 2023-07-11 11:15:46+02:00 | 6 |
| 7038400 | 7038400 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:15:32.000000 | 20 | 9 | 2023-07-11 11:15:32+02:00 | -11 |
| 7038399 | 7038399 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:04:03.000000 | 17 | 15 | 2023-07-11 11:04:03+02:00 | -2 |
| 7038398 | 7038398 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:03:51.000000 | 3 | 15 | 2023-07-11 11:03:51+02:00 | 12 |
| 7038397 | 7038397 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:01:44.000000 | 27 | 13 | 2023-07-11 11:01:44+02:00 | -14 |
| 7038396 | 7038396 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:01:14.000000 | 3 | 3 | 2023-07-11 11:01:14+02:00 | 0 |
| 7038395 | 7038395 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:56:37.000000 | 6 | 4 | 2023-07-11 10:56:37+02:00 | -2 |
| 7038394 | 7038394 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:55:50.000000 | 2 | 10 | 2023-07-11 10:55:50+02:00 | 8 |
| 7038393 | 7038393 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:47:39.000000 | 9 | 9 | 2023-07-11 10:47:39+02:00 | 0 |
| 7038392 | 7038392 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:45:29.000000 | 4 | 6 | 2023-07-11 10:45:29+02:00 | 2 |
| 7038391 | 7038391 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:43:45.000000 | 3 | 3 | 2023-07-11 10:43:45+02:00 | 0 |
| 7038390 | 7038390 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:40:38.000000 | 2 | 5 | 2023-07-11 10:40:38+02:00 | 3 |
| 7038389 | 7038389 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:34:05.000000 | 19 | 12 | 2023-07-11 10:34:05+02:00 | -7 |
| 7038387 | 7038387 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:31:37.000000 | 25 | 22 | 2023-07-11 10:31:37+02:00 | -3 |
| 7038388 | 7038388 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:31:37.000000 | 13 | 16 | 2023-07-11 10:31:37+02:00 | 3 |
| 7038386 | 7038386 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:30:03.000000 | 3 | 5 | 2023-07-11 10:30:03+02:00 | 2 |
| 7038385 | 7038385 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:29:44.000000 | 19 | 13 | 2023-07-11 10:29:44+02:00 | -6 |
| 7038384 | 7038384 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:27:17.000000 | 8 | 3 | 2023-07-11 10:27:17+02:00 | -5 |
| 7038383 | 7038383 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:26:17.000000 | 7 | 3 | 2023-07-11 10:26:17+02:00 | -4 |
| 7038382 | 7038382 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:25:42.000000 | 17 | 15 | 2023-07-11 10:25:42+02:00 | -2 |
| 7038381 | 7038381 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:25:16.000000 | 23 | 23 | 2023-07-11 10:25:16+02:00 | 0 |
| 7038380 | 7038380 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:21:00.000000 | 15 | 13 | 2023-07-11 10:21:00+02:00 | -2 |
| 7038379 | 7038379 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:19:01.000000 | 25 | 20 | 2023-07-11 10:19:01+02:00 | -5 |
| 7038378 | 7038378 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:17:52.000000 | 27 | 19 | 2023-07-11 10:17:52+02:00 | -8 |
| 7038377 | 7038377 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:17:38.000000 | 3 | 4 | 2023-07-11 10:17:38+02:00 | 1 |
| 7038376 | 7038376 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:16:10.000000 | 9 | 7 | 2023-07-11 10:16:10+02:00 | -2 |
| 7038375 | 7038375 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:15:56.000000 | 7 | 5 | 2023-07-11 10:15:56+02:00 | -2 |
| 7038374 | 7038374 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:15:28.000000 | 14 | 4 | 2023-07-11 10:15:28+02:00 | -10 |
| 7038373 | 7038373 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:12:06.000000 | 18 | 14 | 2023-07-11 10:12:06+02:00 | -4 |
| 7038372 | 7038372 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:04:35.000000 | 12 | 17 | 2023-07-11 10:04:35+02:00 | 5 |
| 7038371 | 7038371 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:56:43.000000 | 3 | 8 | 2023-07-11 09:56:43+02:00 | 5 |
| 7038370 | 7038370 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:55:36.000000 | 23 | 7 | 2023-07-11 09:55:36+02:00 | -16 |
| 7038369 | 7038369 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:54:35.000000 | 30 | 31 | 2023-07-11 09:54:35+02:00 | 1 |
| 7038368 | 7038368 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:54:24.000000 | 27 | 22 | 2023-07-11 09:54:24+02:00 | -5 |
| 7038367 | 7038367 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:54:04.000000 | 5 | 5 | 2023-07-11 09:54:04+02:00 | 0 |
| 7038366 | 7038366 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:52:25.000000 | 12 | 22 | 2023-07-11 09:52:25+02:00 | 10 |
| 7038365 | 7038365 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:48:56.000000 | 16 | 19 | 2023-07-11 09:48:56+02:00 | 3 |
| 7038364 | 7038364 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:48:26.000000 | 25 | 22 | 2023-07-11 09:48:26+02:00 | -3 |
| 7038363 | 7038363 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:47:39.000000 | 14 | 9 | 2023-07-11 09:47:39+02:00 | -5 |
| 7038362 | 7038362 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:42:19.000000 | 19 | 15 | 2023-07-11 09:42:19+02:00 | -4 |
| 7038361 | 7038361 | 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");