home / Geschwindigkeitsmonitoring / Kennzahlen_pro_Richtung

Menu
  • Sign in with GitHub

Kennzahlen_pro_Richtung

Fzg
Anzahl gemessene Fahrzeuge während der Messung
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
Messung-ID
Laufnummer der Messung; eine Messung beinhaltet alle Fahrten eines Messgeräts an einem Standort
Ort
Gemeinde am Standort der Messung
Richtung
Name der Fahrtrichtung
Richtung ID
ID der Richtung; In einer Messung werden i.d.R. Fahrten in zwei Richtungen gemessen.
Strasse
Name der Strasse, an welcher ein Messgerät ausgebracht wurde
Strasse_Nr
Hausnummer, bei welcher ein Messgerät ausgebracht wurde
Ue_Quote
Übertretungsquote
V50
Höchstgeschwindigkeit, welche von 50% der Fahrzeuge nicht überschritten wird
V85
Höchstgeschwindigkeit, welche von 85% der Fahrzeuge nicht überschritten wird
Zone
geltende Höchstgeschwindigkeit am Standort der Messung
geometry
Koordinaten des Messstandortes im GeoJSON-Format

500 rows where Zone = 50 sorted by Messung-ID descending

✎ View and edit SQL

This data as json, copyable, geojson, 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
  • Kohlistieg 8
  • Lehenmattstrasse 8
  • Münchensteinerstrasse 8
  • Riehenstrasse 8
  • Rütimeyerstrasse 8
  • Wanderstrasse 8
  • Allschwilerstrasse 6
  • Arnold Böcklin-Strasse 6
  • Bundesstrasse 6
  • Burgfelderstrasse 6
  • Bäumlihofstrasse 6
  • Feldbergstrasse 6
  • Grosspeterstrasse 6
  • Gundeldingerrain 6
  • Heuwaage-Viadukt 6
  • Kleinhüningeranlage 6
  • Metzerstrasse 6
  • Neuweilerstrasse 6
  • Rudolf Wackernagel-Strasse 6
  • Aeschengraben 4
  • …

Messung-ID >30

  • 3 2
  • 6 2
  • 7 2
  • 10 2
  • 11 2
  • 12 2
  • 13 2
  • 17 2
  • 18 2
  • 20 2
  • 24 2
  • 28 2
  • 29 2
  • 30 2
  • 40 2
  • 43 2
  • 44 2
  • 45 2
  • 46 2
  • 47 2
  • 58 2
  • 68 2
  • 75 2
  • 77 2
  • 86 2
  • 87 2
  • 88 2
  • 89 2
  • 90 2
  • 93 2
  • …

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-06-29 4
  • 2020-08-10 4
  • 2020-08-24 4
  • 2020-10-19 4
  • 2020-11-02 4
  • 2021-11-08 4
  • 2022-02-09 4
  • 2022-05-22 4
  • 2022-08-08 4
  • 2023-03-20 4
  • 2024-01-21 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
  • …

Messbeginn (date) >30

  • 2020-09-21 8
  • 2019-12-16 6
  • 2020-01-02 6
  • 2020-02-24 6
  • 2020-03-09 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
  • 2023-03-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
  • 2020-01-13 4
  • 2020-01-27 4
  • 2020-02-10 4
  • 2020-04-06 4
  • 2020-04-20 4
  • 2020-06-02 4
  • 2020-07-27 4
  • 2020-08-10 4
  • 2020-09-07 4
  • …

Richtung ID 2

  • 1 250
  • 2 250

Ort 2

  • Basel 474
  • Riehen 24

Zone 1

  • 50 · 500 ✖
Link rowid Messung-ID ▲ Richtung ID Richtung Fzg V50 V85 Ue_Quote geometry Strasse Strasse_Nr Ort Zone Messbeginn Messende
1941 1941 1056 1 Claragraben 36703 43 48 0.75 {"type":"Point","coordinates":[7.60592807950893,47.5651017395347]} Riehenstrasse 153 Basel 50 2025-07-21 2025-08-02
1942 1942 1056 2 Riehen 56817 41 47 1.0 {"type":"Point","coordinates":[7.60592807950893,47.5651017395347]} Riehenstrasse 153 Basel 50 2025-07-21 2025-08-02
1931 1931 1051 1           {"type":"Point","coordinates":[7.60290304285225,47.5717964566866]} Schwarzwaldallee Y-Brücke Basel 50 2025-06-30 2025-07-15
1932 1932 1051 2 Grenzacherstrasse 85059 42 48 1.96 {"type":"Point","coordinates":[7.60290304285225,47.5717964566866]} Schwarzwaldallee Y-Brücke Basel 50 2025-06-30 2025-07-15
1929 1929 1050 1 Schwarzwaldallee 32923 50 55 13.15 {"type":"Point","coordinates":[7.60697534296563,47.5613606434046]} Wettsteinallee 119 vis Basel 50 2025-06-30 2025-07-14
1930 1930 1050 2 Wielandplatz 14887 48 54 10.12 {"type":"Point","coordinates":[7.60697534296563,47.5613606434046]} Wettsteinallee 119 vis Basel 50 2025-06-30 2025-07-14
1927 1927 1049 1 Riehenring 33939 31 39 0.14 {"type":"Point","coordinates":[7.60198287874612,47.5690249948015]} Erlenstrasse Höhe Jägerstr. Basel 50 2025-06-30 2025-07-21
1928 1928 1049 2 Schwarzwaldallee 46489 32 40 0.16 {"type":"Point","coordinates":[7.60198287874612,47.5690249948015]} Erlenstrasse Höhe Jägerstr. Basel 50 2025-06-30 2025-07-21
1919 1919 1045 1 Riehenstrasse 47012 37 43 0.1 {"type":"Point","coordinates":[7.61542063914724,47.5713707201654]} Fasanenstrasse vis 221 Basel 50 2025-06-23 2025-07-04
1920 1920 1045 2 Schwarzwaldallee 30476 37 43 0.19 {"type":"Point","coordinates":[7.61542063914724,47.5713707201654]} Fasanenstrasse vis 221 Basel 50 2025-06-23 2025-07-04
1917 1917 1044 1 Isteinerstrasse 21144 42 50 3.47 {"type":"Point","coordinates":[7.60831888931105,47.5693666937575]} Maulbeerstrasse vis 151 Basel 50 2025-06-23 2025-07-07
1918 1918 1044 2 Im Surinam 14269 36 43 0.32 {"type":"Point","coordinates":[7.60831888931105,47.5693666937575]} Maulbeerstrasse vis 151 Basel 50 2025-06-23 2025-07-07
1909 1909 1037 1 Weilerweg 89412 34 41 0.12 {"type":"Point","coordinates":[7.59390945180678,47.5840041969409]} Kleinhüningeranlage 60 Basel 50 2025-06-16 2025-06-30
1910 1910 1037 2 Hochbergerplatz 95435 33 41 0.17 {"type":"Point","coordinates":[7.59390945180678,47.5840041969409]} Kleinhüningeranlage 60 Basel 50 2025-06-16 2025-06-30
1907 1907 1036 1 Lehenmattstrasse 74176 44 50 4.5 {"type":"Point","coordinates":[7.61567640279556,47.5547337489214]} Baldeggerstrasse Autobahnauffahrt Basel 50 2025-06-10 2025-06-23
1908 1908 1036 2           {"type":"Point","coordinates":[7.61567640279556,47.5547337489214]} Baldeggerstrasse Autobahnauffahrt Basel 50 2025-06-10 2025-06-23
1905 1905 1035 1 Birsbrücke 87098 41 49 2.43 {"type":"Point","coordinates":[7.61220468092257,47.5550780396613]} Zürcherstrasse 111 Basel 50 2025-06-10 2025-06-23
1906 1906 1035 2 St.Alban-Anlage 116184 41 48 2.26 {"type":"Point","coordinates":[7.61220468092257,47.5550780396613]} Zürcherstrasse 111 Basel 50 2025-06-10 2025-06-23
1903 1903 1034 1 Mittlere Strasse 20510 33 40 0.24 {"type":"Point","coordinates":[7.57709114901949,47.5644533398655]} Metzerstrasse 29 Basel 50 2025-06-10 2025-06-23
1904 1904 1034 2 Klingelbergstrasse 36082 26 35 0.05 {"type":"Point","coordinates":[7.57709114901949,47.5644533398655]} Metzerstrasse 29 Basel 50 2025-06-10 2025-06-23
1901 1901 1033 1 Riehenstrasse 79002 51 57 21.21 {"type":"Point","coordinates":[7.60949664908908,47.5640766730494]} Schwarzwaldstrasse 160 Basel 50 2025-06-02 2025-06-12
1902 1902 1033 2           {"type":"Point","coordinates":[7.60949664908908,47.5640766730494]} Schwarzwaldstrasse 160 Basel 50 2025-06-02 2025-06-12
1897 1897 1031 1 Bonergasse 110874 38 44 0.32 {"type":"Point","coordinates":[7.5975117399137,47.576387110331]} Hochbergerstrasse 17 Basel 50 2025-06-02 2025-06-16
1898 1898 1031 2 Freiburgerstrasse 195608 38 44 0.54 {"type":"Point","coordinates":[7.5975117399137,47.576387110331]} Hochbergerstrasse 17 Basel 50 2025-06-02 2025-06-16
1893 1893 1029 1 Landesgrenze 91790 39 43 0.19 {"type":"Point","coordinates":[7.63062391253201,47.5628367986362]} Grenzacherstrasse 511 Basel 50 2025-05-26 2025-06-10
1894 1894 1029 2 Wettsteinplatz 106319 40 44 0.22 {"type":"Point","coordinates":[7.63062391253201,47.5628367986362]} Grenzacherstrasse 511 Basel 50 2025-05-26 2025-06-10
1873 1873 1016 1 Wielandplatz 34054 41 49 2.72 {"type":"Point","coordinates":[7.56165474288762,47.5518416480661]} Wanderstrasse 137 Basel 50 2025-04-28 2025-05-11
1874 1874 1016 2 Steinbühlallee 28315 43 50 2.58 {"type":"Point","coordinates":[7.56165474288762,47.5518416480661]} Wanderstrasse 137 Basel 50 2025-04-28 2025-05-11
1855 1855 1007 1 Riehenstrasse 52603 43 48 0.74 {"type":"Point","coordinates":[7.60560609550861,47.5730400390254]} Fasanenstrasse vis 54 Basel 50 2025-04-07 2025-04-21
1856 1856 1007 2 Schwarzwaldallee 42649 42 48 0.79 {"type":"Point","coordinates":[7.60560609550861,47.5730400390254]} Fasanenstrasse vis 54 Basel 50 2025-04-07 2025-04-21
1851 1851 1005 1 Holbeinplatz 98283 43 49 2.21 {"type":"Point","coordinates":[7.58511012325079,47.5551323417369]} Steinengraben 25 Basel 50 2025-03-31 2025-04-13
1852 1852 1005 2 Heuwaage-Viadukt 73794 40 46 0.44 {"type":"Point","coordinates":[7.58511012325079,47.5551323417369]} Steinengraben 25 Basel 50 2025-03-31 2025-04-13
1843 1843 1001 1           {"type":"Point","coordinates":[7.59293041523734,47.541923906976]} Dornacherstrasse vis 182 Basel 50 2025-03-24 2025-04-06
1844 1844 1001 2 Margarethenstrasse 68868 31 36 0.03 {"type":"Point","coordinates":[7.59293041523734,47.541923906976]} Dornacherstrasse vis 182 Basel 50 2025-03-24 2025-04-06
1841 1841 1000 1 Wettsteinallee 71950 28 35 0.06 {"type":"Point","coordinates":[7.59763812117352,47.5683960489142]} Riehenring vis 153 Basel 50 2025-03-17 2025-03-31
1842 1842 1000 2 Hochbergerstrasse 61812 31 39 0.13 {"type":"Point","coordinates":[7.59763812117352,47.5683960489142]} Riehenring vis 153 Basel 50 2025-03-17 2025-03-31
1839 1839 999 1 Hochbergerstrasse 57362 34 42 0.51 {"type":"Point","coordinates":[7.59753045381467,47.5697263633696]} Riehenring vis 182 Basel 50 2025-03-17 2025-03-31
1840 1840 999 2 Wettsteinallee 99938 29 35 0.04 {"type":"Point","coordinates":[7.59753045381467,47.5697263633696]} Riehenring vis 182 Basel 50 2025-03-17 2025-03-31
1835 1835 997 1 Bundesplatz 15151 36 43 0.27 {"type":"Point","coordinates":[7.56674318451274,47.5475560462463]} Neubadstrasse 116 Basel 50 2025-03-10 2025-03-19
1836 1836 997 2 Dorenbach-Promenade 19898 40 46 0.54 {"type":"Point","coordinates":[7.56674318451274,47.5475560462463]} Neubadstrasse 116 Basel 50 2025-03-10 2025-03-19
1825 1825 991 1 St.Alban-Tal 2881 29 33 0.0 {"type":"Point","coordinates":[7.60492037072319,47.5534365165225]} St.Alban-Talstrasse vis 15 Basel 50 2025-02-24 2025-03-09
1826 1826 991 2 St.Alban-Anlage 2506 32 38 0.04 {"type":"Point","coordinates":[7.60492037072319,47.5534365165225]} St.Alban-Talstrasse vis 15 Basel 50 2025-02-24 2025-03-09
1823 1823 990 1 Bundesplatz 35179 41 47 0.76 {"type":"Point","coordinates":[7.57576510438988,47.5494740496906]} Rütimeyerstrasse 27 Basel 50 2025-02-24 2025-03-09
1824 1824 990 2 Oberwilerstrasse 54503 39 47 1.63 {"type":"Point","coordinates":[7.57576510438988,47.5494740496906]} Rütimeyerstrasse 27 Basel 50 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 2025-01-27 2025-02-08
1798 1798 977 2 Markthallenbrücke 88897 40 47 1.26 {"type":"Point","coordinates":[7.59031406518489,47.5490360184748]} Elisabethenanlage Mittelinsel Höhe Hotel Euler Basel 50 2025-01-27 2025-02-08
1795 1795 976 1 Markthallenbrücke         {"type":"Point","coordinates":[7.58963965940228,47.5491870900806]} Elisabethenanlage 7 Basel 50 2025-01-20 2025-01-31
1796 1796 976 2 Nauenstrasse 73317 31 40 0.47 {"type":"Point","coordinates":[7.58963965940228,47.5491870900806]} Elisabethenanlage 7 Basel 50 2025-01-20 2025-01-31
1791 1791 974 1 Aeschenplatz 85698 31 38 0.06 {"type":"Point","coordinates":[7.59966178295629,47.5524563907584]} St.Alban-Anlage 29 Basel 50 2025-01-20 2025-02-03
1792 1792 974 2           {"type":"Point","coordinates":[7.59966178295629,47.5524563907584]} St.Alban-Anlage 29 Basel 50 2025-01-20 2025-02-03
1789 1789 973 1 Aeschenplatz 45558 39 45 0.23 {"type":"Point","coordinates":[7.59611731782663,47.5501921119197]} St.Jakobs-Strasse 18 Basel 50 2025-01-13 2025-01-26
1790 1790 973 2 Birs / Kantonsgrenze 41092 38 45 0.25 {"type":"Point","coordinates":[7.59611731782663,47.5501921119197]} St.Jakobs-Strasse 18 Basel 50 2025-01-13 2025-01-26
1787 1787 972 1 Sevogelstrasse 158790 41 49 2.08 {"type":"Point","coordinates":[7.60007544831342,47.5521833075965]} St.Alban-Anlage 40 Basel 50 2025-01-13 2025-01-26
1788 1788 972 2           {"type":"Point","coordinates":[7.60007544831342,47.5521833075965]} St.Alban-Anlage 40 Basel 50 2025-01-13 2025-01-26
1777 1777 967 1 St.Alban-Graben 64116 38 45 0.65 {"type":"Point","coordinates":[7.59490834945785,47.5537939380568]} Dufourstrasse 11 Basel 50 2024-12-30 2025-01-13
1778 1778 967 2 Aeschenplatz 65314 35 43 0.47 {"type":"Point","coordinates":[7.59490834945785,47.5537939380568]} Dufourstrasse 11 Basel 50 2024-12-30 2025-01-13
1771 1771 964 1 St. Jakobs-Strasse 15564 43 51 4.57 {"type":"Point","coordinates":[7.61081423608187,47.5449567268113]} Zeughaustrasse vis 47 Basel 50 2024-12-23 2025-01-02
1772 1772 964 2 Adlerstrasse 11090 40 49 2.82 {"type":"Point","coordinates":[7.61081423608187,47.5449567268113]} Zeughaustrasse vis 47 Basel 50 2024-12-23 2025-01-02
1761 1761 958 1 Reinacherstrasse 63365 40 46 0.58 {"type":"Point","coordinates":[7.58422684767453,47.5430251525279]} Gundeldingerstrasse 97 Basel 50 2024-12-16 2024-12-28
1762 1762 958 2           {"type":"Point","coordinates":[7.58422684767453,47.5430251525279]} Gundeldingerstrasse 97 Basel 50 2024-12-16 2024-12-28
1759 1759 957 1 Zürcherstrasse 262872 46 56 16.71 {"type":"Point","coordinates":[7.61373081929387,47.5577963615072]} Schwarzwaldbrücke mitte Basel 50 2024-12-09 2024-12-23
1760 1760 957 2           {"type":"Point","coordinates":[7.61373081929387,47.5577963615072]} Schwarzwaldbrücke mitte Basel 50 2024-12-09 2024-12-23
1757 1757 956 1 Münchensteinerstrasse 87724 31 43 0.52 {"type":"Point","coordinates":[7.60056168369492,47.5451773912151]} Grosspeterstrasse vis 11 Basel 50 2024-12-09 2024-12-23
1758 1758 956 2 St. Jakobs-Strasse 241146 45 52 6.01 {"type":"Point","coordinates":[7.60056168369492,47.5451773912151]} Grosspeterstrasse vis 11 Basel 50 2024-12-09 2024-12-23
1753 1753 954 1 Centralbahnstrasse 66671 46 52 4.75 {"type":"Point","coordinates":[7.58384589425502,47.5494741583297]} Viaduktstrasse Brücke Basel 50 2024-12-02 2024-12-14
1754 1754 954 2 Holbeinstrasse 69881 44 51 3.55 {"type":"Point","coordinates":[7.58384589425502,47.5494741583297]} Viaduktstrasse Brücke Basel 50 2024-12-02 2024-12-14
1751 1751 953 1 Steinentorberg 19232 29 39 0.09 {"type":"Point","coordinates":[7.58667359609541,47.5502494604917]} Innere Margarethenstrasse 10 Basel 50 2024-12-02 2024-12-16
1752 1752 953 2 Viaduktstrasse 16618 30 40 0.34 {"type":"Point","coordinates":[7.58667359609541,47.5502494604917]} Innere Margarethenstrasse 10 Basel 50 2024-12-02 2024-12-16
1749 1749 952 1 Oberwilerstrasse 92500 43 48 1.26 {"type":"Point","coordinates":[7.57834977013792,47.5442231204729]} Dorenbachviadukt Brücke Basel 50 2024-12-02 2024-12-16
1750 1750 952 2 Margarethenstrasse 80444 43 48 1.49 {"type":"Point","coordinates":[7.57834977013792,47.5442231204729]} Dorenbachviadukt Brücke Basel 50 2024-12-02 2024-12-16
1743 1743 949 1 Vogesenstrasse 36031 32 39 0.27 {"type":"Point","coordinates":[7.57399437278879,47.5668079281999]} Entenweidstrasse 24 Basel 50 2024-11-25 2024-12-09
1744 1744 949 2 Kannenfeldstrasse 35054 33 40 0.18 {"type":"Point","coordinates":[7.57399437278879,47.5668079281999]} Entenweidstrasse 24 Basel 50 2024-11-25 2024-12-09
1739 1739 947 1 Kraftstrasse 8445 32 39 0.11 {"type":"Point","coordinates":[7.57587880102629,47.5720247647508]} Hüningerstrasse 46 Basel 50 2024-11-25 2024-12-02
1740 1740 947 2 Vogesenstrasse 7848 37 43 0.46 {"type":"Point","coordinates":[7.57587880102629,47.5720247647508]} Hüningerstrasse 46 Basel 50 2024-11-25 2024-12-02
1729 1729 942 1 Banngrenze Basel 18895 45 53 7.0 {"type":"Point","coordinates":[7.62936628261698,47.5708360738912]} Bäumlihofstrasse 383 Basel 50 2024-11-04 2024-11-18
1730 1730 942 2 Aeussere Baselstrasse 17992 45 52 5.51 {"type":"Point","coordinates":[7.62936628261698,47.5708360738912]} Bäumlihofstrasse 383 Basel 50 2024-11-04 2024-11-18
1719 1719 937 1 Birsbrücke 106933 50 56 16.5 {"type":"Point","coordinates":[7.60753430633855,47.5532483834855]} Zürcherstrasse vis 27 Basel 50 2024-10-28 2024-11-11
1720 1720 937 2 St. Alban-Anlage 71491 50 56 16.6 {"type":"Point","coordinates":[7.60753430633855,47.5532483834855]} Zürcherstrasse vis 27 Basel 50 2024-10-28 2024-11-11
1715 1715 933 1 Steinengraben 123126 55 60 43.35 {"type":"Point","coordinates":[7.58762495742204,47.5503201982703]} Heuwaage-Viadukt ohne Basel 50 2024-09-23 2024-10-07
1716 1716 933 2 Elisabethenanlage 100160 57 63 60.69 {"type":"Point","coordinates":[7.58762495742204,47.5503201982703]} Heuwaage-Viadukt ohne Basel 50 2024-09-23 2024-10-07
1701 1701 925 1 Kantonsgrenze 125369 48 55 13.59 {"type":"Point","coordinates":[7.6013177639173,47.5422137870044]} Münchensteinerstrasse Höhe Delsbergerallee Basel 50 2024-09-30 2024-10-21
1702 1702 925 2 St. Jakobs-Denkmal 174404 46 54 9.4 {"type":"Point","coordinates":[7.6013177639173,47.5422137870044]} Münchensteinerstrasse Höhe Delsbergerallee Basel 50 2024-09-30 2024-10-21
1685 1685 916 1 Voltastrasse 44666 48 54 11.56 {"type":"Point","coordinates":[7.58275444757373,47.570843695589]} Dreirosenbrücke ohne Basel 50 2024-09-23 2024-10-07
1686 1686 916 2 Dreirosenstrasse 58789 30 36 0.07 {"type":"Point","coordinates":[7.58275444757373,47.570843695589]} Dreirosenbrücke ohne Basel 50 2024-09-23 2024-10-07
1669 1669 907 1 Grenzacherstrasse 68940 45 50 2.77 {"type":"Point","coordinates":[7.63580478775953,47.5642869200971]} Hörnliallee Höhe Hirentweg Basel 50 2024-09-02 2024-09-16
1670 1670 907 2 Kohlistieg 60627 47 53 6.38 {"type":"Point","coordinates":[7.63580478775953,47.5642869200971]} Hörnliallee Höhe Hirentweg Basel 50 2024-09-02 2024-09-16
1667 1667 906 1           {"type":"Point","coordinates":[7.58939709173671,47.5752628853381]} Klybeckstrasse vis 228 Basel 50 2024-09-02 2024-09-16
1668 1668 906 2 Untere Rebgasse 19925 44 53 9.45 {"type":"Point","coordinates":[7.58939709173671,47.5752628853381]} Klybeckstrasse vis 228 Basel 50 2024-09-02 2024-09-16
1639 1639 892 1 Wettsteinplatz 118310 45 49 1.24 {"type":"Point","coordinates":[7.62079393623847,47.5609423265904]} Grenzacherstrasse 351 Basel 50 2024-07-29 2024-08-12
1640 1640 892 2 Landesgrenze 94752 45 51 3.38 {"type":"Point","coordinates":[7.62079393623847,47.5609423265904]} Grenzacherstrasse 351 Basel 50 2024-07-29 2024-08-12
1631 1631 888 1 Aeschenvorstadt 79207 32 39 0.1 {"type":"Point","coordinates":[7.59473569025062,47.552901989879]} Brunngässlein 12 Basel 50 2024-07-22 2024-08-05
1632 1632 888 2           {"type":"Point","coordinates":[7.59473569025062,47.552901989879]} Brunngässlein 12 Basel 50 2024-07-22 2024-08-05
1617 1617 881 1 Margarethenstrasse 79783 27 34 0.02 {"type":"Point","coordinates":[7.60018563118348,47.539862588226]} Dornacherstrasse 291 Basel 50 2024-07-01 2024-07-15
1618 1618 881 2           {"type":"Point","coordinates":[7.60018563118348,47.539862588226]} Dornacherstrasse 291 Basel 50 2024-07-01 2024-07-15
1615 1615 880 1 Grenzacherstrasse 28228 48 54 11.76 {"type":"Point","coordinates":[7.6027593172046,47.5725970973319]} Schwarzwaldallee Y-Brücke Basel 50 2024-06-24 2024-07-08
1616 1616 880 2           {"type":"Point","coordinates":[7.6027593172046,47.5725970973319]} Schwarzwaldallee Y-Brücke Basel 50 2024-06-24 2024-07-08
1613 1613 877 1 Spalentor 71594 42 51 5.0 {"type":"Point","coordinates":[7.58112165749545,47.5570808305584]} Schützengraben 16 Basel 50 2024-06-24 2024-07-08
1614 1614 877 2 Holbeinplatz 81133 38 51 4.93 {"type":"Point","coordinates":[7.58112165749545,47.5570808305584]} Schützengraben 16 Basel 50 2024-06-24 2024-07-08
1611 1611 876 1 Hochbergerstrasse 132041 53 60 33.1 {"type":"Point","coordinates":[7.60865278152303,47.5644664362307]} Schwarzwaldstrasse A2 Einfahrt Riehenstrasse Basel 50 2024-06-24 2024-07-08
1612 1612 876 2           {"type":"Point","coordinates":[7.60865278152303,47.5644664362307]} Schwarzwaldstrasse A2 Einfahrt Riehenstrasse Basel 50 2024-06-24 2024-07-08

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE Kennzahlen_pro_Richtung (
        "Messung-ID" INTEGER,
        "Richtung ID" INTEGER,
        "Richtung" TEXT,
        "Fzg" INTEGER,
        "V50" INTEGER,
        "V85" INTEGER,
        "Ue_Quote" REAL,
        "geometry" TEXT,
        "Strasse" TEXT,
        "Strasse_Nr" TEXT,
        "Ort" TEXT,
        "Zone" INTEGER,
        "Messbeginn" TEXT,
        "Messende" TEXT
    );
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");
Powered by Datasette · Queries took 1.2ms