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
472 rows where Ort = "Basel" and Zone = "50.0" sorted by Messung-ID descending
This data as json, CSV (advanced)
Strasse >30
- Riehenring 20
- Schwarzwaldstrasse 18
- Grenzacherstrasse 14
- Hochbergerstrasse 12
- Zürcherstrasse 12
- Elsässerstrasse 10
- Fasanenstrasse 10
- Klybeckstrasse 10
- Schwarzwaldallee 10
- Gundeldingerstrasse 8
- Lehenmattstrasse 8
- Münchensteinerstrasse 8
- Rütimeyerstrasse 8
- Wanderstrasse 8
- Allschwilerstrasse 6
- Arnold Böcklin-Strasse 6
- Bundesstrasse 6
- Burgfelderstrasse 6
- Feldbergstrasse 6
- Grosspeterstrasse 6
- Gundeldingerrain 6
- Heuwaage-Viadukt 6
- Kleinhüningeranlage 6
- Metzerstrasse 6
- Neuweilerstrasse 6
- Riehenstrasse 6
- Aeschengraben 4
- Ahornstrasse 4
- Baldeggerstrasse 4
- Belforterstrasse 4
- …
Messung-ID >30
Messende (date) >30
- 2019-09-16 6
- 2020-10-05 6
- 2020-12-14 6
- 2021-10-11 6
- 2024-07-08 6
- 2025-06-23 6
- 2019-04-08 4
- 2020-01-11 4
- 2020-03-23 4
- 2020-04-06 4
- 2020-05-04 4
- 2020-08-10 4
- 2020-10-19 4
- 2021-11-08 4
- 2022-02-09 4
- 2022-05-22 4
- 2022-08-08 4
- 2024-09-16 4
- 2024-10-07 4
- 2024-12-16 4
- 2024-12-23 4
- 2025-01-26 4
- 2025-03-09 4
- 2025-03-31 4
- 2018-01-22 2
- 2018-05-01 2
- 2018-05-04 2
- 2018-05-06 2
- 2018-06-04 2
- 2018-06-27 2
- …
Messbeginn (date) >30
- 2020-09-21 8
- 2020-01-02 6
- 2020-02-24 6
- 2020-03-23 6
- 2020-10-05 6
- 2020-11-30 6
- 2020-12-14 6
- 2021-02-08 6
- 2021-08-16 6
- 2021-09-06 6
- 2024-06-24 6
- 2024-12-02 6
- 2025-06-10 6
- 2025-06-30 6
- 2018-04-23 4
- 2019-04-01 4
- 2019-09-09 4
- 2019-09-16 4
- 2019-12-16 4
- 2020-02-10 4
- 2020-03-09 4
- 2020-04-06 4
- 2020-04-20 4
- 2020-06-02 4
- 2020-07-27 4
- 2020-09-07 4
- 2021-03-08 4
- 2021-10-04 4
- 2021-10-25 4
- 2022-01-31 4
- …
Zone 1
- 50.0 · 472 ✖
Ort 1
- Basel · 472 ✖
| Link | rowid | Messung-ID ▲ | Richtung ID | Richtung | Fzg | V50 | V85 | Ue_Quote | geometry | Strasse | Strasse_Nr | Ort | Zone | Messbeginn | Messende |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1931 | 1931 | 1051 | 1 | {"type":"Point","coordinates":[7.60290304285225,47.5717964566866]} | Schwarzwaldallee | Y-Brücke | Basel | 50.0 | 2025-06-30 | 2025-07-15 | |||||
| 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 |
| 1929 | 1929 | 1050 | 1 | Schwarzwaldallee | 32923.0 | 50.0 | 55.0 | 13.15 | {"type":"Point","coordinates":[7.60697534296563,47.5613606434046]} | Wettsteinallee | 119 vis | Basel | 50.0 | 2025-06-30 | 2025-07-14 |
| 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 |
| 1927 | 1927 | 1049 | 1 | Riehenring | 33939.0 | 31.0 | 39.0 | 0.14 | {"type":"Point","coordinates":[7.60198287874612,47.5690249948015]} | Erlenstrasse | Höhe Jägerstr. | Basel | 50.0 | 2025-06-30 | 2025-07-21 |
| 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 |
| 1919 | 1919 | 1045 | 1 | Riehenstrasse | 47012.0 | 37.0 | 43.0 | 0.1 | {"type":"Point","coordinates":[7.61542063914724,47.5713707201654]} | Fasanenstrasse | vis 221 | Basel | 50.0 | 2025-06-23 | 2025-07-04 |
| 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 |
| 1917 | 1917 | 1044 | 1 | Isteinerstrasse | 21144.0 | 42.0 | 50.0 | 3.47 | {"type":"Point","coordinates":[7.60831888931105,47.5693666937575]} | Maulbeerstrasse | vis 151 | Basel | 50.0 | 2025-06-23 | 2025-07-07 |
| 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 |
| 1909 | 1909 | 1037 | 1 | Weilerweg | 89412.0 | 34.0 | 41.0 | 0.12 | {"type":"Point","coordinates":[7.59390945180678,47.5840041969409]} | Kleinhüningeranlage | 60 | Basel | 50.0 | 2025-06-16 | 2025-06-30 |
| 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 |
| 1907 | 1907 | 1036 | 1 | Lehenmattstrasse | 74176.0 | 44.0 | 50.0 | 4.5 | {"type":"Point","coordinates":[7.61567640279556,47.5547337489214]} | Baldeggerstrasse | Autobahnauffahrt | Basel | 50.0 | 2025-06-10 | 2025-06-23 |
| 1908 | 1908 | 1036 | 2 | {"type":"Point","coordinates":[7.61567640279556,47.5547337489214]} | Baldeggerstrasse | Autobahnauffahrt | Basel | 50.0 | 2025-06-10 | 2025-06-23 | |||||
| 1905 | 1905 | 1035 | 1 | Birsbrücke | 87098.0 | 41.0 | 49.0 | 2.43 | {"type":"Point","coordinates":[7.61220468092257,47.5550780396613]} | Zürcherstrasse | 111 | 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 |
| 1903 | 1903 | 1034 | 1 | Mittlere Strasse | 20510.0 | 33.0 | 40.0 | 0.24 | {"type":"Point","coordinates":[7.57709114901949,47.5644533398655]} | Metzerstrasse | 29 | 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 |
| 1901 | 1901 | 1033 | 1 | Riehenstrasse | 79002.0 | 51.0 | 57.0 | 21.21 | {"type":"Point","coordinates":[7.60949664908908,47.5640766730494]} | Schwarzwaldstrasse | 160 | Basel | 50.0 | 2025-06-02 | 2025-06-12 |
| 1902 | 1902 | 1033 | 2 | {"type":"Point","coordinates":[7.60949664908908,47.5640766730494]} | Schwarzwaldstrasse | 160 | Basel | 50.0 | 2025-06-02 | 2025-06-12 | |||||
| 1897 | 1897 | 1031 | 1 | Bonergasse | 110874.0 | 38.0 | 44.0 | 0.32 | {"type":"Point","coordinates":[7.5975117399137,47.576387110331]} | Hochbergerstrasse | 17 | Basel | 50.0 | 2025-06-02 | 2025-06-16 |
| 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 |
| 1893 | 1893 | 1029 | 1 | Landesgrenze | 91790.0 | 39.0 | 43.0 | 0.19 | {"type":"Point","coordinates":[7.63062391253201,47.5628367986362]} | Grenzacherstrasse | 511 | Basel | 50.0 | 2025-05-26 | 2025-06-10 |
| 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 |
| 1873 | 1873 | 1016 | 1 | Wielandplatz | 34054.0 | 41.0 | 49.0 | 2.72 | {"type":"Point","coordinates":[7.56165474288762,47.5518416480661]} | Wanderstrasse | 137 | Basel | 50.0 | 2025-04-28 | 2025-05-11 |
| 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 |
| 1855 | 1855 | 1007 | 1 | Riehenstrasse | 52603.0 | 43.0 | 48.0 | 0.74 | {"type":"Point","coordinates":[7.60560609550861,47.5730400390254]} | Fasanenstrasse | vis 54 | Basel | 50.0 | 2025-04-07 | 2025-04-21 |
| 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 |
| 1851 | 1851 | 1005 | 1 | Holbeinplatz | 98283.0 | 43.0 | 49.0 | 2.21 | {"type":"Point","coordinates":[7.58511012325079,47.5551323417369]} | Steinengraben | 25 | Basel | 50.0 | 2025-03-31 | 2025-04-13 |
| 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 |
| 1843 | 1843 | 1001 | 1 | {"type":"Point","coordinates":[7.59293041523734,47.541923906976]} | Dornacherstrasse | vis 182 | Basel | 50.0 | 2025-03-24 | 2025-04-06 | |||||
| 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 |
| 1841 | 1841 | 1000 | 1 | Wettsteinallee | 71950.0 | 28.0 | 35.0 | 0.06 | {"type":"Point","coordinates":[7.59763812117352,47.5683960489142]} | Riehenring | vis 153 | Basel | 50.0 | 2025-03-17 | 2025-03-31 |
| 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 |
| 1839 | 1839 | 999 | 1 | Hochbergerstrasse | 57362.0 | 34.0 | 42.0 | 0.51 | {"type":"Point","coordinates":[7.59753045381467,47.5697263633696]} | Riehenring | vis 182 | 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 |
| 1835 | 1835 | 997 | 1 | Bundesplatz | 15151.0 | 36.0 | 43.0 | 0.27 | {"type":"Point","coordinates":[7.56674318451274,47.5475560462463]} | Neubadstrasse | 116 | Basel | 50.0 | 2025-03-10 | 2025-03-19 |
| 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 |
| 1825 | 1825 | 991 | 1 | St.Alban-Tal | 2881.0 | 29.0 | 33.0 | 0.0 | {"type":"Point","coordinates":[7.60492037072319,47.5534365165225]} | St.Alban-Talstrasse | vis 15 | Basel | 50.0 | 2025-02-24 | 2025-03-09 |
| 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 |
| 1823 | 1823 | 990 | 1 | Bundesplatz | 35179.0 | 41.0 | 47.0 | 0.76 | {"type":"Point","coordinates":[7.57576510438988,47.5494740496906]} | Rütimeyerstrasse | 27 | 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 |
| 1797 | 1797 | 977 | 1 | Nauenstrasse | {"type":"Point","coordinates":[7.59031406518489,47.5490360184748]} | Elisabethenanlage | Mittelinsel Höhe Hotel Euler | Basel | 50.0 | 2025-01-27 | 2025-02-08 | ||||
| 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 |
| 1795 | 1795 | 976 | 1 | Markthallenbrücke | {"type":"Point","coordinates":[7.58963965940228,47.5491870900806]} | Elisabethenanlage | 7 | Basel | 50.0 | 2025-01-20 | 2025-01-31 | ||||
| 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 |
| 1791 | 1791 | 974 | 1 | Aeschenplatz | 85698.0 | 31.0 | 38.0 | 0.06 | {"type":"Point","coordinates":[7.59966178295629,47.5524563907584]} | St.Alban-Anlage | 29 | Basel | 50.0 | 2025-01-20 | 2025-02-03 |
| 1792 | 1792 | 974 | 2 | {"type":"Point","coordinates":[7.59966178295629,47.5524563907584]} | St.Alban-Anlage | 29 | Basel | 50.0 | 2025-01-20 | 2025-02-03 | |||||
| 1789 | 1789 | 973 | 1 | Aeschenplatz | 45558.0 | 39.0 | 45.0 | 0.23 | {"type":"Point","coordinates":[7.59611731782663,47.5501921119197]} | St.Jakobs-Strasse | 18 | Basel | 50.0 | 2025-01-13 | 2025-01-26 |
| 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 |
| 1787 | 1787 | 972 | 1 | Sevogelstrasse | 158790.0 | 41.0 | 49.0 | 2.08 | {"type":"Point","coordinates":[7.60007544831342,47.5521833075965]} | St.Alban-Anlage | 40 | 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 | |||||
| 1777 | 1777 | 967 | 1 | St.Alban-Graben | 64116.0 | 38.0 | 45.0 | 0.65 | {"type":"Point","coordinates":[7.59490834945785,47.5537939380568]} | Dufourstrasse | 11 | Basel | 50.0 | 2024-12-30 | 2025-01-13 |
| 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 |
| 1771 | 1771 | 964 | 1 | St. Jakobs-Strasse | 15564.0 | 43.0 | 51.0 | 4.57 | {"type":"Point","coordinates":[7.61081423608187,47.5449567268113]} | Zeughaustrasse | vis 47 | Basel | 50.0 | 2024-12-23 | 2025-01-02 |
| 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 |
| 1761 | 1761 | 958 | 1 | Reinacherstrasse | 63365.0 | 40.0 | 46.0 | 0.58 | {"type":"Point","coordinates":[7.58422684767453,47.5430251525279]} | Gundeldingerstrasse | 97 | Basel | 50.0 | 2024-12-16 | 2024-12-28 |
| 1762 | 1762 | 958 | 2 | {"type":"Point","coordinates":[7.58422684767453,47.5430251525279]} | Gundeldingerstrasse | 97 | Basel | 50.0 | 2024-12-16 | 2024-12-28 | |||||
| 1759 | 1759 | 957 | 1 | Zürcherstrasse | 262872.0 | 46.0 | 56.0 | 16.71 | {"type":"Point","coordinates":[7.61373081929387,47.5577963615072]} | Schwarzwaldbrücke | mitte | Basel | 50.0 | 2024-12-09 | 2024-12-23 |
| 1760 | 1760 | 957 | 2 | {"type":"Point","coordinates":[7.61373081929387,47.5577963615072]} | Schwarzwaldbrücke | mitte | Basel | 50.0 | 2024-12-09 | 2024-12-23 | |||||
| 1757 | 1757 | 956 | 1 | Münchensteinerstrasse | 87724.0 | 31.0 | 43.0 | 0.52 | {"type":"Point","coordinates":[7.60056168369492,47.5451773912151]} | Grosspeterstrasse | vis 11 | 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 |
| 1753 | 1753 | 954 | 1 | Centralbahnstrasse | 66671.0 | 46.0 | 52.0 | 4.75 | {"type":"Point","coordinates":[7.58384589425502,47.5494741583297]} | Viaduktstrasse | Brücke | Basel | 50.0 | 2024-12-02 | 2024-12-14 |
| 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 |
| 1751 | 1751 | 953 | 1 | Steinentorberg | 19232.0 | 29.0 | 39.0 | 0.09 | {"type":"Point","coordinates":[7.58667359609541,47.5502494604917]} | Innere Margarethenstrasse | 10 | Basel | 50.0 | 2024-12-02 | 2024-12-16 |
| 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 |
| 1749 | 1749 | 952 | 1 | Oberwilerstrasse | 92500.0 | 43.0 | 48.0 | 1.26 | {"type":"Point","coordinates":[7.57834977013792,47.5442231204729]} | Dorenbachviadukt | Brücke | 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 |
| 1743 | 1743 | 949 | 1 | Vogesenstrasse | 36031.0 | 32.0 | 39.0 | 0.27 | {"type":"Point","coordinates":[7.57399437278879,47.5668079281999]} | Entenweidstrasse | 24 | Basel | 50.0 | 2024-11-25 | 2024-12-09 |
| 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 |
| 1739 | 1739 | 947 | 1 | Kraftstrasse | 8445.0 | 32.0 | 39.0 | 0.11 | {"type":"Point","coordinates":[7.57587880102629,47.5720247647508]} | Hüningerstrasse | 46 | Basel | 50.0 | 2024-11-25 | 2024-12-02 |
| 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 |
| 1729 | 1729 | 942 | 1 | Banngrenze Basel | 18895.0 | 45.0 | 53.0 | 7.0 | {"type":"Point","coordinates":[7.62936628261698,47.5708360738912]} | Bäumlihofstrasse | 383 | Basel | 50.0 | 2024-11-04 | 2024-11-18 |
| 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 |
| 1719 | 1719 | 937 | 1 | Birsbrücke | 106933.0 | 50.0 | 56.0 | 16.5 | {"type":"Point","coordinates":[7.60753430633855,47.5532483834855]} | Zürcherstrasse | vis 27 | Basel | 50.0 | 2024-10-28 | 2024-11-11 |
| 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 |
| 1715 | 1715 | 933 | 1 | Steinengraben | 123126.0 | 55.0 | 60.0 | 43.35 | {"type":"Point","coordinates":[7.58762495742204,47.5503201982703]} | Heuwaage-Viadukt | ohne | Basel | 50.0 | 2024-09-23 | 2024-10-07 |
| 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 |
| 1701 | 1701 | 925 | 1 | Kantonsgrenze | 125369.0 | 48.0 | 55.0 | 13.59 | {"type":"Point","coordinates":[7.6013177639173,47.5422137870044]} | Münchensteinerstrasse | Höhe Delsbergerallee | Basel | 50.0 | 2024-09-30 | 2024-10-21 |
| 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 |
| 1685 | 1685 | 916 | 1 | Voltastrasse | 44666.0 | 48.0 | 54.0 | 11.56 | {"type":"Point","coordinates":[7.58275444757373,47.570843695589]} | Dreirosenbrücke | ohne | Basel | 50.0 | 2024-09-23 | 2024-10-07 |
| 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 |
| 1669 | 1669 | 907 | 1 | Grenzacherstrasse | 68940.0 | 45.0 | 50.0 | 2.77 | {"type":"Point","coordinates":[7.63580478775953,47.5642869200971]} | Hörnliallee | Höhe Hirentweg | Basel | 50.0 | 2024-09-02 | 2024-09-16 |
| 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 |
| 1667 | 1667 | 906 | 1 | {"type":"Point","coordinates":[7.58939709173671,47.5752628853381]} | Klybeckstrasse | vis 228 | 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 |
| 1639 | 1639 | 892 | 1 | Wettsteinplatz | 118310.0 | 45.0 | 49.0 | 1.24 | {"type":"Point","coordinates":[7.62079393623847,47.5609423265904]} | Grenzacherstrasse | 351 | Basel | 50.0 | 2024-07-29 | 2024-08-12 |
| 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 |
| 1631 | 1631 | 888 | 1 | Aeschenvorstadt | 79207.0 | 32.0 | 39.0 | 0.1 | {"type":"Point","coordinates":[7.59473569025062,47.552901989879]} | Brunngässlein | 12 | Basel | 50.0 | 2024-07-22 | 2024-08-05 |
| 1632 | 1632 | 888 | 2 | {"type":"Point","coordinates":[7.59473569025062,47.552901989879]} | Brunngässlein | 12 | Basel | 50.0 | 2024-07-22 | 2024-08-05 | |||||
| 1617 | 1617 | 881 | 1 | Margarethenstrasse | 79783.0 | 27.0 | 34.0 | 0.02 | {"type":"Point","coordinates":[7.60018563118348,47.539862588226]} | Dornacherstrasse | 291 | Basel | 50.0 | 2024-07-01 | 2024-07-15 |
| 1618 | 1618 | 881 | 2 | {"type":"Point","coordinates":[7.60018563118348,47.539862588226]} | Dornacherstrasse | 291 | Basel | 50.0 | 2024-07-01 | 2024-07-15 | |||||
| 1615 | 1615 | 880 | 1 | Grenzacherstrasse | 28228.0 | 48.0 | 54.0 | 11.76 | {"type":"Point","coordinates":[7.6027593172046,47.5725970973319]} | Schwarzwaldallee | Y-Brücke | Basel | 50.0 | 2024-06-24 | 2024-07-08 |
| 1616 | 1616 | 880 | 2 | {"type":"Point","coordinates":[7.6027593172046,47.5725970973319]} | Schwarzwaldallee | Y-Brücke | Basel | 50.0 | 2024-06-24 | 2024-07-08 | |||||
| 1613 | 1613 | 877 | 1 | Spalentor | 71594.0 | 42.0 | 51.0 | 5.0 | {"type":"Point","coordinates":[7.58112165749545,47.5570808305584]} | Schützengraben | 16 | 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 |
| 1611 | 1611 | 876 | 1 | Hochbergerstrasse | 132041.0 | 53.0 | 60.0 | 33.1 | {"type":"Point","coordinates":[7.60865278152303,47.5644664362307]} | Schwarzwaldstrasse | A2 Einfahrt Riehenstrasse | 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 | |||||
| 1561 | 1561 | 850 | 1 | Zürcherstrasse | 66732.0 | 37.0 | 43.0 | 0.21 | {"type":"Point","coordinates":[7.62223876829489,47.5468108741997]} | Birsstrasse | vis 214 | Basel | 50.0 | 2024-04-29 | 2024-05-13 |
| 1562 | 1562 | 850 | 2 | {"type":"Point","coordinates":[7.62223876829489,47.5468108741997]} | Birsstrasse | vis 214 | Basel | 50.0 | 2024-04-29 | 2024-05-13 |
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");