1  Mapping + Counts

1.1 Introduction

Note: counts filtered to only include counts conducted between 2018-2022. We have all historical counts for permanent counters and 2017-2023 SDC stored in our database.

1.2 Count Locations

Figure 1.1 displays where we have permanent (magenta) and short duration counts (yellow) available for this effort.

Figure 1.1: Permanant and Short Duration Count Locations

Permanent Counters

Table 1.1: Perm Summary/Overview (only includes 2018-2022 counts).
name install_date uninstall_date obs_duration modes
2nd Ave PBL 4/23/16 4 years 11 mons 30 days 23:00:00 Bike
39th Ave NE Greenway 1/1/14 5/31/18 0 years 4 mons 29 days 23:00:00 Bike
BGT 1/1/14 4 years 11 mons 30 days 23:00:00 Bike and Ped
Broadway PBL 1/1/14 10/30/21 3 years 9 mons 29 days 23:00:00 Bike
Chief Sealth 1/1/14 10/30/21 1 year 4 mons 29 days 23:00:00 Bike
Elliot Bay 5/11/13 12/11/22 4 years 11 mons 10 days 23:00:00 Bike and Ped
Fremont Bridge 10/8/12 4 years 11 mons 30 days 23:00:00 Bike
MTS or I-90 Trail 12/18/13 12/31/21 3 years 11 mons 30 days 23:00:00 Bike and Ped
NW 58th St 1/1/14 7/31/22 4 years 6 mons 30 days 23:00:00 Bike
Spokane Bridge 11/24/13 4 years 11 mons 30 days 23:00:00 Bike

Consectuive Zeros

Table 1.2: QC: Consectuive Zeros (only includes 2018-2022 counts).
station_id year n_zero_flags n_records pct_flagged
2nd_nb 2018 0 8,760 0.00%
2nd_nb 2019 0 8,760 0.00%
2nd_nb 2020 0 8,784 0.00%
2nd_nb 2021 0 8,736 0.00%
2nd_nb 2022 12 8,760 0.14%
2nd_sb 2018 0 8,760 0.00%
2nd_sb 2019 0 8,760 0.00%
2nd_sb 2020 0 8,784 0.00%
2nd_sb 2021 0 8,736 0.00%
2nd_sb 2022 12 8,760 0.14%
39_nb 2018 18 3,600 0.50%
39_sb 2018 18 3,600 0.50%
58_eb 2018 0 8,760 0.00%
58_eb 2019 293 8,088 3.62%
58_eb 2020 327 8,040 4.07%
58_eb 2021 0 8,726 0.00%
58_eb 2022 0 5,088 0.00%
58_wb 2018 0 8,760 0.00%
58_wb 2019 271 8,088 3.35%
58_wb 2020 364 8,040 4.53%
58_wb 2021 0 8,726 0.00%
58_wb 2022 0 5,088 0.00%
90_b_eb 2018 231 8,760 2.64%
90_b_eb 2019 308 8,760 3.52%
90_b_eb 2020 170 8,784 1.94%
90_b_eb 2021 862 8,760 9.84%
90_b_wb 2018 231 8,760 2.64%
90_b_wb 2019 338 8,760 3.86%
90_b_wb 2020 170 8,784 1.94%
90_b_wb 2021 1,794 8,760 20.48%
90_p_eb 2018 231 8,760 2.64%
90_p_eb 2019 3,370 8,760 38.47%
90_p_eb 2020 7,404 8,784 84.29%
90_p_eb 2021 8,760 8,760 100.00%
90_p_wb 2018 231 8,760 2.64%
90_p_wb 2019 3,370 8,760 38.47%
90_p_wb 2020 7,404 8,784 84.29%
90_p_wb 2021 8,760 8,760 100.00%
bgt_b_nb 2018 2,390 8,760 27.28%
bgt_b_nb 2019 0 8,760 0.00%
bgt_b_nb 2020 0 7,008 0.00%
bgt_b_nb 2021 0 1,464 0.00%
bgt_b_nb 2022 0 8,760 0.00%
bgt_b_sb 2018 2,378 8,760 27.15%
bgt_b_sb 2019 0 8,760 0.00%
bgt_b_sb 2020 0 7,008 0.00%
bgt_b_sb 2021 0 1,464 0.00%
bgt_b_sb 2022 0 8,760 0.00%
bgt_p_nb 2018 2,488 8,760 28.40%
bgt_p_nb 2019 0 8,760 0.00%
bgt_p_nb 2020 363 7,008 5.18%
bgt_p_nb 2021 1,464 1,464 100.00%
bgt_p_nb 2022 8,760 8,760 100.00%
bgt_p_sb 2018 2,486 8,760 28.38%
bgt_p_sb 2019 0 8,760 0.00%
bgt_p_sb 2020 0 7,008 0.00%
bgt_p_sb 2021 1,464 1,464 100.00%
bgt_p_sb 2022 8,760 8,760 100.00%
brd_nb 2018 112 8,760 1.28%
brd_nb 2019 0 7,344 0.00%
brd_nb 2020 629 5,112 12.30%
brd_nb 2021 1,093 7,272 15.03%
brd_sb 2018 216 8,760 2.47%
brd_sb 2019 0 7,344 0.00%
brd_sb 2020 727 5,112 14.22%
brd_sb 2021 1,155 7,272 15.88%
cs_b_nb 2020 257 5,136 5.00%
cs_b_nb 2021 2,444 7,262 33.65%
cs_b_sb 2020 250 5,136 4.87%
cs_b_sb 2021 2,225 7,262 30.64%
cs_p_nb 2020 5,136 5,136 100.00%
cs_p_nb 2021 7,262 7,262 100.00%
cs_p_sb 2020 5,136 5,136 100.00%
cs_p_sb 2021 7,262 7,262 100.00%
eb_b_nb 2018 0 8,760 0.00%
eb_b_nb 2019 0 8,760 0.00%
eb_b_nb 2020 0 8,784 0.00%
eb_b_nb 2021 1,166 8,760 13.31%
eb_b_nb 2022 315 8,280 3.80%
eb_b_sb 2018 0 8,760 0.00%
eb_b_sb 2019 0 8,760 0.00%
eb_b_sb 2020 0 8,784 0.00%
eb_b_sb 2021 1,166 8,760 13.31%
eb_b_sb 2022 315 8,280 3.80%
eb_p_nb 2018 0 8,760 0.00%
eb_p_nb 2019 0 8,760 0.00%
eb_p_nb 2020 0 8,784 0.00%
eb_p_nb 2021 1,166 8,760 13.31%
eb_p_nb 2022 315 8,280 3.80%
eb_p_sb 2018 0 8,760 0.00%
eb_p_sb 2019 0 8,760 0.00%
eb_p_sb 2020 0 8,784 0.00%
eb_p_sb 2021 1,166 8,760 13.31%
eb_p_sb 2022 315 8,280 3.80%
fmt_e 2018 0 8,760 0.00%
fmt_e 2019 0 8,760 0.00%
fmt_e 2020 0 8,784 0.00%
fmt_e 2021 0 8,760 0.00%
fmt_e 2022 0 8,760 0.00%
fmt_w 2018 0 8,760 0.00%
fmt_w 2019 0 8,760 0.00%
fmt_w 2020 0 8,784 0.00%
fmt_w 2021 0 8,760 0.00%
fmt_w 2022 0 8,760 0.00%
sb_eb 2018 0 8,760 0.00%
sb_eb 2019 0 8,760 0.00%
sb_eb 2020 0 8,784 0.00%
sb_eb 2021 706 8,736 8.08%
sb_eb 2022 656 10,248 6.40%
sp_wb 2018 0 8,760 0.00%
sp_wb 2019 0 8,760 0.00%
sp_wb 2020 0 8,784 0.00%
sp_wb 2021 792 8,736 9.07%
sp_wb 2022 634 10,248 6.19%

Short Duration Counts

Table 1.3: SDC Summary/Overview.
dow study_time_cat n_sites n_hours n_bike n_ped bike_per_hr ped_per_hr
Weekday 10:00 AM-12:00 PM 50 1786 17,949.0 338,965.0 10.0 189.8
Weekday 12:00 PM-2:00 PM 5 24 466.0 11,662.0 19.4 485.9
Weekday 5:00 PM-7:00 PM 49 1756 62,270.0 608,536.0 35.5 346.5
Weekend 10:00 AM-12:00 PM 4 8 84.0 1,392.0 10.5 174.0
Weekend 12:00 PM-2:00 PM 50 1770 34,339.0 559,484.0 19.4 316.1
Table 1.4: SDC Locations.
site_descr n_hours n_bike n_ped bike_per_hr ped_per_hr start_year end_year
12TH AVE AND E MADISON ST 108 3,698.0 60,076.0 34.2 556.3 2018 2022
12TH AVE NE AND NE 65TH ST 108 1,793.0 31,122.0 16.6 288.2 2018 2022
12TH AVE S AND S JACKSON ST 108 3,505.0 49,372.0 32.5 457.1 2018 2022
15TH AVE NW AND NW MARKET ST 108 253.0 44,306.0 2.3 410.2 2018 2022
15TH AVE W AND BALLARD BR 108 249.0 4,046.0 2.3 37.5 2018 2022
1ST AVE S AND S JACKSON ST 108 2,347.0 39,967.0 21.7 370.1 2018 2022
1ST AVE S AND S LANDER ST 108 617.0 10,721.0 5.7 99.3 2018 2022
23RD AVE AND E UNION ST 108 1,661.0 22,367.0 15.4 207.1 2018 2022
24TH AVE NW AND NW MARKET ST 108 2,478.0 37,370.0 22.9 346.0 2018 2022
26TH AVE SW AND SW BARTON ST 108 226.0 8,234.0 2.1 76.2 2018 2022
32ND AVE NW AND NW 54TH ST 108 920.0 15,112.0 8.5 139.9 2018 2022
32ND AVE W AND W MCGRAW ST 106 487.0 22,148.0 4.6 208.9 2018 2022
35TH AVE SW AND SW AVALON WAY 108 2,029.0 12,141.0 18.8 112.4 2018 2022
5TH AVE AND STEWART ST 108 1,552.0 82,176.0 14.4 760.9 2018 2022
5TH AVE NE AND NE NORTHGATE WAY 108 228.0 27,124.0 2.1 251.1 2018 2022
6TH AVE AND MADISON ST 108 488.0 23,366.0 4.5 216.4 2018 2022
7TH AVE S AND S JACKSON ST 108 2,502.0 25,280.0 23.2 234.1 2018 2022
8TH AVE S AND S CLOVERDALE ST 108 617.0 3,700.0 5.7 34.3 2018 2022
8TH AVE S AND S DEARBORN ST 108 1,477.0 5,318.0 13.7 49.2 2018 2022
9TH AVE N AND MERCER SR ST 104 5,431.0 20,670.0 52.2 198.8 2018 2022
AIRPORT WAY S AND S VALE ST 108 527.0 7,555.0 4.9 70.0 2018 2022
ALASKAN WAY AND BROAD ST 108 5,776.0 32,154.0 53.5 297.7 2018 2022
ALASKAN WAY AND COLUMBIA ST 102 3,061.0 25,817.0 30.0 253.1 2018 2022
BEACON AVE S AND S LANDER ST 108 1,150.0 22,634.0 10.6 209.6 2018 2022
BOREN AVE AND PINE ST 108 3,914.0 43,796.0 36.2 405.5 2018 2022
BOSTON ST AND QUEEN ANNE AVE N 104 686.0 47,237.0 6.6 454.2 2018 2022
BROAD ST AND VALLEY ST 106 2,332.0 31,691.0 22.0 299.0 2018 2022
BROADWAY AND E PINE ST 108 5,108.0 102,787.0 47.3 951.7 2018 2022
BROADWAY E AND E OLIVE WAY 106 2,408.0 134,418.0 22.7 1,268.1 2018 2022
BROOKLYN AVE NE AND NE 45TH ST 108 1,133.0 53,149.0 10.5 492.1 2018 2022
CALIFORNIA AVE SW AND FAUNTLEROY WAY SW 108 950.0 14,614.0 8.8 135.3 2018 2022
CALIFORNIA AVE SW AND SW ALASKA ST 108 802.0 54,691.0 7.4 506.4 2018 2022
DENNY WAY AND DEXTER AVE 108 5,286.0 50,152.0 48.9 464.4 2018 2022
EAST GREEN LAKE DR N AND NE RAVENNA EB BV 108 4,609.0 46,378.0 42.7 429.4 2018 2022
EAST MARGINAL WAY S AND S HANFORD ST 108 5,813.0 958.0 53.8 8.9 2018 2022
EASTLAKE AVE E AND FUHRMAN AVE E 108 9,226.0 13,178.0 85.4 122.0 2018 2022
FAIRVIEW AVE N AND MERCER ST 72 344.0 9,102.0 4.8 126.4 2018 2022
FAIRVIEW AVE N AND VALLEY ST 108 2,086.0 12,224.0 19.3 113.2 2018 2022
FAUNTLEROY WAY SW AND SW CLOVERDALE ST 106 984.0 5,070.0 9.3 47.8 2018 2022
FREMONT AVE N AND N 34TH ST 108 15,517.0 47,402.0 143.7 438.9 2018 2022
GREENWOOD AVE N AND N 85TH ST 108 1,026.0 25,046.0 9.5 231.9 2018 2022
LAKE CITY WAY NE AND NE 125TH ST 108 379.0 21,253.0 3.5 196.8 2018 2022
LINDEN AVE N AND N 130TH ST 110 2,881.0 6,885.0 26.2 62.6 2018 2022
M L KING JR WAY S AND RAINIER AVE S 108 197.0 8,066.0 1.8 74.7 2018 2022
M L KING JR WR WAY S AND S ALASKA ST 108 399.0 13,837.0 3.7 128.1 2018 2022
M L KING JR WR WAY S AND S OTHELLO ST 108 289.0 29,229.0 2.7 270.6 2018 2022
MONTLAKE BLVD NE AND NE PACIFIC ST 108 467.0 74,707.0 4.3 691.7 2018 2022
RAINIER AVE S AND S HENDERSON ST 108 352.0 11,694.0 3.3 108.3 2018 2022
SAND POINT WAY NE AND NE 65TH ST 108 903.0 6,909.0 8.4 64.0 2018 2022
STONE WAY N AND N 45TH ST 108 3,945.0 22,790.0 36.5 211.0 2018 2022