Many things herald the long-awaited arrival of spring - sunnier weather, leafier trees - but no springtime event is more exciting to baseball fans than Opening Day! On an appointed day in April, all 30 Major League Baseball teams open the new season enthusiastically with 15 back-to-back ball games.
While our Madrid office tends to pay more attention to another kind of “‘bol” sport, this year’s MLB Opening Day was super exciting for us in CartoDB New York because MLB asked us to create a series of Twitter maps for each and every opening day game! How often does baseball and cartography collide?! Mapping Tweets for each team’s hashtag during their game turned out to be a great way to visualize the ferverous excitement of fans and even uncover some interesting stories. Take a look at what we found!
This was one of my favorite maps of the day simply because of the sheer size of activity we captured - over 125,000 Tweets, more than any other game. This makes sense as it was the first game, actually played on the Sunday evening before Monday, the actual opening day. This timing also probably gave more fans a chance to watch and Tweet along - not everybody gets to watch baseball while they’re at work on Monday like we did at CartoDB! There are also three distinct “bursts” over the course of the game that correspond to the timing of the three runs by St Louis.
This map isn’t super interesting at first glance, but I liked it just because of how clearly it shows the dedication of Milwaukee and Wisconsin-based fans to their home team. The game came early in the day, so only around 10,000 tweets were sent pertaining to the game, and it was a 10-0 shutout by Colorado. But just look at how brightly most of Wisconsin shines with that yellow hue…
When I generated this map, it left me scratching my head for some time. Somewhere around the time of the second inning, there was a country-wide, sustained burst of Tweets specifically for the Marlins, in orange. What happened there?
Turns out, Marlins Park is a modern stadium built in 2012 with a retractable roof to avoid rain delays. Except that retractable roofs don’t actually save you from the rain if you leave them open. Marlins’ President David Samson started the game with the roof open, and “tried to predict that a cloud would go north and it went south on top of our ballpark,” pelting the stadium with precipitation in the second inning and delaying the game for 16 minutes while the roof closed, as reported by Fox Sports. This 16-minute delay corresponds almost exactly with the orange burst in our Torque map. Add to that its comical nature and that the name of the stadium, “Marlins Park”, is the same as the team hashtag we were collecting, and you can see how we captured a bevy of Tweets from across the country from people who may have heard about the incident but didn’t start out watching the game.
This just goes to show there are stories to be uncovered everywhere, and CartoDB Twitter maps can help you find them.
This was a demanding project as we had to download Twitter data and create a map for MLB just minutes after the close of each game. With the help of a CartoCSS template we developed that we could quickly copy and paste, CartoDB more than proved to be up to the challenge!
CDB_Math_Mode as the Torque aggregation function, which determines the “mode” (statistics for “most common value”) of the column you give it. In the case of two-category Twitter maps like these,
category_name works well.
To make the bubbles “grow” and fade in, we employed a series of
frame-offset rules. Animated Torque maps consist of a number of frames played over a number of seconds (each set by
frame-offset lets you do something a few frames before or after the main frame the feature/Tweet shows up in, so you can do fade-ins and fade-outs by changing the
marker-fill-opacity, or give a “fireworks” effect by changing the
marker-fill sets the color of the dots. We had a pre-approved list of hex colors for every team in MLB, so updating each map mostly involved just changing these values!
Once we were done creating all the maps, MLB’s videography team put together a great 45-second video that captured the entire Opening Day Twitter bonanza, and tweeted it out on the main @MLB account!
What Twitter maps will you make?
Many things have changed in our day to day lives since the start of the pandemic, and industries such as retail, tourism, and real estate are forced to navigate through a c...Use Cases
In Portland, Oregan, the city picked up more waste in 2020 than any other year on record: 3,000 tons, 50% more than the previous year. As a result of the pandemic, more peo...Use Cases
At CARTO, we firmly believe that the future of geospatial analysis lies in the realm of next generation cloud data warehouses. Traditional data sources (such as census data...Use Cases
Please fill out the below form and we'll be in touch real soon.