The steps of San Francisco

I was curious about what ways in OpenStreetMap were defined as Steps, so I did some basic queries and maps and reports. The query’s overly broad, I need to learn how to intersect that with the actual city of SF.

select
  name, round(ST_Length(way)) as meters, osm_id
from planet_osm_line
where highway = 'steps'
order by meters desc;
meters name
290
280
273
271 Dipsea Trail
260 Arbon Path
245 Sand Ladder
239
226 Wildcat Path
222
213 Chaumont Path
206
201 Fred Herbert Path
198 Lyon Street
195 Lulu Alley
193 Oakhurst Lane
193 Belap Path
191 Vulcan Steps
190
185 El Paseo Path
180 Locarno Path
171
169 Pemberton Place
166 Dipsea Stairs
158 Onique Lane
154 Filbert Steps
154
153 Opal Street
151 Prospect Steps
148
147 Harry Street
146 Poppy Path
141
138
136 Blairwood Lane
135 Sterling Path
134 Covert Path
134 Yosemite Steps
133 Shasta Path
130
129 Quintara Street
129
129 Glendale Path
129 Erba Path
128 El Monte Lane
126 Upper Alcatraz Place
126
125 Cleveland Cascade
125 Orchard Lane
125 Tamalpais Path
125 Ortega Way
124 Path Street
123 Post Street
123
122 Mount Lane
122
121 The Footway
120 Northgate Path
118 South Crossways
118 Greenwich Street Stairs
117 Hawkins Lane
117 Bootlegger’s Steps
116 Stevenson Path
116
115 Ridgeview Path
114 Poplar Path
114
114 Claremont Steps
114 Terrace Walk
114
113 Flibert Steps
113 Rotundo Path
112 Easter Way
111 Visalia Walk
111 Covert Path
111
110 Peter Macchiarini Steps
110 Peter Macchiarini Steps
110
109
109 Stolte Grove
109
109
108 Aerial Way
107 Cascade Walk
106
106
104
104 Bret Harte Path
104 Joy Street
103
102 Moraga St. Steps
102 Redwood Terrace
102 Vallejo Street
102 8th Avenue
102 Linda Vista Steps Street
102
101
101 Coralino Lane
101 Mandalay Lane
101 Stevenson Path
99 Altas Path
99 Avoca Alley
99 Athens Street
97
97
96
96
96 Aerial Way
96 Dipsea Steps
96 Path #9
96 Pacheco Street
95 Glenhaven Lane
95 Farnsworth Lane
94 Oriole Way
94
93
93
93
93
92 Esmeralda Avenue
91 Vincente Walk
91
91 Andeer Path
91 Whitaker Path
91
89
89
89
87 Brookside Lane
87
87
87 Saturn Street Stairs
86
86 Acacia Steps
85 Bancroft Steps
85 The Agave Trail
85 Martinez Path
84
84 Maryland Walk
83 Acme Alley
83 Waller Street
83
81
80
80 Yosemite Steps
80 Stairs
80 Wilson Walk
80
80 Amatista Lane
80 Onique Lane
79
79 Vallejo Street Stairway
79 Ward Street
79 North Path
78 Coastal Trail
77 Cedar Street Path
77 Anne Brower Path
77 Arollo/Arolla Path
77
77 Sunglow Lane
77 Blairwood Lane
76
76
76 Monument Way
76 Fair Avenue
75 Rock Walk
74 Macondray Lane
74
74
74 Esmeralda Avenue
73 Esmeralda Avenue
73
73 Greenwich Street Stairs
73 Hillview Court
73
72
72
72 Griffith Street
72
72 Eugenia Avenue
71
71
68 Iron Alley
68
68
68
68
68
67 Terrace Walk
67 Greenwich Street
67 Vista Lane
67
67 Hill Court Steps
67
66 27th Street
66 Naglee Avenue
65
65
65
65 Beeman Lane
65
64 Verona Path
64
63
63
63 Sunbeam Lane
62
62
61 Prospect Avenue
61
61 Liberty Street
60
60 Stoddard Path
60
60
60 3rd Avenue
59
58
58
58
58 Acme Alley
58
56
56
56
56
55 Bret Harte Lane
55
55 Le Roy Steps
55
54
54 Andover Street
54 Verona Path
53 Orchard Lane
53 Harrison Street
53
53
53
53
53 Boynton Walk
53
53
52 Path #6
52
52
51 Opalo Lane
51
51 Saint Mary’s Avenue
51 Oneida Avenue
50
50 Reno Place
50
50
50
49 Douglass Street
49
49
49 Mono Street
49 Chestnut Street Steps
49
48
48 Muir Path
48
47 Clifford Terrace Stairway
47 Greenwich Street Stairs
47 Billie Jean Walk
47
47
46
46 Arden Steps
46
46
46
45 Gondo Path
45
45 Kenny Alley
45 20th Street
45
44 Lagunitas Avenue
44 Rose Steps
44 20th Street
44 Orchard Lane
44 Levant Street Stairway
44 Fair Avenue
43
43
42
42 Excelsior Lane
42
42 Corbin Place
41
41
41
41
41
40
40 Plank Trail
40 Florida Walk
39
39
39
38
38
38 Duncan Street
38
38
38
37
37 Larkin Street
37 Priest Street
37
37
37
37
37
36 Coastal Trail
36
36
36
36 Path #9
35
35
35
35
35
35
35 Cowboy Rock Trail
35 Houston Street
35
35
35
34
34
34
34
33
33 La Vareda Steps
33
33
33
33
33 Latham Walk
33
33
33
33 Aztec Street
33
32 Fred Herbert Path
32
32
32
32
32
32
32
32
31
31 Glendale Street
31
31
31
31 Crescent Park Path
31 South Street
31
31
31
31 Indian Rock Path
30
30
30
30
30
30 Quail Lane
30 Bessie Street
30
30
30
30
29
29
29 Billie Jean Walk
29
29
29 The Steps
29
29
29 Tamalpais Path
28
28
28
28
28 Bronte Street
28
28
27
27
27 Glendale Path
27
27
27
27 Hawthorne Steps
27
27
27
27
27
27
26
26 Forest Hill Path
26
25
25
25 Fountain Walk
25
25
25
25 20th Street
25
24
24
24
24
24
24
24
24
24
24
24
24
24
23 Boynton Walk
23 Gilroy Street
23 Steps to the soutbound Caltrain platform
23
23
23
23 Havens Street
23
23
22
22 Palmer Avenue
22
22
22
22
22
22 Franconia Street
22
22
21
21
21
21
21
21
21
21
21
21
21
21
21
20
20
20
20
20
20
20
20
20
20
20 Kingston Street
20
20 Bootlegger’s Steps
19
19
19
19
19
19
19
19
19
19
19
19
19
19 Santa Barbara Path
19
19
19
19
19
19
19
19
19
19
19 Tuscany Alley
19
19
19
19
18
18 Path #6
18
18
18
18
18
18
18
18
18 Path #3
18
18 Glen Rose Alley
18
18
18
17
17
17 La Loma Steps
17 Filbert Steps
17
17
17
17
17 De Forest Way
17 Path #6
17
17 Glendale Path
17 Hawthorne Steps
17
17
17
17 Ardmore Path
17
17 Codman Place
16
16
16
16
16
16 Moraga Street
16
16
16
16
16
16 La Loma Steps
16
16
16
16
15
15
15
15
15
15
15
15
15
15
15
15
15
15
15 Path #4
15
15
14
14
14
14
14
14 Stratford Path
14
14
14
14
14
14 Rose Walk
14
14
14
14
14
13
13
13
13 Short Cut
13
13
13
13 West Lane
13 Indian Rock Path
13
13
13
13
13
13 El Camino del Mar
13
13
13
13
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12 Franconia Street
12
12
11
11
11
11
11
10
10
10
10
10
10
10
10
10
10 Glendale Path
10 Glendale Path
10
10
10
10
10
10
10
10
10
9
9
9
9
9 Broadway Street
9
9
9
9
9
9 Arden Path
9
9
9
9
8
8 Mosswood Lane
8
8
8
8
8
8
8
8
8
8
8
8
8
7
7
7
7
7
7
7
7 Jack Micheline Place
7
7 Stolte Grove
6
6
6
6
6
6
6
5 West Lane
5
5
5
4
4
4
4
4
4
3
3
3
3