Giro d’Italia Routing Data 1909-2013

Here is the data I’ve produced for use in my university dissertation. It’s essentially away of seeing where the Giro d’Italia visited each year, and was produced by taking every route from its inception in 1909 till 2013, the most recent route we have, and taking the start and finish towns and charting them. For instance, if the race finished in Milan in 1909, then it gets an ‘X’ in the chart next to that year. If the stage say started and finished in Milan, then it would still only get one ‘X’ – but it would get a 2 rather than a 1 in the most visited list. Here is the raw data I produced following this.

Now, it’s very large, so you’ll have to click and zoom on this image until I discover how to copy Excel tables into WordPress (please help), but there’s 737 different places that have been used as start or finish locations, and the Giro will have had 96 editions by May 2013, so that’s 70,752 boxes. The race has made a total of 3,691 starts and finishes. I know what you’re thinking. That shouldn’t be an odd number. I’m working on it! This took a long time – I had to find the route for every single Giro, type each stage out, then type the name into the chart and add the numbers, then repeat for the next 95 editions. It was a little soul destroying, so please forgive the fact that there is undoubtedly an error or two in this somewhere. PS: Correct figure should be 3,686 visits.

GiroStats

I was then able to show the number of visits to individual provinces, of which there are currently 111, as well as the 20 regions of Italy, and the percentage of visits to each etc as I had attached the provinces and regions, the next two levels of governance up from cities, to the original data. For clarity, here is a map of the 20 regions of Italy (the provinces are subdivided into the regions themselves)

italy-county-map

Here are the subsequent region/province data sheets:

Regions Provinces

The data can also be used to show how the Giro has evenly distributed its stages across all facets of the country:

map5

This map was formed by arbitrarily splitting the country into eighths, where each eight is one eight of the 677 places the race has started and finished within Italy (737 includes international visits), so that there are 85 places in the thin segment N 1/8 and 85 in N 8/8. This demonstrates that the density of places visited is much higher in the North, although given the race needs to go to the Mountains in these regions, this is easily explainable.

graph8

The above graph takes the percentage of visits to these areas over time to show that the race has converged to a more equal distribution of starts/finishes across the country then it did when it first began.

graph2

This graph simply shows that the race visits the most populated areas most often.

graph1

This graph shows some fairly weak correlation between the North/South rank of a region and the % of race visits they have commanded. graph9

This graph shows how the race visited the majority of the regions pretty quickly, but that it took longer to visit some southern regions, such as Sardinia- explanation, I’m afraid, will have to wait until I can publish the dissertation itself online!graph7

This graph was produced by measuring the distance of each international visit of the Giro from a central point, taken as Milan, and then averaging out this distance by the number of international visits that year to produce a figure. Thus, if the Giro went to say Nice and Verbier in 1990, and the distance to Nice was 200km and 400km to Verbier, then the figure for 1990 would be 200+400(total distance) /2 (number of visits) = 300km. As a result, you can see that the Giro has been getting increasingly distant from Italy in its international visits, and these visits are also getting more frequent.

graph5This graph is simply the number of visits carried out by the race, so that again, if there was a stage from Nice to Nice in 1990, there would be 2 international visits in 1990. Again, you can see that the number has been increasing lately

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s