Straightness

I have start places and finish places of each Grand Tour stage in my database, and also the length. As a sanity check, I calculated the straight line distance between start and finish. The real length of a stage should be as least as long, so this is a method to find mistakes.

Below are lists of the 25 stages per Grand Tour where the ratio real length/straight length is the largest.

There are a few sources for errors:

Altogether, this makes an worst case error of a few kilometers (assuming that the error sources above are independent), and because a typical stage has a length of 200 km, a ratio of 1.02 can still be correct. Every stage that has a ratio above 1.02 needs an explanation or improvement.

For the Tour, there are only two anomalies:

All other stages (should) have a ratio below 1; a value slightly above 1 could indicate a rounding error.

YearStageRatio
1988P 5.112
197618A 1.406
19836 0.993
19384A 0.987
198816 0.981
19291 0.979
19301 0.979
193520B 0.979
193620B 0.979
19281 0.974
19311 0.970
19321 0.970
193820A 0.965
19637 0.960
195521 0.959
197218 0.957
19386A 0.955
19608 0.944
193718B 0.942
19518 0.940
193619B 0.939
19381 0.938
19391 0.938
19515 0.938
19636A 0.935
193810B 0.932

I also did this for the Giro, see below. Exception is:

YearStageRatio
19466 1.025
195919 1.011
19105 0.978
19397 0.964
19752 0.948
193910 0.945
193615B 0.941
19751 0.933
196018 0.927
19521 0.927
19196 0.921
19467 0.917
20215 0.916
20104 0.916
199312 0.912
198417 0.912
201714 0.910
19399 0.910
194712 0.909
19597 0.907
193915 0.907
20125 0.905
194710 0.903
19566 0.903
195111 0.899
196913 0.897

And for the Vuelta. Exceptions:

YearStageRatio
19954 1.459
19563 1.167
20241 1.128
195712 1.122
19584 1.122
19619 1.116
197819A 1.043
194610 1.013
196415 0.994
197012 0.991
198310 0.986
195013 0.966
194518 0.964
194723 0.956
19502 0.956
19609 0.955
194622 0.949
197916A 0.949
198315A 0.949
20151 0.943
202320 0.943
19813 0.938
19602 0.934
195022 0.934
19454 0.930
196312B 0.928