-
Notifications
You must be signed in to change notification settings - Fork 15
Best log
Johnson Chetty edited this page May 28, 2013
·
14 revisions
This documents corrections made by hand to Atlas/UniqueRoutes in the web admin, to identify and correct issues with fuzzy text matching of From and To stop names between the BEST Atlas, StopMaster, and RouteDetails tables (see BEST-Database for further explanation).
Alias:
"F-2": Is this supposed to indicate Fort Feri -2 "8131"
"F-1": Is this supposed to indicate Fort Feri -1 "8121",
"279Ext": There is no 279 Extra in Route, only 279 "2790"
"SPL-4": Does not exist in database.
Route 258 has two uniqueroutes which have same from and to stop combinations but different schedules. Can have only one.. Also the to_stop is actually the second last stop as indicated by routed details for this route.
372: Shivaji Nagar Depot to Shivaji Nagar Terminus has one entry with no schedule_type, (assigning full week)
394R - This, most probably could be 3940, because there is a 3940 entry in RouteDetails. And nothing for 3944. 1692 - This is the extra bus service for 1690, running on MS. But does not have entry in RouteDetails (we know that it is the same routedetail as for 1690 though, have added its routedetails entry by replicating 1690) 55 - This, mostly should be 55R, because a 0554 entry in RouteDetails exists. And nothing for 0550. 191 - Not found. Closest route code to it '0191' is 19 Limited.
6310 631: Kurla Stn(W) to Kurla Stn(W) ViaMasrani Estate is actually a ring route.. but code is given as 0, not 4.
To be changed: Atlas.Alias 631 -> 631R RouteMaster: Routecode 6310-> 6314 RouteDetails: Routecode 6310-> 6314 (for all the routedetails entries having 6310.)
6410 - AGARKAR CHK. - MALPA DONGRI NO.3 should have route code as '6414' - Verified by looking at routedetails and atlas
<Route: A-75EXP>,
<Route: A-13EXP>,
<Route: 58>,
<Route: 40LTD>,
<Route: 258>,
<Route: 259>,
<Route: 369>,
<Route: 393>,
<Route: AS-388>,
<Route: AS-512>,
<Route: 511LTD>,
<Route: 523LTD>,
<Route: 606RING>,
<Route: SPL-9>,
<Route: 631>,
<Route: 711LTD>,
<Route: SPL-12>,
<Route: SPL-8>,
<Route: SPL-1>])
"route_id","route_code", "route_alias" 1, "0011", "1LTD" 334, "0017", "AS-1" 401, "0027", "AS-2" 501, "0032", "3-EXTRA" 374, "0037", "AS-3" 510, "0043", "4LTD-EXTRA" 298, "0047", "AS-4" 378, "0057", "AS-5" 6, "0063", "6L EXTRA" 292, "0097", "AS-9" 521, "0116", "SPASTIC SOCIETY" 491, "0118", "" 474, "0126", "C-12" 403, "0138", "A-13EXP" 511, "0139", "A-13EXP.EXT." 502, "0172", "17 LTD.EXTRA" 533, "0332", "33-EXTRA" 343, "0412", "41EXT" 461, "0426", "C-42" 481, "0436", "C-43" 547, "0442", "44-EXTRA" 532, "0446", "C-44" 531, "0456", "C-45" 530, "0466", "C-46" 31, "0490", "49" 480, "0526", "C-52" 475, "0536", "C-53" 269, "0550", "0550" 484, "0556", "C-55" 537, "0580", "58" 476, "0606", "C-60" 478, "0616", "C-61" 479, "0626", "C-62" 446, "0661", "66LTD" 410, "0708", "A-70EXP" 43, "0710", "71" 462, "0716", "C-71" 477, "0726", "C-72" 440, "0748", "A-74EXP" 453, "0758", "A-75EXP" 466, "0768", "A-76EXP" 467, "0778", "A-77EXP" 505, "0852", "85-EXTRA" 60, "0931", "93LTD" 490, "1062", "106-EXTRA" 503, "1082", "108-EXTRA" 504, "1372", "137-EXTRA" 519, "1672", "167-EXT.RING" 515, "1750", "175" 543, "1824", "182 RING" 544, "1827", "AS-182" 545, "1830", "183" 546, "1837", "AS-183" 492, "2106", "SPASTIC SOCIETY" 542, "2160", "216" 459, "2180", "218" 396, "2292", "229EXTRA" 535, "2700", "2700" 132, "2734", "273RING" 366, "2804", "280RING" 297, "2884", "288RING" 424, "3027", "AS-302" 509, "3132", "313-EXT." 324, "3402", "340EXTRA" 181, "3470", "347" 538, "3483", "348 LTD-EXTRA" 284, "3720", "372" 522, "3736", "SPASTIC SOCIETY" 419, "3887", "AS-388" 212, "3894", "389RING" 487, "3904", "390RING" 506, "4212", "421-EXTRA" 302, "4227", "AS-422" 534, "4270", "4270" 540, "4280", "428" 421, "4407", "AS-440" 228, "4430", "443" 416, "4587", "AS-458" 294, "4617", "AS-461" 469, "4641", "464 LTD" 527, "4703", "470-EXTRA" 430, "4791", "479LTD" 407, "5037", "AS-503" 402, "5057", "AS-505" 507, "5063", "506-EXTRA" 423, "5127", "AS-512" 432, "5157", "AS-515" 536, "5161", "516 LTD" 425, "5247", "AS-524" 412, "5257", "AS-525" 529, "5259", "AS-525EXTRA" 411, "5517", "AS-551" 418, "5927", "AS-592" 256, "6214", "621RING" 539, "6284", "628 RING" 377, "7007", "AS-700" 408, "7077", "AS-707" 253, "7085", "708L RING" 520, "8111", "811-LTD" 523, "8126", "8126" 524, "8136", "8136" 541, "8161", "8161"
Nov2012
UniqueRoute 2550: 133R: Colaba Bus Station to Colaba Bus Stn Via Naik Chowk from 2687 to 2687 ran off the end while measuring distance! UniqueRoute 2579: 511Ltd: Mulund Bus Station(W) to Nerul Bus Station from 1018 to 1018 ran off the end while measuring distance! UniqueRoute 2579: 511Ltd: Mulund Bus Station(W) to Nerul Bus Station from 1018 to 1018 still has no distance! UniqueRoute 2735: 209R: Borivli Station(E) to Via Sudhindra Nagar from 3186 to 1388 ran off the end while measuring distance! UniqueRoute 3023: 259: Oshiwara Depot to Gorai Depot from 1365 to 1365 ran off the end while measuring distance! UniqueRoute 3023: 259: Oshiwara Depot to Gorai Depot from 1365 to 1365 still has no distance! UniqueRoute 3041: 250: Andheri Station(W) to Via Gilbert Hill from 3430 to 3658 ran off the end while measuring distance! UniqueRoute 3097: 523Ltd: Dindoshi Bus Station to Airoli Bus Station from 574 to 574 ran off the end while measuring distance! UniqueRoute 3110: AS-388: Poisar Depot to Gharkopar Depot from 1230 to 1230 ran off the end while measuring distance! UniqueRoute 3110: AS-388: Poisar Depot to Gharkopar Depot from 1230 to 1230 still has no distance! UniqueRoute 3125: A-75Exp: Colaba Depot to Jay Coach from 4 to 5 ran off the end while measuring distance! UniqueRoute 3146: 58: Anik Depot to Priyadarshani from 297 to 171 ran off the end while measuring distance! UniqueRoute 3202: 132R: Colaba Bus Station to Colaba Bus Stn Via Naik Chowk from 2687 to 2687 ran off the end while measuring distance! UniqueRoute 3204: 106Ext: Churchgate to R.C.Church from 37 to 37 ran off the end while measuring distance! UniqueRoute 3225: 371: Bandra Bus Stn(W) to Bandra Bus Station(W) from 900 to 900 ran off the end while measuring distance! UniqueRoute 3240: Fort Ferry-2: Chh.Shivaji Terminus to Via Churchgate from 4666 to 897 ran off the end while measuring distance! UniqueRoute 3283: 44: Colaba Depot to Worli Depot from 4 to 4 ran off the end while measuring distance!
July2012
UniqueRoute 3: 2LTD: Electric House to Marol Depot from 628 to 629 ran off the end while measuring distance! UniqueRoute 81: 133RING: Colaba Bus Station to Colaba Bus Stn Via Naik Chowk from 2687 to 2687 ran off the end while measuring distance! UniqueRoute 103: 101: Electric House to Walkeshwar from 866 to 863 ran off the end while measuring distance! UniqueRoute 114: 511LTD: Mulund Bus Station(W) to Nerul Bus Station from 1018 to 1018 ran off the end while measuring distance! UniqueRoute 114: 511LTD: Mulund Bus Station(W) to Nerul Bus Station from 1018 to 1018 still has no distance! UniqueRoute 161: 237: Charkopar Sector No.8 to Borivli Bus Stn. from 1234 to 1234 ran off the end while measuring distance! UniqueRoute 161: 237: Charkopar Sector No.8 to Borivli Bus Stn. from 1234 to 1234 still has no distance! UniqueRoute 271: 6LTD: Colaba Depot to Deonar Depot from 4 to 4 ran off the end while measuring distance! UniqueRoute 549: 259: Oshiwara Depot to Gorai Depot from 1365 to 1365 ran off the end while measuring distance! UniqueRoute 549: 259: Oshiwara Depot to Gorai Depot from 1365 to 1365 still has no distance! UniqueRoute 569: 250: Andheri Station(W) to Via Gilbert Hill from 3430 to 3658 ran off the end while measuring distance! UniqueRoute 614: 523LTD: Dindoshi Bus Station to Airoli Bus Station from 574 to 574 ran off the end while measuring distance! Airoli bus station does not exist. Airoli sect 9, 10, 5 and Airoli Toll Naka.
UniqueRoute 628: AS-388: Poisar Depot to Gharkopar Depot from 1230 to 1230 ran off the end while measuring distance! UniqueRoute 628: AS-388: Poisar Depot to Gharkopar Depot from 1230 to 1230 still has no distance! UniqueRoute 664: 58: Anik Depot to Priyadarshani from 297 to 171 ran off the end while measuring distance! UniqueRoute 717: 132RING: Colaba Bus Station to Colaba Bus Stn Via Naik Chowk from 2687 to 2687 ran off the end while measuring distance! UniqueRoute 793: 44: Colaba Depot to Worli Depot from 4 to 4 ran off the end while measuring distance!
Mar2012
UniqueRoute 6: 2LTD: Electric House to Marol Depot from 628 to 629 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/774/ Corrected From stop name from NELCO to Colaba Depot. Could not find "Electric House" in From stop menu. Fixed missing depot.
UniqueRoute 20: 341: Antop Hill to Dindoshi Bus Station from 4727 to 4727 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/788/ Corrected To stop name from Antop Hill to Dindoshi Depot. Fixed missing depot.
UniqueRoute 30: 494LTD: Ghatkopar Bus Station to RetiBundar Kharigaon (Thane) from 4298 to 4300 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/798/ Corrected From stop name from Raj Park to Ghatkopar Bus Station. Fixed missing depot.
UniqueRoute 64: 133RING: Colaba Bus Station to Colaba Bus Stn Via Naik Chowk from 2687 to 2687 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/774/ Corrected To stop name from Colaba Bus Station to Vasantrao Naik Chowk. Corrected depot for Sunday schedule from Poisar to Backbay (depot text was BB).
UniqueRoute 85: 101: Electric House to Walkeshwar from 866 to 863 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/853/ Corrected From stop name from White House to Colaba Depot (since could not find "Electric House" in menu).
UniqueRoute 96: 511LTD: Mulund Bus Station(W) to Nerul Bus Station from 1018 to 1018 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/864/ Corrected From stop name from Nerul Bus Station to Mulund Depot. Could not find "Mulund Bus Station" in stop menu. Added bus type SD and depot GKD where missing (only in second schedule).
UniqueRoute 96: 511LTD: Mulund Bus Station(W) to Nerul Bus Station from 1018 to 1018 still has no distance!
http://chalobest.in/admin/mumbai/uniqueroute/865/ Corrected From stop name from Nerul Bus Station to Mulund Depot. Could not find "Mulund Bus Station" in stop menu. Added bus type SD and depot GKD where missing (in all schedules).
UniqueRoute 246: 478LTD: Shivaji Nagar Bus Station to Goregaon Bus Stn.(E) from 359 to 1269 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/1014/ Corrected From stop name from Marol Maroshi Bus Station to Shivaji Nagar Depot. Could not find "Shivaji Nagar Bus Station". Fixed incorrect depot match for SH from Anik to Shivaji Nagar
UniqueRoute 383: 16-LTD: Ambika Mills Bus Station to SRA Vashi NaKa from 180 to 181 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/1151/ Corrected From stop name from Aziz Baug to Ambika Mills Bus Station. Fixed incorrect depot match for WDL from Oshiwara to Worli.
UniqueRoute 387: 120: Pt. Paluskar Chowk to Dava Bazar from 441 to 3444 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/1155/ Seems okay, did not change From or To stop names. Fixed incorrect depot match for BB from Oshiwara to Backbay.
UniqueRoute 460: 363: Wadala Truck Terminal to Mahul Village from 194 to 196 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/1228/ Corrected From stop name from Wadala Road to Wadala Truck Terminal. Added bus type SD and added depot text ANK for Anik (already selected in menu).
UniqueRoute 504: 259: Oshiwara Depot to Gorai Depot from 1365 to 1365 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/1272/ Corrected From stop name from Gorai Depot to Oshiwara Depot. Added bus type SD, added depot text OSM, and selected Oshiwara for depot from menu.
UniqueRoute 504: 259: Oshiwara Depot to Gorai Depot from 1365 to 1365 still has no distance!
ibid. This is a cascading error.
UniqueRoute 523: 250: Andheri Station(W) to Via Gilbert Hill from 3430 to 3658 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/1291/ Seems okay. Selected Oshiwara for depot for depot text OSH.
UniqueRoute 570: 523LTD: Dindoshi Bus Station to Airoli Bus Station from 574 to 574 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/1338/ Corrected To stop name from Dindoshi Bus Station to Airoli Bus Station. Added bus type SD.
UniqueRoute 580: 214: Mount Mary Steps to Chuim Village from 1350 to 1349 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/1348/ Corrected To stop name from Mount Carmel Church/Lilavati Hospital to Chuim Village. Fixed incorrect depot match for BND from Wadala to Bandra.
UniqueRoute 663: 132RING: Colaba Bus Station to Colaba Bus Stn Via Naik Chowk from 2687 to 2687 ran off the end while measuring distance!
http://chalobest.in/admin/mumbai/uniqueroute/1431/ Corrected To stop name from Colaba Bus Stn Via Naik Chowk to Vasantrao Naik Chowk. Fixed depot mismatch for BB from Deonar to Backbay.
Nov 2012 These atlas entries still do not have any runtimes assigned to them.
ERR fix_missing_runtimes: 5151 LTD: Bandra Bus Station(W) to C.B.D.Belapur Bus Station: MS STILL missing runtime1! ERR fix_missing_runtimes: 372: Shivaji Nagar Depot to Shivaji Nagar Terminus: STILL missing runtime1! ERR fix_missing_runtimes: 71: Byculla Station(W) to R.G.Gadkari Chowk: MS STILL missing runtime1! ERR fix_missing_runtimes: 66LTD: Electric House to Dharavi Depot: FW STILL missing runtime1! ERR fix_missing_runtimes: 314: Shravane Yashwante Chowk to Raja Shivaji Vidyalaya: MS STILL missing runtime1! ERR fix_missing_runtimes: 1LTD: Colaba Bus Stn to Santacruz Depot: SH STILL missing runtime1! ERR fix_missing_runtimes: 357: Vasantarao Naik Chowk to Shivaji Nagar Bus Station: FW STILL missing runtime1! ERR fix_missing_runtimes: 506LTD: Jijamata Udyan to Kopar Khairane Extn: FW STILL missing runtime1! ERR fix_missing_runtimes: 526LTD: Jijamata Udyan to Jal Vayu Vihar/Kharghar: FW STILL missing runtime1! ERR fix_missing_runtimes: 49: Swami D.S.Chowk to Nadkarni park: MS STILL missing runtime1! ERR fix_missing_runtimes: 43: Ferry Wharf to Prateeksha Nagar: FW STILL missing runtime1! ERR fix_missing_runtimes: 43: M.P.Chowk(Mazgaon) to Prteeksha Nagar Depot: SH STILL missing runtime1! ERR fix_missing_runtimes: 7LTD: Mayo Road to Vikhroli Depot: SUN STILL missing runtime1!
July 2012
502LTD: Shivaji Nagar Junction to Nerul Sector-46/48: FW STILL missing runtime1! 5151 LTD: Bandra Bus Station(W) to C.B.D.Belapur Bus Station: MS STILL missing runtime1! 28: Chh.Shivaji Terminus to J.V.P.D.Bus Station: SH STILL missing runtime1! 340EXTRA: Agarkar Chowk to Barve Nagar: MS STILL missing runtime1! 372: Shivaji Nagar Terminus to Shivaji Nagar Depot: FW STILL missing runtime1! A-70EXP: N.S.C.I. to Mira Road Station: SH STILL missing runtime1! 71: Byculla Station(W) to R.G.Gadkari Chowk: MS STILL missing runtime1! 66LTD: Electric House to Dharavi Depot: FW STILL missing runtime1! 314: Shravane Yashwante Chowk to Raja Shivaji Vidyalaya: MS STILL missing runtime1! 1LTD: Colaba Bus Stn to Santacruz Depot: SH STILL missing runtime1! C-43: Rani Laxmi Chowk to Mumbra Police Stn: SUN STILL missing runtime1! 506LTD: Jijamata Udyan to Kopar Khairane Extn: FW STILL missing runtime1! 526LTD: Jijamata Udyan to Jal Vayu Vihar/Kharghar: FW STILL missing runtime1! 49: Swami D.S.Chowk to Nadkarni park: MS STILL missing runtime1! 43: Ferry Wharf to Prateeksha Nagar: FW STILL missing runtime1!
March 2012
492LTD: Seepz Bus Station to Waghbill(Thane): FW STILL missing runtime1! 492LTD: Seepz Bus Station to Cadbury Junction: FW STILL missing runtime1! 292: Borivli Station(W) to Shimpoli Village: MS STILL missing runtime1! 502LTD: Shivaji Nagar Junction to Nerul Sector-46/48: FW STILL missing runtime1! 502LTD: Rani Laxmi Chowk to Nerul Sector-46/48: FW STILL missing runtime1! 510LTD: Barve Nagar to Kopar Khairane Extn: HOL STILL missing runtime1! 5151 LTD: Bandra Bus Station(W) to C.B.D.Belapur Bus Station: SAT&SUN STILL missing runtime1! 5151 LTD: Bandra Bus Station(W) to C.B.D.Belapur Bus Station: SAT&SUN STILL missing runtime2! 5151 LTD: Bandra Bus Station(W) to C.B.D.Belapur Bus Station: SAT&SUN STILL missing runtime3! 5151 LTD: Bandra Bus Station(W) to Vashi Bus Stn: SAT&SUN STILL missing runtime1! 5151 LTD: Bandra Bus Station(W) to Vashi Bus Stn: SAT&SUN STILL missing runtime2! 5151 LTD: Bandra Bus Station(W) to Vashi Bus Stn: SAT&SUN STILL missing runtime3! 28: Chh.Shivaji Terminus to J.V.P.D.Bus Station: SH STILL missing runtime1! 28: Dr.S.P.Mukherji Chowk to J.V.P.D.Bus Station: SH STILL missing runtime1! 28: Pt. Paluskar Chowk to J.V.P.D.Bus Station: SH STILL missing runtime1! 28: Pt. Paluskar Chowk to J.V.P.D.Bus Station: SH STILL missing runtime1! 403LTD: Gavanpada(Mulund-E) to Agarkar Chowk: SUN STILL missing runtime1! 314: Shravane Yashwante Chowk to Raja Shivaji Vidyalaya: MS STILL missing runtime1! 314: Shravane Yashwante Chowk to Raja Shivaji Vidyalaya: MS STILL missing runtime2! 314: Shravane Yashwante Chowk to Raja Shivaji Vidyalaya: MS STILL missing runtime3! 314: Shravane Yashwante Chowk to Raja Shivaji Vidyalaya: MS STILL missing runtime1! 314: Shravane Yashwante Chowk to Raja Shivaji Vidyalaya: MS STILL missing runtime2! 314: Shravane Yashwante Chowk to Raja Shivaji Vidyalaya: MS STILL missing runtime3! 314: Shravane Yashwante Chowk to Raja Shivaji Vidyalaya: MS STILL missing runtime1! 314: Shravane Yashwante Chowk to Raja Shivaji Vidyalaya: MS STILL missing runtime2! 314: Shravane Yashwante Chowk to Raja Shivaji Vidyalaya: MS STILL missing runtime3! 64: Babulnath to Maheshwari Udyan: SH STILL missing runtime1! 66: Colaba Depot to Rani Laxmi Chowk: MS STILL missing runtime1! 506LTD: Jijamata Udyan to Kopar Khairane Extn: FW STILL missing runtime1! 526LTD: Jijamata Udyan to Jal Vayu Vihar/Kharghar: FW STILL missing runtime1! 526LTD: Jijamata Udyan to Jal Vayu Vihar/Kharghar: FW STILL missing runtime2! 526LTD: Jijamata Udyan to Jal Vayu Vihar/Kharghar: FW STILL missing runtime3! 526LTD: Deonar Depot to Nerul Bus Station: FW STILL missing runtime1! 526LTD: Deonar Depot to Nerul Bus Station: FW STILL missing runtime2! 526LTD: Deonar Depot to Nerul Bus Station: FW STILL missing runtime3! 526LTD: Deonar Depot to Nerul Bus Station: FW STILL missing runtime1! 526LTD: Deonar Depot to Nerul Bus Station: FW STILL missing runtime2! 526LTD: Deonar Depot to Nerul Bus Station: FW STILL missing runtime3! 526LTD: Jijamata Udyan to Nerul Bus Station: FW STILL missing runtime1! 526LTD: Jijamata Udyan to Nerul Bus Station: FW STILL missing runtime2! 526LTD: Jijamata Udyan to Nerul Bus Station: FW STILL missing runtime3! 225: Bandra Bus Station(W) to Magathane Depot: SAT STILL missing runtime1! 43: Ferry Wharf to Prateeksha Nagar: FW STILL missing runtime1! 43: Colaba Bus Station. to Ferry Wharf: FW STILL missing runtime1! 41: Ferry Wharf to Walkeshwar: SAT STILL missing runtime1! 41: Ferry Wharf to Nana Chk: SAT STILL missing runtime1! 41: Ferry Wharf to Central Depot : SUN STILL missing runtime1!
502LTD,510LTD,5151 LTD,314,506LTD,526LTD,43 Assigning runtime based on other routes having a similar distance to each route.
Route 120
All failed for schedule with id 1831 All failed for schedule with id 1832 All failed for schedule with id 1832 All failed for schedule with id 2426 All failed for schedule with id 2427 All failed for schedule with id 2427 All failed for schedule with id 2428 All failed for schedule with id 2565 All failed for schedule with id 2925 All failed for schedule with id 2926 All failed for schedule with id 2927 All failed for schedule with id 2928
These routes typically do not have the right entries in RouteDetails - which specifies which stops come in order for that route. This is however missing data, not erroneous data, so for getting that information I think we need to look at a BEST schedule book or crowdsource , and enter it in the admin. Some routes might actually have 10 stops, then it could be a false positive for some, but not all.
Some details on the data:: Lets look at two tables
Route_alias is what bus users normally use as the actual route number.
RouteDetail route_code,serial,stop_id,stage,distance_in_kms,stage 1200,1,351, 1200,2,357,0.3, True 1200,3,357, 1200,4,357, 1200,5,357,0.9, True 1200,6,357, 1200,7,357,0.4, True
The distance in kms, defines the delta(the distance between the last stop whose km is mentioned, i.e stage, a stage is used for calculating the next fare slab) Right now, we need to first see how to get these route details from other sources.
Routes containing 8 or less RouteDetail entries (13 total)
[id,route_code,route_alias] [365, u'1200', u'120'], [117, u'2480', u'248'], [333, u'2500', u'250'], [121, u'2540', u'254'], [284, u'3720', u'372'], [215, u'3940', u'394'], [443, u'6310', u'631'], [259, u'8011', u'SPL-1'], [346, u'8041', u'SPL-12'], [262, u'8091', u'SPL-9'], [523, u'8126', u'8126'], [524, u'8136', u'8136'], [541, u'8161', u'8161']]
Routes containing 10 or less RouteDetail entries (26 total including the above routes)
[365, u'1200', u'120'], [117, u'2480', u'248'], [333, u'2500', u'250'], [121, u'2540', u'254'], [339, u'2580', u'258'], [127, u'2640', u'264'], [143, u'2990', u'299'], [353, u'3380', u'338'], [284, u'3720', u'372'], [367, u'3780', u'378'], [215, u'3940', u'394'], [216, u'3970', u'397'], [435, u'4010', u'401'], [372, u'4060', u'406'], [223, u'4160', u'416'], [293, u'4290', u'429'], [248, u'6080', u'608'], [438, u'6090', u'609'], [518, u'6100', u'610'], [443, u'6310', u'631'], [259, u'8011', u'SPL-1'], [346, u'8041', u'SPL-12'], [262, u'8091', u'SPL-9'], [523, u'8126', u'8126'], [524, u'8136', u'8136'], [541, u'8161', u'8161']
279,280,874,875,876,1013,1014,1373,1374,1375,1376
These five routes have no neighbouring or any other values by which to calculate headway.
- Thirty-four entries in RouteDetails for non-existing route 3738: Related to 3731 (need verfication)
- 927 25 173 TRUE 0.5 - single entry for this route.
- 359 routedetail entries mapping to 17 missing routes .
17 missing routes ::
u'9040',
u'8101',
u'5063',
u'3434',
u'0087',
u'8131',
u'3140',
u'9050',
u'9030',
u'3842',
u'9010',
u'9020',
u'8127',
u'6032',
u'8111',
u'8526',
u'8121'])
454: Shivshahi Prakalp to Goregaon Depot REVERSED STOPS 133RING: Ahilyabai Holkar Chowk to Colaba Bus Station REVERSED STOPS 201: Juhu Beach to Poisar Depot REVERSED STOPS 511LTD: Mulund Bus Station(W) to Ghatkopar Depot REVERSED STOPS 37: Kurla Stn(W) to N.S.C.I.(Worli) REVERSED STOPS 37: Kalanagar to J.Mehta Marg REVERSED STOPS 431: Refineries to Kurla Station(E) REVERSED STOPS 83: Santacruz Depot to Colaba Bus Station REVERSED STOPS 83: Santacruz Depot to Dr.S.P.M.Chk. REVERSED STOPS 83: Santacruz Depot to Pt.Paluskar Chowk REVERSED STOPS 340: Agarkar Chowk to Barve Nagar REVERSED STOPS 209RING: Borivli Station(E) to Sudhindra Nagar REVERSED STOPS 629RING: Borivli Stn(E) to Ratan Nagar REVERSED STOPS 305: Ghatkopar Depot to Vasantrao Naik Chowk REVERSED STOPS 305: Ghatkopar Depot to Com.P.K.Kurne Chowk REVERSED STOPS 604: Bhandup Stn.(W) to Sahyadri Nagar REVERSED STOPS 220: Khar Rly Stn. to Shrely Village REVERSED STOPS 46: Mahim Machhimar Nagar to Ferry Wharf REVERSED STOPS
- The area code of nearby stops as given in RouteDetail allows us to check the area code and insert the missing value.
3899 DAVA BAZAR(KALBADEVI) 0 641 0 CD should be changed to 3899 DAVA BAZAR(KALBADEVI) 0 641 150 CD
4551 SAFED POOL U 0 374 0 KLD should be changed to 4551 SAFED POOL U 0 374 170 KLD
4723 RUTU PARK 0 0 64 MUL should be changed to 4723 RUTU PARK 0 762 64 MUL
2312 OM NGR.(WARE HOUSE) 0 0 3 MLD should be changed to 2312 OM NGR.(WARE HOUSE) 0 29 3 MLD
3017 MAHARSHI ARVIND CHK.
3139 ALANKAR TALKIES
2968 MINT CLY.
3404 SANTACRUZ STN.RD.
3472 MAHALAXMI STN.
3475 SHANTARAM PJJARE CHK.
3476 SHRAWAN YESHWANTE CHK.
2966 MUMBAI VETERINARY COLLEGE