December Visualisation Blog: Crow Flies Vs. OD Paths
December Visualisation Blog: Crow Flies Vs. OD Paths
Crow Flies Vs. OD Paths
In 2017, the UK Data Service published a report on commutes or more specifically “Location of usual residence and Place of work by Method of travel to work”. This utilised 2011 census data, and used people’s home and workplace, drew a straight line between the two and calculated the distance. This is called “as the crow flies”, but if you are a regular reader of these blogs you, will know, we do not crow fly around here.
Basemap regularly get asked about visualising this journey data, as it provides an insight into commuting locations which is important when looking at new housing developments.
The term as the ‘Crow Flies’ goes as far back as the 19th Century when it was first mentioned in the novel Oliver Twist. Since then, it has been regularly used to represent travel times between two points. And whilst it has been ever so popular within the transport industry, the ‘Crow Flies’ method is quickly becoming obsolete due to its inability to measure real travel times and distances. The reason for this is simply because… well, we aren’t crows. We can’t fly! Instead, we must factor in buildings, junctions, and road speeds, just to name a few. Which we all know play a large part in how we travel.
So, we thought we would show you just how different a crow flies journey compares to an actual everyday commute using some cool maps!
To do this, we firstly downloaded the Middle Layer Super Output Area (MSOA) shapefile from the UK Data Service. This was loaded into QGIS where the centroids for each MSOA was extracted, which became our origins/residences. Out of this layer a single point was selected as the destination/workplace, Bury St. Edmunds. Straight lines were generated for each origin point to create journeys imitating a ‘Crow Flies’ approach. The map below shows the resulting output for this.
Here we can see the shortest distances travelled from residences to Bury St. Edmunds, and at a glance, the destination seems easily accessible with what looks like relatively short trips. As you and I both know, things are never this simple! As these are ‘Crow Flies’ results, we can expect that it isn’t showing actual distances travelled nor the time taken. See Tables 1 and 2 to find out more.
We decided to take this one step further and find out what the true routes would look like for some of the journeys. For this, the MSOA points were exported from QGIS and loaded into TRACC, along with OS Highways and public transport data so that accessibility calculations could be run. Within TRACC there is a feature which produces OD Path Reports whilst running simultaneously calculations to show the exact breakdown of journeys. This was completed for both public transport and car rides. These reports are saved as .csv files which contain co-ordinate information, making them easy to convert into shapefiles when adding into GIS. With the help of the ‘Points to Path’ feature in QGIS we were able to produce the routes for every trip to Bury St. Edmunds from the path reports.
A sample of the ‘Crow Flies’ journeys were compared against the results that had been generated in TRACC. See the comparison maps below to find out just how much the journeys differ!
As already mentioned, the ‘Crow Flies’ distances seemed very short as would be inevitable when you’re excluding the road network from your commute. So, it is expected that both maps would show an immediate difference in their outputs, which shows just how much travel can be affected by factoring in roads.
Office for National Statistics provides a ‘Method of travel to work’ dataset containing information about residents aged 16 to 74 as defined by their method of travel to work from Census 2011. It is summarized by the number of usual journeys between two points.
The table below outlines the number of trips taken using the journey examples shown in the comparison maps. We also added in the various distances travelled and time taken for each as given by Crow Flies and TRACC so these can be compared in more detail.
Table 1
Place of Residence |
MSOA Code |
No. of Trips by PT |
Distance Travelled(Crow Flies, km) |
Distance Travelled(TRACC, km) |
Travel Time (mins)(TRACC) |
Cambridge 006 |
E02003724 |
2 |
37.86 |
40.76 |
81.88 |
St Edmundsbury 002 |
E02006274 |
35 |
10.92 |
18.09 |
39.24 |
Mid Suffolk 002 |
E02006262 |
16 |
21.74 |
35.53 |
173.55 |
Ipswich 007 |
E02006251 |
2 |
37.63 |
42.05 |
60.15 |
Forest Heath 004 |
E02006241 |
12 |
16.96 |
20.56 |
41.92 |
East Cambridgeshire 011 |
E02006825 |
2 |
19.72 |
27.92 |
73.78 |
St Edmundsbury 003 |
E02006275 |
63 |
1.65 |
2.79 |
12.89 |
Babergh 007 |
E02006233 |
4 |
22.96 |
25.62 |
56.59 |
Babergh 002 |
E02006228 |
7 |
12.75 |
14.21 |
44.61 |
Breckland 016 |
E02005518 |
10 |
19.31 |
20.52 |
46.34 |
Table 2
Place of Residence |
MSOA Code |
No. of Trips by Car |
Distance Travelled(Crow Flies, km) |
Distance Travelled(TRACC, km) |
Travel Time (mins)(TRACC) |
Forest Heath 002 |
E02006239 |
40 |
23.49 |
27.02 |
26.05 |
St Edmundsbury 011 |
E02006283 |
57 |
20.95 |
24.32 |
25.44 |
South Norfolk 015 |
E02005611 |
20 |
30.59 |
36.94 |
32.59 |
Norwich 009 |
E02005592 |
2 |
57.03 |
66.44 |
56.12 |
King’s Lynn/West Norfolk 009 |
E02005559 |
2 |
59.88 |
71.51 |
58.52 |
South Cambridgeshire 020 |
E02006873 |
4 |
53.12 |
60.28 |
49.95 |
Suffolk Coastal 001 |
E02006287 |
3 |
54.75 |
68.04 |
58.79 |
Babergh 011 |
E02006237 |
10 |
43.56 |
54.35 |
46.97 |
Colchester 016 |
E02004521 |
1 |
45.57 |
55.92 |
53.57 |
South Cambridgeshire 001 |
E02003775 |
3 |
45.78 |
59.86 |
50.07 |