Einsatzplan
- Ende
- Ende des Messzyklus am Standort
- Geschwindigkeit
- Maximale erlaubte Geschwindigkeit
- Messung_Jahr
- Jahr der Messung
- Ort
- Ortsname
- Ort_Abkuerzung
- Abkürzung des Ortes
- Phase
- Phase der Messung (Vormessung, Betrieb, Nachmessung oder nach Ende)
- Start_Betrieb
- Beginn des aktiven Betriebs
- Start_Nachmessung
- Beginn der Nachmessung (mit ausgeschalteter Anzeige)
- Start_Vormessung
- Beginn der Vormessung (mit ausgeschalteter Anzeige)
- Strassenname
- Name der Strasse
- Zyklus
- Messzyklus
- geometry
- Koordinaten des Messstandortes im GeoJSON-Format
- id_standort
- Eindeutige Standortkennung
89 rows sorted by Start_Vormessung descending
This data as json, copyable, geojson, CSV (advanced)
Suggested facets: Zyklus, Geschwindigkeit, Ort_Abkuerzung, Messung_Jahr, Ort, Start_Vormessung (date), Start_Betrieb (date), Start_Nachmessung (date), Ende (date)
| Link | rowid | id_standort | Zyklus | Strassenname | Geschwindigkeit | Ort_Abkuerzung | Start_Vormessung ▲ | Start_Betrieb | Start_Nachmessung | Ende | Messung_Jahr | Ort | geometry |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50 | 50 | 59.0 | 5.0 | Birsigstrasse | 30.0 | BS | 2024-10-18 14:23:00+02:00 | 2024-11-08 13:19:00+01:00 | 2025-01-31 13:02:00+01:00 | 2025-03-20 13:48:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.581255812405658, 47.54939776115534]} |
| 9 | 9 | 30.0 | 5.0 | Marschalkenstrasse | 30.0 | BS | 2024-10-18 14:06:00+02:00 | 2024-11-08 12:57:00+01:00 | 2025-01-31 12:39:00+01:00 | 2025-03-20 12:19:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.571378079422876, 47.5476847361496]} |
| 31 | 31 | 49.0 | 5.0 | Welschmattstrasse | 30.0 | BS | 2024-10-18 13:46:00+02:00 | 2024-11-08 12:32:00+01:00 | 2025-01-31 12:19:00+01:00 | 2025-03-20 11:43:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.562756305393996, 47.56240392036311]} |
| 78 | 78 | 107.0 | 5.0 | Markircherstrasse | 20.0 | BS | 2024-10-18 13:34:00+02:00 | 2024-11-08 12:18:00+01:00 | 2025-01-31 12:07:00+01:00 | 2025-03-19 11:34:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.5635202239630095, 47.56627701770726]} |
| 55 | 55 | 10.0 | 5.0 | Niederholzstrasse | 20.0 | Rh | 2024-10-18 13:07:00+02:00 | 2024-11-08 12:01:00+01:00 | 2025-01-31 10:58:00+01:00 | 2025-03-19 09:35:00+01:00 | 2024.0 | Riehen | {"type": "Point", "coordinates": [7.635228320014377, 47.57495595665551]} |
| 14 | 14 | 4.0 | 5.0 | Inzlingerstrasse | 30.0 | Rh | 2024-10-18 12:46:00+02:00 | 2024-11-08 11:44:00+01:00 | 2025-01-31 10:32:00+01:00 | 2025-03-19 09:02:00+01:00 | 2024.0 | Riehen | {"type": "Point", "coordinates": [7.663365621525221, 47.58645667477576]} |
| 12 | 12 | 2.0 | 5.0 | Hauptstrasse | 40.0 | Bt | 2024-10-18 11:51:00+02:00 | 2024-11-08 11:29:00+01:00 | 2025-01-31 10:13:00+01:00 | 2025-03-19 07:27:00+01:00 | 2024.0 | Bettingen | {"type": "Point", "coordinates": [7.66687392253766, 47.57149358627666]} |
| 33 | 33 | 17.0 | 5.0 | Erlenstrasse | 50.0 | BS | 2024-10-18 11:18:00+02:00 | 2024-11-08 10:39:00+01:00 | 2025-01-31 09:46:00+01:00 | 2025-03-19 10:34:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.6022120779677955, 47.56906893126001]} |
| 40 | 40 | 57.0 | 5.0 | Erlenmattstrasse | 20.0 | BS | 2024-10-18 11:05:00+02:00 | 2024-11-08 10:29:00+01:00 | 2025-01-31 09:32:00+01:00 | 2025-03-19 10:22:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.600113840327108, 47.56883935272294]} |
| 43 | 43 | 31.0 | 5.0 | Mörsbergerstrasse | 20.0 | BS | 2024-10-18 10:48:00+02:00 | 2024-11-08 10:16:00+01:00 | 2025-01-31 09:14:00+01:00 | 2025-03-19 10:11:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.5933423615884506, 47.568236597919956]} |
| 89 | 89 | 101.0 | 5.0 | Elisabethenstrasse | 30.0 | 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.0 | Basel | {"type": "Point", "coordinates": [7.590838793478457, 47.55048328416821]} |
| 19 | 19 | 41.0 | 5.0 | Gellertstrasse | 30.0 | BS | 2024-10-18 09:22:00+02:00 | 2024-11-08 09:02:00+01:00 | 2025-01-31 08:31:00+01:00 | 2025-03-19 13:39:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.6119220296481735, 47.55121985370047]} |
| 79 | 79 | 38.0 | 5.0 | Emanuel Büchel-Strasse | 30.0 | BS | 2024-10-18 08:45:00+02:00 | 2024-11-08 08:49:00+01:00 | 2025-01-31 07:57:00+01:00 | 2025-03-19 13:28:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.613133048789885, 47.549201239374455]} |
| 53 | 53 | 51.0 | 5.0 | Gundeldingerstrasse | 50.0 | BS | 2024-10-18 08:07:00+02:00 | 2024-11-08 07:38:00+01:00 | 2025-01-31 06:44:00+01:00 | 2025-03-19 06:37:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.592452206181287, 47.54022921087103]} |
| 71 | 71 | 55.0 | 5.0 | Oscar Frey-Strasse | 30.0 | BS | 2024-10-18 07:34:00+02:00 | 2024-11-08 06:45:00+01:00 | 2025-01-31 06:29:00+01:00 | 2025-03-19 06:17:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.587374658494895, 47.53099425001006]} |
| 45 | 45 | 54.0 | 5.0 | Giornicostrasse | 30.0 | BS | 2024-10-18 07:22:00+02:00 | 2024-11-08 06:27:00+01:00 | 2025-01-31 06:17:00+01:00 | 2025-03-19 06:02:00+01:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.594024292037586, 47.52690598936203]} |
| 37 | 37 | 42.0 | 4.0 | Münchensteinerstrasse | 50.0 | BS | 2024-05-07 14:40:00+02:00 | 2024-06-07 10:01:00+02:00 | 2024-09-06 14:02:00+02:00 | 2024-10-17 11:00:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.604405632725479, 47.540733885121526]} |
| 54 | 54 | 51.0 | 4.0 | Gundeldingerstrasse | 50.0 | BS | 2024-05-07 14:15:00+02:00 | 2024-06-07 08:49:00+02:00 | 2024-09-06 07:58:00+02:00 | 2024-10-17 15:34:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.592452206181287, 47.54022921087103]} |
| 86 | 86 | 33.0 | 4.0 | Peter Merian-Strasse | 30.0 | BS | 2024-05-07 13:00:00+02:00 | 2024-06-07 08:56:00+02:00 | 2024-09-06 08:23:00+02:00 | 2024-10-17 11:25:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.596232034662139, 47.548434099551926]} |
| 62 | 62 | 35.0 | 4.0 | Engelgasse | 30.0 | BS | 2024-05-07 11:40:00+02:00 | 2024-06-07 09:55:00+02:00 | 2024-09-06 08:58:00+02:00 | 2024-10-17 12:50:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.604531337049818, 47.54765171092116]} |
| 21 | 21 | 41.0 | 4.0 | Gellertstrasse | 30.0 | BS | 2024-05-07 11:15:00+02:00 | 2024-06-07 09:50:00+02:00 | 2024-09-06 09:29:00+02:00 | 2024-10-17 13:02:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.6119220296481735, 47.55121985370047]} |
| 67 | 67 | 117.0 | 4.0 | Gellertstrasse | 30.0 | BS | 2024-05-07 08:35:00+02:00 | 2024-06-07 09:30:00+02:00 | 2024-09-06 09:40:00+02:00 | 2024-10-17 08:00:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.610901570940486, 47.55154177934172]} |
| 30 | 30 | 116.0 | 4.0 | Güterstrasse | 30.0 | BS | 2024-05-07 07:35:00+02:00 | 2024-06-07 08:35:00+02:00 | 2024-09-06 08:12:00+02:00 | 2024-10-17 07:05:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.596174326259833, 47.542290927671914]} |
| 38 | 38 | 56.0 | 4.0 | Oscar Frey-Strasse | 30.0 | BS | 2024-05-06 15:25:00+02:00 | 2024-06-07 08:23:00+02:00 | 2024-09-06 07:40:00+02:00 | 2024-10-17 15:23:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.587357642332072, 47.52991880004344]} |
| 25 | 25 | 58.0 | 4.0 | Auberg | 50.0 | BS | 2024-05-06 14:45:00+02:00 | 2024-06-07 09:40:00+02:00 | 2024-09-06 08:37:00+02:00 | 2024-10-17 13:15:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.586367676780545, 47.55197196317229]} |
| 26 | 26 | 43.0 | 4.0 | Flughafenstrasse | 50.0 | BS | 2024-05-06 14:20:00+02:00 | 2024-06-07 10:55:00+02:00 | 2024-09-06 13:22:00+02:00 | 2024-10-17 14:46:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.571100011960617, 47.56762535065735]} |
| 75 | 75 | 26.0 | 4.0 | Tangentenweg | 20.0 | BS | 2024-05-06 13:40:00+02:00 | 2024-06-07 11:10:00+02:00 | 2024-09-06 10:23:00+02:00 | 2024-10-17 10:21:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.598473576090929, 47.56873927474225]} |
| 5 | 5 | 16.0 | 4.0 | Sperrstrasse | 30.0 | BS | 2024-05-06 13:15:00+02:00 | 2024-06-07 11:00:00+02:00 | 2024-09-06 10:10:00+02:00 | 2024-10-17 10:33:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.59408988351974, 47.56502606555209]} |
| 3 | 3 | 8.0 | 4.0 | Wendelinsgasse | 30.0 | Rh | 2024-05-06 11:40:00+02:00 | 2024-06-07 12:45:00+02:00 | 2024-09-06 12:58:00+02:00 | 2024-10-17 08:33:00+02:00 | 2024.0 | Riehen | {"type": "Point", "coordinates": [7.65280884940832, 47.585680344521826]} |
| 8 | 8 | 5.0 | 4.0 | Steingrubenweg | 30.0 | Rh | 2024-05-06 11:10:00+02:00 | 2024-06-07 13:01:00+02:00 | 2024-09-06 12:42:00+02:00 | 2024-10-17 08:23:00+02:00 | 2024.0 | Riehen | {"type": "Point", "coordinates": [7.656687279810441, 47.58902877376017]} |
| 88 | 88 | 15.0 | 4.0 | Hochbergerstrasse | 50.0 | BS | 2024-05-06 10:30:00+02:00 | 2024-06-07 11:24:00+02:00 | 2024-09-06 10:37:00+02:00 | 2024-10-17 11:07:00+02:00 | 2024.0 | Basel | {"type": "Point", "coordinates": [7.59635875804432, 47.57718628879343]} |
| 59 | 59 | 7.0 | 4.0 | Weilstrasse | 30.0 | Rh | 2024-05-06 09:50:00+02:00 | 2024-06-07 13:26:00+02:00 | 2024-09-06 11:55:00+02:00 | 2024-10-17 08:54:00+02:00 | 2024.0 | Riehen | {"type": "Point", "coordinates": [7.645558031684063, 47.59263802605024]} |
| 36 | 36 | 9.0 | 4.0 | Lörracherstrasse | 30.0 | Rh | 2024-05-06 08:50:00+02:00 | 2024-06-07 13:15:00+02:00 | 2024-09-06 11:33:00+02:00 | 2024-10-17 08:44:00+02:00 | 2024.0 | Riehen | {"type": "Point", "coordinates": [7.654015072595907, 47.59318783861964]} |
| 84 | 84 | 1.0 | 4.0 | Hauptstrasse | 40.0 | Bt | 2024-05-06 08:20:00+02:00 | 2024-06-07 11:58:00+02:00 | 2024-09-06 11:16:00+02:00 | 2024-10-17 07:49:00+02:00 | 2024.0 | Bettingen | {"type": "Point", "coordinates": [7.662705714833994, 47.57020277263554]} |
| 70 | 70 | 11.0 | 4.0 | Kohlistieg | 50.0 | Rh | 2024-05-06 07:45:00+02:00 | 2024-06-07 11:41:00+02:00 | 2024-09-06 11:04:00+02:00 | 2024-10-17 07:21:00+02:00 | 2024.0 | Riehen | {"type": "Point", "coordinates": [7.639936169264081, 47.56849244150005]} |
| 42 | 42 | 29.0 | 3.0 | Petersgraben | 30.0 | BS | 2023-12-08 11:55:00+01:00 | 2024-01-04 12:45:00+01:00 | 2024-04-05 14:05:00+02:00 | 2024-05-06 14:15:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.584286533661596, 47.558972366081356]} |
| 18 | 18 | 23.0 | 3.0 | Spitalstrasse | 30.0 | BS | 2023-12-08 11:45:00+01:00 | 2024-01-04 12:30:00+01:00 | 2024-04-05 13:55:00+02:00 | 2024-05-06 13:30:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.583264789837327, 47.562911537932244]} |
| 85 | 85 | 14.0 | 3.0 | Mülhauserstrasse | 30.0 | BS | 2023-12-08 11:10:00+01:00 | 2024-01-04 12:15:00+01:00 | 2024-04-05 13:40:00+02:00 | 2024-05-06 13:50:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5814545182039765, 47.569090347145504]} |
| 28 | 28 | 21.0 | 3.0 | Landskronstrasse | 30.0 | BS | 2023-12-08 11:05:00+01:00 | 2024-01-04 12:00:00+01:00 | 2024-04-05 13:24:00+02:00 | 2024-05-06 13:15:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.574711123475233, 47.56734249816205]} |
| 27 | 27 | 52.0 | 3.0 | Hegenheimerstrasse | 30.0 | BS | 2023-12-08 10:50:00+01:00 | 2024-01-04 11:40:00+01:00 | 2024-04-05 13:07:00+02:00 | 2024-05-06 13:20:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.565750762402361, 47.56348144457905]} |
| 74 | 74 | 50.0 | 3.0 | Blotzheimerstrasse | 30.0 | BS | 2023-12-08 10:45:00+01:00 | 2024-01-04 11:00:00+01:00 | 2024-04-05 12:57:00+02:00 | 2024-05-06 13:00:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.561670756025739, 47.56085978786428]} |
| 56 | 56 | 10.0 | 3.0 | Niederholzstrasse | 20.0 | Rh | 2023-12-08 10:20:00+01:00 | 2024-01-04 10:35:00+01:00 | 2024-04-05 11:53:00+02:00 | 2024-05-06 12:00:00+02:00 | 2023.0 | Riehen | {"type": "Point", "coordinates": [7.635228320014377, 47.57495595665551]} |
| 4 | 4 | 3.0 | 3.0 | Bahnhofstrasse | 30.0 | Rh | 2023-12-08 10:00:00+01:00 | 2024-01-04 10:20:00+01:00 | 2024-04-05 11:27:00+02:00 | 2024-05-06 11:35:00+02:00 | 2023.0 | Riehen | {"type": "Point", "coordinates": [7.652133688135013, 47.58424874218438]} |
| 13 | 13 | 2.0 | 3.0 | Hauptstrasse | 40.0 | Bt | 2023-12-08 09:45:00+01:00 | 2024-01-04 10:05:00+01:00 | 2024-04-05 11:38:00+02:00 | 2024-05-06 11:50:00+02:00 | 2023.0 | Bettingen | {"type": "Point", "coordinates": [7.66687392253766, 47.57149358627666]} |
| 24 | 24 | 12.0 | 3.0 | Allmendstrasse | 30.0 | BS | 2023-12-08 09:05:00+01:00 | 2024-01-04 09:35:00+01:00 | 2024-04-05 11:10:00+02:00 | 2024-05-06 11:15:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.618064365304308, 47.56885123022522]} |
| 81 | 81 | 13.0 | 3.0 | Schorenweg | 30.0 | BS | 2023-12-08 08:40:00+01:00 | 2024-01-04 09:20:00+01:00 | 2024-04-05 11:00:00+02:00 | 2024-05-06 11:25:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.610849274773399, 47.5714542933845]} |
| 47 | 47 | 32.0 | 3.0 | Dorfstrasse | 30.0 | BS | 2023-12-08 07:45:00+01:00 | 2024-01-04 08:50:00+01:00 | 2024-04-05 10:28:00+02:00 | 2024-05-06 10:35:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.59255496070469, 47.584630799348915]} |
| 48 | 48 | 19.0 | 3.0 | Wettsteinbrücke | 50.0 | BS | 2023-12-08 07:25:00+01:00 | 2024-01-04 08:20:00+01:00 | 2024-04-05 10:03:00+02:00 | 2024-05-06 09:45:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5974759047131295, 47.55787497255407]} |
| 82 | 82 | 114.0 | 3.0 | St. Alban-Vorstadt | 30.0 | BS | 2023-12-08 07:05:00+01:00 | 2024-01-04 07:45:00+01:00 | 2024-04-05 09:05:00+02:00 | 2024-05-06 09:20:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.600111162342403, 47.5539768902896]} |
| 29 | 29 | 40.0 | 3.0 | Gellertstrasse | 30.0 | BS | 2023-12-08 06:50:00+01:00 | 2024-01-04 07:30:00+01:00 | 2024-04-05 09:00:00+02:00 | 2024-05-06 09:10:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.616868780072343, 47.54936808097247]} |
| 72 | 72 | 24.0 | 3.0 | Karl Jaspers-Allee | 30.0 | BS | 2023-12-08 06:30:00+01:00 | 2024-01-04 07:15:00+01:00 | 2024-04-05 08:46:00+02:00 | 2024-05-06 08:50:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.613788475368083, 47.5470395566042]} |
| 76 | 76 | 47.0 | 3.0 | Binningerstrasse | 60.0 | BS | 2023-12-08 06:10:00+01:00 | 2024-01-04 06:55:00+01:00 | 2024-04-05 08:23:00+02:00 | 2024-05-06 08:30:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5786830839069825, 47.54528993031834]} |
| 73 | 73 | 106.0 | 3.0 | Lerchenstrasse | 30.0 | BS | 2023-12-08 05:50:00+01:00 | 2024-01-04 06:35:00+01:00 | 2024-04-05 07:54:00+02:00 | 2024-05-06 08:00:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.589415847888779, 47.53917691339795]} |
| 66 | 66 | 22.0 | 2.0 | Spitalstrasse | 50.0 | BS | 2023-07-14 17:30:00+02:00 | 2023-08-04 12:46:00+02:00 | 2023-11-03 11:30:00+01:00 | 2023-12-04 11:40:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.581597031044652, 47.564413124837714]} |
| 57 | 57 | 44.0 | 2.0 | Dorfstrasse | 20.0 | BS | 2023-07-14 13:40:00+02:00 | 2023-08-04 10:37:00+02:00 | 2023-11-03 09:30:00+01:00 | 2023-12-04 09:40:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5926838030618375, 47.58309470330223]} |
| 58 | 58 | 7.0 | 2.0 | Weilstrasse | 30.0 | Rh | 2023-07-14 13:15:00+02:00 | 2023-08-04 13:48:00+02:00 | 2023-11-03 12:49:00+01:00 | 2023-12-04 12:55:00+01:00 | 2023.0 | Riehen | {"type": "Point", "coordinates": [7.645558031684063, 47.59263802605024]} |
| 15 | 15 | 4.0 | 2.0 | Inzlingerstrasse | 30.0 | Rh | 2023-07-14 13:05:00+02:00 | 2023-08-04 13:38:00+02:00 | 2023-11-03 12:59:00+01:00 | 2023-12-04 13:00:00+01:00 | 2023.0 | Riehen | {"type": "Point", "coordinates": [7.663365621525221, 47.58645667477576]} |
| 83 | 83 | 1.0 | 2.0 | Hauptstrasse | 40.0 | Bt | 2023-07-14 12:50:00+02:00 | 2023-08-04 13:26:00+02:00 | 2023-11-03 13:16:00+01:00 | 2023-12-04 13:15:00+01:00 | 2023.0 | Bettingen | {"type": "Point", "coordinates": [7.662705714833994, 47.57020277263554]} |
| 61 | 61 | 108.0 | 2.0 | Oberwilerstrasse | 30.0 | BS | 2023-07-14 12:30:00+02:00 | 2023-08-04 12:32:00+02:00 | 2023-11-03 10:41:00+01:00 | 2023-12-04 11:05:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.577934218927053, 47.54931141676089]} |
| 63 | 63 | 60.0 | 2.0 | Wanderstrasse | 50.0 | BS | 2023-07-14 11:50:00+02:00 | 2023-08-04 11:46:00+02:00 | 2023-11-03 10:24:00+01:00 | 2023-12-04 10:20:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.566264501562943, 47.55249744083134]} |
| 32 | 32 | 49.0 | 2.0 | Welschmattstrasse | 30.0 | BS | 2023-07-14 11:30:00+02:00 | 2023-08-04 11:31:00+02:00 | 2023-11-03 10:13:00+01:00 | 2023-12-04 10:15:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.562756305393996, 47.56240392036311]} |
| 49 | 49 | 104.0 | 2.0 | Hegenheimerstrasse | 30.0 | BS | 2023-07-14 11:25:00+02:00 | 2023-08-04 11:19:00+02:00 | 2023-11-03 10:00:00+01:00 | 2023-12-04 10:25:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.565572490967455, 47.563424051900846]} |
| 52 | 52 | 36.0 | 2.0 | Entenweidstrasse | 30.0 | BS | 2023-07-14 11:15:00+02:00 | 2023-08-04 10:53:00+02:00 | 2023-11-03 09:48:00+01:00 | 2023-12-04 09:55:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.573862562524348, 47.568372390504855]} |
| 77 | 77 | 48.0 | 2.0 | Badenweilerstrasse | 30.0 | BS | 2023-07-14 10:55:00+02:00 | 2023-08-04 10:23:00+02:00 | 2023-11-03 09:14:00+01:00 | 2023-12-04 09:30:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.593099674132068, 47.57174401887652]} |
| 22 | 22 | 45.0 | 2.0 | Horburgstrasse | 30.0 | BS | 2023-07-14 10:40:00+02:00 | 2023-08-04 10:15:00+02:00 | 2023-11-03 09:02:00+01:00 | 2023-12-04 09:05:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.596817382610532, 47.57181812346747]} |
| 11 | 11 | 25.0 | 2.0 | Tangentenweg | 20.0 | BS | 2023-07-14 10:30:00+02:00 | 2023-08-04 09:56:00+02:00 | 2023-11-03 08:47:00+01:00 | 2023-12-04 08:50:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.598617201790952, 47.56969177983569]} |
| 1 | 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]} |
| 2 | 2 | 110.0 | 2.0 | Rittergasse | 20.0 | BS | 2023-07-14 10:00:00+02:00 | 2023-08-04 09:31:00+02:00 | 2023-11-03 07:54:00+01:00 | 2023-12-04 07:55:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.592328101436347, 47.5560087956915]} |
| 7 | 7 | 34.0 | 2.0 | Engelgasse | 30.0 | BS | 2023-07-14 09:45:00+02:00 | 2023-08-04 08:38:00+02:00 | 2023-11-03 07:21:00+01:00 | 2023-12-04 07:15:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.602242325948242, 47.548989578382965]} |
| 65 | 65 | 39.0 | 2.0 | Gellertstrasse | 30.0 | BS | 2023-07-14 09:30:00+02:00 | 2023-08-04 08:54:00+02:00 | 2023-11-03 07:31:00+01:00 | 2023-12-04 07:30:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.618557077514559, 47.54683709282721]} |
| 68 | 68 | 46.0 | 2.0 | Margarethenbrücke | 50.0 | BS | 2023-07-14 08:40:00+02:00 | 2023-08-04 08:13:00+02:00 | 2023-11-03 06:49:00+01:00 | 2023-12-04 06:50:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.584758983703197, 47.54754051019417]} |
| 87 | 87 | 53.0 | 2.0 | Unterer Batterieweg | 30.0 | BS | 2023-07-14 08:15:00+02:00 | 2023-08-04 07:58:00+02:00 | 2023-11-03 06:36:00+01:00 | 2023-12-04 06:40:00+01:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.586705011405081, 47.541027020963796]} |
| 10 | 10 | 30.0 | 1.0 | Marschalkenstrasse | 30.0 | BS | 2023-02-09 13:12:00+01:00 | 2023-03-10 10:26:00+01:00 | 2023-06-09 13:16:00+02:00 | 2023-07-11 13:37:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.571378079422876, 47.5476847361496]} |
| 17 | 17 | 102.0 | 1.0 | Gempenstrasse | 20.0 | BS | 2023-02-09 12:54:00+01:00 | 2023-03-10 10:55:00+01:00 | 2023-06-09 13:47:00+02:00 | 2023-07-11 11:32:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.586355521057956, 47.543809357341694]} |
| 51 | 51 | 59.0 | 1.0 | Birsigstrasse | 30.0 | BS | 2023-02-09 12:39:00+01:00 | 2023-03-10 10:39:00+01:00 | 2023-06-09 13:29:00+02:00 | 2023-07-11 12:31:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.581255812405658, 47.54939776115534]} |
| 16 | 16 | 115.0 | 1.0 | Bungestrasse | 20.0 | BS | 2023-02-09 12:12:00+01:00 | 2023-03-10 10:08:00+01:00 | 2023-06-09 12:57:00+02:00 | 2023-07-12 13:35:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.564165795495954, 47.56777983730346]} |
| 35 | 35 | 9.0 | 1.0 | Lörracherstrasse | 50.0 | Rh | 2023-02-09 11:36:00+01:00 | 2023-03-10 08:54:00+01:00 | 2023-06-09 11:04:00+02:00 | 2023-07-11 07:36:00+02:00 | 2023.0 | Riehen | {"type": "Point", "coordinates": [7.654015072595907, 47.59318783861964]} |
| 69 | 69 | 11.0 | 1.0 | Kohlistieg | 50.0 | Rh | 2023-02-09 10:45:00+01:00 | 2023-03-10 08:26:00+01:00 | 2023-06-09 10:34:00+02:00 | 2023-07-11 06:36:00+02:00 | 2023.0 | Riehen | {"type": "Point", "coordinates": [7.639936169264081, 47.56849244150005]} |
| 44 | 44 | 31.0 | 1.0 | Mörsbergerstrasse | 20.0 | BS | 2023-02-09 10:17:00+01:00 | 2023-03-10 09:43:00+01:00 | 2023-06-09 12:38:00+02:00 | 2023-07-10 13:15:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5933423615884506, 47.568236597919956]} |
| 34 | 34 | 17.0 | 1.0 | Erlenstrasse | 50.0 | BS | 2023-02-09 10:00:00+01:00 | 2023-03-10 09:24:00+01:00 | 2023-06-09 11:52:00+02:00 | 2023-07-10 13:07:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.6022120779677955, 47.56906893126001]} |
| 41 | 41 | 57.0 | 1.0 | Erlenmattstrasse | 20.0 | BS | 2023-02-09 09:53:00+01:00 | 2023-03-10 09:14:00+01:00 | 2023-06-09 11:41:00+02:00 | 2023-07-10 12:51:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.600113840327108, 47.56883935272294]} |
| 23 | 23 | 12.0 | 1.0 | Allmendstrasse | 30.0 | BS | 2023-02-09 09:33:00+01:00 | 2023-03-10 08:00:00+01:00 | 2023-06-09 10:18:00+02:00 | 2023-07-10 09:00:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.618064365304308, 47.56885123022522]} |
| 64 | 64 | 20.0 | 1.0 | Wettsteinallee | 30.0 | BS | 2023-02-09 09:16:00+01:00 | 2023-03-10 07:47:00+01:00 | 2023-06-09 09:58:00+02:00 | 2023-07-10 10:00:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.600287024094922, 47.560020076961386]} |
| 39 | 39 | 109.0 | 1.0 | Rittergasse | 20.0 | BS | 2023-02-09 08:58:00+01:00 | 2023-03-10 07:35:00+01:00 | 2023-06-09 09:45:00+02:00 | 2023-07-11 13:33:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.5932381340662385, 47.55546884905992]} |
| 6 | 6 | 34.0 | 1.0 | Engelgasse | 30.0 | BS | 2023-02-09 08:30:00+01:00 | 2023-03-10 07:24:00+01:00 | 2023-06-09 09:35:00+02:00 | 2023-07-11 14:10:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.602242325948242, 47.548989578382965]} |
| 20 | 20 | 41.0 | 1.0 | Gellertstrasse | 30.0 | BS | 2023-02-09 07:55:00+01:00 | 2023-03-10 07:08:00+01:00 | 2023-06-09 09:21:00+02:00 | 2023-07-10 09:26:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.6119220296481735, 47.55121985370047]} |
| 80 | 80 | 38.0 | 1.0 | Emanuel Büchel-Strasse | 30.0 | BS | 2023-02-09 07:45:00+01:00 | 2023-03-10 06:59:00+01:00 | 2023-06-09 08:55:00+02:00 | 2023-07-10 09:11:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.613133048789885, 47.549201239374455]} |
| 60 | 60 | 37.0 | 1.0 | Adlerstrasse | 50.0 | BS | 2023-02-09 07:35:00+01:00 | 2023-03-10 06:49:00+01:00 | 2023-06-09 08:44:00+02:00 | 2023-07-10 09:02:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.610315058920576, 47.546960332273244]} |
| 46 | 46 | 54.0 | 1.0 | Giornicostrasse | 30.0 | BS | 2023-02-09 07:05:00+01:00 | 2023-03-10 06:32:00+01:00 | 2023-06-09 08:21:00+02:00 | 2023-07-10 09:30:00+02:00 | 2023.0 | Basel | {"type": "Point", "coordinates": [7.594024292037586, 47.52690598936203]} |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "Einsatzplan" (
"id_standort" REAL,
"Zyklus" REAL,
"Strassenname" TEXT,
"Geschwindigkeit" REAL,
"Ort_Abkuerzung" TEXT,
"Start_Vormessung" TIMESTAMP,
"Start_Betrieb" TIMESTAMP,
"Start_Nachmessung" TIMESTAMP,
"Ende" TIMESTAMP,
"Messung_Jahr" REAL,
"Ort" TEXT,
"geometry" TEXT
);
CREATE INDEX idx_Einsatzplan_zyklus ON "Einsatzplan" ("Zyklus");
CREATE INDEX idx_Einsatzplan_geschwindigkeit ON "Einsatzplan" ("Geschwindigkeit");
CREATE INDEX idx_Einsatzplan_ort_abkuerzung ON "Einsatzplan" ("Ort_Abkuerzung");
CREATE INDEX idx_Einsatzplan_messung_jahr ON "Einsatzplan" ("Messung_Jahr");