home / Geschwindigkeitsmonitoring

Kennzahlen_pro_Richtung

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

222 rows where Zone = "20.0" sorted by Messung-ID descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: V50, V85

Strasse >30

  • Rheingasse 10
  • Erlenmattstrasse 8
  • Realpstrasse 8
  • Efringerstrasse 6
  • Gempenstrasse 6
  • Niederholzstrasse 6
  • Pfaffenlohweg 6
  • Rittergasse 6
  • Tangentenweg 6
  • Altrheinweg 4
  • Bergalingerstrasse 4
  • Beuggenstrasse 4
  • Davidsbodenstrasse 4
  • Erlkönigweg 4
  • Freie Strasse 4
  • Fürstensteinerstrasse 4
  • Haltingerstrasse 4
  • Im Rheinacker 4
  • Jungstrasse 4
  • Marignanostrasse 4
  • Mörsbergerstrasse 4
  • Paradiesstrasse 4
  • Rössligasse 4
  • Scherkesselweg 4
  • Sissacherstrasse 4
  • Thiersteinerrain 4
  • Webergasse 4
  • Beim Wasserturm 2
  • Biascastrasse 2
  • Birkenstrasse 2
  • …

Messung-ID >30

  • 8 2
  • 36 2
  • 37 2
  • 53 2
  • 78 2
  • 80 2
  • 91 2
  • 100 2
  • 105 2
  • 111 2
  • 118 2
  • 134 2
  • 135 2
  • 136 2
  • 141 2
  • 144 2
  • 145 2
  • 158 2
  • 165 2
  • 191 2
  • 227 2
  • 233 2
  • 236 2
  • 248 2
  • 249 2
  • 263 2
  • 316 2
  • 328 2
  • 362 2
  • 377 2
  • …

Messende (date) >30

  • 2022-11-02 6
  • 2024-06-03 6
  • 2018-06-11 4
  • 2019-05-10 4
  • 2022-09-19 4
  • 2023-01-18 4
  • 2024-05-27 4
  • 2018-02-05 2
  • 2018-03-09 2
  • 2018-06-18 2
  • 2018-09-06 2
  • 2018-11-23 2
  • 2019-01-21 2
  • 2019-02-01 2
  • 2019-03-02 2
  • 2019-06-24 2
  • 2019-07-15 2
  • 2019-08-05 2
  • 2019-09-01 2
  • 2019-10-05 2
  • 2020-03-21 2
  • 2020-03-25 2
  • 2020-04-15 2
  • 2020-06-22 2
  • 2020-07-06 2
  • 2020-07-13 2
  • 2020-07-20 2
  • 2020-07-27 2
  • 2020-08-22 2
  • 2021-01-03 2
  • …

Messbeginn (date) >30

  • 2021-04-26 6
  • 2022-09-05 6
  • 2022-10-24 6
  • 2018-05-28 4
  • 2020-03-16 4
  • 2021-05-03 4
  • 2021-09-20 4
  • 2022-02-14 4
  • 2022-07-04 4
  • 2022-11-28 4
  • 2023-01-09 4
  • 2023-03-20 4
  • 2023-07-03 4
  • 2024-05-13 4
  • 2024-05-24 4
  • 2024-07-08 4
  • 2025-03-03 4
  • 2018-01-21 2
  • 2018-01-22 2
  • 2018-02-26 2
  • 2018-06-04 2
  • 2018-08-27 2
  • 2018-11-06 2
  • 2019-01-07 2
  • 2019-02-18 2
  • 2019-04-29 2
  • 2019-05-06 2
  • 2019-06-11 2
  • 2019-07-01 2
  • 2019-07-23 2
  • …

Ort 3

  • Basel 194
  • Riehen 26
  • Bettingen 2

Richtung ID 2

  • 1 111
  • 2 111

Zone 1

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

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" 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");
Powered by Datasette · Queries took 27.138ms