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
89 rows where Ort = "Riehen", Richtung ID = 1 and Zone = "30.0" sorted by Messung-ID descending
This data as json, CSV (advanced)
Strasse >30
- Kilchgrundstrasse 6
- Inzlingerstrasse 5
- Mühlestiegstrasse 5
- Chrischonaweg 4
- Bischoffweg 3
- Gotenstrasse 3
- Schützengasse 3
- Weilstrasse 3
- Aeussere Baselstrasse 2
- Bahnhofstrasse 2
- Burgstrasse 2
- Hackbergstrasse 2
- Haselrain 2
- Hörnliallee 2
- Im Hirshalm 2
- Kornfeldstrasse 2
- Lörracherstrasse 2
- Oberdorfstrasse 2
- Schäferstrasse 2
- Steingrubenweg 2
- Wenkenstrasse 2
- Auf der Bischoffhöhe 1
- Bäumliweg 1
- Erlensträsschen 1
- Essigstrasse 1
- Grenzacherweg 1
- Hinter Gärten 1
- Hohlweg 1
- Höhenstrasse 1
- Im Niederholzboden 1
- …
Messung-ID >30
Messende (date) >30
- 2019-06-19 2
- 2020-05-18 2
- 2020-07-13 2
- 2020-08-10 2
- 2025-05-05 2
- 2018-08-05 1
- 2018-08-20 1
- 2018-09-05 1
- 2019-03-18 1
- 2019-03-30 1
- 2019-05-01 1
- 2019-08-24 1
- 2019-09-30 1
- 2019-12-10 1
- 2020-03-01 1
- 2020-03-21 1
- 2020-04-26 1
- 2020-05-09 1
- 2020-06-27 1
- 2020-08-17 1
- 2020-09-07 1
- 2020-10-16 1
- 2020-11-03 1
- 2020-11-13 1
- 2021-01-12 1
- 2021-01-28 1
- 2021-02-01 1
- 2021-03-22 1
- 2021-04-12 1
- 2021-05-24 1
- …
Messbeginn (date) >30
- 2019-06-03 2
- 2020-05-04 2
- 2020-06-29 2
- 2020-07-27 2
- 2021-01-18 2
- 2021-08-23 2
- 2022-10-17 2
- 2022-12-12 2
- 2023-10-09 2
- 2023-10-23 2
- 2025-02-03 2
- 2025-02-17 2
- 2025-04-22 2
- 2018-07-23 1
- 2018-08-06 1
- 2018-08-21 1
- 2019-03-04 1
- 2019-03-18 1
- 2019-04-15 1
- 2019-08-12 1
- 2019-09-23 1
- 2019-12-02 1
- 2020-02-24 1
- 2020-03-09 1
- 2020-04-15 1
- 2020-04-27 1
- 2020-06-15 1
- 2020-08-03 1
- 2020-08-24 1
- 2020-10-05 1
- …
Zone 1
- 30.0 · 89 ✖
Richtung ID 1
- 1 · 89 ✖
Ort 1
- Riehen · 89 ✖
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 427 | 427 | 230 | 1 | Im Baumgarten | 2232.0 | 26.0 | 33.0 | 8.2 | {"type":"Point","coordinates":[7.64526095558755,47.5674920659302]} | Waltersgrabenweg | 10 | Riehen | 30.0 | 2020-06-15 | 2020-06-27 |
| 389 | 389 | 208 | 1 | Gotenstrasse | 3101.0 | 27.0 | 32.0 | 4.9 | {"type":"Point","coordinates":[7.63098718697989,47.5707182879122]} | Im Hirshalm | 17 | Riehen | 30.0 | 2020-05-04 | 2020-05-18 |
| 387 | 387 | 207 | 1 | Wasserstelzenweg | 4961.0 | 27.0 | 33.0 | 6.7 | {"type":"Point","coordinates":[7.63705625780263,47.5731453937043]} | Keltenweg | vis 24 | Riehen | 30.0 | 2020-05-04 | 2020-05-18 |
| 375 | 375 | 201 | 1 | Bettingerstrasse | 7249.0 | 22.0 | 28.0 | 2.6 | {"type":"Point","coordinates":[7.62940075089679,47.5730412713099]} | Aeussere Baselstrasse | 320 | Riehen | 30.0 | 2020-04-27 | 2020-05-09 |
| 373 | 373 | 200 | 1 | Bettingerstrasse | 9224.0 | 15.0 | 21.0 | 0.3 | {"type":"Point","coordinates":[7.63533933161245,47.5760712558277]} | Aeussere Baselstrasse | 254/256 | Riehen | 30.0 | 2020-04-15 | 2020-04-26 |
| 335 | 335 | 179 | 1 | Baselstrasse | 29184.0 | 23.0 | 28.0 | 0.8 | {"type":"Point","coordinates":[7.65313867720878,47.5866793279206]} | Rössligasse | vis 51 | Riehen | 30.0 | 2018-08-21 | 2018-09-05 |
| 309 | 309 | 164 | 1 | Baselstrasse | 20243.0 | 32.0 | 38.0 | 23.7 | {"type":"Point","coordinates":[7.66658753905587,47.5856914423227]} | Inzlingerstrasse | 274 | Riehen | 30.0 | 2018-08-06 | 2018-08-20 |
| 281 | 281 | 147 | 1 | Aeussere Baselstrasse | 4664.0 | 31.0 | 36.0 | 17.4 | {"type":"Point","coordinates":[7.64255988974555,47.5770121617596]} | Kilchgrundstrasse | 57 | Riehen | 30.0 | 2020-03-09 | 2020-03-21 |
| 263 | 263 | 138 | 1 | Chrischonawegli | 3095.0 | 30.0 | 35.0 | 13.0 | {"type":"Point","coordinates":[7.66112533878548,47.5828330348532]} | Chrischonaweg | vis 73 | Riehen | 30.0 | 2018-07-23 | 2018-08-05 |
| 239 | 239 | 126 | 1 | Eisenbahnweg | 579.0 | 32.0 | 38.0 | 24.5 | {"type":"Point","coordinates":[7.65186130486908,47.5797385661944]} | Wenkenstrasse | vis. 46 | Riehen | 30.0 | 2020-02-24 | 2020-03-01 |
| 213 | 213 | 113 | 1 | Lörracherstrasse | 37807.0 | 31.0 | 37.0 | 21.3 | {"type":"Point","coordinates":[7.64479931958559,47.5924413321852]} | Weilstrasse | Höhe Naturbad | Riehen | 30.0 | 2019-06-03 | 2019-06-19 |
| 179 | 179 | 92 | 1 | Eisenbahnweg | 30641.0 | 31.0 | 36.0 | 16.4 | {"type":"Point","coordinates":[7.65463431178363,47.5850666976586]} | Schützengasse | vis 46 | Riehen | 30.0 | 2019-08-12 | 2019-08-24 |
| 99 | 99 | 52 | 1 | Stettenlochweg | 1665.0 | 38.0 | 46.0 | 66.1 | {"type":"Point","coordinates":[7.65965205349774,47.5897699511988]} | Bischoffweg | 24 | Riehen | 30.0 | 2019-03-18 | 2019-03-30 |
| 97 | 97 | 51 | 1 | Aeussere Baselstrasse | 4086.0 | 19.0 | 27.0 | 0.8 | {"type":"Point","coordinates":[7.6342190366174,47.5713964244256]} | Niederholzstrasse | 108 | Riehen | 30.0 | 2019-09-23 | 2019-09-30 |
| 45 | 45 | 23 | 1 | Inzlingerstrasse | 5641.0 | 29.0 | 35.0 | 12.6 | {"type":"Point","coordinates":[7.6559346332851,47.5877353927316]} | Hinter Gärten | 4 | Riehen | 30.0 | 2019-04-15 | 2019-05-01 |
| 43 | 43 | 22 | 1 | Inzlingerstrasse | 6762.0 | 27.0 | 33.0 | 6.8 | {"type":"Point","coordinates":[7.65565550714746,47.5910096002166]} | Haselrain | vis Friedhof | Riehen | 30.0 | 2019-03-04 | 2019-03-18 |
| 9 | 9 | 5 | 1 | Helvetierstrasse | 4916.0 | 12.0 | 24.0 | 1.4 | {"type":"Point","coordinates":[7.631686319231,47.5692781384956]} | Gotenstrasse | vis Helvetierstrasse | Riehen | 30.0 | 2019-12-02 | 2019-12-10 |
| 3 | 3 | 2 | 1 | Bettingerstrasse | 9935.0 | 20.0 | 28.0 | 1.4 | {"type":"Point","coordinates":[7.64556116488399,47.579785911627]} | Burgstrasse | 51 | Riehen | 30.0 | 2019-06-03 | 2019-06-19 |
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");