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 = 2 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
- 2 · 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1892 | 1892 | 1028 | 2 | Grabenstrasse | 3749.0 | 24.0 | 32.0 | 4.03 | {"type":"Point","coordinates":[7.64924405986338,47.578371795767]} | Mühlestiegstrasse | 40 | Riehen | 30.0 | 2025-05-26 | 2025-06-09 |
| 1888 | 1888 | 1026 | 2 | Chrischonaweg | 1897.0 | 31.0 | 36.0 | 15.45 | {"type":"Point","coordinates":[7.58862790252353,47.5768035938454]} | Schlossgasse | 14 | Riehen | 30.0 | 2025-05-05 | 2025-05-16 |
| 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 |
| 1872 | 1872 | 1015 | 2 | Morhaldenstrasse | 1784.0 | 29.0 | 34.0 | 9.42 | {"type":"Point","coordinates":[7.66399535505562,47.5822384268202]} | Chrischonaweg | vis 113 | Riehen | 30.0 | 2025-04-22 | 2025-05-05 |
| 1868 | 1868 | 1013 | 2 | Mühlestiegstrasse | 4901.0 | 32.0 | 37.0 | 21.16 | {"type":"Point","coordinates":[7.64022106576007,47.5767707078974]} | Kilchgrundstrasse | 29 | Riehen | 30.0 | 2025-04-22 | 2025-05-05 |
| 1864 | 1864 | 1011 | 2 | Pfaffenlohweg | 2526.0 | 29.0 | 35.0 | 11.84 | {"type":"Point","coordinates":[7.64078806450948,47.576280468321]} | Essigstrasse | 31 | Riehen | 30.0 | 2025-04-14 | 2025-04-25 |
| 1854 | 1854 | 1006 | 2 | Bettingerstrasse | 8762.0 | 27.0 | 33.0 | 7.76 | {"type":"Point","coordinates":[7.64560695158463,47.577885466371]} | Mühlestiegstrasse | vis 18 | Riehen | 30.0 | 2025-03-31 | 2025-04-14 |
| 1820 | 1820 | 988 | 2 | Baselstrasse | 19472.0 | 36.0 | 41.0 | 50.27 | {"type":"Point","coordinates":[7.66621760375428,47.5859134104368]} | Inzlingerstrasse | 270 | Riehen | 30.0 | 2025-02-17 | 2025-03-02 |
| 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 |
| 1816 | 1816 | 986 | 2 | Landesgrenze | 41566.0 | 33.0 | 37.0 | 25.21 | {"type":"Point","coordinates":[7.65374746533202,47.5925915249583]} | Lörracherstrasse | 88 | Riehen | 30.0 | 2025-02-17 | 2025-02-27 |
| 1808 | 1808 | 982 | 2 | Steingrubenweg | 2218.0 | 29.0 | 33.0 | 7.75 | {"type":"Point","coordinates":[7.65912155432842,47.5894354943859]} | Bischoffweg | 12 | Riehen | 30.0 | 2025-02-03 | 2025-02-16 |
| 1806 | 1806 | 981 | 2 | Bettingerstrasse | 34491.0 | 38.0 | 44.0 | 12.12 | {"type":"Point","coordinates":[7.65070731408119,47.5816770121562]} | Eisenbahnweg | 57 | Riehen | 40.0 | 2025-02-03 | 2025-02-15 |
| 1804 | 1804 | 980 | 2 | Landesgrenze | 25417.0 | 31.0 | 37.0 | 20.54 | {"type":"Point","coordinates":[7.64461816455535,47.5923526158541]} | Weilstrasse | 69 | Riehen | 30.0 | 2025-02-03 | 2025-02-15 |
| 1726 | 1726 | 940 | 2 | Bettingerstrasse | 7982.0 | 20.0 | 25.0 | 0.51 | {"type":"Point","coordinates":[7.64647309420148,47.5801548262777]} | Burgstrasse | 44 | Riehen | 30.0 | 2024-11-04 | 2024-11-18 |
| 1714 | 1714 | 931 | 2 | Baselstrasse | 17042.0 | 38.0 | 43.0 | 7.43 | {"type":"Point","coordinates":[7.65126008846067,47.5769669145819]} | Bettingerstrasse | vis 120 | Riehen | 40.0 | 2024-10-21 | 2024-11-04 |
| 1700 | 1700 | 924 | 2 | {"type":"Point","coordinates":[7.63512610107308,47.5744725386694]} | Niederholzstrasse | 35 | Riehen | 20.0 | 2024-09-30 | 2024-10-21 | |||||
| 1656 | 1656 | 900 | 2 | Steingrubenweg | 2096.0 | 32.0 | 39.0 | 30.49 | {"type":"Point","coordinates":[7.65990024957836,47.5903117963642]} | Bischoffweg | vis 36 | Riehen | 30.0 | 2024-08-19 | 2024-09-02 |
| 1544 | 1544 | 841 | 2 | Lörracherstrasse | 78994.0 | 32.0 | 38.0 | 0.87 | {"type":"Point","coordinates":[7.64799516273106,47.5828978655815]} | Baselstrasse | 2 | Riehen | 40.0 | 2024-04-08 | 2024-04-22 |
| 1538 | 1538 | 838 | 2 | Inzlingerstrasse | 3648.0 | 34.0 | 79.0 | 44.79 | {"type":"Point","coordinates":[7.65521502309861,47.5902495586167]} | Haselrain | Seite Friedhofweg | Riehen | 30.0 | 2024-04-02 | 2024-04-10 |
| 1536 | 1536 | 835 | 2 | Banngrenze | 24351.0 | 33.0 | 40.0 | 2.84 | {"type":"Point","coordinates":[7.64893891902502,47.5812089524223]} | Bettingerstrasse | vis 32 | Riehen | 40.0 | 2024-03-25 | 2024-04-07 |
| 1532 | 1532 | 833 | 2 | {"type":"Point","coordinates":[7.64893891902502,47.5812089524223]} | Bettingerstrasse | vis 32 | Riehen | 40.0 | 2024-03-25 | 2024-04-07 | |||||
| 1518 | 1518 | 823 | 2 | {"type":"Point","coordinates":[7.63144250425936,47.5702084913509]} | Im Hirshalm | 52 | Riehen | 30.0 | 2024-03-04 | 2024-03-16 | |||||
| 1506 | 1506 | 814 | 2 | Bettingerstrasse | 21872.0 | 42.0 | 46.0 | 18.29 | {"type":"Point","coordinates":[7.64574207890312,47.571956585948]} | Grenzacherweg | 190 | Riehen | 40.0 | 2024-02-19 | 2024-03-01 |
| 1478 | 1478 | 799 | 2 | BaselRiehenstrasse | 36973.0 | 51.0 | 55.0 | 14.77 | {"type":"Point","coordinates":[7.63352656303222,47.5746470066854]} | Aeussere Baselstrasse | 283 | Riehen | 50.0 | 2024-01-15 | 2024-01-21 |
| 1464 | 1464 | 789 | 2 | Bahnlinie | 2621.0 | 22.0 | 26.0 | 0.95 | {"type":"Point","coordinates":[7.63893818159514,47.5752772726979]} | Im Niederholzboden | 44 | Riehen | 30.0 | 2023-12-18 | 2024-01-02 |
| 1458 | 1458 | 786 | 2 | {"type":"Point","coordinates":[7.64951723774444,47.5822439766782]} | Sieglinweg | 14 | Riehen | 20.0 | 2023-12-11 | 2023-12-19 | |||||
| 1448 | 1448 | 781 | 2 | Bettingerstrasse | 7502.0 | 24.0 | 31.0 | 4.29 | {"type":"Point","coordinates":[7.65002487568807,47.5818752148825]} | Bahnhofstrasse | vis 71 | Riehen | 30.0 | 2023-11-20 | 2023-12-11 |
| 1438 | 1438 | 775 | 2 | Grenzacherweg | 47678.0 | 43.0 | 47.0 | 0.68 | {"type":"Point","coordinates":[7.64238808781208,47.5692724893269]} | Kohlistieg | Höhe Morystrasse | Riehen | 50.0 | 2023-11-13 | 2023-11-27 |
| 1432 | 1432 | 769 | 2 | Bluttrainweg | 768.0 | 23.0 | 29.0 | 1.3 | {"type":"Point","coordinates":[7.63953597496268,47.5713217157971]} | Supperstrasse | 43 | Riehen | 30.0 | 2023-11-06 | 2023-11-20 |
| 1426 | 1426 | 763 | 2 | Kohlistieg | 3744.0 | 25.0 | 30.0 | 1.42 | {"type":"Point","coordinates":[7.64298874780951,47.5710027243145]} | Morystrasse | 59 | Riehen | 30.0 | 2023-10-23 | 2023-11-06 |
| 1424 | 1424 | 762 | 2 | {"type":"Point","coordinates":[7.66919245638679,47.587401400959]} | Hohlweg | Ohne | Riehen | 30.0 | 2023-10-23 | 2023-11-01 | |||||
| 1416 | 1416 | 758 | 2 | Grenzacherweg | 18560.0 | 41.0 | 47.0 | 0.85 | {"type":"Point","coordinates":[7.6467021669591,47.5700572022804]} | Rudolf Wackernagel-Strasse | 38 | Riehen | 50.0 | 2023-10-09 | 2023-10-23 |
| 1414 | 1414 | 757 | 2 | Bischoffweg | 593.0 | 37.0 | 43.0 | 59.02 | {"type":"Point","coordinates":[7.66262834912163,47.5896968089387]} | Auf der Bischoffhöhe | 30 | Riehen | 30.0 | 2023-10-09 | 2023-10-20 |
| 1412 | 1412 | 756 | 2 | Mühlestiegstrasse | 885.0 | 22.0 | 33.0 | 9.38 | {"type":"Point","coordinates":[7.64449515959199,47.5742800707717]} | Kornfeldstrasse | 54 | Riehen | 30.0 | 2023-10-09 | 2023-10-15 |
| 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 |
| 1326 | 1326 | 711 | 2 | Aeussere Baselstrasse | 523.0 | 29.0 | 32.0 | 2.5 | {"type":"Point","coordinates":[7.63478958592729,47.5675371654362]} | Rauracherstrasse | vis 144 | Riehen | 30.0 | 2023-06-26 | 2023-07-07 |
| 1314 | 1314 | 705 | 2 | Kohlistieg | 1143.0 | 24.0 | 30.0 | 2.1 | {"type":"Point","coordinates":[7.6409792651215,47.5702786445278]} | Rainallee | vis 134 | Riehen | 30.0 | 2023-06-12 | 2023-06-20 |
| 1312 | 1312 | 704 | 2 | Lörracherstrasse | 30867.0 | 29.0 | 39.0 | 2.6 | {"type":"Point","coordinates":[7.64918092213575,47.5842582666605]} | Baselstrasse | visa 34 | Riehen | 40.0 | 2023-06-05 | 2023-06-14 |
| 1304 | 1304 | 700 | 2 | Grenzacherstrasse | 4959.0 | 21.0 | 26.0 | 0.4 | {"type":"Point","coordinates":[7.63615012369898,47.5653224111033]} | Hörnliallee | visa 69 | Riehen | 30.0 | 2023-05-30 | 2023-06-12 |
| 1302 | 1302 | 699 | 2 | Grenzacherstrasse | 6953.0 | 39.0 | 46.0 | 69.9 | {"type":"Point","coordinates":[7.63607182695918,47.5657092737821]} | Hörnliallee | 75 | Riehen | 30.0 | 2023-04-17 | 2023-04-29 |
| 1296 | 1296 | 696 | 2 | Inzlingerstrasse | 20619.0 | 31.0 | 36.0 | 15.5 | {"type":"Point","coordinates":[7.65431283902805,47.5844647185948]} | Schützengasse | vis 32 | Riehen | 30.0 | 2023-05-22 | 2023-06-03 |
| 1288 | 1288 | 691 | 2 | Hohlweg | 4991.0 | 26.0 | 31.0 | 3.5 | {"type":"Point","coordinates":[7.65572559852205,47.5886351476692]} | Steingrubenweg | vis 9 | Riehen | 30.0 | 2023-05-08 | 2023-05-22 |
| 1258 | 1258 | 675 | 2 | keine | {"type":"Point","coordinates":[7.64041461766995,47.5755859044213]} | Sonnenbühlstrasse | 32 | Riehen | 30.0 | 2023-04-03 | 2023-04-09 | ||||
| 1236 | 1236 | 663 | 2 | Landesgrenze | 11507.0 | 47.0 | 53.0 | 6.8 | {"type":"Point","coordinates":[7.64895434264852,47.5908420271841]} | Weilstrasse | Ohne (47.59083/7.648963) | Riehen | 50.0 | 2023-03-06 | 2023-03-13 |
| 1168 | 1168 | 627 | 2 | Rössligasse | 1179.0 | 24.0 | 31.0 | 2.5 | {"type":"Point","coordinates":[7.65464036465545,47.5865596333728]} | Oberdorfstrasse | 15 | Riehen | 30.0 | 2022-12-12 | 2022-12-20 |
| 1166 | 1166 | 626 | 2 | Rauracherstrasse | 3486.0 | 18.0 | 25.0 | 0.6 | {"type":"Point","coordinates":[7.63231205096983,47.5695918788181]} | Gotenstrasse | 47.569593 7.632290 | Riehen | 30.0 | 2022-12-12 | 2022-12-27 |
| 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 |
| 1154 | 1154 | 620 | 2 | Rudolf Wackernagel-Strasse | 1647.0 | 28.0 | 33.0 | 4.9 | {"type":"Point","coordinates":[7.64951010753546,47.5700296638622]} | Rütiring | 61 | Riehen | 30.0 | 2022-11-28 | 2022-12-12 |
| 1120 | 1120 | 603 | 2 | Bettingerstrasse | 1589.0 | 33.0 | 40.0 | 35.5 | {"type":"Point","coordinates":[7.65049899516512,47.5747495597686]} | Hackbergstrasse | visa 75 | Riehen | 30.0 | 2022-10-17 | 2022-10-28 |
| 1118 | 1118 | 602 | 2 | Wasserstelzenweg | 4588.0 | 28.0 | 33.0 | 6.5 | {"type":"Point","coordinates":[7.63788139828961,47.5698972592771]} | Schäferstrasse | 59 | Riehen | 30.0 | 2022-10-17 | 2022-10-27 |
| 1070 | 1070 | 576 | 2 | Erlenparkweg | 8823.0 | 25.0 | 30.0 | 1.4 | {"type":"Point","coordinates":[7.64866618733461,47.5851945369749]} | Erlensträsschen | vis 14 | Riehen | 30.0 | 2022-08-15 | 2022-08-29 |
| 1056 | 1056 | 569 | 2 | Schmiedgasse | 15551.0 | 30.0 | 35.0 | 14.9 | {"type":"Point","coordinates":[7.65278888983213,47.5856457017071]} | Wendelinsgasse | 21 | Riehen | 30.0 | 2022-07-18 | 2022-08-03 |
| 980 | 980 | 527 | 2 | Landesgrenze | 11745.0 | 36.0 | 43.0 | 56.5 | {"type":"Point","coordinates":[7.6700814254623,47.5851719067001]} | Inzlingerstrasse | 319c | Riehen | 30.0 | 2022-03-28 | 2022-04-08 |
| 966 | 966 | 520 | 2 | Eisenbahnweg | 4455.0 | 27.0 | 32.0 | 5.9 | {"type":"Point","coordinates":[7.65298783148772,47.5822277439614]} | Immenbachstrasse | 22 | Riehen | 30.0 | 2022-03-21 | 2022-04-01 |
| 964 | 964 | 519 | 2 | Mohrhaldenstrasse | 2334.0 | 30.0 | 35.0 | 12.6 | {"type":"Point","coordinates":[7.66360887059642,47.5823156208668]} | Chrischonaweg | vis 111 | Riehen | 30.0 | 2022-03-14 | 2022-03-25 |
| 954 | 954 | 514 | 2 | Brohegasse | 3583.0 | 28.0 | 33.0 | 6.6 | {"type":"Point","coordinates":[7.65566856287071,47.5811615228627]} | Mohrhaldenstrasse | 44 | Riehen | 30.0 | 2022-03-08 | 2022-03-14 |
| 952 | 952 | 513 | 2 | Garbenstrasse | 1482.0 | 33.0 | 39.0 | 31.8 | {"type":"Point","coordinates":[7.64862570921265,47.5782964667409]} | Mühlestiegstrasse | 36 | Riehen | 30.0 | 2022-02-28 | 2022-03-10 |
| 946 | 946 | 510 | 2 | Pfaffenlohweg | 829.0 | 21.0 | 28.0 | 2.3 | {"type":"Point","coordinates":[7.64265815985205,47.5783790288355]} | Störklingasse | 47 | Riehen | 30.0 | 2022-02-21 | 2022-03-04 |
| 936 | 936 | 505 | 2 | Mohrhaldenstrasse | 1847.0 | 32.0 | 38.0 | 25.0 | {"type":"Point","coordinates":[7.66360887059642,47.5823156208668]} | Chrischonaweg | vis 111 | Riehen | 30.0 | 2022-02-14 | 2022-02-23 |
| 934 | 934 | 504 | 2 | Meierweg | 2312.0 | 17.0 | 24.0 | 11.4 | {"type":"Point","coordinates":[7.64169415571109,47.5765370099983]} | Pfaffenlohweg | 45 | Riehen | 20.0 | 2022-02-07 | 2022-02-18 |
| 910 | 910 | 491 | 2 | keine | {"type":"Point","coordinates":[7.6519516698677,47.5857101946122]} | Rössligasse | vis 30 | Riehen | 20.0 | 2022-01-10 | 2022-01-19 | ||||
| 908 | 908 | 490 | 2 | Landesgrenze | 44433.0 | 32.0 | 36.0 | 15.9 | {"type":"Point","coordinates":[7.65380084491169,47.5926408912926]} | Lörracherstrasse | 88 | Riehen | 30.0 | 2022-01-10 | 2022-01-22 |
| 886 | 886 | 479 | 2 | Rauracherstrasse | 4792.0 | 28.0 | 38.0 | 21.0 | {"type":"Point","coordinates":[7.63446572591704,47.5698131184715]} | Rüchligweg | vis 121 | Riehen | 30.0 | 2021-12-13 | 2021-12-20 |
| 884 | 884 | 478 | 2 | Kehrplatz | 1518.0 | 32.0 | 38.0 | 29.5 | {"type":"Point","coordinates":[7.65178151853587,47.5797297186621]} | Wenkenstrasse | vis 46 | Riehen | 30.0 | 2021-11-29 | 2021-12-08 |
| 868 | 868 | 470 | 2 | Riehenstrasse | 52253.0 | 62.0 | 67.0 | 21.9 | {"type":"Point","coordinates":[7.62401546270057,47.5722405371547]} | Aeussere Baselstrasse | 383-393 | Riehen | 60.0 | 2021-11-22 | 2021-12-02 |
| 866 | 866 | 469 | 2 | Baselstrasse | 9230.0 | 35.0 | 40.0 | 41.6 | {"type":"Point","coordinates":[7.6666140484905,47.5856734030691]} | Inzlingerstrasse | 274 | Riehen | 30.0 | 2021-11-15 | 2021-11-22 |
| 864 | 864 | 468 | 2 | Aeussere Baselstrasse | 28300.0 | 42.0 | 48.0 | 1.5 | {"type":"Point","coordinates":[7.62904637745165,47.5705685852912]} | Bäumlihofstrasse | 388 | Riehen | 50.0 | 2021-11-15 | 2021-11-25 |
| 812 | 812 | 440 | 2 | Im finstern Boden | 7712.0 | 26.0 | 34.0 | 11.3 | {"type":"Point","coordinates":[7.64458535337542,47.5680418799355]} | Grenzacherweg | 261 / Garagenausfahrt | Riehen | 30.0 | 2021-09-13 | 2021-09-27 |
| 806 | 806 | 437 | 2 | Rüchligweg | 4894.0 | 27.0 | 33.0 | 8.8 | {"type":"Point","coordinates":[7.64108222964505,47.5728956318841]} | Wasserstelzenweg | Rainallee 16 Garagen (Nähe Schule) | Riehen | 30.0 | 2021-09-06 | 2021-09-20 |
| 802 | 802 | 435 | 2 | Im finstern Boden | 39132.0 | 37.0 | 42.0 | 3.3 | {"type":"Point","coordinates":[7.6451907723037,47.5699564669264]} | Grenzacherweg | 221 | Riehen | 40.0 | 2021-08-30 | 2021-09-13 |
| 792 | 792 | 430 | 2 | Mühlestiegstrasse | 6704.0 | 29.0 | 35.0 | 12.9 | {"type":"Point","coordinates":[7.64249346890626,47.5770212717808]} | Kilchgrundstrasse | 57 | Riehen | 30.0 | 2021-08-23 | 2021-09-01 |
| 790 | 790 | 429 | 2 | Bettingerstrasse | 7777.0 | 29.0 | 36.0 | 17.3 | {"type":"Point","coordinates":[7.64498081010608,47.5775115415675]} | Mühlestiegstrasse | vis 8 | Riehen | 30.0 | 2021-08-23 | 2021-09-06 |
| 778 | 778 | 422 | 2 | Wenkenstrasse | 1108.0 | 31.0 | 37.0 | 19.0 | {"type":"Point","coordinates":[7.65329246354253,47.5786566941098]} | Wenkenhaldenweg | 10 | Riehen | 30.0 | 2021-08-02 | 2021-08-16 |
| 772 | 772 | 419 | 2 | Morystrasse | 7236.0 | 17.0 | 22.0 | 0.1 | {"type":"Point","coordinates":[7.64397475539576,47.5751210006197]} | Lachenweg | 12 | Riehen | 30.0 | 2021-07-26 | 2021-08-09 |
| 764 | 764 | 415 | 2 | Aeussere Baselstrasse | 708.0 | 20.0 | 25.0 | 13.1 | {"type":"Point","coordinates":[7.64378024455998,47.5798340321573]} | Paradiesstrasse | 30 | Riehen | 20.0 | 2021-07-19 | 2021-07-30 |
| 758 | 758 | 412 | 2 | Grenzacherweg | 3270.0 | 25.0 | 30.0 | 2.0 | {"type":"Point","coordinates":[7.64527172235874,47.5736977021866]} | Vierjuchartenweg | vis 24 | Riehen | 30.0 | 2021-07-12 | 2021-07-21 |
| 752 | 752 | 409 | 2 | Rütiring | 1282.0 | 20.0 | 33.0 | 9.4 | {"type":"Point","coordinates":[7.6511880019116,47.5708900069941]} | Höhenstrasse | 24 | Riehen | 30.0 | 2021-07-05 | 2021-07-19 |
| 724 | 724 | 394 | 2 | {"type":"Point","coordinates":[7.63337047024673,47.5719374687224]} | In den Neumatten | 51 | Riehen | 30.0 | 2021-05-31 | 2021-06-14 | |||||
| 718 | 718 | 391 | 2 | Banngrenze (Bettingen) | 1331.0 | 25.0 | 29.0 | 2.0 | {"type":"Point","coordinates":[7.65885615858643,47.5709027282488]} | Talmattstrasse | vis 42 | Riehen | 30.0 | 2021-05-25 | 2021-06-07 |
| 704 | 704 | 383 | 2 | Mühlestiegstrasse | 7010.0 | 34.0 | 39.0 | 33.6 | {"type":"Point","coordinates":[7.64249343450803,47.5770122781595]} | Kilchgrundstrasse | 57 | Riehen | 30.0 | 2021-05-10 | 2021-05-24 |
| 692 | 692 | 377 | 2 | Baselstrasse | 1689.0 | 15.0 | 22.0 | 4.9 | {"type":"Point","coordinates":[7.65188786751782,47.5863758419659]} | Gartengasse | 21 | Riehen | 20.0 | 2021-04-26 | 2021-05-05 |
| 682 | 682 | 372 | 2 | Lörracherstrasse | 56407.0 | 37.0 | 44.0 | 31.4 | {"type":"Point","coordinates":[7.65051839796366,47.5863153872014]} | Baselstrasse | 71 | Riehen | 40.0 | 2021-04-12 | 2021-04-26 |
| 670 | 670 | 365 | 2 | Bettingerstrasse | 13864.0 | 27.0 | 34.0 | 11.8 | {"type":"Point","coordinates":[7.65020887312151,47.5820169805278]} | Bahnhofstrasse | 66 | Riehen | 30.0 | 2021-03-29 | 2021-04-12 |
| 660 | 660 | 358 | 2 | Mühlestiegstrasse | 3223.0 | 36.0 | 42.0 | 56.6 | {"type":"Point","coordinates":[7.64250672555556,47.5770122548825]} | Kilchgrundstrasse | 57 | Riehen | 30.0 | 2021-03-15 | 2021-03-22 |
| 620 | 620 | 335 | 2 | Mühlestiegstrasse | 4351.0 | 35.0 | 41.0 | 46.7 | {"type":"Point","coordinates":[7.64246681801924,47.5770033310873]} | Kilchgrundstrasse | 57 | Riehen | 30.0 | 2021-01-18 | 2021-01-28 |
| 618 | 618 | 334 | 2 | Bettingerstrasse | 4930.0 | 37.0 | 43.0 | 62.4 | {"type":"Point","coordinates":[7.64499417092259,47.5775295052432]} | Mühlestiegstrasse | vis 8 | Riehen | 30.0 | 2021-01-18 | 2021-02-01 |
| 594 | 594 | 320 | 2 | Tiefweg | 507.0 | 19.0 | 27.0 | 0.4 | {"type":"Point","coordinates":[7.64430066900451,47.5734745797505]} | Kornfeldstrasse | vis 63 | Riehen | 30.0 | 2021-01-04 | 2021-01-12 |
| 586 | 586 | 316 | 2 | keine | {"type":"Point","coordinates":[7.63432611300311,47.5716030995226]} | Niederholzstrasse | 102 | Riehen | 20.0 | 2020-11-23 | 2021-01-03 | ||||
| 554 | 554 | 300 | 2 | Grenzacherweg | 2474.0 | 31.0 | 38.0 | 23.7 | {"type":"Point","coordinates":[7.65049906667291,47.5747675470213]} | Hackbergstrasse | vis 75 | Riehen | 30.0 | 2020-11-02 | 2020-11-13 |
| 542 | 542 | 294 | 2 | Rössligasse | 1637.0 | 28.0 | 34.0 | 8.9 | {"type":"Point","coordinates":[7.65765453525737,47.5857175905378]} | Oberdorfstrasse | 68 | Riehen | 30.0 | 2020-10-26 | 2020-11-03 |
| 536 | 536 | 291 | 2 | Rauracherstrasse | 3575.0 | 18.0 | 25.0 | 1.3 | {"type":"Point","coordinates":[7.6323120836374,47.5696008724667]} | Gotenstrasse | vis Im Hirshalm | Riehen | 30.0 | 2020-10-05 | 2020-10-16 |
| 528 | 528 | 287 | 2 | Aeussere Baselstrasse | 12207.0 | 35.0 | 42.0 | 0.3 | {"type":"Point","coordinates":[7.63051475310992,47.5723829012533]} | Rauracherstrasse | vis 14 | Riehen | 50.0 | 2020-10-19 | 2020-11-02 |
| 488 | 488 | 265 | 2 | Hohlweg | 11939.0 | 23.0 | 28.0 | 0.7 | {"type":"Point","coordinates":[7.65640469310829,47.5889036885386]} | Steingrubenweg | 20 | Riehen | 30.0 | 2020-08-24 | 2020-09-07 |
| 474 | 474 | 258 | 2 | Lörracherstrasse | 26279.0 | 45.0 | 52.0 | 5.9 | {"type":"Point","coordinates":[7.64639355178906,47.5921417085317]} | Weilstrasse | 51 | Riehen | 50.0 | 2020-08-10 | 2020-08-24 |
| 468 | 468 | 255 | 2 | Baselstrasse | 17270.0 | 33.0 | 39.0 | 33.1 | {"type":"Point","coordinates":[7.6640249934535,47.5864159264449]} | Inzlingerstrasse | 238 | Riehen | 30.0 | 2020-08-03 | 2020-08-17 |
| 466 | 466 | 254 | 2 | Steingrubenweg | 3705.0 | 31.0 | 38.0 | 26.4 | {"type":"Point","coordinates":[7.65827559007493,47.5880367828809]} | Bäumliweg | Vis 30 | Riehen | 30.0 | 2020-07-27 | 2020-08-10 |
| 464 | 464 | 253 | 2 | keine | {"type":"Point","coordinates":[7.65429929128466,47.5844017880728]} | Schützengasse | 29 | Riehen | 30.0 | 2020-07-27 | 2020-08-10 | ||||
| 442 | 442 | 239 | 2 | Kohlistieg | 2384.0 | 34.0 | 39.0 | 34.9 | {"type":"Point","coordinates":[7.63788143190141,47.5699062529231]} | Schäferstrasse | 59 | Riehen | 30.0 | 2020-06-29 | 2020-07-13 |
| 440 | 440 | 238 | 2 | Lörracherstrasse | 16726.0 | 31.0 | 37.0 | 21.2 | {"type":"Point","coordinates":[7.64445340865286,47.5923789887357]} | Weilstrasse | Gegenüber Naturbad | Riehen | 30.0 | 2020-06-29 | 2020-07-13 |
| 434 | 434 | 235 | 2 | Grenzacherweg | 9000.0 | 46.0 | 52.0 | 4.2 | {"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");