View_Einsatzplan_Einzelmessungen (view)
>10,000 rows count all
This data as json, copyable, geojson, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:39:24.000000 | 30 | 27 | 2024-10-18 09:39:24+02:00 | -3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:39:41.000000 | 15 | 17 | 2024-10-18 09:39:41+02:00 | 2 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:41:50.000000 | 29 | 22 | 2024-10-18 09:41:50+02:00 | -7 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:43:53.000000 | 23 | 24 | 2024-10-18 09:43:53+02:00 | 1 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:44:08.000000 | 29 | 26 | 2024-10-18 09:44:08+02:00 | -3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:44:28.000000 | 23 | 26 | 2024-10-18 09:44:28+02:00 | 3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:46:02.000000 | 12 | 23 | 2024-10-18 09:46:02+02:00 | 11 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:46:15.000000 | 24 | 22 | 2024-10-18 09:46:15+02:00 | -2 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:46:16.000000 | 5 | 5 | 2024-10-18 09:46:16+02:00 | 0 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:47:50.000000 | 24 | 24 | 2024-10-18 09:47:50+02:00 | 0 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:48:02.000000 | 25 | 24 | 2024-10-18 09:48:02+02:00 | -1 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:49:22.000000 | 25 | 30 | 2024-10-18 09:49:22+02:00 | 5 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:49:32.000000 | 31 | 25 | 2024-10-18 09:49:32+02:00 | -6 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:49:52.000000 | 24 | 20 | 2024-10-18 09:49:52+02:00 | -4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:50:01.000000 | 14 | 20 | 2024-10-18 09:50:01+02:00 | 6 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:50:17.000000 | 20 | 13 | 2024-10-18 09:50:17+02:00 | -7 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:53:11.000000 | 19 | 23 | 2024-10-18 09:53:11+02:00 | 4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:55:09.000000 | 33 | 32 | 2024-10-18 09:55:09+02:00 | -1 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:55:11.000000 | 36 | 35 | 2024-10-18 09:55:11+02:00 | -1 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:55:25.000000 | 25 | 29 | 2024-10-18 09:55:25+02:00 | 4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:55:38.000000 | 20 | 8 | 2024-10-18 09:55:38+02:00 | -12 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:56:03.000000 | 23 | 23 | 2024-10-18 09:56:03+02:00 | 0 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:56:09.000000 | 23 | 19 | 2024-10-18 09:56:09+02:00 | -4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:56:50.000000 | 27 | 27 | 2024-10-18 09:56:50+02:00 | 0 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:58:28.000000 | 25 | 29 | 2024-10-18 09:58:28+02:00 | 4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:58:38.000000 | 30 | 22 | 2024-10-18 09:58:38+02:00 | -8 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 09:58:45.000000 | 23 | 20 | 2024-10-18 09:58:45+02:00 | -3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:00:04.000000 | 28 | 25 | 2024-10-18 10:00:04+02:00 | -3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:00:15.000000 | 25 | 24 | 2024-10-18 10:00:15+02:00 | -1 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:00:21.000000 | 35 | 13 | 2024-10-18 10:00:21+02:00 | -22 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:01:34.000000 | 9 | 27 | 2024-10-18 10:01:34+02:00 | 18 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:01:38.000000 | 32 | 18 | 2024-10-18 10:01:38+02:00 | -14 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:01:57.000000 | 19 | 35 | 2024-10-18 10:01:57+02:00 | 16 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:02:03.000000 | 36 | 39 | 2024-10-18 10:02:03+02:00 | 3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:02:31.000000 | 25 | 25 | 2024-10-18 10:02:31+02:00 | 0 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:02:51.000000 | 35 | 15 | 2024-10-18 10:02:51+02:00 | -20 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:03:17.000000 | 20 | 33 | 2024-10-18 10:03:17+02:00 | 13 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:06:25.000000 | 48 | 37 | 2024-10-18 10:06:25+02:00 | -11 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:06:30.000000 | 27 | 33 | 2024-10-18 10:06:30+02:00 | 6 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:06:46.000000 | 27 | 23 | 2024-10-18 10:06:46+02:00 | -4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:07:08.000000 | 16 | 29 | 2024-10-18 10:07:08+02:00 | 13 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:08:37.000000 | 27 | 32 | 2024-10-18 10:08:37+02:00 | 5 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:08:48.000000 | 17 | 26 | 2024-10-18 10:08:48+02:00 | 9 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:09:01.000000 | 8 | 18 | 2024-10-18 10:09:01+02:00 | 10 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:09:17.000000 | 18 | 23 | 2024-10-18 10:09:17+02:00 | 5 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:09:23.000000 | 34 | 17 | 2024-10-18 10:09:23+02:00 | -17 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:09:53.000000 | 35 | 31 | 2024-10-18 10:09:53+02:00 | -4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:09:57.000000 | 24 | 27 | 2024-10-18 10:09:57+02:00 | 3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:10:52.000000 | 29 | 28 | 2024-10-18 10:10:52+02:00 | -1 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:10:55.000000 | 53 | 46 | 2024-10-18 10:10:55+02:00 | -7 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:10:57.000000 | 46 | 34 | 2024-10-18 10:10:57+02:00 | -12 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:11:05.000000 | 39 | 43 | 2024-10-18 10:11:05+02:00 | 4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:11:05.000000 | 38 | 37 | 2024-10-18 10:11:05+02:00 | -1 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:11:35.000000 | 29 | 26 | 2024-10-18 10:11:35+02:00 | -3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:12:46.000000 | 16 | 29 | 2024-10-18 10:12:46+02:00 | 13 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:14:17.000000 | 35 | 34 | 2024-10-18 10:14:17+02:00 | -1 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:14:19.000000 | 27 | 34 | 2024-10-18 10:14:19+02:00 | 7 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:14:27.000000 | 35 | 27 | 2024-10-18 10:14:27+02:00 | -8 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:14:36.000000 | 24 | 26 | 2024-10-18 10:14:36+02:00 | 2 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:14:47.000000 | 29 | 24 | 2024-10-18 10:14:47+02:00 | -5 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:16:01.000000 | 23 | 24 | 2024-10-18 10:16:01+02:00 | 1 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:16:46.000000 | 10 | 20 | 2024-10-18 10:16:46+02:00 | 10 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:17:07.000000 | 20 | 22 | 2024-10-18 10:17:07+02:00 | 2 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:17:31.000000 | 13 | 19 | 2024-10-18 10:17:31+02:00 | 6 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:18:06.000000 | 13 | 22 | 2024-10-18 10:18:06+02:00 | 9 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:20:48.000000 | 36 | 36 | 2024-10-18 10:20:48+02:00 | 0 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:20:56.000000 | 37 | 34 | 2024-10-18 10:20:56+02:00 | -3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:21:13.000000 | 31 | 28 | 2024-10-18 10:21:13+02:00 | -3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:21:18.000000 | 34 | 30 | 2024-10-18 10:21:18+02:00 | -4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:21:27.000000 | 25 | 28 | 2024-10-18 10:21:27+02:00 | 3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:21:40.000000 | 19 | 23 | 2024-10-18 10:21:40+02:00 | 4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:21:53.000000 | 25 | 29 | 2024-10-18 10:21:53+02:00 | 4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:22:06.000000 | 30 | 36 | 2024-10-18 10:22:06+02:00 | 6 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:22:23.000000 | 29 | 27 | 2024-10-18 10:22:23+02:00 | -2 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:22:33.000000 | 28 | 34 | 2024-10-18 10:22:33+02:00 | 6 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:22:45.000000 | 17 | 26 | 2024-10-18 10:22:45+02:00 | 9 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:23:53.000000 | 30 | 30 | 2024-10-18 10:23:53+02:00 | 0 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:25:12.000000 | 33 | 27 | 2024-10-18 10:25:12+02:00 | -6 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:28:24.000000 | 30 | 34 | 2024-10-18 10:28:24+02:00 | 4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:28:26.000000 | 26 | 32 | 2024-10-18 10:28:26+02:00 | 6 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:30:21.000000 | 28 | 26 | 2024-10-18 10:30:21+02:00 | -2 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:31:27.000000 | 12 | 25 | 2024-10-18 10:31:27+02:00 | 13 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:32:00.000000 | 25 | 31 | 2024-10-18 10:32:00+02:00 | 6 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:32:06.000000 | 27 | 24 | 2024-10-18 10:32:06+02:00 | -3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:32:54.000000 | 40 | 35 | 2024-10-18 10:32:54+02:00 | -5 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:34:19.000000 | 25 | 34 | 2024-10-18 10:34:19+02:00 | 9 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:35:18.000000 | 23 | 12 | 2024-10-18 10:35:18+02:00 | -11 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:36:28.000000 | 30 | 26 | 2024-10-18 10:36:28+02:00 | -4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:36:59.000000 | 31 | 29 | 2024-10-18 10:36:59+02:00 | -2 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:37:06.000000 | 26 | 29 | 2024-10-18 10:37:06+02:00 | 3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:38:17.000000 | 29 | 32 | 2024-10-18 10:38:17+02:00 | 3 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:39:06.000000 | 30 | 30 | 2024-10-18 10:39:06+02:00 | 0 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:39:24.000000 | 20 | 28 | 2024-10-18 10:39:24+02:00 | 8 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:39:35.000000 | 12 | 12 | 2024-10-18 10:39:35+02:00 | 0 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:40:08.000000 | 20 | 24 | 2024-10-18 10:40:08+02:00 | 4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:40:35.000000 | 24 | 24 | 2024-10-18 10:40:35+02:00 | 0 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:40:37.000000 | 29 | 29 | 2024-10-18 10:40:37+02:00 | 0 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:40:40.000000 | 24 | 28 | 2024-10-18 10:40:40+02:00 | 4 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:42:55.000000 | 23 | 24 | 2024-10-18 10:42:55+02:00 | 1 |
| 101 | 5 | Elisabethenstrasse | 30 | BS | 2024-10-18 09:39:00+02:00 | 2024-11-08 08:18:00+01:00 | 2025-01-31 07:06:00+01:00 | 2025-03-19 06:00:00+01:00 | 2024 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} | Vormessung | 2024-10-18 | 10:43:54.000000 | 37 | 38 | 2024-10-18 10:43:54+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;