Bikeshare Distribution Tool

Bikeshare Bike Distribution Tool

This tool is designed to help create a distribution plan for the Citibike bikeshare program. It’s intended to assist field operators find stations for bikes in real time. Whether the bikes are new or replacements, this tool helps locate the stops most likely to be used by the public to further distribute bikes into the system.

A distribution plan can be useful to reintroduce fixed bikes, replace worn-out bicycles, or extending the total number of available steeds. The tool creates a plan by first identifying the most popular stations using historical data (currently, April 2018), then assigning new bikes based on three elements: 1) total incoming bikes, 2) total stations, and 3) the relative demand for each station. The assignment process accounts for morning and evening activity as bike share users tend to act differently depending on the time of day. Total available docking spaces are included in the table to improve the planning process.

This is an ongoing project, so recommendations are welcome, just use this page to contact me. My next step is to build in a download button to get the table data. Thanks for looking!

Here’s a demo of the tool in action.

screenshot

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s