steps
Data source: City of Pittsburgh Steps
1,134 rows
This data as json, CSV (advanced)
Link | rowid ▼ | id | name | maintenance_responsibility | installed | material | length | number_of_steps | schools_count | school_score | total_population | transit_rider_count | transit_score | detour_score | overall_score | image | neighborhood | council_district | ward | tract | public_works_division | pli_division | police_zone | fire_zone | latitude | longitude |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | 758668959 | Byron St from Melwood Ave to Gold Way | 3rd Division | 1949-01-01 | Concrete | 97 | 14 | 0 | 100 | 202 | 12 | 2 | 5 | 4 | https://tools.wprdc.org/images/pittsburgh/steps/Byron_St_from_Melwood_Ave_to_Gold_Way.jpg | North Oakland | 6 | 5 | 42003562000 | 3 | 5 | 4 | 2-23 | 40.45727609 | -79.95459865 |
102 | 102 | 36558457 | Caeser Way from Sterling St | 4th Division | Wood | 80 | 52 | 0 | 100 | 605 | 67 | 3 | 1 | 5 | https://tools.wprdc.org/images/pittsburgh/steps/Caeser_Way_from_Sterling_St.jpg | South Side Slopes | 3 | 16 | 42003160800 | 3 | 16 | 3 | 4-22 | 40.42272311 | -79.97371701 | |
103 | 103 | 1438496025 | California Ave from Eckert St to Knapp St | 1st Division | 1923-01-01 | Concrete | 349 | 119 | 0 | 100 | 664 | 94 | 5 | 2 | 5 | https://tools.wprdc.org/images/pittsburgh/steps/California_Ave_from_Eckert_St_to_Knapp_St.jpg | Marshall-Shadeland | 1 | 27 | 42003271500 | 1 | 27 | 1 | 1-14 | 40.47116953 | -80.03617799 |
104 | 104 | 2064170340 | Candace St from Crosby Ave to Shiras Ave | 5th Division | Concrete | 130 | 56 | 0 | 100 | 744 | 418 | 10 | 7 | 6 | https://tools.wprdc.org/images/pittsburgh/steps/Candace_St_from_Crosby_Ave_to_Shiras_Ave.jpg | Beechview | 4 | 19 | 42003192000 | 5 | 19 | 6 | 4-28 | 40.40411009 | -80.03209315 | |
105 | 105 | 488343298 | Canton Ave from Coast Ave to Hampshire Ave | 5th Division | Concrete | 250 | 54 | https://tools.wprdc.org/images/pittsburgh/steps/Canton_Ave_from_Coast_Ave_to_Hampshire_Ave.jpg | Beechview | 4 | 19 | 42003191600 | 5 | 19 | 6 | 4-28 | 40.40945782 | -80.03002541 | ||||||||
106 | 106 | 1961733621 | Caperton St from Fordyce St to Conniston Ave | 4th Division | 1947-01-01 | Concrete | 357 | 57 | https://tools.wprdc.org/images/pittsburgh/steps/Caperton_St_from_Fordyce_St_to_Conniston_Ave.jpg | Bon Air | 4 | 18 | 42003562400 | 5 | 18 | 3 | 4-7 | 40.40966406 | -80.00001162 | |||||||
107 | 107 | 756027237 | Caramel Way to Webster Ave | 3rd Division | 1949-01-01 | Concrete | 72 | 35 | 1 | 10 | 893 | 237 | 10 | 9 | 10 | https://tools.wprdc.org/images/pittsburgh/steps/Caramel_Way_to_Webster_Ave.jpg | Middle Hill | 6 | 5 | 42003050100 | 3 | 5 | 2 | 2-5 | 40.44850732 | -79.97450029 |
108 | 108 | 1529995894 | Carnahan Rd at Younger Ave from Banksville Ave | 5th Division | Concrete | 140 | 74 | 1 | 2 | 281 | 10 | 2 | 4 | 2 | https://tools.wprdc.org/images/pittsburgh/steps/Carnahan_Rd_at_Younger_Ave_from_Banksville_Ave.jpg | Banksville | 2 | 20 | 42003202300 | 5 | 20 | 6 | 4-9 | 40.40681817 | -80.03603058 | |
109 | 109 | 1845636601 | Carnegie St | 2nd Division | Wood | 30 | 9 | https://tools.wprdc.org/images/pittsburgh/steps/Carnegie_St.jpg | Upper Lawrenceville | 7 | 10 | 42003101100 | 2 | 10 | 2 | 3-5 | 40.48417956 | -79.94667349 | ||||||||
110 | 110 | 1162495077 | Carrie St from Sprain St to Carrie St | 1st Division | Concrete | 225 | 106 | 0 | 100 | 422 | 19 | 4 | 8 | 7 | https://tools.wprdc.org/images/pittsburgh/steps/Carrie_St_from_Sprain_St_to_Carrie_St.jpg | Fineview | 1 | 25 | 42003250900 | 1 | 25 | 1 | 1-10 | 40.46133817 | -80.00137539 | |
111 | 111 | 983831506 | Cedarhurst St from Arlington Ave to Ibis Way | 4th Division | 1953-01-01 | Concrete | 45 | 39 | 0 | 100 | 1278 | 777 | 10 | 4 | 8 | https://tools.wprdc.org/images/pittsburgh/steps/Cedarhurst_St_from_Arlington_Ave_to_Ibis_Way.jpg | Allentown | 3 | 18 | 42003180300 | 5 | 18 | 3 | 4-6 | 40.4185129 | -79.98858254 |
112 | 112 | 1248590957 | Cedarville Way from Juniper St to Lorigan St | 2nd Division | 1952-01-01 | Concrete | 33 | 20 | 0 | 100 | 1031 | 0 | 7 | 8 | 8 | https://tools.wprdc.org/images/pittsburgh/steps/Cedarville_Way_from_Juniper_St_to_Lorigan_St.jpg | Bloomfield | 7 | 8 | 42003080200 | 2 | 8 | 5 | 3-1 | 40.45840326 | -79.95147023 |
113 | 113 | 1153095685 | Cemetery Ave from Morris Ave | 1st Division | Wood | 12 | 7 | https://tools.wprdc.org/images/pittsburgh/steps/Cemetery_Ave_from_Morris_Ave.jpg | Fineview | 1 | 25 | 42003250900 | 1 | 25 | 1 | 1-10 | 40.46247954 | -80.00615773 | ||||||||
114 | 114 | 1240212642 | Centre Ave at Bigelow Blvd to Schenley Farms Terrace | 3rd Division | Stone | 85 | 49 | 0 | 100 | 325 | 76 | 2 | 1 | 2 | https://tools.wprdc.org/images/pittsburgh/steps/Centre_Ave_at_Bigelow_Blvd_to_Schenley_Farms_Terrace.jpg | Upper Hill | 6 | 5 | 42003050600 | 3 | 5 | 2 | 2-22 | 40.45095818 | -79.95507109 | |
115 | 115 | 715652331 | Chartiers Ave and Azalia St | 5th Division | Concrete | 122 | 14 | 1 | 10 | 782 | 184 | 10 | 10 | 10 | https://tools.wprdc.org/images/pittsburgh/steps/Chartiers_Ave_and_Azalia_St.jpg | Elliott | 2 | 20 | 42003562600 | 5 | 20 | 6 | 1-17 | 40.44508032 | -80.04156209 | |
116 | 116 | 824709829 | Chartiers Ave from Danley St to Praego St | 5th Division | Concrete | 50 | 18 | 0 | 100 | 102 | 22 | 4 | 10 | 3 | https://tools.wprdc.org/images/pittsburgh/steps/Chartiers_Ave_from_Danley_St_to_Praego_St.jpg | Crafton Heights | 2 | 20 | 42003562600 | 5 | 20 | 6 | 1-17 | 40.44909359 | -80.04467995 | |
117 | 117 | 698854103 | Chauncey St from Centre to Mahon St | 3rd Division | 1947-01-01 | Concrete | 272 | 60 | 1 | 3 | 545 | 155 | 6 | 5 | 9 | https://tools.wprdc.org/images/pittsburgh/steps/Chauncey_St_from_Centre__to_Mahon_St.jpg | Middle Hill | 6 | 5 | 42003050100 | 3 | 5 | 2 | 2-5 | 40.44640212 | -79.97258837 |
118 | 118 | 1375227318 | Chestnut St from Itin St to Vista St | 1st Division | 1984-01-01 | Concrete | 174 | 116 | 0 | 100 | 910 | 64 | 8 | 7 | 10 | https://tools.wprdc.org/images/pittsburgh/steps/Chestnut_St_from_Itin_St_to_Vista_St.jpg | East Allegheny | 1 | 23 | 42003563200 | 1 | 23 | 1 | 1-5 | 40.45838171 | -79.99567016 |
119 | 119 | 1346373462 | Clairhaven St from Arnold St to Norwalk St | 5th Division | 1945-01-01 | Concrete/Wood | 292 | 67 | 1 | 7 | 627 | 13 | 5 | 8 | 3 | https://tools.wprdc.org/images/pittsburgh/steps/Clairhaven_St_from_Arnold_St_to_Norwalk_St.jpg | Crafton Heights | 2 | 28 | 42003281500 | 5 | 28 | 6 | 1-18 | 40.44010406 | -80.05196507 |
120 | 120 | 395759308 | Clover St from Commanche Way to Eccles St | 4th Division | 1946-01-01 | Concrete | 102 | 1 | 10 | 1389 | 145 | 10 | 7 | 10 | https://tools.wprdc.org/images/pittsburgh/steps/Clover_St_from_Commanche_Way_to_Eccles_St.jpg | South Side Slopes | 3 | 16 | 42003160800 | 3 | 16 | 3 | 4-22 | 40.41821796 | -79.97122107 | |
121 | 121 | 338739954 | Clover St from Eccles St to Arlington Ave | 4th Division | 1946-01-01 | Concrete | 125 | 1 | 9 | 1467 | 154 | 10 | 5 | 10 | https://tools.wprdc.org/images/pittsburgh/steps/Clover_St_from_Eccles_St_to_Arlington_Ave.jpg | South Side Slopes | 3 | 16 | 42003160800 | 3 | 16 | 3 | 4-22 | 40.41784732 | -79.97130824 | |
122 | 122 | 2145741003 | Clover St from Elsie St to Charcot St | 4th Division | Concrete | 140 | 0 | https://tools.wprdc.org/images/pittsburgh/steps/Clover_St_from_Elsie_St_to_Charcot_St.jpg | Arlington | 3 | 16 | 42003561600 | 3 | 16 | 3 | 4-8 | 40.41662315 | -79.97155801 | ||||||||
123 | 123 | 1849415445 | Clover St from Spring St to Elsie St | 4th Division | Concrete | 135 | 0 | https://tools.wprdc.org/images/pittsburgh/steps/Clover_St_from_Spring_St_to_Elsie_St.jpg | Arlington | 3 | 16 | 42003561600 | 3 | 16 | 3 | 4-8 | 40.41619125 | -79.97163177 | ||||||||
124 | 124 | 358530708 | Clover St from Wellington Way to Cobden St | 4th Division | Wood | 120 | 42 | 1 | 8 | 1004 | 36 | 6 | 5 | 9 | https://tools.wprdc.org/images/pittsburgh/steps/Clover_St_from_Wellington_Way_to_Cobden_St.jpg | South Side Slopes | 3 | 16 | 42003160800 | 3 | 16 | 3 | 4-22 | 40.42021404 | -79.97092177 | |
125 | 125 | 1895849559 | Coast Ave from Broadway Ave to Methyl St. | 5th Division | 1945-01-01 | Concrete | 160 | 35 | https://tools.wprdc.org/images/pittsburgh/steps/Coast_Ave_from_Broadway_Ave_to_Methyl_St..jpg | Beechview | 4 | 19 | 42003191600 | 5 | 19 | 6 | 4-28 | 40.40871005 | -80.02521637 | |||||||
126 | 126 | 819842221 | Coast Ave from Dagmar Ave to Fallowfield Ave | 5th Division | 1952-01-01 | Concrete | 220 | 101 | 0 | 100 | 1398 | 1146 | 10 | 6 | 10 | https://tools.wprdc.org/images/pittsburgh/steps/Coast_Ave_from_Dagmar_Ave_to_Fallowfield_Ave.jpg | Beechview | 4 | 19 | 42003192000 | 5 | 19 | 6 | 4-28 | 40.40876203 | -80.02317558 |
127 | 127 | 428021060 | Coast Ave from Methyl St. to Rutherford Ave | 5th Division | 1945-01-01 | Concrete | 222 | 38 | https://tools.wprdc.org/images/pittsburgh/steps/Coast_Ave_from_Methyl_St._to_Rutherford_Ave.jpg | Beechview | 4 | 19 | 42003191600 | 5 | 19 | 6 | 4-28 | 40.40868452 | -80.02599554 | |||||||
128 | 128 | 698011969 | Coleman St from Alger St to Neeb St East | 3rd Division | Concrete | 312 | 68 | https://tools.wprdc.org/images/pittsburgh/steps/Coleman_St_from_Alger_St_to_Neeb_St_East.jpg | Greenfield | 5 | 15 | 42003151600 | 3 | 15 | 4 | 2-12 | 40.42693591 | -79.94213092 | ||||||||
129 | 129 | 1815435996 | Coleman St from Alger St to Neeb St West | 3rd Division | Concrete | 313 | 60 | https://tools.wprdc.org/images/pittsburgh/steps/Coleman_St_from_Alger_St_to_Neeb_St_West.jpg | Greenfield | 5 | 15 | 42003151600 | 3 | 15 | 4 | 2-12 | 40.42691345 | -79.94222212 | ||||||||
130 | 130 | 29614145 | Colmar St from Blessing to Bernhardt Way | 3rd Division | 1949-01-01 | Concrete | 375 | 120 | 0 | 100 | 333 | 12 | 2 | 3 | 3 | https://tools.wprdc.org/images/pittsburgh/steps/Colmar_St_from_Blessing_to_Bernhardt_Way.jpg | Upper Hill | 6 | 5 | 42003050600 | 3 | 5 | 2 | 2-24 | 40.45776382 | -79.95755427 |
131 | 131 | 1902457886 | Cologne St from Berg St to Cobden St East | 4th Division | 1949-01-01 | Concrete | 145 | 98 | 0 | 100 | 733 | 52 | 6 | 6 | 7 | https://tools.wprdc.org/images/pittsburgh/steps/Cologne_St_from_Berg_St_to_Cobden_St_East.jpg | South Side Slopes | 3 | 16 | 42003160800 | 3 | 16 | 3 | 4-22 | 40.41947982 | -79.96908168 |
132 | 132 | 1002130456 | Cologne St from Berg St to Cobden St West | 4th Division | 1949-01-01 | Concrete | 132 | 45 | https://tools.wprdc.org/images/pittsburgh/steps/Cologne_St_from_Berg_St_to_Cobden_St_West.jpg | South Side Slopes | 3 | 16 | 42003160800 | 3 | 16 | 3 | 4-22 | 40.4194941 | -79.96917963 | |||||||
133 | 133 | 951433808 | Cologne St from Patterson St to Berg St | 4th Division | 1949-01-01 | Concrete | 275 | 80 | 1 | 6 | 787 | 59 | 6 | 4 | 7 | https://tools.wprdc.org/images/pittsburgh/steps/Cologne_St_from_Patterson_St_to_Berg_St.jpg | South Side Slopes | 3 | 16 | 42003160800 | 3 | 16 | 3 | 4-22 | 40.41904109 | -79.96925498 |
134 | 134 | 1679883763 | Como St from St Joseph St to Ormsby St | 4th Division | 1953-01-01 | Concrete | 107 | 41 | 1 | 3 | 538 | 80 | 5 | 5 | 4 | https://tools.wprdc.org/images/pittsburgh/steps/Como_St_from_St_Joseph_St_to_Ormsby_St.jpg | Mt. Oliver | 3 | 16 | 42003561700 | 3 | 16 | 3 | 4-8 | 40.41328759 | -79.97924443 |
135 | 135 | 2011605507 | Complete St to Geyer Ave | 1st Division | Wood | 110 | 63 | 0 | 100 | 527 | 35 | 6 | 9 | 7 | https://tools.wprdc.org/images/pittsburgh/steps/Complete_St_to_Geyer_Ave.jpg | Marshall-Shadeland | 1 | 27 | 42003271500 | 1 | 27 | 1 | 1-14 | 40.47340721 | -80.03344658 | |
136 | 136 | 554399718 | Copperfield Ave from Dellrose St to Brownsville Rd | 4th Division | 1949-01-01 | Concrete | 122 | https://tools.wprdc.org/images/pittsburgh/steps/Copperfield_Ave_from_Dellrose_St_to_Brownsville_Rd.jpg | Carrick | 4 | 29 | 42003290100 | 3 | 29 | 3 | 4-12 | 40.39608073 | -79.98763289 | ||||||||
137 | 137 | 280549115 | Copperfield Ave from Dellrose St to Brownsville Rd North | 4th Division | 1949-01-01 | Concrete | 122 | https://tools.wprdc.org/images/pittsburgh/steps/Copperfield_Ave_from_Dellrose_St_to_Brownsville_Rd_North.jpg | Carrick | 4 | 29 | 42003290100 | 3 | 29 | 3 | 4-12 | 40.39617878 | -79.98771067 | ||||||||
138 | 138 | 1693036499 | Copperfield Ave from Mt Joseph St | 4th Division | 1949-01-01 | Concrete | 181 | https://tools.wprdc.org/images/pittsburgh/steps/Copperfield_Ave_from_Mt_Joseph_St.jpg | Carrick | 4 | 29 | 42003290100 | 3 | 29 | 3 | 4-23 | 40.39522283 | -79.99005458 | ||||||||
139 | 139 | 1522080906 | Copperfield Ave from Mt Joseph St to Oakhurst Way | 4th Division | 1949-01-01 | Concrete | 167 | 29 | https://tools.wprdc.org/images/pittsburgh/steps/Copperfield_Ave_from_Mt_Joseph_St_to_Oakhurst_Way.jpg | Carrick | 4 | 29 | 42003290100 | 3 | 29 | 3 | 4-23 | 40.3954765 | -79.989336 | |||||||
140 | 140 | 1507364933 | Copperfield Ave from Oakhurst St to Westmont St North | 4th Division | 1949-01-01 | Asphalt/Wood | 142 | 12 | https://tools.wprdc.org/images/pittsburgh/steps/Copperfield_Ave_from_Oakhurst_St_to_Westmont_St_North.jpg | Carrick | 4 | 29 | 42003290100 | 3 | 29 | 3 | 4-23 | 40.39582131 | -79.98881574 | |||||||
141 | 141 | 425252495 | Copperfield Ave from Oakhurst Way to Westmont Ave | 4th Division | 1949-01-01 | Concrete | 140 | https://tools.wprdc.org/images/pittsburgh/steps/Copperfield_Ave_from_Oakhurst_Way_to_Westmont_Ave.jpg | Carrick | 4 | 29 | 42003290100 | 3 | 29 | 3 | 4-23 | 40.39571335 | -79.98872402 | ||||||||
142 | 142 | 927539104 | Copperfield Ave from Westmont Ave to Dellrose St | 4th Division | 1949-01-01 | Concrete | 142 | https://tools.wprdc.org/images/pittsburgh/steps/Copperfield_Ave_from_Westmont_Ave_to_Dellrose_St.jpg | Carrick | 4 | 29 | 42003290100 | 3 | 29 | 3 | 4-23 | 40.39590097 | -79.98813715 | ||||||||
143 | 143 | 1928094888 | Copperfield Ave from Westmont St to Dellrose St North | 4th Division | 1949-01-01 | Concrete | 142 | https://tools.wprdc.org/images/pittsburgh/steps/Copperfield_Ave_from_Westmont_St_to_Dellrose_St_North.jpg | Carrick | 4 | 29 | 42003290100 | 3 | 29 | 3 | 4-23 | 40.39600413 | -79.9881975 | ||||||||
144 | 144 | 1349385582 | Courtright St to Wing Way | 1st Division | 1944-01-01 | Concrete | 86 | 4 | 0 | 100 | 803 | 351 | 7 | 2 | 6 | https://tools.wprdc.org/images/pittsburgh/steps/Courtright_St_to_Wing_Way.jpg | Marshall-Shadeland | 1 | 27 | 42003271500 | 1 | 27 | 1 | 1-14 | 40.47540389 | -80.03106161 |
145 | 145 | 815033386 | Cowan St from Southern Ave to Greenbush St | 5th Division | 1950-01-01 | Concrete | 300 | 43 | 1 | 10 | 1317 | 126 | 10 | 9 | 10 | https://tools.wprdc.org/images/pittsburgh/steps/Cowan_St_from_Southern_Ave_to_Greenbush_St.jpg | Mount Washington | 2 | 19 | 42003191400 | 5 | 19 | 3 | 4-27 | 40.42757196 | -80.00857748 |
146 | 146 | 827262460 | Crimson Ave from Traymore Ave to Sebring Ave | 5th Division | 1950-01-01 | Concrete | 226 | 51 | 0 | 100 | 146 | 25 | 3 | 9 | 2 | https://tools.wprdc.org/images/pittsburgh/steps/Crimson_Ave_from_Traymore_Ave_to_Sebring_Ave.jpg | Beechview | 4 | 19 | 42003191600 | 5 | 19 | 6 | 4-28 | 40.41204005 | -80.01303029 |
147 | 147 | 1081703269 | Croessus Way from East Busway to Flavian St | 3rd Division | Concrete | 150 | 54 | 0 | 100 | 462 | 14 | 2 | 1 | 2 | https://tools.wprdc.org/images/pittsburgh/steps/Croessus_Way_from_East_Busway_to_Flavian_St.jpg | Polish Hill | 7 | 6 | 42003060500 | 6 | 6 | 2 | 2-6 | 40.45961487 | -79.96176161 | |
148 | 148 | 1670748752 | Crosby Ave from Broadway Ave | 5th Division | Asphalt/Concrete | 21 | 19 | https://tools.wprdc.org/images/pittsburgh/steps/Crosby_Ave_from_Broadway_Ave.jpg | Beechview | 4 | 19 | 42003192000 | 5 | 19 | 6 | 4-28 | 40.40503556 | -80.03030434 | ||||||||
149 | 149 | 2022266670 | Cushman St to Number 37 | 5th Division | Wood | 25 | 21 | 0 | 100 | 1040 | 33 | 4 | 1 | 3 | https://tools.wprdc.org/images/pittsburgh/steps/Cushman_St_to_Number_37.jpg | Mount Washington | 3 | 18 | 42003180700 | 5 | 18 | 3 | 4-5 | 40.42648345 | -80.00427326 | |
150 | 150 | 767101869 | Cust St from Gate Lodge Way to Sunnyside St | 3rd Division | Concrete | 126 | 1 | 4 | 543 | 51 | 5 | 6 | 8 | https://tools.wprdc.org/images/pittsburgh/steps/Cust_St_from_Gate_Lodge_Way_to_Sunnyside_St.jpg | Hazelwood | 5 | 15 | 42003562300 | 3 | 15 | 4 | 2-13 | 40.40224197 | -79.94013625 | ||
151 | 151 | 425764357 | Cust St from Second Ave to Gate Lodge Way | 3rd Division | Concrete | 217 | 69 | 1 | 2 | 534 | 51 | 3 | 3 | 6 | https://tools.wprdc.org/images/pittsburgh/steps/Cust_St_from_Second_Ave_to_Gate_Lodge_Way.jpg | Hazelwood | 5 | 15 | 42003562300 | 3 | 15 | 4 | 2-13 | 40.40191822 | -79.94045142 | |
152 | 152 | 1025967250 | Cust St from Sunnyside St to Shrub Way | 3rd Division | 1948-01-01 | Concrete | 135 | 52 | 1 | 4 | 517 | 50 | 5 | 6 | 8 | https://tools.wprdc.org/images/pittsburgh/steps/Cust_St_from_Sunnyside_St_to_Shrub_Way.jpg | Hazelwood | 5 | 15 | 42003562300 | 3 | 15 | 4 | 2-13 | 40.40250175 | -79.93973177 |
153 | 153 | 2100303975 | Custer Ave from Brinwood Ave to Kirk Ave | 4th Division | 1964-01-01 | Concrete | 310 | 101 | 0 | 100 | 579 | 14 | 4 | 5 | 2 | https://tools.wprdc.org/images/pittsburgh/steps/Custer_Ave_from_Brinwood_Ave_to_Kirk_Ave.jpg | Carrick | 4 | 29 | 42003290400 | 3 | 29 | 3 | 4-15 | 40.39281334 | -79.97776538 |
154 | 154 | 437598672 | Custer Street from Kirk Ave to Spencer Ave | 4th Division | Concrete | 142 | 25 | https://tools.wprdc.org/images/pittsburgh/steps/Custer_Street_from_Kirk_Ave_to_Spencer_Ave.jpg | Carrick | 4 | 29 | 42003290400 | 3 | 29 | 3 | 4-15 | 40.39299298 | -79.97685445 | ||||||||
155 | 155 | 1600958546 | Cuthbert St form Gaskel St to Lauria Way | 5th Division | 1985-01-01 | Concrete | 102 | 30 | https://tools.wprdc.org/images/pittsburgh/steps/Cuthbert_St_form_Gaskel_St_to_Lauria_Way.jpg | Mount Washington | 2 | 19 | 42003191400 | 5 | 19 | 3 | 4-27 | 40.4297543 | -80.00894967 | |||||||
156 | 156 | 2142073153 | Cuthbert St from Natchez St to Gaskel St | 5th Division | 1985-01-01 | Concrete | 104 | 44 | https://tools.wprdc.org/images/pittsburgh/steps/Cuthbert_St_from_Natchez_St_to_Gaskel_St.jpg | Mount Washington | 2 | 19 | 42003191400 | 5 | 19 | 3 | 4-27 | 40.42944481 | -80.00922335 | |||||||
157 | 157 | 1399256346 | Cutler St from Wilson Ave to Perrysville Ave | 1st Division | Concrete | 317 | 106 | https://tools.wprdc.org/images/pittsburgh/steps/Cutler_St_from_Wilson_Ave_to_Perrysville_Ave.jpg | Perry South | 6 | 26 | 42003261400 | 1 | 26 | 1 | 1-12 | 40.46602449 | -80.01231783 | ||||||||
158 | 158 | 2084301892 | Dagmar Ave from Tonopah Ave to Alturia St | 5th Division | Wood | 42 | 44 | 0 | 100 | 1018 | 0 | 7 | 9 | 7 | https://tools.wprdc.org/images/pittsburgh/steps/Dagmar_Ave_from_Tonopah_Ave_to_Alturia_St.jpg | Beechview | 4 | 19 | 42003192000 | 5 | 19 | 6 | 4-28 | 40.40741351 | -80.02249895 | |
159 | 159 | 681152155 | Daisey St from Veteran St to Sherlock St | 1st Division | 1965-01-01 | Concrete | 99 | 26 | https://tools.wprdc.org/images/pittsburgh/steps/Daisey_St_from_Veteran_St_to_Sherlock_St.jpg | Perry South | 6 | 26 | 42003261500 | 1 | 26 | 1 | 1-23 | 40.47347531 | -80.0087413 | |||||||
160 | 160 | 1197024939 | Dale St from Noblestown Rd to Code Way | 5th Division | Wood | 105 | 43 | 1 | 9 | 762 | 61 | 8 | 8 | 4 | https://tools.wprdc.org/images/pittsburgh/steps/Dale_St_from_Noblestown_Rd_to_Code_Way.png | Westwood | 2 | 28 | 42003563100 | 5 | 28 | 6 | 1-18 | 40.43501564 | -80.05074559 | |
161 | 161 | 1944803063 | Dartmore St from Englert St | 4th Division | Concrete | 70 | 8 | https://tools.wprdc.org/images/pittsburgh/steps/Dartmore_St_from_Englert_St.jpg | Overbrook | 4 | 32 | 42003320400 | 5 | 32 | 3 | 4-23 | 40.38855777 | -79.99610315 | ||||||||
162 | 162 | 641016805 | De Witt St from Griffin St to Burson Way North | 5th Division | 1988-01-01 | Concrete | 80 | 13 | https://tools.wprdc.org/images/pittsburgh/steps/De_Witt_St_from_Griffin_St_to_Burson_Way_North.jpg | Mount Washington | 2 | 19 | 42003191400 | 5 | 19 | 3 | 4-27 | 40.42449595 | -80.00973191 | |||||||
163 | 163 | 1130610250 | Delger St from Nina Way to Loyal Way | 1st Division | Wood | 31 | 25 | 0 | 100 | 658 | 37 | 7 | 10 | 8 | https://tools.wprdc.org/images/pittsburgh/steps/Delger_St_from_Nina_Way_to_Loyal_Way.jpg | Perry South | 6 | 26 | 42003261500 | 1 | 26 | 1 | 1-23 | 40.47253437 | -80.0143875 | |
164 | 164 | 209043195 | Delmont Ave from Climax St to Loyal Way | 4th Division | 1948-01-01 | Concrete | 108 | 29 | https://tools.wprdc.org/images/pittsburgh/steps/Delmont_Ave_from_Climax_St_to_Loyal_Way.jpg | Beltzhoover | 3 | 18 | 42003562400 | 5 | 18 | 3 | 4-16 | 40.4192255 | -80.00420242 | |||||||
165 | 165 | 1254442177 | Delmont Ave from Industry St to Proxim Way | 4th Division | 1948-01-01 | Concrete | 113 | 23 | https://tools.wprdc.org/images/pittsburgh/steps/Delmont_Ave_from_Industry_St_to_Proxim_Way.jpg | Beltzhoover | 3 | 18 | 42003562400 | 5 | 18 | 3 | 4-16 | 40.41995041 | -80.00453635 | |||||||
166 | 166 | 906517361 | Delmont Ave from Nina Way to Industry St | 4th Division | 1948-01-01 | Concrete | 112 | 19 | https://tools.wprdc.org/images/pittsburgh/steps/Delmont_Ave_from_Nina_Way_to_Industry_St.jpg | Beltzhoover | 3 | 18 | 42003562400 | 5 | 18 | 3 | 4-16 | 40.42032618 | -80.00463784 | |||||||
167 | 167 | 362684587 | Delmont Ave from Proxim Way to Climax St | 4th Division | 1948-01-01 | Concrete | 106 | 39 | 0 | 100 | 513 | 255 | 8 | 6 | 8 | https://tools.wprdc.org/images/pittsburgh/steps/Delmont_Ave_from_Proxim_Way_to_Climax_St.jpg | Beltzhoover | 3 | 18 | 42003562400 | 5 | 18 | 3 | 4-16 | 40.41963186 | -80.00439152 |
168 | 168 | 1401475151 | Dengler St | 4th Division | Concrete | 196 | 14 | 0 | 100 | 576 | 191 | 5 | 1 | 2 | https://tools.wprdc.org/images/pittsburgh/steps/Dengler_St.jpg | Arlington | 3 | 16 | 42003561600 | 3 | 16 | 3 | 4-8 | 40.41663685 | -79.9677089 | |
169 | 169 | 1249762755 | Devon Rd and Warrick Terrace from 5th Ave | 3rd Division | Concrete | 245 | 98 | 0 | 100 | 1492 | 545 | 10 | 8 | 10 | https://tools.wprdc.org/images/pittsburgh/steps/Devon_Rd_and_Warrick_Terrace_from_5th_Ave.jpg | Squirrel Hill North | 8 | 14 | 42003140100 | 3 | 14 | 4 | 2-26 | 40.44718834 | -79.94020169 | |
170 | 170 | 843120491 | Dewitt St from Griffin St to Burson Way | 5th Division | 1988-01-01 | Concrete | 212 | 29 | https://tools.wprdc.org/images/pittsburgh/steps/Dewitt_St_from_Griffin_St_to_Burson_Way.jpg | Mount Washington | 2 | 19 | 42003191500 | 5 | 19 | 3 | 4-27 | 40.42443561 | -80.00977176 | |||||||
171 | 171 | 1311257894 | Dewitt St from Southern Ave to Griffin St | 5th Division | 1975-01-01 | Concrete | 125 | 33 | 0 | 100 | 1383 | 93 | 10 | 10 | 9 | https://tools.wprdc.org/images/pittsburgh/steps/Dewitt_St_from_Southern_Ave_to_Griffin_St.jpg | Mount Washington | 2 | 19 | 42003191500 | 5 | 19 | 3 | 4-27 | 40.42453338 | -80.01013067 |
172 | 172 | 1806789258 | Diana St from Homer St to Diana St | 1st Division | 1946-01-01 | Concrete | 133 | 108 | 0 | 100 | 533 | 65 | 7 | 10 | 9 | https://tools.wprdc.org/images/pittsburgh/steps/Diana_St_from_Homer_St_to_Diana_St.jpg | Spring Hill-City View | 1 | 24 | 42003262000 | 1 | 24 | 1 | 1-24 | 40.4623986 | -79.9891131 |
173 | 173 | 358347226 | Diana St from Ives Way to Itin St | 1st Division | Concrete | 30 | 14 | https://tools.wprdc.org/images/pittsburgh/steps/Diana_St_from_Ives_Way_to_Itin_St.jpg | Spring Hill-City View | 1 | 24 | 42003262000 | 1 | 24 | 1 | 1-24 | 40.4619471 | -79.99174738 | ||||||||
174 | 174 | 1886235238 | Dickson St from California Ave to Holbrook St | 1st Division | 1948-01-01 | Concrete | 113 | 17 | https://tools.wprdc.org/images/pittsburgh/steps/Dickson_St_from_California_Ave_to_Holbrook_St.jpg | Marshall-Shadeland | 1 | 27 | 42003271500 | 1 | 27 | 1 | 1-14 | 40.46879896 | -80.03525295 | |||||||
175 | 175 | 1120265257 | Dickson St from Holbrook St to Pitler St | 1st Division | 1948-01-01 | Concrete | 116 | 24 | https://tools.wprdc.org/images/pittsburgh/steps/Dickson_St_from_Holbrook_St_to_Pitler_St.jpg | Marshall-Shadeland | 1 | 27 | 42003271500 | 1 | 27 | 1 | 1-14 | 40.4689009 | -80.03475826 | |||||||
176 | 176 | 1658991702 | Dickson St from Pitler St to Plough St | 1st Division | 1948-01-01 | Concrete | 406 | 43 | 1 | 3 | 667 | 113 | 5 | 2 | 6 | https://tools.wprdc.org/images/pittsburgh/steps/Dickson_St_from_Pitler_St_to_Plough_St.jpg | Marshall-Shadeland | 1 | 27 | 42003271500 | 1 | 27 | 1 | 1-14 | 40.46906041 | -80.03398811 |
177 | 177 | 1790779487 | Diulus Way from Boundary St to Bouquet St | 3rd Division | 1949-01-01 | Concrete | 200 | 99 | 0 | 100 | 2026 | 0 | 7 | 8 | 9 | https://tools.wprdc.org/images/pittsburgh/steps/Diulus_Way_from_Boundary_St_to_Bouquet_St.jpg | Central Oakland | 3 | 4 | 42003040600 | 3 | 4 | 4 | 2-11 | 40.4391859 | -79.95107182 |
178 | 178 | 213537103 | Doak Way from Dalton Ave to Dornestic St | 1st Division | 1949-01-01 | Concrete | 108 | 0 | 100 | 267 | 0 | 3 | 8 | 2 | https://tools.wprdc.org/images/pittsburgh/steps/Doak_Way_from_Dalton_Ave_to_Dornestic_St.jpg | Perry North | 1 | 26 | 42003260200 | 1 | 26 | 1 | 1-15 | 40.49093964 | -80.02651845 | |
179 | 179 | 2087378860 | Doak Way from Oakdale St to Dalton Ave | 1st Division | 1949-01-01 | Concrete | 225 | 0 | 100 | 253 | 0 | 2 | 6 | 1 | https://tools.wprdc.org/images/pittsburgh/steps/Doak_Way_from_Oakdale_St_to_Dalton_Ave.jpg | Perry North | 1 | 26 | 42003260200 | 1 | 26 | 1 | 1-15 | 40.49071492 | -80.02712721 | |
180 | 180 | 1323791787 | Dornbush St from Bricelyn St to Fahnestock St | 2nd Division | 1950-01-01 | Concrete | 410 | 143 | 1 | 2 | 603 | 30 | 2 | 1 | 5 | https://tools.wprdc.org/images/pittsburgh/steps/Dornbush_St_from_Bricelyn_St_to_Fahnestock_St.jpg | East Hills | 9 | 13 | 42003130600 | 2 | 13 | 5 | 3-17 | 40.45424248 | -79.87874779 |
181 | 181 | 41754884 | Dornbush St from Fahnestock St to Calistoga St | 2nd Division | 1950-01-01 | Concrete | 524 | 133 | 1 | 2 | 587 | 7 | 2 | 1 | 4 | https://tools.wprdc.org/images/pittsburgh/steps/Dornbush_St_from_Fahnestock_St_to_Calistoga_St.jpg | East Hills | 9 | 13 | 42003130600 | 2 | 13 | 5 | 3-17 | 40.45323585 | -79.87748826 |
182 | 182 | 1385526213 | Downing St from Herron Ave to Hancock St | 3rd Division | 1948-01-01 | Concrete | 129 | 81 | 0 | 100 | 666 | 231 | 7 | 4 | 7 | https://tools.wprdc.org/images/pittsburgh/steps/Downing_St_from_Herron_Ave_to_Hancock_St.jpg | Polish Hill | 7 | 6 | 42003060500 | 6 | 6 | 2 | 2-6 | 40.4588109 | -79.96604891 |
183 | 183 | 351683365 | Dressing Way from Marietta St to Premo St | 2nd Division | 1950-01-01 | Concrete | 154 | 90 | 0 | 100 | 115 | 9 | 2 | 4 | 1 | https://tools.wprdc.org/images/pittsburgh/steps/Dressing_Way_from_Marietta_St_to_Premo_St.jpg | Stanton Heights | 7 | 10 | 42003101800 | 2 | 10 | 5 | 3-7 | 40.48861306 | -79.92861167 |
184 | 184 | 2086315948 | Dubois St from India St to Dickens St | 5th Division | Concrete | 275 | 12 | https://tools.wprdc.org/images/pittsburgh/steps/Dubois_St_from_India_St_to_Dickens_St.jpg | Crafton Heights | 2 | 20 | 42003281400 | 5 | 20 | 6 | 1-16 | 40.44997085 | -80.05103964 | ||||||||
185 | 185 | 569524168 | Duffield St from Morningside Ave to Duffield | 2nd Division | Concrete | 2 | 2 | https://tools.wprdc.org/images/pittsburgh/steps/Duffield_St_from_Morningside_Ave_to_Duffield.jpg | Morningside | 7 | 10 | 42003101400 | 2 | 10 | 5 | 3-7 | 40.47679281 | -79.93170349 | ||||||||
186 | 186 | 1852100834 | Duncan St from Leydon St to Kendall St | 2nd Division | 1951-01-01 | Wood | 101 | 43 | 1 | 9 | 907 | 0 | 6 | 7 | 6 | https://tools.wprdc.org/images/pittsburgh/steps/Duncan_St_from_Leydon_St_to_Kendall_St.jpg | Upper Lawrenceville | 7 | 10 | 42003101100 | 2 | 10 | 2 | 3-5 | 40.48122385 | -79.94811507 |
187 | 187 | 1937783333 | E Cherryhill St from Amanda to Brownsville Rd | 4th Division | 1949-01-01 | Concrete | 201 | 60 | https://tools.wprdc.org/images/pittsburgh/steps/E__Cherryhill_St_from_Amanda_to_Brownsville_Rd.jpg | Carrick | 4 | 29 | 42003290200 | 3 | 29 | 3 | 4-12 | 40.398565 | -79.98819904 | |||||||
188 | 188 | 1533046429 | E Cherryhill St from Concordia St to Amanda St | 4th Division | 1949-01-01 | Concrete | 169 | 31 | 2 | 7 | 1271 | 233 | 9 | 2 | 8 | https://tools.wprdc.org/images/pittsburgh/steps/E__Cherryhill_St_from_Concordia_St_to_Amanda_St.jpg | Carrick | 4 | 29 | 42003290200 | 3 | 29 | 3 | 4-12 | 40.3986774 | -79.98745867 |
189 | 189 | 1475103503 | E Woodford Ave from Fromm Way to Hazeldell St | 4th Division | Concrete | 151 | 61 | https://tools.wprdc.org/images/pittsburgh/steps/E__Woodford_Ave_from_Fromm_Way_to_Hazeldell_St.jpg | Carrick | 4 | 29 | 42003290200 | 3 | 29 | 3 | 4-12 | 40.39327998 | -79.98485308 | ||||||||
190 | 190 | 149457826 | E Burgess St from Maple Ave to Osgood St | 1st Division | Concrete | 210 | 35 | https://tools.wprdc.org/images/pittsburgh/steps/E_Burgess_St_from_Maple_Ave_to_Osgood_St.jpg | Perry South | 6 | 26 | 42003261400 | 1 | 26 | 1 | 1-22 | 40.46784227 | -80.0082497 | ||||||||
191 | 191 | 1674986827 | E Burgess St from Perrysville Ave to Maple Ave | 1st Division | Concrete | 288 | 47 | https://tools.wprdc.org/images/pittsburgh/steps/E_Burgess_St_from_Perrysville_Ave_to_Maple_Ave.jpg | Perry South | 6 | 26 | 42003261400 | 1 | 26 | 1 | 1-22 | 40.4676525 | -80.0092609 | ||||||||
192 | 192 | 568253734 | E Jefferson St at Arch St to Perrysville Ave | 1st Division | 1948-01-01 | Concrete | 257 | 131 | 0 | 100 | 853 | 86 | 9 | 7 | 8 | https://tools.wprdc.org/images/pittsburgh/steps/E_Jefferson_St_at_Arch_St_to_Perrysville_Ave.jpg | Central Northside | 6 | 25 | 42003250300 | 1 | 25 | 1 | 1-10 | 40.45968397 | -80.01003539 |
193 | 193 | 2119023507 | E Sycamore St at Wyoming St | 5th Division | Concrete | 7 | 5 | https://tools.wprdc.org/images/pittsburgh/steps/E_Sycamore_St_at_Wyoming_St.jpg | Mount Washington | 2 | 19 | 42003191400 | 5 | 19 | 3 | 4-27 | 40.43017773 | -80.00636614 | ||||||||
194 | 194 | 1427214027 | E Warrington Ave from St Thomas St to Mt Oliver St | 4th Division | 193 | 34 | https://tools.wprdc.org/images/pittsburgh/steps/E_Warrington_Ave_from_St_Thomas_St_to_Mt_Oliver_St.jpg | South Side Slopes | 3 | 17 | 42003170600 | 3 | 17 | 3 | 4-6 | 40.42211037 | -79.98602637 | |||||||||
195 | 195 | 1847198619 | Eckert St from Mullins St to Hartman St | 1st Division | Wood | 572 | 32 | 1 | 4 | 960 | 78 | 6 | 1 | 5 | https://tools.wprdc.org/images/pittsburgh/steps/Eckert_St_from_Mullins_St_to_Hartman_St.jpg | Marshall-Shadeland | 1 | 27 | 42003271500 | 1 | 27 | 1 | 1-14 | 40.47131658 | -80.0321199 | |
196 | 196 | 63558540 | Eddington St from Kilbourne St to Kinglake St | 3rd Division | 1949-01-01 | Concrete | 289 | 170 | 0 | 100 | 132 | 0 | 2 | 7 | 3 | https://tools.wprdc.org/images/pittsburgh/steps/Eddington_St_from_Kilbourne_St_to_Kinglake_St.jpg | Hazelwood | 5 | 15 | 42003562300 | 3 | 15 | 4 | 2-13 | 40.41221408 | -79.93488248 |
197 | 197 | 1190678091 | Edgebrook Ave from Bellaire Ave to Fitch Way | 4th Division | Concrete | 124 | 13 | https://tools.wprdc.org/images/pittsburgh/steps/Edgebrook_Ave_from_Bellaire_Ave_to_Fitch_Way.jpg | Brookline | 4 | 19 | 42003320600 | 5 | 19 | 6 | 4-26 | 40.39263402 | -80.01507077 | ||||||||
198 | 198 | 1577463443 | Edgebrook Ave from Fitch Way to Brookline Blvd | 4th Division | Concrete | 105 | 12 | https://tools.wprdc.org/images/pittsburgh/steps/Edgebrook_Ave_from_Fitch_Way_to_Brookline_Blvd.jpg | Brookline | 4 | 19 | 42003320600 | 5 | 19 | 6 | 4-26 | 40.39228253 | -80.01515431 | ||||||||
199 | 199 | 796337141 | Edgerton Ave from Hastings St to S. Linden Ave | 2nd Division | Concrete | 138 | 27 | 0 | 100 | 1150 | 59 | 8 | 5 | 5 | https://tools.wprdc.org/images/pittsburgh/steps/Edgerton_Ave_from_Hastings_St_to_S._Linden_Ave.jpg | Point Breeze | 8 | 14 | 42003140400 | 3 | 14 | 4 | 2-17 | 40.4492383 | -79.91436681 | |
200 | 200 | 1780662846 | Elbon Way from Harker St to Wymore St | 5th Division | 1947-01-01 | Concrete | 188 | 128 | 1 | 6 | 640 | 80 | 6 | 6 | 9 | https://tools.wprdc.org/images/pittsburgh/steps/Elbon_Way_from_Harker_St_to_Wymore_St.jpg | Elliott | 2 | 20 | 42003562600 | 5 | 20 | 6 | 1-17 | 40.4408742 | -80.0419438 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "steps" ( "id" INTEGER, "name" TEXT, "maintenance_responsibility" TEXT, "installed" TEXT, "material" TEXT, "length" INTEGER, "number_of_steps" INTEGER, "schools_count" INTEGER, "school_score" INTEGER, "total_population" INTEGER, "transit_rider_count" INTEGER, "transit_score" INTEGER, "detour_score" INTEGER, "overall_score" INTEGER, "image" TEXT, "neighborhood" TEXT, "council_district" INTEGER, "ward" INTEGER, "tract" INTEGER, "public_works_division" INTEGER, "pli_division" INTEGER, "police_zone" INTEGER, "fire_zone" TEXT, "latitude" REAL, "longitude" REAL );