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
128 rows where Ort = "Riehen" and Richtung ID = 1 sorted by Messung-ID descending
This data as json, CSV (advanced)
Strasse >30
- Aeussere Baselstrasse 6
- Kilchgrundstrasse 6
- Bettingerstrasse 5
- Inzlingerstrasse 5
- Mühlestiegstrasse 5
- Weilstrasse 5
- Chrischonaweg 4
- Grenzacherweg 4
- Niederholzstrasse 4
- Baselstrasse 3
- Bischoffweg 3
- Gotenstrasse 3
- Pfaffenlohweg 3
- Rudolf Wackernagel-Strasse 3
- Rössligasse 3
- Schützengasse 3
- Bahnhofstrasse 2
- Burgstrasse 2
- Eisenbahnweg 2
- Hackbergstrasse 2
- Haselrain 2
- Hörnliallee 2
- Im Hirshalm 2
- Kohlistieg 2
- Kornfeldstrasse 2
- Lörracherstrasse 2
- Oberdorfstrasse 2
- Paradiesstrasse 2
- Rauracherstrasse 2
- Schäferstrasse 2
- …
Messung-ID >30
Messende (date) >30
- 2019-06-19 2
- 2020-03-21 2
- 2020-05-18 2
- 2020-07-13 2
- 2020-08-10 2
- 2024-04-07 2
- 2025-02-15 2
- 2025-05-05 2
- 2018-04-23 1
- 2018-08-05 1
- 2018-08-06 1
- 2018-08-20 1
- 2018-08-21 1
- 2018-09-05 1
- 2019-03-02 1
- 2019-03-18 1
- 2019-03-30 1
- 2019-05-01 1
- 2019-07-15 1
- 2019-08-24 1
- 2019-09-30 1
- 2019-12-10 1
- 2019-12-27 1
- 2020-01-27 1
- 2020-02-07 1
- 2020-03-01 1
- 2020-04-26 1
- 2020-05-09 1
- 2020-06-22 1
- 2020-06-27 1
- …
Messbeginn (date) >30
- 2023-10-09 3
- 2025-02-03 3
- 2025-02-17 3
- 2018-07-23 2
- 2018-08-06 2
- 2019-06-03 2
- 2020-03-09 2
- 2020-05-04 2
- 2020-06-29 2
- 2020-07-27 2
- 2021-01-18 2
- 2021-08-23 2
- 2021-11-15 2
- 2022-01-10 2
- 2022-10-17 2
- 2022-11-28 2
- 2022-12-12 2
- 2023-10-23 2
- 2024-03-25 2
- 2025-04-22 2
- 2025-05-05 2
- 2018-04-09 1
- 2018-08-21 1
- 2019-02-18 1
- 2019-03-04 1
- 2019-03-18 1
- 2019-04-15 1
- 2019-07-01 1
- 2019-08-12 1
- 2019-09-23 1
- …
Richtung ID 1
- 1 · 128 ✖
Ort 1
- Riehen · 128 ✖
| Link | rowid | Messung-ID ▲ | Richtung ID | Richtung | Fzg | V50 | V85 | Ue_Quote | geometry | Strasse | Strasse_Nr | Ort | Zone | Messbeginn | Messende |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1891 | 1891 | 1028 | 1 | Bettingerstrasse | 2130.0 | 25.0 | 31.0 | 3.52 | {"type":"Point","coordinates":[7.64924405986338,47.578371795767]} | Mühlestiegstrasse | 40 | Riehen | 30.0 | 2025-05-26 | 2025-06-09 |
| 1887 | 1887 | 1026 | 1 | Oberdorfstrasse | 1765.0 | 30.0 | 36.0 | 15.81 | {"type":"Point","coordinates":[7.58862790252353,47.5768035938454]} | Schlossgasse | 14 | Riehen | 30.0 | 2025-05-05 | 2025-05-16 |
| 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 |
| 1871 | 1871 | 1015 | 1 | Chrischonaweglein | 1878.0 | 28.0 | 34.0 | 9.74 | {"type":"Point","coordinates":[7.66399535505562,47.5822384268202]} | Chrischonaweg | vis 113 | Riehen | 30.0 | 2025-04-22 | 2025-05-05 |
| 1867 | 1867 | 1013 | 1 | Aeussere Baselstrasse | 5400.0 | 34.0 | 38.0 | 32.94 | {"type":"Point","coordinates":[7.64022106576007,47.5767707078974]} | Kilchgrundstrasse | 29 | Riehen | 30.0 | 2025-04-22 | 2025-05-05 |
| 1863 | 1863 | 1011 | 1 | Aeussere Baselstrasse | 2513.0 | 30.0 | 36.0 | 17.31 | {"type":"Point","coordinates":[7.64078806450948,47.576280468321]} | Essigstrasse | 31 | Riehen | 30.0 | 2025-04-14 | 2025-04-25 |
| 1853 | 1853 | 1006 | 1 | Garbenstrasse | 15536.0 | 26.0 | 34.0 | 9.57 | {"type":"Point","coordinates":[7.64560695158463,47.577885466371]} | Mühlestiegstrasse | vis 18 | Riehen | 30.0 | 2025-03-31 | 2025-04-14 |
| 1819 | 1819 | 988 | 1 | Landesgrenze | 18698.0 | 32.0 | 37.0 | 22.29 | {"type":"Point","coordinates":[7.66621760375428,47.5859134104368]} | Inzlingerstrasse | 270 | Riehen | 30.0 | 2025-02-17 | 2025-03-02 |
| 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 |
| 1815 | 1815 | 986 | 1 | Baselstrasse | 37430.0 | 30.0 | 34.0 | 10.17 | {"type":"Point","coordinates":[7.65374746533202,47.5925915249583]} | Lörracherstrasse | 88 | Riehen | 30.0 | 2025-02-17 | 2025-02-27 |
| 1807 | 1807 | 982 | 1 | Stettenlochweg | 3144.0 | 25.0 | 30.0 | 2.93 | {"type":"Point","coordinates":[7.65912155432842,47.5894354943859]} | Bischoffweg | 12 | Riehen | 30.0 | 2025-02-03 | 2025-02-16 |
| 1805 | 1805 | 981 | 1 | Schmiedgasse | 38534.0 | 37.0 | 44.0 | 10.79 | {"type":"Point","coordinates":[7.65070731408119,47.5816770121562]} | Eisenbahnweg | 57 | Riehen | 40.0 | 2025-02-03 | 2025-02-15 |
| 1803 | 1803 | 980 | 1 | Lörracherstrasse | 26001.0 | 31.0 | 36.0 | 19.01 | {"type":"Point","coordinates":[7.64461816455535,47.5923526158541]} | Weilstrasse | 69 | Riehen | 30.0 | 2025-02-03 | 2025-02-15 |
| 1725 | 1725 | 940 | 1 | Aeussere Baselstrasse | 6457.0 | 19.0 | 24.0 | 0.37 | {"type":"Point","coordinates":[7.64647309420148,47.5801548262777]} | Burgstrasse | 44 | Riehen | 30.0 | 2024-11-04 | 2024-11-18 |
| 1713 | 1713 | 931 | 1 | Banngrenze Bettingen | 16673.0 | 38.0 | 43.0 | 7.2 | {"type":"Point","coordinates":[7.65126008846067,47.5769669145819]} | Bettingerstrasse | vis 120 | Riehen | 40.0 | 2024-10-21 | 2024-11-04 |
| 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 |
| 1655 | 1655 | 900 | 1 | Stettenlochweg | 1386.0 | 31.0 | 38.0 | 24.17 | {"type":"Point","coordinates":[7.65990024957836,47.5903117963642]} | Bischoffweg | vis 36 | Riehen | 30.0 | 2024-08-19 | 2024-09-02 |
| 1543 | 1543 | 841 | 1 | Bettingerstrasse | 84437.0 | 29.0 | 36.0 | 0.54 | {"type":"Point","coordinates":[7.64799516273106,47.5828978655815]} | Baselstrasse | 2 | Riehen | 40.0 | 2024-04-08 | 2024-04-22 |
| 1537 | 1537 | 838 | 1 | Grienbodenweg | 6074.0 | 29.0 | 86.0 | 30.66 | {"type":"Point","coordinates":[7.65521502309861,47.5902495586167]} | Haselrain | Seite Friedhofweg | Riehen | 30.0 | 2024-04-02 | 2024-04-10 |
| 1535 | 1535 | 835 | 1 | {"type":"Point","coordinates":[7.64893891902502,47.5812089524223]} | Bettingerstrasse | vis 32 | Riehen | 40.0 | 2024-03-25 | 2024-04-07 | |||||
| 1531 | 1531 | 833 | 1 | Baselstrasse | 19761.0 | 33.0 | 39.0 | 1.41 | {"type":"Point","coordinates":[7.64893891902502,47.5812089524223]} | Bettingerstrasse | vis 32 | Riehen | 40.0 | 2024-03-25 | 2024-04-07 |
| 1517 | 1517 | 823 | 1 | Gotenstrasse | 3823.0 | 27.0 | 32.0 | 4.34 | {"type":"Point","coordinates":[7.63144250425936,47.5702084913509]} | Im Hirshalm | 52 | Riehen | 30.0 | 2024-03-04 | 2024-03-16 |
| 1505 | 1505 | 814 | 1 | Im Finsteren Boden | 20407.0 | 41.0 | 45.0 | 10.86 | {"type":"Point","coordinates":[7.64574207890312,47.571956585948]} | Grenzacherweg | 190 | Riehen | 40.0 | 2024-02-19 | 2024-03-01 |
| 1477 | 1477 | 799 | 1 | Bettingerstrasse | 42730.0 | 50.0 | 55.0 | 10.9 | {"type":"Point","coordinates":[7.63352656303222,47.5746470066854]} | Aeussere Baselstrasse | 283 | Riehen | 50.0 | 2024-01-15 | 2024-01-21 |
| 1463 | 1463 | 789 | 1 | Aeussere Baselstrass | 2601.0 | 21.0 | 26.0 | 0.96 | {"type":"Point","coordinates":[7.63893818159514,47.5752772726979]} | Im Niederholzboden | 44 | Riehen | 30.0 | 2023-12-18 | 2024-01-02 |
| 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 |
| 1447 | 1447 | 781 | 1 | Schmiedgasse | 9354.0 | 27.0 | 34.0 | 9.93 | {"type":"Point","coordinates":[7.65002487568807,47.5818752148825]} | Bahnhofstrasse | vis 71 | Riehen | 30.0 | 2023-11-20 | 2023-12-11 |
| 1437 | 1437 | 775 | 1 | Rauracherstrasse | 61970.0 | 42.0 | 47.0 | 0.81 | {"type":"Point","coordinates":[7.64238808781208,47.5692724893269]} | Kohlistieg | Höhe Morystrasse | Riehen | 50.0 | 2023-11-13 | 2023-11-27 |
| 1431 | 1431 | 769 | 1 | Wasserstelzenweg | 691.0 | 21.0 | 29.0 | 1.16 | {"type":"Point","coordinates":[7.63953597496268,47.5713217157971]} | Supperstrasse | 43 | Riehen | 30.0 | 2023-11-06 | 2023-11-20 |
| 1425 | 1425 | 763 | 1 | Pfaffenlohweg | 3301.0 | 26.0 | 29.0 | 0.67 | {"type":"Point","coordinates":[7.64298874780951,47.5710027243145]} | Morystrasse | 59 | Riehen | 30.0 | 2023-10-23 | 2023-11-06 |
| 1423 | 1423 | 762 | 1 | Maienbühlweg | 364.0 | 33.0 | 40.0 | 36.26 | {"type":"Point","coordinates":[7.66919245638679,47.587401400959]} | Hohlweg | Ohne | Riehen | 30.0 | 2023-10-23 | 2023-11-01 |
| 1415 | 1415 | 758 | 1 | Bettingerstrasse | 17567.0 | 41.0 | 46.0 | 0.54 | {"type":"Point","coordinates":[7.6467021669591,47.5700572022804]} | Rudolf Wackernagel-Strasse | 38 | Riehen | 50.0 | 2023-10-09 | 2023-10-23 |
| 1413 | 1413 | 757 | 1 | Kehrplatz | 689.0 | 33.0 | 39.0 | 33.09 | {"type":"Point","coordinates":[7.66262834912163,47.5896968089387]} | Auf der Bischoffhöhe | 30 | Riehen | 30.0 | 2023-10-09 | 2023-10-20 |
| 1411 | 1411 | 756 | 1 | Tiefweg | 1074.0 | 22.0 | 32.0 | 8.66 | {"type":"Point","coordinates":[7.64449515959199,47.5742800707717]} | Kornfeldstrasse | 54 | Riehen | 30.0 | 2023-10-09 | 2023-10-15 |
| 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 |
| 1325 | 1325 | 711 | 1 | Hörnliallee | 10660.0 | 29.0 | 33.0 | 7.6 | {"type":"Point","coordinates":[7.63478958592729,47.5675371654362]} | Rauracherstrasse | vis 144 | Riehen | 30.0 | 2023-06-26 | 2023-07-07 |
| 1313 | 1313 | 705 | 1 | Rüchligweg | 1349.0 | 24.0 | 29.0 | 1.6 | {"type":"Point","coordinates":[7.6409792651215,47.5702786445278]} | Rainallee | vis 134 | Riehen | 30.0 | 2023-06-12 | 2023-06-20 |
| 1311 | 1311 | 704 | 1 | Bettingerstrasse | 62873.0 | 29.0 | 34.0 | 0.5 | {"type":"Point","coordinates":[7.64918092213575,47.5842582666605]} | Baselstrasse | visa 34 | Riehen | 40.0 | 2023-06-05 | 2023-06-14 |
| 1303 | 1303 | 700 | 1 | keine | {"type":"Point","coordinates":[7.63615012369898,47.5653224111033]} | Hörnliallee | visa 69 | Riehen | 30.0 | 2023-05-30 | 2023-06-12 | ||||
| 1301 | 1301 | 699 | 1 | {"type":"Point","coordinates":[7.63607182695918,47.5657092737821]} | Hörnliallee | 75 | Riehen | 30.0 | 2023-04-17 | 2023-04-29 | |||||
| 1295 | 1295 | 696 | 1 | Eisenbahnweg | 25238.0 | 31.0 | 35.0 | 12.3 | {"type":"Point","coordinates":[7.65431283902805,47.5844647185948]} | Schützengasse | vis 32 | Riehen | 30.0 | 2023-05-22 | 2023-06-03 |
| 1287 | 1287 | 691 | 1 | Inzlingerstrasse | 7589.0 | 24.0 | 30.0 | 2.6 | {"type":"Point","coordinates":[7.65572559852205,47.5886351476692]} | Steingrubenweg | vis 9 | Riehen | 30.0 | 2023-05-08 | 2023-05-22 |
| 1257 | 1257 | 675 | 1 | Pfaffenlohweg | 166.0 | 25.0 | 32.0 | 4.8 | {"type":"Point","coordinates":[7.64041461766995,47.5755859044213]} | Sonnenbühlstrasse | 32 | Riehen | 30.0 | 2023-04-03 | 2023-04-09 |
| 1235 | 1235 | 663 | 1 | Lörracherstrasse | 11890.0 | 46.0 | 51.0 | 4.2 | {"type":"Point","coordinates":[7.64895434264852,47.5908420271841]} | Weilstrasse | Ohne (47.59083/7.648963) | Riehen | 50.0 | 2023-03-06 | 2023-03-13 |
| 1167 | 1167 | 627 | 1 | Schlossgasse | 2708.0 | 24.0 | 30.0 | 1.6 | {"type":"Point","coordinates":[7.65464036465545,47.5865596333728]} | Oberdorfstrasse | 15 | Riehen | 30.0 | 2022-12-12 | 2022-12-20 |
| 1165 | 1165 | 626 | 1 | Helvetierstrasse | 6008.0 | 20.0 | 26.0 | 0.7 | {"type":"Point","coordinates":[7.63231205096983,47.5695918788181]} | Gotenstrasse | 47.569593 7.632290 | Riehen | 30.0 | 2022-12-12 | 2022-12-27 |
| 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 |
| 1153 | 1153 | 620 | 1 | Höhenstrasse | 1465.0 | 27.0 | 33.0 | 5.1 | {"type":"Point","coordinates":[7.64951010753546,47.5700296638622]} | Rütiring | 61 | Riehen | 30.0 | 2022-11-28 | 2022-12-12 |
| 1119 | 1119 | 603 | 1 | Grenzacherweg | 1929.0 | 30.0 | 38.0 | 23.7 | {"type":"Point","coordinates":[7.65049899516512,47.5747495597686]} | Hackbergstrasse | visa 75 | Riehen | 30.0 | 2022-10-17 | 2022-10-28 |
| 1117 | 1117 | 602 | 1 | Kohlistieg | 4486.0 | 28.0 | 34.0 | 8.5 | {"type":"Point","coordinates":[7.63788139828961,47.5698972592771]} | Schäferstrasse | 59 | Riehen | 30.0 | 2022-10-17 | 2022-10-27 |
| 1069 | 1069 | 576 | 1 | Baselstrasse | 8929.0 | 21.0 | 31.0 | 5.3 | {"type":"Point","coordinates":[7.64866618733461,47.5851945369749]} | Erlensträsschen | vis 14 | Riehen | 30.0 | 2022-08-15 | 2022-08-29 |
| 1055 | 1055 | 569 | 1 | Rössligasse | 9873.0 | 23.0 | 30.0 | 2.9 | {"type":"Point","coordinates":[7.65278888983213,47.5856457017071]} | Wendelinsgasse | 21 | Riehen | 30.0 | 2022-07-18 | 2022-08-03 |
| 979 | 979 | 527 | 1 | Baselstrasse | 12598.0 | 36.0 | 43.0 | 56.4 | {"type":"Point","coordinates":[7.6700814254623,47.5851719067001]} | Inzlingerstrasse | 319c | Riehen | 30.0 | 2022-03-28 | 2022-04-08 |
| 965 | 965 | 520 | 1 | Mohrhaldenstrasse | 3846.0 | 25.0 | 31.0 | 2.6 | {"type":"Point","coordinates":[7.65298783148772,47.5822277439614]} | Immenbachstrasse | 22 | Riehen | 30.0 | 2022-03-21 | 2022-04-01 |
| 963 | 963 | 519 | 1 | Chrischonawegli | 1968.0 | 33.0 | 39.0 | 34.2 | {"type":"Point","coordinates":[7.66360887059642,47.5823156208668]} | Chrischonaweg | vis 111 | Riehen | 30.0 | 2022-03-14 | 2022-03-25 |
| 953 | 953 | 514 | 1 | Schmiedgasse | 2628.0 | 25.0 | 33.0 | 6.7 | {"type":"Point","coordinates":[7.65566856287071,47.5811615228627]} | Mohrhaldenstrasse | 44 | Riehen | 30.0 | 2022-03-08 | 2022-03-14 |
| 951 | 951 | 513 | 1 | Bettingerstrasse | 1974.0 | 33.0 | 39.0 | 34.0 | {"type":"Point","coordinates":[7.64862570921265,47.5782964667409]} | Mühlestiegstrasse | 36 | Riehen | 30.0 | 2022-02-28 | 2022-03-10 |
| 945 | 945 | 510 | 1 | Paradiesstrasse | 560.0 | 22.0 | 29.0 | 2.7 | {"type":"Point","coordinates":[7.64265815985205,47.5783790288355]} | Störklingasse | 47 | Riehen | 30.0 | 2022-02-21 | 2022-03-04 |
| 935 | 935 | 505 | 1 | Chrischonawegli | 1538.0 | 35.0 | 41.0 | 49.1 | {"type":"Point","coordinates":[7.66360887059642,47.5823156208668]} | Chrischonaweg | vis 111 | Riehen | 30.0 | 2022-02-14 | 2022-02-23 |
| 933 | 933 | 504 | 1 | Aeussere Baselstrasse | 905.0 | 22.0 | 27.0 | 24.5 | {"type":"Point","coordinates":[7.64169415571109,47.5765370099983]} | Pfaffenlohweg | 45 | Riehen | 20.0 | 2022-02-07 | 2022-02-18 |
| 909 | 909 | 491 | 1 | Inzlingerstrasse | 9438.0 | 21.0 | 26.0 | 17.0 | {"type":"Point","coordinates":[7.6519516698677,47.5857101946122]} | Rössligasse | vis 30 | Riehen | 20.0 | 2022-01-10 | 2022-01-19 |
| 907 | 907 | 490 | 1 | Baselstrasse | 38294.0 | 30.0 | 34.0 | 9.9 | {"type":"Point","coordinates":[7.65380084491169,47.5926408912926]} | Lörracherstrasse | 88 | Riehen | 30.0 | 2022-01-10 | 2022-01-22 |
| 885 | 885 | 479 | 1 | Rainallee | 2658.0 | 32.0 | 39.0 | 28.0 | {"type":"Point","coordinates":[7.63446572591704,47.5698131184715]} | Rüchligweg | vis 121 | Riehen | 30.0 | 2021-12-13 | 2021-12-20 |
| 883 | 883 | 478 | 1 | Eisenbahnweg | 1441.0 | 33.0 | 39.0 | 30.5 | {"type":"Point","coordinates":[7.65178151853587,47.5797297186621]} | Wenkenstrasse | vis 46 | Riehen | 30.0 | 2021-11-29 | 2021-12-08 |
| 867 | 867 | 470 | 1 | Bettingerstrasse | 59001.0 | 59.0 | 63.0 | 8.1 | {"type":"Point","coordinates":[7.62401546270057,47.5722405371547]} | Aeussere Baselstrasse | 383-393 | Riehen | 60.0 | 2021-11-22 | 2021-12-02 |
| 865 | 865 | 469 | 1 | Landesgrenze | 8690.0 | 33.0 | 38.0 | 28.5 | {"type":"Point","coordinates":[7.6666140484905,47.5856734030691]} | Inzlingerstrasse | 274 | Riehen | 30.0 | 2021-11-15 | 2021-11-22 |
| 863 | 863 | 468 | 1 | Banngrenze Riehen | 32106.0 | 45.0 | 52.0 | 5.9 | {"type":"Point","coordinates":[7.62904637745165,47.5705685852912]} | Bäumlihofstrasse | 388 | Riehen | 50.0 | 2021-11-15 | 2021-11-25 |
| 811 | 811 | 440 | 1 | Bettingerstrasse | 4605.0 | 31.0 | 37.0 | 22.0 | {"type":"Point","coordinates":[7.64458535337542,47.5680418799355]} | Grenzacherweg | 261 / Garagenausfahrt | Riehen | 30.0 | 2021-09-13 | 2021-09-27 |
| 805 | 805 | 437 | 1 | Morystrasse | 6218.0 | 22.0 | 29.0 | 1.7 | {"type":"Point","coordinates":[7.64108222964505,47.5728956318841]} | Wasserstelzenweg | Rainallee 16 Garagen (Nähe Schule) | Riehen | 30.0 | 2021-09-06 | 2021-09-20 |
| 801 | 801 | 435 | 1 | Bettingerstrasse | 38103.0 | 37.0 | 41.0 | 1.8 | {"type":"Point","coordinates":[7.6451907723037,47.5699564669264]} | Grenzacherweg | 221 | Riehen | 40.0 | 2021-08-30 | 2021-09-13 |
| 791 | 791 | 430 | 1 | Aeussere Baselstrasse | 5431.0 | 29.0 | 35.0 | 12.4 | {"type":"Point","coordinates":[7.64249346890626,47.5770212717808]} | Kilchgrundstrasse | 57 | Riehen | 30.0 | 2021-08-23 | 2021-09-01 |
| 789 | 789 | 429 | 1 | Garbenstrasse | 11279.0 | 25.0 | 34.0 | 9.6 | {"type":"Point","coordinates":[7.64498081010608,47.5775115415675]} | Mühlestiegstrasse | vis 8 | Riehen | 30.0 | 2021-08-23 | 2021-09-06 |
| 777 | 777 | 422 | 1 | Mohrhaldenstrasse | 1124.0 | 30.0 | 36.0 | 17.6 | {"type":"Point","coordinates":[7.65329246354253,47.5786566941098]} | Wenkenhaldenweg | 10 | Riehen | 30.0 | 2021-08-02 | 2021-08-16 |
| 771 | 771 | 419 | 1 | Grenzacherweg | 2849.0 | 21.0 | 27.0 | 0.6 | {"type":"Point","coordinates":[7.64397475539576,47.5751210006197]} | Lachenweg | 12 | Riehen | 30.0 | 2021-07-26 | 2021-08-09 |
| 763 | 763 | 415 | 1 | Meierweg | 654.0 | 21.0 | 25.0 | 13.1 | {"type":"Point","coordinates":[7.64378024455998,47.5798340321573]} | Paradiesstrasse | 30 | Riehen | 20.0 | 2021-07-19 | 2021-07-30 |
| 757 | 757 | 412 | 1 | Morystrasse | 1769.0 | 26.0 | 30.0 | 2.0 | {"type":"Point","coordinates":[7.64527172235874,47.5736977021866]} | Vierjuchartenweg | vis 24 | Riehen | 30.0 | 2021-07-12 | 2021-07-21 |
| 751 | 751 | 409 | 1 | Rudolf Wackernagel-Strasse | 768.0 | 19.0 | 33.0 | 10.0 | {"type":"Point","coordinates":[7.6511880019116,47.5708900069941]} | Höhenstrasse | 24 | Riehen | 30.0 | 2021-07-05 | 2021-07-19 |
| 723 | 723 | 394 | 1 | Rauracherstrasse | 5553.0 | 26.0 | 30.0 | 1.9 | {"type":"Point","coordinates":[7.63337047024673,47.5719374687224]} | In den Neumatten | 51 | Riehen | 30.0 | 2021-05-31 | 2021-06-14 |
| 717 | 717 | 391 | 1 | Bettingerstrasse | 1246.0 | 26.0 | 31.0 | 2.5 | {"type":"Point","coordinates":[7.65885615858643,47.5709027282488]} | Talmattstrasse | vis 42 | Riehen | 30.0 | 2021-05-25 | 2021-06-07 |
| 703 | 703 | 383 | 1 | Aeussere Baselstrasse | 5342.0 | 33.0 | 38.0 | 29.6 | {"type":"Point","coordinates":[7.64249343450803,47.5770122781595]} | Kilchgrundstrasse | 57 | Riehen | 30.0 | 2021-05-10 | 2021-05-24 |
| 691 | 691 | 377 | 1 | Rössligasse | 1663.0 | 12.0 | 18.0 | 1.8 | {"type":"Point","coordinates":[7.65188786751782,47.5863758419659]} | Gartengasse | 21 | Riehen | 20.0 | 2021-04-26 | 2021-05-05 |
| 681 | 681 | 372 | 1 | Bettingerstrasse | 49879.0 | 36.0 | 43.0 | 25.6 | {"type":"Point","coordinates":[7.65051839796366,47.5863153872014]} | Baselstrasse | 71 | Riehen | 40.0 | 2021-04-12 | 2021-04-26 |
| 669 | 669 | 365 | 1 | Schmiedgasse | 15255.0 | 25.0 | 32.0 | 5.9 | {"type":"Point","coordinates":[7.65020887312151,47.5820169805278]} | Bahnhofstrasse | 66 | Riehen | 30.0 | 2021-03-29 | 2021-04-12 |
| 659 | 659 | 358 | 1 | Aeussere Baselstrasse | 2639.0 | 35.0 | 41.0 | 48.2 | {"type":"Point","coordinates":[7.64250672555556,47.5770122548825]} | Kilchgrundstrasse | 57 | Riehen | 30.0 | 2021-03-15 | 2021-03-22 |
| 619 | 619 | 335 | 1 | Aeussere Baselstrasse | 3524.0 | 34.0 | 40.0 | 38.8 | {"type":"Point","coordinates":[7.64246681801924,47.5770033310873]} | Kilchgrundstrasse | 57 | Riehen | 30.0 | 2021-01-18 | 2021-01-28 |
| 617 | 617 | 334 | 1 | Garbenstrasse | 9417.0 | 31.0 | 41.0 | 34.6 | {"type":"Point","coordinates":[7.64499417092259,47.5775295052432]} | Mühlestiegstrasse | vis 8 | Riehen | 30.0 | 2021-01-18 | 2021-02-01 |
| 593 | 593 | 320 | 1 | Mühlestiegstrasse | 509.0 | 20.0 | 27.0 | 0.0 | {"type":"Point","coordinates":[7.64430066900451,47.5734745797505]} | Kornfeldstrasse | vis 63 | Riehen | 30.0 | 2021-01-04 | 2021-01-12 |
| 585 | 585 | 316 | 1 | Aeussere Baselstrasse | 3947.0 | 18.0 | 23.0 | 5.2 | {"type":"Point","coordinates":[7.63432611300311,47.5716030995226]} | Niederholzstrasse | 102 | Riehen | 20.0 | 2020-11-23 | 2021-01-03 |
| 553 | 553 | 300 | 1 | Bettingerstrasse | 1366.0 | 31.0 | 38.0 | 22.9 | {"type":"Point","coordinates":[7.65049906667291,47.5747675470213]} | Hackbergstrasse | vis 75 | Riehen | 30.0 | 2020-11-02 | 2020-11-13 |
| 541 | 541 | 294 | 1 | Schlossgasse | 1991.0 | 29.0 | 33.0 | 6.2 | {"type":"Point","coordinates":[7.65765453525737,47.5857175905378]} | Oberdorfstrasse | 68 | Riehen | 30.0 | 2020-10-26 | 2020-11-03 |
| 535 | 535 | 291 | 1 | Helvetierstrasse | 5346.0 | 20.0 | 27.0 | 0.8 | {"type":"Point","coordinates":[7.6323120836374,47.5696008724667]} | Gotenstrasse | vis Im Hirshalm | Riehen | 30.0 | 2020-10-05 | 2020-10-16 |
| 527 | 527 | 287 | 1 | Hörnliallee | 13288.0 | 37.0 | 44.0 | 0.6 | {"type":"Point","coordinates":[7.63051475310992,47.5723829012533]} | Rauracherstrasse | vis 14 | Riehen | 50.0 | 2020-10-19 | 2020-11-02 |
| 487 | 487 | 265 | 1 | Inzlingerstrasse | 10272.0 | 24.0 | 29.0 | 1.7 | {"type":"Point","coordinates":[7.65640469310829,47.5889036885386]} | Steingrubenweg | 20 | Riehen | 30.0 | 2020-08-24 | 2020-09-07 |
| 473 | 473 | 258 | 1 | Landesgrenze | 28046.0 | 46.0 | 52.0 | 6.6 | {"type":"Point","coordinates":[7.64639355178906,47.5921417085317]} | Weilstrasse | 51 | Riehen | 50.0 | 2020-08-10 | 2020-08-24 |
| 467 | 467 | 255 | 1 | Landesgrenze | 15636.0 | 34.0 | 41.0 | 40.4 | {"type":"Point","coordinates":[7.6640249934535,47.5864159264449]} | Inzlingerstrasse | 238 | Riehen | 30.0 | 2020-08-03 | 2020-08-17 |
| 465 | 465 | 254 | 1 | Inzlingerstrasse | 4918.0 | 34.0 | 40.0 | 39.3 | {"type":"Point","coordinates":[7.65827559007493,47.5880367828809]} | Bäumliweg | Vis 30 | Riehen | 30.0 | 2020-07-27 | 2020-08-10 |
| 463 | 463 | 253 | 1 | Bettingerstrasse | 30562.0 | 30.0 | 34.0 | 8.2 | {"type":"Point","coordinates":[7.65429929128466,47.5844017880728]} | Schützengasse | 29 | Riehen | 30.0 | 2020-07-27 | 2020-08-10 |
| 441 | 441 | 239 | 1 | Wasserstelzenweg | 2311.0 | 33.0 | 38.0 | 29.9 | {"type":"Point","coordinates":[7.63788143190141,47.5699062529231]} | Schäferstrasse | 59 | Riehen | 30.0 | 2020-06-29 | 2020-07-13 |
| 439 | 439 | 238 | 1 | Landesgrenze | 18298.0 | 32.0 | 38.0 | 25.7 | {"type":"Point","coordinates":[7.64445340865286,47.5923789887357]} | Weilstrasse | Gegenüber Naturbad | Riehen | 30.0 | 2020-06-29 | 2020-07-13 |
| 433 | 433 | 235 | 1 | Bettingerstrasse | 8044.0 | 46.0 | 51.0 | 2.8 | {"type":"Point","coordinates":[7.64670620641179,47.5700706856169]} | Rudolf Wackernagel-Strasse | 38 | Riehen | 50.0 | 2020-06-22 | 2020-06-29 |
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");