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
72 rows where Ort = "Basel" sorted by Start_Vormessung descending
This data as json, copyable, geojson, CSV (advanced)
Suggested facets: Zyklus, Geschwindigkeit, Messung_Jahr, Start_Vormessung (date), Start_Betrieb (date), Start_Nachmessung (date), Ende (date)
| ID | id_standort | Zyklus | Strassenname | Geschwindigkeit | Ort_Abkuerzung | Start_Vormessung ▲ | Start_Betrieb | Start_Nachmessung | Ende | Messung_Jahr | Ort | geometry |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5-59 | 59 | 5 | Birsigstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.581255812405658, 47.54939776115534]} |
| 5-30 | 30 | 5 | Marschalkenstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.571286057910828, 47.547618529853914]} |
| 5-49 | 49 | 5 | Welschmattstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.562756305393996, 47.56240392036311]} |
| 5-107 | 107 | 5 | Markircherstrasse | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.5635202239630095, 47.56627701770726]} |
| 5-17 | 17 | 5 | Erlenstrasse | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.6022120779677955, 47.56906893126001]} |
| 5-57 | 57 | 5 | Erlenmattstrasse | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.600113840327108, 47.56883935272294]} |
| 5-31 | 31 | 5 | Mörsbergerstrasse | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.5933423615884506, 47.568236597919956]} |
| 5-101 | 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]} |
| 5-41 | 41 | 5 | Gellertstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.618528213226541, 47.547089556649816]} |
| 5-38 | 38 | 5 | Emanuel Büchel-Strasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.613133048789885, 47.549201239374455]} |
| 5-51 | 51 | 5 | Gundeldingerstrasse | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.592452206181287, 47.54022921087103]} |
| 5-55 | 55 | 5 | Oscar Frey-Strasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.587374658494895, 47.53099425001006]} |
| 5-54 | 54 | 5 | Giornicostrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.594024292037586, 47.52690598936203]} |
| 4-42 | 42 | 4 | Münchensteinerstrasse | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.604160159080439, 47.5408426094466]} |
| 4-51 | 51 | 4 | Gundeldingerstrasse | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.592452206181287, 47.54022921087103]} |
| 4-33 | 33 | 4 | Peter Merian-Strasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.596232034662139, 47.548434099551926]} |
| 4-35 | 35 | 4 | Engelgasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.604531337049818, 47.54765171092116]} |
| 4-41 | 41 | 4 | Gellertstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.618528213226541, 47.547089556649816]} |
| 4-117 | 117 | 4 | Gellertstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.610901570940486, 47.55154177934172]} |
| 4-116 | 116 | 4 | Güterstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.596174326259833, 47.542290927671914]} |
| 4-56 | 56 | 4 | Oscar Frey-Strasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.587357642332072, 47.52991880004344]} |
| 4-58 | 58 | 4 | Auberg | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.586367676780545, 47.55197196317229]} |
| 4-43 | 43 | 4 | Flughafenstrasse | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.571100011960617, 47.56762535065735]} |
| 4-26 | 26 | 4 | Tangentenweg | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.598473576090929, 47.56873927474225]} |
| 4-16 | 16 | 4 | Sperrstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.59408988351974, 47.56502606555209]} |
| 4-15 | 15 | 4 | Hochbergerstrasse | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.59635875804432, 47.57718628879343]} |
| 3-29 | 29 | 3 | Petersgraben | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.584286533661596, 47.558972366081356]} |
| 3-23 | 23 | 3 | Spitalstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.583208715185524, 47.56291114879368]} |
| 3-14 | 14 | 3 | Mülhauserstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.5814545182039765, 47.569090347145504]} |
| 3-21 | 21 | 3 | Landskronstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.574711123475233, 47.56734249816205]} |
| 3-52 | 52 | 3 | Hegenheimerstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.565750762402361, 47.56348144457905]} |
| 3-50 | 50 | 3 | Blotzheimerstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.561670756025739, 47.56085978786428]} |
| 3-12 | 12 | 3 | Allmendstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.618064365304308, 47.56885123022522]} |
| 3-13 | 13 | 3 | Schorenweg | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.610983072427675, 47.571663063922436]} |
| 3-32 | 32 | 3 | Dorfstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.59255496070469, 47.584630799348915]} |
| 3-19 | 19 | 3 | Wettsteinbrücke | 50 | 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 | Basel | |
| 3-114 | 114 | 3 | St. Alban-Vorstadt | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.600111162342403, 47.5539768902896]} |
| 3-40 | 40 | 3 | Gellertstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.616868780072343, 47.54936808097247]} |
| 3-24 | 24 | 3 | Karl Jaspers-Allee | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.613788475368083, 47.5470395566042]} |
| 3-47 | 47 | 3 | Binningerstrasse | 60 | 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 | Basel | {"type": "Point", "coordinates": [7.578708695291969, 47.545528693086766]} |
| 3-106 | 106 | 3 | Lerchenstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.589415847888779, 47.53917691339795]} |
| 2-22 | 22 | 2 | Spitalstrasse | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.581597031044652, 47.564413124837714]} |
| 2-44 | 44 | 2 | Dorfstrasse | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.592631712668231, 47.58287936522412]} |
| 2-108 | 108 | 2 | Oberwilerstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.577934218927053, 47.54931141676089]} |
| 2-60 | 60 | 2 | Wanderstrasse | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.566264501562943, 47.55249744083134]} |
| 2-49 | 49 | 2 | Welschmattstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.562756305393996, 47.56240392036311]} |
| 2-104 | 104 | 2 | Hegenheimerstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.565572490967455, 47.563424051900846]} |
| 2-36 | 36 | 2 | Entenweidstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.573862562524348, 47.568372390504855]} |
| 2-48 | 48 | 2 | Badenweilerstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.593099674132068, 47.57174401887652]} |
| 2-45 | 45 | 2 | Horburgstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.596817382610532, 47.57181812346747]} |
| 2-25 | 25 | 2 | Tangentenweg | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.598617201790952, 47.56969177983569]} |
| 2-18 | 18 | 2 | Wettsteinbrücke | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.5976330771858835, 47.558551518462025]} |
| 2-110 | 110 | 2 | Rittergasse | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.592328101436347, 47.5560087956915]} |
| 2-34 | 34 | 2 | Engelgasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.602242325948242, 47.548989578382965]} |
| 2-39 | 39 | 2 | Gellertstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.6119220296481735, 47.55121985370047]} |
| 2-46 | 46 | 2 | Margarethenbrücke | 50 | 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 | Basel | |
| 2-53 | 53 | 2 | Unterer Batterieweg | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.586705011405081, 47.541027020963796]} |
| 1-30 | 30 | 1 | Marschalkenstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.571286057910828, 47.547618529853914]} |
| 1-102 | 102 | 1 | Gempenstrasse | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.586355521057956, 47.543809357341694]} |
| 1-59 | 59 | 1 | Birsigstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.581255812405658, 47.54939776115534]} |
| 1-115 | 115 | 1 | Bungestrasse | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.564165795495954, 47.56777983730346]} |
| 1-31 | 31 | 1 | Mörsbergerstrasse | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.5933423615884506, 47.568236597919956]} |
| 1-17 | 17 | 1 | Erlenstrasse | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.6022120779677955, 47.56906893126001]} |
| 1-57 | 57 | 1 | Erlenmattstrasse | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.600113840327108, 47.56883935272294]} |
| 1-12 | 12 | 1 | Allmendstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.618064365304308, 47.56885123022522]} |
| 1-20 | 20 | 1 | Wettsteinallee | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.600287024094922, 47.560020076961386]} |
| 1-109 | 109 | 1 | Rittergasse | 20 | 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 | Basel | {"type": "Point", "coordinates": [7.5932381340662385, 47.55546884905992]} |
| 1-34 | 34 | 1 | Engelgasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.602242325948242, 47.548989578382965]} |
| 1-41 | 41 | 1 | Gellertstrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.618528213226541, 47.547089556649816]} |
| 1-38 | 38 | 1 | Emanuel Büchel-Strasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.613133048789885, 47.549201239374455]} |
| 1-37 | 37 | 1 | Adlerstrasse | 50 | 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 | Basel | {"type": "Point", "coordinates": [7.610315058920576, 47.546960332273244]} |
| 1-54 | 54 | 1 | Giornicostrasse | 30 | 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 | Basel | {"type": "Point", "coordinates": [7.594024292037586, 47.52690598936203]} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE Einsatzplan (
ID TEXT PRIMARY KEY,
id_standort INTEGER,
Zyklus INTEGER,
Strassenname TEXT,
Geschwindigkeit INTEGER,
Ort_Abkuerzung TEXT,
Start_Vormessung TEXT,
Start_Betrieb TEXT,
Start_Nachmessung TEXT,
Ende TEXT,
Messung_Jahr INTEGER,
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");
CREATE INDEX idx_Einsatzplan_start_vormessung ON "Einsatzplan" ("Start_Vormessung");
CREATE INDEX idx_Einsatzplan_start_betrieb ON "Einsatzplan" ("Start_Betrieb");
CREATE INDEX idx_Einsatzplan_start_nachmessung ON "Einsatzplan" ("Start_Nachmessung");
CREATE INDEX idx_Einsatzplan_ende ON "Einsatzplan" ("Ende");