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

222 rows where Zone = 20 sorted by Messung-ID descending

✎ View and edit SQL

This data as json, copyable, geojson, 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 · 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 21 26 17.9 {"type":"Point","coordinates":[7.59857137084401,47.5694047640139]} Tangentenweg 11 Basel 20 2025-07-14 2025-07-28
1934 1934 1052 2 Erlenstrasse 5062 22 28 25.72 {"type":"Point","coordinates":[7.59857137084401,47.5694047640139]} Tangentenweg 11 Basel 20 2025-07-14 2025-07-28
1921 1921 1046 1 Erlkönigweg 1272 22 28 25.39 {"type":"Point","coordinates":[7.59882935231269,47.5712328272674]} Tangentenweg vis 42 Basel 20 2025-07-07 2025-07-14
1922 1922 1046 2 Erlenstrasse 1255 23 28 31.24 {"type":"Point","coordinates":[7.59882935231269,47.5712328272674]} Tangentenweg vis 42 Basel 20 2025-07-07 2025-07-14
1915 1915 1042 1 Allschwilerstrasse 8130 16 20 1.88 {"type":"Point","coordinates":[7.57363089208417,47.55653482902]} Palmenstrasse 20 Basel 20 2025-06-23 2025-07-05
1916 1916 1042 2           {"type":"Point","coordinates":[7.57363089208417,47.55653482902]} Palmenstrasse 20 Basel 20 2025-06-23 2025-07-05
1885 1885 1025 1 Aeussere Baselstrasse 3362 23 28 29.54 {"type":"Point","coordinates":[7.64172262474171,47.5763346024603]} Pfaffenlohweg 51 Riehen 20 2025-05-05 2025-05-20
1886 1886 1025 2 Meierweg 4510 19 25 14.92 {"type":"Point","coordinates":[7.64172262474171,47.5763346024603]} Pfaffenlohweg 51 Riehen 20 2025-05-05 2025-05-20
1829 1829 993 1 Elsässerstrasse 2850 22 28 27.16 {"type":"Point","coordinates":[7.58003787673389,47.5697704764139]} Wasserstrassse 15 Basel 20 2025-03-03 2025-03-14
1830 1830 993 2 Kehrplatz 2719 21 26 19.05 {"type":"Point","coordinates":[7.58003787673389,47.5697704764139]} Wasserstrassse 15 Basel 20 2025-03-03 2025-03-14
1827 1827 992 1 Landskronstrasse 5032 22 29 31.38 {"type":"Point","coordinates":[7.57766061447588,47.5652486053931]} Davidsbodenstrasse 14 Basel 20 2025-03-03 2025-03-15
1828 1828 992 2 St. Johanns-Ring 2124 19 26 16.57 {"type":"Point","coordinates":[7.57766061447588,47.5652486053931]} Davidsbodenstrasse 14 Basel 20 2025-03-03 2025-03-15
1817 1817 987 1 Inzlingerstrasse 14152 24 29 36.63 {"type":"Point","coordinates":[7.65221646457704,47.5857744633692]} Rössligasse 32 Riehen 20 2025-02-17 2025-03-01
1818 1818 987 2 Baselstrasse 3352 21 26 16.23 {"type":"Point","coordinates":[7.65221646457704,47.5857744633692]} Rössligasse 32 Riehen 20 2025-02-17 2025-03-01
1811 1811 984 1 Gundeldingerstrasse 4559 12 17 0.46 {"type":"Point","coordinates":[7.5860421955819,47.5433673322675]} Gempenstrasse 61 Basel 20 2025-02-10 2025-02-21
1812 1812 984 2 Güterstrasse 2067 17 21 1.94 {"type":"Point","coordinates":[7.5860421955819,47.5433673322675]} Gempenstrasse 61 Basel 20 2025-02-10 2025-02-21
1785 1785 971 1 Marktplatz 26729 16 22 4.49 {"type":"Point","coordinates":[7.58684847776975,47.5586979582546]} Stadthausgasse 10 Basel 20 2025-01-13 2025-01-25
1786 1786 971 2           {"type":"Point","coordinates":[7.58684847776975,47.5586979582546]} Stadthausgasse 10 Basel 20 2025-01-13 2025-01-25
1707 1707 928 1 St. Alban-Graben 22320 18 23 7.06 {"type":"Point","coordinates":[7.59300727901647,47.5556518808872]} Rittergasse 5 Basel 20 2024-10-14 2024-10-28
1708 1708 928 2 Münsterplatz 25943 17 23 5.86 {"type":"Point","coordinates":[7.59300727901647,47.5556518808872]} Rittergasse 5 Basel 20 2024-10-14 2024-10-28
1699 1699 924 1 Rauracherstrasse 9117 22 28 27.07 {"type":"Point","coordinates":[7.63512610107308,47.5744725386694]} Niederholzstrasse 35 Riehen 20 2024-09-30 2024-10-21
1700 1700 924 2           {"type":"Point","coordinates":[7.63512610107308,47.5744725386694]} Niederholzstrasse 35 Riehen 20 2024-09-30 2024-10-21
1677 1677 911 1 Erlenmattstrasse 39 7317 21 28 25.17 {"type":"Point","coordinates":[7.60014578778103,47.569287473335]} Erlenmattstrasse 16 Basel 20 2024-09-09 2024-09-23
1678 1678 911 2 Erlenmattstrasse 78 14470 20 27 21.66 {"type":"Point","coordinates":[7.60014578778103,47.569287473335]} Erlenmattstrasse 16 Basel 20 2024-09-09 2024-09-23
1665 1665 905 1           {"type":"Point","coordinates":[7.59107710590609,47.5669100617829]} Matthäusstrasse ohne Basel 20 2024-08-26 2024-09-09
1666 1666 905 2 Müllheimerstrasse 16232 15 20 1.69 {"type":"Point","coordinates":[7.59107710590609,47.5669100617829]} Matthäusstrasse ohne Basel 20 2024-08-26 2024-09-09
1649 1649 897 1 Oberalpstrasse 4092 18 23 8.48 {"type":"Point","coordinates":[7.56575574305623,47.5479213735221]} Realpstrasse 69 Basel 20 2024-08-12 2024-08-26
1650 1650 897 2 St.Galler-Ring 4887 20 25 14.08 {"type":"Point","coordinates":[7.56575574305623,47.5479213735221]} Realpstrasse 69 Basel 20 2024-08-12 2024-08-26
1647 1647 896 1 Eisengasse 49982 17 22 3.83 {"type":"Point","coordinates":[7.58771665555097,47.5584252405963]} Marktplatz vis 5 Basel 20 2024-07-08 2024-07-25
1648 1648 896 2 Gerbergasse 28744 18 23 6.58 {"type":"Point","coordinates":[7.58771665555097,47.5584252405963]} Marktplatz vis 5 Basel 20 2024-07-08 2024-07-25
1627 1627 886 1 Gibenacherweg 522 19 24 10.92 {"type":"Point","coordinates":[7.62318341926957,47.566068581746]} Olsbergerweg ohne Basel 20 2024-07-15 2024-07-29
1628 1628 886 2 Zu den Drei Linden 659 20 26 15.78 {"type":"Point","coordinates":[7.62318341926957,47.566068581746]} Olsbergerweg ohne Basel 20 2024-07-15 2024-07-29
1625 1625 885 1 Muensterplatz 12224 17 21 2.41 {"type":"Point","coordinates":[7.59217702819151,47.5561521301493]} Rittergasse vis 2 Basel 20 2024-07-08 2024-07-22
1626 1626 885 2 St. Alban-Graben 9820 15 20 1.25 {"type":"Point","coordinates":[7.59217702819151,47.5561521301493]} Rittergasse vis 2 Basel 20 2024-07-08 2024-07-22
1621 1621 883 1 Salmenweg 3277 12 16 0.18 {"type":"Point","coordinates":[7.59431104335605,47.5817759343862]} Hunnenstrasse 11 Basel 20 2024-07-01 2024-07-15
1622 1622 883 2 Kleinhüningeranlage 1976 16 24 8.65 {"type":"Point","coordinates":[7.59431104335605,47.5817759343862]} Hunnenstrasse 11 Basel 20 2024-07-01 2024-07-15
1583 1583 861 1 Beuggenstrasse 1736 15 21 2.36 {"type":"Point","coordinates":[7.61057737376122,47.5604955818256]} Bergalingerstrasse 30 Basel 20 2024-05-24 2024-06-03
1584 1584 861 2 Beuggenstrasse         {"type":"Point","coordinates":[7.61057737376122,47.5604955818256]} Bergalingerstrasse 30 Basel 20 2024-05-24 2024-06-03
1581 1581 860 1 Erlenstrasse78 4655 23 28 29.6 {"type":"Point","coordinates":[7.60068371531341,47.570069177964]} Erlenmattstrasse 22 Basel 20 2024-05-22 2024-06-03
1582 1582 860 2 Erlenstrasse39 5188 23 28 28.82 {"type":"Point","coordinates":[7.60068371531341,47.570069177964]} Erlenmattstrasse 22 Basel 20 2024-05-22 2024-06-03
1579 1579 859 1 Schwörstadterstrasse 8009 25 30 48.77 {"type":"Point","coordinates":[7.61030549165057,47.5610643863441]} Beuggenstrasse 55 Basel 20 2024-05-24 2024-06-03
1580 1580 859 2 Schwarzwaldstrasse 2508 16 24 8.73 {"type":"Point","coordinates":[7.61030549165057,47.5610643863441]} Beuggenstrasse 55 Basel 20 2024-05-24 2024-06-03
1577 1577 858 1 Horburgstrasse 8924 18 22 4.06 {"type":"Point","coordinates":[7.59632591570233,47.5686478565571]} Efringerstrasse 25 Basel 20 2024-05-13 2024-05-27
1578 1578 858 2           {"type":"Point","coordinates":[7.59632591570233,47.5686478565571]} Efringerstrasse 25 Basel 20 2024-05-13 2024-05-27
1575 1575 857 1 Efringerstrasse 9128 15 21 2.9 {"type":"Point","coordinates":[7.59244266833772,47.5685801965748]} Bläsiring 110 Basel 20 2024-05-13 2024-05-27
1576 1576 857 2           {"type":"Point","coordinates":[7.59244266833772,47.5685801965748]} Bläsiring 110 Basel 20 2024-05-13 2024-05-27
1545 1545 842 1 Klybeckstrasse 5829 22 28 25.37 {"type":"Point","coordinates":[7.59646304957199,47.5664873840887]} Haltingerstrasse 89 Basel 20 2024-04-08 2024-04-22
1546 1546 842 2           {"type":"Point","coordinates":[7.59646304957199,47.5664873840887]} Haltingerstrasse 89 Basel 20 2024-04-08 2024-04-22
1511 1511 819 1 Gotthardstrasse 5065 25 30 47.48 {"type":"Point","coordinates":[7.56141952437448,47.5471777361398]} Göschenenstrasse 20 Basel 20 2024-02-26 2024-03-04
1512 1512 819 2 Steinbühlallee 4857 23 29 32.02 {"type":"Point","coordinates":[7.56141952437448,47.5471777361398]} Göschenenstrasse 20 Basel 20 2024-02-26 2024-03-04
1485 1485 803 1 Allmendstrasse 9076 20 28 22.8 {"type":"Point","coordinates":[7.62361984669292,47.5669987382583]} Zu den Drei Linden vis 50 Basel 20 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 2024-01-29 2024-02-11
1479 1479 800 1 Gotthardstrasse 3284 18 21 2.13 {"type":"Point","coordinates":[7.56418252894124,47.549444820225]} Oberalpstrasse 49 Basel 20 2024-01-22 2024-02-04
1480 1480 800 2 Wanderstrasse 2624 19 24 8.16 {"type":"Point","coordinates":[7.56418252894124,47.549444820225]} Oberalpstrasse 49 Basel 20 2024-01-22 2024-02-04
1457 1457 786 1 Bettingerstrasse 837 21 26 18.04 {"type":"Point","coordinates":[7.64951723774444,47.5822439766782]} Sieglinweg 14 Riehen 20 2023-12-11 2023-12-19
1458 1458 786 2           {"type":"Point","coordinates":[7.64951723774444,47.5822439766782]} Sieglinweg 14 Riehen 20 2023-12-11 2023-12-19
1435 1435 771 1 Unterer Rheinweg 5349 20 27 19.5 {"type":"Point","coordinates":[7.58762507127319,47.5760817884709]} Altrheinweg 38 Basel 20 2023-11-06 2023-11-11
1436 1436 771 2 Wiesendamm 4532 21 26 18.78 {"type":"Point","coordinates":[7.58762507127319,47.5760817884709]} Altrheinweg 38 Basel 20 2023-11-06 2023-11-11
1417 1417 759 1           {"type":"Point","coordinates":[7.61223572275164,47.5560439214018]} Homburgerstrasse 10 Basel 20 2023-10-16 2023-10-24
1418 1418 759 2 St.Alban-Rheinweg 3035 26 31 50.71 {"type":"Point","coordinates":[7.61223572275164,47.5560439214018]} Homburgerstrasse 10 Basel 20 2023-10-16 2023-10-24
1401 1401 751 1 Baselstrasse 13751 19 24 8.7 {"type":"Point","coordinates":[7.65055007142748,47.5849204135477]} Schmiedgasse 7 Basel 20 2023-09-25 2023-10-05
1402 1402 751 2           {"type":"Point","coordinates":[7.65055007142748,47.5849204135477]} Schmiedgasse 7 Basel 20 2023-09-25 2023-10-05
1379 1379 739 1 Aeussere Baselstrasse 1665 22 27 20.0 {"type":"Point","coordinates":[7.64172001796608,47.5763480975335]} Pfaffenlohweg 51 Riehen 20 2023-09-04 2023-09-14
1380 1380 739 2 Meierweg 2409 18 24 11.83 {"type":"Point","coordinates":[7.64172001796608,47.5763480975335]} Pfaffenlohweg 51 Riehen 20 2023-09-04 2023-09-14
1377 1377 737 1           {"type":"Point","coordinates":[7.62594172552074,47.5633165965919]} Im Rheinacker 20 Basel 20 2023-08-28 2023-09-07
1378 1378 737 2 Allmendstrasse 3305 21 26 20.09 {"type":"Point","coordinates":[7.62594172552074,47.5633165965919]} Im Rheinacker 20 Basel 20 2023-08-28 2023-09-07
1333 1333 715 1 Hauensteinstrasse 757 25 31 47.7 {"type":"Point","coordinates":[7.59536237942306,47.5360288273656]} Thiersteinerrain 124 Basel 20 2023-07-03 2023-07-15
1334 1334 715 2 Gundeldingerrain 2620 24 30 40.8 {"type":"Point","coordinates":[7.59536237942306,47.5360288273656]} Thiersteinerrain 124 Basel 20 2023-07-03 2023-07-15
1331 1331 714 1 Vogesenstrasse 4464 18 22 6.2 {"type":"Point","coordinates":[7.57969471307555,47.5676438835298]} Jungstrasse 14 Basel 20 2023-07-03 2023-07-17
1332 1332 714 2 keine         {"type":"Point","coordinates":[7.57969471307555,47.5676438835298]} Jungstrasse 14 Basel 20 2023-07-03 2023-07-17
1327 1327 712 1 Missionsstrasse 10528 14 19 1.2 {"type":"Point","coordinates":[7.57710157349702,47.5618100759156]} Friedensgasse 50 Basel 20 2023-06-26 2023-07-10
1328 1328 712 2 keine         {"type":"Point","coordinates":[7.57710157349702,47.5618100759156]} Friedensgasse 50 Basel 20 2023-06-26 2023-07-10
1305 1305 701 1 Hauensteinstrasse 1440 17 24 7.6 {"type":"Point","coordinates":[7.59513581524628,47.5357593179342]} Thiersteinerrain 130 Basel 20 2023-05-30 2023-06-11
1306 1306 701 2 Gundeldingerrain         {"type":"Point","coordinates":[7.59513581524628,47.5357593179342]} Thiersteinerrain 130 Basel 20 2023-05-30 2023-06-11
1299 1299 698 1 Spalenring 6898 19 24 10.6 {"type":"Point","coordinates":[7.57636076022945,47.5579256655165]} Nonnenweg 32 Basel 20 2023-05-22 2023-06-05
1300 1300 698 2 Socinstrasse 9421 20 24 9.9 {"type":"Point","coordinates":[7.57636076022945,47.5579256655165]} Nonnenweg 32 Basel 20 2023-05-22 2023-06-05
1265 1265 679 1 Unterer Rheinweg 2585 18 23 7.3 {"type":"Point","coordinates":[7.59186767137266,47.5677994015441]} Oetlingerstrasse vis 84 Basel 20 2023-04-11 2023-04-19
1266 1266 679 2 keine         {"type":"Point","coordinates":[7.59186767137266,47.5677994015441]} Oetlingerstrasse vis 84 Basel 20 2023-04-11 2023-04-19
1261 1261 677 1 Sperrstrasse 5116 18 23 7.2 {"type":"Point","coordinates":[7.59250382116415,47.5672049793703]} Müllheimerstrasse vis 77 Basel 20 2023-04-03 2023-04-12
1262 1262 677 2 keine         {"type":"Point","coordinates":[7.59250382116415,47.5672049793703]} Müllheimerstrasse vis 77 Basel 20 2023-04-03 2023-04-12
1249 1249 671 1 Haltingerstrasse 4473 20 24 9.1 {"type":"Point","coordinates":[7.59345031155102,47.5682380015082]} Mörsbergerstrasse 54/52 Basel 20 2023-03-20 2023-03-27
1250 1250 671 2 keine         {"type":"Point","coordinates":[7.59345031155102,47.5682380015082]} Mörsbergerstrasse 54/52 Basel 20 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 2023-03-20 2023-03-29
1248 1248 670 2 Greifengasse 19684 23 28 30.7 {"type":"Point","coordinates":[7.59075939066479,47.5612714203778]} Untere Rheingasse Ecke Vogel Gryff-Gässli Basel 20 2023-03-20 2023-03-29
1191 1191 640 1 Hechtliacker 1414 20 24 9.7 {"type":"Point","coordinates":[7.59974900596643,47.5373359368176]} Fürstensteinerstrasse 65 Basel 20 2023-01-16 2023-01-24
1192 1192 640 2 keine         {"type":"Point","coordinates":[7.59974900596643,47.5373359368176]} Fürstensteinerstrasse 65 Basel 20 2023-01-16 2023-01-24
1187 1187 638 1 Gundeldingerstrasse 3017 19 24 7.9 {"type":"Point","coordinates":[7.60137440156674,47.5390065229469]} Falkensteinerstrasse 43 Basel 20 2023-01-09 2023-01-18
1188 1188 638 2 keine         {"type":"Point","coordinates":[7.60137440156674,47.5390065229469]} Falkensteinerstrasse 43 Basel 20 2023-01-09 2023-01-18
1185 1185 637 1 Tangentenweg 2838 21 29 33.1 {"type":"Point","coordinates":[7.59994905916624,47.5727889893126]} Erlkönigweg vis 39 Basel 20 2023-01-09 2023-01-18
1186 1186 637 2 Erlenmattstrasse 2160 20 27 22.0 {"type":"Point","coordinates":[7.59994905916624,47.5727889893126]} Erlkönigweg vis 39 Basel 20 2023-01-09 2023-01-18
1177 1177 633 1 Petersgasse 2753 18 24 9.7 {"type":"Point","coordinates":[7.58568093527734,47.5602706404515]} Herbergsgasse 6 Basel 20 2022-12-27 2023-01-09
1178 1178 633 2 keine         {"type":"Point","coordinates":[7.58568093527734,47.5602706404515]} Herbergsgasse 6 Basel 20 2022-12-27 2023-01-09
1161 1161 624 1 Güterstrasse 7680 19 25 11.9 {"type":"Point","coordinates":[7.58744535199482,47.5449790320303]} Gempenstrasse 11 Basel 20 2022-12-05 2022-12-14
1162 1162 624 2 keine         {"type":"Point","coordinates":[7.58744535199482,47.5449790320303]} Gempenstrasse 11 Basel 20 2022-12-05 2022-12-14
1155 1155 621 1 Mühlestiegstrasse 614 22 28 27.2 {"type":"Point","coordinates":[7.64874249483132,47.5775767615473]} Unterm Schellenberg vis 16 Riehen 20 2022-11-28 2022-12-07
1156 1156 621 2 Grenzacherweg 533 21 26 18.9 {"type":"Point","coordinates":[7.64874249483132,47.5775767615473]} Unterm Schellenberg vis 16 Riehen 20 2022-11-28 2022-12-07
1145 1145 616 1 Lachenstrasse 2109 22 27 25.7 {"type":"Point","coordinates":[7.5672418119402,47.5670916726259]} Dammerkirchstrasse 37 Basel 20 2022-11-28 2022-12-01
1146 1146 616 2 Burgfelderstrasse 2149 22 27 22.8 {"type":"Point","coordinates":[7.5672418119402,47.5670916726259]} Dammerkirchstrasse 37 Basel 20 2022-11-28 2022-12-01
1125 1125 606 1 Lindenberg 19248 17 21 2.4 {"type":"Point","coordinates":[7.59422033281635,47.5588655272957]} Rheingasse vis 69 Basel 20 2022-10-24 2022-11-02
1126 1126 606 2 Greifengasse 11659 23 26 18.9 {"type":"Point","coordinates":[7.59422033281635,47.5588655272957]} Rheingasse vis 69 Basel 20 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" 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