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
249 rows where Richtung ID = 2 and Zone = "50.0" sorted by Messung-ID descending
This data as json, CSV (advanced)
Strasse >30
- Riehenring 10
- Schwarzwaldstrasse 9
- Grenzacherstrasse 7
- Hochbergerstrasse 6
- Zürcherstrasse 6
- Elsässerstrasse 5
- Fasanenstrasse 5
- Klybeckstrasse 5
- Schwarzwaldallee 5
- Gundeldingerstrasse 4
- Kohlistieg 4
- Lehenmattstrasse 4
- Münchensteinerstrasse 4
- Rütimeyerstrasse 4
- Wanderstrasse 4
- Allschwilerstrasse 3
- Arnold Böcklin-Strasse 3
- Bundesstrasse 3
- Burgfelderstrasse 3
- Bäumlihofstrasse 3
- Feldbergstrasse 3
- Grosspeterstrasse 3
- Gundeldingerrain 3
- Heuwaage-Viadukt 3
- Kleinhüningeranlage 3
- Metzerstrasse 3
- Neuweilerstrasse 3
- Riehenstrasse 3
- Rudolf Wackernagel-Strasse 3
- Aeschengraben 2
- …
Messung-ID >30
Messende (date) >30
- 2019-09-16 3
- 2020-10-05 3
- 2020-12-14 3
- 2021-10-11 3
- 2024-07-08 3
- 2025-06-23 3
- 2019-04-08 2
- 2020-01-11 2
- 2020-03-23 2
- 2020-04-06 2
- 2020-05-04 2
- 2020-06-29 2
- 2020-08-10 2
- 2020-08-24 2
- 2020-10-19 2
- 2020-11-02 2
- 2021-11-08 2
- 2022-02-09 2
- 2022-05-22 2
- 2022-08-08 2
- 2023-03-20 2
- 2024-01-21 2
- 2024-09-16 2
- 2024-10-07 2
- 2024-12-16 2
- 2024-12-23 2
- 2025-01-26 2
- 2025-03-09 2
- 2025-03-31 2
- 2018-01-22 1
- …
Messbeginn (date) >30
- 2020-09-21 4
- 2019-12-16 3
- 2020-01-02 3
- 2020-02-24 3
- 2020-03-09 3
- 2020-03-23 3
- 2020-10-05 3
- 2020-11-30 3
- 2020-12-14 3
- 2021-02-08 3
- 2021-08-16 3
- 2021-09-06 3
- 2023-03-06 3
- 2024-06-24 3
- 2024-12-02 3
- 2025-06-10 3
- 2025-06-30 3
- 2018-04-23 2
- 2019-04-01 2
- 2019-09-09 2
- 2019-09-16 2
- 2020-01-13 2
- 2020-01-27 2
- 2020-02-10 2
- 2020-04-06 2
- 2020-04-20 2
- 2020-06-02 2
- 2020-07-27 2
- 2020-08-10 2
- 2020-09-07 2
- …
Zone 1
- 50.0 · 249 ✖
Richtung ID 1
- 2 · 249 ✖
| Link | rowid | Messung-ID ▲ | Richtung ID | Richtung | Fzg | V50 | V85 | Ue_Quote | geometry | Strasse | Strasse_Nr | Ort | Zone | Messbeginn | Messende |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1932 | 1932 | 1051 | 2 | Grenzacherstrasse | 85059.0 | 42.0 | 48.0 | 1.96 | {"type":"Point","coordinates":[7.60290304285225,47.5717964566866]} | Schwarzwaldallee | Y-Brücke | Basel | 50.0 | 2025-06-30 | 2025-07-15 |
| 1930 | 1930 | 1050 | 2 | Wielandplatz | 14887.0 | 48.0 | 54.0 | 10.12 | {"type":"Point","coordinates":[7.60697534296563,47.5613606434046]} | Wettsteinallee | 119 vis | Basel | 50.0 | 2025-06-30 | 2025-07-14 |
| 1928 | 1928 | 1049 | 2 | Schwarzwaldallee | 46489.0 | 32.0 | 40.0 | 0.16 | {"type":"Point","coordinates":[7.60198287874612,47.5690249948015]} | Erlenstrasse | Höhe Jägerstr. | Basel | 50.0 | 2025-06-30 | 2025-07-21 |
| 1920 | 1920 | 1045 | 2 | Schwarzwaldallee | 30476.0 | 37.0 | 43.0 | 0.19 | {"type":"Point","coordinates":[7.61542063914724,47.5713707201654]} | Fasanenstrasse | vis 221 | Basel | 50.0 | 2025-06-23 | 2025-07-04 |
| 1918 | 1918 | 1044 | 2 | Im Surinam | 14269.0 | 36.0 | 43.0 | 0.32 | {"type":"Point","coordinates":[7.60831888931105,47.5693666937575]} | Maulbeerstrasse | vis 151 | Basel | 50.0 | 2025-06-23 | 2025-07-07 |
| 1910 | 1910 | 1037 | 2 | Hochbergerplatz | 95435.0 | 33.0 | 41.0 | 0.17 | {"type":"Point","coordinates":[7.59390945180678,47.5840041969409]} | Kleinhüningeranlage | 60 | Basel | 50.0 | 2025-06-16 | 2025-06-30 |
| 1908 | 1908 | 1036 | 2 | {"type":"Point","coordinates":[7.61567640279556,47.5547337489214]} | Baldeggerstrasse | Autobahnauffahrt | Basel | 50.0 | 2025-06-10 | 2025-06-23 | |||||
| 1906 | 1906 | 1035 | 2 | St.Alban-Anlage | 116184.0 | 41.0 | 48.0 | 2.26 | {"type":"Point","coordinates":[7.61220468092257,47.5550780396613]} | Zürcherstrasse | 111 | Basel | 50.0 | 2025-06-10 | 2025-06-23 |
| 1904 | 1904 | 1034 | 2 | Klingelbergstrasse | 36082.0 | 26.0 | 35.0 | 0.05 | {"type":"Point","coordinates":[7.57709114901949,47.5644533398655]} | Metzerstrasse | 29 | Basel | 50.0 | 2025-06-10 | 2025-06-23 |
| 1902 | 1902 | 1033 | 2 | {"type":"Point","coordinates":[7.60949664908908,47.5640766730494]} | Schwarzwaldstrasse | 160 | Basel | 50.0 | 2025-06-02 | 2025-06-12 | |||||
| 1898 | 1898 | 1031 | 2 | Freiburgerstrasse | 195608.0 | 38.0 | 44.0 | 0.54 | {"type":"Point","coordinates":[7.5975117399137,47.576387110331]} | Hochbergerstrasse | 17 | Basel | 50.0 | 2025-06-02 | 2025-06-16 |
| 1894 | 1894 | 1029 | 2 | Wettsteinplatz | 106319.0 | 40.0 | 44.0 | 0.22 | {"type":"Point","coordinates":[7.63062391253201,47.5628367986362]} | Grenzacherstrasse | 511 | Basel | 50.0 | 2025-05-26 | 2025-06-10 |
| 1874 | 1874 | 1016 | 2 | Steinbühlallee | 28315.0 | 43.0 | 50.0 | 2.58 | {"type":"Point","coordinates":[7.56165474288762,47.5518416480661]} | Wanderstrasse | 137 | Basel | 50.0 | 2025-04-28 | 2025-05-11 |
| 1856 | 1856 | 1007 | 2 | Schwarzwaldallee | 42649.0 | 42.0 | 48.0 | 0.79 | {"type":"Point","coordinates":[7.60560609550861,47.5730400390254]} | Fasanenstrasse | vis 54 | Basel | 50.0 | 2025-04-07 | 2025-04-21 |
| 1852 | 1852 | 1005 | 2 | Heuwaage-Viadukt | 73794.0 | 40.0 | 46.0 | 0.44 | {"type":"Point","coordinates":[7.58511012325079,47.5551323417369]} | Steinengraben | 25 | Basel | 50.0 | 2025-03-31 | 2025-04-13 |
| 1844 | 1844 | 1001 | 2 | Margarethenstrasse | 68868.0 | 31.0 | 36.0 | 0.03 | {"type":"Point","coordinates":[7.59293041523734,47.541923906976]} | Dornacherstrasse | vis 182 | Basel | 50.0 | 2025-03-24 | 2025-04-06 |
| 1842 | 1842 | 1000 | 2 | Hochbergerstrasse | 61812.0 | 31.0 | 39.0 | 0.13 | {"type":"Point","coordinates":[7.59763812117352,47.5683960489142]} | Riehenring | vis 153 | Basel | 50.0 | 2025-03-17 | 2025-03-31 |
| 1840 | 1840 | 999 | 2 | Wettsteinallee | 99938.0 | 29.0 | 35.0 | 0.04 | {"type":"Point","coordinates":[7.59753045381467,47.5697263633696]} | Riehenring | vis 182 | Basel | 50.0 | 2025-03-17 | 2025-03-31 |
| 1836 | 1836 | 997 | 2 | Dorenbach-Promenade | 19898.0 | 40.0 | 46.0 | 0.54 | {"type":"Point","coordinates":[7.56674318451274,47.5475560462463]} | Neubadstrasse | 116 | Basel | 50.0 | 2025-03-10 | 2025-03-19 |
| 1826 | 1826 | 991 | 2 | St.Alban-Anlage | 2506.0 | 32.0 | 38.0 | 0.04 | {"type":"Point","coordinates":[7.60492037072319,47.5534365165225]} | St.Alban-Talstrasse | vis 15 | Basel | 50.0 | 2025-02-24 | 2025-03-09 |
| 1824 | 1824 | 990 | 2 | Oberwilerstrasse | 54503.0 | 39.0 | 47.0 | 1.63 | {"type":"Point","coordinates":[7.57576510438988,47.5494740496906]} | Rütimeyerstrasse | 27 | Basel | 50.0 | 2025-02-24 | 2025-03-09 |
| 1798 | 1798 | 977 | 2 | Markthallenbrücke | 88897.0 | 40.0 | 47.0 | 1.26 | {"type":"Point","coordinates":[7.59031406518489,47.5490360184748]} | Elisabethenanlage | Mittelinsel Höhe Hotel Euler | Basel | 50.0 | 2025-01-27 | 2025-02-08 |
| 1796 | 1796 | 976 | 2 | Nauenstrasse | 73317.0 | 31.0 | 40.0 | 0.47 | {"type":"Point","coordinates":[7.58963965940228,47.5491870900806]} | Elisabethenanlage | 7 | Basel | 50.0 | 2025-01-20 | 2025-01-31 |
| 1792 | 1792 | 974 | 2 | {"type":"Point","coordinates":[7.59966178295629,47.5524563907584]} | St.Alban-Anlage | 29 | Basel | 50.0 | 2025-01-20 | 2025-02-03 | |||||
| 1790 | 1790 | 973 | 2 | Birs / Kantonsgrenze | 41092.0 | 38.0 | 45.0 | 0.25 | {"type":"Point","coordinates":[7.59611731782663,47.5501921119197]} | St.Jakobs-Strasse | 18 | Basel | 50.0 | 2025-01-13 | 2025-01-26 |
| 1788 | 1788 | 972 | 2 | {"type":"Point","coordinates":[7.60007544831342,47.5521833075965]} | St.Alban-Anlage | 40 | Basel | 50.0 | 2025-01-13 | 2025-01-26 | |||||
| 1778 | 1778 | 967 | 2 | Aeschenplatz | 65314.0 | 35.0 | 43.0 | 0.47 | {"type":"Point","coordinates":[7.59490834945785,47.5537939380568]} | Dufourstrasse | 11 | Basel | 50.0 | 2024-12-30 | 2025-01-13 |
| 1772 | 1772 | 964 | 2 | Adlerstrasse | 11090.0 | 40.0 | 49.0 | 2.82 | {"type":"Point","coordinates":[7.61081423608187,47.5449567268113]} | Zeughaustrasse | vis 47 | Basel | 50.0 | 2024-12-23 | 2025-01-02 |
| 1762 | 1762 | 958 | 2 | {"type":"Point","coordinates":[7.58422684767453,47.5430251525279]} | Gundeldingerstrasse | 97 | Basel | 50.0 | 2024-12-16 | 2024-12-28 | |||||
| 1760 | 1760 | 957 | 2 | {"type":"Point","coordinates":[7.61373081929387,47.5577963615072]} | Schwarzwaldbrücke | mitte | Basel | 50.0 | 2024-12-09 | 2024-12-23 | |||||
| 1758 | 1758 | 956 | 2 | St. Jakobs-Strasse | 241146.0 | 45.0 | 52.0 | 6.01 | {"type":"Point","coordinates":[7.60056168369492,47.5451773912151]} | Grosspeterstrasse | vis 11 | Basel | 50.0 | 2024-12-09 | 2024-12-23 |
| 1754 | 1754 | 954 | 2 | Holbeinstrasse | 69881.0 | 44.0 | 51.0 | 3.55 | {"type":"Point","coordinates":[7.58384589425502,47.5494741583297]} | Viaduktstrasse | Brücke | Basel | 50.0 | 2024-12-02 | 2024-12-14 |
| 1752 | 1752 | 953 | 2 | Viaduktstrasse | 16618.0 | 30.0 | 40.0 | 0.34 | {"type":"Point","coordinates":[7.58667359609541,47.5502494604917]} | Innere Margarethenstrasse | 10 | Basel | 50.0 | 2024-12-02 | 2024-12-16 |
| 1750 | 1750 | 952 | 2 | Margarethenstrasse | 80444.0 | 43.0 | 48.0 | 1.49 | {"type":"Point","coordinates":[7.57834977013792,47.5442231204729]} | Dorenbachviadukt | Brücke | Basel | 50.0 | 2024-12-02 | 2024-12-16 |
| 1744 | 1744 | 949 | 2 | Kannenfeldstrasse | 35054.0 | 33.0 | 40.0 | 0.18 | {"type":"Point","coordinates":[7.57399437278879,47.5668079281999]} | Entenweidstrasse | 24 | Basel | 50.0 | 2024-11-25 | 2024-12-09 |
| 1740 | 1740 | 947 | 2 | Vogesenstrasse | 7848.0 | 37.0 | 43.0 | 0.46 | {"type":"Point","coordinates":[7.57587880102629,47.5720247647508]} | Hüningerstrasse | 46 | Basel | 50.0 | 2024-11-25 | 2024-12-02 |
| 1730 | 1730 | 942 | 2 | Aeussere Baselstrasse | 17992.0 | 45.0 | 52.0 | 5.51 | {"type":"Point","coordinates":[7.62936628261698,47.5708360738912]} | Bäumlihofstrasse | 383 | Basel | 50.0 | 2024-11-04 | 2024-11-18 |
| 1720 | 1720 | 937 | 2 | St. Alban-Anlage | 71491.0 | 50.0 | 56.0 | 16.6 | {"type":"Point","coordinates":[7.60753430633855,47.5532483834855]} | Zürcherstrasse | vis 27 | Basel | 50.0 | 2024-10-28 | 2024-11-11 |
| 1716 | 1716 | 933 | 2 | Elisabethenanlage | 100160.0 | 57.0 | 63.0 | 60.69 | {"type":"Point","coordinates":[7.58762495742204,47.5503201982703]} | Heuwaage-Viadukt | ohne | Basel | 50.0 | 2024-09-23 | 2024-10-07 |
| 1702 | 1702 | 925 | 2 | St. Jakobs-Denkmal | 174404.0 | 46.0 | 54.0 | 9.4 | {"type":"Point","coordinates":[7.6013177639173,47.5422137870044]} | Münchensteinerstrasse | Höhe Delsbergerallee | Basel | 50.0 | 2024-09-30 | 2024-10-21 |
| 1686 | 1686 | 916 | 2 | Dreirosenstrasse | 58789.0 | 30.0 | 36.0 | 0.07 | {"type":"Point","coordinates":[7.58275444757373,47.570843695589]} | Dreirosenbrücke | ohne | Basel | 50.0 | 2024-09-23 | 2024-10-07 |
| 1670 | 1670 | 907 | 2 | Kohlistieg | 60627.0 | 47.0 | 53.0 | 6.38 | {"type":"Point","coordinates":[7.63580478775953,47.5642869200971]} | Hörnliallee | Höhe Hirentweg | Basel | 50.0 | 2024-09-02 | 2024-09-16 |
| 1668 | 1668 | 906 | 2 | Untere Rebgasse | 19925.0 | 44.0 | 53.0 | 9.45 | {"type":"Point","coordinates":[7.58939709173671,47.5752628853381]} | Klybeckstrasse | vis 228 | Basel | 50.0 | 2024-09-02 | 2024-09-16 |
| 1640 | 1640 | 892 | 2 | Landesgrenze | 94752.0 | 45.0 | 51.0 | 3.38 | {"type":"Point","coordinates":[7.62079393623847,47.5609423265904]} | Grenzacherstrasse | 351 | Basel | 50.0 | 2024-07-29 | 2024-08-12 |
| 1632 | 1632 | 888 | 2 | {"type":"Point","coordinates":[7.59473569025062,47.552901989879]} | Brunngässlein | 12 | Basel | 50.0 | 2024-07-22 | 2024-08-05 | |||||
| 1618 | 1618 | 881 | 2 | {"type":"Point","coordinates":[7.60018563118348,47.539862588226]} | Dornacherstrasse | 291 | Basel | 50.0 | 2024-07-01 | 2024-07-15 | |||||
| 1616 | 1616 | 880 | 2 | {"type":"Point","coordinates":[7.6027593172046,47.5725970973319]} | Schwarzwaldallee | Y-Brücke | Basel | 50.0 | 2024-06-24 | 2024-07-08 | |||||
| 1614 | 1614 | 877 | 2 | Holbeinplatz | 81133.0 | 38.0 | 51.0 | 4.93 | {"type":"Point","coordinates":[7.58112165749545,47.5570808305584]} | Schützengraben | 16 | Basel | 50.0 | 2024-06-24 | 2024-07-08 |
| 1612 | 1612 | 876 | 2 | {"type":"Point","coordinates":[7.60865278152303,47.5644664362307]} | Schwarzwaldstrasse | A2 Einfahrt Riehenstrasse | Basel | 50.0 | 2024-06-24 | 2024-07-08 | |||||
| 1562 | 1562 | 850 | 2 | {"type":"Point","coordinates":[7.62223876829489,47.5468108741997]} | Birsstrasse | vis 214 | Basel | 50.0 | 2024-04-29 | 2024-05-13 | |||||
| 1560 | 1560 | 849 | 2 | {"type":"Point","coordinates":[7.60091274883853,47.5741528923517]} | Schwarzwaldallee | Höhe Signalstr. | Basel | 50.0 | 2024-04-22 | 2024-05-06 | |||||
| 1556 | 1556 | 847 | 2 | Teststrasse | 50.0 | 2023-03-06 | 2023-03-20 | ||||||||
| 1552 | 1552 | 845 | 2 | Münchensteinerstrasse | 68407.0 | 43.0 | 50.0 | 2.3 | {"type":"Point","coordinates":[7.60464694099761,47.534719055663]} | Reinacherstrasse | 148 | Basel | 50.0 | 2024-04-15 | 2024-04-25 |
| 1550 | 1550 | 844 | 2 | Münchensteinerstrasse | 65887.0 | 37.0 | 45.0 | 0.81 | {"type":"Point","coordinates":[7.60604357320112,47.536684001149]} | Leimgrubenweg | vis 16 | Basel | 50.0 | 2024-04-15 | 2024-04-27 |
| 1542 | 1542 | 840 | 2 | Wettsteinallee | 3648.0 | 34.0 | 79.0 | 33.2 | {"type":"Point","coordinates":[7.59797521903149,47.5655769620902]} | Riehenring | 99 | Basel | 50.0 | 2024-04-02 | 2024-04-10 |
| 1540 | 1540 | 839 | 2 | Riehen | 27746.0 | 47.0 | 52.0 | 5.05 | {"type":"Point","coordinates":[7.6141190628373,47.5687905980685]} | Riehenstrasse | Höhe Hermann Albrecht-Strasse | Basel | 50.0 | 2024-04-02 | 2024-04-15 |
| 1524 | 1524 | 826 | 2 | Schwarzwaldallee | 17389.0 | 48.0 | 56.0 | 15.53 | {"type":"Point","coordinates":[7.59515412201591,47.5737353668119]} | Mauerstrasse | vis 70 | Basel | 50.0 | 2024-03-12 | 2024-03-19 |
| 1510 | 1510 | 816 | 2 | Neubadstrasse | 40884.0 | 45.0 | 52.0 | 4.39 | {"type":"Point","coordinates":[7.56113341415676,47.5463739946261]} | Neuweilerstrasse | 62 | Basel | 50.0 | 2024-02-26 | 2024-03-04 |
| 1502 | 1502 | 812 | 2 | Flughafenstrasse | 25936.0 | 47.0 | 54.0 | 11.72 | {"type":"Point","coordinates":[7.5659507011207,47.5745740341117]} | Neudorfstrasse | vis 91 | Basel | 50.0 | 2024-02-12 | 2024-02-24 |
| 1500 | 1500 | 811 | 2 | St. Johanns-Vorstadt | 42370.0 | 45.0 | 51.0 | 4.87 | {"type":"Point","coordinates":[7.5853343470101,47.5646977833648]} | Johanniterbrücke | Mitte | Basel | 50.0 | 2024-02-12 | 2024-02-21 |
| 1496 | 1496 | 809 | 2 | Münchensteinerstrasse | 56462.0 | 45.0 | 52.0 | 5.42 | {"type":"Point","coordinates":[7.59611222947769,47.5462141774662]} | Nauenstr | 73 | Basel | 50.0 | 2024-02-05 | 2024-02-12 |
| 1490 | 1490 | 805 | 2 | {"type":"Point","coordinates":[7.60029863119265,47.5469171518766]} | St.Jakobs-Strasse | 87 | Basel | 50.0 | 2024-01-29 | 2024-02-10 | |||||
| 1478 | 1478 | 799 | 2 | BaselRiehenstrasse | 36973.0 | 51.0 | 55.0 | 14.77 | {"type":"Point","coordinates":[7.63352656303222,47.5746470066854]} | Aeussere Baselstrasse | 283 | Riehen | 50.0 | 2024-01-15 | 2024-01-21 |
| 1472 | 1472 | 794 | 2 | Kannenfeldstrasse | 30817.0 | 34.0 | 42.0 | 0.22 | {"type":"Point","coordinates":[7.56934886923061,47.5619890016676]} | Strassburgerallee | 86 | Basel | 50.0 | 2024-01-08 | 2024-01-21 |
| 1462 | 1462 | 788 | 2 | Wettsteinstrasse | 43031.0 | 40.0 | 44.0 | 0.45 | {"type":"Point","coordinates":[7.5960285508083,47.5565831879438]} | Wettsteinbrücke | keine | Basel | 50.0 | 2023-12-18 | 2023-12-26 |
| 1460 | 1460 | 787 | 2 | Johnniterbrücke | 26565.0 | 23.0 | 36.0 | 0.23 | {"type":"Point","coordinates":[7.59570864470011,47.567068497112]} | Feldbergstrasse | 116 | Basel | 50.0 | 2023-12-11 | 2023-12-17 |
| 1456 | 1456 | 785 | 2 | Rauracherstrasse | 30247.0 | 48.0 | 53.0 | 6.68 | {"type":"Point","coordinates":[7.63946324444901,47.5685958496785]} | Kohlistieg | ohne | Basel | 50.0 | 2023-11-27 | 2023-12-04 |
| 1454 | 1454 | 784 | 2 | Wetssteinstrasse | 38165.0 | 39.0 | 43.0 | 0.18 | {"type":"Point","coordinates":[7.59576859874847,47.556285846108]} | Wettsteinbrücke | ohne | Basel | 50.0 | 2023-12-11 | 2023-12-18 |
| 1442 | 1442 | 778 | 2 | Wettsteinplatz | 57914.0 | 34.0 | 42.0 | 0.45 | {"type":"Point","coordinates":[7.60742796395068,47.5591106573409]} | Grenzacherstrasse | Höhe Roche | Basel | 50.0 | 2023-10-30 | 2023-11-22 |
| 1438 | 1438 | 775 | 2 | Grenzacherweg | 47678.0 | 43.0 | 47.0 | 0.68 | {"type":"Point","coordinates":[7.64238808781208,47.5692724893269]} | Kohlistieg | Höhe Morystrasse | Riehen | 50.0 | 2023-11-13 | 2023-11-27 |
| 1420 | 1420 | 760 | 2 | Landesgrenze | 100361.0 | 46.0 | 53.0 | 7.2 | {"type":"Point","coordinates":[7.62488374271926,47.5620942481278]} | Grenzacherstrasse | keine | Basel | 50.0 | 2023-10-16 | 2023-10-30 |
| 1416 | 1416 | 758 | 2 | Grenzacherweg | 18560.0 | 41.0 | 47.0 | 0.85 | {"type":"Point","coordinates":[7.6467021669591,47.5700572022804]} | Rudolf Wackernagel-Strasse | 38 | Riehen | 50.0 | 2023-10-09 | 2023-10-23 |
| 1410 | 1410 | 755 | 2 | {"type":"Point","coordinates":[7.6073646167545,47.562608408693]} | Kienbergstrasse | 14 | Basel | 50.0 | 2023-10-02 | 2023-10-13 | |||||
| 1408 | 1408 | 754 | 2 | {"type":"Point","coordinates":[7.58188117557871,47.5628601649959]} | Schanzenstrasse | ohne | Basel | 50.0 | 2023-10-02 | 2023-10-15 | |||||
| 1384 | 1384 | 741 | 2 | Unterer Batterieweg | 7853.0 | 29.0 | 40.0 | 0.55 | {"type":"Point","coordinates":[7.59318022995824,47.5323199988224]} | Bruderholzallee | keine | Basel | 50.0 | 2023-09-04 | 2023-09-18 |
| 1376 | 1376 | 736 | 2 | Bruderholzallee | 18883.0 | 40.0 | 49.0 | 2.63 | {"type":"Point","coordinates":[7.59449665045406,47.5383674769901]} | Gundeldingerrain | Keine | Basel | 50.0 | 2023-08-21 | 2023-09-04 |
| 1372 | 1372 | 734 | 2 | Dorfstrasse | 101465.0 | 42.0 | 49.0 | 1.94 | {"type":"Point","coordinates":[7.59961435859066,47.5816707008045]} | Neuhausstrasse | 96 | Basel | 50.0 | 2023-08-21 | 2023-09-01 |
| 1368 | 1368 | 732 | 2 | Untere Rebgasse | 40155.0 | 31.0 | 39.0 | 0.26 | {"type":"Point","coordinates":[7.5904564988636,47.568768969759]} | Klybeckstrasse | vis 91 | Basel | 50.0 | 2023-08-15 | 2023-08-28 |
| 1358 | 1358 | 727 | 2 | Kantonsgrenze | 52919.0 | 24.0 | 30.0 | 0.13 | {"type":"Point","coordinates":[7.55762879868497,47.5634971919856]} | Belforterstrasse | 135 | Basel | 50.0 | 2023-07-31 | 2023-08-12 |
| 1356 | 1356 | 726 | 2 | Freiburgerstrasse | 69012.0 | 37.0 | 45.0 | 0.73 | {"type":"Point","coordinates":[7.59545897376919,47.579335315934]} | Hochbergerstr | 70 | Basel | 50.0 | 2023-07-31 | 2023-08-15 |
| 1322 | 1322 | 709 | 2 | keine | {"type":"Point","coordinates":[7.60143015595388,47.5616527258035]} | Riehenring | 22 | Basel | 50.0 | 2023-06-19 | 2023-07-03 | ||||
| 1280 | 1280 | 687 | 2 | keine | {"type":"Point","coordinates":[7.60361003833697,47.5704994670899]} | Signalstrasse | zw. 13 + 21 | Basel | 50.0 | 2023-05-02 | 2023-05-12 | ||||
| 1278 | 1278 | 686 | 2 | Allschwilerplatz | 7776.0 | 36.0 | 43.0 | 0.2 | {"type":"Point","coordinates":[7.57158966118738,47.5574005714986]} | Ahornstrasse | 51 | Basel | 50.0 | 2023-04-24 | 2023-05-02 |
| 1236 | 1236 | 663 | 2 | Landesgrenze | 11507.0 | 47.0 | 53.0 | 6.8 | {"type":"Point","coordinates":[7.64895434264852,47.5908420271841]} | Weilstrasse | Ohne (47.59083/7.648963) | Riehen | 50.0 | 2023-03-06 | 2023-03-13 |
| 1232 | 1232 | 661 | 2 | Mittlere Strasse | 26614.0 | 36.0 | 43.0 | 0.5 | {"type":"Point","coordinates":[7.57612611417214,47.5648421101037]} | Metzerstrasse | Heberlplatz 2 | Basel | 50.0 | 2023-03-06 | 2023-03-20 |
| 1224 | 1224 | 657 | 2 | Wettsteinplatz | 23158.0 | 37.0 | 44.0 | 0.5 | {"type":"Point","coordinates":[7.60185999861657,47.5588280946073]} | Grenzacherstrasse | 79 | Basel | 50.0 | 2023-02-20 | 2023-02-28 |
| 1216 | 1216 | 653 | 2 | Bundesplatz | {"type":"Point","coordinates":[7.57731366818914,47.5513770949352]} | Arnold Böcklin-Strasse | 29 | Basel | 50.0 | 2023-02-13 | 2023-02-25 | ||||
| 1212 | 1212 | 651 | 2 | keine | {"type":"Point","coordinates":[7.61864399930182,47.5518601919069]} | Lehenmattstrasse | vis 137 | Basel | 50.0 | 2023-02-06 | 2023-02-13 | ||||
| 1206 | 1206 | 648 | 2 | Spalenring | 19842.0 | 45.0 | 52.0 | 5.7 | {"type":"Point","coordinates":[7.56896277195748,47.5644006469147]} | Burgfelderstrasse | 70 | Basel | 50.0 | 2023-01-30 | 2023-02-07 |
| 1202 | 1202 | 645 | 2 | Claragraben | 43434.0 | 45.0 | 51.0 | 3.5 | {"type":"Point","coordinates":[7.60229820957926,47.5630815109332]} | Riehenstrasse | 88 | Basel | 50.0 | 2023-01-23 | 2023-02-03 |
| 1198 | 1198 | 643 | 2 | keine | {"type":"Point","coordinates":[7.60041472441432,47.5378836356203]} | Gundeldingerstrasse | 436 | Basel | 50.0 | 2023-01-23 | 2023-02-06 | ||||
| 1170 | 1170 | 628 | 2 | Isteinerstrasse | 23602.0 | 42.0 | 49.0 | 3.5 | {"type":"Point","coordinates":[7.59922915559369,47.5676276040724]} | Schönaustrasse | 10 | Basel | 50.0 | 2022-12-19 | 2022-12-29 |
| 1152 | 1152 | 619 | 2 | keine | {"type":"Point","coordinates":[7.61591016848094,47.5607142284102]} | Grenzacherstrasse | 47.560796N 7.615889E | Basel | 50.0 | 2022-11-28 | 2022-12-12 | ||||
| 1150 | 1150 | 618 | 2 | Flughafenstrasse | 66444.0 | 46.0 | 53.0 | 7.0 | {"type":"Point","coordinates":[7.56688558758922,47.5681623142252]} | Luzernerring | vis 95 | Basel | 50.0 | 2022-11-21 | 2022-11-30 |
| 1148 | 1148 | 617 | 2 | Kehrplatz Hafenbecken 1 | 10892.0 | 41.0 | 49.0 | 3.8 | {"type":"Point","coordinates":[7.60128152033182,47.5826441978157]} | Grenzstrasse | B: 47.582704 / L: 7.601261 | Basel | 50.0 | 2022-11-21 | 2022-12-05 |
| 1140 | 1140 | 613 | 2 | Wettsteinallee | 40456.0 | 35.0 | 41.0 | 0.1 | {"type":"Point","coordinates":[7.60143015595388,47.5616527258035]} | Riehenring | 22 | Basel | 50.0 | 2022-11-14 | 2022-11-28 |
| 1136 | 1136 | 611 | 2 | Kantonsgrenze | 19707.0 | 36.0 | 43.0 | 0.6 | {"type":"Point","coordinates":[7.57399072100035,47.5559228382069]} | Allschwilerstrasse | vis 22 | Basel | 50.0 | 2022-11-07 | 2022-11-18 |
| 1112 | 1112 | 599 | 2 | Viaduktstrasse | 54940.0 | 43.0 | 49.0 | 2.5 | {"type":"Point","coordinates":[7.57845828954793,47.5521941590452]} | Steinenring | 15 | Basel | 50.0 | 2022-10-10 | 2022-10-23 |
| 1110 | 1110 | 598 | 2 | Reinacherstrasse | 3777.0 | 32.0 | 43.0 | 1.4 | {"type":"Point","coordinates":[7.60118104613,47.5322074769936]} | Jakobsbergerstrasse | 47.532170 / 7.601278 | Basel | 50.0 | 2022-10-10 | 2022-10-21 |
| 1090 | 1090 | 587 | 2 | Kantonsgrenze | 27650.0 | 39.0 | 46.0 | 1.2 | {"type":"Point","coordinates":[7.55677588531491,47.5455177834627]} | Herrenweg | vis 6 | Basel | 50.0 | 2022-09-12 | 2022-09-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");