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: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 8274385 | 8274385 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:46:13.000000 | 23 | 29 | 2023-09-01 08:46:13+02:00 | 6 |
| 8274384 | 8274384 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:43:07.000000 | 19 | 22 | 2023-09-01 08:43:07+02:00 | 3 |
| 8274383 | 8274383 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:35:57.000000 | 25 | 22 | 2023-09-01 08:35:57+02:00 | -3 |
| 8274382 | 8274382 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:29:01.000000 | 18 | 19 | 2023-09-01 08:29:01+02:00 | 1 |
| 8274381 | 8274381 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:28:02.000000 | 13 | 20 | 2023-09-01 08:28:02+02:00 | 7 |
| 8274380 | 8274380 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:27:11.000000 | 24 | 27 | 2023-09-01 08:27:11+02:00 | 3 |
| 8274379 | 8274379 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:24:23.000000 | 16 | 13 | 2023-09-01 08:24:23+02:00 | -3 |
| 8274378 | 8274378 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:24:14.000000 | 28 | 15 | 2023-09-01 08:24:14+02:00 | -13 |
| 8274377 | 8274377 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:15:06.000000 | 15 | 20 | 2023-09-01 08:15:06+02:00 | 5 |
| 8274376 | 8274376 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:14:55.000000 | 24 | 24 | 2023-09-01 08:14:55+02:00 | 0 |
| 8274375 | 8274375 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:56:14.000000 | 16 | 14 | 2023-09-01 07:56:14+02:00 | -2 |
| 8274374 | 8274374 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:49:32.000000 | 15 | 19 | 2023-09-01 07:49:32+02:00 | 4 |
| 8274373 | 8274373 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:39:46.000000 | 19 | 17 | 2023-09-01 07:39:46+02:00 | -2 |
| 8274372 | 8274372 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:30:59.000000 | 16 | 18 | 2023-09-01 07:30:59+02:00 | 2 |
| 8274371 | 8274371 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:30:48.000000 | 27 | 28 | 2023-09-01 07:30:48+02:00 | 1 |
| 8274370 | 8274370 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:30:24.000000 | 27 | 26 | 2023-09-01 07:30:24+02:00 | -1 |
| 8274369 | 8274369 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:29:04.000000 | 14 | 12 | 2023-09-01 07:29:04+02:00 | -2 |
| 8274368 | 8274368 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:26:41.000000 | 33 | 27 | 2023-09-01 07:26:41+02:00 | -6 |
| 8274367 | 8274367 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:18:06.000000 | 23 | 20 | 2023-09-01 07:18:06+02:00 | -3 |
| 8274366 | 8274366 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:11:31.000000 | 16 | 18 | 2023-09-01 07:11:31+02:00 | 2 |
| 8274365 | 8274365 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:06:06.000000 | 12 | 20 | 2023-09-01 07:06:06+02:00 | 8 |
| 8274364 | 8274364 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:00:28.000000 | 17 | 13 | 2023-09-01 07:00:28+02:00 | -4 |
| 8274363 | 8274363 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:45:12.000000 | 16 | 17 | 2023-09-01 06:45:12+02:00 | 1 |
| 8274362 | 8274362 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:38:13.000000 | 31 | 24 | 2023-09-01 06:38:13+02:00 | -7 |
| 8274361 | 8274361 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:31:37.000000 | 15 | 20 | 2023-09-01 06:31:37+02:00 | 5 |
| 8274360 | 8274360 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:30:03.000000 | 16 | 17 | 2023-09-01 06:30:03+02:00 | 1 |
| 8274359 | 8274359 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:27:23.000000 | 26 | 22 | 2023-09-01 06:27:23+02:00 | -4 |
| 8274358 | 8274358 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:27:17.000000 | 14 | 12 | 2023-09-01 06:27:17+02:00 | -2 |
| 8274357 | 8274357 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:26:56.000000 | 3 | 3 | 2023-09-01 06:26:56+02:00 | 0 |
| 8274356 | 8274356 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:26:40.000000 | 11 | 13 | 2023-09-01 06:26:40+02:00 | 2 |
| 8274355 | 8274355 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:25:45.000000 | 28 | 20 | 2023-09-01 06:25:45+02:00 | -8 |
| 8274354 | 8274354 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:22:48.000000 | 11 | 17 | 2023-09-01 06:22:48+02:00 | 6 |
| 8274353 | 8274353 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:17:37.000000 | 15 | 20 | 2023-09-01 06:17:37+02:00 | 5 |
| 8274352 | 8274352 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:17:36.000000 | 25 | 22 | 2023-09-01 06:17:36+02:00 | -3 |
| 8274351 | 8274351 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:17:13.000000 | 25 | 20 | 2023-09-01 06:17:13+02:00 | -5 |
| 8274350 | 8274350 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:13:36.000000 | 31 | 27 | 2023-09-01 06:13:36+02:00 | -4 |
| 8274349 | 8274349 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:12:13.000000 | 16 | 18 | 2023-09-01 06:12:13+02:00 | 2 |
| 8274348 | 8274348 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:12:00.000000 | 24 | 25 | 2023-09-01 06:12:00+02:00 | 1 |
| 8274347 | 8274347 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:06:33.000000 | 26 | 22 | 2023-09-01 06:06:33+02:00 | -4 |
| 8274346 | 8274346 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:45:00.000000 | 17 | 17 | 2023-09-01 05:45:00+02:00 | 0 |
| 8274345 | 8274345 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:43:58.000000 | 20 | 19 | 2023-09-01 05:43:58+02:00 | -1 |
| 8274344 | 8274344 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:39:44.000000 | 24 | 25 | 2023-09-01 05:39:44+02:00 | 1 |
| 8274343 | 8274343 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:36:40.000000 | 29 | 24 | 2023-09-01 05:36:40+02:00 | -5 |
| 8274342 | 8274342 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:35:14.000000 | 17 | 19 | 2023-09-01 05:35:14+02:00 | 2 |
| 8274341 | 8274341 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:31:47.000000 | 19 | 16 | 2023-09-01 05:31:47+02:00 | -3 |
| 8274340 | 8274340 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:28:57.000000 | 17 | 10 | 2023-09-01 05:28:57+02:00 | -7 |
| 8274339 | 8274339 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:28:38.000000 | 24 | 22 | 2023-09-01 05:28:38+02:00 | -2 |
| 8274338 | 8274338 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:26:04.000000 | 29 | 22 | 2023-09-01 05:26:04+02:00 | -7 |
| 8274337 | 8274337 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:25:43.000000 | 16 | 15 | 2023-09-01 05:25:43+02:00 | -1 |
| 8274336 | 8274336 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:24:50.000000 | 14 | 14 | 2023-09-01 05:24:50+02:00 | 0 |
| 8274335 | 8274335 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:22:31.000000 | 20 | 19 | 2023-09-01 05:22:31+02:00 | -1 |
| 8274334 | 8274334 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:18:05.000000 | 26 | 27 | 2023-09-01 05:18:05+02:00 | 1 |
| 8274333 | 8274333 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:15:21.000000 | 30 | 26 | 2023-09-01 05:15:21+02:00 | -4 |
| 8274332 | 8274332 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:13:24.000000 | 20 | 17 | 2023-09-01 05:13:24+02:00 | -3 |
| 8274331 | 8274331 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:08:00.000000 | 18 | 22 | 2023-09-01 05:08:00+02:00 | 4 |
| 8274330 | 8274330 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:07:06.000000 | 31 | 27 | 2023-09-01 05:07:06+02:00 | -4 |
| 8274329 | 8274329 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:03:55.000000 | 26 | 20 | 2023-09-01 05:03:55+02:00 | -6 |
| 8274328 | 8274328 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:03:33.000000 | 26 | 25 | 2023-09-01 05:03:33+02:00 | -1 |
| 8274327 | 8274327 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:00:42.000000 | 17 | 17 | 2023-09-01 05:00:42+02:00 | 0 |
| 8274326 | 8274326 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:00:24.000000 | 23 | 20 | 2023-09-01 05:00:24+02:00 | -3 |
| 8274325 | 8274325 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:57:28.000000 | 24 | 17 | 2023-09-01 04:57:28+02:00 | -7 |
| 8274324 | 8274324 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:45:21.000000 | 14 | 17 | 2023-09-01 04:45:21+02:00 | 3 |
| 8274323 | 8274323 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:41:01.000000 | 11 | 13 | 2023-09-01 04:41:01+02:00 | 2 |
| 8274322 | 8274322 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:07:28.000000 | 28 | 23 | 2023-09-01 04:07:28+02:00 | -5 |
| 8274321 | 8274321 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:02:46.000000 | 26 | 24 | 2023-09-01 04:02:46+02:00 | -2 |
| 8274320 | 8274320 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 03:57:28.000000 | 25 | 15 | 2023-09-01 03:57:28+02:00 | -10 |
| 8274319 | 8274319 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 03:51:23.000000 | 12 | 18 | 2023-09-01 03:51:23+02:00 | 6 |
| 8274318 | 8274318 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 03:41:35.000000 | 23 | 22 | 2023-09-01 03:41:35+02:00 | -1 |
| 8274317 | 8274317 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 02:55:41.000000 | 26 | 22 | 2023-09-01 02:55:41+02:00 | -4 |
| 8274316 | 8274316 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 23:06:04.000000 | 17 | 22 | 2023-08-31 23:06:04+02:00 | 5 |
| 8274315 | 8274315 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:42:01.000000 | 25 | 18 | 2023-08-31 22:42:01+02:00 | -7 |
| 8274314 | 8274314 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:27:36.000000 | 18 | 17 | 2023-08-31 22:27:36+02:00 | -1 |
| 8274313 | 8274313 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:27:26.000000 | 23 | 22 | 2023-08-31 22:27:26+02:00 | -1 |
| 8274312 | 8274312 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:10:51.000000 | 23 | 20 | 2023-08-31 22:10:51+02:00 | -3 |
| 8274311 | 8274311 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:04:59.000000 | 28 | 16 | 2023-08-31 22:04:59+02:00 | -12 |
| 8274310 | 8274310 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:02:58.000000 | 20 | 23 | 2023-08-31 22:02:58+02:00 | 3 |
| 8274309 | 8274309 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:54:34.000000 | 37 | 31 | 2023-08-31 21:54:34+02:00 | -6 |
| 8274308 | 8274308 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:50:35.000000 | 12 | 20 | 2023-08-31 21:50:35+02:00 | 8 |
| 8274307 | 8274307 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:46:19.000000 | 17 | 18 | 2023-08-31 21:46:19+02:00 | 1 |
| 8274306 | 8274306 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:45:45.000000 | 17 | 24 | 2023-08-31 21:45:45+02:00 | 7 |
| 8274305 | 8274305 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:39:14.000000 | 17 | 17 | 2023-08-31 21:39:14+02:00 | 0 |
| 8274304 | 8274304 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:31:16.000000 | 24 | 22 | 2023-08-31 21:31:16+02:00 | -2 |
| 8274303 | 8274303 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:25:45.000000 | 17 | 16 | 2023-08-31 21:25:45+02:00 | -1 |
| 8274302 | 8274302 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:07:51.000000 | 17 | 12 | 2023-08-31 21:07:51+02:00 | -5 |
| 8274301 | 8274301 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:07:34.000000 | 19 | 17 | 2023-08-31 21:07:34+02:00 | -2 |
| 8274300 | 8274300 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:58:00.000000 | 19 | 11 | 2023-08-31 20:58:00+02:00 | -8 |
| 8274299 | 8274299 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:37:29.000000 | 33 | 29 | 2023-08-31 20:37:29+02:00 | -4 |
| 8274298 | 8274298 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:37:27.000000 | 37 | 29 | 2023-08-31 20:37:27+02:00 | -8 |
| 8274297 | 8274297 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:36:59.000000 | 24 | 29 | 2023-08-31 20:36:59+02:00 | 5 |
| 8274296 | 8274296 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:28:09.000000 | 26 | 25 | 2023-08-31 20:28:09+02:00 | -1 |
| 8274295 | 8274295 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:20:03.000000 | 26 | 19 | 2023-08-31 20:20:03+02:00 | -7 |
| 8274294 | 8274294 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:04:46.000000 | 32 | 25 | 2023-08-31 20:04:46+02:00 | -7 |
| 8274293 | 8274293 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:55:16.000000 | 28 | 24 | 2023-08-31 19:55:16+02:00 | -4 |
| 8274292 | 8274292 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:37:42.000000 | 14 | 14 | 2023-08-31 19:37:42+02:00 | 0 |
| 8274291 | 8274291 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:36:39.000000 | 10 | 17 | 2023-08-31 19:36:39+02:00 | 7 |
| 8274290 | 8274290 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:34:05.000000 | 32 | 35 | 2023-08-31 19:34:05+02:00 | 3 |
| 8274289 | 8274289 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:11:28.000000 | 20 | 20 | 2023-08-31 19:11:28+02:00 | 0 |
| 8274288 | 8274288 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:09:01.000000 | 24 | 28 | 2023-08-31 19:09:01+02:00 | 4 |
| 8274287 | 8274287 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 18:51:41.000000 | 23 | 18 | 2023-08-31 18:51:41+02:00 | -5 |
| 8274286 | 8274286 | 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");