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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4605385 | 4605385 | 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 |
| 4605384 | 4605384 | 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 |
| 4605383 | 4605383 | 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 |
| 4605382 | 4605382 | 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 |
| 4605381 | 4605381 | 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 |
| 4605380 | 4605380 | 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 |
| 4605379 | 4605379 | 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 |
| 4605378 | 4605378 | 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 |
| 4605377 | 4605377 | 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 |
| 4605376 | 4605376 | 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 |
| 4605375 | 4605375 | 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 |
| 4605374 | 4605374 | 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 |
| 4605373 | 4605373 | 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 |
| 4605372 | 4605372 | 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 |
| 4605371 | 4605371 | 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 |
| 4605370 | 4605370 | 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 |
| 4605369 | 4605369 | 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 |
| 4605368 | 4605368 | 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 |
| 4605367 | 4605367 | 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 |
| 4605366 | 4605366 | 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 |
| 4605365 | 4605365 | 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 |
| 4605364 | 4605364 | 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 |
| 4605363 | 4605363 | 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 |
| 4605362 | 4605362 | 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 |
| 4605361 | 4605361 | 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 |
| 4605360 | 4605360 | 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 |
| 4605359 | 4605359 | 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 |
| 4605358 | 4605358 | 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 |
| 4605357 | 4605357 | 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 |
| 4605356 | 4605356 | 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 |
| 4605355 | 4605355 | 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 |
| 4605354 | 4605354 | 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 |
| 4605353 | 4605353 | 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 |
| 4605352 | 4605352 | 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 |
| 4605351 | 4605351 | 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 |
| 4605350 | 4605350 | 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 |
| 4605349 | 4605349 | 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 |
| 4605348 | 4605348 | 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 |
| 4605347 | 4605347 | 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 |
| 4605346 | 4605346 | 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 |
| 4605345 | 4605345 | 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 |
| 4605344 | 4605344 | 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 |
| 4605343 | 4605343 | 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 |
| 4605342 | 4605342 | 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 |
| 4605341 | 4605341 | 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 |
| 4605340 | 4605340 | 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 |
| 4605339 | 4605339 | 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 |
| 4605338 | 4605338 | 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 |
| 4605337 | 4605337 | 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 |
| 4605336 | 4605336 | 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 |
| 4605335 | 4605335 | 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 |
| 4605334 | 4605334 | 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 |
| 4605333 | 4605333 | 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 |
| 4605332 | 4605332 | 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 |
| 4605331 | 4605331 | 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 |
| 4605330 | 4605330 | 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 |
| 4605329 | 4605329 | 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 |
| 4605328 | 4605328 | 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 |
| 4605327 | 4605327 | 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 |
| 4605326 | 4605326 | 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 |
| 4605325 | 4605325 | 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 |
| 4605324 | 4605324 | 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 |
| 4605323 | 4605323 | 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 |
| 4605322 | 4605322 | 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 |
| 4605320 | 4605320 | 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 |
| 4605321 | 4605321 | 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 |
| 4605319 | 4605319 | 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 |
| 4605318 | 4605318 | 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 |
| 4605317 | 4605317 | 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 |
| 4605316 | 4605316 | 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 |
| 4605315 | 4605315 | 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 |
| 4605314 | 4605314 | 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 |
| 4605313 | 4605313 | 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 |
| 4605312 | 4605312 | 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 |
| 4605311 | 4605311 | 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 |
| 4605310 | 4605310 | 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 |
| 4605309 | 4605309 | 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 |
| 4605308 | 4605308 | 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 |
| 4605307 | 4605307 | 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 |
| 4605306 | 4605306 | 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 |
| 4605305 | 4605305 | 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 |
| 4605304 | 4605304 | 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 |
| 4605303 | 4605303 | 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 |
| 4605302 | 4605302 | 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 |
| 4605301 | 4605301 | 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 |
| 4605300 | 4605300 | 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 |
| 4605299 | 4605299 | 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 |
| 4605298 | 4605298 | 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 |
| 4605297 | 4605297 | 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 |
| 4605296 | 4605296 | 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 |
| 4605295 | 4605295 | 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 |
| 4605294 | 4605294 | 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 |
| 4605293 | 4605293 | 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 |
| 4605292 | 4605292 | 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 |
| 4605291 | 4605291 | 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 |
| 4605290 | 4605290 | 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 |
| 4605289 | 4605289 | 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 |
| 4605288 | 4605288 | 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 |
| 4605287 | 4605287 | 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 |
| 4605286 | 4605286 | 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");