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
97 rows where Ort = "Basel", Richtung ID = 2 and Zone = "20.0" sorted by Messung-ID descending
This data as json, CSV (advanced)
Strasse >30
- Rheingasse 5
- Erlenmattstrasse 4
- Realpstrasse 4
- Efringerstrasse 3
- Gempenstrasse 3
- Rittergasse 3
- Tangentenweg 3
- Altrheinweg 2
- Bergalingerstrasse 2
- Beuggenstrasse 2
- Davidsbodenstrasse 2
- Erlkönigweg 2
- Freie Strasse 2
- Fürstensteinerstrasse 2
- Haltingerstrasse 2
- Im Rheinacker 2
- Jungstrasse 2
- Marignanostrasse 2
- Mörsbergerstrasse 2
- Scherkesselweg 2
- Sissacherstrasse 2
- Thiersteinerrain 2
- Webergasse 2
- Beim Wasserturm 1
- Biascastrasse 1
- Birkenstrasse 1
- Bläsiring 1
- Chrischonastrasse 1
- Dammerkirchstrasse 1
- Dittingerstrasse 1
- …
Messung-ID >30
Messende (date) >30
- 2022-11-02 3
- 2024-06-03 3
- 2018-06-11 2
- 2019-05-10 2
- 2022-09-19 2
- 2023-01-18 2
- 2024-05-27 2
- 2018-02-05 1
- 2018-03-09 1
- 2018-06-18 1
- 2018-09-06 1
- 2018-11-23 1
- 2019-01-21 1
- 2019-02-01 1
- 2019-06-24 1
- 2019-08-05 1
- 2019-09-01 1
- 2020-03-21 1
- 2020-03-25 1
- 2020-04-15 1
- 2020-06-22 1
- 2020-07-06 1
- 2020-07-13 1
- 2020-07-20 1
- 2020-07-27 1
- 2020-08-22 1
- 2021-02-01 1
- 2021-04-09 1
- 2021-05-07 1
- 2021-05-10 1
- …
Messbeginn (date) >30
- 2022-09-05 3
- 2022-10-24 3
- 2018-05-28 2
- 2020-03-16 2
- 2021-04-26 2
- 2021-05-03 2
- 2021-09-20 2
- 2022-02-14 2
- 2022-07-04 2
- 2023-01-09 2
- 2023-03-20 2
- 2023-07-03 2
- 2024-05-13 2
- 2024-05-24 2
- 2024-07-08 2
- 2025-03-03 2
- 2018-01-21 1
- 2018-01-22 1
- 2018-02-26 1
- 2018-06-04 1
- 2018-08-27 1
- 2018-11-06 1
- 2019-01-07 1
- 2019-04-29 1
- 2019-05-06 1
- 2019-06-11 1
- 2019-07-23 1
- 2019-08-19 1
- 2020-03-30 1
- 2020-06-08 1
- …
Zone 1
- 20.0 · 97 ✖
Richtung ID 1
- 2 · 97 ✖
Ort 1
- Basel · 97 ✖
| Link | rowid | Messung-ID ▲ | Richtung ID | Richtung | Fzg | V50 | V85 | Ue_Quote | geometry | Strasse | Strasse_Nr | Ort | Zone | Messbeginn | Messende |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 1916 | 1916 | 1042 | 2 | {"type":"Point","coordinates":[7.57363089208417,47.55653482902]} | Palmenstrasse | 20 | Basel | 20.0 | 2025-06-23 | 2025-07-05 | |||||
| 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 |
| 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 |
| 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 |
| 1786 | 1786 | 971 | 2 | {"type":"Point","coordinates":[7.58684847776975,47.5586979582546]} | Stadthausgasse | 10 | Basel | 20.0 | 2025-01-13 | 2025-01-25 | |||||
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 1584 | 1584 | 861 | 2 | Beuggenstrasse | {"type":"Point","coordinates":[7.61057737376122,47.5604955818256]} | Bergalingerstrasse | 30 | Basel | 20.0 | 2024-05-24 | 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 |
| 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 |
| 1578 | 1578 | 858 | 2 | {"type":"Point","coordinates":[7.59632591570233,47.5686478565571]} | Efringerstrasse | 25 | 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 | |||||
| 1546 | 1546 | 842 | 2 | {"type":"Point","coordinates":[7.59646304957199,47.5664873840887]} | Haltingerstrasse | 89 | Basel | 20.0 | 2024-04-08 | 2024-04-22 | |||||
| 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 |
| 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 | |||||
| 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 |
| 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 |
| 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 |
| 1402 | 1402 | 751 | 2 | {"type":"Point","coordinates":[7.65055007142748,47.5849204135477]} | Schmiedgasse | 7 | Basel | 20.0 | 2023-09-25 | 2023-10-05 | |||||
| 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 |
| 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 |
| 1332 | 1332 | 714 | 2 | keine | {"type":"Point","coordinates":[7.57969471307555,47.5676438835298]} | Jungstrasse | 14 | Basel | 20.0 | 2023-07-03 | 2023-07-17 | ||||
| 1328 | 1328 | 712 | 2 | keine | {"type":"Point","coordinates":[7.57710157349702,47.5618100759156]} | Friedensgasse | 50 | Basel | 20.0 | 2023-06-26 | 2023-07-10 | ||||
| 1306 | 1306 | 701 | 2 | Gundeldingerrain | {"type":"Point","coordinates":[7.59513581524628,47.5357593179342]} | Thiersteinerrain | 130 | Basel | 20.0 | 2023-05-30 | 2023-06-11 | ||||
| 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 |
| 1266 | 1266 | 679 | 2 | keine | {"type":"Point","coordinates":[7.59186767137266,47.5677994015441]} | Oetlingerstrasse | vis 84 | Basel | 20.0 | 2023-04-11 | 2023-04-19 | ||||
| 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 | ||||
| 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 | ||||
| 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 |
| 1192 | 1192 | 640 | 2 | keine | {"type":"Point","coordinates":[7.59974900596643,47.5373359368176]} | Fürstensteinerstrasse | 65 | Basel | 20.0 | 2023-01-16 | 2023-01-24 | ||||
| 1188 | 1188 | 638 | 2 | keine | {"type":"Point","coordinates":[7.60137440156674,47.5390065229469]} | Falkensteinerstrasse | 43 | 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 |
| 1178 | 1178 | 633 | 2 | keine | {"type":"Point","coordinates":[7.58568093527734,47.5602706404515]} | Herbergsgasse | 6 | Basel | 20.0 | 2022-12-27 | 2023-01-09 | ||||
| 1162 | 1162 | 624 | 2 | keine | {"type":"Point","coordinates":[7.58744535199482,47.5449790320303]} | Gempenstrasse | 11 | Basel | 20.0 | 2022-12-05 | 2022-12-14 | ||||
| 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 |
| 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 |
| 1124 | 1124 | 605 | 2 | Greifengasse | 11586.0 | 23.0 | 28.0 | 29.9 | {"type":"Point","coordinates":[7.59257495599841,47.5596141916172]} | Rheingasse | 46 | Basel | 20.0 | 2022-10-24 | 2022-11-02 |
| 1122 | 1122 | 604 | 2 | Greifengasse | 19766.0 | 15.0 | 20.0 | 1.4 | {"type":"Point","coordinates":[7.59146193523346,47.5606859094864]} | Rheingasse | 7 | Basel | 20.0 | 2022-10-24 | 2022-11-02 |
| 1096 | 1096 | 590 | 2 | Güterstrasse | 6218.0 | 16.0 | 20.0 | 1.4 | {"type":"Point","coordinates":[7.59463914098402,47.5430449546144]} | Tellplatz | Ecke Tellstrasse 1 | Basel | 20.0 | 2022-09-19 | 2022-10-03 |
| 1092 | 1092 | 588 | 2 | Münsterplatz | 23585.0 | 15.0 | 20.0 | 1.2 | {"type":"Point","coordinates":[7.59248468972336,47.5559538621852]} | Rittergasse | 4 | Basel | 20.0 | 2022-09-12 | 2022-09-24 |
| 1088 | 1088 | 586 | 2 | Feldbergstrasse | 4249.0 | 19.0 | 24.0 | 9.8 | {"type":"Point","coordinates":[7.59651584799738,47.5713097324286]} | Efringerstrasse | 104 | Basel | 20.0 | 2022-09-05 | 2022-09-18 |
| 1086 | 1086 | 585 | 2 | Tangentenweg | 4473.0 | 17.0 | 22.0 | 3.1 | {"type":"Point","coordinates":[7.60000140342295,47.5725191063077]} | Erlkönigweg | 37 | Basel | 20.0 | 2022-09-05 | 2022-09-19 |
| 1084 | 1084 | 584 | 2 | Erlenstrasse 39 | 14077.0 | 19.0 | 25.0 | 12.9 | {"type":"Point","coordinates":[7.60103087591601,47.5701703234208]} | Erlenmattstrasse | 24 | Basel | 20.0 | 2022-09-05 | 2022-09-19 |
| 1046 | 1046 | 564 | 2 | Bruderholzallee | 1862.0 | 9.0 | 14.0 | 31.2 | {"type":"Point","coordinates":[7.59015977165044,47.5372588672795]} | Wolfschlucht-Promenade | vis 10 | Basel | 20.0 | 2022-07-04 | 2022-07-18 |
| 1044 | 1044 | 563 | 2 | Greifengasse | 15282.0 | 19.0 | 25.0 | 11.1 | {"type":"Point","coordinates":[7.59166031209703,47.5603618752019]} | Rheingasse | 8 | Basel | 20.0 | 2022-07-04 | 2022-07-17 |
| 1034 | 1034 | 557 | 2 | Oberalpstrasse | 4611.0 | 19.0 | 23.0 | 4.4 | {"type":"Point","coordinates":[7.5679288519998,47.5489685568069]} | Realpstrasse | 27 | Basel | 20.0 | 2022-06-13 | 2022-06-27 |
| 1006 | 1006 | 541 | 2 | Käferholzstrasse | 1587.0 | 17.0 | 23.0 | 5.3 | {"type":"Point","coordinates":[7.61751740240648,47.5684913342288]} | Tüllingerstrasse | 59 | Basel | 20.0 | 2022-05-02 | 2022-05-15 |
| 994 | 994 | 535 | 2 | Erlkönigweg | 6995.0 | 21.0 | 26.0 | 17.3 | {"type":"Point","coordinates":[7.5986357463496,47.569157349027]} | Tangentenweg | 47.569185 / 7.598653 | Basel | 20.0 | 2022-04-25 | 2022-05-08 |
| 982 | 982 | 528 | 2 | Lehenmattstrasse | 5376.0 | 23.0 | 29.0 | 32.7 | {"type":"Point","coordinates":[7.61765195701331,47.5531478283856]} | Nasenweg | 5 | Basel | 20.0 | 2022-04-04 | 2022-04-16 |
| 970 | 970 | 522 | 2 | keine | {"type":"Point","coordinates":[7.60922042267882,47.5462532768083]} | Sissacherstrasse | 39 | Basel | 20.0 | 2022-03-21 | 2022-03-29 | ||||
| 940 | 940 | 507 | 2 | Lindenberg | 9914.0 | 20.0 | 24.0 | 10.4 | {"type":"Point","coordinates":[7.59241611118468,47.5598212569935]} | Rheingasse | 31 | Basel | 20.0 | 2022-02-14 | 2022-02-20 |
| 938 | 938 | 506 | 2 | Untere Rheingasse | 14815.0 | 21.0 | 27.0 | 20.0 | {"type":"Point","coordinates":[7.59084149736871,47.5621077289874]} | Webergasse | 15 | Basel | 20.0 | 2022-02-14 | 2022-03-23 |
| 904 | 904 | 488 | 2 | keine | {"type":"Point","coordinates":[7.5964480919894,47.566372284931]} | Haltingerstrasse | 90 | Basel | 20.0 | 2022-01-03 | 2022-01-13 | ||||
| 874 | 874 | 473 | 2 | keine | {"type":"Point","coordinates":[7.58832231339698,47.5403371189926]} | Dittingerstrasse | 41/43 | Basel | 20.0 | 2021-12-06 | 2021-12-16 | ||||
| 854 | 854 | 463 | 2 | St. Johanns-Ring | 4268.0 | 18.0 | 23.0 | 6.2 | {"type":"Point","coordinates":[7.57768184270829,47.5652359889026]} | Davidsbodenstrasse | 14 | Basel | 20.0 | 2021-11-01 | 2021-11-15 |
| 820 | 820 | 444 | 2 | Reservoirstrasse | 340.0 | 18.0 | 26.0 | 20.6 | {"type":"Point","coordinates":[7.5930257352995,47.5271100832131]} | Beim Wasserturm | 21 | Basel | 20.0 | 2021-09-20 | 2021-10-04 |
| 818 | 818 | 443 | 2 | Giornicostrasse | 2014.0 | 11.0 | 21.0 | 6.1 | {"type":"Point","coordinates":[7.59209700985004,47.5273811254302]} | Biascastrasse | 11 | Basel | 20.0 | 2021-09-20 | 2021-10-03 |
| 798 | 798 | 433 | 2 | {"type":"Point","coordinates":[7.59342196073433,47.5676264676579]} | Mörsbergerstrasse | vis 44 | Basel | 20.0 | 2021-08-30 | 2021-09-13 | |||||
| 746 | 746 | 406 | 2 | Allmendstrasse | 4487.0 | 16.0 | 21.0 | 1.7 | {"type":"Point","coordinates":[7.62583159291014,47.5633608429593]} | Im Rheinacker | vis 20 | Basel | 20.0 | 2021-06-28 | 2021-07-12 |
| 730 | 730 | 397 | 2 | Türkheimerstrasse | 1829.0 | 16.0 | 23.0 | 9.0 | {"type":"Point","coordinates":[7.57118155892148,47.5589209755302]} | Pfeffelstrasse | 31 | Basel | 20.0 | 2021-06-07 | 2021-06-21 |
| 702 | 702 | 382 | 2 | Hardrain | 1711.0 | 21.0 | 25.0 | 14.7 | {"type":"Point","coordinates":[7.6166310357514,47.5457924948063]} | Scherkesselweg | vis 19 | Basel | 20.0 | 2021-05-03 | 2021-05-17 |
| 698 | 698 | 380 | 2 | Hardrain | 9196.0 | 20.0 | 28.0 | 24.0 | {"type":"Point","coordinates":[7.61513249803579,47.5465412595497]} | Scherkesselweg | Höhe Neusatzweglein | Basel | 20.0 | 2021-05-03 | 2021-05-16 |
| 696 | 696 | 379 | 2 | {"type":"Point","coordinates":[7.56333291085153,47.5662145318788]} | Markircherstrasse | 22 | Basel | 20.0 | 2021-04-26 | 2021-05-10 | |||||
| 694 | 694 | 378 | 2 | keine | {"type":"Point","coordinates":[7.60103073908893,47.5701253551461]} | Erlenmattstrasse | 24 | Basel | 20.0 | 2021-04-26 | 2021-05-07 | ||||
| 664 | 664 | 362 | 2 | keine | {"type":"Point","coordinates":[7.57968142435134,47.5676438996012]} | Jungstrasse | 14 | Basel | 20.0 | 2021-03-29 | 2021-04-09 | ||||
| 606 | 606 | 328 | 2 | Lothringerstrasse | 3234.0 | 17.0 | 25.0 | 12.7 | {"type":"Point","coordinates":[7.57971962789582,47.5670142945624]} | Fatiostrasse | 29 | Basel | 20.0 | 2021-01-18 | 2021-02-01 |
| 484 | 484 | 263 | 2 | Schwörstadterstrasse | 2503.0 | 20.0 | 24.0 | 8.5 | {"type":"Point","coordinates":[7.61107553934715,47.5612880919316]} | Beuggenstrasse | vis 59 (Schwarzwaldallee) | Basel | 20.0 | 2020-08-17 | 2020-08-22 |
| 456 | 456 | 249 | 2 | Zum Bischofstein | 1117.0 | 20.0 | 26.0 | 18.0 | {"type":"Point","coordinates":[7.60308518362734,47.5597437319387]} | Chrischonastrasse | 48 | Basel | 20.0 | 2020-07-13 | 2020-07-20 |
| 454 | 454 | 248 | 2 | keine | {"type":"Point","coordinates":[7.59790939214449,47.5395059715665]} | Laufenstrasse | 73 | Basel | 20.0 | 2020-07-14 | 2020-07-27 | ||||
| 436 | 436 | 236 | 2 | Marktplatz | 11984.0 | 19.0 | 27.0 | 20.6 | {"type":"Point","coordinates":[7.59106036329772,47.5549934037614]} | Freie Strasse | 70 | Basel | 20.0 | 2020-06-29 | 2020-07-13 |
| 432 | 432 | 233 | 2 | Kleinriehenstrasse | 898.0 | 15.0 | 22.0 | 5.0 | {"type":"Point","coordinates":[7.61689965022385,47.5665586347221]} | Hirzbrunnenschanze | 57 | Basel | 20.0 | 2020-06-22 | 2020-07-06 |
| 422 | 422 | 227 | 2 | St. Alban-Graben | 13741.0 | 8.0 | 25.0 | 17.9 | {"type":"Point","coordinates":[7.59106036329772,47.5549934037614]} | Freie Strasse | 70 | Basel | 20.0 | 2020-06-08 | 2020-06-22 |
| 360 | 360 | 191 | 2 | keine | {"type":"Point","coordinates":[7.5995898221188,47.5373991135078]} | Fürstensteinerstrasse | 63 | Basel | 20.0 | 2020-03-30 | 2020-04-15 | ||||
| 312 | 312 | 165 | 2 | keine | {"type":"Point","coordinates":[7.59053265506327,47.5656426603348]} | Kandererstrasse | vis 29 | Basel | 20.0 | 2018-05-28 | 2018-06-11 | ||||
| 298 | 298 | 158 | 2 | keine | {"type":"Point","coordinates":[7.58579334939798,47.5432003625104]} | Gempenstrasse | 68 | Basel | 20.0 | 2018-08-27 | 2018-09-06 | ||||
| 278 | 278 | 145 | 2 | Oberalpstrasse | 1231.0 | 18.0 | 22.0 | 5.1 | {"type":"Point","coordinates":[7.56790224041351,47.5489505987877]} | Realpstrasse | 27 | Basel | 20.0 | 2020-03-16 | 2020-03-21 |
| 276 | 276 | 144 | 2 | Oberalpstrasse | 1827.0 | 18.0 | 22.0 | 3.0 | {"type":"Point","coordinates":[7.56864704362405,47.5493185150342]} | Realpstrasse | 11 | Basel | 20.0 | 2020-03-16 | 2020-03-25 |
| 270 | 270 | 141 | 2 | Horburgstrasse | 12539.0 | 22.0 | 26.0 | 20.2 | {"type":"Point","coordinates":[7.59629524482288,47.5686119232631]} | Efringerstrasse | 25 | Basel | 20.0 | 2018-06-04 | 2018-06-18 |
| 260 | 260 | 136 | 2 | keine | {"type":"Point","coordinates":[7.57292955238577,47.5565985947134]} | Birkenstrasse | 43 | Basel | 20.0 | 2018-02-26 | 2018-03-09 | ||||
| 258 | 258 | 135 | 2 | keine | {"type":"Point","coordinates":[7.61058107584428,47.5604074378366]} | Bergalingerstrasse | 28 | Basel | 20.0 | 2018-01-22 | 2018-02-05 | ||||
| 256 | 256 | 134 | 2 | Wiesendamm | 21511.0 | 21.0 | 27.0 | 23.2 | {"type":"Point","coordinates":[7.5877594792075,47.5766185387455]} | Altrheinweg | 42 | Basel | 20.0 | 2018-05-28 | 2018-06-11 |
| 224 | 224 | 118 | 2 | Ensisheimerstrasse | 7208.0 | 18.0 | 22.0 | 5.3 | {"type":"Point","coordinates":[7.56941064451827,47.5627992658611]} | Hagentalerstrasse | 64 | Basel | 20.0 | 2018-11-06 | 2018-11-23 |
| 210 | 210 | 111 | 2 | keine | {"type":"Point","coordinates":[7.59074607792212,47.5612624440323]} | Webergasse | 15 | Basel | 20.0 | 2019-04-29 | 2019-05-10 | ||||
| 202 | 202 | 105 | 2 | Elsässerstrasse | 5641.0 | 17.0 | 22.0 | 4.9 | {"type":"Point","coordinates":[7.57940743270891,47.5695688810067]} | Wasserstrasse | keine | Basel | 20.0 | 2019-01-07 | 2019-01-21 |
| 196 | 196 | 100 | 2 | St. Johanns-Ring | 12193.0 | 16.0 | 27.0 | 20.4 | {"type":"Point","coordinates":[7.58526333447601,47.5630322375988]} | St. Johanns-Rheinweg | 49 | Basel | 20.0 | 2019-07-23 | 2019-08-05 |
| 178 | 178 | 91 | 2 | Speiserstrasse | 5604.0 | 21.0 | 26.0 | 19.6 | {"type":"Point","coordinates":[7.60850329298333,47.5463082877729]} | Sissacherstrasse | 29 | Basel | 20.0 | 2019-08-19 | 2019-09-01 |
| 72 | 72 | 37 | 2 | Unterer Batterieweg | 640.0 | 24.0 | 32.0 | 42.0 | {"type":"Point","coordinates":[7.58628999646262,47.5354650757601]} | Marignanostrasse | 15 | Basel | 20.0 | 2019-05-06 | 2019-05-10 |
| 70 | 70 | 36 | 2 | Schäublinstrasse | 2139.0 | 22.0 | 29.0 | 27.6 | {"type":"Point","coordinates":[7.58631650808867,47.5354470545596]} | Marignanostrasse | 15 | Basel | 20.0 | 2019-06-11 | 2019-06-24 |
| 16 | 16 | 8 | 2 | keine | {"type":"Point","coordinates":[7.59270937776494,47.5831774740324]} | Dorfstrasse | vis 28 | Basel | 20.0 | 2018-01-21 | 2019-02-01 |
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");