Data Nerd: Mapping Vancouver’s Bike Racks

Updated on 2016-04-12 to include 2013-2015 data.

The City of Vancouver made its bike rack data public yesterday. The data is divided into 4 spreadsheets, which isn’t terribly useful. The only interesting tidbit is the exponential growth in bike lane installations. Vancouver now has 1468 bike racks at 1119 locations throughout the city.

In the all the years up until 2009, 676 bike racks were installed.
In 2010: 52
In 2011: 197
In 2012: 543
In 2013: 138
In 2014: 148
In 2015: 422

But without a map, that doesn’t tell the full story. The map above is an interactive google map.

Note: The dataset uses addresses to identify the bike racks, so it’s not perfect when you zoom in.

#batchgeo #bikeParking #bikeRack #bikeRacks #bikeyvr #dataNerd #map #opendata

It sounds dumb, but I am thinking of getting an Oura Ring 4 on top of my Garmin smartwatch... #DataNerd

Friends, don’t make the same mistakes I’ve made: always use replication slots for your #PostgreSQL standbys 🤦

#dba #dataNerd

📊 HEADLINES SAY SURGE. CHARTS SAY NOPE. Stat Dude checks 15 years of ICE deportation data — and the “big crackdown” headlines don’t hold up. 🎥 Watch → www.youtube.com/playlist?lis... #StatDude #TrailMixLive #Immigration #ICE #DataNerd

Crackdown: The Migrant Purge

My 7-year old collected 32 conkers while we out for a walk this morning (still not quite sure they all fitted into his pockets).

Nerdy dad saw the opportunity to introduce him to basic descriptive statistics. He weighed each conker and I set him up with Numbers on his iPad so he could create his first ever spreadsheet.

He seemed quite comfortable learning about basic functions to work out things like sum, average, min and max.

#ProudDad #Spreadsheets #DataNerd

Test your skills with our Data Engineering Quiz!

Tag a data nerd friend who’d ace it!

#DataEngineering #ETL #TechQuiz #DataNerd #EngineerLife #LearnWithFun #TechCareers #BigData #DataPipeline
#DataEngineerLife #SQL #ApacheSpark
#CareerInTech #LearnDataEngineering
#EngineeringQuiz #DataNerd #UpSkill
#TechCareers #DataDriven

🎞️ How many degrees to Kevin Bacon?

I processed nearly 4 million actor-to-movie pairings to build a complete collaboration graph. Then ran shortest-path logic to see how connected a few stars are.

✅ Jon Hamm? 2 degrees.
✅ Brie Larson? 2 degrees.
✅ Jodie Foster? You guessed it—2.

🍳 This is part of my "Degrees of Bacon" series—drop 4 is here!
Built using public data + a love for film.

▶️ Animation below 👇

#KevinBacon #MovieGraph #IndieDev #DataNerd #Python #Fediverse #OpenData #Bamlytics

I have also been looking for a blogging platform to host some stories about my selfhosting adventures

I'm currently looking into Ghost CMS as I used it in the past, but I am open to new outlooks

My requirements are:
- Must be opensource
- Loads of statistics (I'm a data nerd after-all)
- Lightweight'ish
- Simple design
- No Wordpress

Bonus if I can sync posts with a git repo (one way or another)

#blog #selfhosting #selfhost #opensource #datanerd #git

This Math Teacher Gets Mean… Median, and Mode!
Me: Explains statistics.
Students: "Will we ever use this in real life?"
Me: Yes, and I’m collecting data on your confusion right now.

🔗 https://techgeeksapparel.com/this-math-teacher-gets-mean/
#StatisticsJokes #MathTeacherLife #DataNerd #STEMHumor

I Never Metadata I Didn’t Like
Data lovers get it.
Metadata is where the real magic happens.

🔗 https://techgeeksapparel.com/i-never-metadata-i-didnt-like-t-shirt/
#DataNerd #MachineLearning #BigData #TechHumor

Data > Opinions
Data tells the truth.
Opinions… not so much.

🔗 https://techgeeksapparel.com/data-is-greater-than-opinion-t-shirt/
#DataNerd #TrustTheData #BigData #STEMLife

In the Amazon Prime day sale last year I splurged to get a #WalkingPad. I've been using it most days since I purchased it and have slowly been able to increase the amount of time I use it.

Over the last month I've ended up keeping my standing desk permanently in the up position as I stand all the time now, even when not walking.

I'm a spreadsheet-data-logging-obsessive kind of person so let's take a look at what I've been tracking...

#walking #DataAnalysis #DataNerd #charts 📈

@jaseg

From the Department of "Things That Are Really Interesting To Think About, But Would Never Have Crossed My Mind To Ponder"

😊

#DataNerd #Data

In #cronometer I learned I can mark a day as complete when I'm done tracking my food and also only show reports based on completed days. That's super helpful since I'm not very consistent!
#foodjournal #healthyeating #datanerd #habits

#TIL about the Internet History Initiative (@IHI). It's a website that focuses on historical relevant public data sets. As a #datanerd and #datahoarder of #internet data, I appreciate that something like this spun up.

However, I am shocked, I haven't heard from it so far. Although, it's online since January 2024 already! Will definitely start to keep an eye on it.

Edit: Forgot to link the website: internethistoryinitiative.org

#infosec #data #DNS #BGP #IXP

Just added my recent library haul to my spreadsheet and I've already borrowed €191,- worth of books, which means I've already read more than the fee of €66,- (Dutch libraries you pay for your subscription) in January alone. I've also read €132,- worth of books on my #koboplus and #storytel subscriptions, I need to read a bunch more to read the yearly fee worth but it's way more than the montly fee. #bibliotheek #libraries #books #data #datanerd

Hello transit and data nerds, Charles Komanoff gives you an opportunity to get into his magical spreadsheet. #datanerd #congestionpricing #opendata nyc.streetsblog.org/2025/01/15/k...

KOMANOFF: Why I’m Not Scrutini...

@blaine @akurjata Here's a BC map with major provincial highways and using charging stations as of today.

There is some weirdness near the border of the Yukon and Alberta as I limited it to BC. But this weekend I'll try running it for the whole country. #ev #electricvehicles #datanerd #mapping

Alle Fotos gesichtet und von Sichtungs- in Hauptkatalog importiert. Jetzt die ganzen Keywords...

Alle Strava-Files betitelt und für jeden Stint schon ausführliche Notizen bis sogar schon fertigen Journal-/ Blog-Text geschrieben.

Sehr zufrieden. Jetzt die weitere Auswertung (Höhenmeter, Zeit, schauen, ob ich die Hike-a-Bikes irgendwie abgebildet bekomme etc...) :)

#AlpsDivide #bikepacking #Ultracycling #datanerd #photographer #geek #weitradeln

Co-Op (https://www.instagram.com/coopuk/) consistently beat out other grocery reward schemes, and as a #dataNerd I always appreciate their useful use of my purchase data.

But they *definitely* understand #theGreat2024Move assignment for this week!

The only problem is how do I pick two?!