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

97 rows where Ort = "Basel", Richtung ID = 2 and Zone = 20 sorted by Messung-ID descending

✎ View and edit SQL

This data as json, copyable, geojson, CSV (advanced)

Suggested facets: V50, V85

Messung-ID >30

Zone 1

Richtung ID 1

Ort 1

  • Basel · 97 ✖
Link rowid Messung-ID ▲ Richtung ID Richtung Fzg V50 V85 Ue_Quote geometry Strasse Strasse_Nr Ort Zone Messbeginn Messende
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
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
1916 1916 1042 2           {"type":"Point","coordinates":[7.57363089208417,47.55653482902]} Palmenstrasse 20 Basel 20 2025-06-23 2025-07-05
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
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
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
1786 1786 971 2           {"type":"Point","coordinates":[7.58684847776975,47.5586979582546]} Stadthausgasse 10 Basel 20 2025-01-13 2025-01-25
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
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
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
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
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
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
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
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
1584 1584 861 2 Beuggenstrasse         {"type":"Point","coordinates":[7.61057737376122,47.5604955818256]} Bergalingerstrasse 30 Basel 20 2024-05-24 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
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
1578 1578 858 2           {"type":"Point","coordinates":[7.59632591570233,47.5686478565571]} Efringerstrasse 25 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
1546 1546 842 2           {"type":"Point","coordinates":[7.59646304957199,47.5664873840887]} Haltingerstrasse 89 Basel 20 2024-04-08 2024-04-22
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
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
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
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
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
1402 1402 751 2           {"type":"Point","coordinates":[7.65055007142748,47.5849204135477]} Schmiedgasse 7 Basel 20 2023-09-25 2023-10-05
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
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
1332 1332 714 2 keine         {"type":"Point","coordinates":[7.57969471307555,47.5676438835298]} Jungstrasse 14 Basel 20 2023-07-03 2023-07-17
1328 1328 712 2 keine         {"type":"Point","coordinates":[7.57710157349702,47.5618100759156]} Friedensgasse 50 Basel 20 2023-06-26 2023-07-10
1306 1306 701 2 Gundeldingerrain         {"type":"Point","coordinates":[7.59513581524628,47.5357593179342]} Thiersteinerrain 130 Basel 20 2023-05-30 2023-06-11
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
1266 1266 679 2 keine         {"type":"Point","coordinates":[7.59186767137266,47.5677994015441]} Oetlingerstrasse vis 84 Basel 20 2023-04-11 2023-04-19
1262 1262 677 2 keine         {"type":"Point","coordinates":[7.59250382116415,47.5672049793703]} Müllheimerstrasse vis 77 Basel 20 2023-04-03 2023-04-12
1250 1250 671 2 keine         {"type":"Point","coordinates":[7.59345031155102,47.5682380015082]} Mörsbergerstrasse 54/52 Basel 20 2023-03-20 2023-03-27
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
1192 1192 640 2 keine         {"type":"Point","coordinates":[7.59974900596643,47.5373359368176]} Fürstensteinerstrasse 65 Basel 20 2023-01-16 2023-01-24
1188 1188 638 2 keine         {"type":"Point","coordinates":[7.60137440156674,47.5390065229469]} Falkensteinerstrasse 43 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
1178 1178 633 2 keine         {"type":"Point","coordinates":[7.58568093527734,47.5602706404515]} Herbergsgasse 6 Basel 20 2022-12-27 2023-01-09
1162 1162 624 2 keine         {"type":"Point","coordinates":[7.58744535199482,47.5449790320303]} Gempenstrasse 11 Basel 20 2022-12-05 2022-12-14
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
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
1124 1124 605 2 Greifengasse 11586 23 28 29.9 {"type":"Point","coordinates":[7.59257495599841,47.5596141916172]} Rheingasse 46 Basel 20 2022-10-24 2022-11-02
1122 1122 604 2 Greifengasse 19766 15 20 1.4 {"type":"Point","coordinates":[7.59146193523346,47.5606859094864]} Rheingasse 7 Basel 20 2022-10-24 2022-11-02
1096 1096 590 2 Güterstrasse 6218 16 20 1.4 {"type":"Point","coordinates":[7.59463914098402,47.5430449546144]} Tellplatz Ecke Tellstrasse 1 Basel 20 2022-09-19 2022-10-03
1092 1092 588 2 Münsterplatz 23585 15 20 1.2 {"type":"Point","coordinates":[7.59248468972336,47.5559538621852]} Rittergasse 4 Basel 20 2022-09-12 2022-09-24
1088 1088 586 2 Feldbergstrasse 4249 19 24 9.8 {"type":"Point","coordinates":[7.59651584799738,47.5713097324286]} Efringerstrasse 104 Basel 20 2022-09-05 2022-09-18
1086 1086 585 2 Tangentenweg 4473 17 22 3.1 {"type":"Point","coordinates":[7.60000140342295,47.5725191063077]} Erlkönigweg 37 Basel 20 2022-09-05 2022-09-19
1084 1084 584 2 Erlenstrasse 39 14077 19 25 12.9 {"type":"Point","coordinates":[7.60103087591601,47.5701703234208]} Erlenmattstrasse 24 Basel 20 2022-09-05 2022-09-19
1046 1046 564 2 Bruderholzallee 1862 9 14 31.2 {"type":"Point","coordinates":[7.59015977165044,47.5372588672795]} Wolfschlucht-Promenade vis 10 Basel 20 2022-07-04 2022-07-18
1044 1044 563 2 Greifengasse 15282 19 25 11.1 {"type":"Point","coordinates":[7.59166031209703,47.5603618752019]} Rheingasse 8 Basel 20 2022-07-04 2022-07-17
1034 1034 557 2 Oberalpstrasse 4611 19 23 4.4 {"type":"Point","coordinates":[7.5679288519998,47.5489685568069]} Realpstrasse 27 Basel 20 2022-06-13 2022-06-27
1006 1006 541 2 Käferholzstrasse 1587 17 23 5.3 {"type":"Point","coordinates":[7.61751740240648,47.5684913342288]} Tüllingerstrasse 59 Basel 20 2022-05-02 2022-05-15
994 994 535 2 Erlkönigweg 6995 21 26 17.3 {"type":"Point","coordinates":[7.5986357463496,47.569157349027]} Tangentenweg 47.569185 / 7.598653 Basel 20 2022-04-25 2022-05-08
982 982 528 2 Lehenmattstrasse 5376 23 29 32.7 {"type":"Point","coordinates":[7.61765195701331,47.5531478283856]} Nasenweg 5 Basel 20 2022-04-04 2022-04-16
970 970 522 2 keine         {"type":"Point","coordinates":[7.60922042267882,47.5462532768083]} Sissacherstrasse 39 Basel 20 2022-03-21 2022-03-29
940 940 507 2 Lindenberg 9914 20 24 10.4 {"type":"Point","coordinates":[7.59241611118468,47.5598212569935]} Rheingasse 31 Basel 20 2022-02-14 2022-02-20
938 938 506 2 Untere Rheingasse 14815 21 27 20.0 {"type":"Point","coordinates":[7.59084149736871,47.5621077289874]} Webergasse 15 Basel 20 2022-02-14 2022-03-23
904 904 488 2 keine         {"type":"Point","coordinates":[7.5964480919894,47.566372284931]} Haltingerstrasse 90 Basel 20 2022-01-03 2022-01-13
874 874 473 2 keine         {"type":"Point","coordinates":[7.58832231339698,47.5403371189926]} Dittingerstrasse 41/43 Basel 20 2021-12-06 2021-12-16
854 854 463 2 St. Johanns-Ring 4268 18 23 6.2 {"type":"Point","coordinates":[7.57768184270829,47.5652359889026]} Davidsbodenstrasse 14 Basel 20 2021-11-01 2021-11-15
820 820 444 2 Reservoirstrasse 340 18 26 20.6 {"type":"Point","coordinates":[7.5930257352995,47.5271100832131]} Beim Wasserturm 21 Basel 20 2021-09-20 2021-10-04
818 818 443 2 Giornicostrasse 2014 11 21 6.1 {"type":"Point","coordinates":[7.59209700985004,47.5273811254302]} Biascastrasse 11 Basel 20 2021-09-20 2021-10-03
798 798 433 2           {"type":"Point","coordinates":[7.59342196073433,47.5676264676579]} Mörsbergerstrasse vis 44 Basel 20 2021-08-30 2021-09-13
746 746 406 2 Allmendstrasse 4487 16 21 1.7 {"type":"Point","coordinates":[7.62583159291014,47.5633608429593]} Im Rheinacker vis 20 Basel 20 2021-06-28 2021-07-12
730 730 397 2 Türkheimerstrasse 1829 16 23 9.0 {"type":"Point","coordinates":[7.57118155892148,47.5589209755302]} Pfeffelstrasse 31 Basel 20 2021-06-07 2021-06-21
702 702 382 2 Hardrain 1711 21 25 14.7 {"type":"Point","coordinates":[7.6166310357514,47.5457924948063]} Scherkesselweg vis 19 Basel 20 2021-05-03 2021-05-17
698 698 380 2 Hardrain 9196 20 28 24.0 {"type":"Point","coordinates":[7.61513249803579,47.5465412595497]} Scherkesselweg Höhe Neusatzweglein Basel 20 2021-05-03 2021-05-16
696 696 379 2           {"type":"Point","coordinates":[7.56333291085153,47.5662145318788]} Markircherstrasse 22 Basel 20 2021-04-26 2021-05-10
694 694 378 2 keine         {"type":"Point","coordinates":[7.60103073908893,47.5701253551461]} Erlenmattstrasse 24 Basel 20 2021-04-26 2021-05-07
664 664 362 2 keine         {"type":"Point","coordinates":[7.57968142435134,47.5676438996012]} Jungstrasse 14 Basel 20 2021-03-29 2021-04-09
606 606 328 2 Lothringerstrasse 3234 17 25 12.7 {"type":"Point","coordinates":[7.57971962789582,47.5670142945624]} Fatiostrasse 29 Basel 20 2021-01-18 2021-02-01
484 484 263 2 Schwörstadterstrasse 2503 20 24 8.5 {"type":"Point","coordinates":[7.61107553934715,47.5612880919316]} Beuggenstrasse vis 59 (Schwarzwaldallee) Basel 20 2020-08-17 2020-08-22
456 456 249 2 Zum Bischofstein 1117 20 26 18.0 {"type":"Point","coordinates":[7.60308518362734,47.5597437319387]} Chrischonastrasse 48 Basel 20 2020-07-13 2020-07-20
454 454 248 2 keine         {"type":"Point","coordinates":[7.59790939214449,47.5395059715665]} Laufenstrasse 73 Basel 20 2020-07-14 2020-07-27
436 436 236 2 Marktplatz 11984 19 27 20.6 {"type":"Point","coordinates":[7.59106036329772,47.5549934037614]} Freie Strasse 70 Basel 20 2020-06-29 2020-07-13
432 432 233 2 Kleinriehenstrasse 898 15 22 5.0 {"type":"Point","coordinates":[7.61689965022385,47.5665586347221]} Hirzbrunnenschanze 57 Basel 20 2020-06-22 2020-07-06
422 422 227 2 St. Alban-Graben 13741 8 25 17.9 {"type":"Point","coordinates":[7.59106036329772,47.5549934037614]} Freie Strasse 70 Basel 20 2020-06-08 2020-06-22
360 360 191 2 keine         {"type":"Point","coordinates":[7.5995898221188,47.5373991135078]} Fürstensteinerstrasse 63 Basel 20 2020-03-30 2020-04-15
312 312 165 2 keine         {"type":"Point","coordinates":[7.59053265506327,47.5656426603348]} Kandererstrasse vis 29 Basel 20 2018-05-28 2018-06-11
298 298 158 2 keine         {"type":"Point","coordinates":[7.58579334939798,47.5432003625104]} Gempenstrasse 68 Basel 20 2018-08-27 2018-09-06
278 278 145 2 Oberalpstrasse 1231 18 22 5.1 {"type":"Point","coordinates":[7.56790224041351,47.5489505987877]} Realpstrasse 27 Basel 20 2020-03-16 2020-03-21
276 276 144 2 Oberalpstrasse 1827 18 22 3.0 {"type":"Point","coordinates":[7.56864704362405,47.5493185150342]} Realpstrasse 11 Basel 20 2020-03-16 2020-03-25
270 270 141 2 Horburgstrasse 12539 22 26 20.2 {"type":"Point","coordinates":[7.59629524482288,47.5686119232631]} Efringerstrasse 25 Basel 20 2018-06-04 2018-06-18
260 260 136 2 keine         {"type":"Point","coordinates":[7.57292955238577,47.5565985947134]} Birkenstrasse 43 Basel 20 2018-02-26 2018-03-09
258 258 135 2 keine         {"type":"Point","coordinates":[7.61058107584428,47.5604074378366]} Bergalingerstrasse 28 Basel 20 2018-01-22 2018-02-05
256 256 134 2 Wiesendamm 21511 21 27 23.2 {"type":"Point","coordinates":[7.5877594792075,47.5766185387455]} Altrheinweg 42 Basel 20 2018-05-28 2018-06-11
224 224 118 2 Ensisheimerstrasse 7208 18 22 5.3 {"type":"Point","coordinates":[7.56941064451827,47.5627992658611]} Hagentalerstrasse 64 Basel 20 2018-11-06 2018-11-23
210 210 111 2 keine         {"type":"Point","coordinates":[7.59074607792212,47.5612624440323]} Webergasse 15 Basel 20 2019-04-29 2019-05-10
202 202 105 2 Elsässerstrasse 5641 17 22 4.9 {"type":"Point","coordinates":[7.57940743270891,47.5695688810067]} Wasserstrasse keine Basel 20 2019-01-07 2019-01-21
196 196 100 2 St. Johanns-Ring 12193 16 27 20.4 {"type":"Point","coordinates":[7.58526333447601,47.5630322375988]} St. Johanns-Rheinweg 49 Basel 20 2019-07-23 2019-08-05
178 178 91 2 Speiserstrasse 5604 21 26 19.6 {"type":"Point","coordinates":[7.60850329298333,47.5463082877729]} Sissacherstrasse 29 Basel 20 2019-08-19 2019-09-01
72 72 37 2 Unterer Batterieweg 640 24 32 42.0 {"type":"Point","coordinates":[7.58628999646262,47.5354650757601]} Marignanostrasse 15 Basel 20 2019-05-06 2019-05-10
70 70 36 2 Schäublinstrasse 2139 22 29 27.6 {"type":"Point","coordinates":[7.58631650808867,47.5354470545596]} Marignanostrasse 15 Basel 20 2019-06-11 2019-06-24
16 16 8 2 keine         {"type":"Point","coordinates":[7.59270937776494,47.5831774740324]} Dorfstrasse vis 28 Basel 20 2018-01-21 2019-02-01

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");