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
222 rows where Zone = "20.0" sorted by Messung-ID descending
This data as json, CSV (advanced)
Strasse >30
- Rheingasse 10
- Erlenmattstrasse 8
- Realpstrasse 8
- Efringerstrasse 6
- Gempenstrasse 6
- Niederholzstrasse 6
- Pfaffenlohweg 6
- Rittergasse 6
- Tangentenweg 6
- Altrheinweg 4
- Bergalingerstrasse 4
- Beuggenstrasse 4
- Davidsbodenstrasse 4
- Erlkönigweg 4
- Freie Strasse 4
- Fürstensteinerstrasse 4
- Haltingerstrasse 4
- Im Rheinacker 4
- Jungstrasse 4
- Marignanostrasse 4
- Mörsbergerstrasse 4
- Paradiesstrasse 4
- Rössligasse 4
- Scherkesselweg 4
- Sissacherstrasse 4
- Thiersteinerrain 4
- Webergasse 4
- Beim Wasserturm 2
- Biascastrasse 2
- Birkenstrasse 2
- …
Messung-ID >30
Messende (date) >30
- 2022-11-02 6
- 2024-06-03 6
- 2018-06-11 4
- 2019-05-10 4
- 2022-09-19 4
- 2023-01-18 4
- 2024-05-27 4
- 2018-02-05 2
- 2018-03-09 2
- 2018-06-18 2
- 2018-09-06 2
- 2018-11-23 2
- 2019-01-21 2
- 2019-02-01 2
- 2019-03-02 2
- 2019-06-24 2
- 2019-07-15 2
- 2019-08-05 2
- 2019-09-01 2
- 2019-10-05 2
- 2020-03-21 2
- 2020-03-25 2
- 2020-04-15 2
- 2020-06-22 2
- 2020-07-06 2
- 2020-07-13 2
- 2020-07-20 2
- 2020-07-27 2
- 2020-08-22 2
- 2021-01-03 2
- …
Messbeginn (date) >30
- 2021-04-26 6
- 2022-09-05 6
- 2022-10-24 6
- 2018-05-28 4
- 2020-03-16 4
- 2021-05-03 4
- 2021-09-20 4
- 2022-02-14 4
- 2022-07-04 4
- 2022-11-28 4
- 2023-01-09 4
- 2023-03-20 4
- 2023-07-03 4
- 2024-05-13 4
- 2024-05-24 4
- 2024-07-08 4
- 2025-03-03 4
- 2018-01-21 2
- 2018-01-22 2
- 2018-02-26 2
- 2018-06-04 2
- 2018-08-27 2
- 2018-11-06 2
- 2019-01-07 2
- 2019-02-18 2
- 2019-04-29 2
- 2019-05-06 2
- 2019-06-11 2
- 2019-07-01 2
- 2019-07-23 2
- …
Zone 1
- 20.0 · 222 ✖
Link | rowid | Messung-ID ▲ | Richtung ID | Richtung | Fzg | V50 | V85 | Ue_Quote | geometry | Strasse | Strasse_Nr | Ort | Zone | Messbeginn | Messende |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1933 | 1933 | 1052 | 1 | Erlkönigweg | 5067.0 | 21.0 | 26.0 | 17.9 | {"type":"Point","coordinates":[7.59857137084401,47.5694047640139]} | Tangentenweg | 11 | Basel | 20.0 | 2025-07-14 | 2025-07-28 |
1934 | 1934 | 1052 | 2 | Erlenstrasse | 5062.0 | 22.0 | 28.0 | 25.72 | {"type":"Point","coordinates":[7.59857137084401,47.5694047640139]} | Tangentenweg | 11 | Basel | 20.0 | 2025-07-14 | 2025-07-28 |
1921 | 1921 | 1046 | 1 | Erlkönigweg | 1272.0 | 22.0 | 28.0 | 25.39 | {"type":"Point","coordinates":[7.59882935231269,47.5712328272674]} | Tangentenweg | vis 42 | Basel | 20.0 | 2025-07-07 | 2025-07-14 |
1922 | 1922 | 1046 | 2 | Erlenstrasse | 1255.0 | 23.0 | 28.0 | 31.24 | {"type":"Point","coordinates":[7.59882935231269,47.5712328272674]} | Tangentenweg | vis 42 | Basel | 20.0 | 2025-07-07 | 2025-07-14 |
1915 | 1915 | 1042 | 1 | Allschwilerstrasse | 8130.0 | 16.0 | 20.0 | 1.88 | {"type":"Point","coordinates":[7.57363089208417,47.55653482902]} | Palmenstrasse | 20 | Basel | 20.0 | 2025-06-23 | 2025-07-05 |
1916 | 1916 | 1042 | 2 | {"type":"Point","coordinates":[7.57363089208417,47.55653482902]} | Palmenstrasse | 20 | Basel | 20.0 | 2025-06-23 | 2025-07-05 | |||||
1885 | 1885 | 1025 | 1 | Aeussere Baselstrasse | 3362.0 | 23.0 | 28.0 | 29.54 | {"type":"Point","coordinates":[7.64172262474171,47.5763346024603]} | Pfaffenlohweg | 51 | Riehen | 20.0 | 2025-05-05 | 2025-05-20 |
1886 | 1886 | 1025 | 2 | Meierweg | 4510.0 | 19.0 | 25.0 | 14.92 | {"type":"Point","coordinates":[7.64172262474171,47.5763346024603]} | Pfaffenlohweg | 51 | Riehen | 20.0 | 2025-05-05 | 2025-05-20 |
1829 | 1829 | 993 | 1 | Elsässerstrasse | 2850.0 | 22.0 | 28.0 | 27.16 | {"type":"Point","coordinates":[7.58003787673389,47.5697704764139]} | Wasserstrassse | 15 | Basel | 20.0 | 2025-03-03 | 2025-03-14 |
1830 | 1830 | 993 | 2 | Kehrplatz | 2719.0 | 21.0 | 26.0 | 19.05 | {"type":"Point","coordinates":[7.58003787673389,47.5697704764139]} | Wasserstrassse | 15 | Basel | 20.0 | 2025-03-03 | 2025-03-14 |
1827 | 1827 | 992 | 1 | Landskronstrasse | 5032.0 | 22.0 | 29.0 | 31.38 | {"type":"Point","coordinates":[7.57766061447588,47.5652486053931]} | Davidsbodenstrasse | 14 | Basel | 20.0 | 2025-03-03 | 2025-03-15 |
1828 | 1828 | 992 | 2 | St. Johanns-Ring | 2124.0 | 19.0 | 26.0 | 16.57 | {"type":"Point","coordinates":[7.57766061447588,47.5652486053931]} | Davidsbodenstrasse | 14 | Basel | 20.0 | 2025-03-03 | 2025-03-15 |
1817 | 1817 | 987 | 1 | Inzlingerstrasse | 14152.0 | 24.0 | 29.0 | 36.63 | {"type":"Point","coordinates":[7.65221646457704,47.5857744633692]} | Rössligasse | 32 | Riehen | 20.0 | 2025-02-17 | 2025-03-01 |
1818 | 1818 | 987 | 2 | Baselstrasse | 3352.0 | 21.0 | 26.0 | 16.23 | {"type":"Point","coordinates":[7.65221646457704,47.5857744633692]} | Rössligasse | 32 | Riehen | 20.0 | 2025-02-17 | 2025-03-01 |
1811 | 1811 | 984 | 1 | Gundeldingerstrasse | 4559.0 | 12.0 | 17.0 | 0.46 | {"type":"Point","coordinates":[7.5860421955819,47.5433673322675]} | Gempenstrasse | 61 | Basel | 20.0 | 2025-02-10 | 2025-02-21 |
1812 | 1812 | 984 | 2 | Güterstrasse | 2067.0 | 17.0 | 21.0 | 1.94 | {"type":"Point","coordinates":[7.5860421955819,47.5433673322675]} | Gempenstrasse | 61 | Basel | 20.0 | 2025-02-10 | 2025-02-21 |
1785 | 1785 | 971 | 1 | Marktplatz | 26729.0 | 16.0 | 22.0 | 4.49 | {"type":"Point","coordinates":[7.58684847776975,47.5586979582546]} | Stadthausgasse | 10 | Basel | 20.0 | 2025-01-13 | 2025-01-25 |
1786 | 1786 | 971 | 2 | {"type":"Point","coordinates":[7.58684847776975,47.5586979582546]} | Stadthausgasse | 10 | Basel | 20.0 | 2025-01-13 | 2025-01-25 | |||||
1707 | 1707 | 928 | 1 | St. Alban-Graben | 22320.0 | 18.0 | 23.0 | 7.06 | {"type":"Point","coordinates":[7.59300727901647,47.5556518808872]} | Rittergasse | 5 | Basel | 20.0 | 2024-10-14 | 2024-10-28 |
1708 | 1708 | 928 | 2 | Münsterplatz | 25943.0 | 17.0 | 23.0 | 5.86 | {"type":"Point","coordinates":[7.59300727901647,47.5556518808872]} | Rittergasse | 5 | Basel | 20.0 | 2024-10-14 | 2024-10-28 |
1699 | 1699 | 924 | 1 | Rauracherstrasse | 9117.0 | 22.0 | 28.0 | 27.07 | {"type":"Point","coordinates":[7.63512610107308,47.5744725386694]} | Niederholzstrasse | 35 | Riehen | 20.0 | 2024-09-30 | 2024-10-21 |
1700 | 1700 | 924 | 2 | {"type":"Point","coordinates":[7.63512610107308,47.5744725386694]} | Niederholzstrasse | 35 | Riehen | 20.0 | 2024-09-30 | 2024-10-21 | |||||
1677 | 1677 | 911 | 1 | Erlenmattstrasse 39 | 7317.0 | 21.0 | 28.0 | 25.17 | {"type":"Point","coordinates":[7.60014578778103,47.569287473335]} | Erlenmattstrasse | 16 | Basel | 20.0 | 2024-09-09 | 2024-09-23 |
1678 | 1678 | 911 | 2 | Erlenmattstrasse 78 | 14470.0 | 20.0 | 27.0 | 21.66 | {"type":"Point","coordinates":[7.60014578778103,47.569287473335]} | Erlenmattstrasse | 16 | Basel | 20.0 | 2024-09-09 | 2024-09-23 |
1665 | 1665 | 905 | 1 | {"type":"Point","coordinates":[7.59107710590609,47.5669100617829]} | Matthäusstrasse | ohne | Basel | 20.0 | 2024-08-26 | 2024-09-09 | |||||
1666 | 1666 | 905 | 2 | Müllheimerstrasse | 16232.0 | 15.0 | 20.0 | 1.69 | {"type":"Point","coordinates":[7.59107710590609,47.5669100617829]} | Matthäusstrasse | ohne | Basel | 20.0 | 2024-08-26 | 2024-09-09 |
1649 | 1649 | 897 | 1 | Oberalpstrasse | 4092.0 | 18.0 | 23.0 | 8.48 | {"type":"Point","coordinates":[7.56575574305623,47.5479213735221]} | Realpstrasse | 69 | Basel | 20.0 | 2024-08-12 | 2024-08-26 |
1650 | 1650 | 897 | 2 | St.Galler-Ring | 4887.0 | 20.0 | 25.0 | 14.08 | {"type":"Point","coordinates":[7.56575574305623,47.5479213735221]} | Realpstrasse | 69 | Basel | 20.0 | 2024-08-12 | 2024-08-26 |
1647 | 1647 | 896 | 1 | Eisengasse | 49982.0 | 17.0 | 22.0 | 3.83 | {"type":"Point","coordinates":[7.58771665555097,47.5584252405963]} | Marktplatz | vis 5 | Basel | 20.0 | 2024-07-08 | 2024-07-25 |
1648 | 1648 | 896 | 2 | Gerbergasse | 28744.0 | 18.0 | 23.0 | 6.58 | {"type":"Point","coordinates":[7.58771665555097,47.5584252405963]} | Marktplatz | vis 5 | Basel | 20.0 | 2024-07-08 | 2024-07-25 |
1627 | 1627 | 886 | 1 | Gibenacherweg | 522.0 | 19.0 | 24.0 | 10.92 | {"type":"Point","coordinates":[7.62318341926957,47.566068581746]} | Olsbergerweg | ohne | Basel | 20.0 | 2024-07-15 | 2024-07-29 |
1628 | 1628 | 886 | 2 | Zu den Drei Linden | 659.0 | 20.0 | 26.0 | 15.78 | {"type":"Point","coordinates":[7.62318341926957,47.566068581746]} | Olsbergerweg | ohne | Basel | 20.0 | 2024-07-15 | 2024-07-29 |
1625 | 1625 | 885 | 1 | Muensterplatz | 12224.0 | 17.0 | 21.0 | 2.41 | {"type":"Point","coordinates":[7.59217702819151,47.5561521301493]} | Rittergasse | vis 2 | Basel | 20.0 | 2024-07-08 | 2024-07-22 |
1626 | 1626 | 885 | 2 | St. Alban-Graben | 9820.0 | 15.0 | 20.0 | 1.25 | {"type":"Point","coordinates":[7.59217702819151,47.5561521301493]} | Rittergasse | vis 2 | Basel | 20.0 | 2024-07-08 | 2024-07-22 |
1621 | 1621 | 883 | 1 | Salmenweg | 3277.0 | 12.0 | 16.0 | 0.18 | {"type":"Point","coordinates":[7.59431104335605,47.5817759343862]} | Hunnenstrasse | 11 | Basel | 20.0 | 2024-07-01 | 2024-07-15 |
1622 | 1622 | 883 | 2 | Kleinhüningeranlage | 1976.0 | 16.0 | 24.0 | 8.65 | {"type":"Point","coordinates":[7.59431104335605,47.5817759343862]} | Hunnenstrasse | 11 | Basel | 20.0 | 2024-07-01 | 2024-07-15 |
1583 | 1583 | 861 | 1 | Beuggenstrasse | 1736.0 | 15.0 | 21.0 | 2.36 | {"type":"Point","coordinates":[7.61057737376122,47.5604955818256]} | Bergalingerstrasse | 30 | Basel | 20.0 | 2024-05-24 | 2024-06-03 |
1584 | 1584 | 861 | 2 | Beuggenstrasse | {"type":"Point","coordinates":[7.61057737376122,47.5604955818256]} | Bergalingerstrasse | 30 | Basel | 20.0 | 2024-05-24 | 2024-06-03 | ||||
1581 | 1581 | 860 | 1 | Erlenstrasse78 | 4655.0 | 23.0 | 28.0 | 29.6 | {"type":"Point","coordinates":[7.60068371531341,47.570069177964]} | Erlenmattstrasse | 22 | Basel | 20.0 | 2024-05-22 | 2024-06-03 |
1582 | 1582 | 860 | 2 | Erlenstrasse39 | 5188.0 | 23.0 | 28.0 | 28.82 | {"type":"Point","coordinates":[7.60068371531341,47.570069177964]} | Erlenmattstrasse | 22 | Basel | 20.0 | 2024-05-22 | 2024-06-03 |
1579 | 1579 | 859 | 1 | Schwörstadterstrasse | 8009.0 | 25.0 | 30.0 | 48.77 | {"type":"Point","coordinates":[7.61030549165057,47.5610643863441]} | Beuggenstrasse | 55 | Basel | 20.0 | 2024-05-24 | 2024-06-03 |
1580 | 1580 | 859 | 2 | Schwarzwaldstrasse | 2508.0 | 16.0 | 24.0 | 8.73 | {"type":"Point","coordinates":[7.61030549165057,47.5610643863441]} | Beuggenstrasse | 55 | Basel | 20.0 | 2024-05-24 | 2024-06-03 |
1577 | 1577 | 858 | 1 | Horburgstrasse | 8924.0 | 18.0 | 22.0 | 4.06 | {"type":"Point","coordinates":[7.59632591570233,47.5686478565571]} | Efringerstrasse | 25 | Basel | 20.0 | 2024-05-13 | 2024-05-27 |
1578 | 1578 | 858 | 2 | {"type":"Point","coordinates":[7.59632591570233,47.5686478565571]} | Efringerstrasse | 25 | Basel | 20.0 | 2024-05-13 | 2024-05-27 | |||||
1575 | 1575 | 857 | 1 | Efringerstrasse | 9128.0 | 15.0 | 21.0 | 2.9 | {"type":"Point","coordinates":[7.59244266833772,47.5685801965748]} | Bläsiring | 110 | Basel | 20.0 | 2024-05-13 | 2024-05-27 |
1576 | 1576 | 857 | 2 | {"type":"Point","coordinates":[7.59244266833772,47.5685801965748]} | Bläsiring | 110 | Basel | 20.0 | 2024-05-13 | 2024-05-27 | |||||
1545 | 1545 | 842 | 1 | Klybeckstrasse | 5829.0 | 22.0 | 28.0 | 25.37 | {"type":"Point","coordinates":[7.59646304957199,47.5664873840887]} | Haltingerstrasse | 89 | Basel | 20.0 | 2024-04-08 | 2024-04-22 |
1546 | 1546 | 842 | 2 | {"type":"Point","coordinates":[7.59646304957199,47.5664873840887]} | Haltingerstrasse | 89 | Basel | 20.0 | 2024-04-08 | 2024-04-22 | |||||
1511 | 1511 | 819 | 1 | Gotthardstrasse | 5065.0 | 25.0 | 30.0 | 47.48 | {"type":"Point","coordinates":[7.56141952437448,47.5471777361398]} | Göschenenstrasse | 20 | Basel | 20.0 | 2024-02-26 | 2024-03-04 |
1512 | 1512 | 819 | 2 | Steinbühlallee | 4857.0 | 23.0 | 29.0 | 32.02 | {"type":"Point","coordinates":[7.56141952437448,47.5471777361398]} | Göschenenstrasse | 20 | Basel | 20.0 | 2024-02-26 | 2024-03-04 |
1485 | 1485 | 803 | 1 | Allmendstrasse | 9076.0 | 20.0 | 28.0 | 22.8 | {"type":"Point","coordinates":[7.62361984669292,47.5669987382583]} | Zu den Drei Linden | vis 50 | Basel | 20.0 | 2024-01-29 | 2024-02-11 |
1486 | 1486 | 803 | 2 | {"type":"Point","coordinates":[7.62361984669292,47.5669987382583]} | Zu den Drei Linden | vis 50 | Basel | 20.0 | 2024-01-29 | 2024-02-11 | |||||
1479 | 1479 | 800 | 1 | Gotthardstrasse | 3284.0 | 18.0 | 21.0 | 2.13 | {"type":"Point","coordinates":[7.56418252894124,47.549444820225]} | Oberalpstrasse | 49 | Basel | 20.0 | 2024-01-22 | 2024-02-04 |
1480 | 1480 | 800 | 2 | Wanderstrasse | 2624.0 | 19.0 | 24.0 | 8.16 | {"type":"Point","coordinates":[7.56418252894124,47.549444820225]} | Oberalpstrasse | 49 | Basel | 20.0 | 2024-01-22 | 2024-02-04 |
1457 | 1457 | 786 | 1 | Bettingerstrasse | 837.0 | 21.0 | 26.0 | 18.04 | {"type":"Point","coordinates":[7.64951723774444,47.5822439766782]} | Sieglinweg | 14 | Riehen | 20.0 | 2023-12-11 | 2023-12-19 |
1458 | 1458 | 786 | 2 | {"type":"Point","coordinates":[7.64951723774444,47.5822439766782]} | Sieglinweg | 14 | Riehen | 20.0 | 2023-12-11 | 2023-12-19 | |||||
1435 | 1435 | 771 | 1 | Unterer Rheinweg | 5349.0 | 20.0 | 27.0 | 19.5 | {"type":"Point","coordinates":[7.58762507127319,47.5760817884709]} | Altrheinweg | 38 | Basel | 20.0 | 2023-11-06 | 2023-11-11 |
1436 | 1436 | 771 | 2 | Wiesendamm | 4532.0 | 21.0 | 26.0 | 18.78 | {"type":"Point","coordinates":[7.58762507127319,47.5760817884709]} | Altrheinweg | 38 | Basel | 20.0 | 2023-11-06 | 2023-11-11 |
1417 | 1417 | 759 | 1 | {"type":"Point","coordinates":[7.61223572275164,47.5560439214018]} | Homburgerstrasse | 10 | Basel | 20.0 | 2023-10-16 | 2023-10-24 | |||||
1418 | 1418 | 759 | 2 | St.Alban-Rheinweg | 3035.0 | 26.0 | 31.0 | 50.71 | {"type":"Point","coordinates":[7.61223572275164,47.5560439214018]} | Homburgerstrasse | 10 | Basel | 20.0 | 2023-10-16 | 2023-10-24 |
1401 | 1401 | 751 | 1 | Baselstrasse | 13751.0 | 19.0 | 24.0 | 8.7 | {"type":"Point","coordinates":[7.65055007142748,47.5849204135477]} | Schmiedgasse | 7 | Basel | 20.0 | 2023-09-25 | 2023-10-05 |
1402 | 1402 | 751 | 2 | {"type":"Point","coordinates":[7.65055007142748,47.5849204135477]} | Schmiedgasse | 7 | Basel | 20.0 | 2023-09-25 | 2023-10-05 | |||||
1379 | 1379 | 739 | 1 | Aeussere Baselstrasse | 1665.0 | 22.0 | 27.0 | 20.0 | {"type":"Point","coordinates":[7.64172001796608,47.5763480975335]} | Pfaffenlohweg | 51 | Riehen | 20.0 | 2023-09-04 | 2023-09-14 |
1380 | 1380 | 739 | 2 | Meierweg | 2409.0 | 18.0 | 24.0 | 11.83 | {"type":"Point","coordinates":[7.64172001796608,47.5763480975335]} | Pfaffenlohweg | 51 | Riehen | 20.0 | 2023-09-04 | 2023-09-14 |
1377 | 1377 | 737 | 1 | {"type":"Point","coordinates":[7.62594172552074,47.5633165965919]} | Im Rheinacker | 20 | Basel | 20.0 | 2023-08-28 | 2023-09-07 | |||||
1378 | 1378 | 737 | 2 | Allmendstrasse | 3305.0 | 21.0 | 26.0 | 20.09 | {"type":"Point","coordinates":[7.62594172552074,47.5633165965919]} | Im Rheinacker | 20 | Basel | 20.0 | 2023-08-28 | 2023-09-07 |
1333 | 1333 | 715 | 1 | Hauensteinstrasse | 757.0 | 25.0 | 31.0 | 47.7 | {"type":"Point","coordinates":[7.59536237942306,47.5360288273656]} | Thiersteinerrain | 124 | Basel | 20.0 | 2023-07-03 | 2023-07-15 |
1334 | 1334 | 715 | 2 | Gundeldingerrain | 2620.0 | 24.0 | 30.0 | 40.8 | {"type":"Point","coordinates":[7.59536237942306,47.5360288273656]} | Thiersteinerrain | 124 | Basel | 20.0 | 2023-07-03 | 2023-07-15 |
1331 | 1331 | 714 | 1 | Vogesenstrasse | 4464.0 | 18.0 | 22.0 | 6.2 | {"type":"Point","coordinates":[7.57969471307555,47.5676438835298]} | Jungstrasse | 14 | Basel | 20.0 | 2023-07-03 | 2023-07-17 |
1332 | 1332 | 714 | 2 | keine | {"type":"Point","coordinates":[7.57969471307555,47.5676438835298]} | Jungstrasse | 14 | Basel | 20.0 | 2023-07-03 | 2023-07-17 | ||||
1327 | 1327 | 712 | 1 | Missionsstrasse | 10528.0 | 14.0 | 19.0 | 1.2 | {"type":"Point","coordinates":[7.57710157349702,47.5618100759156]} | Friedensgasse | 50 | Basel | 20.0 | 2023-06-26 | 2023-07-10 |
1328 | 1328 | 712 | 2 | keine | {"type":"Point","coordinates":[7.57710157349702,47.5618100759156]} | Friedensgasse | 50 | Basel | 20.0 | 2023-06-26 | 2023-07-10 | ||||
1305 | 1305 | 701 | 1 | Hauensteinstrasse | 1440.0 | 17.0 | 24.0 | 7.6 | {"type":"Point","coordinates":[7.59513581524628,47.5357593179342]} | Thiersteinerrain | 130 | Basel | 20.0 | 2023-05-30 | 2023-06-11 |
1306 | 1306 | 701 | 2 | Gundeldingerrain | {"type":"Point","coordinates":[7.59513581524628,47.5357593179342]} | Thiersteinerrain | 130 | Basel | 20.0 | 2023-05-30 | 2023-06-11 | ||||
1299 | 1299 | 698 | 1 | Spalenring | 6898.0 | 19.0 | 24.0 | 10.6 | {"type":"Point","coordinates":[7.57636076022945,47.5579256655165]} | Nonnenweg | 32 | Basel | 20.0 | 2023-05-22 | 2023-06-05 |
1300 | 1300 | 698 | 2 | Socinstrasse | 9421.0 | 20.0 | 24.0 | 9.9 | {"type":"Point","coordinates":[7.57636076022945,47.5579256655165]} | Nonnenweg | 32 | Basel | 20.0 | 2023-05-22 | 2023-06-05 |
1265 | 1265 | 679 | 1 | Unterer Rheinweg | 2585.0 | 18.0 | 23.0 | 7.3 | {"type":"Point","coordinates":[7.59186767137266,47.5677994015441]} | Oetlingerstrasse | vis 84 | Basel | 20.0 | 2023-04-11 | 2023-04-19 |
1266 | 1266 | 679 | 2 | keine | {"type":"Point","coordinates":[7.59186767137266,47.5677994015441]} | Oetlingerstrasse | vis 84 | Basel | 20.0 | 2023-04-11 | 2023-04-19 | ||||
1261 | 1261 | 677 | 1 | Sperrstrasse | 5116.0 | 18.0 | 23.0 | 7.2 | {"type":"Point","coordinates":[7.59250382116415,47.5672049793703]} | Müllheimerstrasse | vis 77 | Basel | 20.0 | 2023-04-03 | 2023-04-12 |
1262 | 1262 | 677 | 2 | keine | {"type":"Point","coordinates":[7.59250382116415,47.5672049793703]} | Müllheimerstrasse | vis 77 | Basel | 20.0 | 2023-04-03 | 2023-04-12 | ||||
1249 | 1249 | 671 | 1 | Haltingerstrasse | 4473.0 | 20.0 | 24.0 | 9.1 | {"type":"Point","coordinates":[7.59345031155102,47.5682380015082]} | Mörsbergerstrasse | 54/52 | Basel | 20.0 | 2023-03-20 | 2023-03-27 |
1250 | 1250 | 671 | 2 | keine | {"type":"Point","coordinates":[7.59345031155102,47.5682380015082]} | Mörsbergerstrasse | 54/52 | Basel | 20.0 | 2023-03-20 | 2023-03-27 | ||||
1247 | 1247 | 670 | 1 | keine | {"type":"Point","coordinates":[7.59075939066479,47.5612714203778]} | Untere Rheingasse | Ecke Vogel Gryff-Gässli | Basel | 20.0 | 2023-03-20 | 2023-03-29 | ||||
1248 | 1248 | 670 | 2 | Greifengasse | 19684.0 | 23.0 | 28.0 | 30.7 | {"type":"Point","coordinates":[7.59075939066479,47.5612714203778]} | Untere Rheingasse | Ecke Vogel Gryff-Gässli | Basel | 20.0 | 2023-03-20 | 2023-03-29 |
1191 | 1191 | 640 | 1 | Hechtliacker | 1414.0 | 20.0 | 24.0 | 9.7 | {"type":"Point","coordinates":[7.59974900596643,47.5373359368176]} | Fürstensteinerstrasse | 65 | Basel | 20.0 | 2023-01-16 | 2023-01-24 |
1192 | 1192 | 640 | 2 | keine | {"type":"Point","coordinates":[7.59974900596643,47.5373359368176]} | Fürstensteinerstrasse | 65 | Basel | 20.0 | 2023-01-16 | 2023-01-24 | ||||
1187 | 1187 | 638 | 1 | Gundeldingerstrasse | 3017.0 | 19.0 | 24.0 | 7.9 | {"type":"Point","coordinates":[7.60137440156674,47.5390065229469]} | Falkensteinerstrasse | 43 | Basel | 20.0 | 2023-01-09 | 2023-01-18 |
1188 | 1188 | 638 | 2 | keine | {"type":"Point","coordinates":[7.60137440156674,47.5390065229469]} | Falkensteinerstrasse | 43 | Basel | 20.0 | 2023-01-09 | 2023-01-18 | ||||
1185 | 1185 | 637 | 1 | Tangentenweg | 2838.0 | 21.0 | 29.0 | 33.1 | {"type":"Point","coordinates":[7.59994905916624,47.5727889893126]} | Erlkönigweg | vis 39 | Basel | 20.0 | 2023-01-09 | 2023-01-18 |
1186 | 1186 | 637 | 2 | Erlenmattstrasse | 2160.0 | 20.0 | 27.0 | 22.0 | {"type":"Point","coordinates":[7.59994905916624,47.5727889893126]} | Erlkönigweg | vis 39 | Basel | 20.0 | 2023-01-09 | 2023-01-18 |
1177 | 1177 | 633 | 1 | Petersgasse | 2753.0 | 18.0 | 24.0 | 9.7 | {"type":"Point","coordinates":[7.58568093527734,47.5602706404515]} | Herbergsgasse | 6 | Basel | 20.0 | 2022-12-27 | 2023-01-09 |
1178 | 1178 | 633 | 2 | keine | {"type":"Point","coordinates":[7.58568093527734,47.5602706404515]} | Herbergsgasse | 6 | Basel | 20.0 | 2022-12-27 | 2023-01-09 | ||||
1161 | 1161 | 624 | 1 | Güterstrasse | 7680.0 | 19.0 | 25.0 | 11.9 | {"type":"Point","coordinates":[7.58744535199482,47.5449790320303]} | Gempenstrasse | 11 | Basel | 20.0 | 2022-12-05 | 2022-12-14 |
1162 | 1162 | 624 | 2 | keine | {"type":"Point","coordinates":[7.58744535199482,47.5449790320303]} | Gempenstrasse | 11 | Basel | 20.0 | 2022-12-05 | 2022-12-14 | ||||
1155 | 1155 | 621 | 1 | Mühlestiegstrasse | 614.0 | 22.0 | 28.0 | 27.2 | {"type":"Point","coordinates":[7.64874249483132,47.5775767615473]} | Unterm Schellenberg | vis 16 | Riehen | 20.0 | 2022-11-28 | 2022-12-07 |
1156 | 1156 | 621 | 2 | Grenzacherweg | 533.0 | 21.0 | 26.0 | 18.9 | {"type":"Point","coordinates":[7.64874249483132,47.5775767615473]} | Unterm Schellenberg | vis 16 | Riehen | 20.0 | 2022-11-28 | 2022-12-07 |
1145 | 1145 | 616 | 1 | Lachenstrasse | 2109.0 | 22.0 | 27.0 | 25.7 | {"type":"Point","coordinates":[7.5672418119402,47.5670916726259]} | Dammerkirchstrasse | 37 | Basel | 20.0 | 2022-11-28 | 2022-12-01 |
1146 | 1146 | 616 | 2 | Burgfelderstrasse | 2149.0 | 22.0 | 27.0 | 22.8 | {"type":"Point","coordinates":[7.5672418119402,47.5670916726259]} | Dammerkirchstrasse | 37 | Basel | 20.0 | 2022-11-28 | 2022-12-01 |
1125 | 1125 | 606 | 1 | Lindenberg | 19248.0 | 17.0 | 21.0 | 2.4 | {"type":"Point","coordinates":[7.59422033281635,47.5588655272957]} | Rheingasse | vis 69 | Basel | 20.0 | 2022-10-24 | 2022-11-02 |
1126 | 1126 | 606 | 2 | Greifengasse | 11659.0 | 23.0 | 26.0 | 18.9 | {"type":"Point","coordinates":[7.59422033281635,47.5588655272957]} | Rheingasse | vis 69 | Basel | 20.0 | 2022-10-24 | 2022-11-02 |
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");