View_Einsatzplan_Einzelmessungen (view)
>10,000 rows count all
This data as json, geojson, copyable, CSV (advanced)
Suggested facets: Start_Vormessung (date), Start_Betrieb (date), Start_Nachmessung (date), Ende (date), Messung_Datum (date), Messung_Timestamp (date)
| id_standort | Zyklus | Strassenname | Geschwindigkeit | Ort_Abkuerzung | Start_Vormessung | Start_Betrieb | Start_Nachmessung | Ende | Messung_Jahr | Ort | geometry | Phase | Messung_Datum | Messung_Zeit | V_Einfahrt | V_Ausfahrt | Messung_Timestamp | V_Delta |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:04:52.000000 | 31 | 29 | 2023-07-21 00:04:52+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:05:01.000000 | 36 | 39 | 2023-07-21 00:05:01+02:00 | 3 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:07:11.000000 | 36 | 27 | 2023-07-21 00:07:11+02:00 | -9 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:10:02.000000 | 37 | 37 | 2023-07-21 00:10:02+02:00 | 0 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:19:01.000000 | 39 | 34 | 2023-07-21 00:19:01+02:00 | -5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:21:47.000000 | 43 | 35 | 2023-07-21 00:21:47+02:00 | -8 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:24:45.000000 | 39 | 26 | 2023-07-21 00:24:45+02:00 | -13 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:26:55.000000 | 29 | 26 | 2023-07-21 00:26:55+02:00 | -3 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:29:13.000000 | 47 | 43 | 2023-07-21 00:29:13+02:00 | -4 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:29:24.000000 | 40 | 29 | 2023-07-21 00:29:24+02:00 | -11 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:31:41.000000 | 26 | 25 | 2023-07-21 00:31:41+02:00 | -1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:31:46.000000 | 34 | 32 | 2023-07-21 00:31:46+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:36:28.000000 | 33 | 32 | 2023-07-21 00:36:28+02:00 | -1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:56:37.000000 | 31 | 32 | 2023-07-21 00:56:37+02:00 | 1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 00:58:52.000000 | 26 | 25 | 2023-07-21 00:58:52+02:00 | -1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 01:05:56.000000 | 32 | 27 | 2023-07-21 01:05:56+02:00 | -5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 01:06:40.000000 | 36 | 34 | 2023-07-21 01:06:40+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 01:11:26.000000 | 45 | 40 | 2023-07-21 01:11:26+02:00 | -5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 01:17:36.000000 | 33 | 25 | 2023-07-21 01:17:36+02:00 | -8 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 01:33:05.000000 | 36 | 32 | 2023-07-21 01:33:05+02:00 | -4 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 01:43:05.000000 | 39 | 33 | 2023-07-21 01:43:05+02:00 | -6 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 01:55:34.000000 | 43 | 39 | 2023-07-21 01:55:34+02:00 | -4 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 01:59:17.000000 | 46 | 35 | 2023-07-21 01:59:17+02:00 | -11 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 01:59:48.000000 | 35 | 23 | 2023-07-21 01:59:48+02:00 | -12 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:04:02.000000 | 32 | 29 | 2023-07-21 02:04:02+02:00 | -3 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:10:17.000000 | 33 | 29 | 2023-07-21 02:10:17+02:00 | -4 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:15:06.000000 | 35 | 32 | 2023-07-21 02:15:06+02:00 | -3 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:16:11.000000 | 35 | 36 | 2023-07-21 02:16:11+02:00 | 1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:19:39.000000 | 41 | 33 | 2023-07-21 02:19:39+02:00 | -8 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:22:24.000000 | 34 | 29 | 2023-07-21 02:22:24+02:00 | -5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:26:17.000000 | 43 | 38 | 2023-07-21 02:26:17+02:00 | -5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:29:21.000000 | 36 | 34 | 2023-07-21 02:29:21+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:35:05.000000 | 37 | 32 | 2023-07-21 02:35:05+02:00 | -5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:39:24.000000 | 23 | 18 | 2023-07-21 02:39:24+02:00 | -5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:47:51.000000 | 24 | 29 | 2023-07-21 02:47:51+02:00 | 5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 02:57:06.000000 | 35 | 38 | 2023-07-21 02:57:06+02:00 | 3 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:00:58.000000 | 40 | 38 | 2023-07-21 03:00:58+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:09:32.000000 | 30 | 28 | 2023-07-21 03:09:32+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:12:56.000000 | 33 | 26 | 2023-07-21 03:12:56+02:00 | -7 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:13:08.000000 | 39 | 38 | 2023-07-21 03:13:08+02:00 | -1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:19:22.000000 | 33 | 35 | 2023-07-21 03:19:22+02:00 | 2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:19:52.000000 | 39 | 34 | 2023-07-21 03:19:52+02:00 | -5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:25:57.000000 | 39 | 28 | 2023-07-21 03:25:57+02:00 | -11 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:32:12.000000 | 35 | 35 | 2023-07-21 03:32:12+02:00 | 0 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:32:20.000000 | 36 | 38 | 2023-07-21 03:32:20+02:00 | 2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:33:35.000000 | 51 | 50 | 2023-07-21 03:33:35+02:00 | -1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:35:51.000000 | 35 | 25 | 2023-07-21 03:35:51+02:00 | -10 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:43:02.000000 | 38 | 37 | 2023-07-21 03:43:02+02:00 | -1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 03:58:24.000000 | 23 | 28 | 2023-07-21 03:58:24+02:00 | 5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:04:32.000000 | 20 | 31 | 2023-07-21 04:04:32+02:00 | 11 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:04:43.000000 | 46 | 40 | 2023-07-21 04:04:43+02:00 | -6 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:12:12.000000 | 29 | 32 | 2023-07-21 04:12:12+02:00 | 3 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:12:41.000000 | 33 | 38 | 2023-07-21 04:12:41+02:00 | 5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:14:54.000000 | 43 | 37 | 2023-07-21 04:14:54+02:00 | -6 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:15:08.000000 | 40 | 33 | 2023-07-21 04:15:08+02:00 | -7 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:24:11.000000 | 30 | 25 | 2023-07-21 04:24:11+02:00 | -5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:26:41.000000 | 35 | 31 | 2023-07-21 04:26:41+02:00 | -4 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:28:00.000000 | 29 | 29 | 2023-07-21 04:28:00+02:00 | 0 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:28:22.000000 | 41 | 39 | 2023-07-21 04:28:22+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:33:05.000000 | 39 | 35 | 2023-07-21 04:33:05+02:00 | -4 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:42:22.000000 | 46 | 38 | 2023-07-21 04:42:22+02:00 | -8 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:47:25.000000 | 34 | 33 | 2023-07-21 04:47:25+02:00 | -1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:47:34.000000 | 34 | 38 | 2023-07-21 04:47:34+02:00 | 4 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:48:11.000000 | 39 | 31 | 2023-07-21 04:48:11+02:00 | -8 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:49:07.000000 | 34 | 33 | 2023-07-21 04:49:07+02:00 | -1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:49:16.000000 | 40 | 38 | 2023-07-21 04:49:16+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:51:26.000000 | 38 | 36 | 2023-07-21 04:51:26+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:51:32.000000 | 9 | 26 | 2023-07-21 04:51:32+02:00 | 17 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:51:49.000000 | 35 | 35 | 2023-07-21 04:51:49+02:00 | 0 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:52:44.000000 | 39 | 30 | 2023-07-21 04:52:44+02:00 | -9 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:54:15.000000 | 39 | 28 | 2023-07-21 04:54:15+02:00 | -11 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:56:51.000000 | 47 | 41 | 2023-07-21 04:56:51+02:00 | -6 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 04:57:48.000000 | 36 | 30 | 2023-07-21 04:57:48+02:00 | -6 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:00:30.000000 | 33 | 29 | 2023-07-21 05:00:30+02:00 | -4 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:00:58.000000 | 34 | 28 | 2023-07-21 05:00:58+02:00 | -6 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:02:06.000000 | 33 | 38 | 2023-07-21 05:02:06+02:00 | 5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:03:06.000000 | 35 | 41 | 2023-07-21 05:03:06+02:00 | 6 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:05:23.000000 | 35 | 33 | 2023-07-21 05:05:23+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:06:13.000000 | 17 | 29 | 2023-07-21 05:06:13+02:00 | 12 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:06:27.000000 | 40 | 38 | 2023-07-21 05:06:27+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:07:59.000000 | 35 | 33 | 2023-07-21 05:07:59+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:10:40.000000 | 37 | 34 | 2023-07-21 05:10:40+02:00 | -3 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:12:24.000000 | 41 | 38 | 2023-07-21 05:12:24+02:00 | -3 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:13:07.000000 | 36 | 32 | 2023-07-21 05:13:07+02:00 | -4 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:13:16.000000 | 29 | 32 | 2023-07-21 05:13:16+02:00 | 3 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:14:22.000000 | 32 | 32 | 2023-07-21 05:14:22+02:00 | 0 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:16:35.000000 | 31 | 26 | 2023-07-21 05:16:35+02:00 | -5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:16:43.000000 | 34 | 34 | 2023-07-21 05:16:43+02:00 | 0 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:20:22.000000 | 23 | 19 | 2023-07-21 05:20:22+02:00 | -4 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:20:50.000000 | 27 | 25 | 2023-07-21 05:20:50+02:00 | -2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:21:36.000000 | 38 | 37 | 2023-07-21 05:21:36+02:00 | -1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:22:02.000000 | 47 | 34 | 2023-07-21 05:22:02+02:00 | -13 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:22:49.000000 | 41 | 43 | 2023-07-21 05:22:49+02:00 | 2 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:23:44.000000 | 40 | 28 | 2023-07-21 05:23:44+02:00 | -12 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:26:16.000000 | 31 | 30 | 2023-07-21 05:26:16+02:00 | -1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:26:34.000000 | 32 | 33 | 2023-07-21 05:26:34+02:00 | 1 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:27:28.000000 | 39 | 34 | 2023-07-21 05:27:28+02:00 | -5 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:28:14.000000 | 41 | 37 | 2023-07-21 05:28:14+02:00 | -4 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:28:32.000000 | 18 | 29 | 2023-07-21 05:28:32+02:00 | 11 |
| 18.0 | 2.0 | Wettsteinbrücke | 50.0 | BS | 2023-07-14 10:15:00+02:00 | 2023-08-04 09:42:00+02:00 | 2023-11-03 08:32:00+01:00 | 2023-12-04 08:35:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} | Vormessung | 2023-07-21 | 05:28:46.000000 | 30 | 29 | 2023-07-21 05:28:46+02:00 | -1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW View_Einsatzplan_Einzelmessungen AS
SELECT
e.id_standort,
e.Zyklus,
e.Strassenname,
e.Geschwindigkeit,
e.Ort_Abkuerzung,
e.Start_Vormessung,
e.Start_Betrieb,
e.Start_Nachmessung,
e.Ende,
e.Messung_Jahr,
e.Ort,
e.geometry,
em.Phase,
em.Messung_Datum,
em.Messung_Zeit,
em.V_Einfahrt,
em.V_Ausfahrt,
em.Messung_Timestamp,
em.V_Delta
FROM Einsatzplan e
JOIN Einzelmessungen em ON e.id_standort = em.id_standort AND e.Zyklus = em.Zyklus;