Comparing e-scooter and bike share usage in Minneapolis, MN using PostgreSQL

Introduction

Micromobility has become increasingly popular worldwide in recent years (Galatoulas et al. 2020, Oeschger et al. 2020). Its ability to solve the first and last mile transportation holds promise for an integrated transport system with multiple economic, social, and environmental benefits (APTA 2021, Oeschger et al 2020). Micromobility can be defined as “the use of micro-vehicles: vehicles with a mass of no more than 350 kg(771 lbs) and a design speed no higher than 45 km/h (ITF 2020). Examples of micro-vehicles are bikes and electric scooters.

In Minneapolis Minnesota bike-sharing and e-scooters have gained popularity. In 2018, Minneapolis launched a scooter share pilot with 2500 scooters available for use and has continued this program since. Scooters utilize the same rules as for bikes; scooters must be operated in bike lanes or with traffic and parked and locked at racks or nearby signposts (City of Minneapolis 2020). Unlike bikes, scooters are electrically powered and must be recharged. However, both micro-vehicles require infrastructure like bike lanes for routes and their cost for usage is similar.

This study aims to compare the usage of bike and e-scooters. Specifically, are bike sharing and scooter sharing complimentary or competing with one another based on their usage and travel patterns. Furthermore, because micromobility increases accessibility, this study will also examine the demographics (race and median income) of where trips are occurring to infer who may be using the micro-vehicles most and compare end trips to existing bus transit stops.

Results

Nice ride and e-scooter usage

The nice ride and e-scooter usage was compared initially by computing multiple statistics and summarizing metrics. The dataset for the Nice Ride bike share dataset for 2018 ranged from April 2018 to November 2018. There was a total of 824,846 trips with an average trip time of 3825 seconds. This averages about 117,835 trips per month. The month with the most bike share trips was July, and the least was November. The date with the most trip was in July. In comparison, the e-scooter dataset for 2018 ranged from July 2018 to December 2018. There was a total of 225,543 trips with an average trip time of 1127 seconds and average trip distance of 2157 meters. The month with the most e-scooter trip activity was October and the least was December. The date with the most trips was in October.

In terms of usage during weekdays, the most nice-ride trips occurred on Saturdays and these trips also had the longest average trip duration. The weekday with the least number of trips overall was Tuesday (fig 1). In comparison, most nice ride trips occurred on Thursdays and the longest trip durations were on Sundays. The day with the least number of e-scooter trips was Sunday (fig 2).

Examining all trips on an hourly level for each weekday, the activity percentage trend for each weekday is similar. Each weekday had a peak hour and showed more activity in the morning. The peak activity for each weekday is between 8:00-8:59 AM for both micro-vehicles and the peaks are similar throughout the weekdays (fig 1). Throughout the day, the activity decreased after the peak with lower hourly activity after 4 pm.

E-scooter and bikeshare trips were similar in their start and ending locations. The areas with the most starting and trips for both micro-vehicles appear to be downtown Minneapolis and the University of Minnesota campus (fig 2, 3). Also, locations for ending trips of both micro-vehicles compared to the starting trip locations appear to be dispersed throughout the City – shown through the increase of points and road centerlines with trip counts (fig 2, 3). ­

Proximity to Transit Stops

The percentage of trips within a 0.25 buffer of a transit stop for e-scooters was 100% and 93.85 for the nice-ride bikes.

Demographics

Median household income and percent non-white were observed for each census tract in Minneapolis. The tracts with the highest median household income appear to be in the south west of the city boundary and the lowest median household income tracts are in downtown and north of downtown Minneapolis. For percent non-white, the areas with higher non-white populations were in tracts of downtown and north of downtown Minneapolis, while the tracts with a lower non-white population were in the southern region and north east corner of Minneapolis (fig 4).


­Discussion

The usage counts for the nice ride bikes and the e-scooters are different. Nice ride bikes have a higher count and a larger average trip duration. The usage activity in terms of total counts for each weekday for scooters have the most on usage on Thursdays and for nice ride bikes it is Saturday. When examining the activity on an hourly level for each weekday, both micro-vehicles have a similar trend throughout each weekday. The start and end locations are similar for both as they have highest trip counts for start and end locations in the downtown Minneapolis area and the University of Minnesota Minneapolis campus (fig 2, 3). The demographics of the tracts where the most trips start and end for each micro-vehicle correspond with low median household income rates and high non-white population (fig 4).

The usage of both micro-vehicles does not appear to compete with one another. The differences in trips counts could be attributed to the number of bodies for each vehicle. The nice ride bikes share program launched much earlier than the scooter and may have more availability in general. Furthermore, there is already infrastructure such as docks for bikes which can hold more than 5 bikes while scooters are dockless, and they are typically found at corners of blocks. Additionally, when the activities are examined on an hourly level for each weekday, the pattern of activity is very similar. When there is a peak in usage for the nice ride bikes, there is a similar increase in the e-scooter usage (fig 1). This suggests that folks are not favoring one micro-vehicle over another. Instead, they are both being used similarly in the same locations.

The start and end locations of the bikes and e-scooters are very similar. It suggests users are traveling from and within the downtown and University of Minneapolis campus mostly. With typical city traffic and presence of students in these areas, the micro-vehicles are a great alternative to the typical city bus and helps users decrease on wait times for traveling. One observation about the ending locations for the nice rides bikes is the ending points may be outside of the Minneapolis boundary, suggesting that users are traveling further than users using the e scooters. This is also indicated by the average trip duration time. Most trips started and ended within 0.25 miles Euclidean distance of a transit stop. There are many transits stops in Minneapolis especially in the areas where the most e-scooter and bike share trips occurred. One way to improve the observation of users to transit stops is using a network instead of a Euclidean distance to determine the 0.25 buffer. However, because of the density of transit stops, it showed that most or all trips occurred within the buffer.

The people living in the areas where the most trips are starting and ending had lower median household income and a higher non-white population (fig 4). This implies that micromobility is helping folks of lower household income and of color to travel around the city. Of course, the areas where trips are occurring also coincides with high population density like the downtown area of Minneapolis and the UMN college campus. Overall micromobility has many benefits. The usage of the two micro-vehicles is similar and have similar starting and ending locations. The folks living in the tracts where the trips start, and end imply that there are some social benefits in helping folks with lower income and of color travel throughout the city. Further studies can incorporate a smaller scale like block groups, network analysis, and collected demographics of the micro-vehicle users to observe the effectiveness of micromobility in Minneapolis, MN.

References

American Public Transportation Association (APTA). (2021). “First Last/Mile Solutions.” American Public Transportation Association. <www.apta.com/research-technical-resources/mobility-innovation-hub/first-last-mile-solutions/#:%7E:text=Transit%20agencies%20are%20collaborating%20with,as%20the%20first%2Flast%20mile>

City of Minneapolis. (2020) Motorized foot scooters. City of Minneapolis. http://www2.minneapolismn.gov/publicworks/trans/WCMSP-212816

Galatoulas, N., Genikomsakis, K.N., and Loakimidis, C.S. Spatio-temporal trends of e-bike sharing system deployment: a review in Europe, North America and Asia. Sustainbility12(11), 4611.

ITF. (2020). Safe Micromobility. Report by the International Transport Forum OECD/ITF.

Oescheger, G., Carroll, P., and Caulfield, B. 2020. Micromobility and public transport integration: The current state of knowledge. Transportation Research Part D 89, 102628.