Train Spotting

Hey all,

For the past 15 days, we have been trying to get our coding skills polished and shining before we possibly put them away for some time.

The idea is to map the trains in India every minute for an entire day and watch the video :D
A sneak peak video can be found at:


However, we never realized how intricate the railways network in the country was until this threw up locations that Google couldn't locate or wrongly located. In order to improve the video, we require 5 minutes of your time:
1. Here you'll find the trains that have behave erratically (due to a mistake in the raw data) and the corresponding approximate times at which they do so.
2. Pick some random entry that you want to correct.
3. Go here and enter the train number of the corresponding train. A train schedule shows up.
[If it throws an error, blame the government website and try again in a few hrs! Thanks already!!]
4. The train will be between some two stations at that time (Step 1, 2). The data of one of the stations is most likely to be wrong.
5. Open Google Maps. Use common sense and basic knowledge of India's geography to locate the Latitude and Longitude of the stations. This spreadsheet will guide you to current values of the co-ordinates.
(A -1 in the spreadsheet indicates data currently unavailable).
6. In case, you locate an error in the 2nd spreadsheet values of Latitude or Longitude - do kindly mail me at shantanugangal at gmail.

I really hope that this cooperative effort will help us quickly get our data sanitised. You have no idea how thankful I would be, since checking all the error prone entries is tough for a single guy :D

Example:
1, 2. I want to fix the fifth row -- 1007    10    20
3, 4. Train is between Talegaon Station and Khadki Station, at 10h20 for the Train number 1007.
5. The co-ordinates of Khadki (19.88, 75.32) in the second spreadsheet are wrong because they are hardly near the train way from Lonavala to Pune.
6. The correct co-ordinates of Khadki are (18.566527,73.84203). Do mail me such errors in the 2nd spreadsheet.