Bike availability over time

381 views
Skip to first unread message

Conor Skelding

unread,
Dec 8, 2021, 2:22:17 PM12/8/21
to citibike...@googlegroups.com
Good afternoon:

I'm a features reporter for the Sunday NY Post. I've heard anecdotally that Citi Bike has become less reliable under Lyft -- but does anyone on this list have the stats to substantiate or disprove that? Maybe percentage of bikes out of service over time? Times docks were entirely full or entirely empty?

My cell is 917 533 2992 anyone wants to discuss this.

Thanks,
Conor Skelding

--

Clif Kranish

unread,
Dec 8, 2021, 4:43:45 PM12/8/21
to citibike...@googlegroups.com, conors...@gmail.com

While CitiBike does provide a real-time feed of availability of bikes at each station they don't provide historical data. Someone would have had to capture the count of bikes at each station at some time interval and publish that data.

What they do provide is a record of each TRIP taken on a CitiBike and with that I was able to ESTIMATE the number of bikes at a station.

Here's a link to an article I wrote about how to do that. If you're not interested in how then scroll down to the charts at the bottom that show counts at one station for one day.

https://towardsdatascience.com/estimating-bike-availability-from-nyc-bike-share-data-7cfc4655d5f6

--
You received this message because you are subscribed to the Google Groups "BikeNYC and CitiBikeNYC Hackers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to citibike-hacke...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/citibike-hackers/CAMLsgYZUcfaB82-CAMsLdV5SN8icNSRqhgzSCr0DMPk27_n37g%40mail.gmail.com.

edward hull

unread,
Dec 8, 2021, 8:00:32 PM12/8/21
to BikeNYC and CitiBikeNYC Hackers
I can provide a better solution in estimating bike availability based on the trip data, for bikeshare or other shared mobility services.

Even though ckan's method provides a good framework of "trip+rebalancing", he only gets the gap between pickups and drop-offs, not the real bike amount in each station.
So his "guess" may not be accurate, I have solved this problem by converting trip data into location data.

My method of estimating bike availability is as follows. a) Split each trip record into two location records of this bike. b) Use the location data to get all bikes' station locations at each time point. c) Bikes, that are in use at a time point, are unavailable and should be removed. d) Calculate the bike amount in each station at each time point.

More details are in my paper: Forecasting usage and bike distribution of dockless bike-sharing using journey data
https://ietresearch.onlinelibrary.wiley.com/doi/full/10.1049/iet-its.2020.0305

Feel free to contact me if you have any questions. Here is my contact information.
Cell: 45 9166 3761
Email: huamin...@seu.edu.cn

Chetan Temkar

unread,
Dec 8, 2021, 11:47:47 PM12/8/21
to citibike...@googlegroups.com
Hi Conor
I have written an app for Citibike Bike Angels and do read the data regularly whenever it is accessed in the app. 

If needed I can create a server based database to map the history based on suggestions in this group.

One of the things they need to do is increase the Bike Angel points like they were doing in the trial period a month back. That encourages people to move bikes where they are needed. 

Lyft had more problems when it took over Citibike but they seem to be slowly improving.

Chetan Temkar




--

Rowan Whalen

unread,
Oct 23, 2023, 11:24:39 AM10/23/23
to BikeNYC and CitiBikeNYC Hackers
Hi Chetan, 

Curious if you could share more about your Bike Angels app. I was exploring the idea of creating a model that calculates the best opportunities for getting points (where is there the biggest discrepancy for points to take away vs. points to dock, thereby getting the best 'arbitrage' opportunity) for a class and would love to see what your app does. 

Thanks!
Rowan
Reply all
Reply to author
Forward
0 new messages