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: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 689287 | 689287 | 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 |
| 689286 | 689286 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:32:07.000000 | 2 | 5 | 2023-07-11 13:32:07+02:00 | 3 |
| 689285 | 689285 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:28:01.000000 | 15 | 15 | 2023-07-11 13:28:01+02:00 | 0 |
| 689284 | 689284 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:27:13.000000 | 17 | 15 | 2023-07-11 13:27:13+02:00 | -2 |
| 689283 | 689283 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:25:44.000000 | 2 | 6 | 2023-07-11 13:25:44+02:00 | 4 |
| 689282 | 689282 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:24:39.000000 | 19 | 14 | 2023-07-11 13:24:39+02:00 | -5 |
| 689281 | 689281 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:22:27.000000 | 2 | 7 | 2023-07-11 13:22:27+02:00 | 5 |
| 689280 | 689280 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:20:58.000000 | 24 | 17 | 2023-07-11 13:20:58+02:00 | -7 |
| 689279 | 689279 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:20:44.000000 | 19 | 12 | 2023-07-11 13:20:44+02:00 | -7 |
| 689278 | 689278 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:17:39.000000 | 2 | 6 | 2023-07-11 13:17:39+02:00 | 4 |
| 689277 | 689277 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:13:42.000000 | 24 | 22 | 2023-07-11 13:13:42+02:00 | -2 |
| 689276 | 689276 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:13:13.000000 | 2 | 3 | 2023-07-11 13:13:13+02:00 | 1 |
| 689275 | 689275 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:12:43.000000 | 28 | 23 | 2023-07-11 13:12:43+02:00 | -5 |
| 689274 | 689274 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:09:32.000000 | 15 | 22 | 2023-07-11 13:09:32+02:00 | 7 |
| 689273 | 689273 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:08:27.000000 | 25 | 23 | 2023-07-11 13:08:27+02:00 | -2 |
| 689272 | 689272 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:07:27.000000 | 25 | 12 | 2023-07-11 13:07:27+02:00 | -13 |
| 689271 | 689271 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:04:30.000000 | 18 | 12 | 2023-07-11 13:04:30+02:00 | -6 |
| 689270 | 689270 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 13:02:51.000000 | 20 | 11 | 2023-07-11 13:02:51+02:00 | -9 |
| 689269 | 689269 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:54:19.000000 | 4 | 7 | 2023-07-11 12:54:19+02:00 | 3 |
| 689268 | 689268 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:47:48.000000 | 19 | 18 | 2023-07-11 12:47:48+02:00 | -1 |
| 689267 | 689267 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:47:10.000000 | 17 | 17 | 2023-07-11 12:47:10+02:00 | 0 |
| 689266 | 689266 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:50.000000 | 19 | 17 | 2023-07-11 12:46:50+02:00 | -2 |
| 689265 | 689265 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:42.000000 | 24 | 19 | 2023-07-11 12:46:42+02:00 | -5 |
| 689264 | 689264 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:19.000000 | 15 | 18 | 2023-07-11 12:46:19+02:00 | 3 |
| 689263 | 689263 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:46:14.000000 | 20 | 22 | 2023-07-11 12:46:14+02:00 | 2 |
| 689262 | 689262 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:45:48.000000 | 25 | 15 | 2023-07-11 12:45:48+02:00 | -10 |
| 689261 | 689261 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:44:39.000000 | 5 | 3 | 2023-07-11 12:44:39+02:00 | -2 |
| 689260 | 689260 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:43:05.000000 | 10 | 3 | 2023-07-11 12:43:05+02:00 | -7 |
| 689259 | 689259 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:42:44.000000 | 23 | 8 | 2023-07-11 12:42:44+02:00 | -15 |
| 689258 | 689258 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:42:43.000000 | 15 | 11 | 2023-07-11 12:42:43+02:00 | -4 |
| 689257 | 689257 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:42:25.000000 | 19 | 12 | 2023-07-11 12:42:25+02:00 | -7 |
| 689256 | 689256 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:30:16.000000 | 3 | 3 | 2023-07-11 12:30:16+02:00 | 0 |
| 689255 | 689255 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:29:13.000000 | 20 | 18 | 2023-07-11 12:29:13+02:00 | -2 |
| 689254 | 689254 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:28:53.000000 | 2 | 7 | 2023-07-11 12:28:53+02:00 | 5 |
| 689253 | 689253 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:24:17.000000 | 14 | 12 | 2023-07-11 12:24:17+02:00 | -2 |
| 689252 | 689252 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:15:59.000000 | 3 | 4 | 2023-07-11 12:15:59+02:00 | 1 |
| 689251 | 689251 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:13:47.000000 | 16 | 13 | 2023-07-11 12:13:47+02:00 | -3 |
| 689250 | 689250 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:11:57.000000 | 2 | 5 | 2023-07-11 12:11:57+02:00 | 3 |
| 689249 | 689249 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:10:45.000000 | 25 | 16 | 2023-07-11 12:10:45+02:00 | -9 |
| 689248 | 689248 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:09:33.000000 | 3 | 6 | 2023-07-11 12:09:33+02:00 | 3 |
| 689247 | 689247 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:04:44.000000 | 3 | 8 | 2023-07-11 12:04:44+02:00 | 5 |
| 689246 | 689246 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 12:00:38.000000 | 2 | 4 | 2023-07-11 12:00:38+02:00 | 2 |
| 689245 | 689245 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:59:40.000000 | 17 | 16 | 2023-07-11 11:59:40+02:00 | -1 |
| 689244 | 689244 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:57:20.000000 | 4 | 5 | 2023-07-11 11:57:20+02:00 | 1 |
| 689243 | 689243 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:55:39.000000 | 16 | 4 | 2023-07-11 11:55:39+02:00 | -12 |
| 689242 | 689242 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:54:13.000000 | 2 | 11 | 2023-07-11 11:54:13+02:00 | 9 |
| 689241 | 689241 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:54:00.000000 | 19 | 17 | 2023-07-11 11:54:00+02:00 | -2 |
| 689240 | 689240 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:53:34.000000 | 15 | 14 | 2023-07-11 11:53:34+02:00 | -1 |
| 689239 | 689239 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:51:33.000000 | 4 | 5 | 2023-07-11 11:51:33+02:00 | 1 |
| 689238 | 689238 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:51:03.000000 | 2 | 3 | 2023-07-11 11:51:03+02:00 | 1 |
| 689237 | 689237 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:47:46.000000 | 2 | 6 | 2023-07-11 11:47:46+02:00 | 4 |
| 689236 | 689236 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:35:53.000000 | 23 | 13 | 2023-07-11 11:35:53+02:00 | -10 |
| 689235 | 689235 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:35:16.000000 | 3 | 8 | 2023-07-11 11:35:16+02:00 | 5 |
| 689234 | 689234 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:32:24.000000 | 15 | 12 | 2023-07-11 11:32:24+02:00 | -3 |
| 689233 | 689233 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:29:39.000000 | 18 | 18 | 2023-07-11 11:29:39+02:00 | 0 |
| 689232 | 689232 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:29:35.000000 | 3 | 4 | 2023-07-11 11:29:35+02:00 | 1 |
| 689231 | 689231 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:24:26.000000 | 14 | 12 | 2023-07-11 11:24:26+02:00 | -2 |
| 689230 | 689230 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:21:08.000000 | 4 | 6 | 2023-07-11 11:21:08+02:00 | 2 |
| 689229 | 689229 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:17:24.000000 | 2 | 9 | 2023-07-11 11:17:24+02:00 | 7 |
| 689228 | 689228 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:15:46.000000 | 11 | 17 | 2023-07-11 11:15:46+02:00 | 6 |
| 689227 | 689227 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:15:32.000000 | 20 | 9 | 2023-07-11 11:15:32+02:00 | -11 |
| 689226 | 689226 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:04:03.000000 | 17 | 15 | 2023-07-11 11:04:03+02:00 | -2 |
| 689225 | 689225 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:03:51.000000 | 3 | 15 | 2023-07-11 11:03:51+02:00 | 12 |
| 689224 | 689224 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:01:44.000000 | 27 | 13 | 2023-07-11 11:01:44+02:00 | -14 |
| 689223 | 689223 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 11:01:14.000000 | 3 | 3 | 2023-07-11 11:01:14+02:00 | 0 |
| 689222 | 689222 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:56:37.000000 | 6 | 4 | 2023-07-11 10:56:37+02:00 | -2 |
| 689221 | 689221 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:55:50.000000 | 2 | 10 | 2023-07-11 10:55:50+02:00 | 8 |
| 689220 | 689220 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:47:39.000000 | 9 | 9 | 2023-07-11 10:47:39+02:00 | 0 |
| 689219 | 689219 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:45:29.000000 | 4 | 6 | 2023-07-11 10:45:29+02:00 | 2 |
| 689218 | 689218 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:43:45.000000 | 3 | 3 | 2023-07-11 10:43:45+02:00 | 0 |
| 689217 | 689217 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:40:38.000000 | 2 | 5 | 2023-07-11 10:40:38+02:00 | 3 |
| 689216 | 689216 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:34:05.000000 | 19 | 12 | 2023-07-11 10:34:05+02:00 | -7 |
| 689214 | 689214 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:31:37.000000 | 25 | 22 | 2023-07-11 10:31:37+02:00 | -3 |
| 689215 | 689215 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:31:37.000000 | 13 | 16 | 2023-07-11 10:31:37+02:00 | 3 |
| 689213 | 689213 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:30:03.000000 | 3 | 5 | 2023-07-11 10:30:03+02:00 | 2 |
| 689212 | 689212 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:29:44.000000 | 19 | 13 | 2023-07-11 10:29:44+02:00 | -6 |
| 689211 | 689211 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:27:17.000000 | 8 | 3 | 2023-07-11 10:27:17+02:00 | -5 |
| 689210 | 689210 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:26:17.000000 | 7 | 3 | 2023-07-11 10:26:17+02:00 | -4 |
| 689209 | 689209 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:25:42.000000 | 17 | 15 | 2023-07-11 10:25:42+02:00 | -2 |
| 689208 | 689208 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:25:16.000000 | 23 | 23 | 2023-07-11 10:25:16+02:00 | 0 |
| 689207 | 689207 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:21:00.000000 | 15 | 13 | 2023-07-11 10:21:00+02:00 | -2 |
| 689206 | 689206 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:19:01.000000 | 25 | 20 | 2023-07-11 10:19:01+02:00 | -5 |
| 689205 | 689205 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:17:52.000000 | 27 | 19 | 2023-07-11 10:17:52+02:00 | -8 |
| 689204 | 689204 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:17:38.000000 | 3 | 4 | 2023-07-11 10:17:38+02:00 | 1 |
| 689203 | 689203 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:16:10.000000 | 9 | 7 | 2023-07-11 10:16:10+02:00 | -2 |
| 689202 | 689202 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:15:56.000000 | 7 | 5 | 2023-07-11 10:15:56+02:00 | -2 |
| 689201 | 689201 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:15:28.000000 | 14 | 4 | 2023-07-11 10:15:28+02:00 | -10 |
| 689200 | 689200 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:12:06.000000 | 18 | 14 | 2023-07-11 10:12:06+02:00 | -4 |
| 689199 | 689199 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 10:04:35.000000 | 12 | 17 | 2023-07-11 10:04:35+02:00 | 5 |
| 689198 | 689198 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:56:43.000000 | 3 | 8 | 2023-07-11 09:56:43+02:00 | 5 |
| 689197 | 689197 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:55:36.000000 | 23 | 7 | 2023-07-11 09:55:36+02:00 | -16 |
| 689196 | 689196 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:54:35.000000 | 30 | 31 | 2023-07-11 09:54:35+02:00 | 1 |
| 689195 | 689195 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:54:24.000000 | 27 | 22 | 2023-07-11 09:54:24+02:00 | -5 |
| 689194 | 689194 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:54:04.000000 | 5 | 5 | 2023-07-11 09:54:04+02:00 | 0 |
| 689193 | 689193 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:52:25.000000 | 12 | 22 | 2023-07-11 09:52:25+02:00 | 10 |
| 689192 | 689192 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:48:56.000000 | 16 | 19 | 2023-07-11 09:48:56+02:00 | 3 |
| 689191 | 689191 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:48:26.000000 | 25 | 22 | 2023-07-11 09:48:26+02:00 | -3 |
| 689190 | 689190 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:47:39.000000 | 14 | 9 | 2023-07-11 09:47:39+02:00 | -5 |
| 689189 | 689189 | Rittergasse 1-109 | 109 | 1 | Nachmessung | 2023-07-11 | 09:42:19.000000 | 19 | 15 | 2023-07-11 09:42:19+02:00 | -4 |
| 689188 | 689188 | 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");