What football clubs support in different areas of the cities of the world
For the international football application Scores & Video, we collect the best photos from Instagram and Foursquare for each match, it turns out an operational and atmospheric tape. We have accumulated several million photos of fans along with their geodata. We decided to find out how their addictions are distributed in space and which areas of Moscow are truly Spartak .
For implementation, we used our data warehouse in Amazon Redshift (see the previous post about its device ), Yandex.Maps, and the coordinates of city districts from OpenStreetMap. Club preferences are determined by our hashtag database, data is cleaned to get rid of artifacts from other sports. In total, there are 10 major football cities in Europe and America in infographics, for which the most interesting distributions were obtained.
For example, Rome was clearly divided into the northern and southern parts .
And in Buenos Aires, among the large teams, the only area stands out where the “Argentinos Juniors” are popular (Maradona started there).
For some large cities (Tehran, Cairo, Tokyo), it was not possible to determine the quality of clubs by hashtags, so we excluded them from the selection. Others (Sao Paulo, Lisbon) in OpenStreetMap did not find an administrative division suitable for us. In general, the quality of the data makes us happy: Torpedo fans confirm that Teply Stan is their area (and CSKA fans note that the map as a whole is still red and blue).
We are planning several more infographics based on open data and our user activity database. What sports data would you be interested in?
For implementation, we used our data warehouse in Amazon Redshift (see the previous post about its device ), Yandex.Maps, and the coordinates of city districts from OpenStreetMap. Club preferences are determined by our hashtag database, data is cleaned to get rid of artifacts from other sports. In total, there are 10 major football cities in Europe and America in infographics, for which the most interesting distributions were obtained.
For example, Rome was clearly divided into the northern and southern parts .
And in Buenos Aires, among the large teams, the only area stands out where the “Argentinos Juniors” are popular (Maradona started there).
For some large cities (Tehran, Cairo, Tokyo), it was not possible to determine the quality of clubs by hashtags, so we excluded them from the selection. Others (Sao Paulo, Lisbon) in OpenStreetMap did not find an administrative division suitable for us. In general, the quality of the data makes us happy: Torpedo fans confirm that Teply Stan is their area (and CSKA fans note that the map as a whole is still red and blue).
We are planning several more infographics based on open data and our user activity database. What sports data would you be interested in?