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
36 rows where Ort = "Basel" and Zone = "40.0" sorted by Messung-ID descending
This data as json, CSV (advanced)
Suggested facets: Richtung, V50, V85, geometry, Strasse_Nr, Messbeginn, Messende
Messung-ID 18
Messende (date) 17
- 2021-06-28 4
- 2018-06-25 2
- 2020-01-02 2
- 2020-01-16 2
- 2021-06-26 2
- 2021-07-12 2
- 2022-11-19 2
- 2022-12-19 2
- 2023-09-09 2
- 2024-04-29 2
- 2024-07-15 2
- 2024-09-02 2
- 2024-10-07 2
- 2024-10-14 2
- 2024-12-09 2
- 2025-06-16 2
- 2025-06-30 2
Messbeginn (date) 16
- 2021-06-14 6
- 2018-06-11 2
- 2019-12-23 2
- 2020-01-06 2
- 2021-06-28 2
- 2022-11-07 2
- 2022-12-05 2
- 2023-08-28 2
- 2024-04-15 2
- 2024-07-01 2
- 2024-08-19 2
- 2024-09-23 2
- 2024-10-07 2
- 2024-11-25 2
- 2025-06-02 2
- 2025-06-16 2
Strasse 9
Zone 1
- 40.0 · 36 ✖
Ort 1
- Basel · 36 ✖
| Link | rowid | Messung-ID ▲ | Richtung ID | Richtung | Fzg | V50 | V85 | Ue_Quote | geometry | Strasse | Strasse_Nr | Ort | Zone | Messbeginn | Messende |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1913 | 1913 | 1039 | 1 | Kehrplatz (Hafenbecken 2) | 3949.0 | 24.0 | 34.0 | 0.99 | {"type":"Point","coordinates":[7.60177442700159,47.585606915772]} | Grenzstrasse | 90 | Basel | 40.0 | 2025-06-16 | 2025-06-30 |
| 1914 | 1914 | 1039 | 2 | Neuhausstrasse | 3839.0 | 25.0 | 35.0 | 1.46 | {"type":"Point","coordinates":[7.60177442700159,47.585606915772]} | Grenzstrasse | 90 | Basel | 40.0 | 2025-06-16 | 2025-06-30 |
| 1899 | 1899 | 1032 | 1 | Hiltalingerstrasse | 5342.0 | 41.0 | 48.0 | 23.21 | {"type":"Point","coordinates":[7.59532696355775,47.5859827006908]} | Südquaistrasse | 31 | Basel | 40.0 | 2025-06-02 | 2025-06-16 |
| 1900 | 1900 | 1032 | 2 | Areal Hafenbecken II | 6408.0 | 40.0 | 47.0 | 20.51 | {"type":"Point","coordinates":[7.59532696355775,47.5859827006908]} | Südquaistrasse | 31 | Basel | 40.0 | 2025-06-02 | 2025-06-16 |
| 1747 | 1747 | 951 | 1 | Luzern | 265697.0 | 47.0 | 53.0 | 59.87 | {"type":"Point","coordinates":[7.60663828549183,47.5446156669003]} | A2 Einfahrt Wolf | Einfahrt Grosspeter | Basel | 40.0 | 2024-11-25 | 2024-12-09 |
| 1748 | 1748 | 951 | 2 | {"type":"Point","coordinates":[7.60663828549183,47.5446156669003]} | A2 Einfahrt Wolf | Einfahrt Grosspeter | Basel | 40.0 | 2024-11-25 | 2024-12-09 | |||||
| 1695 | 1695 | 922 | 1 | Banngrenze Bettingen | 6541.0 | 45.0 | 50.0 | 44.57 | {"type":"Point","coordinates":[7.65120188580046,47.5760370737766]} | Bettingerstrasse | vis 117 | Basel | 40.0 | 2024-10-07 | 2024-10-14 |
| 1696 | 1696 | 922 | 2 | Baselstrasse | 6354.0 | 46.0 | 53.0 | 54.52 | {"type":"Point","coordinates":[7.65120188580046,47.5760370737766]} | Bettingerstrasse | vis 117 | Basel | 40.0 | 2024-10-07 | 2024-10-14 |
| 1687 | 1687 | 917 | 1 | Bettingerstrasse | 31346.0 | 42.0 | 46.0 | 20.44 | {"type":"Point","coordinates":[7.64843990569685,47.5793796405675]} | Grenzacherweg | 15 | Basel | 40.0 | 2024-09-23 | 2024-10-07 |
| 1688 | 1688 | 917 | 2 | Im Finsteren Boden | 33238.0 | 44.0 | 49.0 | 34.97 | {"type":"Point","coordinates":[7.64843990569685,47.5793796405675]} | Grenzacherweg | 15 | Basel | 40.0 | 2024-09-23 | 2024-10-07 |
| 1659 | 1659 | 902 | 1 | Landesgrenze | 17008.0 | 36.0 | 40.0 | 2.35 | {"type":"Point","coordinates":[7.65827786501645,47.5869764270345]} | Inzlingerstrasse | Verzweigung Bosenhaldenweg | Basel | 40.0 | 2024-08-19 | 2024-09-02 |
| 1660 | 1660 | 902 | 2 | Baselstrasse | 18248.0 | 34.0 | 39.0 | 1.4 | {"type":"Point","coordinates":[7.65827786501645,47.5869764270345]} | Inzlingerstrasse | Verzweigung Bosenhaldenweg | Basel | 40.0 | 2024-08-19 | 2024-09-02 |
| 1619 | 1619 | 882 | 1 | Kehrplatz | 11872.0 | 28.0 | 36.0 | 3.1 | {"type":"Point","coordinates":[7.58794980530131,47.5847926286906]} | Westquaistrasse | ohne | Basel | 40.0 | 2024-07-01 | 2024-07-15 |
| 1620 | 1620 | 882 | 2 | Hochbergerstrasse | 9959.0 | 26.0 | 33.0 | 1.42 | {"type":"Point","coordinates":[7.58794980530131,47.5847926286906]} | Westquaistrasse | ohne | Basel | 40.0 | 2024-07-01 | 2024-07-15 |
| 1553 | 1553 | 846 | 1 | Hochbergerstrasse | 7929.0 | 32.0 | 40.0 | 5.57 | {"type":"Point","coordinates":[7.58771275258255,47.5846364425715]} | Westquaistrasse | vis 28 | Basel | 40.0 | 2024-04-15 | 2024-04-29 |
| 1554 | 1554 | 846 | 2 | Kehrplatz | 7937.0 | 33.0 | 40.0 | 5.49 | {"type":"Point","coordinates":[7.58771275258255,47.5846364425715]} | Westquaistrasse | vis 28 | Basel | 40.0 | 2024-04-15 | 2024-04-29 |
| 1381 | 1381 | 740 | 1 | Kehrplatz | 6701.0 | 38.0 | 46.0 | 17.82 | {"type":"Point","coordinates":[7.59027204583632,47.5838363059776]} | Hafenstrasse | vis 7 | Basel | 40.0 | 2023-08-28 | 2023-09-09 |
| 1382 | 1382 | 740 | 2 | Westquaistrasse | 6656.0 | 40.0 | 48.0 | 25.05 | {"type":"Point","coordinates":[7.59027204583632,47.5838363059776]} | Hafenstrasse | vis 7 | Basel | 40.0 | 2023-08-28 | 2023-09-09 |
| 1157 | 1157 | 622 | 1 | Wiesendamm | 3537.0 | 34.0 | 43.0 | 10.1 | {"type":"Point","coordinates":[7.58664315888418,47.581458550452]} | Uferstrasse | 90 | Basel | 40.0 | 2022-12-05 | 2022-12-19 |
| 1158 | 1158 | 622 | 2 | Unterer Rheinweg | 2878.0 | 35.0 | 44.0 | 11.4 | {"type":"Point","coordinates":[7.58664315888418,47.581458550452]} | Uferstrasse | 90 | Basel | 40.0 | 2022-12-05 | 2022-12-19 |
| 1133 | 1133 | 610 | 1 | Areal Hafenbecken 2 | 6421.0 | 44.0 | 51.0 | 41.5 | {"type":"Point","coordinates":[7.59710216162325,47.5852671055868]} | Südquaistrasse | vis 55 | Basel | 40.0 | 2022-11-07 | 2022-11-19 |
| 1134 | 1134 | 610 | 2 | Hiltalingerstrasse | 6621.0 | 45.0 | 52.0 | 46.1 | {"type":"Point","coordinates":[7.59710216162325,47.5852671055868]} | Südquaistrasse | vis 55 | Basel | 40.0 | 2022-11-07 | 2022-11-19 |
| 747 | 747 | 407 | 1 | Bettingerstrasse | 30792.0 | 37.0 | 42.0 | 2.3 | {"type":"Point","coordinates":[7.64640580813929,47.5748288883925]} | Grenzacherweg | 97 | Basel | 40.0 | 2021-06-28 | 2021-07-12 |
| 748 | 748 | 407 | 2 | Im finstern Boden | 32286.0 | 38.0 | 43.0 | 6.4 | {"type":"Point","coordinates":[7.64640580813929,47.5748288883925]} | Grenzacherweg | 97 | Basel | 40.0 | 2021-06-28 | 2021-07-12 |
| 735 | 735 | 400 | 1 | Areal Hafenbecken 2 | 5655.0 | 43.0 | 50.0 | 34.8 | {"type":"Point","coordinates":[7.59718178682282,47.5852220291141]} | Südquaistrasse | vis 55 | Basel | 40.0 | 2021-06-14 | 2021-06-28 |
| 736 | 736 | 400 | 2 | Hiltalingerstrasse | 7131.0 | 44.0 | 52.0 | 42.8 | {"type":"Point","coordinates":[7.59718178682282,47.5852220291141]} | Südquaistrasse | vis 55 | Basel | 40.0 | 2021-06-14 | 2021-06-28 |
| 733 | 733 | 399 | 1 | Kehrplatz | 8159.0 | 43.0 | 51.0 | 37.0 | {"type":"Point","coordinates":[7.59047780502986,47.5837380074924]} | Hafenstrasse | vis 7 | Basel | 40.0 | 2021-06-14 | 2021-06-26 |
| 734 | 734 | 399 | 2 | Westquaistrasse | 5263.0 | 44.0 | 52.0 | 41.1 | {"type":"Point","coordinates":[7.59047780502986,47.5837380074924]} | Hafenstrasse | vis 7 | Basel | 40.0 | 2021-06-14 | 2021-06-26 |
| 731 | 731 | 398 | 1 | Hochbergerstrasse | 11060.0 | 19.0 | 28.0 | 0.9 | {"type":"Point","coordinates":[7.58744951399404,47.5846232882956]} | Westquaistrasse | vis 28 | Basel | 40.0 | 2021-06-14 | 2021-06-28 |
| 732 | 732 | 398 | 2 | Kehrplatz Hafenbecken 1 | 9621.0 | 20.0 | 30.0 | 1.2 | {"type":"Point","coordinates":[7.58744951399404,47.5846232882956]} | Westquaistrasse | vis 28 | Basel | 40.0 | 2021-06-14 | 2021-06-28 |
| 301 | 301 | 160 | 1 | Kehrplatz | 10912.0 | 39.0 | 48.0 | 23.6 | {"type":"Point","coordinates":[7.60180451986575,47.5841454063535]} | Grenzstrasse | keine | Basel | 40.0 | 2018-06-11 | 2018-06-25 |
| 302 | 302 | 160 | 2 | Neuhausstrasse | 11051.0 | 38.0 | 48.0 | 22.0 | {"type":"Point","coordinates":[7.60180451986575,47.5841454063535]} | Grenzstrasse | keine | Basel | 40.0 | 2018-06-11 | 2018-06-25 |
| 37 | 37 | 19 | 1 | Areal Hafenbecken 2 | 3133.0 | 43.0 | 50.0 | 32.4 | {"type":"Point","coordinates":[7.59716852041868,47.5852310407978]} | Südquaistrasse | vis 55 | Basel | 40.0 | 2020-01-06 | 2020-01-16 |
| 38 | 38 | 19 | 2 | Hiltalingerstrasse | 3513.0 | 44.0 | 52.0 | 38.3 | {"type":"Point","coordinates":[7.59716852041868,47.5852310407978]} | Südquaistrasse | vis 55 | Basel | 40.0 | 2020-01-06 | 2020-01-16 |
| 31 | 31 | 16 | 1 | Hochbergerstrasse | 2795.0 | 32.0 | 39.0 | 4.6 | {"type":"Point","coordinates":[7.58744948892393,47.5846142946851]} | Westquaistrasse | vis 28 | Basel | 40.0 | 2019-12-23 | 2020-01-02 |
| 32 | 32 | 16 | 2 | Kehrplatz Hafenbecken 1 | 2723.0 | 34.0 | 41.0 | 6.2 | {"type":"Point","coordinates":[7.58744948892393,47.5846142946851]} | Westquaistrasse | vis 28 | Basel | 40.0 | 2019-12-23 | 2020-01-02 |
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");