Kennzahlen_pro_Richtung
- Messung-ID
- Laufnummer der Messung; eine Messung beinhaltet alle Fahrten eines Messgeräts an einem Standort
- Richtung ID
- ID der Richtung; In einer Messung werden i.d.R. Fahrten in zwei Richtungen gemessen.
- Richtung
- Name der Fahrtrichtung
- Fzg
- Anzahl gemessene Fahrzeuge während der Messung
- V50
- Höchstgeschwindigkeit, welche von 50% der Fahrzeuge nicht überschritten wird
- V85
- Höchstgeschwindigkeit, welche von 85% der Fahrzeuge nicht überschritten wird
- Messbeginn
- Datum, an welchem ein Messgerät an einem Standort ausgebracht wurde
- Messende
- Datum, bis zu welchem ein Messgerät an einem Standort im Einsatz war
- Zone
- geltende Höchstgeschwindigkeit am Standort der Messung
- Ort
- Gemeinde am Standort der Messung
- geometry
- Koordinaten des Messstandortes im GeoJSON-Format
- Ue_Quote
- Übertretungsquote
- Strasse
- Name der Strasse, an welcher ein Messgerät ausgebracht wurde
- Strasse_Nr
- Hausnummer, bei welcher ein Messgerät ausgebracht wurde
36 rows where Zone = "60.0" sorted by Messung-ID descending
This data as json, CSV (advanced)
Suggested facets: Richtung, V50, V85, Ue_Quote, geometry, Strasse_Nr, Messbeginn, Messende
Messung-ID 18
Messende (date) 15
- 2024-06-10 8
- 2018-08-06 2
- 2019-02-09 2
- 2019-06-24 2
- 2021-02-04 2
- 2021-08-16 2
- 2021-11-13 2
- 2021-11-18 2
- 2021-12-02 2
- 2023-05-02 2
- 2023-11-20 2
- 2024-12-09 2
- 2024-12-30 2
- 2025-04-21 2
- 2025-07-14 2
Messbeginn (date) 15
- 2024-05-27 8
- 2018-07-23 2
- 2019-01-28 2
- 2019-06-12 2
- 2021-01-25 2
- 2021-08-02 2
- 2021-11-01 2
- 2021-11-08 2
- 2021-11-22 2
- 2023-04-17 2
- 2023-11-06 2
- 2024-11-25 2
- 2024-12-16 2
- 2025-04-07 2
- 2025-07-07 2
Strasse 11
Zone 1
- 60.0 · 36 ✖
Link | rowid | Messung-ID ▲ | Richtung ID | Richtung | Fzg | V50 | V85 | Ue_Quote | geometry | Strasse | Strasse_Nr | Ort | Zone | Messbeginn | Messende |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1923 | 1923 | 1047 | 1 | Landesgrenze | 39023.0 | 47.0 | 53.0 | 0.61 | {"type":"Point","coordinates":[7.60330081100603,47.5788181580724]} | Freiburgerstrasse | vis 48 | Basel | 60.0 | 2025-07-07 | 2025-07-14 |
1924 | 1924 | 1047 | 2 | {"type":"Point","coordinates":[7.60330081100603,47.5788181580724]} | Freiburgerstrasse | vis 48 | Basel | 60.0 | 2025-07-07 | 2025-07-14 | |||||
1859 | 1859 | 1009 | 1 | Bettingerstrasse | 79068.0 | 60.0 | 65.0 | 12.7 | {"type":"Point","coordinates":[7.62405672067884,47.5722575594826]} | Aeuss. Baselstrasse | 383 | Basel | 60.0 | 2025-04-07 | 2025-04-21 |
1860 | 1860 | 1009 | 2 | Basel Riehenstrasse | 73038.0 | 63.0 | 68.0 | 29.32 | {"type":"Point","coordinates":[7.62405672067884,47.5722575594826]} | Aeuss. Baselstrasse | 383 | Basel | 60.0 | 2025-04-07 | 2025-04-21 |
1765 | 1765 | 961 | 1 | Kantonsgrenze | 39364.0 | 55.0 | 60.0 | 2.88 | {"type":"Point","coordinates":[7.57863871065922,47.5449980368794]} | Binningerstrasse | 191 | Basel | 60.0 | 2024-12-16 | 2024-12-30 |
1766 | 1766 | 961 | 2 | Steinentorberg | 41986.0 | 56.0 | 61.0 | 3.62 | {"type":"Point","coordinates":[7.57863871065922,47.5449980368794]} | Binningerstrasse | 191 | Basel | 60.0 | 2024-12-16 | 2024-12-30 |
1745 | 1745 | 950 | 1 | Frankreich | 151042.0 | 58.0 | 67.0 | 19.82 | {"type":"Point","coordinates":[7.56414403196328,47.5749312404715]} | Autobahn A3 | Km 0.1 L | Basel | 60.0 | 2024-11-25 | 2024-12-09 |
1746 | 1746 | 950 | 2 | {"type":"Point","coordinates":[7.56414403196328,47.5749312404715]} | Autobahn A3 | Km 0.1 L | Basel | 60.0 | 2024-11-25 | 2024-12-09 | |||||
1591 | 1591 | 866 | 1 | Frankreich | 201276.0 | 53.0 | 59.0 | 2.82 | {"type":"Point","coordinates":[7.59850114785096,47.573468208731]} | Autobahn A3 | Km 3.0 | Basel | 60.0 | 2024-05-27 | 2024-06-10 |
1592 | 1592 | 866 | 2 | {"type":"Point","coordinates":[7.59850114785096,47.573468208731]} | Autobahn A3 | Km 3.0 | Basel | 60.0 | 2024-05-27 | 2024-06-10 | |||||
1589 | 1589 | 864 | 1 | Deutschland | 181819.0 | 67.0 | 77.0 | 58.71 | {"type":"Point","coordinates":[7.60215858924803,47.5860362735493]} | Autobahn A2 | Km 0.0 | Basel | 60.0 | 2024-05-27 | 2024-06-10 |
1590 | 1590 | 864 | 2 | {"type":"Point","coordinates":[7.60215858924803,47.5860362735493]} | Autobahn A2 | Km 0.0 | Basel | 60.0 | 2024-05-27 | 2024-06-10 | |||||
1587 | 1587 | 863 | 1 | Zürich | 402552.0 | 106.0 | 59.0 | 2.82 | {"type":"Point","coordinates":[7.59855170441712,47.5734861267371]} | Autobahn A3 | Km 3.0 | Basel | 60.0 | 2024-05-27 | 2024-06-10 |
1588 | 1588 | 863 | 2 | {"type":"Point","coordinates":[7.59855170441712,47.5734861267371]} | Autobahn A3 | Km 3.0 | Basel | 60.0 | 2024-05-27 | 2024-06-10 | |||||
1585 | 1585 | 862 | 1 | Luzern | 229150.0 | 63.0 | 72.0 | 35.41 | {"type":"Point","coordinates":[7.60207477242481,47.5860139070016]} | Autobahn A2 | Km 0.0 | Basel | 60.0 | 2024-05-27 | 2024-06-10 |
1586 | 1586 | 862 | 2 | {"type":"Point","coordinates":[7.60207477242481,47.5860139070016]} | Autobahn A2 | Km 0.0 | Basel | 60.0 | 2024-05-27 | 2024-06-10 | |||||
1433 | 1433 | 770 | 1 | St. Jakobs Sitasse | 78345.0 | 49.0 | 56.0 | 0.96 | {"type":"Point","coordinates":[7.61121998716795,47.5365199507547]} | Brueglingerstrasse | 24 | Basel | 60.0 | 2023-11-06 | 2023-11-20 |
1434 | 1434 | 770 | 2 | Münchensteinerstrasse | 53003.0 | 48.0 | 56.0 | 1.38 | {"type":"Point","coordinates":[7.61121998716795,47.5365199507547]} | Brueglingerstrasse | 24 | Basel | 60.0 | 2023-11-06 | 2023-11-20 |
1269 | 1269 | 681 | 1 | Münchensteinerstrasse | 101994.0 | 57.0 | 64.0 | 12.3 | {"type":"Point","coordinates":[7.61522999747253,47.5398767181351]} | Brüglingerstrasse | Höhe Walkeweg | Basel | 60.0 | 2023-04-17 | 2023-05-02 |
1270 | 1270 | 681 | 2 | keine | {"type":"Point","coordinates":[7.61522999747253,47.5398767181351]} | Brüglingerstrasse | Höhe Walkeweg | Basel | 60.0 | 2023-04-17 | 2023-05-02 | ||||
867 | 867 | 470 | 1 | Bettingerstrasse | 59001.0 | 59.0 | 63.0 | 8.1 | {"type":"Point","coordinates":[7.62401546270057,47.5722405371547]} | Aeussere Baselstrasse | 383-393 | Riehen | 60.0 | 2021-11-22 | 2021-12-02 |
868 | 868 | 470 | 2 | Riehenstrasse | 52253.0 | 62.0 | 67.0 | 21.9 | {"type":"Point","coordinates":[7.62401546270057,47.5722405371547]} | Aeussere Baselstrasse | 383-393 | Riehen | 60.0 | 2021-11-22 | 2021-12-02 |
859 | 859 | 466 | 1 | Luzern | 248009.0 | 54.0 | 62.0 | 8.1 | {"type":"Point","coordinates":[7.59791037420488,47.5710110433084]} | Autobahn A3 | Ausfahrt Riehenring | Basel | 60.0 | 2021-11-08 | 2021-11-18 |
860 | 860 | 466 | 2 | keine | {"type":"Point","coordinates":[7.59791037420488,47.5710110433084]} | Autobahn A3 | Ausfahrt Riehenring | Basel | 60.0 | 2021-11-08 | 2021-11-18 | ||||
855 | 855 | 464 | 1 | Steinentorberg | 55368.0 | 61.0 | 67.0 | 20.4 | {"type":"Point","coordinates":[7.57993159199378,47.5466702171275]} | Binningerstrasse | nach Rechtskurve | Basel | 60.0 | 2021-11-01 | 2021-11-13 |
856 | 856 | 464 | 2 | Kantonsgrenze | 55756.0 | 63.0 | 68.0 | 29.8 | {"type":"Point","coordinates":[7.57993159199378,47.5466702171275]} | Binningerstrasse | nach Rechtskurve | Basel | 60.0 | 2021-11-01 | 2021-11-13 |
773 | 773 | 420 | 1 | Birs / Kantonsgrenze | 62931.0 | 52.0 | 59.0 | 2.4 | {"type":"Point","coordinates":[7.61667255755296,47.5423118380003]} | St. Jakobs-Strasse | 351 | Basel | 60.0 | 2021-08-02 | 2021-08-16 |
774 | 774 | 420 | 2 | Aeschenplatz | 101401.0 | 52.0 | 59.0 | 2.1 | {"type":"Point","coordinates":[7.61667255755296,47.5423118380003]} | St. Jakobs-Strasse | 351 | Basel | 60.0 | 2021-08-02 | 2021-08-16 |
625 | 625 | 338 | 1 | Birs / Kantonsgrenze | 53273.0 | 40.0 | 46.0 | 0.0 | {"type":"Point","coordinates":[7.61889877054091,47.5407614799515]} | St. Jakobs-Strasse | 388 | Basel | 60.0 | 2021-01-25 | 2021-02-04 |
626 | 626 | 338 | 2 | {"type":"Point","coordinates":[7.61889877054091,47.5407614799515]} | St. Jakobs-Strasse | 388 | Basel | 60.0 | 2021-01-25 | 2021-02-04 | |||||
245 | 245 | 129 | 1 | Riehenstrasse | 61474.0 | 58.0 | 63.0 | 8.0 | {"type":"Point","coordinates":[7.62381602111373,47.5722138734029]} | Aeussere Baselstrasse | 383 | Riehen | 60.0 | 2018-07-23 | 2018-08-06 |
246 | 246 | 129 | 2 | Bettingerstrasse | 32272.0 | 62.0 | 68.0 | 25.3 | {"type":"Point","coordinates":[7.62381602111373,47.5722138734029]} | Aeussere Baselstrasse | 383 | Riehen | 60.0 | 2018-07-23 | 2018-08-06 |
199 | 199 | 104 | 1 | Greifengasse | 10503.0 | 22.0 | 28.0 | 2.3 | {"type":"Point","coordinates":[7.59298842980002,47.5601622619413]} | Utengasse | 30 | Basel | 60.0 | 2019-01-28 | 2019-02-09 |
200 | 200 | 104 | 2 | Lindenberg | 8308.0 | 27.0 | 33.0 | 9.0 | {"type":"Point","coordinates":[7.59298842980002,47.5601622619413]} | Utengasse | 30 | Basel | 60.0 | 2019-01-28 | 2019-02-09 |
147 | 147 | 76 | 1 | Kantonsgrenze | 74225.0 | 21.0 | 46.0 | 0.1 | {"type":"Point","coordinates":[7.60404984344197,47.5408914495707]} | Münchensteinerstrasse | OBI | Basel | 60.0 | 2019-06-12 | 2019-06-24 |
148 | 148 | 76 | 2 | keine | {"type":"Point","coordinates":[7.60404984344197,47.5408914495707]} | Münchensteinerstrasse | OBI | Basel | 60.0 | 2019-06-12 | 2019-06-24 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "Kennzahlen_pro_Richtung" ( "Messung-ID" INTEGER, "Richtung ID" INTEGER, "Richtung" TEXT, "Fzg" REAL, "V50" REAL, "V85" REAL, "Ue_Quote" REAL, "geometry" TEXT, "Strasse" TEXT, "Strasse_Nr" TEXT, "Ort" TEXT, "Zone" REAL, "Messbeginn" DATE, "Messende" DATE ); CREATE INDEX idx_Kennzahlen_pro_Richtung_messung_id ON "Kennzahlen_pro_Richtung" ("Messung-ID"); CREATE INDEX idx_Kennzahlen_pro_Richtung_richtung_id ON "Kennzahlen_pro_Richtung" ("Richtung ID"); CREATE INDEX idx_Kennzahlen_pro_Richtung_messbeginn ON "Kennzahlen_pro_Richtung" ("Messbeginn"); CREATE INDEX idx_Kennzahlen_pro_Richtung_messende ON "Kennzahlen_pro_Richtung" ("Messende"); CREATE INDEX idx_Kennzahlen_pro_Richtung_zone ON "Kennzahlen_pro_Richtung" ("Zone"); CREATE INDEX idx_Kennzahlen_pro_Richtung_ort ON "Kennzahlen_pro_Richtung" ("Ort"); CREATE INDEX idx_Kennzahlen_pro_Richtung_strasse ON "Kennzahlen_pro_Richtung" ("Strasse");