\n", " | distance_overtaker | \n", "distance_stationary | \n", "direction | \n", "way_id | \n", "course | \n", "speed | \n", "time | \n", "geometry | \n", "portal | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "1.82 | \n", "NaN | \n", "-1 | \n", "28496022.0 | \n", "1.913791 | \n", "4.611111 | \n", "2022-05-09 15:22:33+00:00 | \n", "POINT (13.42786 52.47392) | \n", "bbb | \n", "
1 | \n", "0.71 | \n", "NaN | \n", "-1 | \n", "28496022.0 | \n", "1.927347 | \n", "1.666667 | \n", "2022-05-09 15:22:48+00:00 | \n", "POINT (13.42766 52.47430) | \n", "bbb | \n", "
2 | \n", "1.57 | \n", "0.50 | \n", "-1 | \n", "849599088.0 | \n", "1.934648 | \n", "4.500000 | \n", "2022-05-09 15:23:26+00:00 | \n", "POINT (13.42738 52.47485) | \n", "bbb | \n", "
3 | \n", "1.26 | \n", "0.74 | \n", "-1 | \n", "568336446.0 | \n", "1.878984 | \n", "4.138889 | \n", "2022-05-09 15:23:33+00:00 | \n", "POINT (13.42746 52.47528) | \n", "bbb | \n", "
4 | \n", "2.05 | \n", "NaN | \n", "-1 | \n", "816236476.0 | \n", "2.021442 | \n", "4.083333 | \n", "2022-05-09 15:23:44+00:00 | \n", "POINT (13.42769 52.47581) | \n", "bbb | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2102 | \n", "1.29 | \n", "2.41 | \n", "1 | \n", "93245513.0 | \n", "0.794396 | \n", "3.916667 | \n", "2022-11-01 05:42:58+00:00 | \n", "POINT (8.00970 52.26666) | \n", "os | \n", "
2103 | \n", "1.69 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.721962 | \n", "2.361111 | \n", "2022-11-01 05:43:05+00:00 | \n", "POINT (8.01000 52.26678) | \n", "os | \n", "
2104 | \n", "1.39 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.536645 | \n", "2.138889 | \n", "2022-11-01 05:43:08+00:00 | \n", "POINT (8.01010 52.26682) | \n", "os | \n", "
2105 | \n", "1.52 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.930771 | \n", "2.750000 | \n", "2022-11-01 05:43:16+00:00 | \n", "POINT (8.01051 52.26698) | \n", "os | \n", "
2106 | \n", "1.51 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.880807 | \n", "2.694444 | \n", "2022-11-01 05:43:20+00:00 | \n", "POINT (8.01073 52.26707) | \n", "os | \n", "
108461 rows × 9 columns
\n", "\n", " | osm_id | \n", "name | \n", "highway | \n", "ref | \n", "maxspeed | \n", "lanes | \n", "lit | \n", "surface | \n", "bicycle | \n", "cycleway | \n", "... | \n", "smoothness | \n", "oneway | \n", "cycleway_both_lane | \n", "cycleway_right_lane | \n", "cycleway_left_lane | \n", "parking_lane_both | \n", "parking_lane_left | \n", "parking_lane_right | \n", "other_tags | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "92 | \n", "Eigenheimstraße | \n", "residential | \n", "None | \n", "30 | \n", "None | \n", "yes | \n", "asphalt | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"maxweight\"=>\"3.5\",\"maxweight:destination\"=>\"n... | \n", "LINESTRING (13.73698 51.01663, 13.73752 51.016... | \n", "
1 | \n", "93 | \n", "Eigenheimberg | \n", "residential | \n", "None | \n", "30 | \n", "None | \n", "yes | \n", "asphalt | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"maxweight\"=>\"3.5\",\"maxweight:destination\"=>\"n... | \n", "LINESTRING (13.73939 51.01669, 13.73967 51.016... | \n", "
2 | \n", "99 | \n", "None | \n", "tertiary | \n", "None | \n", "None | \n", "None | \n", "yes | \n", "asphalt | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"junction\"=>\"roundabout\",\"lane_markings\"=>\"no\"... | \n", "LINESTRING (11.36639 48.17411, 11.36643 48.174... | \n", "
3 | \n", "100 | \n", "None | \n", "secondary | \n", "St 2069 | \n", "100 | \n", "None | \n", "None | \n", "asphalt | \n", "use_sidepath | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"foot\"=>\"use_sidepath\",\"junction\"=>\"roundabout... | \n", "LINESTRING (11.33035 48.18011, 11.33028 48.180... | \n", "
4 | \n", "103 | \n", "Altmockritz | \n", "residential | \n", "None | \n", "5 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"postal_code\"=>\"01217\",\"source:maxspeed\"=>\"sign\" | \n", "LINESTRING (13.74127 51.01615, 13.74149 51.016... | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
9737740 | \n", "1109134415 | \n", "None | \n", "footway | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"footway\"=>\"sidewalk\" | \n", "LINESTRING (7.84410 47.98632, 7.84415 47.98636... | \n", "
9737741 | \n", "1109134416 | \n", "None | \n", "footway | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"footway\"=>\"sidewalk\" | \n", "LINESTRING (7.84433 47.98790, 7.84433 47.98795... | \n", "
9737742 | \n", "1109134417 | \n", "None | \n", "footway | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"footway\"=>\"sidewalk\" | \n", "LINESTRING (7.84453 47.98793, 7.84454 47.98798... | \n", "
9737743 | \n", "1109134418 | \n", "None | \n", "footway | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"footway\"=>\"sidewalk\" | \n", "LINESTRING (7.84454 47.98798, 7.84584 47.98816... | \n", "
9737744 | \n", "1109134419 | \n", "None | \n", "footway | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"footway\"=>\"sidewalk\" | \n", "LINESTRING (7.84612 47.98821, 7.84616 47.98824... | \n", "
9737745 rows × 25 columns
\n", "\n", " | distance_overtaker | \n", "distance_stationary | \n", "direction | \n", "way_id | \n", "course | \n", "speed | \n", "time | \n", "geometry_x | \n", "portal | \n", "distance_overtaker_binned | \n", "... | \n", "smoothness | \n", "oneway | \n", "cycleway_both_lane | \n", "cycleway_right_lane | \n", "cycleway_left_lane | \n", "parking_lane_both | \n", "parking_lane_left | \n", "parking_lane_right | \n", "other_tags | \n", "geometry_y | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "182.0 | \n", "NaN | \n", "-1 | \n", "28496022 | \n", "1.913791 | \n", "4.611111 | \n", "2022-05-09 15:22:33+00:00 | \n", "POINT (13.42786 52.47392) | \n", "bbb | \n", "150-200 | \n", "... | \n", "good | \n", "None | \n", "None | \n", "None | \n", "None | \n", "parallel | \n", "None | \n", "None | \n", "\"foot\"=>\"use_sidepath\",\"lane_markings\"=>\"yes\",... | \n", "LINESTRING (13.42746 52.47469, 13.42748 52.474... | \n", "
1 | \n", "71.0 | \n", "NaN | \n", "-1 | \n", "28496022 | \n", "1.927347 | \n", "1.666667 | \n", "2022-05-09 15:22:48+00:00 | \n", "POINT (13.42766 52.47430) | \n", "bbb | \n", "50-100 | \n", "... | \n", "good | \n", "None | \n", "None | \n", "None | \n", "None | \n", "parallel | \n", "None | \n", "None | \n", "\"foot\"=>\"use_sidepath\",\"lane_markings\"=>\"yes\",... | \n", "LINESTRING (13.42746 52.47469, 13.42748 52.474... | \n", "
2 | \n", "119.0 | \n", "74.0 | \n", "1 | \n", "28496022 | \n", "4.994918 | \n", "3.944444 | \n", "2022-05-10 06:12:56+00:00 | \n", "POINT (13.42753 52.47456) | \n", "bbb | \n", "100-150 | \n", "... | \n", "good | \n", "None | \n", "None | \n", "None | \n", "None | \n", "parallel | \n", "None | \n", "None | \n", "\"foot\"=>\"use_sidepath\",\"lane_markings\"=>\"yes\",... | \n", "LINESTRING (13.42746 52.47469, 13.42748 52.474... | \n", "
3 | \n", "149.0 | \n", "NaN | \n", "1 | \n", "28496022 | \n", "5.283753 | \n", "3.305556 | \n", "2022-05-05 06:06:42+00:00 | \n", "POINT (13.42762 52.47439) | \n", "bbb | \n", "100-150 | \n", "... | \n", "good | \n", "None | \n", "None | \n", "None | \n", "None | \n", "parallel | \n", "None | \n", "None | \n", "\"foot\"=>\"use_sidepath\",\"lane_markings\"=>\"yes\",... | \n", "LINESTRING (13.42746 52.47469, 13.42748 52.474... | \n", "
4 | \n", "169.0 | \n", "NaN | \n", "1 | \n", "28496022 | \n", "5.052679 | \n", "3.944444 | \n", "2022-05-05 06:06:53+00:00 | \n", "POINT (13.42786 52.47392) | \n", "bbb | \n", "150-200 | \n", "... | \n", "good | \n", "None | \n", "None | \n", "None | \n", "None | \n", "parallel | \n", "None | \n", "None | \n", "\"foot\"=>\"use_sidepath\",\"lane_markings\"=>\"yes\",... | \n", "LINESTRING (13.42746 52.47469, 13.42748 52.474... | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
100471 | \n", "148.0 | \n", "198.0 | \n", "1 | \n", "39320393 | \n", "1.370343 | \n", "7.250000 | \n", "2022-09-28 05:50:11+00:00 | \n", "POINT (8.01634 52.26995) | \n", "os | \n", "100-150 | \n", "... | \n", "None | \n", "yes | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "LINESTRING (8.01622 52.26958, 8.01631 52.26967... | \n", "
100472 | \n", "189.0 | \n", "94.0 | \n", "1 | \n", "254429971 | \n", "0.285211 | \n", "5.722222 | \n", "2022-09-28 06:00:22+00:00 | \n", "POINT (8.04871 52.28001) | \n", "os | \n", "150-200 | \n", "... | \n", "None | \n", "yes | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"lane_markings\"=>\"no\",\"sidewalk\"=>\"right\",\"sou... | \n", "LINESTRING (8.04791 52.27995, 8.04809 52.28005... | \n", "
100473 | \n", "220.0 | \n", "95.0 | \n", "-1 | \n", "7752586 | \n", "3.737579 | \n", "5.055556 | \n", "2022-11-02 14:59:03+00:00 | \n", "POINT (7.99315 52.25897) | \n", "os | \n", "200-250 | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"sidewalk\"=>\"both\" | \n", "LINESTRING (7.99180 52.25798, 7.99192 52.25816... | \n", "
100474 | \n", "126.0 | \n", "109.0 | \n", "-1 | \n", "26733317 | \n", "6.240770 | \n", "4.805556 | \n", "2022-10-04 05:07:51+00:00 | \n", "POINT (8.04897 52.27981) | \n", "os | \n", "100-150 | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "LINESTRING (8.05178 52.27926, 8.05171 52.27923... | \n", "
100475 | \n", "125.0 | \n", "106.0 | \n", "1 | \n", "7760160 | \n", "0.695963 | \n", "4.805556 | \n", "2022-11-01 05:34:50+00:00 | \n", "POINT (7.99438 52.25893) | \n", "os | \n", "100-150 | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "\"sidewalk\"=>\"right\" | \n", "LINESTRING (7.99367 52.25932, 7.99414 52.25906... | \n", "
100476 rows × 36 columns
\n", "\n", " | maxspeed | \n", "counts | \n", "
---|---|---|
0 | \n", "100 | \n", "291 | \n", "
1 | \n", "20 | \n", "8 | \n", "
2 | \n", "30 | \n", "2107 | \n", "
3 | \n", "40 | \n", "21 | \n", "
4 | \n", "50 | \n", "9734 | \n", "
5 | \n", "60 | \n", "75 | \n", "
6 | \n", "70 | \n", "1224 | \n", "
7 | \n", "80 | \n", "273 | \n", "
\n", " | index | \n", "0 | \n", "share_tags | \n", "share_tags_inverse | \n", "
---|---|---|---|---|
0 | \n", "maxspeed | \n", "675 | \n", "0.953535 | \n", "0.046465 | \n", "
1 | \n", "lit | \n", "6395 | \n", "0.559785 | \n", "0.440215 | \n", "
2 | \n", "lanes | \n", "4158 | \n", "0.713774 | \n", "0.286226 | \n", "
3 | \n", "surface | \n", "1192 | \n", "0.917946 | \n", "0.082054 | \n", "
4 | \n", "width | \n", "14114 | \n", "0.028430 | \n", "0.971570 | \n", "
5 | \n", "smoothness | \n", "8078 | \n", "0.443932 | \n", "0.556068 | \n", "
6 | \n", "cycleway (assembled) | \n", "3767 | \n", "0.740690 | \n", "0.259310 | \n", "
\n", " | index | \n", "0 | \n", "share_tags | \n", "share_tags_inverse | \n", "
---|---|---|---|---|
0 | \n", "maxspeed | \n", "8058 | \n", "0.919802 | \n", "0.080198 | \n", "
1 | \n", "lit | \n", "29701 | \n", "0.704397 | \n", "0.295603 | \n", "
2 | \n", "lanes | \n", "31143 | \n", "0.690045 | \n", "0.309955 | \n", "
3 | \n", "surface | \n", "7149 | \n", "0.928849 | \n", "0.071151 | \n", "
4 | \n", "width | \n", "97251 | \n", "0.032097 | \n", "0.967903 | \n", "
5 | \n", "smoothness | \n", "71340 | \n", "0.289980 | \n", "0.710020 | \n", "
6 | \n", "cycleway (assembled) | \n", "39586 | \n", "0.606015 | \n", "0.393985 | \n", "
\n", " | cycleway_mod_dir | \n", "counts | \n", "
---|---|---|
5 | \n", "no | \n", "4504 | \n", "
17 | \n", "NaN | \n", "3720 | \n", "
1 | \n", "lane | \n", "1897 | \n", "
2 | \n", "lane:advisory | \n", "1585 | \n", "
11 | \n", "separate | \n", "1307 | \n", "
15 | \n", "track | \n", "659 | \n", "
4 | \n", "lane:exclusive | \n", "604 | \n", "
12 | \n", "share_busway | \n", "82 | \n", "
14 | \n", "shared_lane | \n", "15 | \n", "
0 | \n", "cyclewaylane | \n", "15 | \n", "
10 | \n", "oppositeno | \n", "5 | \n", "
8 | \n", "opposite | \n", "2 | \n", "
6 | \n", "none | \n", "2 | \n", "
3 | \n", "lane:designated | \n", "2 | \n", "
9 | \n", "opposite_track | \n", "2 | \n", "
7 | \n", "nono | \n", "1 | \n", "
13 | \n", "shared | \n", "1 | \n", "
16 | \n", "yes | \n", "1 | \n", "
\n", " | geometry_x | \n", "cycleway_mod_dir | \n", "
---|---|---|
0 | \n", "POINT (13.42786 52.47392) | \n", "no | \n", "
1 | \n", "POINT (13.42766 52.47430) | \n", "no | \n", "
2 | \n", "POINT (13.42753 52.47456) | \n", "no | \n", "
3 | \n", "POINT (13.42762 52.47439) | \n", "no | \n", "
4 | \n", "POINT (13.42786 52.47392) | \n", "no | \n", "
... | \n", "... | \n", "... | \n", "
14773 | \n", "POINT (13.52152 52.36479) | \n", "separate | \n", "
14774 | \n", "POINT (13.36614 52.54229) | \n", "no | \n", "
14775 | \n", "POINT (13.61395 52.34502) | \n", "no | \n", "
14776 | \n", "POINT (13.52560 52.36576) | \n", "separate | \n", "
14777 | \n", "POINT (13.51989 52.36441) | \n", "separate | \n", "
14527 rows × 2 columns
\n", "\n", " | distance_overtaker_binned | \n", "counts | \n", "
---|---|---|
0 | \n", "<50 | \n", "0 | \n", "
1 | \n", "50-100 | \n", "12 | \n", "
2 | \n", "100-150 | \n", "27 | \n", "
3 | \n", "150-200 | \n", "8 | \n", "
4 | \n", "200-250 | \n", "1 | \n", "
5 | \n", ">250 | \n", "0 | \n", "
\n", " | distance_overtaker_binned | \n", "counts | \n", "
---|---|---|
0 | \n", "<50 | \n", "0 | \n", "
1 | \n", "50-100 | \n", "10 | \n", "
2 | \n", "100-150 | \n", "38 | \n", "
3 | \n", "150-200 | \n", "32 | \n", "
4 | \n", "200-250 | \n", "11 | \n", "
5 | \n", ">250 | \n", "0 | \n", "
\n", " | distance_overtaker_binned | \n", "counts | \n", "
---|---|---|
0 | \n", "<50 | \n", "0 | \n", "
1 | \n", "50-100 | \n", "0 | \n", "
2 | \n", "100-150 | \n", "13 | \n", "
3 | \n", "150-200 | \n", "17 | \n", "
4 | \n", "200-250 | \n", "5 | \n", "
5 | \n", ">250 | \n", "1 | \n", "
\n", " | distance_overtaker_binned | \n", "counts | \n", "
---|---|---|
0 | \n", "<50 | \n", "1 | \n", "
1 | \n", "50-100 | \n", "4 | \n", "
2 | \n", "100-150 | \n", "29 | \n", "
3 | \n", "150-200 | \n", "16 | \n", "
4 | \n", "200-250 | \n", "1 | \n", "
5 | \n", ">250 | \n", "0 | \n", "