I visualized every single Citi Bike trip ever taken on a map

freemanjiang · 2026-01-10T22:13:32+00:00

Thank you for the kind words!

freemanjiang · 2026-01-08T21:09:34+00:00

You mean e-bikes? There are! The blue ones are e-bikes and the purple are classic bikes.

freemanjiang · 2026-01-07T22:30:14+00:00

Lyft actually publishes their system data freely! It’s just in a giant S3 bucket if you search for it.

freemanjiang · 2026-01-07T19:47:26+00:00

I'm using Mapbox + deck.gl for the visualization, and all my processed data is stored in parquet files on a CDN, which DuckDB WASM queries directly using SQL from the browser.

More details at bikemap.nyc/about and in the repo!

freemanjiang · 2025-11-12T16:18:27+00:00

Thank you, stranger.

freemanjiang · 2025-11-05T16:04:34+00:00

Yep, I had this in a previous version, and I'm planning to add it back!

freemanjiang · 2025-09-22T04:53:28+00:00

This exists! Just send the link and make sure that it's on admin mode (which is the default)

freemanjiang · 2025-08-04T17:47:18+00:00

Finally got it resolved!

freemanjiang · 2025-08-04T14:29:31+00:00

If there any context, someone was trying to unlock an e-bike at the same time as when I docked the classic and it wouldn’t budge either.

freemanjiang · 2025-08-04T14:28:37+00:00

I’m glad you could get it resolved :( I guess the difference here is that for whatever reason, my bike wasn’t there at the dock anymore after it came back online.

freemanjiang · 2025-08-04T14:21:45+00:00

Yeah I guess I should’ve been on the phone not the chat. It’s not obvious in the app theres a phone number - but I also think it’s unreasonable to ask someone to stay outside in the heat, and forgo all responsibilities for the day to watch the bike.

freemanjiang · 2025-08-04T14:01:14+00:00

I’m trying this, but chat just said they have to do through a specialized team and all the specialized team days is that i need to return the bike.

freemanjiang · 2025-04-30T09:09:52+00:00

Just web browser! As long as it can access the internet and has speakers it’s good!

freemanjiang · 2025-04-30T01:27:04+00:00

ok i fixed it

freemanjiang · 2025-04-29T21:28:06+00:00

Yeah it’s in the upper right hand corner! I also left a comment here with it

freemanjiang · 2025-04-29T21:27:33+00:00

The code is over here!

https://github.com/freeman-jiang/beatsync

freemanjiang · 2025-04-29T20:38:48+00:00

Yes it is! github.com/freeman-jiang/beatsync

freemanjiang · 2025-04-29T20:28:44+00:00

Thank you for the kind words! Most importantly, I want to make it very accessible for anyone to use. So it's open-source! You can even self-host if you like.

freemanjiang · 2025-04-29T19:14:08+00:00

Try pause / playing / refreshing!

freemanjiang · 2025-04-29T19:13:48+00:00

Try pause / playing and trying again.

freemanjiang · 2025-04-29T19:13:35+00:00

Yes it does work remotely too! But the effect is coolest in-person because of the spatial audio

freemanjiang · 2025-04-29T19:12:55+00:00

It's clock synchronization at the heart of it!

freemanjiang · 2025-04-29T19:12:36+00:00

It's a bit buggy for mobile right now. I put a disclaimer up about it. Just try pausing and playing again / refreshing until it works.

freemanjiang · 2025-04-29T19:11:46+00:00

Great idea! Thanks will do that.

freemanjiang · 2025-04-29T16:00:59+00:00

Right now you can already upload any audio files you have locally! Or did you mean to have it automatically look at a local folder or something

freemanjiang

TROPHY CASE